This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25638 | 25638 | 1912-01-27 | 2 | c | Current letters from Hubei | Teenage troop, women troop and monk troop are organised in Hubei to assist north expedition. Hubei troops welcome and respect troops from Hunan. | China | http://trove.nla.gov.au/newspaper/page/24092083 | 24092083 |
25639 | 25639 | 1912-01-27 | 2 | c | A glorious deed of a Hunan army officer | Liu Yutang, a Hunanese, led a troop bravely fighting against the enemy troops and died in the battle. | China | http://trove.nla.gov.au/newspaper/page/24092083 | 24092083 |
25654 | 25654 | 1912-01-27 | 3 | c | Beijing news | La Tong's properties vanishes in an insurance company that has disappeared. Shangdong government is brutally killing revolutionaries. Chen Bianlong arrested and killed Wang Zhongsheng. Liang Xinghai is discarded by its people after visiting Yuan Shikai. Some managers of silk stores in Shanghai oppose cutting queue. | http://trove.nla.gov.au/newspaper/page/24092082 | 24092082 | |
25667 | 25667 | 1912-01-27 | 7 | c | The emperor's abdication may fail | Her majesty opposes the emperor's abdication. | America | http://trove.nla.gov.au/newspaper/page/24092086 | 24092086 |
25668 | 25668 | 1912-01-27 | 7 | c | Brief introduction about Bian Zhenxing | Bian Zhengxing is a straightforward and brave army official in the north expedition army. | Other... | http://trove.nla.gov.au/newspaper/page/24092086 | 24092086 |
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]);