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 |
---|---|---|---|---|---|---|---|---|---|
25634 | 25634 | 1912-01-27 | 2 | a | Personnel and administration system of the new government should take lessons from the Qing government | A comment suggests that the new government should be careful of using officials, putting the interest of country and people above anything else. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092083 | 24092083 |
25642 | 25642 | 1912-01-27 | 3 | a | Records of assassinations on Yuan Shikai | The bombs for assassinating Yuan Shikai were made by Japanese and three assassinates were hanged. | China | http://trove.nla.gov.au/newspaper/page/24092082 | 24092082 |
25643 | 25643 | 1912-01-27 | 3 | a | Shangxi and Henan in panic | Government troops and revolutionary troops are both killing people carelessly in Shangxi and Henan, leading to a state of anarchism. | China | http://trove.nla.gov.au/newspaper/page/24092082 | 24092082 |
25644 | 25644 | 1912-01-27 | 3 | a | Man nationality's abdication | Man emperor plans to abdicate and Yuan Shikai is to be the first president of the republic if the revolutionaries accept the peace negotiation. | China | http://trove.nla.gov.au/newspaper/page/24092082 | 24092082 |
25645 | 25645 | 1912-01-27 | 3 | a | Man people attempt to keep their money | Man royal families oppose to give away their money for government troops. | China | http://trove.nla.gov.au/newspaper/page/24092082 | 24092082 |
25646 | 25646 | 1912-01-27 | 3 | a | Demand for recognition | The Republic of China demands recognition from America , who awaits for other big powers's views. | America | http://trove.nla.gov.au/newspaper/page/24092082 | 24092082 |
25647 | 25647 | 1912-01-27 | 3 | a | Ship construction in Britain | Over 700 ships were built in Britain in the previous year. | Britain | http://trove.nla.gov.au/newspaper/page/24092082 | 24092082 |
25648 | 25648 | 1912-01-27 | 3 | a | Huge fire in Japan | A fire in Japanese Da Bang (ppp) resulted in huge casualties. | Japan | http://trove.nla.gov.au/newspaper/page/24092082 | 24092082 |
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]);