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 |
|---|---|---|---|---|---|---|---|---|---|
| 46295 | 46295 | 1927-10-15 | 2 | b-c | Tung Wah Times comments on the principle of equality among countries. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098560 | 24098560 | |
| 46296 | 46296 | 1927-10-15 | 2 | c-d | Documents seized in Soviet Russian embassy in Beijing reveal their conspiracy in China. | China | http://trove.nla.gov.au/newspaper/page/24098560 | 24098560 | |
| 46297 | 46297 | 1927-10-15 | 2 | d | Feng Yuxiang delays his attack to Zhili and Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098560 | 24098560 | |
| 46298 | 46298 | 1927-10-15 | 2 | e | Army commander Liu Zhenfu talks to journalists the war between Nanjing and Zhenjiang. | China | http://trove.nla.gov.au/newspaper/page/24098560 | 24098560 | |
| 46299 | 46299 | 1927-10-15 | 3 | b | Industrialists and businessmen in Fengtian oppose to Japanese rule in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24098559 | 24098559 | |
| 46300 | 46300 | 1927-10-15 | 3 | c | Representatives of Soviet Russia in China and their forces. | China | http://trove.nla.gov.au/newspaper/page/24098559 | 24098559 | |
| 46301 | 46301 | 1927-10-15 | 3 | c | Anti-communist movement in Outer Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24098559 | 24098559 | |
| 46302 | 46302 | 1927-10-15 | 3 | c | Zhang Wei (Huichang) is injured and now hospitalised in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098559 | 24098559 | |
| 46303 | 46303 | 1927-10-15 | 3 | d | Wu Peifu arrives Wanxian, of Sichuan province, the welcome ceremony, and Yang Sen, and the people's attitude towards Wu. | China | http://trove.nla.gov.au/newspaper/page/24098559 | 24098559 | |
| 46304 | 46304 | 1927-10-15 | 5 | a | Foreign report on the war in north China. | China | http://trove.nla.gov.au/newspaper/page/24098561 | 24098561 | |
| 46305 | 46305 | 1927-10-15 | 5 | a | The Chinese Communist Party and their activities throughout China. | China | http://trove.nla.gov.au/newspaper/page/24098561 | 24098561 | |
| 46306 | 46306 | 1927-10-15 | 5 | a | Panic in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24098561 | 24098561 | |
| 46307 | 46307 | 1927-10-15 | 5 | b | Leader of rebellions is arrested in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24098561 | 24098561 | |
| 46308 | 46308 | 1927-10-15 | 5 | b | Danish warship sinks in the North Sea. | Other... | http://trove.nla.gov.au/newspaper/page/24098561 | 24098561 | |
| 46309 | 46309 | 1927-10-15 | 5 | b | Troops from Shanxi province are approaching Beijing. | China | http://trove.nla.gov.au/newspaper/page/24098561 | 24098561 | |
| 46310 | 46310 | 1927-10-15 | 5 | b-c | Battles between Zhang Zuolin and Yan Xishan's troops. Shanxi troops are defeated. Yan Xishan seeks truce with Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24098561 | 24098561 | |
| 46311 | 46311 | 1927-10-15 | 5 | c | Emperor of Japan reviews military parade. | Japan | http://trove.nla.gov.au/newspaper/page/24098561 | 24098561 | |
| 46312 | 46312 | 1927-10-15 | 5 | c | A notice by the Dongguan gong yi tang on the donations to building of a hospital in their home town. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098561 | 24098561 | |
| 46313 | 46313 | 1927-10-15 | 7 | a | The enterprise of a 17-year-old Australian boy, George Palmer. Photograph of George Palmer and Miss Thelma Nelson. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098563 | 24098563 | |
| 46314 | 46314 | 1927-10-15 | 7 | b | Australia news/ Chinese businessman in Inverell, New South Wales, welcomes his mother in Sydney on her arrival. Farewell party for Chen Zanhua and Lin Kangnian and welcome Cai Tian. Chinese communities in Sydney celebrate the National Day on October 10, and speakers include Wu Zhaoquan, Ye Bingnan, Ye Tonggui, Zheng Fanchang, Guo Jianying, Liu Guangfu and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098563 | 24098563 | |
| 46315 | 46315 | 1927-10-15 | 7 | c | Finance and business in Hankou. | China | http://trove.nla.gov.au/newspaper/page/24098563 | 24098563 | |
| 46316 | 46316 | 1927-10-15 | 7 | c | The Shanxi army after the war with Zhang Zuolin's army. | China | http://trove.nla.gov.au/newspaper/page/24098563 | 24098563 | |
| 46317 | 46317 | 1927-10-15 | 7 | c | Riots in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24098563 | 24098563 | |
| 46318 | 46318 | 1927-10-15 | 8 | a-d | Guangdong news/ The Communists in Lufeng county. Military commanders and the Northern Expedition. A young man suicides for love. Naval training in Guangdong. Financial assistance provided by Soviet Russian to the peasants' associations in Guangdong. He Yingqin stops recruitment of new soldiers. President Dai Jitao of the Zhongshan University in Guangzhou offers privileges to overseas Chinese students. Bandits rob villages in Zengcheng county. The Communist forces occupy Chaoyang county and the report. Corruption in the Electrical Lights Company in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24098566 | 24098566 |
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]);