This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 40154 | 40154 | 1923-07-28 | 2 | c-d | Political struggle in Beijing (Li Yuanhong, Yan Huiqing, Zhang Shaozeng, Feng Yuxiang, and others). | China | http://trove.nla.gov.au/newspaper/page/24094488 | 24094488 | |
| 40155 | 40155 | 1923-07-28 | 2 | d-f | Political situation in Beijing before the flea of Li Yuanhong. | China | http://trove.nla.gov.au/newspaper/page/24094488 | 24094488 | |
| 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 | |
| 40160 | 40160 | 1923-07-28 | 6 | a | Three orders issued by Chinese President Li Yuanhong before his leaving for Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24094492 | 24094492 | |
| 40161 | 40161 | 1923-07-28 | 6 | a-b | Situation in Guangdong may have fundamental change. | China | http://trove.nla.gov.au/newspaper/page/24094492 | 24094492 | |
| 40162 | 40162 | 1923-07-28 | 6 | b | Ma Xiaojin on Sun Yatsen and the current Guangdong situation. | China | http://trove.nla.gov.au/newspaper/page/24094492 | 24094492 | |
| 40164 | 40164 | 1923-07-28 | 6 | c | Students in Jilin province promotes Chinese goods. | China | http://trove.nla.gov.au/newspaper/page/24094492 | 24094492 | |
| 40165 | 40165 | 1923-07-28 | 6 | c-d | China, America and Japan may jointly develop their radio communication. | China | http://trove.nla.gov.au/newspaper/page/24094492 | 24094492 | |
| 40177 | 40177 | 1923-07-28 | 7 | c | First part of an investigation on economic activities in China conducted by the Beijing government (the making and export of hairnet). | China | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 |
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]);