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 |
|---|---|---|---|---|---|---|---|---|---|
| 53816 | 53816 | 1934-02-03 | 2 | a | Editorial by Tung Wah Times provides advice to Zhang Xueliang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091519 | 24091519 | |
| 53817 | 53817 | 1934-02-03 | 2 | b | Battles between Fujian troops and the armies of the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24091519 | 24091519 | |
| 53818 | 53818 | 1934-02-03 | 2 | c | Liu Guitang and his troops commit banditry again. | China | http://trove.nla.gov.au/newspaper/page/24091519 | 24091519 | |
| 53819 | 53819 | 1934-02-03 | 2 | e | Japanese seek to invade Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24091519 | 24091519 | |
| 53820 | 53820 | 1934-02-03 | 2 | f | Plan of autonomous administration in Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24091519 | 24091519 | |
| 53821 | 53821 | 1934-02-03 | 3 | a | News on the war between Fujian troops and Jiang Jieshi's army. | China | http://trove.nla.gov.au/newspaper/page/24091518 | 24091518 | |
| 53822 | 53822 | 1934-02-03 | 3 | c | Soviet Russian foreign minister on the League of Nations. | Russia | http://trove.nla.gov.au/newspaper/page/24091518 | 24091518 | |
| 53823 | 53823 | 1934-02-03 | 3 | d | Struggle of political parties in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24091518 | 24091518 | |
| 53824 | 53824 | 1934-02-03 | 3 | e | Japan has agreed to protect the puppet Manchurian state. | China | http://trove.nla.gov.au/newspaper/page/24091518 | 24091518 | |
| 53825 | 53825 | 1934-02-03 | 5 | a | First part of an open letter from Wu Xianzi to Hu Hanmin. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091520 | 24091520 | |
| 53826 | 53826 | 1934-02-03 | 5 | d | Funeral service in Hong Kong for Dr Chen Zhongyuan. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24091520 | 24091520 | |
| 53827 | 53827 | 1934-02-03 | 5 | f | Tianjin customs detains smuggled antiques. | China | http://trove.nla.gov.au/newspaper/page/24091520 | 24091520 | |
| 53828 | 53828 | 1934-02-03 | 7-8 | a-f | Guangdong news/ Sun Ke arrives Guangzhou. Military officers from the north welcome Zhang Xueliang in Hong Kong. Zhang Renmin arrives Guangzhou from Guangxi. Xiang Hanpin resigns from the position of appeasement commissioner. Effort to promote trade between Australia, Hong Kong and the Nanyang area. Guangzhou commercial chamber to help local paper industry. Gambling in Taishan. A man returned from overseas is defrauded in Xinhui. | China | http://trove.nla.gov.au/newspaper/page/24091522 | 24091522 | |
| 53829 | 53829 | 1934-02-03 | 6 | f | The Nationalist government in Nanjing adopts Western calendar. | China | http://trove.nla.gov.au/newspaper/page/24091523 | 24091523 | |
| 53830 | 53830 | 1934-02-03 | 6 | g | Australia news/ Anniversary of the discovery of Australian continent. More suicides on the Sydney Harbour Bridge. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091523 | 24091523 |
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]);