This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
72 | 72 | 1898-07-06 | 3 | c | Sydney, two friends play with guns, one killed. | http://trove.nla.gov.au/newspaper/page/24102052 | 24102052 | ||
73 | 73 | 1898-07-06 | 3 | c | Buddhist monk in a Guangzhou temple talks about current political situation | http://trove.nla.gov.au/newspaper/page/24102052 | 24102052 | ||
74 | 74 | 1898-07-06 | 3 | c | colourful clouds, strange omen, in a temple in Fujian Province | http://trove.nla.gov.au/newspaper/page/24102052 | 24102052 | ||
97 | 97 | 1898-07-06 | 4 | c | Sea. Pirates near Huizhou rob dozens of ship. | http://trove.nla.gov.au/newspaper/page/24102049 | 24102049 | ||
98 | 98 | 1898-07-06 | 4 | c | Beautiful woman in Melbourne dies before marrying. | http://trove.nla.gov.au/newspaper/page/24102049 | 24102049 | ||
99 | 99 | 1898-07-06 | 4 | c | Seven Chinese in Melbourne penalised for gambling. | http://trove.nla.gov.au/newspaper/page/24102049 | 24102049 |
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]);