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 |
|---|---|---|---|---|---|---|---|---|---|
| 52580 | 52580 | 1933-02-25 | 2 | a | Editorial by Tung Wah Times on Zhang Xueliang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091130 | 24091130 | |
| 52581 | 52581 | 1933-02-25 | 2 | c | Japanese army in Shanghai have an exercise. | China | http://trove.nla.gov.au/newspaper/page/24091130 | 24091130 | |
| 52582 | 52582 | 1933-02-25 | 2 | c | Soviet Russia prepares for a war. | China | http://trove.nla.gov.au/newspaper/page/24091130 | 24091130 | |
| 52583 | 52583 | 1933-02-25 | 2 | c | A speech by Shi Zhaoji, Chinese ambassador in Washington. | America | http://trove.nla.gov.au/newspaper/page/24091130 | 24091130 | |
| 52584 | 52584 | 1933-02-25 | 2 | d | Civilians in Beijing organise a self-defence committee. | China | http://trove.nla.gov.au/newspaper/page/24091130 | 24091130 | |
| 52585 | 52585 | 1933-02-25 | 2 | d | Rice production in Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24091130 | 24091130 | |
| 52586 | 52586 | 1933-02-25 | 2 | e | The Council of Administration in Nanjing issue new regulations on military secrets. | China | http://trove.nla.gov.au/newspaper/page/24091130 | 24091130 | |
| 52587 | 52587 | 1933-02-25 | 2 | f | Chinese agricultural authority encourages farming. | China | http://trove.nla.gov.au/newspaper/page/24091130 | 24091130 | |
| 52588 | 52588 | 1933-02-25 | 2 | f | Royalties in Mongolia request to remove Shi Qingyang. | China | http://trove.nla.gov.au/newspaper/page/24091130 | 24091130 | |
| 52589 | 52589 | 1933-02-25 | 2 | f | Wang Delin leads his troops retreat into Russia. | China | http://trove.nla.gov.au/newspaper/page/24091130 | 24091130 | |
| 52590 | 52590 | 1933-02-25 | 2 | f | The Filipino parliament on the independence. | Other... | http://trove.nla.gov.au/newspaper/page/24091130 | 24091130 | |
| 52591 | 52591 | 1933-02-25 | 3 | a | The war in Yuguan between Chinese and Japanese troops. | China | http://trove.nla.gov.au/newspaper/page/24091129 | 24091129 | |
| 52592 | 52592 | 1933-02-25 | 3 | b | The power of Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24091129 | 24091129 | |
| 52593 | 52593 | 1933-02-25 | 3 | d | Chinese medicine and acupuncture in France. | France | http://trove.nla.gov.au/newspaper/page/24091129 | 24091129 | |
| 52594 | 52594 | 1933-02-25 | 5 | a | Australia news/ Photograph of Zhu Songqing, Chairman of the Chinese Chamber of Commerce in NSW, and Chen Weipin, Chinese Consul-General in Sydney, at the Australian federal trade conference in Canberra. Federal cabinet to meet in Sydney on the New Zealand's ban the import of Australian fruits. Chinese doctor murdered in Victoria. A Chinese shop in Sydney is robbed. Chinese man arrested in Sydney for the use of counterfeit bank notes. The book, White China, is published. A notice issued by Chen Ruixi, of the Chungwah Society in Melbourne, on the Chinese school in Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091131 | 24091131 | |
| 52595 | 52595 | 1933-02-25 | 7-8 | a-e | Guangdong news/ Li Zongren on the resistance to Japanese invasion. A national defence committee set up in the southwest of China. Troops from the southwest on the way to fight Japanese in north China. Tang Yulin reports Japanese invasion of Kaifeng and Shandong. Military officers in Guizhou province want to fight Japanese invaders in the north. Snow in the Luofu Mountain. Business in Zhaoqing last year. Chen Yong'an sue Tang Shaoyi, magistrate of the Zhongshan county. | China | http://trove.nla.gov.au/newspaper/page/24091133 | 24091133 |
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]);