This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30981 | 30981 | 1916-02-26 | 3 | a-b | The public cable by the Yunnan Republican Troops to all soldiers on keeping social stabilities and to Chinese people on preserving republicanism. | China | http://trove.nla.gov.au/newspaper/page/24095170 | 24095170 | |
30982 | 30982 | 1916-02-26 | 3 | b-d | Origin of restoring imperial system/ Yuan Shikai conspires to be an emperor long ago. | China | http://trove.nla.gov.au/newspaper/page/24095170 | 24095170 | |
30983 | 30983 | 1916-02-26 | 3 | d | Chinese government conspires to restore imperial system and makes Zhang Sun as the first man advocate it. | China | http://trove.nla.gov.au/newspaper/page/24095170 | 24095170 | |
30984 | 30984 | 1916-02-26 | 3 | d-e | Battle situation in east Europe between Russian and German troops. | Russia | http://trove.nla.gov.au/newspaper/page/24095170 | 24095170 | |
30985 | 30985 | 1916-02-26 | 3 | e | Turkish troops cancel their plan to attack Suez Canal. | Britain | http://trove.nla.gov.au/newspaper/page/24095170 | 24095170 | |
30986 | 30986 | 1916-02-26 | 3 | e | Battle situation in Meng Di Nei Ge (ppp) between German and Meng's troops. | Other... | http://trove.nla.gov.au/newspaper/page/24095170 | 24095170 | |
30987 | 30987 | 1916-02-26 | 3 | e | Russian troops win another victory over Turkish troops in Gao Jia Suo(ppp). | Britain | http://trove.nla.gov.au/newspaper/page/24095170 | 24095170 | |
30988 | 30988 | 1916-02-26 | 3 | e | Statistics of war expenses of Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24095170 | 24095170 | |
30989 | 30989 | 1916-02-26 | 3 | e-f | Beijing news/Guizhou governor demands Yuan Shikai reject imperial system. Government troops in Jinzhou, Liaonin, are ordered to go southward. Yunnan Military Government orders to use income of salt. Heavy rains in northeast China cause worries. A tornado happens in Suolong, Jiangsu. | China | http://trove.nla.gov.au/newspaper/page/24095170 | 24095170 |
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]);