This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
6810 | 6810 | 1901-01-09 | 2 | c-d | The first part of a record, prepared by editor Zheng Lu, on the grand ceremony held to celebrate the Australian commonwealth. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099910 | 24099910 | |
6811 | 6811 | 1901-01-09 | 2 | d | A man killed by a shark in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099910 | 24099910 | |
6813 | 6813 | 1901-01-09 | 2 | d | Report on the mausoleum of Indian kings. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099910 | 24099910 | |
6815 | 6815 | 1901-01-09 | 2 | e | Bandits in Xiangshan, Nanhai, Panyu and Shunde counties, Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099910 | 24099910 | |
6816 | 6816 | 1901-01-09 | 2 | e | Liu Shengsan, a local scholar in Xiangshan county, was murdered, together with all his family members. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099910 | 24099910 | |
6819 | 6819 | 1901-01-09 | 3 | a | The ban on gambling in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099909 | 24099909 | |
6826 | 6826 | 1901-01-09 | 3 | d | Timely rain in northwestern Queensland; gold exported from New Zealand; wheat transported from Melbourne to Britain; exports from Tasmania; New Zealand was impressed by Australian Commonwealth ceremony; a Queensland bank made huge profit. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099909 | 24099909 | |
6827 | 6827 | 1901-01-09 | 3 | d | The craftsman association in New South Wales asks the government not to purchase products from Chinese carpenters. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099909 | 24099909 | |
6828 | 6828 | 1901-01-09 | 3 | d | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099909 | 24099909 |
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]);