This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id
source 9 ✖
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 53795 | 53795 | 1934-01-27 | 2 | a | Second part of an open letter from Hu Hanmin on the current situations. | China | http://trove.nla.gov.au/newspaper/page/24091511 | 24091511 | |
| 53796 | 53796 | 1934-01-27 | 2 | c | Civilian associations in Fujian province urge Jiang Jieshi to stop bombing. | China | http://trove.nla.gov.au/newspaper/page/24091511 | 24091511 | |
| 53797 | 53797 | 1934-01-27 | 2 | d | Zhu Qiqing and his suggestions to save China. | China | http://trove.nla.gov.au/newspaper/page/24091511 | 24091511 | |
| 53798 | 53798 | 1934-01-27 | 2 | e | Troops of the Nanjing government take over Mawei Port on the coast of Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24091511 | 24091511 | |
| 53799 | 53799 | 1934-01-27 | 2 | f | Resolutions of the Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24091511 | 24091511 | |
| 53800 | 53800 | 1934-01-27 | 2 | f | Shanghai to build the biggest airport in Asia. | China | http://trove.nla.gov.au/newspaper/page/24091511 | 24091511 | |
| 53801 | 53801 | 1934-01-27 | 3 | a | Jiang Jieshi's warplanes show off in Fujian. Other news on the military conflict between Fujian and the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24091510 | 24091510 | |
| 53802 | 53802 | 1934-01-27 | 3 | e | France opposes to disarmament. | France | http://trove.nla.gov.au/newspaper/page/24091510 | 24091510 | |
| 53803 | 53803 | 1934-01-27 | 5 | a | Editorial on the warplanes of the Nanjing government bombing Fujian province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091512 | 24091512 | |
| 53804 | 53804 | 1934-01-27 | 5 | c | A robbery at the Wing On Company in Shanghai and the investigation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091512 | 24091512 | |
| 53805 | 53805 | 1934-01-27 | 5 | e | A Russian newspaper issues more copies than any others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091512 | 24091512 | |
| 53806 | 53806 | 1934-01-27 | 5 | f | Australia news/ Ma Lianghua becomes principal of the Sydney Chinese School while Rev. Liang Lanxin is the supervisor. Fire on the George Street, Sydney. Notice of admission of the Sydney Chinese School. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091512 | 24091512 | |
| 53807 | 53807 | 1934-01-27 | 7-8 | a-f | Guangdong news/ Xiao Focheng condemns the Nanjing government for their bombing of Fujian. Report on the bombing of Fujian by Jiang Jieshi's warplanes. Decline of the silk industry in Guangdong. Business in Shiqi town, Shunde county. Villagers in Nanhai county set fire on the police office. | China | http://trove.nla.gov.au/newspaper/page/24091514 | 24091514 | |
| 53808 | 53808 | 1934-01-27 | 6 | a | The puppet Manchurian state restores emperor system. | China | http://trove.nla.gov.au/newspaper/page/24091515 | 24091515 | |
| 53809 | 53809 | 1934-01-27 | 6 | b | Resistance of revolutionary army in Fuzhou, capital of Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24091515 | 24091515 | |
| 53810 | 53810 | 1934-01-27 | 6 | c | Peaceful solution to the disputes between Japan and Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24091515 | 24091515 | |
| 53811 | 53811 | 1934-01-27 | 6 | c | Chen Youren leaves Fuzhou for Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24091515 | 24091515 | |
| 53812 | 53812 | 1934-01-27 | 6 | d | Japanese seek to colonise Chile. | America | http://trove.nla.gov.au/newspaper/page/24091515 | 24091515 | |
| 53813 | 53813 | 1934-01-27 | 6 | f | Three Chinese in Vancouver, Canada, die from beriberi. | Canada | http://trove.nla.gov.au/newspaper/page/24091515 | 24091515 | |
| 53814 | 53814 | 1934-01-27 | 6 | g | Italian Prime Minister Mussolini on the Yellow Peril. | Japan | http://trove.nla.gov.au/newspaper/page/24091515 | 24091515 | |
| 53815 | 53815 | 1934-01-27 | 6 | g | Sydney reintroduces old traffic regulations. | South America | http://trove.nla.gov.au/newspaper/page/24091515 | 24091515 |
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]);