This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50750 | 50750 | 1931-10-03 | 2 | c | Xinjiang authority in northwest China requests military assistance to suppress bandits. Muslims in the northwest ask for help to their school education. Gold transported from Shanghai to New York. Conspiracy of the Comintern for communist propaganda in China. A reply from Japan on the Jilin Incident. Floods in Wuhan. Bandits in Jiangxi province. Finnish people set up factory in China without licence. Wang Zhengting on the foreign affairs and the anti-Chinese movement in Mexico. Chinese in Korea experience another panic. Nanjing government appropriates funds for disaster relief. Floods in Henan province and Wuhu, of Anhui province. | China | http://trove.nla.gov.au/newspaper/page/24090543 | 24090543 | |
50755 | 50755 | 1931-10-03 | 5 | c | Japanese in Manchuria support the invasion of China. | China | http://trove.nla.gov.au/newspaper/page/24090544 | 24090544 | |
50768 | 50768 | 1931-10-03 | 8 | c | Rumours on the independence of Manchuria and Mongolia. | Japan | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
50769 | 50769 | 1931-10-03 | 8 | c | Chinese Communist Party requests to atone for their crimes by doing good deeds. | China | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
50770 | 50770 | 1931-10-03 | 8 | c | The League of Nations to discuss the Manchuria issues. | China | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
50771 | 50771 | 1931-10-03 | 8 | c | Police in Hong Kong shoot Chinese nationals. | China | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
50772 | 50772 | 1931-10-03 | 8 | c | Chinese communities in Sydney organise an association to fight Japanese and to save China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 |
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]);