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 |
|---|---|---|---|---|---|---|---|---|---|
| 55359 | 55359 | 1935-08-24 | 2 | b | Japan seeks to set up a federation which comprises China, Manchuria, Korea and Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096545 | 24096545 | |
| 55360 | 55360 | 1935-08-24 | 2 | c | The communist existence in north Shaanxi province. | China | http://trove.nla.gov.au/newspaper/page/24096545 | 24096545 | |
| 55361 | 55361 | 1935-08-24 | 2 | d | Floods of the Yangtze and Yellow Rivers, the victims and their plea for help. | China | http://trove.nla.gov.au/newspaper/page/24096545 | 24096545 | |
| 55362 | 55362 | 1935-08-24 | 2 | d | Chinese communities in the Philippines donate to help Du Zhongyuan. | China | http://trove.nla.gov.au/newspaper/page/24096545 | 24096545 | |
| 55363 | 55363 | 1935-08-24 | 2 | f | Wang Jingwei flies to Qingdao for a rest. | China | http://trove.nla.gov.au/newspaper/page/24096545 | 24096545 | |
| 55364 | 55364 | 1935-08-24 | 2 | f | Japanese soldiers in north China. Jiang Zuobin flies to Chengdu, Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24096545 | 24096545 | |
| 55365 | 55365 | 1935-08-24 | 3 | a | Japanese warlords examine their China policy. | Japan | http://trove.nla.gov.au/newspaper/page/24096544 | 24096544 | |
| 55366 | 55366 | 1935-08-24 | 3 | a | Recent relations between Japan and Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24096544 | 24096544 | |
| 55367 | 55367 | 1935-08-24 | 3 | c | Internal fighting of Japanese army. | Japan | http://trove.nla.gov.au/newspaper/page/24096544 | 24096544 | |
| 55368 | 55368 | 1935-08-24 | 3 | c | British cotton businessmen urge their government to review the policy in the Far East. | Britain | http://trove.nla.gov.au/newspaper/page/24096544 | 24096544 | |
| 55369 | 55369 | 1935-08-24 | 3 | e | Japan and Manchuria may jointly manufacture warships secretly. | China | http://trove.nla.gov.au/newspaper/page/24096544 | 24096544 | |
| 55370 | 55370 | 1935-08-24 | 3 | e | Thailand government bans entry of Chinese newspapers. | China | http://trove.nla.gov.au/newspaper/page/24096544 | 24096544 | |
| 55371 | 55371 | 1935-08-24 | 3 | e | Japanese envoy comes to visit Australia. | Japan | http://trove.nla.gov.au/newspaper/page/24096544 | 24096544 | |
| 55372 | 55372 | 1935-08-24 | 5 | a | Responsibilities of the floods in China and the relief work. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096546 | 24096546 | |
| 55373 | 55373 | 1935-08-24 | 5 | f | Chinese communities in Melbourne donate to the Hanchi Hospital in Guangzhou and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096546 | 24096546 | |
| 55374 | 55374 | 1935-08-24 | 6-7 | a-f | Guangdong news/ Hu Hanming and Wang Chonghui meet in Italy and the new cooperation between Guangzhou and Nanjing. Smuggling of Japanese goods into Guangzhou and the investigation. Nuns in Guangzhou set up vegetarian restaurant to make a life. School teachers in Guangzhou demand payment of their salaries. Rice donated to the flooding areas in Zhongshan county are exempted from taxes. Banditry on the border of Jiangxi and Hunan province. Dozens of unemployed Chinese are returning from Vancouver, Canada. Improvement needed for the Chinese hand-woven fabrics to be sold in Nanyang. Private factories apply for registration of patent. Floods in Gaoyao and Gaoming. Relief work for the famine victims in Zhongshan county. Progress of water projects in Gaoyao. Group wedding in Taishan. | China | http://trove.nla.gov.au/newspaper/page/24096549 | 24096549 | |
| 55375 | 55375 | 1935-08-24 | 8 | a | The Chinese Chamber of Commerce in New South Wales calls for donations to the victims of the flooding areas of the Yangtze and Yellow Rivers. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096551 | 24096551 | |
| 55376 | 55376 | 1935-08-24 | 8 | a | American people look down upon the Emperor of Japan. | America | http://trove.nla.gov.au/newspaper/page/24096551 | 24096551 | |
| 55377 | 55377 | 1935-08-24 | 8 | e | Australian tourist is penalised in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096551 | 24096551 | |
| 55378 | 55378 | 1935-08-24 | 8 | f | Australia news/ Prime Minister talks about the sales tax in Sydney. Sailors on strike in Sydney. Germany may recognise the Manchurian state. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096551 | 24096551 |
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]);