This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28329 | 28329 | 1913-12-27 | 3 | c | Budget for royal British navy. | Britain | http://trove.nla.gov.au/newspaper/page/24092936 | 24092936 | |
28330 | 28330 | 1913-12-27 | 3 | c | Local military governors and provincial administrators request to dissolve the parliament. | China | http://trove.nla.gov.au/newspaper/page/24092936 | 24092936 | |
28331 | 28331 | 1913-12-27 | 3 | c | Chinese government appoints Lu Bingtian new consul-general to Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092936 | 24092936 | |
28332 | 28332 | 1913-12-27 | 3 | c | Diplomatic crisis between Russia and Turkey. | Britain | http://trove.nla.gov.au/newspaper/page/24092936 | 24092936 | |
28333 | 28333 | 1913-12-27 | 3 | c | China to have new and big shipping company. | China | http://trove.nla.gov.au/newspaper/page/24092936 | 24092936 | |
28334 | 28334 | 1913-12-27 | 3 | c | Revenue increases in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24092936 | 24092936 | |
28346 | 28346 | 1913-12-27 | 8 | c | Guangdong news/ Confucianism Promotion Society in Guangzhou and their meeting with provincial governor. Long Jiguang welcomes Kang Youwei and the ceremony. Guangdong and Guangxi to swap their governors. Hong Kong businessmen request provincial authority to repay public debt. The Nationalist Party and their new roles. Stamp duty to be collected. Three female convicts to be executed in Guangzhou for weapon smuggling. Bandits robbery in Xiangshan county. Luo Pu arrives Guangzhou as new industrial commissioner. | China | http://trove.nla.gov.au/newspaper/page/24092943 | 24092943 |
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]);