This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29272 | 29272 | 1914-09-26 | 8 | a | Guangdong news/ Redundancy of the provincial government. Government office set up for water conservancy projects. Effort to protect the products of China. The central government to award activists in the disaster relief. Charges for licence registration in Guangdong. Yao Yuping is arrested for plotting rebellion. Wu Zhuang and Long Jianzhang return to Guangdong together. | China | http://trove.nla.gov.au/newspaper/page/24093268 | 24093268 | |
29273 | 29273 | 1914-09-26 | 8 | c | A notice issued by the Constitutionalist Association, formerly the Chinese Empire Reform Association or Nationalist Association, 158 George Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093268 | 24093268 | |
29274 | 29274 | 1914-09-26 | 8 | c | A notice issued by the New South Wales Chinese Chamber of Commerce. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093268 | 24093268 |
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]);