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 |
---|---|---|---|---|---|---|---|---|---|
54423 | 54423 | 1934-08-11 | 6 | e | American President escapes from an assassination. | America | http://trove.nla.gov.au/newspaper/page/24096120 | 24096120 | |
54424 | 54424 | 1934-08-11 | 6 | f | Australia news/ Three aborigines in Darwin are sentenced for murdering a Japanese immigrant. Restrictions on the peanut import. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096120 | 24096120 | |
54420 | 54420 | 1934-08-11 | 6 | a | British troops in north China and their exercise. | China | http://trove.nla.gov.au/newspaper/page/24096120 | 24096120 | |
54411 | 54411 | 1934-08-11 | 2 | b | China news/ Railway transportation between Beijing and Shenyang. Fujian authority suppress pirates. Panchen Lama arrives Nanjing from Shanghai. Efforts to abolish exorbitant taxes. Heat wave swallow Hangzhou. A conference of military commanders in Shanxi province. Hot weather in Shanghai and the epidemic disease. | China | http://trove.nla.gov.au/newspaper/page/24096116 | 24096116 | |
54422 | 54422 | 1934-08-11 | 6 | e | Epidemic in India. | Other... | http://trove.nla.gov.au/newspaper/page/24096120 | 24096120 | |
54417 | 54417 | 1934-08-11 | 5 | f | Feng Yuxiang on the girl students. | China | http://trove.nla.gov.au/newspaper/page/24096117 | 24096117 | |
54415 | 54415 | 1934-08-11 | 5 | a | French newspaper reports arms industry in Germany. | France | http://trove.nla.gov.au/newspaper/page/24096117 | 24096117 | |
54419 | 54419 | 1934-08-11 | 6 | a | German President dies and a further report. | Germany | http://trove.nla.gov.au/newspaper/page/24096120 | 24096120 | |
54418 | 54418 | 1934-08-11 | 7-8 | a-f | Guangdong news/ Relationship between Guangzhou and Nanjing after the left of He Jian. Guangzhou and Nanjing are talking about political cooperation. Singapore seeks to get more Chinese immigrants. Fluctuation of the Hong Kong dollars. Two reasons of the failure of Guangdong's foreign trade. Business in Shantou. Zhongshan county magistrate Tang Shaoyi wants to resign. Clan fighting in Nanhai. Floods in Kaiping. Business decline in Foshan and Xinhui. | China | http://trove.nla.gov.au/newspaper/page/24096119 | 24096119 | |
54413 | 54413 | 1934-08-11 | 3 | c | Japanese administration of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096115 | 24096115 | |
54414 | 54414 | 1934-08-11 | 3 | e | Pirates in the Yellow River and the responses of the Shandong government. | China | http://trove.nla.gov.au/newspaper/page/24096115 | 24096115 | |
54421 | 54421 | 1934-08-11 | 6 | d | The communist troops attack Fuzhou, Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24096120 | 24096120 | |
54416 | 54416 | 1934-08-11 | 5 | c | Wu Peifu writes to his friends in south China. | China | http://trove.nla.gov.au/newspaper/page/24096117 | 24096117 | |
54412 | 54412 | 1934-08-11 | 2 | a | Zhang Xueliang talks about his visit to the east of Hubei. | China | http://trove.nla.gov.au/newspaper/page/24096116 | 24096116 |
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]);