This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47717 | 47717 | 1929-01-05 | 3 | b | Prominent figures in Sichuan province suggest to set up the Tibet province and their appeal. | China | http://trove.nla.gov.au/newspaper/page/24099073 | 24099073 | |
47718 | 47718 | 1929-01-05 | 3 | d | Ancient graves found in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24099073 | 24099073 | |
47719 | 47719 | 1929-01-05 | 3 | d | Fu Zuoyi in Tianjin resigns due to his empty pockets. | China | http://trove.nla.gov.au/newspaper/page/24099073 | 24099073 | |
47720 | 47720 | 1929-01-05 | 3 | e | Internal disputes in Manchuria. Zhang Xueliang's attitude is still unstable. Zhou Xicheng from Guizhou province sends telegram to his representative in Nanjing. Soviet Russia seeks to control Xinjiang province. Japanese conspiracy in Dalian, Fengtian province. Bandits in Harbin, Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24099073 | 24099073 | |
47721 | 47721 | 1929-01-05 | 3 | f | Japanese police in Tokyo stop the plan to erect a statue of Sun Yatsen. | Japan | http://trove.nla.gov.au/newspaper/page/24099073 | 24099073 |
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]);