This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42294 | 42294 | 1924-11-08 | 6 | a-b | An open letter issued by the Guangdong commercial chambers to all overseas Chinese. | China | http://trove.nla.gov.au/newspaper/page/24100925 | 24100925 | |
42295 | 42295 | 1924-11-08 | 6 | b-d | Third and final part of travel notes written by Yu Wenhou on his trip to the South Pacific (Samoa, Tonga, Fiji and other islands), and his report on the Chinese communities there. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100925 | 24100925 | |
42296 | 42296 | 1924-11-08 | 6 | d | Chinese Students Association in New South Wales is organised and their declaration, signed by Su Yiguang, Chen Qingyi, Zhong Ziyuan, Luo Fuquan, Su Guanqing, Li Huafu, Xiao Songfen, Zhong Zhensheng, Liu Xiliang, Li Weiman, Liu Zhenkai, Li Shekun, and Li Zhenxing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100925 | 24100925 |
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]);