This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
35873 | 35873 | 1920-07-03 | 6 | a-b | Chinese Ministry of Agriculture and Industry proposes to issue new industrial bonds, their report to the President, and their letter to the New South Wales Chinese Chamber of Commerce. | China | http://trove.nla.gov.au/newspaper/page/24098225 | 24098225 | |
35875 | 35875 | 1920-07-03 | 7 | a-b | Australia news/ Prince Edward is on the way to Western Australia. Twenty-two Chinese are penalised in Sydney for gambling. Thieves in Sydney like to steal from clothes shops at the moment. Shortage of sugar in Sydney. Heavy rain in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098224 | 24098224 |
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]);