This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
Link | rowid | date | page | column | title | description ▼ | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53228 | 53228 | 1933-08-26 | 6 | c | Air force troops in Soviet Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24091346 | 24091346 | |
53226 | 53226 | 1933-08-26 | 6 | b | America exports wheat to China. | America | http://trove.nla.gov.au/newspaper/page/24091346 | 24091346 | |
53230 | 53230 | 1933-08-26 | 6 | d | Australia news/ Another court hearing on the case of Huang Huazhi. Famous Chinese businessman and accountant of the Chinese Baptism church in Sydney Huang Si dies. Chinese gardener is found embezzlement. Chinese man killed in a tram accident, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091346 | 24091346 | |
53221 | 53221 | 1933-08-26 | 5 | e | Feng Yuxiang refuses to pay the Party dues. | China | http://trove.nla.gov.au/newspaper/page/24091343 | 24091343 | |
53210 | 53210 | 1933-08-26 | 2 | a | First part of an editorial on Japanese conspiracy of their proposed Asian alliance. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091342 | 24091342 | |
53229 | 53229 | 1933-08-26 | 6 | d | Floods in China. | China | http://trove.nla.gov.au/newspaper/page/24091346 | 24091346 | |
53225 | 53225 | 1933-08-26 | 6 | a | Floods of the Yellow River. | China | http://trove.nla.gov.au/newspaper/page/24091346 | 24091346 | |
53222 | 53222 | 1933-08-26 | 7-8 | a-f | Guangdong news/ Chinese troops from Nanjing to attack Chaha'er province. The 19th Route Army sieges Changting in Fujian province. Huang Guangrui tries to make noiseless plane. Attempt to suppress the communists in Fujian province. Businessmen in Taishan and Xinhui are found in collaboration with Japanese. | China | http://trove.nla.gov.au/newspaper/page/24091345 | 24091345 | |
53224 | 53224 | 1933-08-26 | 6 | a | Japanese ambassador to Poland is baptised before dies. | Britain | http://trove.nla.gov.au/newspaper/page/24091346 | 24091346 | |
53215 | 53215 | 1933-08-26 | 3 | a | Japanese economic invasion of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091341 | 24091341 | |
53218 | 53218 | 1933-08-26 | 3 | e | Japanese monopolise sale of local products in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091341 | 24091341 | |
53223 | 53223 | 1933-08-26 | 6 | a | Japanese navy on exercise. | Japan | http://trove.nla.gov.au/newspaper/page/24091346 | 24091346 | |
53214 | 53214 | 1933-08-26 | 2 | f | Japanese want to station their troops in every county of north China. | China | http://trove.nla.gov.au/newspaper/page/24091342 | 24091342 | |
53211 | 53211 | 1933-08-26 | 2 | b | Jiang Jieshi in collaboration with Japanese to trap Feng Yuxiang. | China | http://trove.nla.gov.au/newspaper/page/24091342 | 24091342 | |
53213 | 53213 | 1933-08-26 | 2 | e | The Blue Clothes Society (a spy unit) plans for assassination in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091342 | 24091342 | |
53227 | 53227 | 1933-08-26 | 6 | b | The end of dictatorship in Cuba and the celebrations. | Other... | http://trove.nla.gov.au/newspaper/page/24091346 | 24091346 | |
53220 | 53220 | 1933-08-26 | 5 | d | The girl secretaries in Nanjing and their stories. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091343 | 24091343 | |
53216 | 53216 | 1933-08-26 | 3 | b | The world economic conference in London. | Britain | http://trove.nla.gov.au/newspaper/page/24091341 | 24091341 | |
53212 | 53212 | 1933-08-26 | 2 | d | Wang Jingwei replies to Li Jishen and Chen Mingshu. | China | http://trove.nla.gov.au/newspaper/page/24091342 | 24091342 | |
53217 | 53217 | 1933-08-26 | 3 | c | Wang Jingwei wants to save and unify China by economic construction. | China | http://trove.nla.gov.au/newspaper/page/24091341 | 24091341 | |
53219 | 53219 | 1933-08-26 | 5 | a | Zhi gong tang and the Constitutional Party (xian zheng dang) welcome Zhang Junmai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091343 | 24091343 |
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]);