This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34872 | 34872 | 1919-09-06 | 8 | a | Poems by Li Jialian on Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097858 | 24097858 | |
34873 | 34873 | 1919-09-06 | 8 | a | Chinese community in Brisbane, Queensland, donates to the famine victims in Guangdong and their names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097858 | 24097858 | |
34874 | 34874 | 1919-09-06 | 8 | a-b | Guangdong news/ Wei Bangping in crisis. Secret report on the Guangzhou-Hankou railway company. Zhao Binghua and Chen Dianjing, two Chinese returned from America, help to strengthen the local civil corps in their home town of Xiangshan county. Guangxi troops in Zhaoqing and their looting. | China | http://trove.nla.gov.au/newspaper/page/24097858 | 24097858 |
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]);