This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34579 | 34579 | 1919-06-14 | 2 | e | The independence movement in Korea. | Other... | http://trove.nla.gov.au/newspaper/page/24097752 | 24097752 | |
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]);