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 |
---|---|---|---|---|---|---|---|---|---|
25421 | 25421 | 1911-12-16 | 3 | a | Revolution and its effects | Spreading revolution results in the Regent's retirement, pigtails cut all over China and use of western calendar. Government troops defeated revolutionary troops in Tianjin on their way back to Beijing, Hundred revolutionaries caught and killed by government troops in Pinghu (ppp). Negotiation on fire cease between government and revolutionaries broke and war between them starts again. Chinese gold and silver sold to foreign banks for money. Yuan Shikai's representative is to have peace talk with revolutionary representative in Hankou, Hubei. Revolutionaries are said not willing to have peace talk with government. They insist establishment of a republic China. | Other... | http://trove.nla.gov.au/newspaper/page/24092034 | 24092034 |
25422 | 25422 | 1911-12-16 | 3 | a | War likely between Britain and Germany | War likely happens between Britain and Germany over the issue of protecting French and Belgian borders against Germany's invasion. | Britain | http://trove.nla.gov.au/newspaper/page/24092034 | 24092034 |
25429 | 25429 | 1911-12-16 | 6 | a | Advertisement | Advertisement of the World's Chinese Students' Journal for promotion. | Other... | http://trove.nla.gov.au/newspaper/page/24092039 | 24092039 |
25430 | 25430 | 1911-12-16 | 6 | a | More about loss of Yichang | More about why Yichang lost to revolutionaries. | Other... | http://trove.nla.gov.au/newspaper/page/24092039 | 24092039 |
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]);