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 |
---|---|---|---|---|---|---|---|---|---|
53398 | 53398 | 1933-10-14 | 5 | c | A prophet on the future of Japan. | China | http://trove.nla.gov.au/newspaper/page/24091399 | 24091399 | |
53397 | 53397 | 1933-10-14 | 5 | a | A visit to Gansu and Qinghai province. | 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 | |
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 | |
53401 | 53401 | 1933-10-14 | 6 | a | Bandits occupy Beidaihe in Hebei province. | China | http://trove.nla.gov.au/newspaper/page/24091402 | 24091402 | |
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 | |
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 | |
53402 | 53402 | 1933-10-14 | 6 | a | Bush fire in America and the casualties. | America | http://trove.nla.gov.au/newspaper/page/24091402 | 24091402 | |
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 | |
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 | |
53405 | 53405 | 1933-10-14 | 6 | d | Fang Zhenwu is trapped. | China | http://trove.nla.gov.au/newspaper/page/24091402 | 24091402 | |
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 | |
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 | |
53399 | 53399 | 1933-10-14 | 5 | f | Holiday in Lushan mountain, Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24091399 | 24091399 | |
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 | |
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 | |
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 | |
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 | |
53403 | 53403 | 1933-10-14 | 6 | b | Song Ziwen is skilled in securing loans. | China | 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]);