This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36090 | 36090 | 1920-09-04 | 8 | a | The end of Xu Shuzheng, leader of the Anfu Club in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24098300 | 24098300 | |
36091 | 36091 | 1920-09-04 | 8 | a | Zhili army requests to punish traitors and their list. | China | http://trove.nla.gov.au/newspaper/page/24098300 | 24098300 | |
36092 | 36092 | 1920-09-04 | 8 | b-c | Guangdong news/ Self-government movement in Guangdong. Li Hu and his troops in Xijiang area. Military government and its policy towards the northern government. The Save China Army in Zengcheng county. Joint defence plan for eight provinces. Revolutionaries are executed in Guangzhou. Storm and heavy rain in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24098300 | 24098300 |
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]);