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 |
---|---|---|---|---|---|---|---|---|---|
53329 | 53329 | 1933-09-30 | 2 | a | Editorial on the diplomacy between China and Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091382 | 24091382 | |
53330 | 53330 | 1933-09-30 | 2 | c | The communist forces in Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24091382 | 24091382 | |
53331 | 53331 | 1933-09-30 | 2 | d | Refugees in the southwest of Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24091382 | 24091382 | |
53332 | 53332 | 1933-09-30 | 2 | d | Sun Liangcheng resigns after the crisis in Chaha'er. | China | http://trove.nla.gov.au/newspaper/page/24091382 | 24091382 | |
53333 | 53333 | 1933-09-30 | 2 | e | Zhang Xueliang to return to China next Spring. | China | http://trove.nla.gov.au/newspaper/page/24091382 | 24091382 | |
53334 | 53334 | 1933-09-30 | 2 | e | Baojia system enforced in Henan, Hubei and Anhui province. | China | http://trove.nla.gov.au/newspaper/page/24091382 | 24091382 | |
53335 | 53335 | 1933-09-30 | 2 | e | Luo Wengan arrives Xi'an, of Shaanxi province. | China | http://trove.nla.gov.au/newspaper/page/24091382 | 24091382 | |
53336 | 53336 | 1933-09-30 | 2 | e | Liu Wenhui in Sichuan is defeated. | China | http://trove.nla.gov.au/newspaper/page/24091382 | 24091382 | |
53337 | 53337 | 1933-09-30 | 2 | f | Song Ziwen arrives Yokohama. | China | http://trove.nla.gov.au/newspaper/page/24091382 | 24091382 | |
53338 | 53338 | 1933-09-30 | 2 | f | Yu Xuezhong arrives Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24091382 | 24091382 | |
53339 | 53339 | 1933-09-30 | 2 | f | A proposal to convene a national conference. | China | http://trove.nla.gov.au/newspaper/page/24091382 | 24091382 | |
53340 | 53340 | 1933-09-30 | 3 | a | Chinese troops in north China under Song Zheyuan, Ji Hongchang and Fang Jinwu and their resistance to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24091381 | 24091381 | |
53341 | 53341 | 1933-09-30 | 3 | c | Song Ziwen on the world situations. | China | http://trove.nla.gov.au/newspaper/page/24091381 | 24091381 | |
53342 | 53342 | 1933-09-30 | 3 | e | Trade between China and Russia. | China | http://trove.nla.gov.au/newspaper/page/24091381 | 24091381 | |
53343 | 53343 | 1933-09-30 | 5 | a | Third part of the resolution passed by the League of Nations on Manchurian issues. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091383 | 24091383 | |
53344 | 53344 | 1933-09-30 | 5 | c | Ma Zhanshan lists all donations he has received, part III. | China | http://trove.nla.gov.au/newspaper/page/24091383 | 24091383 | |
53345 | 53345 | 1933-09-30 | 5 | d | Prostitution in Nanjing, capital of China. | China | http://trove.nla.gov.au/newspaper/page/24091383 | 24091383 | |
53346 | 53346 | 1933-09-30 | 5 | e | Chinese communities in Sydney and Melbourne have memorial gatherings on September 18. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091383 | 24091383 | |
53347 | 53347 | 1933-09-30 | 7-8 | a-f | Guangdong news/ Manoeuvre of troops in Guangdong to guard against the communists. Fang Dehua on the Guangdong economy. Deng Longguang back to Guangzhou from Zhaoqing. Japanese seek to invade the islands near Hainan. Budget for police force in Guangdong. Import of poor quality products. Bandits in Dongguan. French troops occupy nines islands in the South China Sea. Financial authority on the industrial development in Guangdong. A ferry in Wuzhou is bombed. | China | http://trove.nla.gov.au/newspaper/page/24091385 | 24091385 | |
53348 | 53348 | 1933-09-30 | 6 | a | Epidemic disease in north Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091386 | 24091386 | |
53349 | 53349 | 1933-09-30 | 6 | a | Japanese in Africa. | Britain | http://trove.nla.gov.au/newspaper/page/24091386 | 24091386 | |
53350 | 53350 | 1933-09-30 | 6 | a | China imports cotton from America. | China | http://trove.nla.gov.au/newspaper/page/24091386 | 24091386 | |
53351 | 53351 | 1933-09-30 | 6 | b | Jiang Jieshi dispatches more warplanes to suppress the communists. | China | http://trove.nla.gov.au/newspaper/page/24091386 | 24091386 | |
53352 | 53352 | 1933-09-30 | 6 | c | Japanese in the Far East. | China | http://trove.nla.gov.au/newspaper/page/24091386 | 24091386 | |
53353 | 53353 | 1933-09-30 | 6 | d | Soviet Russia condemns Japan for the breach of mutual treaties. | Britain | http://trove.nla.gov.au/newspaper/page/24091386 | 24091386 | |
53354 | 53354 | 1933-09-30 | 6 | e | The worsening disputes between Russia and Japan. | China | http://trove.nla.gov.au/newspaper/page/24091386 | 24091386 | |
53355 | 53355 | 1933-09-30 | 6 | f | Japanese planes casts leaflets in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24091386 | 24091386 | |
53356 | 53356 | 1933-09-30 | 6 | f | Fang Zhenwu seeks to enter Beijing. | France | http://trove.nla.gov.au/newspaper/page/24091386 | 24091386 | |
53357 | 53357 | 1933-09-30 | 6 | g | Sydney post office advises senders to write the address clearly. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091386 | 24091386 |
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]);