This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39317 | 39317 | 1923-01-27 | 2 | b-d | Wu Jinglian tries to control China's politics and his plot. | China | http://trove.nla.gov.au/newspaper/page/24094268 | 24094268 | |
39347 | 39347 | 1923-01-27 | 8 | b-d | Guangdong news/ Election in Guangzhou of the legislature assembly members. Li Ruihua is executed in Guangzhou. A kidnap in Guangzhou and the ransom. Military conference to be held in Wuzhou. Supervisor appointed for the support to Fujian province. Bandits in Zhaoqing hijack two ferries. Court hearing organised for the bomb attack in Guangzhou. Guerrilla fighting in Qianshan near Macao. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094274 | 24094274 |
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]);