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 |
---|---|---|---|---|---|---|---|---|---|
53473 | 53473 | 1933-11-04 | 2 | a | China and Japan to have a face-to-face dialogue, editorial by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091422 | 24091422 | |
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 | |
53484 | 53484 | 1933-11-04 | 3 | d | Japan military authority on the expansion of their troops. | Japan | http://trove.nla.gov.au/newspaper/page/24091421 | 24091421 | |
53485 | 53485 | 1933-11-04 | 3 | e | Japanese protest against Gu Weijun's speech in Geneva. | Japan | 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 | |
53489 | 53489 | 1933-11-04 | 3 | f | Conference of the League of Nations examine its past achievements. | Other... | 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 | |
53491 | 53491 | 1933-11-04 | 5 | c | Tang Caichang and his story, Part II. | Tung Wah | 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 | |
53494 | 53494 | 1933-11-04 | 5 | f | Chinese communities in Wellington, New Zealand, celebrate the National Day. | New Zealand | 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 | |
53496 | 53496 | 1933-11-04 | 6 | a | America and Russia reach agreement to set up diplomatic relations. | Britain | http://trove.nla.gov.au/newspaper/page/24091426 | 24091426 | |
53497 | 53497 | 1933-11-04 | 6 | d | French cabinet reshuffled. | Britain | http://trove.nla.gov.au/newspaper/page/24091426 | 24091426 | |
53498 | 53498 | 1933-11-04 | 6 | d | Earthquake in America. | America | http://trove.nla.gov.au/newspaper/page/24091426 | 24091426 | |
53499 | 53499 | 1933-11-04 | 6 | d | Manchurian state purchases old warships from France. | Britain | http://trove.nla.gov.au/newspaper/page/24091426 | 24091426 | |
53500 | 53500 | 1933-11-04 | 6 | e | Russian foreign minister secretly visits America. | Britain | http://trove.nla.gov.au/newspaper/page/24091426 | 24091426 | |
53501 | 53501 | 1933-11-04 | 6 | e | Warlords in Sichuan province and their battles. | China | http://trove.nla.gov.au/newspaper/page/24091426 | 24091426 | |
53502 | 53502 | 1933-11-04 | 6 | e | Australia news/ Prices of train tickets in Sydney reduced. A robbery in Queensland. Chinese fruit businessman is beaten and injured in Sydney. Chinese businessmen in Singapore share the market of Australian wheat flour. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091426 | 24091426 | |
53503 | 53503 | 1933-11-04 | 6 | f | Funeral of Rev. Liu Junchen. | Tung Wah | 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]);