This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25548 | 25548 | 1912-01-06 | 8 | a | Special envoy's letter to Yuan Shikai | Special envoy to Jiangsu Zhang Qian replies to Yuan Shikai about his views on China's political system. | Other... | http://trove.nla.gov.au/newspaper/page/24092065 | 24092065 |
25549 | 25549 | 1912-01-06 | 8 | a-b | Nanjing back to government control | Nanjing back to government control after several battles with revolutionary troops. | Other... | http://trove.nla.gov.au/newspaper/page/24092065 | 24092065 |
25550 | 25550 | 1912-01-06 | 8 | b-c | Wu asks foreign nations for their recognition | Minister for Foreign Affairs of Republic China Wu Tingfang calls his colleagues in America to ask ally foreign nations for their recognition of Republic China. | Other... | http://trove.nla.gov.au/newspaper/page/24092065 | 24092065 |
25551 | 25551 | 1912-01-06 | 8 | c | Yunnan army general concerns China's future | Yunnan army general Cai E calls for all army officials to express their views on how to save China. | Other... | http://trove.nla.gov.au/newspaper/page/24092065 | 24092065 |
25552 | 25552 | 1912-01-06 | 8 | c-d | Guangdong military government's statement | Guangdong republic military government issues a statement about promotion of a republic China. | Other... | http://trove.nla.gov.au/newspaper/page/24092065 | 24092065 |
25553 | 25553 | 1912-01-06 | 8 | d | Emperor's statement | The Regent announces content of emperor's statement for him. | Other... | http://trove.nla.gov.au/newspaper/page/24092065 | 24092065 |
25554 | 25554 | 1912-01-06 | 8 | d | Two poems | Two poems about things in Wuchang, Hubei. | Other... | http://trove.nla.gov.au/newspaper/page/24092065 | 24092065 |
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]);