This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39964 | 39964 | 1923-06-09 | 8 | a-d | Guangdong news/ Yang Ximin orders troops to stop looting. Appointment from Beijing government on the military commandership in Guangdong. Guangdong students request for abrogation of the Twenty-one Demands. Yang Kunru urges Yao Yuping to return to Huizhou. Precautions against Li Yaohan and Shen Baofan in Jiangmen. Shen Hongying's army takes over Qingyuan county town. Sun Yatsen takes back Jianggu cruiser. Rumours on the truce in the front line. Young men in Guangzhou are forced to join the army. Sun Ke to set up a technical training institute for women in Guangzhou. Female government employee Ma Ruying in Guangzhou. Song Qingling arrives Guangzhou. Panic in Shiqi town, Xiangshan county. More troops arrive Shaozhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094438 | 24094438 | |
39965 | 39965 | 1923-06-09 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094438 | 24094438 | |
39966 | 39966 | 1923-06-09 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094438 | 24094438 |
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]);