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 |
---|---|---|---|---|---|---|---|---|---|
50901 | 50901 | 1931-11-28 | 2 | d | People in Manchuria request to abolish the Party administration and support from other areas. People in Shanghai to present their petition. Student representatives in Shanghai meet Wang Jingwei and their request. Peace talks between Guangzhou and Nanjing authorities fails to achieve success. | China | http://trove.nla.gov.au/newspaper/page/24090613 | 24090613 | |
50904 | 50904 | 1931-11-28 | 3 | d | Quite a few factories in Japan are closed down. | Japan | http://trove.nla.gov.au/newspaper/page/24090612 | 24090612 | |
50905 | 50905 | 1931-11-28 | 3 | d | Japanese international trade declines. | Japan | http://trove.nla.gov.au/newspaper/page/24090612 | 24090612 |
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]);