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 |
|---|---|---|---|---|---|---|---|---|---|
| 48016 | 48016 | 1929-04-20 | 2 | b | Circular telegram issued by the Chinese Constitutionalist Party in America. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099186 | 24099186 | |
| 48017 | 48017 | 1929-04-20 | 2 | c | Political declaration issued by Wang Jingwei, Chen Gongbo, Yan Mengyu, Bai Wenwei, He Xiangni, Wang Faqin and others on the Nationalist Party affairs. | China | http://trove.nla.gov.au/newspaper/page/24099186 | 24099186 | |
| 48018 | 48018 | 1929-04-20 | 2 | e | Preparation for the Third National Congress of the Nationalist Party. Opening ceremony of the Third Nationalist Party Congress. | China | http://trove.nla.gov.au/newspaper/page/24099186 | 24099186 | |
| 48019 | 48019 | 1929-04-20 | 3 | a | Bai Chongxi's army in Hebei province sees an internal fighting. Rumour says Bai Chongxi and Feng Yuxiang may collaborate. | China | http://trove.nla.gov.au/newspaper/page/24099185 | 24099185 | |
| 48020 | 48020 | 1929-04-20 | 3 | a | Yu Youren leaves Nanjing for the Shanghai in protest. | China | http://trove.nla.gov.au/newspaper/page/24099185 | 24099185 | |
| 48021 | 48021 | 1929-04-20 | 3 | b | Division of the Bai Chongxi's army in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24099185 | 24099185 | |
| 48022 | 48022 | 1929-04-20 | 3 | b | Feng Yuxiang resigns and his letter. | China | http://trove.nla.gov.au/newspaper/page/24099185 | 24099185 | |
| 48023 | 48023 | 1929-04-20 | 3 | b | Chen Diaoyuan under house arrest by the order of Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24099185 | 24099185 | |
| 48024 | 48024 | 1929-04-20 | 3 | b | Huang Fengqi's troops loot in Shouguang and other areas of Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24099185 | 24099185 | |
| 48025 | 48025 | 1929-04-20 | 3 | c | Chinese Communist leader Yi Huaishan is arrested. | China | http://trove.nla.gov.au/newspaper/page/24099185 | 24099185 | |
| 48026 | 48026 | 1929-04-20 | 3 | c | Wu Peifu in mediation. | China | http://trove.nla.gov.au/newspaper/page/24099185 | 24099185 | |
| 48027 | 48027 | 1929-04-20 | 3 | d | Zhang Zongchang raises funds in Qingdao, Shandong. | China | http://trove.nla.gov.au/newspaper/page/24099185 | 24099185 | |
| 48028 | 48028 | 1929-04-20 | 3 | d | Chen Guofu is besieged by old comrades of the Party. | China | http://trove.nla.gov.au/newspaper/page/24099185 | 24099185 | |
| 48029 | 48029 | 1929-04-20 | 6-7 | a-d | Guangdong news/ Guangdong stops to provide provision to Bai Chongxi. Political turmoil in north Guangdong. Zhang Huichang takes over the aviation association. Police raid human traffic. Japanese are studying the Buddhist sites in Guangdong. A survey on the famine in the north-west China. Report on the suppression of bandits in Zhongshan county. Victims of the fire in Gaoming. Tax officer of Xinhui county Huang Landu dies in toilet on board of a ferry. Li Luchao to be the magistrate of Zhongshan county. Disasters of the communism in Lufeng county. Businessmen and local residents in Dongjiang area raise funds for river projects. Two men in Shunde county exchange their sister for marriage. | China | http://trove.nla.gov.au/newspaper/page/24099190 | 24099190 | |
| 48030 | 48030 | 1929-04-20 | 8 | a | Japanese nationals are leaving Jinan. | China | http://trove.nla.gov.au/newspaper/page/24099192 | 24099192 | |
| 48031 | 48031 | 1929-04-20 | 8 | a | British warship in the Yangtze River reports the war in China. | China | http://trove.nla.gov.au/newspaper/page/24099192 | 24099192 | |
| 48032 | 48032 | 1929-04-20 | 8 | a | Australia news/ Truck and tram collide in Sydney and the casualties. Police in Sydney raid Chinese houses for the release of white girls. Flight accident on its way from Sydney to London. A life case in the car park in Sydney. Further report on the strike of timber workers in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099192 | 24099192 | |
| 48033 | 48033 | 1929-04-20 | 8 | c | Advertisement for driving school Fowlers' Motor College, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099192 | 24099192 |
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]);