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 |
|---|---|---|---|---|---|---|---|---|---|
| 47178 | 47178 | 1928-06-30 | 2 | b | Editorial by Tung Wah Times claims that certain criteria are essential for a government and its administration. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098858 | 24098858 | |
| 47179 | 47179 | 1928-06-30 | 2 | c | Japanese troops fire at Dangjiazhuang (the Dang Family Village) near Jinan and the detailed report. | China | http://trove.nla.gov.au/newspaper/page/24098858 | 24098858 | |
| 47180 | 47180 | 1928-06-30 | 2 | e | Women in America suffer from the economic recession. | America | http://trove.nla.gov.au/newspaper/page/24098858 | 24098858 | |
| 47181 | 47181 | 1928-06-30 | 3 | b | Communist activist Xiang Jingyu is executed in Hankou and the report. | China | http://trove.nla.gov.au/newspaper/page/24098857 | 24098857 | |
| 47182 | 47182 | 1928-06-30 | 3 | d | New development of the Chinese foreign policy. | China | http://trove.nla.gov.au/newspaper/page/24098857 | 24098857 | |
| 47183 | 47183 | 1928-06-30 | 3 | e | Jiang Jieshi sacks He Yaozu and the reason. | China | http://trove.nla.gov.au/newspaper/page/24098857 | 24098857 | |
| 47184 | 47184 | 1928-06-30 | 5 | a | Hong Kong news/ Anti-Japanese movement in Hong Kong. Situations of the Chinese immigrants in Japan. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098859 | 24098859 | |
| 47185 | 47185 | 1928-06-30 | 5 | b | Second part of the survey on the textiles' printing and dyeing industry in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098859 | 24098859 | |
| 47186 | 47186 | 1928-06-30 | 5 | c | Second and final part of the report on that a girl in Hankou tests her future husband. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098859 | 24098859 | |
| 47187 | 47187 | 1928-06-30 | 6 | a-d | Guangdong news/ The Communist office is smashed in Guangzhou. Munitions factory in north-east of Guangzhou explodes. Commercial chambers in Guangzhou call to break off economic relations with Japan, their slogans, and to promote Chinese products. Authority confess that there are too many Communist members in Guangzhou to arrest. | China | http://trove.nla.gov.au/newspaper/page/24098862 | 24098862 | |
| 47188 | 47188 | 1928-06-30 | 7 | a-d | Guangdong news/ The Northern Expedition and its influence upon the value of currency. Floods in Guangdong. Miscellaneous report on bandits in local Guangdong. The middlemen and their roles in the navigation industry in Xijiang area. Businessmen in Gaoyao county oppose to road construction. Bandits and their robbery in Doumen. Rice businessmen in See Yip counties oppose to the monopoly of grains market. Cholera in Shilong town. | China | http://trove.nla.gov.au/newspaper/page/24098861 | 24098861 | |
| 47189 | 47189 | 1928-06-30 | 8 | a | The Fengtian authority publicly declares the death of Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24098864 | 24098864 | |
| 47190 | 47190 | 1928-06-30 | 8 | a | The Nationalist government makes Nanjing the capital and changes the name of Beijing to Beiping. | China | http://trove.nla.gov.au/newspaper/page/24098864 | 24098864 | |
| 47191 | 47191 | 1928-06-30 | 8 | a | British foreign secretary reports current situations in north China. | China | http://trove.nla.gov.au/newspaper/page/24098864 | 24098864 | |
| 47192 | 47192 | 1928-06-30 | 8 | a | War in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24098864 | 24098864 | |
| 47193 | 47193 | 1928-06-30 | 8 | a | A train accident in Sweden. | Britain | http://trove.nla.gov.au/newspaper/page/24098864 | 24098864 | |
| 47194 | 47194 | 1928-06-30 | 8 | a | Japan to withdraw their troops from Shandong. | Japan | http://trove.nla.gov.au/newspaper/page/24098864 | 24098864 | |
| 47195 | 47195 | 1928-06-30 | 8 | b | Australia news/ Two people die when a car falls into the sea in Sydney. Chinese man is detained for supplying his wife with opium. Postal parcels are stolen in Sydney. Japanese businessmen purchase iron mine in Western Australia. Japanese come to buy sheep. Earthquake in Suva, Fiji. Heavy rain and floods in New South Wales. State government of New South Wales prohibits returned servicemen from begging on the street. A man is detained in New South Wales for forging bank notes. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098864 | 24098864 | |
| 47196 | 47196 | 1928-06-30 | 8 | d | A notice issued by Wei Zijing, Chinese Consul-General in Australia, on his holiday back to China and that, during this time, all correspondence should be addressed to the Chinese Chamber of Commerce in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098864 | 24098864 | |
| 47197 | 47197 | 1928-06-30 | 8 | e | Advertisement for Wing Sang Co Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098864 | 24098864 |
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]);