This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27612 | 27612 | 1913-07-19 | 3 | a | People in Jiujiang, of Guangdong province, condemn traitors. | China | http://trove.nla.gov.au/newspaper/page/24092752 | 24092752 | |
27613 | 27613 | 1913-07-19 | 3 | a | Another draft treaty to be discussed between China and Russia. | China | http://trove.nla.gov.au/newspaper/page/24092752 | 24092752 | |
27614 | 27614 | 1913-07-19 | 3 | a | China and Britain discuss the Tibet issues. | China | http://trove.nla.gov.au/newspaper/page/24092752 | 24092752 | |
27615 | 27615 | 1913-07-19 | 3 | a | A local authority in America ban Japanese to take bath in public. | Britain | http://trove.nla.gov.au/newspaper/page/24092752 | 24092752 | |
27616 | 27616 | 1913-07-19 | 3 | a | War declared in the Balkan peninsula. | Britain | http://trove.nla.gov.au/newspaper/page/24092752 | 24092752 | |
27617 | 27617 | 1913-07-19 | 3 | a | A man is sentenced to death for attempting to assassinate King of Spain. | Other... | http://trove.nla.gov.au/newspaper/page/24092752 | 24092752 | |
27618 | 27618 | 1913-07-19 | 3 | a | Royal British navy to have an exercise. | Britain | http://trove.nla.gov.au/newspaper/page/24092752 | 24092752 | |
27619 | 27619 | 1913-07-19 | 3 | b | Prince of Britain visits Germany, Austria and Hungary. | Britain | http://trove.nla.gov.au/newspaper/page/24092752 | 24092752 | |
27620 | 27620 | 1913-07-19 | 3 | b | Riots in Morocco. | Britain | http://trove.nla.gov.au/newspaper/page/24092752 | 24092752 | |
27621 | 27621 | 1913-07-19 | 3 | b | Reform movement in Poland and the possible influence. | Britain | http://trove.nla.gov.au/newspaper/page/24092752 | 24092752 | |
27622 | 27622 | 1913-07-19 | 3 | b | King of Britain visits villagers in the west of the country. | Britain | http://trove.nla.gov.au/newspaper/page/24092752 | 24092752 | |
27623 | 27623 | 1913-07-19 | 3 | b | American authority refuse to grant citizenship to Japanese immigrants. | Japan | http://trove.nla.gov.au/newspaper/page/24092752 | 24092752 | |
27624 | 27624 | 1913-07-19 | 3 | b | Irish people protest against the self-government proposal. | Britain | http://trove.nla.gov.au/newspaper/page/24092752 | 24092752 | |
27625 | 27625 | 1913-07-19 | 3 | b | Storm in the south of Italy and the damages. | Other... | http://trove.nla.gov.au/newspaper/page/24092752 | 24092752 | |
27626 | 27626 | 1913-07-19 | 3 | b | Detailed report on the war in the Balkan peninsula. | Other... | http://trove.nla.gov.au/newspaper/page/24092752 | 24092752 | |
27627 | 27627 | 1913-07-19 | 3 | c-d | Beijing news/ President Yuan Shikai on the national unification. Zhang Taiyan condemns Sun Yatsen and Huang Xing. Feng Guozhang might move to Wuhan. Chinese ambassador to Austria Shen Ruilin on China's diplomacy. Branch of the Progress Party in Hunan province on the current situation. Urge to investigate Li Liejun. Ni Sichong might replace Bai Wenwei as governor of Anhui province. Chinese authority seeks mining engineers. Xu Qiwen is brought to trial in a military court. | China | http://trove.nla.gov.au/newspaper/page/24092752 | 24092752 | |
27628 | 27628 | 1913-07-19 | 3 | d | Guangdong news/ Long Jiguang refutes a rumour. Financial revenue in Guangdong. Looting in Xinning county. Cargo ship Taian is detained for weapon smuggling. Bandits in Gaoyao county. | China | http://trove.nla.gov.au/newspaper/page/24092752 | 24092752 |
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]);