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 |
---|---|---|---|---|---|---|---|---|---|
55252 | 55252 | 1935-07-13 | 3 | a | A plea from the overseas Chinese communities. | China | http://trove.nla.gov.au/newspaper/page/24096496 | 24096496 | |
55251 | 55251 | 1935-07-13 | 3 | a | American President Roosevelt convenes a meeting for economic recovery. | America | http://trove.nla.gov.au/newspaper/page/24096496 | 24096496 | |
55263 | 55263 | 1935-07-13 | 8 | e | Australia news/ Australia's import and export last year. Flour price going down in Sydney. An aged man in South Australia. Archaeological findings in Goulburn. Wu Zhimei arrives Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096502 | 24096502 | |
55261 | 55261 | 1935-07-13 | 8 | c | Aviation industry in Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24096502 | 24096502 | |
55258 | 55258 | 1935-07-13 | 8 | b | Border dispute between Russia and Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096502 | 24096502 | |
55249 | 55249 | 1935-07-13 | 2 | c | Chinese financial authority to reduce export tariff. | China | http://trove.nla.gov.au/newspaper/page/24096497 | 24096497 | |
55254 | 55254 | 1935-07-13 | 3 | b | Chinese government starts press censorship for foreign news report. | China | http://trove.nla.gov.au/newspaper/page/24096496 | 24096496 | |
55257 | 55257 | 1935-07-13 | 8 | a | Floods in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096502 | 24096502 | |
55256 | 55256 | 1935-07-13 | 6-7 | a-f | Guangdong news/ Jiang Jieshi in Nanjing and the north China crisis. Power disputes in the southwest of China. Businessmen in Shilong town of Nanhai county refuse to paying taxes. Li Shufen on the health of Guangzhou residents. Fan Dexing to convene an agricultural conference of seven counties. The southwest authority issues new regulations for press censorship. Guangzhou to become a park city. Murderer of Liao Zhongkai is executed. Japanese goods sell well in south China. Fighting in Xinhui county to protest against heavy land tax. Hooligans in Taishan make trouble during drama performance. Local security in Dongguan county. | China | http://trove.nla.gov.au/newspaper/page/24096501 | 24096501 | |
55260 | 55260 | 1935-07-13 | 8 | a | Independence celebration in America. | America | http://trove.nla.gov.au/newspaper/page/24096502 | 24096502 | |
55262 | 55262 | 1935-07-13 | 8 | c | Italy and Algeria are ready to fight. | Other... | http://trove.nla.gov.au/newspaper/page/24096502 | 24096502 | |
55253 | 55253 | 1935-07-13 | 3 | a | Key points of the trade agreement between China and Vietnam. | China | http://trove.nla.gov.au/newspaper/page/24096496 | 24096496 | |
55255 | 55255 | 1935-07-13 | 3 | c | Ma Yinchu publishes essay on Chinese financial policy. | China | http://trove.nla.gov.au/newspaper/page/24096496 | 24096496 | |
55259 | 55259 | 1935-07-13 | 8 | b | New Life magazine is closed down in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24096502 | 24096502 | |
55250 | 55250 | 1935-07-13 | 2 | d | Report on the north China crisis. | China | http://trove.nla.gov.au/newspaper/page/24096497 | 24096497 | |
55248 | 55248 | 1935-07-13 | 2 | b | Second and final part of comments on the north China crisis by Li Jishen, Chen Mingshu, Jiang Guanglai and Cai Tingkai. | China | http://trove.nla.gov.au/newspaper/page/24096497 | 24096497 |
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]);