This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24987 | 24987 | 1911-09-16 | 2 | c | Events of diplomatic relations | China negotiates with Britain about the issue of Pianma (ppp). China negotiates with Russia the extension of their treaty. China discusses with Mexico on the issue of the killing of Chinese in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24091921 | 24091921 |
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]);