This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42250 | 42250 | 1924-10-25 | 8 | a-d | Guangdong news/ Sun Yatsen flees Shaoguan and has arrived Guangzhou. A new government to be organised in the southwest. Obstacles to Hu Hanmin's attempt to be the governor of Guangdong. Fan Shisheng disapproves Li Fulin to be the mayor of Guangzhou. The move of Yunnan army in Guangdong. Orders issued by Sun Yatsen on his departure for the North Expedition. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100911 | 24100911 | |
42251 | 42251 | 1924-10-25 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100911 | 24100911 | |
42252 | 42252 | 1924-10-25 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100911 | 24100911 |
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]);