This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 40207 | 40207 | 1923-08-04 | 8 | a | Executive Manager of the Tung Wah Times Zhang Maokuan calls for donations to the building of Confucian temple. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094502 | 24094502 | |
| 40208 | 40208 | 1923-08-04 | 8 | a-d | Guangdong news/ Yuan Dai issues an open letter to the Guangdong people. Chen Jiongming orders his troops to attack the Guangzhou city. Chen Jiongming's army attack Boluo. Porters killed in the battle in Guangzhou. Guangzhou municipal public security bureau to check the defence headquarters. Policemen in Guangzhou are prohibited from extorting money from peddlers. Yao Yuping's mediation between different political groups in Guangdong. Japanese kill local residents in Changsha, capital of Hunan province, and the demonstration in Guangzhou. Looting in Zhaoqing. Headquarters in Guangzhou borrows loans from the Xinning Railway company. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094502 | 24094502 | |
| 40209 | 40209 | 1923-08-04 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094502 | 24094502 | |
| 40210 | 40210 | 1923-08-04 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094502 | 24094502 |
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]);