This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26041 | 26041 | 1912-04-20 | 3 | b-c | Beijing news | President Yuan intends to come to Nanjing to take his office. Beijing government has another foreign loan from Italy. President Sun orders to ban export of Jiangsu rice. A German intends to have Chinese nationality. North Expeditionary army is supplied with more ammunition. Nanjing magistrate has strong power. Qingdao, Shandong becomes a refuge for Qing government officials. China Bank regains tax right from foreign banks. Cen Xiling is to take Gansu governorship. Northern three provinces may become anti-republic base. | Other... | http://trove.nla.gov.au/newspaper/page/24092207 | 24092207 |
26044 | 26044 | 1912-04-20 | 6 | b-c | Merciless government troops | Merciless government troops rob, rape and set fire on Yuncheng town in Shanxi. | Other... | http://trove.nla.gov.au/newspaper/page/24092212 | 24092212 |
26048 | 26048 | 1912-04-20 | 8 | b-c | Current situation in China | Some Beijing government officials do not want to follow Nanjing government. President Yuan appoints Huang Xing army chief. soldier rebel under control in Nanjing. Former financial minister appointed head of Shandong province. Former army general of Qing government Zhang Xun does not allow republic army to use railways under his control in Shandong. | Other... | http://trove.nla.gov.au/newspaper/page/24092214 | 24092214 |
26053 | 26053 | 1912-04-20 | 8 | b-c | Guangdong warlords executed | Two key Guangdong warlords executed. | Other... | http://trove.nla.gov.au/newspaper/page/24092214 | 24092214 |
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]);