This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30467 | 30467 | 1915-09-18 | 2 | a-b | Important issue/ Chinese council general reports the situation of business and trade between China and Australia to Chinese Agriculture and Business Ministry as China is to promote national industries and expects to export more goods to Australia. | Other... | http://trove.nla.gov.au/newspaper/page/24094987 | 24094987 | |
30477 | 30477 | 1915-09-18 | 3 | c | Battle situation in east Europe between Russian, German and Austrian troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094986 | 24094986 |
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]);