This data as json, CSV (advanced)
Suggested facets: date, column, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 12918 | 12918 | 1904-03-19 | Suppl't | b | Japanese troops save Russian soldiers from a sinking torpedo. | Australia | http://trove.nla.gov.au/newspaper/page/26800396 | 26800396 | |
| 12958 | 12958 | 1904-03-26 | Suppl't | b | Russian general reports on their battle with Japanese. | Australia | http://trove.nla.gov.au/newspaper/page/26800401 | 26800401 | |
| 12959 | 12959 | 1904-03-26 | Suppl't | b | Japanese troops and their fortifications in Korea | Australia | http://trove.nla.gov.au/newspaper/page/26800401 | 26800401 | |
| 13024 | 13024 | 1904-04-09 | Suppl't | b | A policeman became food for a crocodile near Perth in Western Australia. | Australia | http://trove.nla.gov.au/newspaper/page/26800411 | 26800411 | |
| 13132 | 13132 | 1904-04-30 | Suppl't | b | A robbery in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/26800426 | 26800426 | |
| 13133 | 13133 | 1904-04-30 | Suppl't | b | A Chinese warship sank near Dalian. | Australia | http://trove.nla.gov.au/newspaper/page/26800426 | 26800426 | |
| 13176 | 13176 | 1904-05-07 | Suppl't | b | Russian troops give up Dalian. | Australia | http://trove.nla.gov.au/newspaper/page/26800431 | 26800431 | |
| 13177 | 13177 | 1904-05-07 | Suppl't | b | Japanese troops have taken over Niuzhuang. | Australia | http://trove.nla.gov.au/newspaper/page/26800431 | 26800431 | |
| 13384 | 13384 | 1904-06-18 | Suppl't | c | A Chinese in Sydney fled hospital due to his craving for opium. | Australia | http://trove.nla.gov.au/newspaper/page/26800461 | 26800461 | |
| 13388 | 13388 | 1904-06-18 | Suppl't | c | Finland wants to shake off dictatorship from Russia. | Australia | http://trove.nla.gov.au/newspaper/page/26800461 | 26800461 | |
| 13422 | 13422 | 1904-06-25 | Suppl't | b | Statistics of casualty of the Russian army in Manchuria. | Australia | http://trove.nla.gov.au/newspaper/page/26800466 | 26800466 | |
| 13423 | 13423 | 1904-06-25 | Suppl't | b | Japanese cargo ship was attacked and sank. | Australia | http://trove.nla.gov.au/newspaper/page/26800466 | 26800466 | |
| 13456 | 13456 | 1904-07-02 | Suppl't | a | An article, published in Sydney's Sunday Times, says Chinese businesses in Sydney are now in crisis as many Chinese businessmen are leaving. The article is written after interviewing with Chen Xia and Sun Junchen, two Chinese businessmen in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/26800471 | 26800471 | |
| 13565 | 13565 | 1904-07-23 | Suppl't | c | Russian gunboats in the Red Sea and response of Germany, Singapore, and others. | Australia | http://trove.nla.gov.au/newspaper/page/26800486 | 26800486 | |
| 13566 | 13566 | 1904-07-23 | Suppl't | c | Russian commander in Manchuria at a loss what to do. | Australia | http://trove.nla.gov.au/newspaper/page/26800486 | 26800486 | |
| 13789 | 13789 | 1904-09-10 | Suppl't | b | France demands China provide compensation over the missionary case in Lichuan county, Hubei province. | Australia | http://trove.nla.gov.au/newspaper/page/26800521 | 26800521 | |
| 13790 | 13790 | 1904-09-10 | Suppl't | b | The Treasurer and Tax Commissioner in Queensland quarrel over the employment of Chinese labourers. | Australia | http://trove.nla.gov.au/newspaper/page/26800521 | 26800521 | |
| 13823 | 13823 | 1904-09-17 | Suppl't | c | Report from Africa on current affairs, Chinese labourers in the area, and other issues. | Australia | http://trove.nla.gov.au/newspaper/page/26800526 | 26800526 | |
| 13854 | 13854 | 1904-09-24 | Suppl't | c | A Russian gunboat arrives in San Francisco. Japanese administration in Manchuria. Japanese army win more battles. | Australia | http://trove.nla.gov.au/newspaper/page/26800531 | 26800531 | |
| 13855 | 13855 | 1904-09-24 | Suppl't | c | Manslaughter of a Jewish family in Poland. | Australia | http://trove.nla.gov.au/newspaper/page/26800531 | 26800531 | |
| 13856 | 13856 | 1904-09-24 | Suppl't | c | Furniture unions in Sydney and Melbourne are being organised to boycott Chinese carpenters. | Australia | http://trove.nla.gov.au/newspaper/page/26800531 | 26800531 | |
| 13875 | 13875 | 1904-10-01 | Suppl't | b | A drunk man in Broken Hill, New South Wales, smashed a local hotel. | Australia | http://trove.nla.gov.au/newspaper/page/26800536 | 26800536 | |
| 13876 | 13876 | 1904-10-01 | Suppl't | c | Bandits and robbery in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/26800536 | 26800536 | |
| 13897 | 13897 | 1904-10-08 | Suppl't | c | New method has been found in Brisbane to protect and grow bananas. | Australia | http://trove.nla.gov.au/newspaper/page/26800541 | 26800541 | |
| 13922 | 13922 | 1904-10-15 | Suppl't | b | Russian soldiers suffer after being defeated by Japanese in Manchuria. | Australia | http://trove.nla.gov.au/newspaper/page/26800546 | 26800546 | |
| 13925 | 13925 | 1904-10-15 | Suppl't | b | Report on Chinese communities in the Pacific islands. | Australia | http://trove.nla.gov.au/newspaper/page/26800546 | 26800546 | |
| 13987 | 13987 | 1904-11-12 | Suppl't | b | New Zealand parliament advises British authorities in South Africa to not recruit any Chinese labourer for gold mining. | Australia | http://trove.nla.gov.au/newspaper/page/26800566 | 26800566 | |
| 14003 | 14003 | 1904-11-19 | Suppl't | a | Earthquake in Taiwan. | Australia | http://trove.nla.gov.au/newspaper/page/26800571 | 26800571 | |
| 14004 | 14004 | 1904-11-19 | Suppl't | b | Russia's plans for reform. | Australia | http://trove.nla.gov.au/newspaper/page/26800571 | 26800571 | |
| 14062 | 14062 | 1904-12-10 | Suppl't | b | Attempt of Chinese government to increase tariffs has been blocked by foreign governments. | Australia | http://trove.nla.gov.au/newspaper/page/26800586 | 26800586 | |
| 14134 | 14134 | 1904-12-31 | Suppl't | c | Taiwan on alert under Japanese rule. | Australia | http://trove.nla.gov.au/newspaper/page/26800601 | 26800601 | |
| 14202 | 14202 | 1905-01-28 | Suppl't | b | Rebellion within the Winter Palace. | Australia | http://trove.nla.gov.au/newspaper/page/26800621 | 26800621 | |
| 14255 | 14255 | 1905-02-25 | Suppl't | b | Transvaal (South Africa) can not be fully independent. | Australia | http://trove.nla.gov.au/newspaper/page/26800637 | 26800637 | |
| 14421 | 14421 | 1905-04-29 | Suppl't | b | German demands business privileges in the Yangtze River area. | Australia | http://trove.nla.gov.au/newspaper/page/26800682 | 26800682 | |
| 14443 | 14443 | 1905-05-06 | Suppl't | b | France and Germany negotiate further on the Morocco issue. | Australia | http://trove.nla.gov.au/newspaper/page/26800687 | 26800687 | |
| 14444 | 14444 | 1905-05-06 | Suppl't | b | British parliament has approved new policy for Transvaal (South Africa). | Australia | http://trove.nla.gov.au/newspaper/page/26800687 | 26800687 | |
| 14464 | 14464 | 1905-05-13 | Suppl't | b | Japan and France are in negotiation for the Russian fleet near Vietnam. | Australia | http://trove.nla.gov.au/newspaper/page/26800692 | 26800692 | |
| 14608 | 14608 | 1905-07-15 | Suppl't | c | Japan to borrow from Britain, Germany and America to pay for the war in Manchuria and its aftermath, while Russia is looking for domestic sources to borrow from. | Australia | http://trove.nla.gov.au/newspaper/page/26800733 | 26800733 | |
| 14681 | 14681 | 1905-08-05 | Suppl't | c | Britain decides to stay away from the peace talks between Japan and Russia. | Australia | http://trove.nla.gov.au/newspaper/page/26800748 | 26800748 | |
| 14741 | 14741 | 1905-08-26 | Suppl't | b | Russian representative says they need foreign assistance in their negotiation for peace with Japan. | Australia | http://trove.nla.gov.au/newspaper/page/26800763 | 26800763 | |
| 14794 | 14794 | 1905-09-16 | Suppl't | a | Thousands of Russian troops on the move to suppress rebellion in the Black Sea region. | Australia | http://trove.nla.gov.au/newspaper/page/26800778 | 26800778 | |
| 14795 | 14795 | 1905-09-16 | Suppl't | a | Russian newspaper comments on the Anglo-Japanese Alliance. | Australia | http://trove.nla.gov.au/newspaper/page/26800778 | 26800778 | |
| 14820 | 14820 | 1905-09-23 | Suppl't | a | Chinese government seeks compensation from Japan and Russia for property damages during the Russo-Japanese War. | Australia | http://trove.nla.gov.au/newspaper/page/26800784 | 26800784 | |
| 14822 | 14822 | 1905-09-23 | Suppl't | b | Russia is building more warships. | Australia | http://trove.nla.gov.au/newspaper/page/26800784 | 26800784 | |
| 14825 | 14825 | 1905-09-23 | Suppl't | b | United States of America is building more warships. | Australia | http://trove.nla.gov.au/newspaper/page/26800784 | 26800784 |
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]);