This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41122 | 41122 | 1924-02-09 | 19 | a | Photograph of the Chinese ladies who assisted at the Chinese Festival Night, in the Sydney Town Hall, on December 15, 1923, in aid of the Royal Prince Alfred Hospital, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100615 | 24100615 | |
41123 | 41123 | 1924-02-09 | 19 | b | New oil well found in Queensland. | Australia | http://trove.nla.gov.au/newspaper/page/24100615 | 24100615 | |
41124 | 41124 | 1924-02-09 | 19 | b | Japanese naval fleet is on the way to New Zealand after a visit in Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24100615 | 24100615 | |
41125 | 41125 | 1924-02-09 | 19 | b | A policeman is detained in Sydney for sexual harassment. | Australia | http://trove.nla.gov.au/newspaper/page/24100615 | 24100615 | |
41126 | 41126 | 1924-02-09 | 19 | b | Military officer in Guangdong and the withholding of tariff income. | China | http://trove.nla.gov.au/newspaper/page/24100615 | 24100615 | |
41127 | 41127 | 1924-02-09 | 19 | b | Advertisement for Wing Tiy & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100615 | 24100615 |
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]);