This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30159 | 30159 | 1915-06-13 | 7 | b | News miscellany/Kai Yuwei's confiscated properties are to be returned. Xinghui county in Guangdong defeated bandits troop. A passenger ship in Macau is exploded resulting from engine problem. Warships are sending ammunition to North China for defending purposes. Chinese people are angered by Japanese demands. Liang Qicao returns to Guangdong from Beijing. People in Guangdong are advising to donate for rescuing China. Yuan Shikai is discussing with ministers over negotiation with Japan. Sun Yatsen and his followers return to China and attempt to start another revolution. Japan demands Guangdong to quit the activities of promoting national products. Guangdong businessmen strike to oppose the government act of levying tax on teas. | China | |||
30160 | 30160 | 1915-06-13 | 7 | a | Australian news/ Chinese consul general notifies all Chinese in Australia to purchase passports as British government requires. Statistics of Australian soldiers killed and wounded in the Europe War. Twelve illegal immigrants are found in a ship in Brisbane. A German man commits suicide after having killed his wife and children in South Australia. A comet appears in Perth. A British company in Sydney, allegedly believed to be run by German people, is suffered from loss as Chinese refuse to buy goods from it. | Australia | |||
30161 | 30161 | 1915-06-13 | 7 | b | News from New Zealand about election of China's Association there. | New Zealand | |||
30162 | 30162 | 1915-06-13 | 7 | b | Battle situation in west Europe between British, French and German troops. | Other... | |||
30163 | 30163 | 1915-06-13 | 7 | b-c | Battle situation in east Europe between Russian and Turkish troops. | Other... |
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]);