This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
16659 | 16659 | 1906-12-29 | 6 | a-b | A letter from anonymous author in Queensland rebukes Chinese profiteer for selling tobacco & opium illegally. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801179 | 26801179 | |
16660 | 16660 | 1906-12-29 | 6 | b-c | A survey on the three northeast province: Heilongjiang, Jilin and Fengtian (Liaoning), including Dalian Bay, Yingkou, Liaoyang, Fengtian, Tianjin, and Fengcheng, such as population, business opportunity, etc. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801179 | 26801179 | |
16661 | 16661 | 1906-12-29 | 6 | c | Names listed for shareholders in Australia of the National Daily (guo shi ri bao), published in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801179 | 26801179 | |
16662 | 16662 | 1906-12-29 | 6 | c | Correction to the report in last issue on Australian federal election, the folk song on opium ban as well as the notice to build headquarters of the Chinese Empire Reform Association in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801179 | 26801179 |
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]);