This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42208 | 42208 | 1924-10-18 | 7 | a | Two cases of theft in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100900 | 24100900 | |
42209 | 42209 | 1924-10-18 | 7 | a | Canadian newspaper worries about the peril of coloured peoples. | Australia | http://trove.nla.gov.au/newspaper/page/24100900 | 24100900 | |
42210 | 42210 | 1924-10-18 | 7 | a | Sydney Zoo moves to a new but bigger place. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100900 | 24100900 | |
42211 | 42211 | 1924-10-18 | 7 | a | A young man in Ballarat, Victoria, shoots dead his father. | Australia | http://trove.nla.gov.au/newspaper/page/24100900 | 24100900 | |
42212 | 42212 | 1924-10-18 | 7 | b | Chinese consulate general in Australia and the Chinese communities celebrate the National Day on October 10. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100900 | 24100900 | |
42213 | 42213 | 1924-10-18 | 7 | b | Chinese societies in New York have fierce fighting and the casualties. | America | http://trove.nla.gov.au/newspaper/page/24100900 | 24100900 | |
42214 | 42214 | 1924-10-18 | 7 | b | Zhang Zuolin's army take over Shanhaiguan and a report on the truth. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100900 | 24100900 | |
42215 | 42215 | 1924-10-18 | 7 | b-c | The outcome of the war between Zhejiang and Jiangsu province becomes clear. | China | http://trove.nla.gov.au/newspaper/page/24100900 | 24100900 | |
42216 | 42216 | 1924-10-18 | 7 | c | Chinese Chamber of Commerce in Sydney acknowledges receipt of donations to the flood victims in Guangdong. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100900 | 24100900 | |
42217 | 42217 | 1924-10-18 | 7 | c | Chinese Chamber of Commerce in Sydney calls for donations to the commercial chambers in Guangdong for their fighting with Sun Yatsen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100900 | 24100900 |
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]);