This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31356 | 31356 | 1916-07-01 | 3 | a-b | Tang Jiyao cares about the injured soldiers. | China | http://trove.nla.gov.au/newspaper/page/24095315 | 24095315 | |
31361 | 31361 | 1916-07-01 | 6 | a-b | Correspondence from Hong Kong on the situations there. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24095320 | 24095320 | |
31367 | 31367 | 1916-07-01 | 7 | a-b | Australia news/ Chinese men in Sydney are shot and injured and the court hearings. Opium smuggled and caught by the New South Wales customs. Census and the statistics of population in New South Wales in 1915. | Australia | http://trove.nla.gov.au/newspaper/page/24095319 | 24095319 | |
31373 | 31373 | 1916-07-01 | 8 | a-b | Beijing news/ Yuan Shikai's government in Beijing plans to fight the hu guo jun by force. Zhuang Yunkuan is appointed Chief Auditor in Beijing. Liang Shiyi and Cao Rulin are planning to mortgage railway to loans from Japan. Comrades Association in Hebei writes to the national parliament. The Nanjing Conference and its circular telegram. Duan Zhiquan leads his troops to Beijing. Zhejiang province has the fourth military governor within months. | China | http://trove.nla.gov.au/newspaper/page/24095321 | 24095321 |
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]);