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 |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 55249 | 55249 | 1935-07-13 | 2 | c | Chinese financial authority to reduce export tariff. | China | http://trove.nla.gov.au/newspaper/page/24096497 | 24096497 | |
| 55250 | 55250 | 1935-07-13 | 2 | d | Report on the north China crisis. | China | http://trove.nla.gov.au/newspaper/page/24096497 | 24096497 | |
| 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 | |
| 55252 | 55252 | 1935-07-13 | 3 | a | A plea from the overseas Chinese communities. | China | http://trove.nla.gov.au/newspaper/page/24096496 | 24096496 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 55257 | 55257 | 1935-07-13 | 8 | a | Floods in Japan. | Japan | 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 | |
| 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 | |
| 55260 | 55260 | 1935-07-13 | 8 | a | Independence celebration in America. | America | 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 | |
| 55262 | 55262 | 1935-07-13 | 8 | c | Italy and Algeria are ready to fight. | Other... | http://trove.nla.gov.au/newspaper/page/24096502 | 24096502 | |
| 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 |
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]);