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 |
|---|---|---|---|---|---|---|---|---|---|
| 46116 | 46116 | 1927-09-03 | 2 | b | Tung Wah Times comments on the difficulties of the Soviet Russia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098512 | 24098512 | |
| 46117 | 46117 | 1927-09-03 | 2 | c | Feng Yuxiang and his relations with He Jian in Wuhan and Tang Shengzhi in Yunnan. | China | http://trove.nla.gov.au/newspaper/page/24098512 | 24098512 | |
| 46118 | 46118 | 1927-09-03 | 2 | d | The Chinese Communist Party are still very active in Hunan province and the report. | China | http://trove.nla.gov.au/newspaper/page/24098512 | 24098512 | |
| 46119 | 46119 | 1927-09-03 | 2 | e | The women movement in China and the support around the globe. | China | http://trove.nla.gov.au/newspaper/page/24098512 | 24098512 | |
| 46120 | 46120 | 1927-09-03 | 2 | f | Visitor to Hankou, Hubei, talks on the financial situation there. | China | http://trove.nla.gov.au/newspaper/page/24098512 | 24098512 | |
| 46121 | 46121 | 1927-09-03 | 2 | f | Two German ships are detained in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098512 | 24098512 | |
| 46122 | 46122 | 1927-09-03 | 3 | b | Yan Xishan in Shanxi and his attitude towards other warlords. | China | http://trove.nla.gov.au/newspaper/page/24098511 | 24098511 | |
| 46123 | 46123 | 1927-09-03 | 3 | c | The close of the Far East Bank in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098511 | 24098511 | |
| 46124 | 46124 | 1927-09-03 | 3 | d | Chinese communities in Mexico financially support the Chinese consulate. | Other... | http://trove.nla.gov.au/newspaper/page/24098511 | 24098511 | |
| 46125 | 46125 | 1927-09-03 | 5 | a | Comprise between Hankou and Nanjing and Song Ziwen's tariff policy. | China | http://trove.nla.gov.au/newspaper/page/24098513 | 24098513 | |
| 46126 | 46126 | 1927-09-03 | 5 | a | Riots in Paris. | France | http://trove.nla.gov.au/newspaper/page/24098513 | 24098513 | |
| 46127 | 46127 | 1927-09-03 | 5 | b | Clash between Chinese and Japanese in Benxi, of Fengtian province. | China | http://trove.nla.gov.au/newspaper/page/24098513 | 24098513 | |
| 46128 | 46128 | 1927-09-03 | 5 | b | Troops from north China occupy Tongzhou, north shore of the Yangtze River. | China | http://trove.nla.gov.au/newspaper/page/24098513 | 24098513 | |
| 46129 | 46129 | 1927-09-03 | 5 | b | Japanese warship sinks during an exercise. | China | http://trove.nla.gov.au/newspaper/page/24098513 | 24098513 | |
| 46130 | 46130 | 1927-09-03 | 5 | c | Troops from the north attack Nanjing but failed. | China | http://trove.nla.gov.au/newspaper/page/24098513 | 24098513 | |
| 46131 | 46131 | 1927-09-03 | 5 | c | Earthquake in Taiwan. | China | http://trove.nla.gov.au/newspaper/page/24098513 | 24098513 | |
| 46132 | 46132 | 1927-09-03 | 5 | c | The Nationalist government in Nanjing lifts its control over opium smuggling. | China | http://trove.nla.gov.au/newspaper/page/24098513 | 24098513 | |
| 46133 | 46133 | 1927-09-03 | 5 | d | Japanese troops in Shandong are being withdrawn. | Japan | http://trove.nla.gov.au/newspaper/page/24098513 | 24098513 | |
| 46134 | 46134 | 1927-09-03 | 7 | a | Australia news/ Rice production in New South Wales and a historical review. Leaders of demonstration are detained in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098515 | 24098515 | |
| 46135 | 46135 | 1927-09-03 | 7 | a | Feng Yuxiang's troops take over Hankou, of Hubei province. Bandits hijack a train in Harbin, of Heilongjiang. | China | http://trove.nla.gov.au/newspaper/page/24098515 | 24098515 | |
| 46136 | 46136 | 1927-09-03 | 7 | a-b | Poems by Ruan Yongshang in response to Wu Elou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098515 | 24098515 | |
| 46137 | 46137 | 1927-09-03 | 7 | b-d | Protest gathering of the Chinese herbalists and Western medical practitioners in Guangzhou on the death of Su Binglin and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098515 | 24098515 | |
| 46138 | 46138 | 1927-09-03 | 9 | a-d | Guangdong news/ Yuan Xiajiu joins the Chinese Communists and his looting. Trams transportation in Guangzhou. Petitions from the blind people. Li Luchao proposes to reward in industrial development throughout the province. Dongguan county authority has a local security conference. Women in Guangzhou demonstrate against the case of rape by a doctor. Commercial chamber convenes a meeting. Provincial government to be reorganised from August. Fan Shisheng is leaving but Qian Dajun is coming. | 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]);