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 |
|---|---|---|---|---|---|---|---|---|---|
| 48147 | 48147 | 1929-06-01 | 2 | b | The key of politics relies on the administration of people, comments written by Wang Zhixian. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099232 | 24099232 | |
| 48148 | 48148 | 1929-06-01 | 2 | b | A major earthquake may happen soon. | Britain | http://trove.nla.gov.au/newspaper/page/24099232 | 24099232 | |
| 48149 | 48149 | 1929-06-01 | 2 | c | Feng Yuxiang denies any collaboration with Soviet Russia. Liu Zhennian and his troops occupy Yantai, Shandong province. The Fourth Group Army surrender. Song Ziwen borrows more foreign loans. Jiang Jieshi appoints Chen Ce commander of the Fourth Fleet. Li Jishen is sleepless. Yang Sen is defeated by Liu Wenhui. Martial law enforced again in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24099232 | 24099232 | |
| 48150 | 48150 | 1929-06-01 | 2 | d | Agreement on the relieve of Qingdao, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24099232 | 24099232 | |
| 48151 | 48151 | 1929-06-01 | 2 | d | Tang Shengzhi arrives Beijing secretly. | China | http://trove.nla.gov.au/newspaper/page/24099232 | 24099232 | |
| 48152 | 48152 | 1929-06-01 | 2 | e | Twenty-two Communist students arrested in Fengyang county, north Anhui province. | China | http://trove.nla.gov.au/newspaper/page/24099232 | 24099232 | |
| 48153 | 48153 | 1929-06-01 | 2 | f | Feng Yuxiang urges Jiang Jieshi to come to Henan province. | China | http://trove.nla.gov.au/newspaper/page/24099232 | 24099232 | |
| 48154 | 48154 | 1929-06-01 | 2 | f | Foreign missions in China protest against the search on board of foreign ships by Chinese authority. | China | http://trove.nla.gov.au/newspaper/page/24099232 | 24099232 | |
| 48155 | 48155 | 1929-06-01 | 3 | a | The Communist bandits in the south of Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24099231 | 24099231 | |
| 48156 | 48156 | 1929-06-01 | 3 | a | Plan for improvement of the railway lines in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24099231 | 24099231 | |
| 48157 | 48157 | 1929-06-01 | 3 | b | Coal mines in Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24099231 | 24099231 | |
| 48158 | 48158 | 1929-06-01 | 3 | c | Railway line from Beijing to Fengtian changes name. | China | http://trove.nla.gov.au/newspaper/page/24099231 | 24099231 | |
| 48159 | 48159 | 1929-06-01 | 3 | c | Bandits Big Sword Society to the east of Xuzhou, north Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24099231 | 24099231 | |
| 48160 | 48160 | 1929-06-01 | 3 | d | Communists arrested in Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24099231 | 24099231 | |
| 48161 | 48161 | 1929-06-01 | 3 | e | American to convene an international conference on silk industry. | China | http://trove.nla.gov.au/newspaper/page/24099231 | 24099231 | |
| 48162 | 48162 | 1929-06-01 | 3 | e | Yang Xishan is still in his hometown. | China | http://trove.nla.gov.au/newspaper/page/24099231 | 24099231 | |
| 48163 | 48163 | 1929-06-01 | 5 | a | Hong Kong news/ Hong Kong and Guangdong authorities jointly wipe out the Communist bandits from Hainan island. Prince of Britain arrives Hong Kong. Sale of housemaids in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099233 | 24099233 | |
| 48164 | 48164 | 1929-06-01 | 5 | c | Lin Zexun and his story of opium ban. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099233 | 24099233 | |
| 48165 | 48165 | 1929-06-01 | 5 | d | American government provides loans to Soviet Russia. | America | http://trove.nla.gov.au/newspaper/page/24099233 | 24099233 | |
| 48166 | 48166 | 1929-06-01 | 5 | d | Advertisement for The Humorist, a fortnightly magazine from America. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099233 | 24099233 | |
| 48167 | 48167 | 1929-06-01 | 6-7 | a-d | Guangdong news/ The peace conference between Guangdong and Guangxi before their rupture. The life and death of Deng Jiayan. Zhu De and Mao Zedong lead their troops flee to south Jiangxi province. Ornithological research in the Zhongshan University, Guangzhou. Appeals from the commercial chamber to the provincial financial authority for the abolition of stamp duty and some taxes in the Dongjiang area. Fire alarm in Shantou. Divorce in Taishan. Plan for the port construction in Haikou, of Hainan island. Jiang Guanglai and the conscription in Zhongshan county. Bandits in Zhongshan. Bandit chieftain in Zengcheng Zhu Xinghe is arrested. Bao'an county magistrate orders to collect ferry levy. Storm in Dongguan. | China | http://trove.nla.gov.au/newspaper/page/24099236 | 24099236 | |
| 48168 | 48168 | 1929-06-01 | 8 | a | Rumour says Guangzhou is besieged. | China | http://trove.nla.gov.au/newspaper/page/24099238 | 24099238 | |
| 48169 | 48169 | 1929-06-01 | 8 | a | Nanjing government dispatches troops to suppress Feng Yuxiang. | China | http://trove.nla.gov.au/newspaper/page/24099238 | 24099238 | |
| 48170 | 48170 | 1929-06-01 | 8 | a | Guangxi troops suffer heavy casualties during their attack Guangdong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099238 | 24099238 | |
| 48171 | 48171 | 1929-06-01 | 8 | a | Japanese troops are withdrawing from Wuhan, Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24099238 | 24099238 | |
| 48172 | 48172 | 1929-06-01 | 8 | a | Han Fuqu in Shandong and Feng Yuxiang. | China | http://trove.nla.gov.au/newspaper/page/24099238 | 24099238 | |
| 48173 | 48173 | 1929-06-01 | 8 | b | Turkish parliament imposes new restrictions on foreign immigrants. | Britain | http://trove.nla.gov.au/newspaper/page/24099238 | 24099238 | |
| 48174 | 48174 | 1929-06-01 | 8 | b | Australia news/ Second part of the report on the fighting of the Chinese Chamber of Commerce for peanut import and their letter to the government authorities signed by Chairman Zhu Songqing. Customer is detained in a Sydney restaurant for using counterfeit bank notes. New Chinese Consul-General in Australia Song Faxiang assumes office. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099238 | 24099238 | |
| 48175 | 48175 | 1929-06-01 | 8 | e | A notice by the Sydney Chinese Presbyterian Church. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099238 | 24099238 |
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]);