This data as json, CSV (advanced)
Suggested facets: page, column, trove_id
Link | rowid | date | page | column ▼ | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
53348 | 53348 | 1933-09-30 | 6 | a | Epidemic disease in north Manchuria. | China | 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 | |
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 | |
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 |
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]);