This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34580 | 34580 | 1919-06-14 | 2 | f | League of Nations to have a conference in America. League of Nations elects the secretary-general. | France | http://trove.nla.gov.au/newspaper/page/24097752 | 24097752 | |
34581 | 34581 | 1919-06-14 | 2 | f | Chinese government is ready to recognise the independence of Poland. Czech government prepares to set up consulate in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24097752 | 24097752 | |
34589 | 34589 | 1919-06-14 | 3 | f | Germany puts forward their peace proposals to the Paris Conference. | America | http://trove.nla.gov.au/newspaper/page/24097751 | 24097751 | |
34590 | 34590 | 1919-06-14 | 3 | f | A woman pilot in America. French ship on fire in Suez Canal. German delegation to the Paris Peace Conference refuse to sign the treaty. Oil production in Britain. Mission Society in Beijing protests against the resolutions on Shandong. Chinese people in Wuhu start boycott to Japanese goods. | Other... | http://trove.nla.gov.au/newspaper/page/24097751 | 24097751 |
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]);