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 |
|---|---|---|---|---|---|---|---|---|---|
| 56093 | 56093 | 1936-07-25 | 2 | b | Editorial on the circular telegram issued by the Guangzhou authority. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096930 | 24096930 | |
| 56094 | 56094 | 1936-07-25 | 2 | d | China news/ Railway construction completed from Xi'an to Xingping. Wang Shouting leads more warships to Fujian province. Students demonstration in Shanghai against Japanese invasion. Recent maneuverer of the central government troops. Song Zheyuan seeks to resign. Japanese to set up bank in Shanghai. Jiang Jieshi declares that he would never use military force towards internal groups. | China | http://trove.nla.gov.au/newspaper/page/24096930 | 24096930 | |
| 56095 | 56095 | 1936-07-25 | 3 | a | Japanese occupy the customs office in Tanggu, near Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24096929 | 24096929 | |
| 56096 | 56096 | 1936-07-25 | 3 | a | Shanghai may be on the same level with Berlin within five years. | Germany | http://trove.nla.gov.au/newspaper/page/24096929 | 24096929 | |
| 56097 | 56097 | 1936-07-25 | 3 | a | Chinese delegation to the International Labour Conference requests help to the industrial development in China. | Other... | http://trove.nla.gov.au/newspaper/page/24096929 | 24096929 | |
| 56098 | 56098 | 1936-07-25 | 3 | c | Song Zheyuan's troops are ordered to leave Tianjin for the south. | China | http://trove.nla.gov.au/newspaper/page/24096929 | 24096929 | |
| 56099 | 56099 | 1936-07-25 | 3 | c | Japanese airport in Changchun on fire. | China | http://trove.nla.gov.au/newspaper/page/24096929 | 24096929 | |
| 56100 | 56100 | 1936-07-25 | 3 | c | Wang Jingwei to return from overseas. | China | http://trove.nla.gov.au/newspaper/page/24096929 | 24096929 | |
| 56101 | 56101 | 1936-07-25 | 3 | d | American journalist reports from north China. | America | http://trove.nla.gov.au/newspaper/page/24096929 | 24096929 | |
| 56102 | 56102 | 1936-07-25 | 3 | e | Chinese Studies Association organised in Germany. | France | http://trove.nla.gov.au/newspaper/page/24096929 | 24096929 | |
| 56103 | 56103 | 1936-07-25 | 5 | a | Li Zongren on the anti-Japanese invasion and the national revolution, part II. | China | http://trove.nla.gov.au/newspaper/page/24096931 | 24096931 | |
| 56104 | 56104 | 1936-07-25 | 5 | c | Chinese communities in New Zealand and Australia donate to the Lingnan University in Guangzhou and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096931 | 24096931 | |
| 56105 | 56105 | 1936-07-25 | 6-7 | a-d | Guangdong news/ The coming conflict between Guangzhou and Nanjing. Dozens of military officers are arrested in Guangzhou. Military arrangement in Guangdong. People in Guangdong promote local products. Envoy of Wu Peifu arrives Guangzhou. Exhibition of air defence in Guangzhou. Military expansion in Guangdong. Wang Xunzhi on the military forces in Guangxi. Cai Tingkai expresses his desire to lead troops to fight Japanese. Floods in Zengcheng. Famine victims in Zhongshan. | China | http://trove.nla.gov.au/newspaper/page/24096934 | 24096934 | |
| 56106 | 56106 | 1936-07-25 | 8 | a | A prediction on the war in the Pacific region. | America | http://trove.nla.gov.au/newspaper/page/24096936 | 24096936 | |
| 56107 | 56107 | 1936-07-25 | 8 | a | Military expense of the American government. | America | http://trove.nla.gov.au/newspaper/page/24096936 | 24096936 | |
| 56108 | 56108 | 1936-07-25 | 8 | b | The war clouds over Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24096936 | 24096936 | |
| 56109 | 56109 | 1936-07-25 | 8 | c | The internal war in China is approaching. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24096936 | 24096936 | |
| 56110 | 56110 | 1936-07-25 | 8 | e | Arrest of dissidents in Poland. | Other... | http://trove.nla.gov.au/newspaper/page/24096936 | 24096936 | |
| 56111 | 56111 | 1936-07-25 | 8 | e | Chen Jitang arrives Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24096936 | 24096936 | |
| 56112 | 56112 | 1936-07-25 | 8 | f | Australia news/ Businessmen are required to keep English records. Advice to the tax payers on personal income tax. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096936 | 24096936 | |
| 56113 | 56113 | 1936-07-25 | 8 | f | Farewell message from Wu Ruixiang on his return to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096936 | 24096936 |
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]);