This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45650 | 45650 | 1927-04-23 | 7 | a-d | Australia news/ A notice by Wu Elou (Xiuguang) on his departure. Chinese Chamber of Commerce in Sydney farewells Wu Elou and speakers include Wu Zhaoquan, Liu Guangfu, Zhu Songqing, Zheng Fanchang, Zhao Zhongguang, Guo Jianying, Liu Bingshu, Tan Liangnan, and others. The Royal Agricultural Show in Sydney postponed to close. Advertisement report for New Zealand Redwood Forest Ltd. Three prisoners are caught while trying to escape in the Bathurst prison. Storm in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101959 | 24101959 | |
45651 | 45651 | 1927-04-23 | 7 | d | Farewell message by Wu Elou (Xiuguang), chief editor of the Tung Wah Times and the Chinese secretary of the New South Wales Chinese Chamber of Commerce. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101959 | 24101959 |
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]);