This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31059 | 31059 | 1916-03-25 | 2 | d-e | Fake public opinions in China during the debate on the state system. | China | http://trove.nla.gov.au/newspaper/page/24095203 | 24095203 | |
31060 | 31060 | 1916-03-25 | 2 | e-f | Further report on the assassination in the Xinhua Palace, Beijing. | China | http://trove.nla.gov.au/newspaper/page/24095203 | 24095203 | |
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 | |
31067 | 31067 | 1916-03-25 | 6 | a-b | Further report on the Funds Raising Organisation in Yunnan Province/Notice calling for donations and regulations of the organisation. | China | http://trove.nla.gov.au/newspaper/page/24095207 | 24095207 | |
31072 | 31072 | 1916-03-25 | 7 | b | Report on the political chaos in China following the independence of Guangxi province. | China | http://trove.nla.gov.au/newspaper/page/24095206 | 24095206 | |
31073 | 31073 | 1916-03-25 | 7 | c | Miscellaneous reports on the Chinese politics and officialdom. | China | http://trove.nla.gov.au/newspaper/page/24095206 | 24095206 | |
31076 | 31076 | 1916-03-25 | 8 | a-b | Beijing news/ Yuan Shikai helps the poor. Li Yuanhong refuses to congratulate Yuan Shikai. Another method to change the Chinese calendar by force. Li Liejun and Cai E to lead armies out of Yunnan province and on their way to the north. Volunteer army in Yunnan province after its independence. Chinese government to mediate the Yunnan disputes. | China | http://trove.nla.gov.au/newspaper/page/24095208 | 24095208 | |
31077 | 31077 | 1916-03-25 | 8 | b-c | Guangdong news/ Long Jianzhang is under investigation. Long Jiguang in panic. Guangdong army on their way to expedite Yunnan.Servicemen in Guangdong required to make oath. | China | http://trove.nla.gov.au/newspaper/page/24095208 | 24095208 |
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]);