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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
53396 | 53396 | 1933-10-14 | 3 | e | Economic recovery in America. | America | 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 | |
53398 | 53398 | 1933-10-14 | 5 | c | A prophet on the future of Japan. | China | http://trove.nla.gov.au/newspaper/page/24091399 | 24091399 | |
53399 | 53399 | 1933-10-14 | 5 | f | Holiday in Lushan mountain, Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24091399 | 24091399 | |
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 | |
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 | |
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 | |
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 | |
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]);