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 |
---|---|---|---|---|---|---|---|---|---|
56172 | 56172 | 1936-08-22 | 2 | b | Wang Kemin arrives Beijing and the exercise of Japanese troops. | China | http://trove.nla.gov.au/newspaper/page/24096962 | 24096962 | |
56173 | 56173 | 1936-08-22 | 2 | d | Registration of opium smokers in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24096962 | 24096962 | |
56174 | 56174 | 1936-08-22 | 2 | d | Guangxi provincial government to collect more grains for storage. | China | http://trove.nla.gov.au/newspaper/page/24096962 | 24096962 | |
56175 | 56175 | 1936-08-22 | 2 | e | Song Zheyuan's troops have conflict with Japanese troops in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24096962 | 24096962 | |
56176 | 56176 | 1936-08-22 | 2 | f | Japanese purchase rice in south Anhui province. | China | http://trove.nla.gov.au/newspaper/page/24096962 | 24096962 | |
56177 | 56177 | 1936-08-22 | 2 | f | A meeting of Japanese army officers in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24096962 | 24096962 | |
56178 | 56178 | 1936-08-22 | 2 | f | Chinese Ministry of Finance to help the Bank of Transportation. | China | http://trove.nla.gov.au/newspaper/page/24096962 | 24096962 | |
56191 | 56191 | 1936-08-22 | 6-7 | a-d | Guangdong news/ An open letter from the Central Government in Nanjing to the military commanders in Guangdong. Lin Yungai and Liu Jiwen arrive Hong Kong secretly. Jiang Guanglai seeks to reorganise the 19th Route Army. Guangdong airforce troops surrender to the Central Government. Gambling in Shunde county. Punishment on adultery in Meixian county. | China | http://trove.nla.gov.au/newspaper/page/24096966 | 24096966 |
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]);