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 |
---|---|---|---|---|---|---|---|---|---|
50889 | 50889 | 1931-11-21 | 2 | c | Miscellaneous report on Japanese invasion of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090605 | 24090605 | |
50890 | 50890 | 1931-11-21 | 3 | a | Special army unit organised in Hunan province to fight Japan and to save China. | China | http://trove.nla.gov.au/newspaper/page/24090604 | 24090604 | |
50891 | 50891 | 1931-11-21 | 3 | b | Miscellaneous report on Japanese invasion of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090604 | 24090604 | |
50892 | 50892 | 1931-11-21 | 5 | a | University professors in Shanghai put forward their proposal to save China. | China | http://trove.nla.gov.au/newspaper/page/24090606 | 24090606 | |
50893 | 50893 | 1931-11-21 | 5 | d | First part of a letter from Chen Jiongming to Cai Yuanpei and Zhang Xueliang. | China | http://trove.nla.gov.au/newspaper/page/24090606 | 24090606 | |
50896 | 50896 | 1931-11-21 | 6 | a-d | Guangdong news/ Murderer runs away from Guangzhou. Order to capture Du Xuantai and others. Newspaper is sealed off for publishing dissident opinions. More spies dispatched to protect Japanese nationals. Guangzhou authority check gun licences. Social security in Chaozhou and Meixian county. Troops dispatched to suppress bandits in the Beijiang area. Ministry of Finance issues new currency policy. | China | http://trove.nla.gov.au/newspaper/page/24090609 | 24090609 |
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]);