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 |
---|---|---|---|---|---|---|---|---|---|
53474 | 53474 | 1933-11-04 | 2 | b | Wang Jingwei may resign due to his disagreement with Jiang Jieshi and Song Ziwen. | China | http://trove.nla.gov.au/newspaper/page/24091422 | 24091422 | |
53475 | 53475 | 1933-11-04 | 2 | c | Wu Tiecheng also acts as General Commander of the police force in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091422 | 24091422 | |
53476 | 53476 | 1933-11-04 | 2 | d | Japanese encourage independence movement in Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24091422 | 24091422 | |
53477 | 53477 | 1933-11-04 | 2 | e | He Chengrui arrives Chongqing, Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24091422 | 24091422 | |
53478 | 53478 | 1933-11-04 | 2 | e | American cotton arrive Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091422 | 24091422 | |
53479 | 53479 | 1933-11-04 | 2 | e | Hunan people oppose to the rice export to Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24091422 | 24091422 | |
53480 | 53480 | 1933-11-04 | 2 | f | List of antiques of the Forbidden City in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24091422 | 24091422 | |
53481 | 53481 | 1933-11-04 | 2 | f | The 19th Route Army search communists in north Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24091422 | 24091422 | |
53482 | 53482 | 1933-11-04 | 2 | f | Huang Shaoxiong returns to Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24091422 | 24091422 | |
53483 | 53483 | 1933-11-04 | 3 | a | Chinese troops under Fang Zhenwu and Ji Hongchang in north China and their resistance to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24091421 | 24091421 | |
53486 | 53486 | 1933-11-04 | 3 | e | Jiang Zuobin is urged to go to Japan. | China | http://trove.nla.gov.au/newspaper/page/24091421 | 24091421 | |
53487 | 53487 | 1933-11-04 | 3 | f | Japanese are building airport in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24091421 | 24091421 | |
53488 | 53488 | 1933-11-04 | 3 | f | German newspaper apologises to China for incorrect report. | China | http://trove.nla.gov.au/newspaper/page/24091421 | 24091421 | |
53490 | 53490 | 1933-11-04 | 5 | a | An inscription on the tablet for the 19th Route Army, written by Hu Hanmin. | China | http://trove.nla.gov.au/newspaper/page/24091423 | 24091423 | |
53492 | 53492 | 1933-11-04 | 5 | d | Puyi, dethroned emperor of Qing dynasty, and his life in Changchun. | China | http://trove.nla.gov.au/newspaper/page/24091423 | 24091423 | |
53493 | 53493 | 1933-11-04 | 5 | e | The Nationalist government in Nanjing and the establishment of Manchurian state. | China | http://trove.nla.gov.au/newspaper/page/24091423 | 24091423 | |
53495 | 53495 | 1933-11-04 | 7-8 | a-f | Guangdong news/ Chen Lifu and Chen Jicheng on the way south and the report. Chen Jiongming dies in Hong Kong and a further report. Finance in Guangdong. Deng Shizeng personally command his troops to suppress the communists. Training of land tax collectors in Guangzhou. The First Group Army has secured some new weapons. The Southeast Bank collapses in Guangzhou. Prostitution in Chencun town, Shunde. Business declines in Taishan. Survey on the floods in the east of Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24091425 | 24091425 | |
53501 | 53501 | 1933-11-04 | 6 | e | Warlords in Sichuan province and their battles. | China | http://trove.nla.gov.au/newspaper/page/24091426 | 24091426 |
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]);