This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
35504 | 35504 | 1920-03-13 | 8 | a | A warning issued by the Chinese Youth Patriotic Association in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098091 | 24098091 | |
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 | |
35506 | 35506 | 1920-03-13 | 8 | b-c | Rev. Liu Junchen acknowledges receipt of donations to the Chinese Christian church and all names listed. | 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]);