This data as json, CSV (advanced)
Suggested facets: page, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
801 | 801 | 1898-09-24 | 3 | a-b-c | First part of the memorial report presented by Xu Zhijing to His Majesty on the reform of Imperial Examination. | http://trove.nla.gov.au/newspaper/page/24102140 | 24102140 | ||
802 | 802 | 1898-09-24 | 3 | c | Juvenile crime, Sydney woman robbed by group of children. | http://trove.nla.gov.au/newspaper/page/24102140 | 24102140 | ||
803 | 803 | 1898-09-24 | 3 | c-d | 12-year-old mother in Zhaoqing, Guangdong. | http://trove.nla.gov.au/newspaper/page/24102140 | 24102140 | ||
804 | 804 | 1898-09-24 | 3 | d | Tornado causes flooding in India. | http://trove.nla.gov.au/newspaper/page/24102140 | 24102140 | ||
805 | 805 | 1898-09-24 | 3 | d-e | Two men from London travel by hot-air balloon. | http://trove.nla.gov.au/newspaper/page/24102140 | 24102140 | ||
806 | 806 | 1898-09-24 | 3 | e | Girl in Guangzhou works hard as man in order to make more money. | http://trove.nla.gov.au/newspaper/page/24102140 | 24102140 | ||
807 | 807 | 1898-09-24 | 3 | e-f | Rulers compete for power in same area. | http://trove.nla.gov.au/newspaper/page/24102140 | 24102140 | ||
808 | 808 | 1898-09-24 | 3 | f | Man in Sydney dies in bicycle race. | http://trove.nla.gov.au/newspaper/page/24102140 | 24102140 | ||
809 | 809 | 1898-09-24 | 3-2 | f-a | Melbourne woman hangs herself because she has nothing to eat; another woman suicides because she cannot feed her six children. | http://trove.nla.gov.au/newspaper/page/24102140 | 24102140 |
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]);