This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21170 | 21170 | 1909-06-19 | 3 | a-b | Guangdong news/ Gambling is prosperous in Guangzhou and many government officials are involved. Opium ban in Guangdong and the effect. Qualification of overseas Chinese for the rights to vote. Some government officials continue to smoke opium secretly. Portuguese people in Macao and their attitude towards the border demarcation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802221 | 26802221 | |
21183 | 21183 | 1909-06-19 | 6 | a-b | Dispute in Huizhou, Guangdong, on the cultivation of wasteland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802226 | 26802226 | |
21190 | 21190 | 1909-06-19 | 7 | a-b | Three cases of opium smuggling in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802225 | 26802225 |
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]);