This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29376 | 29376 | 1914-11-07 | 8 | a | Article written by Li Jiabei suggests that China should remain united. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093318 | 24093318 | |
29377 | 29377 | 1914-11-07 | 8 | b | Chinese government (ministry of finance and internal affairs) agrees to compensate Kang Youwei for his assets previously confiscated. | China | http://trove.nla.gov.au/newspaper/page/24093318 | 24093318 | |
29378 | 29378 | 1914-11-07 | 8 | b | Chinese government to punish any revolutionary rebels like Sun Yatsen, Huang Xing and others. | China | http://trove.nla.gov.au/newspaper/page/24093318 | 24093318 | |
29379 | 29379 | 1914-11-07 | 8 | c | Zhao Er'tuan seeks to recruit more history talents. | China | http://trove.nla.gov.au/newspaper/page/24093318 | 24093318 | |
29380 | 29380 | 1914-11-07 | 8 | c | Guangdong news/ Some revolutionary rebels in Japan change their names. Wu Zhuang is retained to work in the finance department. Government authority dispatches troops to suppress bandits in Zengcheng and Panyu counties. Two brothers in Guangzhou are fighting for inheritance for many years. | China | http://trove.nla.gov.au/newspaper/page/24093318 | 24093318 |
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]);