This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
37557 | 37557 | 1921-09-10 | 3 | a-b | A newspaper in Osaka proposes to solve outstanding problems between China and Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24093678 | 24093678 | |
37558 | 37558 | 1921-09-10 | 3 | b | Clashes between school students and businessmen in Xiamen (Amoy) and an analysis. | China | http://trove.nla.gov.au/newspaper/page/24093678 | 24093678 | |
37559 | 37559 | 1921-09-10 | 3 | b-c | Foreign missions in Beijing discuss the proposal by Chinese government to revise its customs regulations. | China | http://trove.nla.gov.au/newspaper/page/24093678 | 24093678 | |
37560 | 37560 | 1921-09-10 | 3 | c | Japan puts forwards its condition to the Washington Conference. | Japan | http://trove.nla.gov.au/newspaper/page/24093678 | 24093678 | |
37561 | 37561 | 1921-09-10 | 3 | c | Rebellion in India and response of the authority. | Other... | http://trove.nla.gov.au/newspaper/page/24093678 | 24093678 | |
37562 | 37562 | 1921-09-10 | 3 | c | French army organises a flying unit. | Britain | http://trove.nla.gov.au/newspaper/page/24093678 | 24093678 | |
37563 | 37563 | 1921-09-10 | 3 | c-d | Leon Trotsky convenes an emergency meeting of the Soviet Party. Famine in Russia and the relief work. | Britain | http://trove.nla.gov.au/newspaper/page/24093678 | 24093678 |
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]);