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 |
---|---|---|---|---|---|---|---|---|---|
55267 | 55267 | 1935-07-20 | 3 | a | Gu Weijun comments on the European issues. | China | http://trove.nla.gov.au/newspaper/page/24096504 | 24096504 | |
55268 | 55268 | 1935-07-20 | 3 | a | New British Prime Minister talks about international situations. | Britain | http://trove.nla.gov.au/newspaper/page/24096504 | 24096504 | |
55274 | 55274 | 1935-07-20 | 5 | a | The south China may fall after Japanese occupation of the north part, comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096506 | 24096506 | |
55278 | 55278 | 1935-07-20 | 8 | a | Stalin revises the constitution of Soviet Russia. | Other... | http://trove.nla.gov.au/newspaper/page/24096510 | 24096510 | |
55277 | 55277 | 1935-07-20 | 6-7 | a-f | Guangdong news/ Hu Hanmin is leaving China to tour Europe and the report. Some sailors on the two warships in Huangpu, Haiqi and Haishen, are deserting. Former Chinese foreign minister Luo Wengan is now a businessman. Market of hand-woven clothes in Guangzhou. Small business in Guangzhou. Zhongshan county authority moves its office once again. Sericulture in Zhongshan county. Opium addict in Nanhai and his story. Prostitutes in Huizhou. Sanshui county authority prevents the establishment of commercial chambers. | China | http://trove.nla.gov.au/newspaper/page/24096509 | 24096509 | |
55264 | 55264 | 1935-07-20 | 2 | b | Japanese have totally controlled north China and the relevant report. | China | http://trove.nla.gov.au/newspaper/page/24096505 | 24096505 | |
55265 | 55265 | 1935-07-20 | 2 | b | Japanese may invade the south part of China. National crisis in China after the January 28. | China | http://trove.nla.gov.au/newspaper/page/24096505 | 24096505 | |
55279 | 55279 | 1935-07-20 | 8 | b | Both the Yellow and Yangtze Rivers in China are flooding. | China | http://trove.nla.gov.au/newspaper/page/24096510 | 24096510 | |
55269 | 55269 | 1935-07-20 | 3 | c | American Secretary of State on the arms race and the possible outcome. | America | http://trove.nla.gov.au/newspaper/page/24096504 | 24096504 | |
55270 | 55270 | 1935-07-20 | 3 | c | Thailand government initiates another wave of anti-Chinese movement and the resistance. | China | http://trove.nla.gov.au/newspaper/page/24096504 | 24096504 | |
55275 | 55275 | 1935-07-20 | 5 | c | Story of Zhong Guanghong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096506 | 24096506 | |
55280 | 55280 | 1935-07-20 | 8 | c | Soviet Russia tries to protect Outer Mongolia. | Britain | http://trove.nla.gov.au/newspaper/page/24096510 | 24096510 | |
55281 | 55281 | 1935-07-20 | 8 | c | British Foreign Secretary on their foreign policy. | Britain | http://trove.nla.gov.au/newspaper/page/24096510 | 24096510 | |
55271 | 55271 | 1935-07-20 | 3 | d | American attitude on the north China crisis. | America | http://trove.nla.gov.au/newspaper/page/24096504 | 24096504 | |
55282 | 55282 | 1935-07-20 | 8 | d | Soviet Russia to rebuild Moscow. | Russia | http://trove.nla.gov.au/newspaper/page/24096510 | 24096510 | |
55283 | 55283 | 1935-07-20 | 8 | e | Australia news/ Envoy of Guangzhou government Wu Zhimei comes to visit Sydney and the welcome of Chinese communities. Exhibition of Australian products in Japan. A Sydney man travels around the world by a small ship. Guo Zhenhong is returning after a few months' stay in Australia. The gas bomb in the future war. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096510 | 24096510 | |
55266 | 55266 | 1935-07-20 | 2 | f | The Nanjing government seeks compromise with Japanese invaders. Huang Fu becomes governor of Hebei province. Nanjing government accepts all Japanese demands. | China | http://trove.nla.gov.au/newspaper/page/24096505 | 24096505 | |
55272 | 55272 | 1935-07-20 | 3 | f | Advertisement of War Hing & Co. Ltd., Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096504 | 24096504 | |
55273 | 55273 | 1935-07-20 | 3 | f | Advertisement of Hop Lee & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096504 | 24096504 | |
55276 | 55276 | 1935-07-20 | 5 | f | News about the Chinese School in Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096506 | 24096506 |
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]);