This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33991 | 33991 | 1919-01-11 | 3 | f | German are preparing for the war of trade after the World War I. | Britain | http://trove.nla.gov.au/newspaper/page/24097566 | 24097566 | |
33993 | 33993 | 1919-01-11 | 3 | f | Japan withdraws its troops from Siberia. | Britain | http://trove.nla.gov.au/newspaper/page/24097566 | 24097566 | |
33996 | 33996 | 1919-01-11 | 7 | c | Leaders from the south and the north in China are all ready for peace talks. Russian employ Chinese for looting. Chinese government deports German nationals. Japanese suggest an alliance with China. | Britain | http://trove.nla.gov.au/newspaper/page/24097570 | 24097570 |
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]);