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 |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 47089 | 47089 | 1928-06-02 | 2 | c | The amalgamation Germany and Austria. | Germany | http://trove.nla.gov.au/newspaper/page/24098826 | 24098826 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 |
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]);