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 |
|---|---|---|---|---|---|---|---|---|---|
| 54748 | 54748 | 1934-12-22 | 2 | a | Notice issued by the Chinese Chamber of Commerce in NSW. Notice issued by Ye Bingnan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096271 | 24096271 | |
| 54749 | 54749 | 1934-12-22 | 2 | a | Government troops pursue the communist troops into Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24096271 | 24096271 | |
| 54750 | 54750 | 1934-12-22 | 2 | c | Jiang Jieshi's train is bombed and the report. Japanese troops invade Rehe province in north China. Financial situation is recovering in north China. Japanese plan to control the Manchuria. Wang Shuchang entertains Mongolian royalties. Police in Tangshan, Hebei province, smash the communist offices. | China | http://trove.nla.gov.au/newspaper/page/24096271 | 24096271 | |
| 54751 | 54751 | 1934-12-22 | 3 | a | The communist troops in west Hunan province. Jiang Jieshi seeks cooperation of Hu Hanmin. Jiang Bocheng comes to Guangzhou again. Tang Shaoyi is hospitalised in Hong Kong. Tan Qixiu arrives Hong Kong on his way back to China. | China | http://trove.nla.gov.au/newspaper/page/24096270 | 24096270 | |
| 54752 | 54752 | 1934-12-22 | 8 | a | Chinese communities in Sydney welcome General Qiu Zhaoshen and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096276 | 24096276 | |
| 54753 | 54753 | 1934-12-22 | 7 | a | Guangdong news/ Textile industry in Guangdong. Public funds are robbed in Taishan. Girl school students in Gaoyao on strike. Gold mine in Enping. Two local administrators are detained in Panyu. | China | http://trove.nla.gov.au/newspaper/page/24096274 | 24096274 | |
| 54754 | 54754 | 1934-12-22 | 6 | a | Chinese General Qiu Zhaoshen to deliver a speech in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096275 | 24096275 | |
| 54755 | 54755 | 1934-12-22 | 6 | a | Japanese ambassador in Washington and his talks. | America | http://trove.nla.gov.au/newspaper/page/24096275 | 24096275 | |
| 54756 | 54756 | 1934-12-22 | 6 | a | The search for Australian plane fails. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096275 | 24096275 | |
| 54757 | 54757 | 1934-12-22 | 6 | b | Japanese business in Poland. | Britain | http://trove.nla.gov.au/newspaper/page/24096275 | 24096275 | |
| 54758 | 54758 | 1934-12-22 | 6 | c | American businessmen secure huge profit during the World War I. | America | http://trove.nla.gov.au/newspaper/page/24096275 | 24096275 | |
| 54759 | 54759 | 1934-12-22 | 6 | d | American missionary is injured in China. | China | http://trove.nla.gov.au/newspaper/page/24096275 | 24096275 | |
| 54760 | 54760 | 1934-12-22 | 6 | d | British army in Singapore and their exercise. | Singapore | http://trove.nla.gov.au/newspaper/page/24096275 | 24096275 | |
| 54761 | 54761 | 1934-12-22 | 6 | e | Australia news/ Chinese associations in Sydney entertain General Qiu Zhaoshen. Chinese businessmen come to buy Australian ships. Federal Bank of Reserve reduces the interest rate. Northern Territory government subsidises old Chinese people for their return. Federal government pay pensions to the families of pilot. Hot weather in Queensland. Another storm in Victoria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096275 | 24096275 |
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]);