This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29289 | 29289 | 1914-10-03 | 8 | a-b | Chinese Masonic Society (hong men) in San Francisco refuses to cooperate with Sun Yatsen for his Third Revolution. American expert on the revolutionary movement in China. | America | http://trove.nla.gov.au/newspaper/page/24093276 | 24093276 | |
29290 | 29290 | 1914-10-03 | 8 | b | Beijing news/ Rebels occupy capital of Yunnan province. Chinese government to borrow internal loans in order to alleviate financial shortage. Premier Xu Shichang proposes to organise military police. Bailang bandits are suppressed. Chinese government seeks to send observers to the World War I. | China | http://trove.nla.gov.au/newspaper/page/24093276 | 24093276 | |
29291 | 29291 | 1914-10-03 | 8 | b-c | Guangdong news/ Commandership of security troops in Guangzhou. Financial staff in the Guangzhou government. Preparation for new coins to be issued. City wall to be renovated in Guangzhou. Guangdong people in Shanghai sell for charity. Many Chinese are returning from Hong Kong. Urgent need for flooding relief in Zhaoqing. Bandits hijack a train in Zengcheng county. Bandits in Zhaoqing hijack a ship for silk transportation. Police commissioner Deng Yaoguang in Guangzhou ban frivolous girls and boys. Li Guojun to discipline the defence. | China | http://trove.nla.gov.au/newspaper/page/24093276 | 24093276 |
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]);