This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
44740 | 44740 | 1926-05-15 | 7 | b-d | Australia news/ Some big department stores in Sydney are closed down or for sale. Fundraising for Sydney hospitals. Police arrest a thief who steals from a Chinese garden in Sydney. Timely rain in Queensland after a long drought. A Western scholar speaks in Sydney on ancient and modern China. Prices of milk and bread are going up in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101561 | 24101561 | |
44741 | 44741 | 1926-05-15 | 7 | d | A Norwegian explorer on the way to the North Pole. | Britain | http://trove.nla.gov.au/newspaper/page/24101561 | 24101561 | |
44742 | 44742 | 1926-05-15 | 7 | d | Strike in Britain and the report. | Britain | http://trove.nla.gov.au/newspaper/page/24101561 | 24101561 | |
44743 | 44743 | 1926-05-15 | 7 | d-f | Miscellaneous report on the political changes in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24101561 | 24101561 | |
44744 | 44744 | 1926-05-15 | 7 | f | Social custom in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101561 | 24101561 |
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]);