This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25331 | 25331 | 1911-11-25 | 8 | a | Report on riots in Hubei | A comprehensive report on riots in Hubei province. | Other... | http://trove.nla.gov.au/newspaper/page/24092016 | 24092016 |
25332 | 25332 | 1911-11-25 | 8 | a-b | Mongolia establishes close relationship with Russia | Mongolia established close relationship with Russia. | Other... | http://trove.nla.gov.au/newspaper/page/24092016 | 24092016 |
25333 | 25333 | 1911-11-25 | 8 | b | Travel notes | An American insurance company insures couples for temporary separation. | Other... | http://trove.nla.gov.au/newspaper/page/24092016 | 24092016 |
25334 | 25334 | 1911-11-25 | 8 | b-c | Miscellousness | Russia has lots of spies in China. | Other... | http://trove.nla.gov.au/newspaper/page/24092016 | 24092016 |
25335 | 25335 | 1911-11-25 | 8 | c | Tittle-tattle | Comments on 'new four classic books'. | Other... | http://trove.nla.gov.au/newspaper/page/24092016 | 24092016 |
25336 | 25336 | 1911-11-25 | 8 | c | A satire poem | A satire poem on minister for transport. | Other... | http://trove.nla.gov.au/newspaper/page/24092016 | 24092016 |
25337 | 25337 | 1911-11-25 | 8 | c-d | Proses | Several proses on various topics. | Other... | http://trove.nla.gov.au/newspaper/page/24092016 | 24092016 |
25338 | 25338 | 1911-11-25 | 8 | d | Notice of Chinese Consulate General to Australia | Chinese Consulate General to Australia issued its notice about its note to Tasmanian government and a reply from Tasmanian government over the case of killing of a Chinese in Tasmania. (continues on page 6) | Other... | http://trove.nla.gov.au/newspaper/page/24092016 | 24092016 |
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]);