This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39784 | 39784 | 1923-04-28 | 3 | c | Gu Zhongxiu on the redeem of the railway from Qingdao to Jinan. | China | http://trove.nla.gov.au/newspaper/page/24094383 | 24094383 | |
39801 | 39801 | 1923-04-28 | 7 | c | News in brief/ Zhang Shaozeng telegrams Cao Kun and Wu Peifu on the chaos in Guangdong and Fujian. Li Yuanhong and the Zhang Shaozeng cabinet. Chinese foreign minister on the return of Lushun and Dalian. A conference in Luoyang, Henan province, is attended by major warlords in China. American government responds to China's abrogation of the Twenty-one Demands. Wu Peifu provides weapons to Shen Hongying. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094387 | 24094387 |
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]);