This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 54305 | 54305 | 1934-07-14 | 2 | b | China news/ Japanese request to lease Fuzhou and Xiamen. Japanese troops gather in Manchuria preparing for the war with Russian. China and Japan start direct radio communications. China's foreign trade in April. Resistance of Chinese troops to Japanese invasion in Manchuria. Wang Jitang and his negotiation in Japan. Yan Xishan sends telegram to the southwest authority. Former foreign minister Lu Zhengxiang is now a Catholic father. Accident in the Kailuan Coal Mine, Hebei province. More Japanese people now live in China. Chinese warship going to Japan for funeral of a naval commander. Japanese troops in north China. Japanese are recruiting Chinese labourers. | China | http://trove.nla.gov.au/newspaper/page/24096084 | 24096084 | |
| 54306 | 54306 | 1934-07-14 | 3 | a | Export of Chinese silk products. | China | http://trove.nla.gov.au/newspaper/page/24096083 | 24096083 | |
| 54307 | 54307 | 1934-07-14 | 3 | a | Japanese complete its fortification building in Hulu island. | China | http://trove.nla.gov.au/newspaper/page/24096083 | 24096083 | |
| 54308 | 54308 | 1934-07-14 | 3 | a | Soviet Russian troops on the border of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096083 | 24096083 | |
| 54309 | 54309 | 1934-07-14 | 3 | b | Chinese troops in Rehe and Liaoning fight Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24096083 | 24096083 | |
| 54317 | 54317 | 1934-07-14 | 3 | e | Japanese school set up in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24096083 | 24096083 | |
| 54319 | 54319 | 1934-07-14 | 7-8 | a-f | Guangdong news/ The First Group Army builds a shipyard. Air force defence in the southwest. Guangdong troops in the east take over Liancheng. Education in local Guangdong. Provincial financial authority reshuffled. Provincial authority and cultural development. Guangdong authority on the national defence. Guangdong and the loans to Japan. Issues of business registration in Guangdong. Effort of economic recovery in Guangdong. Widows in Shilong town of Dongguan and their pleas. Peasants in Zhongshan and their life. A case of murder in the Land Administration Office of Dongguan. Petition to reduce land tax in Taishan. Fishermen in Haifeng catch strange fish. Bandits in Fengshun murder the county magistrate. | China | http://trove.nla.gov.au/newspaper/page/24096087 | 24096087 | |
| 54320 | 54320 | 1934-07-14 | 6 | a | Japanese in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24096088 | 24096088 |
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]);