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 |
---|---|---|---|---|---|---|---|---|---|
50250 | 50250 | 1931-05-02 | 2 | b | First part of editorial on the negotiations between China and Japan over the Manchurian railways. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090365 | 24090365 | |
50254 | 50254 | 1931-05-02 | 3 | b | Disasters of communism, banditry and opium in Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24090364 | 24090364 | |
50264 | 50264 | 1931-05-02 | 8 | b | A Spanish warship defects under the instigation of communists. | Britain | http://trove.nla.gov.au/newspaper/page/24090371 | 24090371 | |
50265 | 50265 | 1931-05-02 | 8 | b | America recognises new government of Spain. | America | http://trove.nla.gov.au/newspaper/page/24090371 | 24090371 | |
50266 | 50266 | 1931-05-02 | 8 | b | American missionary is kidnapped in Hubei, China. | China | http://trove.nla.gov.au/newspaper/page/24090371 | 24090371 | |
50267 | 50267 | 1931-05-02 | 8 | b | American government increases charges of some services including air mail. | America | http://trove.nla.gov.au/newspaper/page/24090371 | 24090371 | |
50268 | 50268 | 1931-05-02 | 8 | b | Australia news/ Arsonist arrested in Sydney. A mail bomb in Sydney. Tram accident in Sydney. Earthquake in New Zealand. NSW state government repays debts to Britain. Another reduction of salary payment in Australia. The Savings Bank of New South Wales is closed down. Communist members make trouble in a government meeting. Heavy rains in the west of NSW. Two bodies found in NSW. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090371 | 24090371 |
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]);