This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41909 | 41909 | 1924-08-02 | 8 | a-d | Guangdong news/ New progress of the reconciliation between Sun Yatsen and Chen Jiongming. Guangdong officer He Chengrui pretends to be ill after being defeated. Mutiny troops are to be captured. Foreign missions in Guangzhou protest for the bomb blast in Shamian. Members of Guomindang Zhang Ji and Xie Chi question Borodin in Guangzhou. Flood in Zengcheng and Panyu county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100815 | 24100815 | |
41910 | 41910 | 1924-08-02 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100815 | 24100815 | |
41911 | 41911 | 1924-08-02 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100815 | 24100815 |
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]);