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 |
---|---|---|---|---|---|---|---|---|---|
52381 | 52381 | 1933-01-07 | 2 | c | Survey on the losses suffered by China in the Shanghai battles with Japanese troops. | China | http://trove.nla.gov.au/newspaper/page/24091074 | 24091074 | |
52382 | 52382 | 1933-01-07 | 2 | c | Police in Jinan, Shandong province, raid an underground society. | China | http://trove.nla.gov.au/newspaper/page/24091074 | 24091074 | |
52383 | 52383 | 1933-01-07 | 2 | d | Japanese policies in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091074 | 24091074 | |
52384 | 52384 | 1933-01-07 | 2 | d | Fujian provincial government reshuffled. | China | http://trove.nla.gov.au/newspaper/page/24091074 | 24091074 | |
52385 | 52385 | 1933-01-07 | 2 | e | Good opportunity to redeem the railway from Qingdao to Jinan in Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24091074 | 24091074 | |
52386 | 52386 | 1933-01-07 | 2 | e | An open letter issued by Li Liejun to the Chinese government authorities. | China | http://trove.nla.gov.au/newspaper/page/24091074 | 24091074 | |
52387 | 52387 | 1933-01-07 | 2 | e | Wu Peifu and his suggestions to save China. | China | http://trove.nla.gov.au/newspaper/page/24091074 | 24091074 | |
52389 | 52389 | 1933-01-07 | 2 | f | A declaration issued by the foreign minister of the Manchurian state government. | China | http://trove.nla.gov.au/newspaper/page/24091074 | 24091074 | |
52391 | 52391 | 1933-01-07 | 3 | a | Two open letters issued by Zhu Qinglan on the national crisis. | China | http://trove.nla.gov.au/newspaper/page/24091073 | 24091073 | |
52392 | 52392 | 1933-01-07 | 3 | a | Political turmoil in Guizhou province. | China | http://trove.nla.gov.au/newspaper/page/24091073 | 24091073 | |
52393 | 52393 | 1933-01-07 | 3 | b | Gatherings in Beijing call for relief to the Manchurian refugees. | China | http://trove.nla.gov.au/newspaper/page/24091073 | 24091073 | |
52394 | 52394 | 1933-01-07 | 3 | c | News on the Chinese armies in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091073 | 24091073 | |
52399 | 52399 | 1933-01-07 | 6-7 | a-f | Guangdong news/ Zhu Zhaoxin dies and the report. Political chaos in Hunan province. Chen Jitang to set up another munitions factory in Guangzhou. More Chinese are returning from overseas due to unemployment. Financial crisis in Guangzhou. Political chaos in Guizhou province. Business in Shilong town, Zengcheng county. Sales of tobacco products decline. Fire of the Huizhou Electricity Supply Office. Bandit chieftain arrested in Shilong town, Zengcheng. Businessmen in Zhongshan county are involved in silver export. Saving China Association in Jiangmen searches Japanese goods. | China | http://trove.nla.gov.au/newspaper/page/24091082 | 24091082 | |
52402 | 52402 | 1933-01-07 | 5 | d | Zheng Xiaoxu is still alive though very old. | China | http://trove.nla.gov.au/newspaper/page/24091075 | 24091075 | |
52405 | 52405 | 1933-01-07 | 8 | b | Japanese may invade Rehe province in north China and the report. | China | http://trove.nla.gov.au/newspaper/page/24091084 | 24091084 | |
52407 | 52407 | 1933-01-07 | 8 | e | A gathering of the Chinese military officers calls for fighting Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24091084 | 24091084 | |
52409 | 52409 | 1933-01-07 | 8 | e | Japanese troops attack Shanhaiguan and the crisis followed. | China | http://trove.nla.gov.au/newspaper/page/24091084 | 24091084 |
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]);