This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51547 | 51547 | 1932-05-21 | 8 | b | New president elected in France. | France | http://trove.nla.gov.au/newspaper/page/24090813 | 24090813 | |
51548 | 51548 | 1932-05-21 | 8 | c | Japanese soldiers in Manchuria kills women and children. | China | http://trove.nla.gov.au/newspaper/page/24090813 | 24090813 | |
51549 | 51549 | 1932-05-21 | 8 | c | Japanese Prime Minister is assassinated. | Japan | http://trove.nla.gov.au/newspaper/page/24090813 | 24090813 | |
51550 | 51550 | 1932-05-21 | 8 | d | The Nationalist Party government in China is utterly isolated. | China | http://trove.nla.gov.au/newspaper/page/24090813 | 24090813 | |
51551 | 51551 | 1932-05-21 | 8 | d | War clouds over Russia and Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24090813 | 24090813 | |
51552 | 51552 | 1932-05-21 | 8 | d | French mail ship on fire. | Other... | http://trove.nla.gov.au/newspaper/page/24090813 | 24090813 | |
51553 | 51553 | 1932-05-21 | 8 | d | Australia news/ Governor of New South Wales, Sir Philip Game, sacks state premier Jack Lang and the successor. Sydney city councillor attack Japanese in his speech. Astronomical observatory in Sydney predicts earthquake. Chinese Consulate-General in Australia passes messages from Wang Jingwei to the Australian Chinese communities. Advertisements for Neptune Products, lolly company T. A. MacLeod and Beresford F. Daley glasses in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090813 | 24090813 |
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]);