This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45151 | 45151 | 1926-09-18 | 2 | d | Wu Peifu on the organisation of Chinese cabinet. | China | http://trove.nla.gov.au/newspaper/page/24101712 | 24101712 | |
45152 | 45152 | 1926-09-18 | 2 | e | Department of Justice in Beijing orders to reform the prison. | China | http://trove.nla.gov.au/newspaper/page/24101712 | 24101712 | |
45153 | 45153 | 1926-09-18 | 2 | f | War news from the Northwest China. | China | http://trove.nla.gov.au/newspaper/page/24101712 | 24101712 | |
45154 | 45154 | 1926-09-18 | 3 | d | Jiang Jieshi (Chiang Kai-shek) is keen to occupy Jiangxi province and his strategies. | China | http://trove.nla.gov.au/newspaper/page/24101711 | 24101711 | |
45155 | 45155 | 1926-09-18 | 3 | f | Sun Chuanfang's attitude towards Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24101711 | 24101711 | |
45156 | 45156 | 1926-09-18 | 3 | f | Defence plan of the Jiangxi authority. | China | http://trove.nla.gov.au/newspaper/page/24101711 | 24101711 | |
45160 | 45160 | 1926-09-18 | 7 | a | The war in Wuhan, of Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24101715 | 24101715 | |
45162 | 45162 | 1926-09-18 | 7 | b-c | The arrest and exile of Chinese immigrants in the Soviet Russia. | China | http://trove.nla.gov.au/newspaper/page/24101715 | 24101715 | |
45163 | 45163 | 1926-09-18 | 8 | a-d | Guangdong news/ The Nationalist government in Guangzhou issues the second bonds. Troops loot in Taishan county. Charity institutions in Guangzhou and their call for help in the disaster relief. Bandits in Gaoyao county. Zou Lu seeks collaboration with bandits in Xiangshan county. | China | http://trove.nla.gov.au/newspaper/page/24101718 | 24101718 |
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]);