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 |
---|---|---|---|---|---|---|---|---|---|
55647 | 55647 | 1935-12-14 | 2 | c | China news/ Japanese troops in Shanghai. Japanese request Song Zheyuan to arrest Jiang Menglin, Hu Shi and other 130 persons. Japanese demands to the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24096676 | 24096676 | |
55648 | 55648 | 1935-12-14 | 2 | f | Taiwan governor helps Japanese invasion of south China. | China | http://trove.nla.gov.au/newspaper/page/24096676 | 24096676 | |
55649 | 55649 | 1935-12-14 | 2 | f | Feng Yuxiang in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24096676 | 24096676 | |
55650 | 55650 | 1935-12-14 | 3 | a | Japanese invasion of north China. | China | http://trove.nla.gov.au/newspaper/page/24096675 | 24096675 | |
55655 | 55655 | 1935-12-14 | 6-7 | a-f | Guangdong news/ The cooperation between Guangdong and Nanjing. Li Zongren leaves Guangxi for Nanjing. Provincial government to issue new land certificate. Hong Kong businessmen reluctant to sell Japanese goods. More unemployed Chinese are returning from Canada. Many shops are closed down in Fuzhou, Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24096680 | 24096680 | |
55658 | 55658 | 1935-12-14 | 8 | a | The autonomous movement in north China. | China | http://trove.nla.gov.au/newspaper/page/24096684 | 24096684 | |
55659 | 55659 | 1935-12-14 | 8 | b | Atrocities of Japanese troops in north China. | China | http://trove.nla.gov.au/newspaper/page/24096684 | 24096684 | |
55660 | 55660 | 1935-12-14 | 8 | c | The new currency system in China and its effects. | China | http://trove.nla.gov.au/newspaper/page/24096684 | 24096684 |
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]);