This data as json, CSV (advanced)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 40058 | 40058 | 1923-06-30 | 8 | a-d | Guangdong news/ Liao Zhongkai becomes governor of Guangdong province and the inaugural ceremony. Sale of public properties in Guangzhou. Guangdong authority borrows foreign loans. Some Hong Kong businessmen cease to be adviser of the provincial government. Some public properties are to be auctioned. Municipal government in Guangzhou sells public properties. Guangdong military officers oppose to sale of public properties. Temples are also on the list for sale. Refugees from Zhaoqing. Demonstration in Zengcheng. Sun Ke punishes legislature assembly member Zhong Xifen. Guangdong army has arrived Shilong, of Boluo county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094462 | 24094462 |
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]);