This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42657 | 42657 | 1925-01-24 | 8 | a-d | Guangdong news/ Sun Yatsen speaks to the cadets in Huangpu before leaving for Beijing. Both Hu Hanmin and Li Fulin want to resign. Fan Shisheng to lead his army back to Yunnan. Exorbitant taxes and levies in Guangzhou. Deng Benyin urges Chen Jiongming to lead the troops. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101017 | 24101017 | |
42658 | 42658 | 1925-01-24 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101017 | 24101017 | |
42659 | 42659 | 1925-01-24 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101017 | 24101017 |
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]);