This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26958 | 26958 | 1913-02-08 | 2 | c-d | Effects of Mongolian issue. | Other... | http://trove.nla.gov.au/newspaper/page/24092569 | 24092569 | |
26976 | 26976 | 1913-02-08 | 3 | c-d | Guangdong news/ Governor withdraws ban on money limits. Heilongjiang army vows to fight against Russia. Patriot calls for unity to save China. Civil Affairs Ministry notes no foreigners allowed to survey in China. Enping area, Guangdong looted by robbers. | Other... | http://trove.nla.gov.au/newspaper/page/24092568 | 24092568 |
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]);