This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26207 | 26207 | 1912-06-01 | 3 | a | Mexican riots | The revolutionary troops and government troops are fighting bitterly and the revolutionary troops suffered a huge loss. | Other... | http://trove.nla.gov.au/newspaper/page/24092255 | 24092255 |
26208 | 26208 | 1912-06-01 | 3 | a | Italy-Turkey war | Italian troops occupied almost all Turkish islands and Turkish troops retreated inland, | Russia | http://trove.nla.gov.au/newspaper/page/24092255 | 24092255 |
26209 | 26209 | 1912-06-01 | 3 | a | Hong Kong plague | Too many people fled to Hong Kong from Guangdong, led to a widespread plague there. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24092255 | 24092255 |
26210 | 26210 | 1912-06-01 | 3 | a | Australian envoy visits Germany | An Australian envoy visited Germany, promoting Australian trade with Germany. | Britain | http://trove.nla.gov.au/newspaper/page/24092255 | 24092255 |
26211 | 26211 | 1912-06-01 | 3 | a | Earthquake in Japan | A huge earthquake occurred in northwest Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24092255 | 24092255 |
26212 | 26212 | 1912-06-01 | 3 | a-b | Mexico riots affect Germans | Four German people were killed in Mexico riots and German government demands compensation from Mexican government. | Other... | http://trove.nla.gov.au/newspaper/page/24092255 | 24092255 |
26213 | 26213 | 1912-06-01 | 3 | b | Chinese government officials and Premier Tang | Chinese state government officials oppose the dismissal plan for reducing expenses. Premier Tang is to resign for criticism for his abuse of foreign loans and shortage of government funding. | China | http://trove.nla.gov.au/newspaper/page/24092255 | 24092255 |
26214 | 26214 | 1912-06-01 | 3 | b | Black people's activity in Cuba | Black people bought a lot of weapons and American government sent troops to stop them. | Other... | http://trove.nla.gov.au/newspaper/page/24092255 | 24092255 |
26215 | 26215 | 1912-06-01 | 3 | b | Earthquake in Spain | A volcano in Spanish sea caused an earthquake in Spain. | Other... | http://trove.nla.gov.au/newspaper/page/24092255 | 24092255 |
26216 | 26216 | 1912-06-01 | 3 | b | Russia and France are to mediate between Italy and Turkey | Russia and France are to mediate between Italy and Turkey, Britain may join them too. | France | http://trove.nla.gov.au/newspaper/page/24092255 | 24092255 |
26217 | 26217 | 1912-06-01 | 3 | b | Japanese is to expand fishery in Mexico | Japanese is to set up a fishery company in Mexico. | Canada | http://trove.nla.gov.au/newspaper/page/24092255 | 24092255 |
26218 | 26218 | 1912-06-01 | 3 | b | American president election | American president candidates are competing for the position by exposing privacy of each other. | America | http://trove.nla.gov.au/newspaper/page/24092255 | 24092255 |
26219 | 26219 | 1912-06-01 | 3 | b | Russian students' suicide | Russian students' suicide is common at present. | Russia | http://trove.nla.gov.au/newspaper/page/24092255 | 24092255 |
26220 | 26220 | 1912-06-01 | 3 | b | Funeral of Denmark emperor | A huge funeral is held for the emperor in Denmark. | Other... | http://trove.nla.gov.au/newspaper/page/24092255 | 24092255 |
26221 | 26221 | 1912-06-01 | 3 | b-c | Beijing news | Wu Tingfang was elected as president of China's Constitutional Party. Provinces and governors are to be kept for stability's sake. New currency has been designed. Some riot parties are buying weapons in order to assassinate president and other state officials. Mongolia demands Beijing government to elect their own governor. Two brothers in Hubei killed their uncle who brought them up and villagers decided to bury the younger brother lively. A squire in Hubei was charged as he forced villagers to donate for his own benefits. A burglar pretending to be a military commander was sentenced to death in Wuhan. Beijing decides that governors of different provinces are to be from their provinces. Man students graduated from an institute by changing their family names. | China | http://trove.nla.gov.au/newspaper/page/24092255 | 24092255 |
26222 | 26222 | 1912-06-01 | 3 | c-d | Guangdong news | Over 3,000 people attend Guangdong Industrial Corporation ceremony. Troops are ordered to stay outside of Guangzhou city. Guangdong governor orders to investigate soldiers' robberies. A commander of revolutionary troop in Guangdong robbed many properties and kidnapped over 100 women for sale. Many officials in Guangdong resigned resulting from pay cut. A village in Gaoming County, Guangdong, was robbed and burned by bandits. A businessman named Ye Yangzhen applied for exploring Dongsa Island , which was approved. Gaoyao and Dongwan, Guangdong, are to make straw-hats to replace the imported ones. Gaoming County in Guangdong is occupied by Shanghe Party and Guangdong government is likely to send troops to restore social order there. Some Huo county's businessmen in Hong Kong wrote to Guangdong governor, requiring to punish Li Dun who slandered county governor. Some Shanghe bandit party members were arrested in Xingan county, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24092255 | 24092255 |
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]);