This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
35500 | 35500 | 1920-03-13 | 7 | a-b | Australia news/ American scholar comes to visit Sydney after staying in China for quite a few years and will deliver a speech on the China affairs. A cargo ship on fire in Brisbane. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098088 | 24098088 | |
35505 | 35505 | 1920-03-13 | 8 | a-b | Guangdong news/ Military governor and Sun Yatsen have different opinions on the political future. Commercial chambers in Xiangshan county fight for the territorial sovereignty. Rice price going down in Xiangshan county. Local civil corps in Gaoyao county. Bandits in Xinhui county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098091 | 24098091 |
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]);