This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40117 | 40117 | 1923-07-14 | 8 | b-d | Guangdong news/ A charity hospital in closed in Guangzhou. Government troops can not protect local residents. Guangdong army takes over Chaozhou and Shantou. City wall to be demolished in Zhaoqing for the disaster relief. Li Liejun shoots dead a envoy from Hong Zhaolin. Shen Rongguang escapes to Wuzhou. Ammunition depot near Sun Yatsen's headquarters is destroyed. Li Fulin reports from Shantou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094478 | 24094478 |
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]);