This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51866 | 51866 | 1932-09-03 | 5 | a | Second part of an open letter from Chen Mingshu to the 19th Route Army. | China | http://trove.nla.gov.au/newspaper/page/24090932 | 24090932 | |
51867 | 51867 | 1932-09-03 | 5 | c | A notice issued by the Chinese Chamber of Commerce in New South Wales on the exports to China. Regulations issued by the Chinese government on the exports to China (by overseas Chinese businessmen). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090932 | 24090932 |
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]);