This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45512 | 45512 | 1927-02-26 | 8 | a-d | Guangdong news/ Jiang Jieshi invites Wang Jingwei and Hu Hanmin back to office. Proposal to reform civil administration in local counties. Preparation for the set-up of military office in Guangzhou. Order to wipe out bandits from Guangzhou. Si yi people in Guangzhou request to eradicate pirates. Fighting between rickshaw men and taxi driver for the limited jobs. Labour movement in Dongguan county. | China | http://trove.nla.gov.au/newspaper/page/24101898 | 24101898 |
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]);