This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
49720 | 49720 | 1930-11-22 | 5 | a | Hong Kong news/ A film studio to be organised in Hong Kong. Chen Lianbo on the Nanyang Brothers' Tobacco Company. Chen Botao dies in Hong Kong. Progress of connecting Guangzhou and Hong Kong by long distance telephone communications. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099855 | 24099855 | |
49730 | 49730 | 1930-11-22 | 8 | b | Pirates hijack ships near Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099860 | 24099860 |
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]);