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 |
---|---|---|---|---|---|---|---|---|---|
51536 | 51536 | 1932-05-21 | 2 | d | Chinese National Crisis Association (guo nan hui) issues an open letter to the army officers and soldiers. | China | http://trove.nla.gov.au/newspaper/page/24090808 | 24090808 | |
51537 | 51537 | 1932-05-21 | 2 | d | Japanese foreign minister says they would not give up Manchuria. | France | http://trove.nla.gov.au/newspaper/page/24090808 | 24090808 | |
51542 | 51542 | 1932-05-21 | 3 | d | Telegram from Wu Peifu to Panchen Lama on the Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24090807 | 24090807 | |
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]);