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 |
---|---|---|---|---|---|---|---|---|---|
56123 | 56123 | 1936-08-01 | 3 | d | Exercise of British airforce troops. | Britain | http://trove.nla.gov.au/newspaper/page/24096937 | 24096937 | |
56128 | 56128 | 1936-08-01 | 8 | a | Revolution in Spain and the report. | Britain | http://trove.nla.gov.au/newspaper/page/24096944 | 24096944 | |
56129 | 56129 | 1936-08-01 | 8 | c | German defence arrangement along the Rhine River. | Britain | http://trove.nla.gov.au/newspaper/page/24096944 | 24096944 | |
56132 | 56132 | 1936-08-01 | 8 | d | France exports weapons to Spain. | Britain | http://trove.nla.gov.au/newspaper/page/24096944 | 24096944 | |
56115 | 56115 | 1936-08-01 | 2 | c | China news/ Japanese airforce troops in north China. Shi Yousan and other traitors kidnap Song Zheyuan's mother in Tianjin. The Nanjing government to expand its naval forces. Inner Mongolia declares independence. The war clouds in south Hunan province. Japanese regard Song Zheyuan the key enemy. Japanese military police in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24096938 | 24096938 | |
56116 | 56116 | 1936-08-01 | 2 | f | The Wing On Company in Shanghai converts its capital to Chinese currency. | China | http://trove.nla.gov.au/newspaper/page/24096938 | 24096938 | |
56118 | 56118 | 1936-08-01 | 3 | a | Japanese to organise a new government in Inner Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24096937 | 24096937 | |
56119 | 56119 | 1936-08-01 | 3 | a | Chinese troops in Manchuria bomb Japanese trains. | China | http://trove.nla.gov.au/newspaper/page/24096937 | 24096937 | |
56120 | 56120 | 1936-08-01 | 3 | b | Japanese troops in south China. | China | http://trove.nla.gov.au/newspaper/page/24096937 | 24096937 | |
56121 | 56121 | 1936-08-01 | 3 | b | Military cooperation between Soviet Russia and Czech. | China | http://trove.nla.gov.au/newspaper/page/24096937 | 24096937 | |
56127 | 56127 | 1936-08-01 | 6-7 | a-d | Guangdong news/ Military officers in Guizhou province support Guangdong authority for their anti-Japanese policy. A survey on the first-aid work in Guangzhou. Tang Shengzhi and his relations with Jiang Jieshi. Jiang Guanglai arrives Guangzhou. Tang Shengzhi in Hong Kong. Military news from Guangxi. Floods in Gaoyao and Gaoming. A case of murder in Xinhui. Fire alarm in Zhongshan. | China | http://trove.nla.gov.au/newspaper/page/24096942 | 24096942 | |
56131 | 56131 | 1936-08-01 | 8 | d | Silver flow from China to America. | China | http://trove.nla.gov.au/newspaper/page/24096944 | 24096944 | |
56130 | 56130 | 1936-08-01 | 8 | d | French gunboats guard Bai Chongxi. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24096944 | 24096944 | |
56117 | 56117 | 1936-08-01 | 3 | a | Japanese warships gather on the coast line of China. | Japan | http://trove.nla.gov.au/newspaper/page/24096937 | 24096937 | |
56122 | 56122 | 1936-08-01 | 3 | c | China and Germany secretly sign trade agreement. | Japan | http://trove.nla.gov.au/newspaper/page/24096937 | 24096937 | |
56114 | 56114 | 1936-08-01 | 2 | b | Editorial on the survival of the Chinese nation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096938 | 24096938 | |
56124 | 56124 | 1936-08-01 | 5 | a | Story of Zhang Zongxiang and Lu Zongyu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096939 | 24096939 | |
56125 | 56125 | 1936-08-01 | 5 | b | Chinese graduates from Japanese military academy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096939 | 24096939 | |
56126 | 56126 | 1936-08-01 | 5 | c | A meeting of board directors of the Guangming Electrical Factory in Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096939 | 24096939 | |
56133 | 56133 | 1936-08-01 | 8 | e | Australia news/ Italian consul in Sydney refuses to attend international gathering. An aged Chinese man dies in Darwin. A woman in Sydney wins Tattslotto. Member of NSW state parliament dies when delivering speech. Less Japanese cargo ships arrive Australia. Japanese exports toys to Australia. Japanese steal marine products from Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096944 | 24096944 |
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]);