This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25256 | 25256 | 1911-11-11 | 2 | c | Opium ban issues between China and Britain | Opium ban leads to profit reduction of British businessmen. | China | http://trove.nla.gov.au/newspaper/page/24091993 | 24091993 |
25267 | 25267 | 1911-11-11 | 3 | c | Beijing news | Li Jingyi makes up mind to resign.Wang Botang returns to Beijing on issue of Japanese East Asia Association. Cai Naihuang escapes to Qingdao to avoid legal charge. Some students are to go to Britain to study navy. Yunnan businessmen oppose government's agreement. Liu Shengyuan is proved still alive. Result of overseas students examination is exposed. | China | http://trove.nla.gov.au/newspaper/page/24091992 | 24091992 |
25281 | 25281 | 1911-11-11 | 8 | c | Investigation of Guangzhou | Statistics of residences and shops in various streets in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24091999 | 24091999 |
25282 | 25282 | 1911-11-11 | 8 | c | Satire on document of the Post Ministry | Satire on the Post Ministry in China making a wilful penalty regulation. | China | http://trove.nla.gov.au/newspaper/page/24091999 | 24091999 |
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]);