This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18092 | 18092 | 1907-09-14 | 2 | b-c | Report. Heroine Qiu Jin and her story, written by Wu Zhiying. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801468 | 26801468 | |
18098 | 18098 | 1907-09-14 | 3 | b-c | Guangdong news. A further report on the license system for opium smoking (all addicts are required to apply for licence). Government authority supports civilian association to ban opium trade and smoking. Guangdong has a quit-opium-smoking company and report on the opening ceremony. Army school and other students in Guangzhou are not allowed to cut hair. Guangdong authority tries to promote local self-government. Fares for the first part of the Guangzhou-Hankou railway from Huangsha to Jiangcun. A hotel collapses in Hong Kong and first report on the casualties. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801467 | 26801467 | |
18112 | 18112 | 1907-09-14 | 6 | b-c | A detailed report on the ban-opium parade in Guangzhou, organised by Guangzhou quit-opium-smoking association. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801472 | 26801472 | |
18127 | 18127 | 1907-09-14 | 7 | b-c | The Tangye Oil Engine is in great demand in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801471 | 26801471 | |
18133 | 18133 | 1907-09-14 | 8 | b-c | A reply from the Beijing ministry of communications to Zhang Zhidong regarding the commercialisation and nationalisation of railway project. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801474 | 26801474 |
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]);