This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
37846 | 37846 | 1921-11-12 | 6 | a | The financial report submitted by New Zealand government to the parliament. | New Zealand | http://trove.nla.gov.au/newspaper/page/24093755 | 24093755 | |
37849 | 37849 | 1921-11-12 | 7 | a | Oil drilling in New South Wales and the prospect. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093754 | 24093754 | |
37850 | 37850 | 1921-11-12 | 7 | a | A motorbike in Sydney runs over a man and kills him. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093754 | 24093754 | |
37851 | 37851 | 1921-11-12 | 7 | a | A burglary in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093754 | 24093754 | |
37852 | 37852 | 1921-11-12 | 7 | a | New South Wales government takes every precaution against the plague. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093754 | 24093754 | |
37853 | 37853 | 1921-11-12 | 7 | a | Bush fire near Dubbo and Gilgandra in New South Wales burns over 30,000 acres farm. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093754 | 24093754 | |
37861 | 37861 | 1921-11-12 | 8 | a | Fiction/ A sad woman, part IX (final section). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093757 | 24093757 |
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]);