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 |
---|---|---|---|---|---|---|---|---|---|
47094 | 47094 | 1928-06-02 | 5 | a | Hong Kong news/ Chinese sugar and ginger retails businessmen and their negotiations with the Western counterparts. Rich businessman Zheng Sijin dies in Hong Kong and the funeral. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098827 | 24098827 | |
47100 | 47100 | 1928-06-02 | 7 | a | A military conference of Guangdong and Guangxi and speech by Li Jishen. | China | http://trove.nla.gov.au/newspaper/page/24098829 | 24098829 | |
47103 | 47103 | 1928-06-02 | 8 | a | Gas factory explodes in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47104 | 47104 | 1928-06-02 | 8 | a | Gas explosion in America and the tragedy. | America | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47105 | 47105 | 1928-06-02 | 8 | a | Battle on the Beijing-Hankou railway between Feng Yuxiang and Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47106 | 47106 | 1928-06-02 | 8 | a | Communists are detained in Germany. | Britain | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47107 | 47107 | 1928-06-02 | 8 | a | Foreign missions in Beijing mediate the military clashes. | Japan | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47108 | 47108 | 1928-06-02 | 8 | a | Pirates hijack British ship near Hong Kong and a further report. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47109 | 47109 | 1928-06-02 | 8 | a | Communist office smashed in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47099 | 47099 | 1928-06-02 | 6 | a-d | Guangdong news/ Guangzhou authority on the harm of students' movement. Land authority explains the land tax. Bandits hijack train from Guangzhou to Kowloon. Businessmen in Guangzhou organise various associations. Internal fighting in the Shantou Branch of the Nationalist Party. | China | http://trove.nla.gov.au/newspaper/page/24098830 | 24098830 | |
47088 | 47088 | 1928-06-02 | 2 | b | Editorial by Tung Wah Times on the obstacles to the elimination of the Chinese Communist Party. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098826 | 24098826 | |
47091 | 47091 | 1928-06-02 | 3 | b | The Communist bandits set fire in Jiading, Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24098825 | 24098825 | |
47095 | 47095 | 1928-06-02 | 5 | b | Fourth part of the survey on the tobacco production in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098827 | 24098827 | |
47101 | 47101 | 1928-06-02 | 7 | b | Guangdong agricultural and industrial administration issues temporary regulations on the labour movement, relations between employers and employees, and others. | China | http://trove.nla.gov.au/newspaper/page/24098829 | 24098829 | |
47110 | 47110 | 1928-06-02 | 8 | b | Japan's attitude on the disarmament treaty. | America | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47111 | 47111 | 1928-06-02 | 8 | b | Another strike in India. | Other... | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47112 | 47112 | 1928-06-02 | 8 | b | Australia news/ Vietnamese sailor is punished in Sydney for opium smuggling. Bank manager is killed in a traffic accident. A woman in Sydney is charged with murder. Chinese consul in New Zealand Li Guangheng dies in Wellington. Australian Ministry of Defence organises air force. Chefs on board of ships on strike. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47089 | 47089 | 1928-06-02 | 2 | c | The amalgamation Germany and Austria. | Germany | http://trove.nla.gov.au/newspaper/page/24098826 | 24098826 | |
47113 | 47113 | 1928-06-02 | 8 | c | Message by Yu Enhe, Chinese consul in New Zealand, thanks the Chinese communities in Australia and New Zealand for their condolences on the death of consul Li Guangheng. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47092 | 47092 | 1928-06-02 | 3 | d | The movement in Hunan province to wipe out Communists. | China | http://trove.nla.gov.au/newspaper/page/24098825 | 24098825 | |
47096 | 47096 | 1928-06-02 | 5 | d | New couplets for the Farewell Pagoda. New version of Thousand-character Classics. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098827 | 24098827 | |
47097 | 47097 | 1928-06-02 | 5 | d | Advertisement for the Jang Hing Loong Co Ltd, Suva, Fuji. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098827 | 24098827 | |
47098 | 47098 | 1928-06-02 | 5 | d | Advertisement for the Chinese Chamber of Commerce of New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098827 | 24098827 | |
47102 | 47102 | 1928-06-02 | 7 | d | Public protest gathering in Guangzhou against Japanese troops in north China. | China | http://trove.nla.gov.au/newspaper/page/24098829 | 24098829 | |
47093 | 47093 | 1928-06-02 | 3 | e | Lu Diping is appointed army commander on the recommendation of Li Zongren. | China | http://trove.nla.gov.au/newspaper/page/24098825 | 24098825 | |
47090 | 47090 | 1928-06-02 | 2 | f | Pagoda to be built in Jiangxi province for the dead servicemen. | China | http://trove.nla.gov.au/newspaper/page/24098826 | 24098826 |
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]);