This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 40834 | 40834 | 1923-12-22 | 7 | b | A building under construction in Melbourne collapses and some workers injured. | Australia | http://trove.nla.gov.au/newspaper/page/24094659 | 24094659 | |
| 40835 | 40835 | 1923-12-22 | 7 | b | Bush fire in Wagga Wagga, New South Wales. | Australia | 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 | |
| 40837 | 40837 | 1923-12-22 | 7 | b | A baby is found dead in St Mary Church, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094659 | 24094659 | |
| 40838 | 40838 | 1923-12-22 | 7 | b | Anti-foreign emotion in Guangzhou. | Hong Kong | 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 |
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]);