This data as json, CSV (advanced)
Suggested facets: page, column, description, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50922 | 50922 | 1931-12-05 | 2 | c | Feng Yong returns to Beijing safely and his story. | China | http://trove.nla.gov.au/newspaper/page/24090621 | 24090621 | |
50923 | 50923 | 1931-12-05 | 2 | e | Li Shizeng talks about military and administrative divisions in China again. | China | http://trove.nla.gov.au/newspaper/page/24090621 | 24090621 | |
50924 | 50924 | 1931-12-05 | 2 | e | Yan Xishan requests civil administration. Talks by Hu Hanmin. Zhang Xueliang is optimistic over the Chinese affairs. Loss of railways in Manchuria. Japanese troops in Shenyang set fire on radio station. Du Xuantai is arrested. | China | http://trove.nla.gov.au/newspaper/page/24090621 | 24090621 | |
50925 | 50925 | 1931-12-05 | 3 | a | Miscellaneous report on Japanese invasion of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090620 | 24090620 | |
50926 | 50926 | 1931-12-05 | 3 | a | Japanese factory in Hankou is closed down. | China | http://trove.nla.gov.au/newspaper/page/24090620 | 24090620 | |
50929 | 50929 | 1931-12-05 | 3 | d | Loss of Japanese businessmen in China due to the boycott. | China | http://trove.nla.gov.au/newspaper/page/24090620 | 24090620 | |
50930 | 50930 | 1931-12-05 | 3 | d | Resistance to Japanese invasion in Manchuria and the report. | China | http://trove.nla.gov.au/newspaper/page/24090620 | 24090620 | |
50931 | 50931 | 1931-12-05 | 5 | a | Third and final part of a letter from Chen Jiongming to Cai Yuanpei and Zhang Xueliang. | China | http://trove.nla.gov.au/newspaper/page/24090622 | 24090622 | |
50934 | 50934 | 1931-12-05 | 6 | c | Guangdong news/ Disputes in the Beijiang area over exorbitant taxes. Anti-Japanese movement in Guangzhou. A case of murder in Guangzhou and the investigation. Levy on the Chinese medicine in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24090625 | 24090625 | |
50935 | 50935 | 1931-12-05 | 7 | a | News from Shenyang on Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24090624 | 24090624 | |
50936 | 50936 | 1931-12-05 | 7 | b | Japanese to set up the Central Manchuria Province. | China | http://trove.nla.gov.au/newspaper/page/24090624 | 24090624 | |
50939 | 50939 | 1931-12-05 | 8 | a-c | Miscellaneous report on Japanese invasion of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090627 | 24090627 |
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]);