This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21588 | 21588 | 1909-09-04 | 3 | b-d | Guangdong news/ Representative of Chinese government Gao Er'qian reports the border demarcation on Macao. Local election in Xinning county and the result. Local elections in Nanhai, Conghua, Xiangshan, Huaxian, Heshan, Dong'an, Zengcheng, Haiyang, and Chenghai counties. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802311 | 26802311 |
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]);