This data as json, CSV (advanced)
Suggested facets: page, column, source, 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 | |
56179 | 56179 | 1936-08-22 | 3 | a | Japanese on the treaty talks between China and Germany. | Japan | http://trove.nla.gov.au/newspaper/page/24096961 | 24096961 | |
56180 | 56180 | 1936-08-22 | 3 | a | Japanese cultural and economic invasion of China. | Japan | http://trove.nla.gov.au/newspaper/page/24096961 | 24096961 | |
56181 | 56181 | 1936-08-22 | 3 | a | British House of Commons on the tax police in Beijing and Tianjin. | Britain | http://trove.nla.gov.au/newspaper/page/24096961 | 24096961 | |
56182 | 56182 | 1936-08-22 | 3 | a | Chinese community in the east of America farewell Wu Xianzi on his return to China. | America | http://trove.nla.gov.au/newspaper/page/24096961 | 24096961 | |
56183 | 56183 | 1936-08-22 | 3 | c | The trade war between America and Germany. | America | http://trove.nla.gov.au/newspaper/page/24096961 | 24096961 | |
56184 | 56184 | 1936-08-22 | 3 | c | Ancient graves found in Egypt. | Other... | http://trove.nla.gov.au/newspaper/page/24096961 | 24096961 | |
56185 | 56185 | 1936-08-22 | 3 | d | The naval force of Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24096961 | 24096961 | |
56186 | 56186 | 1936-08-22 | 3 | d | America and Soviet Russia agree to extend their trade agreement. | America | http://trove.nla.gov.au/newspaper/page/24096961 | 24096961 | |
56187 | 56187 | 1936-08-22 | 3 | e | Honduras quit the League of Nations. | Other... | http://trove.nla.gov.au/newspaper/page/24096961 | 24096961 | |
56188 | 56188 | 1936-08-22 | 5 | a | Farewell to Wu Xianzi on his return to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096963 | 24096963 | |
56189 | 56189 | 1936-08-22 | 5 | b | Wu Peifu entertains his guests. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096963 | 24096963 | |
56190 | 56190 | 1936-08-22 | 5 | c | Poems written by Chen Yuehu farewell Wu Xianzi on his return to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096963 | 24096963 | |
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 | |
56192 | 56192 | 1936-08-22 | 8 | a | The military existence of Soviet Russia in the Far East. | Britain | http://trove.nla.gov.au/newspaper/page/24096968 | 24096968 | |
56193 | 56193 | 1936-08-22 | 8 | a | Japanese troops enter Inner Mongolia. | Britain | http://trove.nla.gov.au/newspaper/page/24096968 | 24096968 | |
56194 | 56194 | 1936-08-22 | 8 | a | Japanese parliament criticises the government. | Japan | http://trove.nla.gov.au/newspaper/page/24096968 | 24096968 | |
56195 | 56195 | 1936-08-22 | 8 | b | Manchurian government imposes restrictions upon the import of Australian products. | Japan | http://trove.nla.gov.au/newspaper/page/24096968 | 24096968 | |
56196 | 56196 | 1936-08-22 | 8 | b | Further report on the revolutionary movement in Spain. | Britain | http://trove.nla.gov.au/newspaper/page/24096968 | 24096968 | |
56197 | 56197 | 1936-08-22 | 8 | c | The naval force of Italy. | Britain | http://trove.nla.gov.au/newspaper/page/24096968 | 24096968 | |
56198 | 56198 | 1936-08-22 | 8 | d | Floods in India. | Other... | http://trove.nla.gov.au/newspaper/page/24096968 | 24096968 | |
56199 | 56199 | 1936-08-22 | 8 | d | Bush fire in America. | America | http://trove.nla.gov.au/newspaper/page/24096968 | 24096968 | |
56200 | 56200 | 1936-08-22 | 8 | d | Japan to declare economic war with Australia. | Japan | http://trove.nla.gov.au/newspaper/page/24096968 | 24096968 | |
56201 | 56201 | 1936-08-22 | 8 | e | Japan reviews its police of invasion in China. | Britain | http://trove.nla.gov.au/newspaper/page/24096968 | 24096968 | |
56202 | 56202 | 1936-08-22 | 8 | f | Typhoon in Hong Kong and the casualties. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24096968 | 24096968 | |
56203 | 56203 | 1936-08-22 | 8 | f | Australia news/ New methods of opium smuggling in Brisbane. Chinese immigrants in Australia and their payment to agents' service. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096968 | 24096968 |
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]);