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 |
---|---|---|---|---|---|---|---|---|---|
45599 | 45599 | 1927-04-09 | 2 | c | Editorial by Tung Wah Times on the national strength of China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101940 | 24101940 | |
45611 | 45611 | 1927-04-09 | 7 | a-b | Australia news/ A Sydney man fights his rival in love. A Chinese gardener is beaten by his friends. Burglary of a bakery shop in Sydney. New committee of the Chinese Chamber of Committee, its meeting and speakers include Wu Elou (Xiuguang), Wu Zhaoquan, Liu Guangfu, Guo Jianying, Zheng Fanchang, Ye Bingnan, Liu Chunxi, Tan Liangnan, Huang Guangzhao, Peng Lichuan, Zhu Peiqing and others. Police in Sydney raid Chinese gambling dens. Tobacco growers in north New South Wales and the new requirements by the state government. Bus ticket price to be increased in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101943 | 24101943 | |
45612 | 45612 | 1927-04-09 | 7 | d | News from Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101943 | 24101943 | |
45613 | 45613 | 1927-04-09 | 7 | d | Stories of Qian Jiang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101943 | 24101943 |
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]);