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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
47109 | 47109 | 1928-06-02 | 8 | a | Communist office smashed in Tianjin. | 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 | |
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 | |
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 | |
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 | |
47104 | 47104 | 1928-06-02 | 8 | a | Gas explosion in America and the tragedy. | America | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47103 | 47103 | 1928-06-02 | 8 | a | Gas factory explodes in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
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 | |
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 | |
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 | |
47110 | 47110 | 1928-06-02 | 8 | b | Japan's attitude on the disarmament treaty. | America | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
47089 | 47089 | 1928-06-02 | 2 | c | The amalgamation Germany and Austria. | Germany | http://trove.nla.gov.au/newspaper/page/24098826 | 24098826 | |
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 |
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]);