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 | |
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 | |
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 | |
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 | |
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 | |
53215 | 53215 | 1933-08-26 | 3 | a | Japanese economic invasion of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091341 | 24091341 | |
53216 | 53216 | 1933-08-26 | 3 | b | The world economic conference in London. | Britain | http://trove.nla.gov.au/newspaper/page/24091341 | 24091341 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
53228 | 53228 | 1933-08-26 | 6 | c | Air force troops in Soviet Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24091346 | 24091346 | |
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 |
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]);