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 |
|---|---|---|---|---|---|---|---|---|---|
| 47159 | 47159 | 1928-06-23 | 2 | b | Second and final part of the editorial by Tung Wah Times on the population increase and its relationship to the war. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098850 | 24098850 | |
| 47160 | 47160 | 1928-06-23 | 2 | c-f | Further report on Japanese invasion in Shandong province, their cruelty in Jinan, their demands to Jiang Jieshi, and the appeal of the Nationalist government to the League of Nations. | China | http://trove.nla.gov.au/newspaper/page/24098850 | 24098850 | |
| 47161 | 47161 | 1928-06-23 | 2 | f | Independence movement in Korea and their open letter. | Other... | http://trove.nla.gov.au/newspaper/page/24098850 | 24098850 | |
| 47162 | 47162 | 1928-06-23 | 3 | b | The fall of Jinan and the Japanese invasion. Japanese troops are building airport in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24098849 | 24098849 | |
| 47163 | 47163 | 1928-06-23 | 3 | d | Panic in Harbin, capital of Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24098849 | 24098849 | |
| 47164 | 47164 | 1928-06-23 | 3 | e | Foreign missions in Beijing respond to Japanese occupation of Jinan, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098849 | 24098849 | |
| 47165 | 47165 | 1928-06-23 | 3 | f | The Chinese Communist Party is preparing to make trouble following the fall of Jinan. | China | http://trove.nla.gov.au/newspaper/page/24098849 | 24098849 | |
| 47166 | 47166 | 1928-06-23 | 5 | b | First part of a survey on the textiles' printing and dyeing industry in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098851 | 24098851 | |
| 47167 | 47167 | 1928-06-23 | 5 | c | First part of a report on that a girl in Hankou tests her future husband. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098851 | 24098851 | |
| 47168 | 47168 | 1928-06-23 | 6 | a-d | Guangdong news/ Jiang Jieshi has agreed to the requests of Japanese military commander in Shandong and comments by He Yingqin. Four commercial chambers in Guangzhou urge the government to repay the debt. High court in Guangzhou requests to stop physical punishment. Provincial authority on the management of sand land (sha tian). A sudden but thorough search in Guangzhou for the Communist suspects. | China | http://trove.nla.gov.au/newspaper/page/24098854 | 24098854 | |
| 47169 | 47169 | 1928-06-23 | 7 | a-d | Guangdong news/ Policeman in Guangzhou marries a woman who has husband. All hotels are ordered to be closed. Salary increase for the employees of the Guangzhou-Hankou railway. Revival of the clan feud and fighting in Panyu and Zengcheng county. Floods in the Dongjiang area. Zhongshan county authority check up receipts issued by private banks. Yangchun county suffers devastation of the Communists. Bandits flood a village in Xinhui county with blood and the report. Bandits in Dongguan county. A strange case of murder in Zhongshan county. | China | http://trove.nla.gov.au/newspaper/page/24098853 | 24098853 | |
| 47170 | 47170 | 1928-06-23 | 8 | a | Korean man attempts to assassinate the father-in-law of Japanese emperor. | Japan | http://trove.nla.gov.au/newspaper/page/24098856 | 24098856 | |
| 47171 | 47171 | 1928-06-23 | 8 | a | The Nationalist government orders banks in Tianjin to stop payment of foreign debt. | China | http://trove.nla.gov.au/newspaper/page/24098856 | 24098856 | |
| 47172 | 47172 | 1928-06-23 | 8 | a | Textile workers on strike in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24098856 | 24098856 | |
| 47173 | 47173 | 1928-06-23 | 8 | a | Export of gold coins from the United States of America. | America | http://trove.nla.gov.au/newspaper/page/24098856 | 24098856 | |
| 47174 | 47174 | 1928-06-23 | 8 | a | The biggest ship to be built in London. | Britain | http://trove.nla.gov.au/newspaper/page/24098856 | 24098856 | |
| 47175 | 47175 | 1928-06-23 | 8 | b | The new strategies of the Fengxi Army under its new leadership after the death of Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24098856 | 24098856 | |
| 47176 | 47176 | 1928-06-23 | 8 | b | Australia news/ A cargo ship sinks in storm near Newcastle. Secretary of the trade union associations in Sydney is arrested for strike instigation. Chinese man is killed in a madhouse. Earthquake under the sea in South Pacific. Business is dull and the unemployment is high in Brisbane. A party on board of passenger liner Taiping in Sydney. Bandits in Sydney rob shops in broad day light. Japanese naval fleet on the way to Australia for training. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098856 | 24098856 | |
| 47177 | 47177 | 1928-06-23 | 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/24098856 | 24098856 |
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]);