This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54632 | 54632 | 1934-10-27 | 6 | a | Prince of Britain is engaged. | Britain | http://trove.nla.gov.au/newspaper/page/24096212 | 24096212 | |
54633 | 54633 | 1934-10-27 | 6 | a | British businessman suggests to open a commercial port in north Australia. | Britain | http://trove.nla.gov.au/newspaper/page/24096212 | 24096212 | |
54634 | 54634 | 1934-10-27 | 6 | b | Earthquake in America. | America | http://trove.nla.gov.au/newspaper/page/24096212 | 24096212 | |
54635 | 54635 | 1934-10-27 | 6 | b | Centenary celebration in Melbourne. | Britain | http://trove.nla.gov.au/newspaper/page/24096212 | 24096212 | |
54636 | 54636 | 1934-10-27 | 6 | d | Australia news/ Preparations for the centenary celebration in Melbourne. Australian plane flies over the Pacific. Trams on strike in Melbourne and the solution. American warship arrives Sydney. Plane disappears in Tasmania. Flight competition in Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096212 | 24096212 |
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]);