This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39160 | 39160 | 1922-12-16 | 8 | a-c | Guangdong news/ Guangzhou municipal government wants to borrow foreign loans and the conditions. Newspaper publishing in Guangzhou. Bank notes and the trouble. Long Qingyu is captured in Beihai. Trial on the foreigner who in involved in the bomb blast. Memorial service on the death of Wu Tingfang. A man in Guangzhou leaves his wife as a pledge. Bandit Xu Shurong is shot dead in Panyu county. Strange noise in Xinhui county. Dispute over the infrastructure building in Songlong town, of Gaoyao county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094226 | 24094226 | |
39161 | 39161 | 1922-12-16 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094226 | 24094226 | |
39162 | 39162 | 1922-12-16 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094226 | 24094226 |
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]);