This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28529 | 28529 | 1914-03-07 | 2 | d | New proposals on the presidential system in China. | China | http://trove.nla.gov.au/newspaper/page/24093030 | 24093030 | |
28530 | 28530 | 1914-03-07 | 2 | d | Detailed report on the political conference in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24093030 | 24093030 | |
28545 | 28545 | 1914-03-07 | 3 | d | Guangdong news/ Long Jiguang investigates the case of weapon smuggling. Provincial authority prohibits Chinese merchant boats from flying foreign flags. Foreign businessmen in Guangzhou organise their own associations. Chen Niandian to build a railway in Zengcheng county. China sends Xu Gui and Zhu Quanming respectively to comfort Chinese communities in America and Southeast Asia. Robbery in Yangjiang county. Bandit chieftain in Dongguan county Yuan Chongyu is arrested. | China | http://trove.nla.gov.au/newspaper/page/24093029 | 24093029 |
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]);