This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39594 | 39594 | 1923-03-10 | 8 | a-d | Guangdong news/ Wei Bangping orders troops to move out civil residence. Zhang Kairu will not interfere with local administration. Candidates for the provincial governor. Huang Hongyou and Liu Daqing are executed. Local transportation is still on pause. Police forces to be reorganised. Gu Renguang becomes head of the police forces in Guangzhou. Guangzhou welcomes Sun Yatsen. Yunnan army seals up civil residence. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094333 | 24094333 | |
39595 | 39595 | 1923-03-10 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094333 | 24094333 | |
39596 | 39596 | 1923-03-10 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094333 | 24094333 |
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]);