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 |
---|---|---|---|---|---|---|---|---|---|
8659 | 8659 | 1901-09-28 | 2 | d | Story of Empress Dowager's relatives. | China | http://trove.nla.gov.au/newspaper/page/24100177 | 24100177 | |
8660 | 8660 | 1901-09-28 | 2 | d | Fortification in the foreign embassies in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24100177 | 24100177 | |
8661 | 8661 | 1901-09-28 | 2 | d | Dozens of French soldiers harassed the East Tombs of Qing dynasty. | China | http://trove.nla.gov.au/newspaper/page/24100177 | 24100177 | |
8662 | 8662 | 1901-09-28 | 2 | d | Hubei province paid its shares of national revenue. | China | http://trove.nla.gov.au/newspaper/page/24100177 | 24100177 | |
8663 | 8663 | 1901-09-28 | 2 | d | Xi'an news about expenditure of the temporary lodge. | China | http://trove.nla.gov.au/newspaper/page/24100177 | 24100177 | |
8664 | 8664 | 1901-09-28 | 2 | d | Russian in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24100177 | 24100177 | |
8665 | 8665 | 1901-09-28 | 2 | d | An American bishop comments on the missionary cases in China. | Australia | http://trove.nla.gov.au/newspaper/page/24100177 | 24100177 | |
8684 | 8684 | 1901-09-28 | 3 | d | A girl in Melbourne was compensated for defamation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100176 | 24100176 | |
8685 | 8685 | 1901-09-28 | 3 | d | Two prisoners in Adelaide escaped and now on the run. | Australia | http://trove.nla.gov.au/newspaper/page/24100176 | 24100176 | |
8686 | 8686 | 1901-09-28 | 3 | d | Flooding in Xi'an and the Empress has decided to leave within days. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100176 | 24100176 | |
8687 | 8687 | 1901-09-28 | 3 | d | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100176 | 24100176 |
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]);