This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31061 | 31061 | 1916-03-25 | 3 | a-b | Political situation in Yunnan province. | China | http://trove.nla.gov.au/newspaper/page/24095202 | 24095202 | |
31062 | 31062 | 1916-03-25 | 3 | b-c | American ship on its way to Shanghai with gun powder. | China | http://trove.nla.gov.au/newspaper/page/24095202 | 24095202 | |
31063 | 31063 | 1916-03-25 | 3 | c | Protect the Nation Army (Hu guo jun) in Yunnan province and their moves. | China | http://trove.nla.gov.au/newspaper/page/24095202 | 24095202 | |
31064 | 31064 | 1916-03-25 | 3 | c-d | Battles in Yunnan province between the Republican army and government troops. | China | http://trove.nla.gov.au/newspaper/page/24095202 | 24095202 | |
31065 | 31065 | 1916-03-25 | 3 | d | Chaos following the reform in China (Yuan Shikai's army wins another battle in Sichuan province, Guangxi declares independence). | China | http://trove.nla.gov.au/newspaper/page/24095202 | 24095202 | |
31066 | 31066 | 1916-03-25 | 3 | e-f | Miscellaneous report on the World War I (military expenses of Britain, Germany, France, Russia, Austria and Italy; loss of Austrian army; war between Italy and Austria, war in Caucasus Mountains). | Other... | http://trove.nla.gov.au/newspaper/page/24095202 | 24095202 |
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]);