This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36427 | 36427 | 1920-12-25 | 3 | b-c | Xu Shuzheng flees and the report. | China | http://trove.nla.gov.au/newspaper/page/24098428 | 24098428 | |
36434 | 36434 | 1920-12-25 | 6 | b-c | Ma Ping reports the Chinese tax officers in Hong Kong and their behaviour. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098433 | 24098433 | |
36442 | 36442 | 1920-12-25 | 8 | b-c | Guangdong news/ Governor Chen Jiongming bans gambling in Guangdong. Army commanders want to recruit civil corps in order to attack Guangxi. Arrests in Guangzhou for gambling. Guangxi army leave Zhaoqing and the report. | China | http://trove.nla.gov.au/newspaper/page/24098436 | 24098436 |
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]);