This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
38063 | 38063 | 1921-12-31 | 3 | b-c | Hong Kong newspaper criticises some members of the provincial legislature assembly in Guangdong who hold concurrent administrative post. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24093806 | 24093806 | |
38086 | 38086 | 1921-12-31 | 8 | b-c | Guangdong news/ Backgrounds of the new county magistrates in Guangdong recently elected by the people. Businessmen in Guangzhou thank governor Chen Jiongming for abolition of some taxes. Bandits in Xiangshan county rob farmers. County magistrate in Leizhou escapes bandit robbery. Suffering of fire victims in Yingde county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093813 | 24093813 |
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]);