This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25252 | 25252 | 1911-11-11 | 2 | a-b | The relaltions between the government and people after the revolution. | The future government and people should cooperate to build a constitutional country in China. | Other... | http://trove.nla.gov.au/newspaper/page/24091993 | 24091993 |
25261 | 25261 | 1911-11-11 | 3 | a-b | Riots record in China | Yuan Shikai is negotiating with Li Yuanhong. Military revolts in various places result in huge casualties. Wu Tingfang is on the side of revolutionaries. Zi Zheng Yuan admits differences between revolutionary parties and the riot bandits. | China | http://trove.nla.gov.au/newspaper/page/24091992 | 24091992 |
25269 | 25269 | 1911-11-11 | 6 | a-b | War between Italy and Turkey | Italy's troops defeats Turkish troops repeatedly. | Other... | http://trove.nla.gov.au/newspaper/page/24091997 | 24091997 |
25274 | 25274 | 1911-11-11 | 7 | a-b | Australia news | British government admits Portugal a democratic country. New South Wales welcomes European immigrants. Statistics of New South Wales's government debt. Income of railways in New South Wales. A Chinese woman shot a Chinese man. An European is murdered in Sydney. Begg's Whisky is popular. Tangye Oil Engine is advised to Chinese. | Australia | http://trove.nla.gov.au/newspaper/page/24091996 | 24091996 |
25280 | 25280 | 1911-11-11 | 8 | a-b | Informations of riots in Shichun | Informations on robberies, strikes and other riots in Shichun. | China | http://trove.nla.gov.au/newspaper/page/24091999 | 24091999 |
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]);