This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54626 | 54626 | 1934-10-27 | 2 | a | Editorial on the bookish and corrupt Chinese officials. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096206 | 24096206 | |
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]);