This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
949 | 949 | 1898-10-15 | 2 | a | Japanese man in Queensland charged for murdering another Japanese man. Brother of American First Lady killed on street. | http://trove.nla.gov.au/newspaper/page/24102163 | 24102163 | ||
950 | 950 | 1898-10-15 | 2 | a-b | Girl sustains burns after her clothes caught fire. | http://trove.nla.gov.au/newspaper/page/24102163 | 24102163 | ||
951 | 951 | 1898-10-15 | 2 | b | Sydney builds new tramway to be completed next March. | http://trove.nla.gov.au/newspaper/page/24102163 | 24102163 | ||
952 | 952 | 1898-10-15 | 2 | b-c | Man's confession about visits to prostitutes. | http://trove.nla.gov.au/newspaper/page/24102163 | 24102163 | ||
953 | 953 | 1898-10-15 | 2 | c | Two men detained for stealing a cow in NSW. | http://trove.nla.gov.au/newspaper/page/24102163 | 24102163 | ||
954 | 954 | 1898-10-15 | 2 | c-d | Three women drown in South Australia. | http://trove.nla.gov.au/newspaper/page/24102163 | 24102163 | ||
955 | 955 | 1898-10-15 | 2 | d-e | Female criminal in San Francisco. | http://trove.nla.gov.au/newspaper/page/24102163 | 24102163 | ||
956 | 956 | 1898-10-15 | 2 | e-f | Advantages and disadvantages of new ferry service from Foshan to Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102163 | 24102163 | ||
957 | 957 | 1898-10-15 | 2 | f | Nightmare involving prostitute frightens away thief in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102163 | 24102163 |
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]);