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 |
---|---|---|---|---|---|---|---|---|---|
18136 | 18136 | 1907-09-21 | 2 | a | Books for sale from the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801476 | 26801476 | |
18161 | 18161 | 1907-09-21 | 7 | a | An effective prescription to quit opium smoking, provided by anonymous reader. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801479 | 26801479 | |
18162 | 18162 | 1907-09-21 | 7 | a | Newly-elected parliament of New South Wales will sit on October 2. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801479 | 26801479 | |
18163 | 18163 | 1907-09-21 | 7 | a | Number of Japanese in Australia and their distribution. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801479 | 26801479 | |
18164 | 18164 | 1907-09-21 | 7 | a | Japanese government appoints new consul to Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801479 | 26801479 | |
18165 | 18165 | 1907-09-21 | 7 | a | Police in Western Australia seize opium in Chinese residential place in Perth, Freemantle and Geraldton. And comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801479 | 26801479 | |
18166 | 18166 | 1907-09-21 | 7 | a | Sydney police seize opium smuggled in a cargo liner from China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801479 | 26801479 | |
18167 | 18167 | 1907-09-21 | 7 | a | Premier of Victoria suggests for higher traffic speed in Melbourne as time is money. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801479 | 26801479 | |
18168 | 18168 | 1907-09-21 | 7 | a | Business links between Australian and Southeast Asian countries. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801479 | 26801479 |
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]);