This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18179 | 18179 | 1907-09-28 | 2 | a-b | Report written by Kang Youwei on his meeting and talks with President of Mexico. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801484 | 26801484 | |
18184 | 18184 | 1907-09-28 | 3 | a-b | Guangdong news. Guangdong authority to increase tariff levy. A case of superstition and the disasters that followed. Guangdong students in Germany have excellent performance. A survey and the report on opium smoking in Guangzhou. Nearly 3,000 opium addicts in Guangzhou register to quit smoking. Two restaurants destroy all smoking paraphernalia and advise customers not to smoking. New governor Zhang Renjun and his entourage. Report on the military medical school in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801483 | 26801483 | |
18201 | 18201 | 1907-09-28 | 7 | a-b | Two Chinese in Sydney are penalised for illegally selling opium. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801487 | 26801487 | |
18211 | 18211 | 1907-09-28 | 8 | a-b | A public letter from Chinese Constitutional Reform Society in Tokyo (dongjing zhongguo jiang xi xian zheng hui). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801490 | 26801490 |
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]);