This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 45068 | 45068 | 1926-08-21 | 2 | c-d | Editorial on the relationship between Wu Peifu and Zhang Zuolin. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101672 | 24101672 | |
| 45069 | 45069 | 1926-08-21 | 2 | d-e | A meeting of the Beijing cabinet and its resolution on the international tariff conference. | China | http://trove.nla.gov.au/newspaper/page/24101672 | 24101672 | |
| 45070 | 45070 | 1926-08-21 | 2 | f | War news from Northwest China. | China | http://trove.nla.gov.au/newspaper/page/24101672 | 24101672 | |
| 45071 | 45071 | 1926-08-21 | 3 | d-e | Wu Peifu is fighting in every direction and the influence. | China | http://trove.nla.gov.au/newspaper/page/24101671 | 24101671 | |
| 45072 | 45072 | 1926-08-21 | 3 | e | Chen Dingjia defects and the report. | China | http://trove.nla.gov.au/newspaper/page/24101671 | 24101671 | |
| 45073 | 45073 | 1926-08-21 | 3 | f | Naval fleet in Shanghai are going to aid Hunan province under the order of Wu Peifu. | China | http://trove.nla.gov.au/newspaper/page/24101671 | 24101671 | |
| 45074 | 45074 | 1926-08-21 | 5 | a | Panic of the Beijing journalist following the execution of a journalist. | China | http://trove.nla.gov.au/newspaper/page/24101673 | 24101673 | |
| 45075 | 45075 | 1926-08-21 | 5 | a | War clouds over the Balkan peninsula. | Britain | http://trove.nla.gov.au/newspaper/page/24101673 | 24101673 | |
| 45076 | 45076 | 1926-08-21 | 5 | a | Tragedy at a party in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24101673 | 24101673 | |
| 45077 | 45077 | 1926-08-21 | 5 | a | Earthquake in Korea. | China | http://trove.nla.gov.au/newspaper/page/24101673 | 24101673 | |
| 45078 | 45078 | 1926-08-21 | 5 | a | News on the politics in the Soviet Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24101673 | 24101673 | |
| 45079 | 45079 | 1926-08-21 | 5 | b | Bandits and robbery in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24101673 | 24101673 | |
| 45080 | 45080 | 1926-08-21 | 5 | b | Singaporean police raid on rubber smuggling. | Singapore | http://trove.nla.gov.au/newspaper/page/24101673 | 24101673 | |
| 45081 | 45081 | 1926-08-21 | 5 | c | Dethroned emperor of the Qing dynasty Puyi seeks to move back to the Forbidden Palace in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24101673 | 24101673 | |
| 45082 | 45082 | 1926-08-21 | 5 | c | Tang Haiqiu in Yiyang, of Hunan province, and his story. | China | http://trove.nla.gov.au/newspaper/page/24101673 | 24101673 | |
| 45083 | 45083 | 1926-08-21 | 6 | a | Annual meeting of shareholders of the Wing On textile company in Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101676 | 24101676 | |
| 45084 | 45084 | 1926-08-21 | 6 | a-c | An open letter to overseas Chinese communities from the national anticommunist association in Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101676 | 24101676 | |
| 45085 | 45085 | 1926-08-21 | 6 | c | The plane industry in European and Asian countries. | Other... | http://trove.nla.gov.au/newspaper/page/24101676 | 24101676 | |
| 45086 | 45086 | 1926-08-21 | 6 | c-d | Foreign observation on the loss of Chinese railway. | Britain | http://trove.nla.gov.au/newspaper/page/24101676 | 24101676 | |
| 45087 | 45087 | 1926-08-21 | 7 | a-c | Australia news/ Many Chinese passengers travel by liner Taiping. Opium found on board of liner Taiping. Demands in Sydney for the forty hours' working per week. A Chinese in Brisbane dies in a car accident. A young man in New South Wales commits suicide. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101675 | 24101675 | |
| 45088 | 45088 | 1926-08-21 | 7 | b | A speech by the Hong Kong governor and the part on the Guangzhou government. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101675 | 24101675 | |
| 45089 | 45089 | 1926-08-21 | 7 | c | Gambling in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101675 | 24101675 | |
| 45090 | 45090 | 1926-08-21 | 8 | a-d | Guangdong news/ Borodin is advisor for both the Nationalists and the Communists. Treasurer Song Ziwen forces commercial chambers to pay for them. Tax for military service to be collected in counties. Bandit chieftains meet in Guangzhou. Jiang Jieshi's troops harass local residents in Dongguan. Oil resources in Taishan county. Residents in Guangzhou are forced to join the army. Order to disband the guerrilla in Xiangshan county. | China | http://trove.nla.gov.au/newspaper/page/24101678 | 24101678 |
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]);