This data as json, CSV (advanced)
Suggested facets: page, column, 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 | |
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 | |
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 | |
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 |
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]);