This data as json, CSV (advanced)
Suggested facets: page, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41155 | 41155 | 1924-02-23 | 2 | a-b | Editorial on the North Expedition and the establishment of a national government in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100624 | 24100624 | |
41156 | 41156 | 1924-02-23 | 2 | b-d | A special report published in The Herald of Melbourne on China and Japan (yellow peril from Japan, awakening of China, Japan revises its China policy, etc), translated by Guo Shaohong and Guo Shaozhou, two Chinese students in the University of Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24100624 | 24100624 | |
41157 | 41157 | 1924-02-23 | 2 | d-e | Sun Baoqi is appointed premier of China who is to organise a new cabinet. | China | http://trove.nla.gov.au/newspaper/page/24100624 | 24100624 | |
41158 | 41158 | 1924-02-23 | 2 | e-f | American ambassador in Beijing comments on the dispute over tariff income in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24100624 | 24100624 | |
41159 | 41159 | 1924-02-23 | 2-3 | f-a | A meeting in Fengtian on the relationship between Zhli and Fengtian. | China | http://trove.nla.gov.au/newspaper/page/24100624 | 24100624 |
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]);