This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
44990 | 44990 | 1926-07-24 | 8 | a-d | Guangdong news/ Zhao Hengti asks Jiang Jieshi to withdraw his troops. Li Jishen in Guangzhou. Wu Tiecheng under house arrest. The whereabouts of Wang Jingwei. Jiang Jieshi forces military police to join the Northern Expedition. Funeral of the mother of Cai Chang, Cai Xing and Cai Cong. Silk industry in Xiangshan county. Bandits on the border of Xiangshan and Xinhui county. Another clan fighting in Dongguan county. | China | http://trove.nla.gov.au/newspaper/page/24101646 | 24101646 | |
44991 | 44991 | 1926-07-24 | 8 | e | Gold price in Hong Kong. Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101646 | 24101646 |
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]);