This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50900 | 50900 | 1931-11-28 | 2 | b | On the resistance to Japanese invasion of Manchuria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090613 | 24090613 | |
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 |
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]);