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 |
---|---|---|---|---|---|---|---|---|---|
50522 | 50522 | 1931-07-18 | 5 | e | Fighting thief and a story from Fujian province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090454 | 24090454 | |
50523 | 50523 | 1931-07-18 | 5 | e | Teacher of a private school in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090454 | 24090454 | |
50532 | 50532 | 1931-07-18 | 8 | c | Australia news/ Governor-General of Australia Sir Isaac Isaacs takes voluntary 25% reduction in salary and allowances. Lottery in New South Wales. Thief killed by the shop owner in Sydney. Chinese government sets up consulate office in Fiji with Zheng Guanlu as the acting consul. China appoints Chen Weipin new consul-general to Australia and his backgrounds. Three more taxes to be collected by the federal government. Chinese opium smokers detained in Sydney. Heavy snow in New Zealand. Another plane accident in NSW. The Savings Bank of New South Wales to be reopened. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090459 | 24090459 |
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]);