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 |
---|---|---|---|---|---|---|---|---|---|
39291 | 39291 | 1923-01-20 | 3 | b | Political factions in the Chinese parliament and their plot. | China | http://trove.nla.gov.au/newspaper/page/24094259 | 24094259 | |
39292 | 39292 | 1923-01-20 | 3 | b | American and Japanese companies want to supervise the railway operation in China. | China | http://trove.nla.gov.au/newspaper/page/24094259 | 24094259 | |
39306 | 39306 | 1923-01-20 | 7 | b | Three woman workers are killed in an explosion of Melbourne ammunition factory. | Australia | http://trove.nla.gov.au/newspaper/page/24094263 | 24094263 | |
39307 | 39307 | 1923-01-20 | 7 | b | Chen Jiongming arrives Huizhou. | China | http://trove.nla.gov.au/newspaper/page/24094263 | 24094263 | |
39308 | 39308 | 1923-01-20 | 7 | b | News in brief/ Gu Weijun is back to his ambassador office in London. Transportation is suspended in Yichang and Chongqing. Wang Zhengting is the acting premier. Zhang Shaozeng, Wu Jinglian, Li Houji, Wang Xianchen and the cabinet organisation in Beijing. Lu Zhengxiang reports from the League of Nations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094263 | 24094263 |
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]);