This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54665 | 54665 | 1934-11-17 | 2 | c | China news/ Celebrations on the National Day in China. Japanese troops in Manchuria to have an exercise. Jiang Jieshi and Zhang Xueliang to Luoyang in Henan province. Chinese government negotiates with Japan on the deportation of Chinese immigrants. Jiang Bocheng arrives Shanghai from Guangzhou. Jiang Jieshi and his strategies to eradicate the communists. Airport building in Hengyang, Hunan province. Gu Zhutong dies in an air accident. Disasters in south Hebei province. | China | http://trove.nla.gov.au/newspaper/page/24096232 | 24096232 | |
54667 | 54667 | 1934-11-17 | 3 | c | German prophet predicts the second world war will break out next summer. | America | http://trove.nla.gov.au/newspaper/page/24096231 | 24096231 | |
54676 | 54676 | 1934-11-17 | 6 | c | Australia news/ Members of the new federal cabinet. Chinese tobacco shop robbed in Sydney. Heavy rains in Victoria. A robbery in Sydney. Prince of Britain tours Tasmania. Jewellery shop is robbed in Sydney. Sydney welcomes Prince of Britain and the ceremony. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096236 | 24096236 |
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]);