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 |
|---|---|---|---|---|---|---|---|---|---|
| 45886 | 45886 | 1927-07-09 | 2 | b | The Outer Mongolia today is under tight control of Russian and the report. | China | http://trove.nla.gov.au/newspaper/page/24098448 | 24098448 | |
| 45889 | 45889 | 1927-07-09 | 2 | d | Businessmen in Shanghai are penalised for their support to the Communist Party. | China | http://trove.nla.gov.au/newspaper/page/24098448 | 24098448 | |
| 45890 | 45890 | 1927-07-09 | 2 | d | Red Gun Society (hong qiang hui) besieges Luoyang, of Henan province. | China | http://trove.nla.gov.au/newspaper/page/24098448 | 24098448 | |
| 45891 | 45891 | 1927-07-09 | 2 | e | Sichuan army has finalised its plan to suppress the communists. | China | http://trove.nla.gov.au/newspaper/page/24098448 | 24098448 | |
| 45892 | 45892 | 1927-07-09 | 2 | f | Possible change of the political situation in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24098448 | 24098448 | |
| 45893 | 45893 | 1927-07-09 | 2 | f | The Revolutionary Army, led by Jiang Jieshi, have occupied Xuzhou following the Tianjin-Pukou railway line. | China | http://trove.nla.gov.au/newspaper/page/24098448 | 24098448 | |
| 45894 | 45894 | 1927-07-09 | 2 | f | Zhang Zuolin's army are defeated in Henan province. | China | http://trove.nla.gov.au/newspaper/page/24098448 | 24098448 | |
| 45895 | 45895 | 1927-07-09 | 3 | b | Famine and starvation in Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24098447 | 24098447 | |
| 45896 | 45896 | 1927-07-09 | 3 | c | The Act, drafted by Luo Zhixi and Hu Hanmin of the Law Committee of the Nationalist government, to punish local bullies and evil gentry. | China | http://trove.nla.gov.au/newspaper/page/24098447 | 24098447 | |
| 45897 | 45897 | 1927-07-09 | 5 | a | Borodin is preparing to leave China. | China | http://trove.nla.gov.au/newspaper/page/24098449 | 24098449 | |
| 45898 | 45898 | 1927-07-09 | 5 | a | The Nationalist troops from Nanjing attack the communist nestle in Shanghai and the report. | China | http://trove.nla.gov.au/newspaper/page/24098449 | 24098449 | |
| 45900 | 45900 | 1927-07-09 | 5 | b | Chaos in Hankou, of Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24098449 | 24098449 | |
| 45901 | 45901 | 1927-07-09 | 5 | c | The Guomindang troops attack Jinan, Shandong. | China | http://trove.nla.gov.au/newspaper/page/24098449 | 24098449 | |
| 45902 | 45902 | 1927-07-09 | 5 | c | Coming crisis along the Yangtze River. | China | http://trove.nla.gov.au/newspaper/page/24098449 | 24098449 | |
| 45903 | 45903 | 1927-07-09 | 5 | c | The Guomindang troops occupy Yanzhou, of Shandong province, and the support from Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098449 | 24098449 | |
| 45904 | 45904 | 1927-07-09 | 5 | c | League of Nations to meet and discuss China problems and attitude of the Chinese government. | China | http://trove.nla.gov.au/newspaper/page/24098449 | 24098449 | |
| 45909 | 45909 | 1927-07-09 | 9 | a-d | Guangdong news/ The Communists in Hunan province ban rice export to Guangdong. Jiang Jieshi orders to stop teaching of Sociology. Refugees in Hunan province appeal for punishment of Chen Jiayou. Property price in Guangzhou going up due to the expulsion of the Communists. Congress of the Workers' Representatives is re-organised. Magistrate of Heshan county and the communists. Congress of the Workers' Representatives to bail out innocent mates. Security Headquarters in Guangzhou busy suppressing all communists. Lu Jingke is appointed envoy of Guangdong for foreign negotiations. | China |
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]);