This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
55809 | 55809 | 1936-02-22 | 2 | b | Editorial on the last opportunity to save China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096752 | 24096752 | |
55810 | 55810 | 1936-02-22 | 2 | d | Jiang Jieshi to set Sichuan and Shaanxi as the basis to save China. | China | http://trove.nla.gov.au/newspaper/page/24096752 | 24096752 | |
55811 | 55811 | 1936-02-22 | 2 | d | Yan Xishan prefers to stay in Taiyuan, Shanxi province. | China | http://trove.nla.gov.au/newspaper/page/24096752 | 24096752 | |
55812 | 55812 | 1936-02-22 | 2 | d | Sun Dianying arrives Beijing to see doctor. Traitor Zhao Lei and others and their collaboration with Japanese invaders to taking over Tianjin. Economic Commission plans to dredge the Huaihe River to the sea. Ma Zhanshan puts forward his proposals to Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24096752 | 24096752 | |
55813 | 55813 | 1936-02-22 | 2 | e | The Sun Company opens new department store in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24096752 | 24096752 | |
55814 | 55814 | 1936-02-22 | 2 | f | Japanese military officers in north China request to send more troops to China. | China | http://trove.nla.gov.au/newspaper/page/24096752 | 24096752 | |
55822 | 55822 | 1936-02-22 | 2 | b | Du Zhongyuan in the prison. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096752 | 24096752 |
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]);