This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30730 | 30730 | 1915-11-20 | 7 | a-b | Australia news/China's Business and Trade Association in Sydney decides to support Zhang Yasheng's legal suite over his brother being killed by bandits in Guangdong. Chinese farmers in Sydney suburbs watering their farm result in shortage of drinking water in neighbouring areas. A Japanese cook in Freemantle is of mental disorder and attempts to poison and shoot his Master. Date of Tax reporting in Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24095062 | 24095062 | |
30731 | 30731 | 1915-11-20 | 7 | b | New Zealand government decides to forbid people above age of 18 leave New Zealand without official permission. | New Zealand | http://trove.nla.gov.au/newspaper/page/24095062 | 24095062 | |
30732 | 30732 | 1915-11-20 | 7 | b | Chinese government notifies Japan that it is to postpone its decision on changing national system. | Britain | http://trove.nla.gov.au/newspaper/page/24095062 | 24095062 | |
30733 | 30733 | 1915-11-20 | 7 | b | Shanghai governor Zhu Qinghui is assassinated by the revolutionary party in Shanghai. | Canada | http://trove.nla.gov.au/newspaper/page/24095062 | 24095062 | |
30734 | 30734 | 1915-11-20 | 7 | b-c | Russian newspapers claim that the leased land in China to Germany should be regarded as German territory and the Ally nations should keep a close watch on it. | Britain | http://trove.nla.gov.au/newspaper/page/24095062 | 24095062 |
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]);