This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30400 | 30400 | 1915-08-28 | 3 | a | Details of Ha Ke Tu (ppp) Treaty between Russia and China. | China | http://trove.nla.gov.au/newspaper/page/24094962 | 24094962 | |
30401 | 30401 | 1915-08-28 | 3 | a-b | Overseas Chinese, especially those in Southeast Asia are competing to deposit money for China's rescuing funds. | China | http://trove.nla.gov.au/newspaper/page/24094962 | 24094962 | |
30402 | 30402 | 1915-08-28 | 3 | b | China and Japan sign a treaty on Qingdao custom in Shandong. | Japan | http://trove.nla.gov.au/newspaper/page/24094962 | 24094962 | |
30403 | 30403 | 1915-08-28 | 3 | b | A Chinese navy commander Zhen escaped a bomb assassination in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24094962 | 24094962 | |
30404 | 30404 | 1915-08-28 | 3 | b | A British military personnel transporting ship is sunken by a German submarine, resulting in huge casualties. | Britain | http://trove.nla.gov.au/newspaper/page/24094962 | 24094962 | |
30405 | 30405 | 1915-08-28 | 3 | b | German airships attack British cities, leading to many casualties. | Britain | http://trove.nla.gov.au/newspaper/page/24094962 | 24094962 | |
30406 | 30406 | 1915-08-28 | 3 | b | A British submarine is stranded on a Denmark island. | Britain | http://trove.nla.gov.au/newspaper/page/24094962 | 24094962 | |
30407 | 30407 | 1915-08-28 | 3 | b-c | Russian and German navies are fighting in Palladia Sea, and Russian fleets retreat to their sea ports. | Russia | http://trove.nla.gov.au/newspaper/page/24094962 | 24094962 | |
30408 | 30408 | 1915-08-28 | 3 | c | Battle situation in east Europe between Russian, German and Austrian troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094962 | 24094962 | |
30409 | 30409 | 1915-08-28 | 3 | c | German troops defeated Russian troops in La Niao Zhuo Zi Ji(ppp) fort, capturing 20,000 Russian soldiers. | Britain | http://trove.nla.gov.au/newspaper/page/24094962 | 24094962 | |
30410 | 30410 | 1915-08-28 | 3 | c-d | Italy declares war against Turkey and German people are worrying about situation in Turkish strait. | Britain | http://trove.nla.gov.au/newspaper/page/24094962 | 24094962 | |
30411 | 30411 | 1915-08-28 | 3 | d | Beijing news/China is to make its constitution, and Lin Changming, Liang Qicao and some others are selected for writing the draft. Central government is to restore the congress in order to pacify people's anger on Sino-Japan negotiation. Provincial senates are to be restored too for regulating activities of provincial governors in China. Rumours are heard that Yuan Shikai is to award titles of nobilities to Li Yuanhong, Feng Guozhang, Xu Shichang and Shi Ji (to be continued). | China | http://trove.nla.gov.au/newspaper/page/24094962 | 24094962 |
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]);