This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40156 | 40156 | 1923-07-28 | 3 | a-b | Effort to topple Li Yuanhong in Beijing and the political conspiracy. Correspondence between different power groups (Gao Lingwei and five others resign, telegram to Zhang Shaozeng in Tianjin, Wang Chengbin to Li Yuanhong, Qi Xieyuan's circular telegram). | China | http://trove.nla.gov.au/newspaper/page/24094487 | 24094487 | |
40157 | 40157 | 1923-07-28 | 3 | c-d | Li Yuanhong issues a circular telegram which says that he is forced to abdicate. | China | http://trove.nla.gov.au/newspaper/page/24094487 | 24094487 | |
40158 | 40158 | 1923-07-28 | 3 | d-e | Japanese businessmen in Shanghai seek to stop the boycott to Japanese goods. | China | http://trove.nla.gov.au/newspaper/page/24094487 | 24094487 | |
40159 | 40159 | 1923-07-28 | 3 | e | Foreign diplomats in Beijing on the possible cooperation between Zhang Zuolin, Wu Peifu and Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24094487 | 24094487 |
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]);