This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36349 | 36349 | 1920-11-27 | 8 | a-b | Chinese Chamber of Commerce in Sydney calls for donations to the famine victims in north China, contact details, and all names listed for donations (Chinese and Western people), and acknowledgement by the Chinese Consul-General Wei Zijing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098401 | 24098401 | |
36350 | 36350 | 1920-11-27 | 8 | b-d | Guangdong news/ Mo Rongxin executes Xu Chonghao. Shen Hongying's troops return to Guangzhou. Mo Rongxin is leaving Guangdong. Qin Chunxuan leaves Guangdong. Guangxi army leave Huizhou. Guangxi army loot in Sihui county and the report. | China | http://trove.nla.gov.au/newspaper/page/24098401 | 24098401 |
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]);