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 |
---|---|---|---|---|---|---|---|---|---|
55273 | 55273 | 1935-07-20 | 3 | f | Advertisement of Hop Lee & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096504 | 24096504 | |
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 | |
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 | |
55271 | 55271 | 1935-07-20 | 3 | d | American attitude on the north China crisis. | America | http://trove.nla.gov.au/newspaper/page/24096504 | 24096504 | |
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 | |
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 | |
55281 | 55281 | 1935-07-20 | 8 | c | British Foreign Secretary on their foreign policy. | Britain | http://trove.nla.gov.au/newspaper/page/24096510 | 24096510 | |
55267 | 55267 | 1935-07-20 | 3 | a | Gu Weijun comments on the European issues. | China | http://trove.nla.gov.au/newspaper/page/24096504 | 24096504 | |
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 | |
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 | |
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 | |
55282 | 55282 | 1935-07-20 | 8 | d | Soviet Russia to rebuild Moscow. | Russia | http://trove.nla.gov.au/newspaper/page/24096510 | 24096510 | |
55280 | 55280 | 1935-07-20 | 8 | c | Soviet Russia tries to protect Outer Mongolia. | Britain | http://trove.nla.gov.au/newspaper/page/24096510 | 24096510 | |
55278 | 55278 | 1935-07-20 | 8 | a | Stalin revises the constitution of Soviet Russia. | Other... | http://trove.nla.gov.au/newspaper/page/24096510 | 24096510 | |
55275 | 55275 | 1935-07-20 | 5 | c | Story of Zhong Guanghong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096506 | 24096506 | |
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 | |
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 | |
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 |
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]);