This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29082 | 29082 | 1914-07-18 | 8 | a-b | Foreigners in Beijing and Nanjing and their residence. | China | http://trove.nla.gov.au/newspaper/page/24093186 | 24093186 | |
29083 | 29083 | 1914-07-18 | 8 | b | Song Yuchun in Changchun, of Jilin province, is found collaboration with rebels. | China | http://trove.nla.gov.au/newspaper/page/24093186 | 24093186 | |
29084 | 29084 | 1914-07-18 | 8 | b | Mongolian princes in Kulun may cancel their independence claim. | China | http://trove.nla.gov.au/newspaper/page/24093186 | 24093186 | |
29085 | 29085 | 1914-07-18 | 8 | b-c | Rich men in the United States of American and their wealth. | America | http://trove.nla.gov.au/newspaper/page/24093186 | 24093186 | |
29086 | 29086 | 1914-07-18 | 8 | c | Humorous regulations on opium smoking and opium addicts. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093186 | 24093186 | |
29087 | 29087 | 1914-07-18 | 8 | c-d | Guangdong news/ Chen Jiongming and Qin Chunxuan may cause trouble in Guangdong again. Chen Jiongming is found preparing for rebellion. Flood in Zhaoqing and Wuzhou and the casualties. Chief of the Industrial Bureau Luo Pu resigns. Two Progressive Party (jin bu dang) members returns from San Francisco with their planes. Li Yaohan is on sick leave before being asked to suppress bandits in Zhaoqing. The world of bandits in Zengcheng county. | China | http://trove.nla.gov.au/newspaper/page/24093186 | 24093186 |
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]);