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 |
|---|---|---|---|---|---|---|---|---|---|
| 54590 | 54590 | 1934-10-13 | 2 | a | Second part of an editorial on Confucianism and the national crisis in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096190 | 24096190 | |
| 54591 | 54591 | 1934-10-13 | 2 | b | China news/ Li Jichun going to Fujian province. Liu Guitang and Shi Yousan to attack Tianjin. Communist leader He Long leads his troops fleeing to the south of Sichuan province. Kong Xiangxi on the loans from America. A member of the Central Executive Committee talks in Shanghai. Concubine of Li Yuanhong leaves. Shaanxi provincial government to build the Longhai Railway. Swimming across the Yangtze River in Wuhan. The Huanglian Religion in south Hebei province. Arsenal in Nanjing explodes. | China | http://trove.nla.gov.au/newspaper/page/24096190 | 24096190 | |
| 54592 | 54592 | 1934-10-13 | 3 | a | Yan Huiqing on the international affairs. | China | http://trove.nla.gov.au/newspaper/page/24096189 | 24096189 | |
| 54593 | 54593 | 1934-10-13 | 3 | b | Bandits near Beijing loot local villages. | China | http://trove.nla.gov.au/newspaper/page/24096189 | 24096189 | |
| 54594 | 54594 | 1934-10-13 | 3 | c | Duan Qirui arrives Beijing on his way to Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24096189 | 24096189 | |
| 54595 | 54595 | 1934-10-13 | 3 | c | Japanese businessman is murdered in Tangshan, Hebei province. | China | http://trove.nla.gov.au/newspaper/page/24096189 | 24096189 | |
| 54596 | 54596 | 1934-10-13 | 3 | d | Germany disagrees with Britain, France and Italy on the mutual agreement between Eastern European countries. | Germany | http://trove.nla.gov.au/newspaper/page/24096189 | 24096189 | |
| 54597 | 54597 | 1934-10-13 | 3 | e | Arms dealers in America. | America | http://trove.nla.gov.au/newspaper/page/24096189 | 24096189 | |
| 54598 | 54598 | 1934-10-13 | 7-8 | a-f | Guangdong news/ First part of proposals by Hu Hanmin and others in the southwest to the central authority in Nanjing. Miu Peinan and others inspect the munitions factory in Guangzhou. Zhongshan people welcome Song Qingling to govern the county. Cai Tingkai may return from America next month. The whereabouts of Wong Zhaoyuan. Survey on the business in Shunde county. Sun Ke is to solve the magistrate problem in Zhongshan county. Corrupt officials from Dongguan are escorted to Guangzhou. Secret society smashed in Jiujiang. Fabrics industry in Kaiping. Co-operatives established in Zengcheng. Police in Taishan raid weapons smuggled. | China | http://trove.nla.gov.au/newspaper/page/24096193 | 24096193 | |
| 54599 | 54599 | 1934-10-13 | 6 | e | Australia imports Japanese cars. | Japan | http://trove.nla.gov.au/newspaper/page/24096194 | 24096194 | |
| 54600 | 54600 | 1934-10-13 | 6 | e | American fleet on the way to Melbourne for centenary celebrations. | China | http://trove.nla.gov.au/newspaper/page/24096194 | 24096194 | |
| 54601 | 54601 | 1934-10-13 | 6 | f | Chaos in Spain. | Other... | http://trove.nla.gov.au/newspaper/page/24096194 | 24096194 | |
| 54602 | 54602 | 1934-10-13 | 6 | g | Australia news/ Prince of Britain arrives Western Australia. Chinese Chamber of Commerce in NSW celebrates the birthday of Confucius. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096194 | 24096194 |
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]);