This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33819 | 33819 | 1918-11-16 | 6 | a-b | A circular telegram issued by Chinese President Feng Guozhang to resign. | China | http://trove.nla.gov.au/newspaper/page/24097506 | 24097506 | |
33823 | 33823 | 1918-11-16 | 8 | a-b | Beijing news/ Xu Shichang denies any imperial restoration. Beijing students go to study at Hong Kong university. Tang Hualong's coffin is on the way to China. Cheng Qian is killed in Hunan. Hu Jingyi, military commander in Shaanxi province, is under arrest. Opera actors in Beijing avoid the name of new president. A local scholar in Fuzhou, Fujian province, and the marriage of his daughter. Xu Shichang engages Liang Qichao as political adviser. | China | http://trove.nla.gov.au/newspaper/page/24097508 | 24097508 |
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]);