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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
56122 | 56122 | 1936-08-01 | 3 | c | China and Germany secretly sign trade agreement. | Japan | http://trove.nla.gov.au/newspaper/page/24096937 | 24096937 | |
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 | |
56125 | 56125 | 1936-08-01 | 5 | b | Chinese graduates from Japanese military academy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096939 | 24096939 | |
56119 | 56119 | 1936-08-01 | 3 | a | Chinese troops in Manchuria bomb Japanese trains. | China | 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 | |
56123 | 56123 | 1936-08-01 | 3 | d | Exercise of British airforce troops. | Britain | http://trove.nla.gov.au/newspaper/page/24096937 | 24096937 | |
56132 | 56132 | 1936-08-01 | 8 | d | France exports weapons to Spain. | Britain | 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 | |
56129 | 56129 | 1936-08-01 | 8 | c | German defence arrangement along the Rhine River. | Britain | http://trove.nla.gov.au/newspaper/page/24096944 | 24096944 | |
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 | |
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 | |
56120 | 56120 | 1936-08-01 | 3 | b | Japanese troops in south China. | China | http://trove.nla.gov.au/newspaper/page/24096937 | 24096937 | |
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 | |
56121 | 56121 | 1936-08-01 | 3 | b | Military cooperation between Soviet Russia and Czech. | China | 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 | |
56131 | 56131 | 1936-08-01 | 8 | d | Silver flow from China to America. | China | http://trove.nla.gov.au/newspaper/page/24096944 | 24096944 | |
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 | |
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 |
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]);