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 |
---|---|---|---|---|---|---|---|---|---|
56205 | 56205 | 1936-08-29 | 2 | c | The Chinese Communist Party and their troops in the west of China. | China | http://trove.nla.gov.au/newspaper/page/24096970 | 24096970 | |
56206 | 56206 | 1936-08-29 | 2 | c | Shi Yousan to assume the office of governor of Hebei province. | China | http://trove.nla.gov.au/newspaper/page/24096970 | 24096970 | |
56207 | 56207 | 1936-08-29 | 2 | d | The central government in Nanjing to reorganise the finance in Guangdong. The Nanjing government to solve the Guangdong problems. | China | http://trove.nla.gov.au/newspaper/page/24096970 | 24096970 | |
56208 | 56208 | 1936-08-29 | 2 | f | Jiang Jieshi and his wife Song Meiling on holiday in Lushan Mountain of Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24096970 | 24096970 | |
56209 | 56209 | 1936-08-29 | 3 | a | Japanese to have a meeting in Taiwan for the invasion of south China. | China | http://trove.nla.gov.au/newspaper/page/24096969 | 24096969 | |
56210 | 56210 | 1936-08-29 | 3 | a | Japanese navy to have exercise in Taiwan. | China | http://trove.nla.gov.au/newspaper/page/24096969 | 24096969 | |
56217 | 56217 | 1936-08-29 | 6-7 | a-d | Guangdong news/ Zhang Da has given up Yingde county and retreated with his troops. A military meeting in Guangzhou. Huang Guangrui surrenders himself to the Central Government. Miu Peinan and his advice to Chen Jitang. Jiang Guanglai and Cai Tingkai reply to the Guangzhou authority. Guangdong compensates Guangxi for military expenses. Local security in local Guangdong. Silk price in Zhongshan. Heyuan county authority relaxes its control on the export of rice. A singing competition in Dongguan. | China | http://trove.nla.gov.au/newspaper/page/24096974 | 24096974 |
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]);