This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54466 | 54466 | 1934-09-01 | 2 | b | China news/ Floods and drought in local provinces -- Henan, Hubei, Fujian, Shandong, Zhejiang and Anhui. Japan dispatches more troops to China as preparation for the war with Russia. The communists in Fujian province. Japanese troops in Beijing and their exercise. Yin Tong arrives Shanghai and reports the Dalian meeting. Gu Weijun talks to journalists on the international affairs. Huang Fu to chair the negotiation with Japanese in north China. Japanese seek to use the Muslim rebellions. | China | http://trove.nla.gov.au/newspaper/page/24096142 | 24096142 | |
54470 | 54470 | 1934-09-01 | 3 | b | Bandits in the war zones in China. | China | http://trove.nla.gov.au/newspaper/page/24096141 | 24096141 | |
54471 | 54471 | 1934-09-01 | 3 | b | Japanese troops in Tianjin. Yu Youren to meet Jiang Jieshi in Jiangxi. Chinese armies in Manchuria cooperate with Korean people. | China | http://trove.nla.gov.au/newspaper/page/24096141 | 24096141 | |
54479 | 54479 | 1934-09-01 | 6 | b | American farmers request to deport Japanese immigrants. | America | http://trove.nla.gov.au/newspaper/page/24096146 | 24096146 |
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]);