This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24181 | 24181 | 1911-01-21 | 2 | c | The Cabinet's plea for an amnesty of the political prisoners and exiles associated with the reform movement | The Cabinet proposes to amnesty those political prisoners and exiles associated with the reform movement. | China | http://trove.nla.gov.au/newspaper/page/24091605 | 24091605 |
24197 | 24197 | 1911-01-21 | 3 | c | Issues concerning cutting queue | Many sectors of Chinese, including students, police, army and etc. began to cut off their queue, whereas some officials, such as Prince Qin, strongly rejected the idea; a national policy on this matter remained unsettled. | China | http://trove.nla.gov.au/newspaper/page/24091604 | 24091604 |
24210 | 24210 | 1911-01-21 | 8 | c | Prince Qin nearly got assassinated | Prince Qin nearly got assassinated on his way out of the imperial palace. | http://trove.nla.gov.au/newspaper/page/24091611 | 24091611 | |
24211 | 24211 | 1911-01-21 | 8 | c | The magic of Buddha | A joke about how one high-level official was promoted only with the help of Buddha. | China | http://trove.nla.gov.au/newspaper/page/24091611 | 24091611 |
24212 | 24212 | 1911-01-21 | 8 | c | Women only | There exists a female-ruled tribe in a place called Peisi in Russia; there exists a women's only bank in Britain. | Other... | http://trove.nla.gov.au/newspaper/page/24091611 | 24091611 |
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]);