This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 40814 | 40814 | 1923-12-22 | 2 | a-b | An observation on the new cabinet organised in Beijing, editorial by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094656 | 24094656 | |
| 40815 | 40815 | 1923-12-22 | 2 | b-d | Seventh and final part of the constitution of the Republic of China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094656 | 24094656 | |
| 40828 | 40828 | 1923-12-22 | 6 | a-b | An article written by Wu Xiufeng claims that Chinese government should not monopolise the industry. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094660 | 24094660 | |
| 40833 | 40833 | 1923-12-22 | 7 | a-b | The fundraising concert/ party in the Sydney city town hall organised by the Chinese Chamber of Commerce Sydney hospital, and those who are involved include Ye Tonggui and his wife, actor Lang Deshan, Zhang Maokuan, Zhu Hechou, Liu Guangfu, and Ma Zanfen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094659 | 24094659 | |
| 40836 | 40836 | 1923-12-22 | 7 | b | A baby boy found in the central railway station, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094659 | 24094659 | |
| 40839 | 40839 | 1923-12-22 | 7 | b | The war in Guangdong/ Headquarters of the Yunnan army moves to Shaoguan. Yunnan army force local businessmen to apply for gun license. Mo Guohua occupies Sanshui county. Zhu Zhuowen and Chen Yong'an. Survey on the war disaster in local Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094659 | 24094659 | |
| 40840 | 40840 | 1923-12-22 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094659 | 24094659 | |
| 40841 | 40841 | 1923-12-22 | 8 | a-d | Guangdong news/ The war between Chen Jiongming and Sun Yatsen. United Army (lian jun) decides to stay in Guangzhou. Corpse found everywhere in Dongjiang area. Guangzhou newspapers are not allowed by report the defeat of Tan Yankai. Zhong Sheng issues an open letter to the associations in Guangzhou. Zou Lu's wife is assassinated. An army officer forces Sun Ke to provide army provisions. Yunnan army may retreat to Beijiang. The Third Division declares independence. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094662 | 24094662 | |
| 40842 | 40842 | 1923-12-22 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094662 | 24094662 | |
| 40843 | 40843 | 1923-12-22 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094662 | 24094662 |
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]);