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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
54423 | 54423 | 1934-08-11 | 6 | e | American President escapes from an assassination. | America | http://trove.nla.gov.au/newspaper/page/24096120 | 24096120 | |
54422 | 54422 | 1934-08-11 | 6 | e | Epidemic in India. | Other... | http://trove.nla.gov.au/newspaper/page/24096120 | 24096120 | |
54421 | 54421 | 1934-08-11 | 6 | d | The communist troops attack Fuzhou, Fujian province. | China | 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 | |
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 | |
54417 | 54417 | 1934-08-11 | 5 | f | Feng Yuxiang on the girl students. | China | http://trove.nla.gov.au/newspaper/page/24096117 | 24096117 | |
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 | |
54415 | 54415 | 1934-08-11 | 5 | a | French newspaper reports arms industry in Germany. | France | http://trove.nla.gov.au/newspaper/page/24096117 | 24096117 | |
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 | |
54413 | 54413 | 1934-08-11 | 3 | c | Japanese administration of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096115 | 24096115 | |
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 | |
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 |
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]);