This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33699 | 33699 | 1918-10-05 | 6 | a | Poems by Zheng Qiufan on the current situations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097458 | 24097458 | |
33700 | 33700 | 1918-10-05 | 6 | a-b | Support letters from Wei Zijing, Chinese Consul-General in Australia, and Chinese communities in Brisbane, Melbourne, Perth and Adelaide to the Chinese Association against Discrimination in Sydney (ao zhou hua qiao wei chi jin li hui) (names include Zhang Zhuoxiong and Lei Peng in Melbourne, Chen Qiong in Perth, Zhu He, Xie Zhenkuan, Xie Jihuang, Ye Guo'en, Liu Kongfang and Liu Bingshu in Adelaide, and Zhong Yibei in Brisbane). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097458 | 24097458 | |
33701 | 33701 | 1918-10-05 | 6 | c | A notice by the Dongguan Gong Yi Tang in Brisbane to transfer remains of their deceased fellows back to China, and the contact details. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097458 | 24097458 |
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]);