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 |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 56122 | 56122 | 1936-08-01 | 3 | c | China and Germany secretly sign trade agreement. | Japan | http://trove.nla.gov.au/newspaper/page/24096937 | 24096937 | |
| 56123 | 56123 | 1936-08-01 | 3 | d | Exercise of British airforce troops. | Britain | http://trove.nla.gov.au/newspaper/page/24096937 | 24096937 | |
| 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 | |
| 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 | |
| 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 | |
| 56130 | 56130 | 1936-08-01 | 8 | d | French gunboats guard Bai Chongxi. | Hong Kong | 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 | |
| 56132 | 56132 | 1936-08-01 | 8 | d | France exports weapons to Spain. | Britain | http://trove.nla.gov.au/newspaper/page/24096944 | 24096944 | |
| 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]);