This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34518 | 34518 | 1919-05-24 | 6 | a | Poems by Shou Zhen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097730 | 24097730 | |
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 | |
34520 | 34520 | 1919-05-24 | 6 | b | A train in New Zealand overturns. Australian pilot disappears while across the Atlantic Ocean. Korean people seek independence at the Paris Peace Conference. Emperor of Germany may be brought to trial. German warships now owned by Britain. | Other... | http://trove.nla.gov.au/newspaper/page/24097730 | 24097730 |
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]);