This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
53330 | 53330 | 1933-09-30 | 2 | c | The communist forces in Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24091382 | 24091382 | |
53341 | 53341 | 1933-09-30 | 3 | c | Song Ziwen on the world situations. | China | http://trove.nla.gov.au/newspaper/page/24091381 | 24091381 | |
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 | |
53352 | 53352 | 1933-09-30 | 6 | c | Japanese in the Far East. | China | http://trove.nla.gov.au/newspaper/page/24091386 | 24091386 | |
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 | |
53345 | 53345 | 1933-09-30 | 5 | d | Prostitution in Nanjing, capital of China. | China | http://trove.nla.gov.au/newspaper/page/24091383 | 24091383 | |
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 | |
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 | |
53342 | 53342 | 1933-09-30 | 3 | e | Trade between China and Russia. | China | http://trove.nla.gov.au/newspaper/page/24091381 | 24091381 | |
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 | |
53354 | 53354 | 1933-09-30 | 6 | e | The worsening disputes between Russia and Japan. | China | http://trove.nla.gov.au/newspaper/page/24091386 | 24091386 | |
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 | |
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]);