This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32480 | 32480 | 1917-07-21 | 2 | c-e | A circular telegram issued by Chinese President Li Yuanhong on the current political situations. | China | http://trove.nla.gov.au/newspaper/page/24095769 | 24095769 | |
32497 | 32497 | 1917-07-21 | 8 | c-e | Guangdong news/ Chen Bingkun, Tan Haoming and Li Liejun jointly send telegram to Beijing and urge to suppress rebellions. Telegram from Tang Jiyao in Yunnan to Tan Haoming in Guangzhou. Telegram from Tan Yankai in Hunan to Lu Rongting in Guangxi. Chen Bingkun convenes a meeting in Guangzhou on the rebellions in Beijing. Flood in Zhaoqing. | China | http://trove.nla.gov.au/newspaper/page/24095775 | 24095775 |
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]);