This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41342 | 41342 | 1924-03-29 | 7 | a | Australian federal government to sink one of the warships. | Australia | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
41343 | 41343 | 1924-03-29 | 7 | a | Chinese Consulate General in Melbourne has a new office manager, Qu Sunyi, who is arriving in Sydney from China, and his background. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
41344 | 41344 | 1924-03-29 | 7 | a-b | The Sydney pianist is sentenced to death for murdering his three daughters. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
41345 | 41345 | 1924-03-29 | 7 | c | A man in Sydney is sentenced to seven years' imprisonment for fighting. | Australia | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
41346 | 41346 | 1924-03-29 | 7 | c | A young woman in Sydney dies of abortion. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
41347 | 41347 | 1924-03-29 | 7 | c | Chinese market gardener Wu Zhen and his excellent performance in the agriculture show in Glen Innes. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
41348 | 41348 | 1924-03-29 | 7 | c | Chinese football team to visit New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
41349 | 41349 | 1924-03-29 | 7 | d | Passengers of Lingnan, a liner of the Chungwah Navigation Company Ltd, write in praise of the service on board. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
41350 | 41350 | 1924-03-29 | 7 | d-e | Gong yi tang (The Dong Guan Goon Yee Tong) in Sydney is to set up a board and its notice for election of the board directors. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
41351 | 41351 | 1924-03-29 | 7 | e | Farewell message by Chen Junle on his return to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
41352 | 41352 | 1924-03-29 | 7 | f | Chinese immigrants in Samoa island write and thank Chinese consul Li Zhaosong for his great help. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
41353 | 41353 | 1924-03-29 | 7 | f | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 |
JSON shape: default, array, newline-delimited
CREATE TABLE [article_index] ( [date] TEXT, [page] TEXT, [column] TEXT, [title] TEXT, [description] TEXT, [source] TEXT, [page_url] TEXT, [trove_id] TEXT ); CREATE INDEX [idx_article_index_date] ON [article_index] ([date]);