This data as json, CSV (advanced)
Suggested facets: page, title, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26037 | 26037 | 1912-04-20 | 3 | a-b | Portuguese republic faces financial crisis | Portuguese republic faces severe financial crisis, monarch seems to be back. | France | http://trove.nla.gov.au/newspaper/page/24092207 | 24092207 |
26767 | 26767 | 1912-09-21 | 3 | a-b | Britain, Russia and France establish military alliance. | France | http://trove.nla.gov.au/newspaper/page/24092383 | 24092383 | |
29406 | 29406 | 1914-11-21 | 3 | a-b | Chinese ambassador to Japan Lu Zongyu on the Shandong issues. French newspaper reports Japanese army in Shandong province. | France | http://trove.nla.gov.au/newspaper/page/24093327 | 24093327 | |
29544 | 29544 | 1915-01-09 | 3 | a-b | European War/ French military press reports current battles in Europe. | France | http://trove.nla.gov.au/newspaper/page/24094679 | 24094679 | |
30264 | 30264 | 1915-07-10 | 7 | a-b | Battle situation in west Europe between French, British and German troops. | France | http://trove.nla.gov.au/newspaper/page/24094908 | 24094908 | |
34372 | 34372 | 1919-04-12 | 3 | a-b | Contents of the secret treaty between China and Japan revealed at the Paris Peace Conference. | France | http://trove.nla.gov.au/newspaper/page/24097677 | 24097677 | |
34519 | 34519 | 1919-05-24 | 6 | a-b | Miscellaneous report (protest in Germany against the Treaty of Versailles and their signature, Austrian envoy arrives Paris, anti-American movement in Japan, Japanese newspaper discriminates against Britain). | France | http://trove.nla.gov.au/newspaper/page/24097730 | 24097730 | |
35357 | 35357 | 1920-02-21 | 11 | a-b | Foreign newspaper on the disarmament in China. | France | http://trove.nla.gov.au/newspaper/page/24098057 | 24098057 | |
36679 | 36679 | 1921-03-05 | 3 | a-b | French newspaper predicts the future war between Japan and America and the possible influence upon China. | France | http://trove.nla.gov.au/newspaper/page/24093460 | 24093460 | |
40559 | 40559 | 1923-10-20 | 3 | a-b | Banking Corporation of Britain, France, America and Japan meets in Paris on the China's repayment of indemnity and the mortgage. | France | http://trove.nla.gov.au/newspaper/page/24094583 | 24094583 |
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]);