This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29815 | 29815 | 1915-03-27 | 3 | b | The court conviction of Cheng Dequan, Yin Dehong and other higher officials involved in the public loan corruption in Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24094784 | 24094784 | |
29816 | 29816 | 1915-03-27 | 3 | b | Battle situation in East Europe between Russian troops and German troops. | Russia | http://trove.nla.gov.au/newspaper/page/24094784 | 24094784 | |
29817 | 29817 | 1915-03-27 | 3 | b | Turkish troops are sent to the front and constructing military works during the temporary fire stopping period. | Other... | http://trove.nla.gov.au/newspaper/page/24094784 | 24094784 | |
29818 | 29818 | 1915-03-27 | 3 | b | Statistics of business ships sunkened by German submarines in British sea. | Britain | http://trove.nla.gov.au/newspaper/page/24094784 | 24094784 | |
29825 | 29825 | 1915-03-27 | 6 | b | The order of Agriculture and Business Ministry on postponing reform and explaining the previous provisions of government policy. | China | http://trove.nla.gov.au/newspaper/page/24094789 | 24094789 | |
29828 | 29828 | 1915-03-27 | 7 | b | Women police are enrolled in New Zealand for protecting youngsters. | New Zealand | http://trove.nla.gov.au/newspaper/page/24094788 | 24094788 | |
29829 | 29829 | 1915-03-27 | 7 | b | People in Shanghai urge Chinese government to fight against Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24094788 | 24094788 | |
29830 | 29830 | 1915-03-27 | 7 | b | Japanese troops have come to Shandong and Manchu. | China | http://trove.nla.gov.au/newspaper/page/24094788 | 24094788 |
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]);