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 |
---|---|---|---|---|---|---|---|---|---|
54813 | 54813 | 1935-01-26 | 2 | c | Jiang Jieshi flies to Shanghai. Shang Lizi talks in Xuzhou, north Jiangsu province. Comet seen in Tangshan, Hebei province. Huang Shaoxiong to Zhejiang. Railway construction in Shandong. Chen Cheng on the victory of suppression of the communist troops in Fujian. Liu Xiang on the way to Nanjing. Yan Xishan observes a period of mourning for his deceased father. Construction of the Longhai railway to be completed. | China | http://trove.nla.gov.au/newspaper/page/24096303 | 24096303 | |
54817 | 54817 | 1935-01-26 | 3 | c | War clouds over north Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096302 | 24096302 | |
54820 | 54820 | 1935-01-26 | 5 | c | Chinese School in Wellington, New Zealand, has a party before its holiday and the report. Chinese communities in Sydney donate to welcome ceremony for Prince of Britain and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096304 | 24096304 | |
54827 | 54827 | 1935-01-26 | 6 | c | Flight service connects London and Paris. | Britain | http://trove.nla.gov.au/newspaper/page/24096307 | 24096307 | |
54828 | 54828 | 1935-01-26 | 6 | c | German authority promotes population increase. | Britain | http://trove.nla.gov.au/newspaper/page/24096307 | 24096307 |
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]);