This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28999 | 28999 | 1914-06-27 | 8 | a | Full copy of the regulation of the Political Consulting Commission (can zheng yuan) in Beijing | China | http://trove.nla.gov.au/newspaper/page/24093162 | 24093162 | |
29000 | 29000 | 1914-06-27 | 8 | a-b | Second part of the new immigration regulations issued by the New Zealand governor, translated by Chinese consul-general there Gui Zhi. | New Zealand | http://trove.nla.gov.au/newspaper/page/24093162 | 24093162 | |
29001 | 29001 | 1914-06-27 | 8 | b | Conspiracy of the bandits and revolutionary rebels in China. | China | http://trove.nla.gov.au/newspaper/page/24093162 | 24093162 | |
29002 | 29002 | 1914-06-27 | 8 | c-d | Guangdong news/ Preparation for the establishment of Confucian Society. The Bank of China in Guangzhou and the paper notes issued. Provincial authority approves French companies to recruit labourers in Guangdong. Curfew imposed in Guangzhou and why. Long Jiguang's mother and her birthday celebration. A unfilial son is struck to death by lightning. | China | http://trove.nla.gov.au/newspaper/page/24093162 | 24093162 | |
29003 | 29003 | 1914-06-27 | 8 | d | Confession of the pirates/ bandits who are under custody for hijack of passenger liner Tai'an. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24093162 | 24093162 |
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]);