This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31913 | 31913 | 1917-01-20 | 6 | c | Guangdong news/ State Ministry of Transportation writes to Guangdong province on the railway licence. Ministry of Transportation conducts investigation on the Guangzhou-Hankou Railway project. Zhu Qinglan reports the whereabouts of Qin Chunxuan. Liang Qichao leaves Hong Kong for Shanghai. Governor Zhu Qinglan encourages investment by overseas Chinese businessmen. Zhu Qinglan and his plan to cultivate Dongsha islands. | China | http://trove.nla.gov.au/newspaper/page/24095559 | 24095559 | |
31916 | 31916 | 1917-01-20 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095558 | 24095558 |
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]);