This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50956 | 50956 | 1931-12-12 | 7 | a | Japanese war planes twice bomb Jinzhou, of Liaoning province, and the first part of a survey on the casualties. | China | http://trove.nla.gov.au/newspaper/page/24090632 | 24090632 | |
50958 | 50958 | 1931-12-12 | 8 | a | The League of Nations and Japanese invasion of Manchuria. Puyi under house arrest by Japanese. Chinese and Japanese armies are preparing for war. Japanese to take over Jinzhou, Liaoning province. Shi Zhaoji and Gu Weijun during the national crisis. Demonstration of students in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24090635 | 24090635 |
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]);