This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47787 | 47787 | 1929-02-02 | 2 | b | Second and final part of the editorial on the ultimate from Japanese government to the Chinese authority regarding the tariff issues. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099106 | 24099106 | |
47788 | 47788 | 1929-02-02 | 2 | c | Zhang Dingfan refuses to cooperate with Jiang Jieshi and may go to Beiping for Bai Chongxi. The Nanjing government and the Nationalist associations in Tianjin. Zheng Yuxiu and Zheng Hongnian in tears before the portrait of Sun Yatsen. Zhou Xicheng in Guizhou wins again. A report submitted by Zhang Zhijiang for his investigation on the opium smuggling in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24099106 | 24099106 | |
47789 | 47789 | 1929-02-02 | 2 | f | Feng Yuxiang attacks Liu Jiwen once again. | China | http://trove.nla.gov.au/newspaper/page/24099106 | 24099106 |
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]);