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 |
---|---|---|---|---|---|---|---|---|---|
49918 | 49918 | 1931-01-24 | 2 | b | Second part of comments by Tung Wah Times on the independence movement in India. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090248 | 24090248 | |
49924 | 49924 | 1931-01-24 | 3 | b | Japanese consul in Jinan, Shandong province, requests China to compensate Japanese nationals for their loss during the war. | China | http://trove.nla.gov.au/newspaper/page/24090247 | 24090247 | |
49932 | 49932 | 1931-01-24 | 8 | b | Nationalist troops defect to the Communist Party in south China. Sichuan, Guizhou, Yunnan and Guangxi jointly against the Nanjing government. Zhang Xueliang may not be able to return to Shenyang. Chinese naval fleet helps to fight pirates. | China | http://trove.nla.gov.au/newspaper/page/24090254 | 24090254 | |
49933 | 49933 | 1931-01-24 | 8 | b | Earthquake in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24090254 | 24090254 | |
49934 | 49934 | 1931-01-24 | 8 | b | American government has new policy against the communist movement. | America | http://trove.nla.gov.au/newspaper/page/24090254 | 24090254 |
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]);