This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22449 | 22449 | 1910-03-05 | 3 | b-c | Clouds over Tibet. Chinese troops arrive in Lasa and have serious clash with local residents. Dalai Lama flees Tibet and has arrived in India. British and Indian authorities respond to crisis in Tibet. | Britain | http://trove.nla.gov.au/newspaper/page/26802543 | 26802543 | |
22457 | 22457 | 1910-03-05 | 6 | b-c | Prince Regent and the court meeting. | China | http://trove.nla.gov.au/newspaper/page/26802548 | 26802548 | |
22466 | 22466 | 1910-03-05 | 7 | b-c | An animal school in America. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802547 | 26802547 |
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]);