This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
53403 | 53403 | 1933-10-14 | 6 | b | Song Ziwen is skilled in securing loans. | China | 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 |
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]);