This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
50959 | 50959 | 1931-12-12 | 8 | b | Clash between police and civilians in Peru. | Canada | http://trove.nla.gov.au/newspaper/page/24090635 | 24090635 | |
50960 | 50960 | 1931-12-12 | 8 | b | Feng Zhanshan fights Japanese invaders. Demonstrations of students in Shanghai and Beijing. | China | http://trove.nla.gov.au/newspaper/page/24090635 | 24090635 | |
50961 | 50961 | 1931-12-12 | 8 | c | Famine in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24090635 | 24090635 | |
50962 | 50962 | 1931-12-12 | 8 | c | Epidemic disease in Perth, Western Australia, and the casualties. Huge profit of the lottery in NSW. Chinese communities in NSW organise a Fundraising Committee for Resistance to Japanese Invasion, and its regulations. Policeman is thief in Sydney. | Tung Wah | 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]);