This data as json, CSV (advanced)
Suggested facets: page, column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
941 | 941 | 1898-10-15 | 3 | a-b-c | Russia increases threats towards China, possible response from China. | http://trove.nla.gov.au/newspaper/page/24102164 | 24102164 | ||
942 | 942 | 1898-10-15 | 3 | c | New Castle woman jumps into ocean. Her husband died days before. | http://trove.nla.gov.au/newspaper/page/24102164 | 24102164 | ||
943 | 943 | 1898-10-15 | 3 | c | Chinese in Windorah, Queensland, fined for kicking patrol officer; White man in Queensland sentenced for raping 12-year-old girl. | http://trove.nla.gov.au/newspaper/page/24102164 | 24102164 | ||
944 | 944 | 1898-10-15 | 3 | c-d | Adelaide man dies during tour of Victoria. | http://trove.nla.gov.au/newspaper/page/24102164 | 24102164 | ||
945 | 945 | 1898-10-15 | 3 | d-e | Ferryboat in Dongguan, Guangdong province, sinks on journey to Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102164 | 24102164 | ||
946 | 946 | 1898-10-15 | 3 | f | Troops from Russia, Britain and Germany arrive in Beijing in response to Chinese residents insulting foreigners. | http://trove.nla.gov.au/newspaper/page/24102164 | 24102164 | ||
947 | 947 | 1898-10-15 | 3 | f | His Majesty ill after taking strange red pill. | http://trove.nla.gov.au/newspaper/page/24102164 | 24102164 | ||
948 | 948 | 1898-10-15 | 3-2 | f-a | Three royal family members hurt by a diamond in Spain. | http://trove.nla.gov.au/newspaper/page/24102164 | 24102164 |
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]);