This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
37937 | 37937 | 1921-12-03 | 6 | a-b | A public notice issued by the Chinese Consul-General in Australia on the family reunion of Chinese businessmen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093779 | 24093779 | |
37938 | 37938 | 1921-12-03 | 6 | b-c | Chen Duxiu and his colleagues are brought to trial in Shanghai for communist propaganda. | China | http://trove.nla.gov.au/newspaper/page/24093779 | 24093779 | |
37939 | 37939 | 1921-12-03 | 6 | c | To plant jujube tree in the Beijing front yard and to encourage industrial effort, written by Liu Rongting. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093779 | 24093779 |
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]);