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 |
|---|---|---|---|---|---|---|---|---|---|
| 52739 | 52739 | 1933-04-08 | 2 | b | Editorial on the national crisis in China and the resistance of Chinese government to Japanese invasion. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091180 | 24091180 | |
| 52740 | 52740 | 1933-04-08 | 2 | b | Liu Chongjie presents awards to the army units in north China. | China | http://trove.nla.gov.au/newspaper/page/24091180 | 24091180 | |
| 52741 | 52741 | 1933-04-08 | 2 | f | Yan Xishan reports his troops have arrived Rehe. Feng Yuxiang may enter Liaoning province. | China | http://trove.nla.gov.au/newspaper/page/24091180 | 24091180 | |
| 52742 | 52742 | 1933-04-08 | 3 | a | Battles in north China between Chinese and Japanese troops. | China | http://trove.nla.gov.au/newspaper/page/24091179 | 24091179 | |
| 52743 | 52743 | 1933-04-08 | 3 | c | Tang Yulin troops retreat without fighting. | China | http://trove.nla.gov.au/newspaper/page/24091179 | 24091179 | |
| 52744 | 52744 | 1933-04-08 | 3 | e | Britain denies any knowledge of Japanese invasion of Rehe in north China. | China | http://trove.nla.gov.au/newspaper/page/24091179 | 24091179 | |
| 52745 | 52745 | 1933-04-08 | 3 | f | Earthquake in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24091179 | 24091179 | |
| 52746 | 52746 | 1933-04-08 | 5 | a | Japanese respect Jiang Jieshi and Cai Tingkai. | China | http://trove.nla.gov.au/newspaper/page/24091181 | 24091181 | |
| 52747 | 52747 | 1933-04-08 | 5 | c | A telegram from the Nanjing government praises the patriotism of the Australian Chinese communities. Chinese communities in Melbourne organise drama performance to raise funds for the war of resistance in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091181 | 24091181 | |
| 52748 | 52748 | 1933-04-08 | 5 | f | Chinese communities in Melbourne and Sydney donate to the war of resistance in China, and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091181 | 24091181 | |
| 52749 | 52749 | 1933-04-08 | 7-8 | a-f | Guangdong news/ A meeting on national defence in Guangzhou. Authorities in north China plea for help from Guangdong and the response. Zhu Qinglan sends another telegram to Guangdong for help. Preparation in the southwest for troops departure to fight Japanese in north China. Chen Jitang sets up a model rehabilitation centre. Second Unit of the airforce troops are ready to enter Jiangxi province. Japanese economy collapses. Local security troops must be under the commander of the county authority, an order issued by the provincial government. Businessmen in Macao and their manipulation of currency in Guangdong. Foreign business in Guangdong. Disputes solved between China and Portugal over the Hengqin island. Police in Guangzhou close a newspaper. Guangdong to have an airforce unit. Vietnam reduce rice tariff. | China | http://trove.nla.gov.au/newspaper/page/24091183 | 24091183 | |
| 52750 | 52750 | 1933-04-08 | 6 | e | Australia news/ Australian trade with Hong Kong and Macao. Royal Agricultural Show opened in Sydney. New committee of the Chinese Chamber of Commerce in NSW. Mysterious plan found near Darwin. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091184 | 24091184 |
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]);