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 |
|---|---|---|---|---|---|---|---|---|---|
| 54053 | 54053 | 1934-04-14 | 2 | a | Chinese volunteer troops in Manchuria vow to fight Japanese invaders, and comments by the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095972 | 24095972 | |
| 54054 | 54054 | 1934-04-14 | 2 | b | China news/ Declaration issued by the Nanjing government on the establishment of Manchurian state. Troops from Shanxi and Suiyun are on the way west to fight Sun Dianying. Jiang Jieshi enjoys his holiday in Nanchang. First part of the draft constitution of Republic of China. | China | http://trove.nla.gov.au/newspaper/page/24095972 | 24095972 | |
| 54055 | 54055 | 1934-04-14 | 3 | a | Japanese spy planes are shot down in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24095971 | 24095971 | |
| 54056 | 54056 | 1934-04-14 | 3 | a | Japanese propaganda on the economic cooperation between China and Japan. | China | http://trove.nla.gov.au/newspaper/page/24095971 | 24095971 | |
| 54057 | 54057 | 1934-04-14 | 3 | b | Japanese ambassador is bombed in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24095971 | 24095971 | |
| 54058 | 54058 | 1934-04-14 | 3 | c | Alliance troops of five provinces on the way to fight Sun Dianying. | China | http://trove.nla.gov.au/newspaper/page/24095971 | 24095971 | |
| 54059 | 54059 | 1934-04-14 | 3 | c | Unemployment in the United States of America. | America | http://trove.nla.gov.au/newspaper/page/24095971 | 24095971 | |
| 54060 | 54060 | 1934-04-14 | 3 | d | American parliament approves the new budget for navy. | America | http://trove.nla.gov.au/newspaper/page/24095971 | 24095971 | |
| 54061 | 54061 | 1934-04-14 | 3 | d | French newspaper predicts the war between Japan and Russia. | France | http://trove.nla.gov.au/newspaper/page/24095971 | 24095971 | |
| 54062 | 54062 | 1934-04-14 | 3 | e | Japanese troops still occupy fortifications along the Great Wall. | China | http://trove.nla.gov.au/newspaper/page/24095971 | 24095971 | |
| 54063 | 54063 | 1934-04-14 | 3 | f | Britain dispatches more troops to Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24095971 | 24095971 | |
| 54064 | 54064 | 1934-04-14 | 5 | c | New methods to quit opium smoking. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095973 | 24095973 | |
| 54065 | 54065 | 1934-04-14 | 5 | d | Dalai Lama and Tibet. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095973 | 24095973 | |
| 54066 | 54066 | 1934-04-14 | 7-8 | a-f | Guangdong news/ The southwest authority seeks suggestions from other provinces on the reform of provincial system. A public gathering in Guangzhou condemns Puyi. Tang Shaoyi on the current situation. Provincial government repeats its ban on torture. Zhang Yan and Ou Shounian are going overseas. Fujian authority and its pro-Japanese attitude. Two banks collapse in Guangzhou and the aftermath. Remains of Wu Chaoshu arrive Guangzhou. Xinhui county authority awards scholar Chen Baisha. Police in Taishan seize smuggled goods. | China | http://trove.nla.gov.au/newspaper/page/24095975 | 24095975 | |
| 54067 | 54067 | 1934-04-14 | 6 | a | Japan requests the League of Nations not to discuss the Manchurian problems. | Japan | http://trove.nla.gov.au/newspaper/page/24095976 | 24095976 | |
| 54068 | 54068 | 1934-04-14 | 6 | a | The Red Army in the Far East of Soviet Union. | Britain | http://trove.nla.gov.au/newspaper/page/24095976 | 24095976 | |
| 54069 | 54069 | 1934-04-14 | 6 | c | Population increase in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24095976 | 24095976 | |
| 54070 | 54070 | 1934-04-14 | 6 | c | Puyi comes to visit Beiping. | China | http://trove.nla.gov.au/newspaper/page/24095976 | 24095976 | |
| 54071 | 54071 | 1934-04-14 | 6 | d | Japan and Holland start trade talks. | Japan | http://trove.nla.gov.au/newspaper/page/24095976 | 24095976 | |
| 54072 | 54072 | 1934-04-14 | 6 | d | Afghanistan engages Japanese advisor. | Japan | http://trove.nla.gov.au/newspaper/page/24095976 | 24095976 | |
| 54073 | 54073 | 1934-04-14 | 6 | d | Chinese man arrested in Singapore for shooting dead a police officer. | Singapore | http://trove.nla.gov.au/newspaper/page/24095976 | 24095976 | |
| 54074 | 54074 | 1934-04-14 | 6 | e | Australia news/ Australia purchase cannons from overseas. Chinese businessman Sheng Peiti comes to visit Australia. Chinese gardener in Sydney sues a company for compensation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095976 | 24095976 |
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]);