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 |
|---|---|---|---|---|---|---|---|---|---|
| 29208 | 29208 | 1914-09-05 | 2 | a-b | Editorial on the difference between the centralisation of state authority and autocratic monarchy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093236 | 24093236 | |
| 29209 | 29209 | 1914-09-05 | 2 | b-c | Orders issued by Chinese President Yuan Shikai on July 17 on the bandits in Henan province. | China | http://trove.nla.gov.au/newspaper/page/24093236 | 24093236 | |
| 29210 | 29210 | 1914-09-05 | 2 | c-d | First part of the new civil service system in China. | China | http://trove.nla.gov.au/newspaper/page/24093236 | 24093236 | |
| 29211 | 29211 | 1914-09-05 | 2 | d | Chinese President Yuan Shikai on the etiquette and his birthday celebration. | China | http://trove.nla.gov.au/newspaper/page/24093236 | 24093236 | |
| 29212 | 29212 | 1914-09-05 | 2 | d | A New York newspaper on Sun Yatsen and China. | America | http://trove.nla.gov.au/newspaper/page/24093236 | 24093236 | |
| 29213 | 29213 | 1914-09-05 | 3 | a | A noble man in Hubei province Sun Wu and money. | China | http://trove.nla.gov.au/newspaper/page/24093235 | 24093235 | |
| 29214 | 29214 | 1914-09-05 | 3 | b | Banditry in Yunnan province and the social chaos. | China | http://trove.nla.gov.au/newspaper/page/24093235 | 24093235 | |
| 29215 | 29215 | 1914-09-05 | 3 | b | Miscellaneous report on the World War I (battle between German and French troops, British navy in the North Sea, Germany confiscates Japan's money deposit, Prince of Britain is sick, Austrian warship is sunk, Paris prepares for the war, Jiaozhou Peninsula and the World War I, Turkey prepares for the war, another revolutionary rebellion in the Yangtze River area of China, German troops and their fighting with Allies, Norwegian commanders surrenders, French cabinet is disbanded). | Other... | http://trove.nla.gov.au/newspaper/page/24093235 | 24093235 | |
| 29216 | 29216 | 1914-09-05 | 6 | a-b | Miscellaneous report on the Chinese politics and officialdom. | China | http://trove.nla.gov.au/newspaper/page/24093240 | 24093240 | |
| 29217 | 29217 | 1914-09-05 | 6 | b-c | Chinese communities in Australia and New Zealand donate to the flooding area in Guangdong. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093240 | 24093240 | |
| 29218 | 29218 | 1914-09-05 | 7 | a | Chinese Chamber of Commerce in Sydney acknowledges receipt of donations to the flooding area in Guangdong and their report on the donations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093239 | 24093239 | |
| 29219 | 29219 | 1914-09-05 | 7 | a-b | Australia news/ Chinese communities in Cairns, Queensland, and New Zealand donate to the flood victims in Guangdong. Australian and New Zealand naval fleets join together and their whereabouts. New Zealand troops occupy Samoa island. More Chinese are returning from Noumea, of New Caledonia. Business remains normal in the Sydney banks. Insurance charges increase due to the war. Natives of Songlong town, Gaoyao county, in Sydney actively donate to the flood victims in their hometown. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093239 | 24093239 | |
| 29220 | 29220 | 1914-09-05 | 7 | b-c | News about the World War I (German warship sinks in heavy fog, Russian troops approach German border, battle between Austrian and Russian armies). | Other... | http://trove.nla.gov.au/newspaper/page/24093239 | 24093239 | |
| 29221 | 29221 | 1914-09-05 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093239 | 24093239 | |
| 29222 | 29222 | 1914-09-05 | 8 | a | American immigration authority maltreats Chinese delegation who are on their way to the Panama Exhibition, and the report. | America | http://trove.nla.gov.au/newspaper/page/24093242 | 24093242 | |
| 29223 | 29223 | 1914-09-05 | 8 | a-b | Beijing news/ Chinese government in Beijing to build headquarters of supreme commander. Wu Tingfang to be the foreign minister. Scholar comments on the provisional constitution. China and Britain to revise their opium trade treaty. Plan for repayment of the indemnity to foreign countries in 1915. Russia to annex Mongolia. Chinese government is considering to appoint honorary consul among overseas Chinese communities. | China | http://trove.nla.gov.au/newspaper/page/24093242 | 24093242 | |
| 29224 | 29224 | 1914-09-05 | 8 | b-c | Guangdong news/ General Inspector Li Guojun replies to the central government in Beijing on the water conservancy projects. Flood and tragedy in Songlong and Huilongbao town, of Gaoyao county. Official correspondence on the water conservancy projects in Guangdong. Li Guojun to start investigation in Guangdong on the recruitment of Chinese labourers for foreign companies. A man in Panyu county is bleeding mysteriously. Mermaid found in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24093242 | 24093242 |
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]);