This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47293 | 47293 | 1928-08-04 | 3 | b | Yan Xishan on the disarmament plan proposed by Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24098897 | 24098897 | |
47294 | 47294 | 1928-08-04 | 3 | b | Zhang Xueliang and Wu Tailai are blamed. | China | http://trove.nla.gov.au/newspaper/page/24098897 | 24098897 | |
47295 | 47295 | 1928-08-04 | 3 | c | Jiang Jieshi convenes an economic conference in Shanghai and the participants. | China | http://trove.nla.gov.au/newspaper/page/24098897 | 24098897 | |
47296 | 47296 | 1928-08-04 | 3 | c | The Nanjing government appoints Wang Dading the first ambassador to Japan. | China | http://trove.nla.gov.au/newspaper/page/24098897 | 24098897 | |
47297 | 47297 | 1928-08-04 | 3 | d | Xue Dubi, Minister of Internal Affairs of the Nanjing government, prohibits women from restraining themselves. Feng Yuxiang resigns and the reason. Dethroned emperor Puyi and Zhang Xueliang and the future of Manchuria. The Nanjing government to replace some of the overseas missions. Yang Yuting is killed by Zhang Xueliang. Chief justice changed in the temporary court in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098897 | 24098897 |
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]);