This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33688 | 33688 | 1918-10-05 | 2 | c-d | Secrecy of the Golden Currency (jin bi quan) in China. | China | http://trove.nla.gov.au/newspaper/page/24097454 | 24097454 | |
33696 | 33696 | 1918-10-05 | 3 | c-d | Zhang Jingyao supports peace talks between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24097453 | 24097453 | |
33707 | 33707 | 1918-10-05 | 8 | c-d | Guangdong news/ Recent moves of the Zhaoqing troops under Li Yaohan. A joint session for the provincial legislature assembly. Robbery in Xiangshan county. Public property under investigation in Guangdong. Fengchuan county magistrate reports floods. Provincial water authority reports water level in various rivers in Guangdong. The railway from Guangzhou to Hankou will resume operation after some repairs. | China | http://trove.nla.gov.au/newspaper/page/24097460 | 24097460 |
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]);