This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
55287 | 55287 | 1935-07-27 | 2 | f | Transportation in Guizhou province. Qin Dechun returns to Chaha'er. Exhibition of air defence equipment in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24096513 | 24096513 | |
55304 | 55304 | 1935-07-27 | 8 | f | Australia news/ Celebrations in Sydney for the 150th anniversary of the city. Queensland may restrict banana growing. Japanese man is on trial in Sydney for drug smuggling. Bandits in Sydney rob jewellery shop. Sand storm in South Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096519 | 24096519 |
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]);