This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50053 | 50053 | 1931-03-07 | 2 | b | Second and final part of editorial on the American loans to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090300 | 24090300 | |
50054 | 50054 | 1931-03-07 | 2 | c | Many Chinese in New York are unemployed and the statistics | America | http://trove.nla.gov.au/newspaper/page/24090300 | 24090300 | |
50055 | 50055 | 1931-03-07 | 2 | c | Chinese communities in Mexico fight discrimination. | Other... | http://trove.nla.gov.au/newspaper/page/24090300 | 24090300 | |
50056 | 50056 | 1931-03-07 | 2 | d | Number of factories and workers in Qingdao, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24090300 | 24090300 | |
50057 | 50057 | 1931-03-07 | 2 | d | International opium conference to be held in Thailand this coming November. | Other... | http://trove.nla.gov.au/newspaper/page/24090300 | 24090300 | |
50058 | 50058 | 1931-03-07 | 2 | e | Huang Shaoxiong talks to foreign journalists in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24090300 | 24090300 | |
50059 | 50059 | 1931-03-07 | 2 | f | Bandits in Shanghai and the kidnap. Li Jishen refuses to talk about current situations. Jiang Jieshi, Huang Shaoxiong, Chen Jitang and others discuss solutions to the Guangxi situations. Reorganisation of Shanxi army. Zhang Xueliang and his methods to reorganise Shanxi army. | China | http://trove.nla.gov.au/newspaper/page/24090300 | 24090300 |
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]);