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 |
|---|---|---|---|---|---|---|---|---|---|
| 29157 | 29157 | 1914-08-15 | 2 | a-b | Editorial on the war in Europe and the possible influence upon the world trade. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093212 | 24093212 | |
| 29158 | 29158 | 1914-08-15 | 2 | b-c | Chinese President Yuan Shikai and Premier Xu Shichang talk on the politics. | China | http://trove.nla.gov.au/newspaper/page/24093212 | 24093212 | |
| 29159 | 29159 | 1914-08-15 | 2 | b-c | Chinese Ministry of Internal Affairs on the haircut. | China | http://trove.nla.gov.au/newspaper/page/24093212 | 24093212 | |
| 29160 | 29160 | 1914-08-15 | 2 | d | Japanese visitor to China comments on Yuan Shikai, Chinese politics and the trade with Japan on his return. | Japan | http://trove.nla.gov.au/newspaper/page/24093212 | 24093212 | |
| 29161 | 29161 | 1914-08-15 | 3 | a | Orders issued by Chinese President Yuan Shikai to remove Wang Zhixin for corruption. | China | http://trove.nla.gov.au/newspaper/page/24093211 | 24093211 | |
| 29162 | 29162 | 1914-08-15 | 3 | a | Tibetan representatives put forward their requests in the negotiation with Chen Yifan, representative of the Chinese government. | China | http://trove.nla.gov.au/newspaper/page/24093211 | 24093211 | |
| 29163 | 29163 | 1914-08-15 | 3 | a-b | Government authority suppress revolutionary rebellions in Hunan and Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24093211 | 24093211 | |
| 29164 | 29164 | 1914-08-15 | 3 | b | The war in Europe (Austria declares war to Germany, Italy remains neutral, Holland declares war to Germany, Russia in the fighting, comparison of troops and navy of belligerent countries, warships of the two belligerent groups, German and Russian navies fight in the Chinese water territory, foreign warships and their moves in China, and other news on the World War One). | Other... | http://trove.nla.gov.au/newspaper/page/24093211 | 24093211 | |
| 29165 | 29165 | 1914-08-15 | 6 | a | A notice issued by the Chinese Chamber of Commerce on the award of Patriotic Medals to the Chinese citizens in Australia for their contribution towards the Citizenship Levy (guo min juan). Names of all medalists throughout Australia are listed (societies and individuals). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093216 | 24093216 | |
| 29166 | 29166 | 1914-08-15 | 7 | a | Australia news/ Fewer merchant ships are arriving in Australia due to the war in Europe. Many young Australians are recruited. Australian federal government commandeer ships in Sydney. Passenger liner St Albans of Gibbs Bright & Co, is stuck in Townsville, Queensland, on its way from Sydney to Hong Kong. German warships in Samoa island. | Australia | http://trove.nla.gov.au/newspaper/page/24093215 | 24093215 | |
| 29167 | 29167 | 1914-08-15 | 7 | a-c | Miscellaneous report on the World War One in Europe. | Other... | http://trove.nla.gov.au/newspaper/page/24093215 | 24093215 | |
| 29168 | 29168 | 1914-08-15 | 7 | c | Chinese communities in Australia donate to the flood victims in Guangdong. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093215 | 24093215 | |
| 29169 | 29169 | 1914-08-15 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093215 | 24093215 | |
| 29170 | 29170 | 1914-08-15 | 8 | a-b | Criticism on Sun Yatsen's correspondence with Japanese politician, selected from newspapers in China. | China | http://trove.nla.gov.au/newspaper/page/24093218 | 24093218 | |
| 29171 | 29171 | 1914-08-15 | 8 | b-c | Beijing news/ President Yuan Shikai cares about overseas Chinese. New plan to retrieve paper bank notes. Judicial law to be revised and the key points. Budget for the central government has been finalised. China to compensate foreign countries fro their loss during the 1911 Revolution. Plague of bandits and locusts in Xiangyang, of Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24093218 | 24093218 | |
| 29172 | 29172 | 1914-08-15 | 8 | c | Guangdong news/ The Disaster Relief Committee in Guangzhou calls for donations and more funds for the flooding areas. Miscellaneous report on the fundraising activities in Guangzhou and involvement of government officials such as Long Jiguang and the new General Inspector. | China | http://trove.nla.gov.au/newspaper/page/24093218 | 24093218 |
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]);