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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
53215 | 53215 | 1933-08-26 | 3 | a | Japanese economic invasion of Manchuria. | 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 | |
53223 | 53223 | 1933-08-26 | 6 | a | Japanese navy on exercise. | Japan | http://trove.nla.gov.au/newspaper/page/24091346 | 24091346 | |
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 | |
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 | |
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 | |
53216 | 53216 | 1933-08-26 | 3 | b | The world economic conference in London. | Britain | http://trove.nla.gov.au/newspaper/page/24091341 | 24091341 | |
53226 | 53226 | 1933-08-26 | 6 | b | America exports wheat to China. | America | http://trove.nla.gov.au/newspaper/page/24091346 | 24091346 | |
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 | |
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 | |
53228 | 53228 | 1933-08-26 | 6 | c | Air force troops in Soviet Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24091346 | 24091346 | |
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 | |
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 | |
53229 | 53229 | 1933-08-26 | 6 | d | Floods in China. | China | 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 | |
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 | |
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 | |
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 | |
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 |
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]);