This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22275 | 22275 | 1910-01-15 | 7 | a | Income of Australian post office in the second half of 1909. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802461 | 26802461 | |
22276 | 22276 | 1910-01-15 | 7 | a | More boycotts of Chinese shops in Bendigo, Victoria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802467 | 26802467 | |
22277 | 22277 | 1910-01-15 | 7 | a | Commonwealth government of Australia plans to build dockyard and naval base. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802467 | 26802467 | |
22278 | 22278 | 1910-01-15 | 7 | a | Earthquake in Bathurst, New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802467 | 26802467 | |
22279 | 22279 | 1910-01-15 | 7 | a | Attorney general of New South Wales dies. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802467 | 26802467 | |
22280 | 22280 | 1910-01-15 | 7 | a | British military commander Lord Kitchener leaves Sydney for Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802467 | 26802467 | |
22281 | 22281 | 1910-01-15 | 7 | a | Perth to have an exhibition on manufacturing technology. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802467 | 26802467 |
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]);