This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33361 | 33361 | 1918-06-08 | 8 | a | Chinese communities in Sydney donate to the disaster relief in Guangdong and Fujian (earthquake), and Zhili and Fengtian (floods), names listed for donations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097320 | 24097320 | |
33362 | 33362 | 1918-06-08 | 8 | a-c | Beijing news/ Ministry of Internal Affairs to investigate seven industries. A national conference in Beijing for the river projects. Another meeting of the Anfu Club. Central government awards medals to heroes. A cargo ship sinks near Shanghai after collision with a warship. Troops from Zhejiang province to support Fujian. Japanese ship leaves Shanghai with military provisions for Europe. Lu Rongting dies and the opportunity for national peace. | China | http://trove.nla.gov.au/newspaper/page/24097320 | 24097320 | |
33363 | 33363 | 1918-06-08 | 8 | c-d | Guangdong news/ Sun Yatsen flees to Taiwan. Organisation of a military government in Guangzhou. Government troops from the north enter Nanxiong county. | China | http://trove.nla.gov.au/newspaper/page/24097320 | 24097320 |
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]);