This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53359 | 53359 | 1933-10-07 | 2 | b | Wang Jingwei reports his foreign policy. | China | http://trove.nla.gov.au/newspaper/page/24091390 | 24091390 | |
53360 | 53360 | 1933-10-07 | 2 | c | Song Ziwen reports his overseas tour. | China | http://trove.nla.gov.au/newspaper/page/24091390 | 24091390 | |
53361 | 53361 | 1933-10-07 | 2 | d | Typhoon on the coast of Jiangsu and Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24091390 | 24091390 | |
53362 | 53362 | 1933-10-07 | 2 | e | Jiang Jieshi to chair the conference in Lushan Mountain, Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24091390 | 24091390 | |
53363 | 53363 | 1933-10-07 | 2 | e | Song Ziwen to mortgage imported cotton for more loans from America. | China | http://trove.nla.gov.au/newspaper/page/24091390 | 24091390 | |
53364 | 53364 | 1933-10-07 | 2 | f | The Nanjing government to protect journalists. | China | http://trove.nla.gov.au/newspaper/page/24091390 | 24091390 | |
53365 | 53365 | 1933-10-07 | 2 | f | Jiang Jieshi promotes traditional values. | China | http://trove.nla.gov.au/newspaper/page/24091390 | 24091390 | |
53366 | 53366 | 1933-10-07 | 2 | f | Ma Zhanshan refuses to joint the officialdom. | China | http://trove.nla.gov.au/newspaper/page/24091390 | 24091390 | |
53367 | 53367 | 1933-10-07 | 2 | f | Train hijacked on the railway from Tianjin to Pukou. | China | http://trove.nla.gov.au/newspaper/page/24091390 | 24091390 | |
53369 | 53369 | 1933-10-07 | 3 | c | China and France reach agreement over the Vietnam issues and the response of the Chinese communities there. | China | http://trove.nla.gov.au/newspaper/page/24091389 | 24091389 | |
53372 | 53372 | 1933-10-07 | 5 | a | China manufactures new cannons in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091391 | 24091391 | |
53373 | 53373 | 1933-10-07 | 5 | b | The Lushan conference chaired by Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24091391 | 24091391 | |
53374 | 53374 | 1933-10-07 | 5 | e | How Zhang Xueliang quit opium smoking. | China | http://trove.nla.gov.au/newspaper/page/24091391 | 24091391 | |
53377 | 53377 | 1933-10-07 | 7-8 | a-f | Guangdong news/ Zou Lu proposes to convene the Fifth Plenary Session in Guangzhou. The communist troops in Changting, Fujian province. Proposal to reform the commercial chamber of Guangzhou. Guard against the communists in Shilong town, Shunde county. Outflow of gold and silver from China. Guangxi secures several planes from Hong Kong. A survey on the coach service in Guangzhou. Weather changes in Guangzhou. Memorial gatherings in Foshan on the birthday of Confucius. Chinese returned from overseas need help. Drought in Guangdong and a survey. | China | http://trove.nla.gov.au/newspaper/page/24091393 | 24091393 | |
53380 | 53380 | 1933-10-07 | 6 | a | Cost of Japanese invasion of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091394 | 24091394 | |
53381 | 53381 | 1933-10-07 | 6 | b | Japanese warplanes harass Beijing. | China | http://trove.nla.gov.au/newspaper/page/24091394 | 24091394 | |
53382 | 53382 | 1933-10-07 | 6 | c | Fang Zhenwu and his troops in north China. | China | http://trove.nla.gov.au/newspaper/page/24091394 | 24091394 | |
53383 | 53383 | 1933-10-07 | 6 | d | Disasters in China. | China | http://trove.nla.gov.au/newspaper/page/24091394 | 24091394 | |
53384 | 53384 | 1933-10-07 | 6 | e | Nanjing government seeks cooperation of Japanese to wipe out Fang Zhenwu. | China | http://trove.nla.gov.au/newspaper/page/24091394 | 24091394 |
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]);