This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34603 | 34603 | 1919-06-21 | 3 | b-c | A protest gathering in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24097759 | 24097759 | |
34604 | 34604 | 1919-06-21 | 3 | c-d | Name of Chinese students arrested in Tokyo by Japanese police. | Japan | http://trove.nla.gov.au/newspaper/page/24097759 | 24097759 | |
34605 | 34605 | 1919-06-21 | 3 | d-f | Miscellaneous/ Strike in France. New Turkey. China boycotts Japanese goods. Reconsideration proposed for the Shandong issues. Strike in Canada. America also demands compensation from Germany. American authority lifts ban on gold export. Soldiers on riots in Canada. German's proposals for the peace treaty. | Other... | http://trove.nla.gov.au/newspaper/page/24097759 | 24097759 |
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]);