This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
4398 | 4398 | 1900-01-10 | 2 | a-c | The first part of a memorial report from Shen Peng, of the Imperial Academy. | China | http://trove.nla.gov.au/newspaper/page/24102667 | 24102667 | |
4400 | 4400 | 1900-01-10 | 2 | c-d | A robbery case in Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24102667 | 24102667 | |
4406 | 4406 | 1900-01-10 | 2 | e | A man in Shashi city, Hubei province, was sentenced for killing his wife. | China | http://trove.nla.gov.au/newspaper/page/24102667 | 24102667 | |
4412 | 4412 | 1900-01-10 | 2 | f | Governor of Sichuan suggests changes China's military service system following Japan's example. | China | http://trove.nla.gov.au/newspaper/page/24102667 | 24102667 | |
4413 | 4413 | 1900-01-10 | 3 | a | A woman in Chuansha plotted with her adulterer to murder her husband. | China | http://trove.nla.gov.au/newspaper/page/24102666 | 24102666 | |
4414 | 4414 | 1900-01-10 | 3 | a | Robbery cases in Sihui county, Guangdong province. | China | http://trove.nla.gov.au/newspaper/page/24102666 | 24102666 | |
4416 | 4416 | 1900-01-10 | 3 | c | More clashes between French soldiers and local Chinese residents in the Guangzhou Bay. | China | http://trove.nla.gov.au/newspaper/page/24102666 | 24102666 | |
4422 | 4422 | 1900-01-10 | 3 | d | Graduates from Jiangnan Military School were sent overseas for further training. | China | http://trove.nla.gov.au/newspaper/page/24102666 | 24102666 | |
4423 | 4423 | 1900-01-10 | 3 | d | A new society has been established in Mongolia. All members are required not to smoke, drink, etc. | China | http://trove.nla.gov.au/newspaper/page/24102666 | 24102666 |
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]);