This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
50269 | 50269 | 1931-05-02 | 8 | e | A notice for tea party by the Chinese Chamber of Commerce in Sydney. | 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]);