This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
49935 | 49935 | 1931-01-24 | 8 | c | Textile factory closed in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24090254 | 24090254 | |
49936 | 49936 | 1931-01-24 | 8 | c | Australia news/ Policeman is charged in Sydney. Gibbs Bright lines after the change of routes. Another bank robbery in Brisbane. Workers arrested in Melbourne during their demonstration. Young boy in NSW finds gold. High exchange rate of the Australian currency. Postage going up. Man detained in NSW for illegal wine. Imperial Theatre in Melbourne on fire. Police in Sydney raid Chinese opium den. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090254 | 24090254 | |
49937 | 49937 | 1931-01-24 | 8 | e | Notice issued by Gui Zhi, Chinese Consul-General in Australia, on the registration of Chinese nationals in Australia. | Tung Wah | 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]);