This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 31151 | 31151 | 1916-04-22 | 2 | a-d | First part of the public notice issued by the Saving the Nation Army (hu guo jun) in Yunnan province under the leadership of Tang Jiyao, Cai E and Li Liejun. | China | http://trove.nla.gov.au/newspaper/page/24095236 | 24095236 | |
| 31152 | 31152 | 1916-04-22 | 2 | d-f | An observation by the Tung Wah Times on the peace talks between the South and the North in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095236 | 24095236 | |
| 31153 | 31153 | 1916-04-22 | 2-3 | f-a | Third part of the true report on the uprising in Yunnan province. | China | http://trove.nla.gov.au/newspaper/page/24095236 | 24095236 | |
| 31154 | 31154 | 1916-04-22 | 3 | b | Representatives of students, businessmen and gentry write to Long Jiguang and their letter. | China | http://trove.nla.gov.au/newspaper/page/24095235 | 24095235 | |
| 31155 | 31155 | 1916-04-22 | 3 | b-c | Wang Tieshan's admonition to the police force in Yunnan province. | China | http://trove.nla.gov.au/newspaper/page/24095235 | 24095235 | |
| 31156 | 31156 | 1916-04-22 | 3 | c-d | Sun Yatsen's plot and his followers. | China | http://trove.nla.gov.au/newspaper/page/24095235 | 24095235 | |
| 31157 | 31157 | 1916-04-22 | 3 | d | Yunnan, Guizhou and Guangxi provinces declare independence and they are to set up republic government. | China | http://trove.nla.gov.au/newspaper/page/24095235 | 24095235 | |
| 31158 | 31158 | 1916-04-22 | 3 | d-e | Reform in China/ Zhejiang province declares independence. Truce between the South and the North. British diplomats on the chaos in China. Chen Qimei returns to Shanghai. War breaks out in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24095235 | 24095235 | |
| 31159 | 31159 | 1916-04-22 | 3 | e-f | News on the World War I (Eighty merchant ships sink. German people are saving for the War. Negotiation between America and Germany. The war between Russia and Turkey. And other reports.) | Other... | http://trove.nla.gov.au/newspaper/page/24095235 | 24095235 | |
| 31160 | 31160 | 1916-04-22 | 6 | a-b | Miscellaneous report from China. | China | http://trove.nla.gov.au/newspaper/page/24095240 | 24095240 | |
| 31161 | 31161 | 1916-04-22 | 6 | b | China and Japan negotiate over their dispute for the mining near Benxi, Fengtian province. | China | http://trove.nla.gov.au/newspaper/page/24095240 | 24095240 | |
| 31162 | 31162 | 1916-04-22 | 6 | c | Poems by Huang Yu'ang and Zhou Yufan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095240 | 24095240 | |
| 31163 | 31163 | 1916-04-22 | 7 | a-b | Australia news/ A Chinese garden in Sydney is burglarised and the case. A Chinese man who married a Western girl is sentenced and his life in the Sydney prison. A white woman is arrested in New South Wales for wearing military uniform. About 20 woman workers in Melbourne are poisoned by fish and chips. Gold production in New South Wales and the statistics. | Australia | http://trove.nla.gov.au/newspaper/page/24095239 | 24095239 | |
| 31164 | 31164 | 1916-04-22 | b-c | American government dispatches troops to suppress rebellions in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24095233 | 24095233 | ||
| 31165 | 31165 | 1916-04-22 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095239 | 24095239 | |
| 31166 | 31166 | 1916-04-22 | 7 | d | Advertisement for Wing On Insurance Company. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095239 | 24095239 | |
| 31167 | 31167 | 1916-04-22 | 8 | a-b | Beijing news/ Saving the Nation Army (hu guo jun) are on the way to Guangxi. Government troops are defeated in southern Sichuan province. Feng Yuxiang stays in Nanjing. Financial situation in Hunan province. Chongqing declares independence. Long Jiguang and his troops are in Yunnan. | China | http://trove.nla.gov.au/newspaper/page/24095242 | 24095242 | |
| 31168 | 31168 | 1916-04-22 | 8 | b-c | Guangdong news/ Long Jiguang and his troops in Guangzhou. Spy sentenced in Guangzhou. Revolutionaries in Qingyuan county and their plot. Bandits in Qingyuan county. Post offices in Yunnan and Guizhou province are not looking after parcels properly. | China | http://trove.nla.gov.au/newspaper/page/24095242 | 24095242 |
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]);