This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31053 | 31053 | 1916-03-18 | 7 | a | Australia news/German schools in Victoria are banned for their improper teaching. A 4-year old girl is brutally murdered in Melbourne. Some 19 Chinese are arrested for gambling in Sydney. Chinese consul general notifies that government troops defeat Yunnan revolutionary troops. | Australia | http://trove.nla.gov.au/newspaper/page/24095198 | 24095198 | |
31054 | 31054 | 1916-03-18 | 7 | a-b | News miscellany/Yunnan Republican troops occupy Louzhou and other cities. Chinese Political Elimination Department urges Yuan Shikai to quit imperial system. Government troops are to have a decisive battle with the Yunnan Republican Troops. Chinese government takes back the artificial documents of people's views from provincial governments. Guizhou declares independence. Yuan Shikai mails huge amount of money to Britain for his end. Yuan Shikai orders his officials to urge him to put an end of imperial system and to punish Yang Du and others. Chinese government sets up an assassinating team in order to murder Liang Qichao. Chinese government orders to elect representatives to Beijing discussing rejecting imperial system. Guangdong government troops are defeated by the revolutionary troops. | China | http://trove.nla.gov.au/newspaper/page/24095198 | 24095198 |
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]);