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 |
---|---|---|---|---|---|---|---|---|---|
29345 | 29345 | 1914-10-31 | 3 | a | Chinese foreign ministry notifies foreign missions in Beijing in regards to the war zones in Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24093303 | 24093303 | |
29346 | 29346 | 1914-10-31 | 3 | a | Japan has revised its China policy. | Japan | http://trove.nla.gov.au/newspaper/page/24093303 | 24093303 | |
29347 | 29347 | 1914-10-31 | 3 | a | American newspaper comments on the neutrality of China in the World War I. | America | http://trove.nla.gov.au/newspaper/page/24093303 | 24093303 | |
29351 | 29351 | 1914-10-31 | 6 | a | Chinese Consulate-General in New Zealand reports that Chinese passenger Ye Zuoyi jumps into the sea on his way from Tahiti to New Zealand, and report by the captain. | New Zealand | http://trove.nla.gov.au/newspaper/page/24093308 | 24093308 | |
29358 | 29358 | 1914-10-31 | 8 | a | Guangdong news/ Central government advises Guangdong not to comment on the victory or defeat of the World War I. Li Guojun and his policy to maintain local security. Tang Hualong recommends Lu Naixiang. Guangdong people purchase government bonds. Assassination in the west of Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24093310 | 24093310 | |
29359 | 29359 | 1914-10-31 | 8 | a | Chinese communities in Australia and New Zealand donate to the flooding area in Guangdong. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093310 | 24093310 |
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]);