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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
53808 | 53808 | 1934-01-27 | 6 | a | The puppet Manchurian state restores emperor system. | China | http://trove.nla.gov.au/newspaper/page/24091515 | 24091515 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
53812 | 53812 | 1934-01-27 | 6 | d | Japanese seek to colonise Chile. | America | http://trove.nla.gov.au/newspaper/page/24091515 | 24091515 | |
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 | |
53802 | 53802 | 1934-01-27 | 3 | e | France opposes to disarmament. | France | http://trove.nla.gov.au/newspaper/page/24091510 | 24091510 | |
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 | |
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 | |
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 | |
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]);