This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 18169 | 18169 | 1907-09-21 | 7 | b | Big fire in Murwillumbah and Bangalow, north New South Wales, razes the two towns to the ground. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801479 | 26801479 | |
| 18170 | 18170 | 1907-09-21 | 7 | b | Chinese in Melbourne submit a petition to the state parliament of Victoria which requests lifting restrictions on Chinese employment. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801479 | 26801479 | |
| 18171 | 18171 | 1907-09-21 | 7 | b | Rumours in Sydney say Belmore Market will be moved to another place but the city council says no. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801479 | 26801479 | |
| 18172 | 18172 | 1907-09-21 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801479 | 26801479 | |
| 18173 | 18173 | 1907-09-21 | 7 | c | Timetable of ocean liners. | 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]);