This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43851 | 43851 | 1925-09-19 | 6 | a | Chinese delegate Zhu Zhaoxin talks to the League of Nations on the revision of unequal treaties. | Other... | http://trove.nla.gov.au/newspaper/page/24101286 | 24101286 | |
43852 | 43852 | 1925-09-19 | 6 | a | American president Calvin Coolidge orders to set up an air navigation bureau. | America | http://trove.nla.gov.au/newspaper/page/24101286 | 24101286 | |
43853 | 43853 | 1925-09-19 | 6 | a-b | The Times in London reports anti-foreign sentiment in China. | Britain | http://trove.nla.gov.au/newspaper/page/24101286 | 24101286 | |
43854 | 43854 | 1925-09-19 | 6 | b | More feud and fighting among Chinese communities in New York. | America | http://trove.nla.gov.au/newspaper/page/24101286 | 24101286 | |
43855 | 43855 | 1925-09-19 | 6 | b-c | A returned businessman talks in Guangzhou his experience while in Hong Kong. | China | http://trove.nla.gov.au/newspaper/page/24101286 | 24101286 | |
43856 | 43856 | 1925-09-19 | 6 | c | Report on the strike in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101286 | 24101286 | |
43857 | 43857 | 1925-09-19 | 6 | b-f | The China Goods Company Ltd raises funds by floating shares in the Australian Chinese communities, and the founders are Chen Binghui, Wu Dingming, Ye Tonggui, Liang Bozhi, Yang Guozhu, Zhang Jixin, Wu Weitang, Huang Hui, Zheng Peizhi, Yang Honglin, Chen Lin, Xie Zhaoshu, Lei Binglin, Xu Juesheng, Chen Yunan, Chen Yin and many others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101286 | 24101286 |
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]);