This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34007 | 34007 | 1919-01-18 | 3 | a-b | China and America join each other to deal with the aftermath of the World War I. | China | http://trove.nla.gov.au/newspaper/page/24097574 | 24097574 | |
34008 | 34008 | 1919-01-18 | 3 | b | Speeches by Wang Jitang, Xiong Xiling and Cai Yuanpei in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24097574 | 24097574 | |
34009 | 34009 | 1919-01-18 | 3 | d | A court hearing in Beijing on the murder of Song Jiaoren in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24097574 | 24097574 | |
34010 | 34010 | 1919-01-18 | 3 | e | Former American president Roosevelt dies. | Canada | http://trove.nla.gov.au/newspaper/page/24097574 | 24097574 | |
34011 | 34011 | 1919-01-18 | 3 | e | American President Wilson arrives Rome, Italy, and the welcome. | Britain | http://trove.nla.gov.au/newspaper/page/24097574 | 24097574 | |
34012 | 34012 | 1919-01-18 | 3 | e | Chinese workers in Moscow gather and ask the Russian government to help organise Bolshevik party in China. | Britain | http://trove.nla.gov.au/newspaper/page/24097574 | 24097574 | |
34013 | 34013 | 1919-01-18 | 3 | e | The end of the Tsar of Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24097574 | 24097574 | |
34014 | 34014 | 1919-01-18 | 3 | f | Preparation for the Paris Conference. | Britain | http://trove.nla.gov.au/newspaper/page/24097574 | 24097574 | |
34015 | 34015 | 1919-01-18 | 3 | f | Fighting in Germany after the World War I. | Britain | http://trove.nla.gov.au/newspaper/page/24097574 | 24097574 |
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]);