This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29307 | 29307 | 1914-10-17 | 2 | a-b | Editorial on the neutrality in the World War I. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093288 | 24093288 | |
29314 | 29314 | 1914-10-17 | 6 | a-b | American people on the neutrality of China in the World War I. | America | http://trove.nla.gov.au/newspaper/page/24093292 | 24093292 | |
29318 | 29318 | 1914-10-17 | 7 | a-b | Australia news/ Australian federal government donates 100,000 pounds to Belgium. French consulate office in Sydney issues a notice of conscription to its citizens in Australia. A school teacher in Bendigo, Victoria, is sacked for his sympathy with Germany. Bandits rob a Chinese shop in Surry Hills, Sydney. Chinese community in Sydney shows indifference towards the National Day on October 10. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093291 | 24093291 | |
29322 | 29322 | 1914-10-17 | 8 | a-b | Beijing news/ Rumour says a foreign country is helping Sun Yatsen for his Third Revolution. Liu Guochun, of Hunan province, and his secret society. Rebels in Manchuria and their activities. Remnants of the Bailang bandits. | China | http://trove.nla.gov.au/newspaper/page/24093294 | 24093294 |
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]);