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 |
|---|---|---|---|---|---|---|---|---|---|
| 48405 | 48405 | 1929-08-31 | 2 | b | Comments on China's intention to take over the Manchurian railways. | Other... | http://trove.nla.gov.au/newspaper/page/24099341 | 24099341 | |
| 48406 | 48406 | 1929-08-31 | 2 | c | Further report on the arrest of Chinese deputy-consul's wife in San Francisco for opium smuggling. | America | http://trove.nla.gov.au/newspaper/page/24099341 | 24099341 | |
| 48407 | 48407 | 1929-08-31 | 2 | d | Zhang Xueliang reports the negotiation over the Manchurian railway. Zhang Xueliang reports the invasion of Russian troops. | China | http://trove.nla.gov.au/newspaper/page/24099341 | 24099341 | |
| 48408 | 48408 | 1929-08-31 | 2 | e | American President Herbert Hoover on an international peace agreement. | America | http://trove.nla.gov.au/newspaper/page/24099341 | 24099341 | |
| 48409 | 48409 | 1929-08-31 | 2 | e | Japan's attitude on the American effort to mediate the conflict between China and Soviet Russia. | Japan | http://trove.nla.gov.au/newspaper/page/24099341 | 24099341 | |
| 48410 | 48410 | 1929-08-31 | 2 | f | Chinese troops on the way to the border for a war with Russian. American government dispatches envoy to investigate the coming conflict between China and Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24099341 | 24099341 | |
| 48411 | 48411 | 1929-08-31 | 3 | a | China takes back the electrify supply of the railway lines in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24099340 | 24099340 | |
| 48412 | 48412 | 1929-08-31 | 3 | b | Russian manager of the railway company in Heilongjiang is leaving. | China | http://trove.nla.gov.au/newspaper/page/24099340 | 24099340 | |
| 48413 | 48413 | 1929-08-31 | 3 | c | Many refugees are fleeing Henan province. | China | http://trove.nla.gov.au/newspaper/page/24099340 | 24099340 | |
| 48414 | 48414 | 1929-08-31 | 3 | d | New Japanese cabinet and their China policy. | Japan | http://trove.nla.gov.au/newspaper/page/24099340 | 24099340 | |
| 48415 | 48415 | 1929-08-31 | 3 | e | Current situation in south Anhui province following the defection of Chen Guocai. | China | http://trove.nla.gov.au/newspaper/page/24099340 | 24099340 | |
| 48416 | 48416 | 1929-08-31 | 5 | a-c | A public notice issued by the Chinese Consulate-General in Australia on the registration of the Chinese nationals in Australia, and a notice issued by the Nationalist government in Nanjing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099342 | 24099342 | |
| 48417 | 48417 | 1929-08-31 | 5 | d | Hong Kong news/ Security troops in Shantou and their harassment to local residents. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099342 | 24099342 | |
| 48418 | 48418 | 1929-08-31 | 5 | e | New Ten Commandments to women. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099342 | 24099342 | |
| 48419 | 48419 | 1929-08-31 | 6-7 | a-d | Guangdong news/ Reorganisation of various troops in Guangdong. Chen Weiyuan to be the director of the provincial police authority. Levies for entertainment and theatre performance in Guangzhou and the oppositions. Cosmetics businessmen and the stamp duties. Levies to be collected for army provision. Wong Guiqing removes chief tax commissioners in Jiangmen and Jiulong. Four reactionary magazines are banned in Guangzhou. Fishing industry in Xisha island, South China Sea. Survey on the properties in Guangzhou owned by Russian people. Two men are detained in Jiujiang fro defraud. Further report on the bankruptcy of some private banks in Jiangmen. A robbery in Taishan county. Two prisoners are escaping from Zengcheng prison. Bandits in Xinhui county. People in Gaoyao county sue their magistrate. New market to be built in Jiangmen. Villagers in Gao'an county detain security troops. | China | http://trove.nla.gov.au/newspaper/page/24099345 | 24099345 | |
| 48420 | 48420 | 1929-08-31 | 8 | c | British navy reports the military clash between Chinese and Russian troops. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099347 | 24099347 | |
| 48421 | 48421 | 1929-08-31 | 8 | c | Another call for boycott to Japanese goods in the Yangtze River area. | Britain | http://trove.nla.gov.au/newspaper/page/24099347 | 24099347 | |
| 48422 | 48422 | 1929-08-31 | 8 | c | Zhang Xueliang seeks advice from Nanjing for the coming conflict between China and Russia. | Japan | http://trove.nla.gov.au/newspaper/page/24099347 | 24099347 | |
| 48423 | 48423 | 1929-08-31 | 8 | c | Typhoon in Hong Kong and the damages. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099347 | 24099347 | |
| 48424 | 48424 | 1929-08-31 | 8 | d | Chinese soldiers shoot down Russian plane. British businessman detained in Harbin. Chinese government asks the League of Nations to mediate the Sino-Russian dispute over the Manchurian railways. Bandit groups smashed in Shanghai. Soviet Russia suffers loss in the clash with China. Arsenal explodes in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24099347 | 24099347 | |
| 48425 | 48425 | 1929-08-31 | 8 | f | Australia news/ Taxes increased for tobacco and wines in Australia. Passenger liner Changte delays its departure for Hong Kong. An old man in Sydney is detained for selling wine without license. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099347 | 24099347 |
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]);