This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
35782 | 35782 | 1920-06-05 | 8 | a-b | A letter from Chinese businessmen in Samoa Du Zheng, Cheng Xiuji, Qiu Yinghe, Xu Jiaoji and Chen Yaoji argues for the performance of Chinese Consul Lin Runzhao in Samoa and the Chinese communities there. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098191 | 24098191 | |
35783 | 35783 | 1920-06-05 | 8 | b-c | Guangdong news/ Wen Zongyao arrives Guangzhou. New tax for overseas parcels. Mo Rongxin entertains Italian pilots. Celebration of the International Labour Day in Guangzhou. Advocate for short hair for women in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24098191 | 24098191 |
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]);