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 |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 55271 | 55271 | 1935-07-20 | 3 | d | American attitude on the north China crisis. | America | 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 | |
| 55273 | 55273 | 1935-07-20 | 3 | f | Advertisement of Hop Lee & Co, Sydney. | Tung Wah | 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 | |
| 55275 | 55275 | 1935-07-20 | 5 | c | Story of Zhong Guanghong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096506 | 24096506 | |
| 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 | |
| 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 | |
| 55278 | 55278 | 1935-07-20 | 8 | a | Stalin revises the constitution of Soviet Russia. | Other... | 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 | |
| 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 | |
| 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 |
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]);