This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50441 | 50441 | 1931-06-27 | 3 | a | Zou Lu on the Party and other political affairs. | China | http://trove.nla.gov.au/newspaper/page/24090428 | 24090428 | |
50442 | 50442 | 1931-06-27 | 3 | a | Tibet troops approach Xikang. | China | http://trove.nla.gov.au/newspaper/page/24090428 | 24090428 | |
50448 | 50448 | 1931-06-27 | 5 | a | Hong Kong news/ University of Hong Kong has secured some of the Boxer Indemnity refunded by Britain. Changes of value of the Hong Kong currency. Hong Kong government formally denies any introduction of gold standard system. Police fight pirates. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090430 | 24090430 |
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]);