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 |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 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 | |
| 54415 | 54415 | 1934-08-11 | 5 | a | French newspaper reports arms industry in Germany. | France | 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 | |
| 54417 | 54417 | 1934-08-11 | 5 | f | Feng Yuxiang on the girl students. | China | http://trove.nla.gov.au/newspaper/page/24096117 | 24096117 | |
| 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 | |
| 54419 | 54419 | 1934-08-11 | 6 | a | German President dies and a further report. | Germany | 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 | |
| 54421 | 54421 | 1934-08-11 | 6 | d | The communist troops attack Fuzhou, Fujian province. | China | 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 | |
| 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 |
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]);