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 |
|---|---|---|---|---|---|---|---|---|---|
| 40649 | 40649 | 1923-11-10 | 2 | a-b | First part of an article written by Wu Xiufeng claims that Chinese culture is the future of our world. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094608 | 24094608 | |
| 40659 | 40659 | 1923-11-10 | 6 | a | Tung Wah Times comments on the current situation in Dongjiang River area, east of Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094612 | 24094612 | |
| 40665 | 40665 | 1923-11-10 | 7 | a-b | Two police officers in Sydney organise donations to a disabled Chinese man which buy him a wheelchair. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094611 | 24094611 | |
| 40666 | 40666 | 1923-11-10 | 7 | b | A half-caste Chinese is shot and injured in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094611 | 24094611 | |
| 40668 | 40668 | 1923-11-10 | 7 | c-d | First part of a report on the wars in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094611 | 24094611 | |
| 40669 | 40669 | 1923-11-10 | 7 | d-e | Fourth part of the report on the reclamation and agricultural development in Zhangjiakou area. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094611 | 24094611 | |
| 40670 | 40670 | 1923-11-10 | 8 | a-d | Guangdong news/ Sun Yatsen sets up a fundraising bureau in Guangzhou, headed by Liao Zhongkai, which supplies army provisions. Two aeroplanes are detained by Gongbei Customs Office. Xu Chongzhi and his troops return to Guangdong. Businessmen are required to surrender their weapons. National parliamentarians from Guangdong are punished in Beijing. Dongguan county has turned into a bandit world. A man jumps into river in order to escape the pressgang. A well in Guangzhou is boiled with no reason. A kidnap in Guangzhou and the ransom. Typhoon swallows Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094614 | 24094614 | |
| 40671 | 40671 | 1923-11-10 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094614 | 24094614 | |
| 40672 | 40672 | 1923-11-10 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094614 | 24094614 |
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]);