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 |
|---|---|---|---|---|---|---|---|---|---|
| 54697 | 54697 | 1934-12-01 | 2 | a | How to eradicate the communist disasters in China, comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096247 | 24096247 | |
| 54698 | 54698 | 1934-12-01 | 2 | b | China news/ Jiang Jieshi moves more troops to suppress the communists. Li Jichun and Shi Yousan plot a comeback. Japanese seeks to utilise the Communist troops in south China. The Communists give up their base in Jiangxi and Fujian province. Shandong and Shanxi troops on the way south. Zhang Junmai on Japanese attitude towards Huang Fu. | China | http://trove.nla.gov.au/newspaper/page/24096247 | 24096247 | |
| 54699 | 54699 | 1934-12-01 | 2 | d | America purchases more silver from overseas. | America | http://trove.nla.gov.au/newspaper/page/24096247 | 24096247 | |
| 54700 | 54700 | 1934-12-01 | 2 | e | Zhang Qun to train more young reserves. The communist troops in Jiangxi province to harass east Guizhou province. Gold mine found in Gansu province. Jiang Jieshi encourages to develop the northwest region. China relax its boycott to Japanese goods. | China | http://trove.nla.gov.au/newspaper/page/24096247 | 24096247 | |
| 54701 | 54701 | 1934-12-01 | 3 | a | Jiang Jieshi calls for postpone of the Fifth Plenary Session meeting. | China | http://trove.nla.gov.au/newspaper/page/24096246 | 24096246 | |
| 54702 | 54702 | 1934-12-01 | 3 | d | A new plane in Britain can fly faster. | Britain | http://trove.nla.gov.au/newspaper/page/24096246 | 24096246 | |
| 54703 | 54703 | 1934-12-01 | 3 | d | France to resist German invaders. | France | http://trove.nla.gov.au/newspaper/page/24096246 | 24096246 | |
| 54704 | 54704 | 1934-12-01 | 3 | d | Britain prohibits from selling weapons to overseas. | Britain | http://trove.nla.gov.au/newspaper/page/24096246 | 24096246 | |
| 54705 | 54705 | 1934-12-01 | 3 | f | Japanese troops in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24096246 | 24096246 | |
| 54706 | 54706 | 1934-12-01 | 5 | a | Another study on the development of the northwest region in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096248 | 24096248 | |
| 54707 | 54707 | 1934-12-01 | 7-8 | a-f | Guangdong news/ Fighting the communists in Jiangxi and other report on the suppression of the communist troops. Wang Chonghui tries hard to start cooperation between Nanjing and Guangzhou. Bai Chongxi leads his troops to attack Xiao Ke and his communist followers. Proposal to set up customs office in Kowloon. | China | http://trove.nla.gov.au/newspaper/page/24096250 | 24096250 | |
| 54708 | 54708 | 1934-12-01 | 6 | a | The Chinese communists kidnap foreign missionaries. | China | http://trove.nla.gov.au/newspaper/page/24096251 | 24096251 | |
| 54709 | 54709 | 1934-12-01 | 6 | a | Proposal in France for alliance with Russia for the containment of Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24096251 | 24096251 | |
| 54710 | 54710 | 1934-12-01 | 6 | b | Peasants in Manchuria and their life under the puppet government. | China | http://trove.nla.gov.au/newspaper/page/24096251 | 24096251 | |
| 54711 | 54711 | 1934-12-01 | 6 | c | Japan to abrogate the Washington agreement. | Japan | http://trove.nla.gov.au/newspaper/page/24096251 | 24096251 | |
| 54712 | 54712 | 1934-12-01 | 6 | d | Australia news/ Sydney welcomes Prince of Britain. Flour price to be reduced again. Earthquake in NSW. ANZAC memorial statue in Sydney. Royal Agricultural Show in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096251 | 24096251 |
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]);