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 |
---|---|---|---|---|---|---|---|---|---|
30124 | 30124 | 1915-06-05 | 3 | b | Treaty between China and Japan is signed in Japan. | Canada | http://trove.nla.gov.au/newspaper/page/24094864 | 24094864 | |
30125 | 30125 | 1915-06-05 | 3 | b | Germany attempts to make Romania a neutral nation. | Germany | http://trove.nla.gov.au/newspaper/page/24094864 | 24094864 | |
30126 | 30126 | 1915-06-05 | 3 | b | A Russian warship is sunken by Turkish submarine in the Black Sea. | Germany | http://trove.nla.gov.au/newspaper/page/24094864 | 24094864 | |
30133 | 30133 | 1915-06-05 | 6 | b | News miscellany/ Chinese industrial delegation is investigating in America. President Yuan Shikai compromised in negotiation with Japan and angered Chinese people. Central government requires legislation departments in various provinces be established sooner. Kaiping and Xinghui in Guangdong are troubled with bandits riots. Japanese parties are trying to throw down the present government as the latter is regarded a failure in negotiation with China. | China | http://trove.nla.gov.au/newspaper/page/24094869 | 24094869 | |
30135 | 30135 | 1915-06-05 | 7 | b | Name list of people buying Chinese public loans in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24094868 | 24094868 | |
30136 | 30136 | 1915-06-05 | 7 | b | Japanese politicians are gathering to oppose their government for the treaty with China. | Canada | http://trove.nla.gov.au/newspaper/page/24094868 | 24094868 | |
30137 | 30137 | 1915-06-05 | 7 | b | Battle situation in west Europe between Britain, France and Germany. | Other... | http://trove.nla.gov.au/newspaper/page/24094868 | 24094868 |
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]);