This data as json, CSV (advanced)
Suggested facets: page, column, 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 | |
50260 | 50260 | 1931-05-02 | 5 | c | A miser and his story. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090366 | 24090366 | |
50261 | 50261 | 1931-05-02 | 5 | d | A story of cheating and marriage. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090366 | 24090366 | |
50262 | 50262 | 1931-05-02 | 5 | d | First part of story of Liu Jie. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090366 | 24090366 | |
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]);