This data as json, CSV (advanced)
Suggested facets: date, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
4404 | 4404 | 1900-01-10 | 2 | e | A man in Dunedin, New Zealand, was charged with murdering his wife. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102667 | 24102667 | |
4408 | 4408 | 1900-01-10 | 2 | f | The gold production of New Zealand | New Zealand | http://trove.nla.gov.au/newspaper/page/24102667 | 24102667 | |
4409 | 4409 | 1900-01-10 | 2 | f | A man in New Zealand charged with forging stamps. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102667 | 24102667 | |
4503 | 4503 | 1900-01-24 | 2 | f | A woman in Auckland, New Zealand, poisoned her baby after eating too much cheese. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102683 | 24102683 | |
4640 | 4640 | 1900-02-28 | 2 | d | A man in New Zealand commits suicide after losing in gambling. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102714 | 24102714 | |
4714 | 4714 | 1900-03-10 | 2 | c | A big shop in Auckland, New Zealand, was destroyed in a fire. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102727 | 24102727 | |
4721 | 4721 | 1900-03-10 | 2 | d | A Chinese was beaten to death in New Zealand and the murderer has not been found. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102727 | 24102727 | |
4906 | 4906 | 1900-04-07 | 2 | d | A girl in New Zealand drowned trying to save her brother. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102759 | 24102759 | |
5296 | 5296 | 1900-05-23 | 2 | f | Two Maoris in New Zealand died on their friend's wedding. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102812 | 24102812 | |
5465 | 5465 | 1900-06-13 | 2 | e | All old people in New Zealand are entitled to receive pensions from the government except for Chinese. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102838 | 24102838 | |
5844 | 5844 | 1900-08-15 | 2 | d | Eighteen people in Wellington, New Zealand, drowned while touring a river. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102908 | 24102908 | |
6213 | 6213 | 1900-10-03 | 2 | e | New Zealand wants to govern other British island colonies in the Pacific. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102969 | 24102969 | |
8865 | 8865 | 1901-10-19 | 2 | e | New Zealand considers boycotting imports from Australia. | New Zealand | http://trove.nla.gov.au/newspaper/page/24100201 | 24100201 | |
36931 | 36931 | 1921-05-07 | 2 | a-b | Christianity and Confucianism, written by Branden, New Zealand legal expert and former mayor of Wellington, and translated by Lin Shiyuan, Chinese consul in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24093533 | 24093533 | |
47816 | 47816 | 1929-02-16 | 2 | d | Chinese Consulate-General in New Zealand in shortage of money. | New Zealand |
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]);