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 |
|---|---|---|---|---|---|---|---|---|---|
| 39540 | 39540 | 1923-03-03 | 2 | b-c | Political priorities in Beijing: organisation of the cabinet, national unification, and conflict between different political groups. | China | http://trove.nla.gov.au/newspaper/page/24094319 | 24094319 | |
| 39541 | 39541 | 1923-03-03 | 2 | c-d | Fighting in the senate in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24094319 | 24094319 | |
| 39542 | 39542 | 1923-03-03 | 2 | d-f | Luo Wengan is arrested in Beijing for the second time. | China | http://trove.nla.gov.au/newspaper/page/24094319 | 24094319 | |
| 39543 | 39543 | 1923-03-03 | 2-3 | f-a | Zhang Shaozeng sends envoys to meet Sun Yatsen in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24094319 | 24094319 | |
| 39544 | 39544 | 1923-03-03 | 3 | a-b | Duan Qirui replies to Zhang Shaozeng for his inquiry on current situation in China. | China | http://trove.nla.gov.au/newspaper/page/24094318 | 24094318 | |
| 39545 | 39545 | 1923-03-03 | 3 | b | Negotiation between China and Britain over the return of Weihaiwei has broken down. | China | http://trove.nla.gov.au/newspaper/page/24094318 | 24094318 | |
| 39547 | 39547 | 1923-03-03 | 3 | b-c | Members of the Chinese parliament refuse to discuss the constitutional problem for local province. | China | http://trove.nla.gov.au/newspaper/page/24094318 | 24094318 | |
| 39555 | 39555 | 1923-03-03 | 6 | c | The joint communique issued by Sun Yatsen and Adolf Joffe, envoy of Lenin's Soviet Russian government. | China | http://trove.nla.gov.au/newspaper/page/24094323 | 24094323 | |
| 39556 | 39556 | 1923-03-03 | 6 | c-d | Rumours on the situation change in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24094323 | 24094323 | |
| 39563 | 39563 | 1923-03-03 | 7 | b-c | News in brief/ Zheng xue hui in Beijing opposes Meng Renqian to be the Guangxi governor. Wu Peifu's envoy meet Li Yuanhong. Zhang Shaozeng has different opinion on the appointment of Guangxi governor. Why Shi Zhaoji can not be the foreign affairs minister. Sun Yatsen talks in Shanghai before returning to Guangdong. Li Yuanhong asks Chen Jiongming to come to Beijing. Sun Yatsen asks for release of Wei Bangping. Imperial Qing family and their privileges. Wu Peifu has another opinion on the governorship in Guangdong, Guangxi and Fujian. Shen Hongying sends telegram to Qin Chunxuan. | China | http://trove.nla.gov.au/newspaper/page/24094322 | 24094322 |
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]);