This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53358 | 53358 | 1933-10-07 | 2 | a | Editorial on the foreign policies proposed by Wang Jingwei and Song Ziwen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091390 | 24091390 | |
53359 | 53359 | 1933-10-07 | 2 | b | Wang Jingwei reports his foreign policy. | China | http://trove.nla.gov.au/newspaper/page/24091390 | 24091390 | |
53360 | 53360 | 1933-10-07 | 2 | c | Song Ziwen reports his overseas tour. | China | http://trove.nla.gov.au/newspaper/page/24091390 | 24091390 | |
53361 | 53361 | 1933-10-07 | 2 | d | Typhoon on the coast of Jiangsu and Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24091390 | 24091390 | |
53362 | 53362 | 1933-10-07 | 2 | e | Jiang Jieshi to chair the conference in Lushan Mountain, Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24091390 | 24091390 | |
53363 | 53363 | 1933-10-07 | 2 | e | Song Ziwen to mortgage imported cotton for more loans from America. | China | http://trove.nla.gov.au/newspaper/page/24091390 | 24091390 | |
53364 | 53364 | 1933-10-07 | 2 | f | The Nanjing government to protect journalists. | China | http://trove.nla.gov.au/newspaper/page/24091390 | 24091390 | |
53365 | 53365 | 1933-10-07 | 2 | f | Jiang Jieshi promotes traditional values. | China | http://trove.nla.gov.au/newspaper/page/24091390 | 24091390 | |
53366 | 53366 | 1933-10-07 | 2 | f | Ma Zhanshan refuses to joint the officialdom. | China | http://trove.nla.gov.au/newspaper/page/24091390 | 24091390 | |
53367 | 53367 | 1933-10-07 | 2 | f | Train hijacked on the railway from Tianjin to Pukou. | China | http://trove.nla.gov.au/newspaper/page/24091390 | 24091390 |
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]);