This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41156 | 41156 | 1924-02-23 | 2 | b-d | A special report published in The Herald of Melbourne on China and Japan (yellow peril from Japan, awakening of China, Japan revises its China policy, etc), translated by Guo Shaohong and Guo Shaozhou, two Chinese students in the University of Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24100624 | 24100624 | |
41175 | 41175 | 1924-02-23 | 7 | a-b | Husband and wife die at the same time in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100627 | 24100627 |
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]);