This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18460 | 18460 | 1907-11-16 | 2 | a-b | An article written by anonymous author claims that unhygienic life style helps Chinese people to be conquered. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801540 | 26801540 | |
18465 | 18465 | 1907-11-16 | 3 | a-b | Guangdong news. Two revolutionary bandit leaders in Qinxian county, Liang Er and Lai Defei, confess they are followers of Sun Yatsen. Market survey in Foshan. New governor Zhang Renjun appoints Wei Han and Wen Zongyao to be in charge of all foreign affairs in Guangdong. Li Dao reports to governor Zhang Renjun situations in Qinxian county. Board of Revenue in Beijing urges Guangdong customs to pay their dues. Report on celebrations in Guangzhou on the birthday of Confucius. Dozens of people are detained in Guangzhou for illegal opium smoking and their names listed. Guangzhou magistrate to ban all gambling and opium smoking in Xinhui and other counties. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801539 | 26801539 | |
18478 | 18478 | 1907-11-16 | 6 | a-b | Second part of the report submitted by Duan Fang on the abolition of the boundary between Manchurian and Han people. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801544 | 26801544 | |
18487 | 18487 | 1907-11-16 | 7 | a-b | Detailed report on the fighting between Xiangshan and Siyi (See Yip) fellows in Melbourne and involvement of Li Bao, Liu Zu, Hong Rongji, Lin Tianhui, Chen Tang, Chen Rong, He Nan, Gao Heshun, Yang Gengwu, Li Ge, Li Xing, and others. Comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801543 | 26801543 |
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]);