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 |
---|---|---|---|---|---|---|---|---|---|
53387 | 53387 | 1933-10-14 | 2 | a | First part of an editorial claims that Japan is challenging the international community. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091398 | 24091398 | |
53393 | 53393 | 1933-10-14 | 3 | a | Resistance of Chinese troops in Jilin province to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24091397 | 24091397 | |
53394 | 53394 | 1933-10-14 | 3 | a | Britain to be involved in aviation development in south China. | China | http://trove.nla.gov.au/newspaper/page/24091397 | 24091397 | |
53397 | 53397 | 1933-10-14 | 5 | a | A visit to Gansu and Qinghai province. | China | http://trove.nla.gov.au/newspaper/page/24091399 | 24091399 | |
53401 | 53401 | 1933-10-14 | 6 | a | Bandits occupy Beidaihe in Hebei province. | China | http://trove.nla.gov.au/newspaper/page/24091402 | 24091402 | |
53402 | 53402 | 1933-10-14 | 6 | a | Bush fire in America and the casualties. | America | http://trove.nla.gov.au/newspaper/page/24091402 | 24091402 | |
53400 | 53400 | 1933-10-14 | 7-8 | a-f | Guangdong news/ Zou Lu to visit Nanyang for the Party organisation issues. Communist troops in north Fujian. Two airports in Guangzhou are named. Huang Zhiwen urges to organise mass associations to fight the Communists. Loans from Guangdong to the Central Government. Business in Hong Kong is recovering. Homeless people in Guangzhou. Fluctuation of rice prices in Guangzhou. The Ghost Festival in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24091401 | 24091401 | |
53388 | 53388 | 1933-10-14 | 2 | b | Memorial service in Beijing for the Chinese officers and soldiers killed in the resistance to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24091398 | 24091398 | |
53395 | 53395 | 1933-10-14 | 3 | b | Dutch colonies in Nanyang to restrict Chinese immigration. | China | http://trove.nla.gov.au/newspaper/page/24091397 | 24091397 | |
53403 | 53403 | 1933-10-14 | 6 | b | Song Ziwen is skilled in securing loans. | China | http://trove.nla.gov.au/newspaper/page/24091402 | 24091402 | |
53404 | 53404 | 1933-10-14 | 6 | b | British newspaper on the air defence capability in America, France, Germany, Britain, Italy and Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24091402 | 24091402 | |
53389 | 53389 | 1933-10-14 | 2 | c | Song Ziwen is on the way to Lushan following other political and military leaders. | China | http://trove.nla.gov.au/newspaper/page/24091398 | 24091398 | |
53398 | 53398 | 1933-10-14 | 5 | c | A prophet on the future of Japan. | China | http://trove.nla.gov.au/newspaper/page/24091399 | 24091399 | |
53390 | 53390 | 1933-10-14 | 2 | d | A visit to Jiangxi, Anhui, Hunan and Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24091398 | 24091398 | |
53405 | 53405 | 1933-10-14 | 6 | d | Fang Zhenwu is trapped. | China | http://trove.nla.gov.au/newspaper/page/24091402 | 24091402 | |
53406 | 53406 | 1933-10-14 | 6 | d | Australia news/ Sydney city council to build new market. Robberies in Melbourne. Sale of Australian products in China. Earthquake in the Snow Mountain. Federal government publicises its budget. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091402 | 24091402 | |
53396 | 53396 | 1933-10-14 | 3 | e | Economic recovery in America. | America | http://trove.nla.gov.au/newspaper/page/24091397 | 24091397 | |
53391 | 53391 | 1933-10-14 | 2 | f | Cai Tingkai orders to stop the movement of communist troops in Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24091398 | 24091398 | |
53392 | 53392 | 1933-10-14 | 2 | f | Drought in north Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24091398 | 24091398 | |
53399 | 53399 | 1933-10-14 | 5 | f | Holiday in Lushan mountain, Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24091399 | 24091399 | |
53407 | 53407 | 1933-10-14 | 6 | f | Song Zheyuan writes to Sydney Chinese communities for their donations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091402 | 24091402 |
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]);