This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34409 | 34409 | 1919-04-19 | 8 | a | The New South Wales Chinese Chamber of Commerce calls for donations to the famine victims in Guangdong. Names listed for donations received. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097692 | 24097692 | |
34410 | 34410 | 1919-04-19 | 8 | a-c | Beijing news/ Committee set up in Beijing to draft regulations for navigation. Shen Huakui applies for mining licence in Pingshan county. An association organised in Beijing to promote China's diplomacy. A meeting in the British embassy in Beijing. Japanese textile industrialists and their arrogant talks in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24097692 | 24097692 | |
34411 | 34411 | 1919-04-19 | 8 | c-d | Guangdong news/ Zhan Tianyou and others ask for protection of the Confucian temple. Telegram from the central government in Beijing on the continuing deportation of German nationals. Mo Rongxin is still in the office. British consul in Guangzhou asks for protection of oil transportation ships. | China | http://trove.nla.gov.au/newspaper/page/24097692 | 24097692 |
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]);