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 |
|---|---|---|---|---|---|---|---|---|---|
| 55663 | 55663 | 1935-12-21 | 2 | b | A speech by Zou Lu to save the national crisis. | China | http://trove.nla.gov.au/newspaper/page/24096686 | 24096686 | |
| 55664 | 55664 | 1935-12-21 | 2 | c | Feng Yuxiang suggests to form alliance with Russia in order to resist Japanese invasion. Japanese in north China and the peasants' riots in Hebei province. | China | http://trove.nla.gov.au/newspaper/page/24096686 | 24096686 | |
| 55665 | 55665 | 1935-12-21 | 2 | d | A speech by Jiang Jieshi at the Fifth Plenary Session in Nanjing and the response in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24096686 | 24096686 | |
| 55666 | 55666 | 1935-12-21 | 2 | f | Chinese financial ministry on the exchange of currencies in China. | China | http://trove.nla.gov.au/newspaper/page/24096686 | 24096686 | |
| 55667 | 55667 | 1935-12-21 | 3 | a | Efforts of Japanese authorities to organise autonomous government in north China and the report. | China | http://trove.nla.gov.au/newspaper/page/24096685 | 24096685 | |
| 55668 | 55668 | 1935-12-21 | 3 | c | Rumours in Japan about a secret agreement between China, Russia and America. | America | http://trove.nla.gov.au/newspaper/page/24096685 | 24096685 | |
| 55669 | 55669 | 1935-12-21 | 5 | b | The Chinese Society in Melbourne elects new members of its board and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096689 | 24096689 | |
| 55670 | 55670 | 1935-12-21 | 5 | c | Chinese communities in New Zealand donate to the floods victims in China. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096689 | 24096689 | |
| 55671 | 55671 | 1935-12-21 | 6-7 | a-f | Guangdong news/ Clearance of the Bank of Guangdong. Preparation for the Fifth Plenary Session in Nanjing. Li Zongren on leave while Hu Hanmin is returning from overseas. Business in Guangzhou is prosperous again. Peasants in Dongguan on demonstration on the new land tax. | China | http://trove.nla.gov.au/newspaper/page/24096692 | 24096692 | |
| 55672 | 55672 | 1935-12-21 | 8 | a | Students in Egypt on riots. | Other... | http://trove.nla.gov.au/newspaper/page/24096694 | 24096694 | |
| 55673 | 55673 | 1935-12-21 | 8 | a | The central government in Nanjing still controls north China. | China | http://trove.nla.gov.au/newspaper/page/24096694 | 24096694 | |
| 55674 | 55674 | 1935-12-21 | 8 | b | Britain and France mediate the conflict between Italy and Algeria. | Britain | http://trove.nla.gov.au/newspaper/page/24096694 | 24096694 | |
| 55675 | 55675 | 1935-12-21 | 8 | c | Jiang Jieshi is now also head of the Administrative Council (xing zheng yuan). | China | http://trove.nla.gov.au/newspaper/page/24096694 | 24096694 | |
| 55676 | 55676 | 1935-12-21 | 8 | d | Students in Beijing organise anti-Japanese demonstration. | China | http://trove.nla.gov.au/newspaper/page/24096694 | 24096694 | |
| 55677 | 55677 | 1935-12-21 | 8 | e | Australia news/ Airmail service between China and Australia. A Chinese man is robbed in Sydney. Candidates for the mayor of Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096694 | 24096694 |
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]);