This data as json, CSV (advanced)
Suggested facets: page, column, date (date)
Link | rowid | date | page | column | title | description ▼ | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30140 | 30140 | 1915-06-05 | 7 | c | German airships come close to London and British Navy Ministry forbids to report any details. | Britain | http://trove.nla.gov.au/newspaper/page/24094868 | 24094868 | |
41582 | 41582 | 1924-05-17 | 7 | b | A 87 year-old bridegroom and his 80 year-old bride in London. | Britain | http://trove.nla.gov.au/newspaper/page/24100724 | 24100724 | |
48303 | 48303 | 1929-07-20 | 8 | c | A Belgian diamond businessman is robbed in London. | Britain | http://trove.nla.gov.au/newspaper/page/24099294 | 24099294 | |
43182 | 43182 | 1925-05-16 | 5 | b-c | A British actor dies in Madrid, Spain, and leaves a lot inheritance. | Britain | http://trove.nla.gov.au/newspaper/page/24101135 | 24101135 | |
42377 | 42377 | 1924-11-29 | 7 | a | A British army commander is murdered in Egypt and the negotiations after that. | Britain | http://trove.nla.gov.au/newspaper/page/24100950 | 24100950 | |
30061 | 30061 | 1915-05-15 | 7 | b | A British business ship was sunken by German submarine, resulting huge casualties. | Britain | http://trove.nla.gov.au/newspaper/page/24094844 | 24094844 | |
27799 | 27799 | 1913-08-30 | 3 | b | A British company is under investigation for purchase of stolen goods. | Britain | http://trove.nla.gov.au/newspaper/page/24092800 | 24092800 | |
10661 | 10661 | 1902-05-21 | 2 | f | A British company purchased shares of a Chinese company. | Britain | http://trove.nla.gov.au/newspaper/page/24100432 | 24100432 | |
28392 | 28392 | 1914-01-10 | 3 | c | A British company to set up a soap factory in Shanghai. | Britain | http://trove.nla.gov.au/newspaper/page/24092952 | 24092952 | |
23380 | 23380 | 1910-08-27 | 3 | c | A British cruiser gets stranded in the south of Korea. | Britain | http://trove.nla.gov.au/newspaper/page/26802745 | 26802745 | |
24733 | 24733 | 1911-07-22 | 3 | b | A general appointed consul-general to Egypt | A British general is appointed consul-general to Egypt. | Britain | http://trove.nla.gov.au/newspaper/page/24091850 | 24091850 |
21977 | 21977 | 1909-11-13 | 8 | c | A British general on the weakness of China and the reason. | Britain | http://trove.nla.gov.au/newspaper/page/26802398 | 26802398 | |
8877 | 8877 | 1901-10-19 | 3 | c | A British gunboat, carrying a large quantity of ammunitions, on the way to Guangdong, China. | Britain | http://trove.nla.gov.au/newspaper/page/24100200 | 24100200 | |
24708 | 24708 | 1911-07-15 | 3 | b | Value of Chinese chinas | A British intends to sell about 500 chinas he collected. | Britain | http://trove.nla.gov.au/newspaper/page/24091842 | 24091842 |
19483 | 19483 | 1908-06-13 | 3 | c | A British man is appointed advisor to Chinese government. | Britain | http://trove.nla.gov.au/newspaper/page/26801766 | 26801766 | |
28964 | 28964 | 1914-06-20 | 3 | c | A British man is punished for living upon his wife. | Britain | http://trove.nla.gov.au/newspaper/page/24093147 | 24093147 | |
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 | |
53087 | 53087 | 1933-07-15 | 6 | d | A British missionary on the Manchurian issues. | Britain | http://trove.nla.gov.au/newspaper/page/24091298 | 24091298 | |
4587 | 4587 | 1900-02-17 | 2 | f | A British newspaper comments on the efforts of Western countries to carve up China. | Britain | http://trove.nla.gov.au/newspaper/page/24102701 | 24102701 | |
5652 | 5652 | 1900-07-11 | 2 | e | A British newspaper reports that the Emperor was poisoned. | Britain | http://trove.nla.gov.au/newspaper/page/24102870 | 24102870 | |
5509 | 5509 | 1900-06-20 | 2 | d | A British newspaper says China should move its capital to Nanjing. | Britain | http://trove.nla.gov.au/newspaper/page/24102846 | 24102846 | |
5167 | 5167 | 1900-05-09 | 2 | b-c | A British newspaper says Singapore is the second China. | Britain | http://trove.nla.gov.au/newspaper/page/24102796 | 24102796 | |
23612 | 23612 | 1910-10-08 | 3 | c | A British opinion on the naval building in China. | Britain | http://trove.nla.gov.au/newspaper/page/26802793 | 26802793 | |
19518 | 19518 | 1908-06-20 | 3 | b | A British passenger liner sinks on the way from Hong Kong to Guangzhou and more than 80 Chinese passengers disappear. | Britain | http://trove.nla.gov.au/newspaper/page/26801775 | 26801775 | |
29891 | 29891 | 1915-04-10 | 3 | b | A British priest says that British troops suffer a big loss. | Britain | http://trove.nla.gov.au/newspaper/page/24094800 | 24094800 | |
7147 | 7147 | 1901-02-27 | 3 | b | A British scientist has new theory about the earth. | Britain | http://trove.nla.gov.au/newspaper/page/24099957 | 24099957 | |
12274 | 12274 | 1903-09-26 | 3 | c | A British scientist talks the power of the Sun. | Britain | http://trove.nla.gov.au/newspaper/page/26800296 | 26800296 | |
29784 | 29784 | 1915-03-20 | 3 | c | A British ship carrying volunteers sunk in west British sea resulting in many death. | Britain | http://trove.nla.gov.au/newspaper/page/24094776 | 24094776 | |
43226 | 43226 | 1925-05-23 | 5 | b | A British ship sinks near London after collision with a Swedish cargo ship. | Britain | http://trove.nla.gov.au/newspaper/page/24101143 | 24101143 | |
36736 | 36736 | 1921-03-19 | 3 | c | A British ship sinks opposite to Shantou and 800 Chinese are drowned. | Britain | http://trove.nla.gov.au/newspaper/page/24093476 | 24093476 | |
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 | |
30390 | 30390 | 1915-08-21 | 7 | b | A British submarine sank a Turkish warship. | Britain | http://trove.nla.gov.au/newspaper/page/24094958 | 24094958 | |
21367 | 21367 | 1909-07-24 | 3 | c | A British submarine sinks in the Atlantic. | Britain | http://trove.nla.gov.au/newspaper/page/26802261 | 26802261 | |
30664 | 30664 | 1915-11-06 | 3 | c | A British transport ship is sunk by a torpedo and a British submarine sank a Turkish transport ship. | Britain | http://trove.nla.gov.au/newspaper/page/24095042 | 24095042 | |
30700 | 30700 | 1915-11-13 | 3 | d | A British transporting ship is sunken by an enemy submarine, resulting in many casualties. | Britain | http://trove.nla.gov.au/newspaper/page/24095050 | 24095050 | |
30665 | 30665 | 1915-11-06 | 3 | c | A British warship is stranded due to bad weather in east Scotland. | Britain | http://trove.nla.gov.au/newspaper/page/24095042 | 24095042 | |
29576 | 29576 | 1915-01-16 | 3 | c | A British warship is sunk by an enemy submarine in British Gulf. | Britain | http://trove.nla.gov.au/newspaper/page/24094687 | 24094687 | |
30385 | 30385 | 1915-08-21 | 3 | d | A British warship is sunken by a Sea-bomb and another is sunken by an enemy submarine, both resulting in huge casualties. | Britain | http://trove.nla.gov.au/newspaper/page/24094954 | 24094954 | |
30914 | 30914 | 1916-01-22 | 3 | b | A British warship is sunken by a sea-bomb without personnel loss. | Britain | http://trove.nla.gov.au/newspaper/page/24095117 | 24095117 | |
43511 | 43511 | 1925-07-18 | 7 | c | A British warship leaves Malta for China. | Britain | http://trove.nla.gov.au/newspaper/page/24101211 | 24101211 | |
30677 | 30677 | 1915-11-06 | 7 | b | A British warship sank due to crash with other warship, resulting in many casualties. | Britain | http://trove.nla.gov.au/newspaper/page/24095046 | 24095046 | |
11934 | 11934 | 1903-06-06 | 3 | c | A British woman has slept for 20 years in Paris. | Britain | http://trove.nla.gov.au/newspaper/page/26800235 | 26800235 | |
28752 | 28752 | 1914-04-25 | 3 | b | A British woman swallows gold she stole while in the court. | Britain | http://trove.nla.gov.au/newspaper/page/24093085 | 24093085 | |
21561 | 21561 | 1909-08-28 | 3 | c | A British writers advocates cooperation among Western powers. | Britain | http://trove.nla.gov.au/newspaper/page/26802303 | 26802303 | |
40175 | 40175 | 1923-07-28 | 7 | c | A Briton is kidnapped in Yunnan province, China. | Britain | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 | |
11477 | 11477 | 1903-02-07 | 3 | b | A Briton was sentenced for providing information to South African troops during the war. | Britain | http://trove.nla.gov.au/newspaper/page/26800164 | 26800164 | |
29764 | 29764 | 1915-03-13 | 7 | c | A Chinese business ship is driven by a German submarine but succeeds in escaping. | Britain | http://trove.nla.gov.au/newspaper/page/24094772 | 24094772 | |
12917 | 12917 | 1904-03-19 | Suppl't | b | A Chinese general in Jilin province has committed suicide for failing to protect local residents. | Britain | http://trove.nla.gov.au/newspaper/page/26800396 | 26800396 | |
24700 | 24700 | 1911-07-15 | 3 | a | Crime of multi-wives | A Chinese is convicted of having several wives. | Britain | http://trove.nla.gov.au/newspaper/page/24091842 | 24091842 |
55978 | 55978 | 1936-04-18 | 8 | d | A Chinese woman in Singapore gives birth to a son at the age of 105. | Britain | http://trove.nla.gov.au/newspaper/page/24096822 | 24096822 | |
28696 | 28696 | 1914-04-11 | 3 | c | A Duke in Britain donates to preservation of the Waterloo battlefield and building of a museum. | Britain | http://trove.nla.gov.au/newspaper/page/24093069 | 24093069 | |
42802 | 42802 | 1925-03-07 | 3 | e | A French military plane crashes. | Britain | http://trove.nla.gov.au/newspaper/page/24101053 | 24101053 | |
31022 | 31022 | 1916-03-11 | 3 | c | A French personnel transporting warship sank in Mediterranean Sea, resulting in many casualties. | Britain | http://trove.nla.gov.au/newspaper/page/24095186 | 24095186 | |
44458 | 44458 | 1926-02-27 | 5 | a | A French ship is hijacked on its way from Guangzhou to Hong Kong. | Britain | http://trove.nla.gov.au/newspaper/page/24101471 | 24101471 | |
13928 | 13928 | 1904-10-15 | Suppl't | c | A German businessman in London was sentenced for rape. | Britain | http://trove.nla.gov.au/newspaper/page/26800546 | 26800546 | |
11754 | 11754 | 1903-04-18 | 3 | b | A German businessman sold weapons to China. | Britain | http://trove.nla.gov.au/newspaper/page/26800206 | 26800206 | |
38887 | 38887 | 1922-06-17 | 3 | e | A German cargo ship is on the way to Australia. | Britain | http://trove.nla.gov.au/newspaper/page/24094009 | 24094009 | |
45061 | 45061 | 1926-08-14 | 7 | b | A German man is arrested in Fuzhou, of Fujian province, and the investigation. | Britain | http://trove.nla.gov.au/newspaper/page/24101667 | 24101667 | |
30389 | 30389 | 1915-08-21 | 7 | b | A German military business ship in North Sea sank a British warship and then sank itself when other British warhships coming. | Britain | http://trove.nla.gov.au/newspaper/page/24094958 | 24094958 | |
12203 | 12203 | 1903-09-05 | 3 | b | A German missionary was injured in Guangdong. Residents in Shandong province stole telephone line owned by German troops. | Britain | http://trove.nla.gov.au/newspaper/page/26800284 | 26800284 | |
23478 | 23478 | 1910-09-17 | 3 | b | A German spy is arrested by British authority in Portsmouth. | Britain | http://trove.nla.gov.au/newspaper/page/26802769 | 26802769 | |
25455 | 25455 | 1911-12-23 | 3 | a | German spies on British military | A German spy is found to spy on British military. | Britain | http://trove.nla.gov.au/newspaper/page/24092042 | 24092042 |
30663 | 30663 | 1915-11-06 | 3 | c | A German submarine sank an Italian steamboat without earlier notice. | Britain | http://trove.nla.gov.au/newspaper/page/24095042 | 24095042 | |
43925 | 43925 | 1925-10-03 | 5 | b | A German union selects their representatives to visit Soviet Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24101299 | 24101299 | |
30645 | 30645 | 1915-10-30 | 7 | b | A German warship in Mediterranean Sea is sunken by a British submarine. | Britain | http://trove.nla.gov.au/newspaper/page/24095038 | 24095038 | |
21628 | 21628 | 1909-09-11 | 6 | b | A Japanese business delegation to visit America. | Britain | http://trove.nla.gov.au/newspaper/page/26802324 | 26802324 | |
23610 | 23610 | 1910-10-08 | 3 | c | A Japanese railway expert is seeking support in Paris for a railway project from Fengtian (Shenyang) to Korea, which will connect Asia and Europe. | Britain | http://trove.nla.gov.au/newspaper/page/26802793 | 26802793 | |
23375 | 23375 | 1910-08-27 | 3 | b | A Japanese shipyard is building two gunboats for Chinese navy. | Britain | http://trove.nla.gov.au/newspaper/page/26802745 | 26802745 | |
17807 | 17807 | 1907-07-20 | 3 | c | A Japanese spy is captured in California, the United States, and a further report. | Britain | http://trove.nla.gov.au/newspaper/page/26801403 | 26801403 | |
30886 | 30886 | 1916-01-15 | 3 | d | A Japanese transport ship and a British transport ship are sunken by submarines, resulting in many casualties. | Britain | http://trove.nla.gov.au/newspaper/page/24095109 | 24095109 | |
14484 | 14484 | 1905-05-20 | Suppl't | a-b | A Korean official hanged himself in London for his conquered nation. | Britain | http://trove.nla.gov.au/newspaper/page/26800697 | 26800697 | |
43305 | 43305 | 1925-06-06 | 5 | c | A London hospital purchase radio for the entertainment of their patients and donations from royal family. | Britain | http://trove.nla.gov.au/newspaper/page/24101159 | 24101159 | |
40830 | 40830 | 1923-12-22 | 6 | b-c | A London magazine assesses China's credit. | Britain | http://trove.nla.gov.au/newspaper/page/24094660 | 24094660 | |
12295 | 12295 | 1903-10-03 | 3 | b | A London newspaper claims that Russia has already taken Manchuria. | Britain | http://trove.nla.gov.au/newspaper/page/26800300 | 26800300 | |
5698 | 5698 | 1900-07-18 | 2 | e | A London newspaper comments on relations between Britain and France. | Britain | http://trove.nla.gov.au/newspaper/page/24102878 | 24102878 | |
41724 | 41724 | 1924-06-21 | 6 | a-b | A London newspaper criticise Sun Yatsen and his government in Guangzhou. | Britain | http://trove.nla.gov.au/newspaper/page/24100765 | 24100765 | |
6439 | 6439 | 1900-11-17 | 2 | a-b | A London newspaper publishes an article on China affairs. | Britain | http://trove.nla.gov.au/newspaper/page/24103017 | 24103017 | |
40250 | 40250 | 1923-08-18 | 2 | e-f | A London newspaper suggests that international cooperation would be necessary in order to put down chaos in China by force. | Britain | http://trove.nla.gov.au/newspaper/page/24094512 | 24094512 | |
14085 | 14085 | 1904-12-17 | Suppl't | b | A London newspaper, Standard, reports and comments on racial problem in Australia. | Britain | http://trove.nla.gov.au/newspaper/page/26800591 | 26800591 | |
39730 | 39730 | 1923-04-14 | 3 | f | A London theatre is closed due to smallpox infection. | Britain | http://trove.nla.gov.au/newspaper/page/24094367 | 24094367 | |
54047 | 54047 | 1934-04-07 | 6 | c | A New Zealander is detained by Japanese in Tokyo. | Britain | http://trove.nla.gov.au/newspaper/page/24095968 | 24095968 | |
44741 | 44741 | 1926-05-15 | 7 | d | A Norwegian explorer on the way to the North Pole. | Britain | http://trove.nla.gov.au/newspaper/page/24101561 | 24101561 | |
42846 | 42846 | 1925-03-14 | 3 | f | A Russian farmer organises secret society. | Britain | http://trove.nla.gov.au/newspaper/page/24101061 | 24101061 | |
30697 | 30697 | 1915-11-13 | 3 | c | A Russian general is sentenced to prison for his fleeing after failure in a battle. | Britain | http://trove.nla.gov.au/newspaper/page/24095050 | 24095050 | |
13054 | 13054 | 1904-04-16 | 3 | b | A Russian gunboat sank after being hit. | Britain | http://trove.nla.gov.au/newspaper/page/26800414 | 26800414 | |
13386 | 13386 | 1904-06-18 | Suppl't | c | A Russian official has been arrested for embezzlement. | Britain | http://trove.nla.gov.au/newspaper/page/26800461 | 26800461 | |
9017 | 9017 | 1901-11-06 | 2 | f | A Scottish woman demands more compensation for defamation. | Britain | http://trove.nla.gov.au/newspaper/page/24100221 | 24100221 | |
14861 | 14861 | 1905-10-07 | 3 | b | A Sino-Austria bank is being prepared with headquarter in Vienna and branches throughout China. | Britain | http://trove.nla.gov.au/newspaper/page/26800792 | 26800792 | |
50264 | 50264 | 1931-05-02 | 8 | b | A Spanish warship defects under the instigation of communists. | Britain | http://trove.nla.gov.au/newspaper/page/24090371 | 24090371 | |
30721 | 30721 | 1915-11-20 | 3 | c | A Weapon Manufacturing Plant in America caught a fire, resulting in huge loss. | Britain | http://trove.nla.gov.au/newspaper/page/24095058 | 24095058 | |
9269 | 9269 | 1901-12-07 | 2 | f | A bank employee in London was arrested for embezzlement. | Britain | http://trove.nla.gov.au/newspaper/page/24100257 | 24100257 | |
4678 | 4678 | 1900-03-03 | 3 | a | A bank in London makes huge profits. | Britain | http://trove.nla.gov.au/newspaper/page/24102717 | 24102717 | |
5537 | 5537 | 1900-06-20 | 2 | d | A banker in London was detained for embezzlement. | Britain | http://trove.nla.gov.au/newspaper/page/24102846 | 24102846 | |
25678 | 25678 | 1912-02-03 | 3 | b | West African tribe head | A barbarian tribe chief in Angle was killed by a Bulgarian. | Britain | http://trove.nla.gov.au/newspaper/page/24092090 | 24092090 |
31021 | 31021 | 1916-03-11 | 3 | c | A big British business ship is sunken by an underwater mine in British sea, resulting in many casualties. | Britain | http://trove.nla.gov.au/newspaper/page/24095186 | 24095186 | |
24702 | 24702 | 1911-07-15 | 3 | a | Earthquake in central Asia | A big earthquake happened in central Asia. | Britain | http://trove.nla.gov.au/newspaper/page/24091842 | 24091842 |
22981 | 22981 | 1910-06-18 | 3 | c | A big fire in St Louis, America. | Britain | http://trove.nla.gov.au/newspaper/page/26802665 | 26802665 | |
18066 | 18066 | 1907-09-07 | 3 | c | A big fire in Tokyo. | Britain | http://trove.nla.gov.au/newspaper/page/26801459 | 26801459 | |
22164 | 22164 | 1909-12-25 | 3 | c | A big fire in Valdivia, Chile. | Britain | http://trove.nla.gov.au/newspaper/page/26802439 | 26802439 | |
32926 | 32926 | 1918-02-09 | 2 | a-c | A big gathering in London welcomes China's entry into the World War I. | Britain | http://trove.nla.gov.au/newspaper/page/24097171 | 24097171 |
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]);