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 |
|---|---|---|---|---|---|---|---|---|---|
| 54465 | 54465 | 1934-09-01 | 2 | a | Editorial on the relations between Guangzhou and Nanjing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096142 | 24096142 | |
| 54466 | 54466 | 1934-09-01 | 2 | b | China news/ Floods and drought in local provinces -- Henan, Hubei, Fujian, Shandong, Zhejiang and Anhui. Japan dispatches more troops to China as preparation for the war with Russia. The communists in Fujian province. Japanese troops in Beijing and their exercise. Yin Tong arrives Shanghai and reports the Dalian meeting. Gu Weijun talks to journalists on the international affairs. Huang Fu to chair the negotiation with Japanese in north China. Japanese seek to use the Muslim rebellions. | China | http://trove.nla.gov.au/newspaper/page/24096142 | 24096142 | |
| 54467 | 54467 | 1934-09-01 | 3 | a | Japanese investigate the mineral resources in north China. | China | http://trove.nla.gov.au/newspaper/page/24096141 | 24096141 | |
| 54468 | 54468 | 1934-09-01 | 3 | a | Mails from Germany and France arrive China via Japan. | China | http://trove.nla.gov.au/newspaper/page/24096141 | 24096141 | |
| 54469 | 54469 | 1934-09-01 | 3 | a | American President Roosevelt arrives Honolulu. | America | http://trove.nla.gov.au/newspaper/page/24096141 | 24096141 | |
| 54470 | 54470 | 1934-09-01 | 3 | b | Bandits in the war zones in China. | China | http://trove.nla.gov.au/newspaper/page/24096141 | 24096141 | |
| 54471 | 54471 | 1934-09-01 | 3 | b | Japanese troops in Tianjin. Yu Youren to meet Jiang Jieshi in Jiangxi. Chinese armies in Manchuria cooperate with Korean people. | China | http://trove.nla.gov.au/newspaper/page/24096141 | 24096141 | |
| 54472 | 54472 | 1934-09-01 | 3 | c | Zhang Fakui on the growth of airforce troops. Russian are building garrisons in Outer Mongolia. Japanese lure Mongolian people for independence. French and Italian troops in north China. | China | http://trove.nla.gov.au/newspaper/page/24096141 | 24096141 | |
| 54473 | 54473 | 1934-09-01 | 3 | d | British airforce troops and their exercise in London. | Britain | http://trove.nla.gov.au/newspaper/page/24096141 | 24096141 | |
| 54474 | 54474 | 1934-09-01 | 3 | d | Russian spy planes fly over Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096141 | 24096141 | |
| 54475 | 54475 | 1934-09-01 | 3 | e | Japanese propaganda movement on their invasion of China. | Japan | http://trove.nla.gov.au/newspaper/page/24096141 | 24096141 | |
| 54476 | 54476 | 1934-09-01 | 7-8 | a-f | Guangdong news/ Sun Ke to return to China. Truth of the Lushan conference convened by Jiang Jieshi. Massive communist troops in east Fujian province. Entry into Hainan island and their passport examination. Tang Shaoyi and the election of Zhongshan county magistrate. Two missions for Jiang Jieshi to convene the Lushan conference. Bai Chongxi has eye problem. Hong Kong government may change its tariff policy. Price of flour going up in Guangzhou. Bandits in Zhongshan. Business in Shilong town of Dongguan. Gold hunters killed in Enping county. Clan fighting in Nanhai. Bandits in Taishan. Boat people in Sihui county. Gold found in Sihui. | China | http://trove.nla.gov.au/newspaper/page/24096145 | 24096145 | |
| 54477 | 54477 | 1934-09-01 | 6 | a | Britain and Japan may re-establish an alliance. Conspiracy of Britain and Japan in Asian region. | Japan | http://trove.nla.gov.au/newspaper/page/24096146 | 24096146 | |
| 54478 | 54478 | 1934-09-01 | 6 | a | Kidnap in New York. | America | http://trove.nla.gov.au/newspaper/page/24096146 | 24096146 | |
| 54479 | 54479 | 1934-09-01 | 6 | b | American farmers request to deport Japanese immigrants. | America | http://trove.nla.gov.au/newspaper/page/24096146 | 24096146 | |
| 54480 | 54480 | 1934-09-01 | 6 | c | More report on the conflicts between Russia and Japan over the railway ownership. | China | http://trove.nla.gov.au/newspaper/page/24096146 | 24096146 | |
| 54481 | 54481 | 1934-09-01 | 6 | e | Australia news/ Visitor to the East talks about the business there. Chinese man detained in Darwin for opium smuggling. Foreign lotteries are not permitted to sell in Sydney. St Mary Church is burgled in Sydney. Chinese magician Huang Caixin and his performance in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096146 | 24096146 |
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]);