This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25297 | 25297 | 1911-11-18 | 7 | a | Notice of Sydney Empire Constitution Association | A notice calling for donations to Anhui and Liang Hu stricken by flooding. | Australia | http://trove.nla.gov.au/newspaper/page/24092005 | 24092005 |
25298 | 25298 | 1911-11-18 | 7 | a-b | Australia news | Two Australian warships are ordered to go to China to protect British people. Governor of New South Wales returns from abroad. Census of Sydney. A Japanese army official went to explore the South Pole. A Japanese training warship visits Australia. Two women were attacked in Mo Shi Wen(ppp). Teachers in New South Wales demand for pay rise. Chen Wu, a Chinese seaman was beaten by their European colleagues. | Australia | http://trove.nla.gov.au/newspaper/page/24092005 | 24092005 |
25299 | 25299 | 1911-11-18 | 7 | b | Riots record in China | Manchu troops are brutally killing innocent people. Foreigner are required to stay at home. People in Beijing welcome the return of Yuan Shikai. Wu Tingfang askes the emperor to retreat. Revolutionaries accidently killed each other. Her majesty asks Yuan Shikai protect the country. Wu Tingfang notifies foreign ambassadors that a new parliament is to set up in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24092005 | 24092005 |
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]);