This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24791 | 24791 | 1911-08-05 | 3 | a | Morocco riots | Morocco Riots affect the relations among Britain, France and Gernany. | Britain | http://trove.nla.gov.au/newspaper/page/24091866 | 24091866 |
24792 | 24792 | 1911-08-05 | 3 | a | Turkey fire | Fire in Turkey destroyed thousands of houses and other properties. | Other... | http://trove.nla.gov.au/newspaper/page/24091866 | 24091866 |
24793 | 24793 | 1911-08-05 | 3 | a | Hurricane in Japan | About 100 people are killed in hurricane close to Japanese sea. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091866 | 24091866 |
24794 | 24794 | 1911-08-05 | 3 | a | Flooding in China | Flooding in Yangtze River area and the casualties. | China | http://trove.nla.gov.au/newspaper/page/24091866 | 24091866 |
24795 | 24795 | 1911-08-05 | 3 | a-b | International Race Conference | International Race Conference in London advocates equity and anti-discrimination among different races and nationalities. | Britain | http://trove.nla.gov.au/newspaper/page/24091866 | 24091866 |
24796 | 24796 | 1911-08-05 | 3 | b | Aviation world | French pilot won the first price in the plane flying competition. | Britain | http://trove.nla.gov.au/newspaper/page/24091866 | 24091866 |
24797 | 24797 | 1911-08-05 | 3 | b | Friendship between Britain and Japan | British government holds honorary ceremony to see Japanese ambassador off. | Britain | http://trove.nla.gov.au/newspaper/page/24091866 | 24091866 |
24798 | 24798 | 1911-08-05 | 3 | b | Plague in Singapore | Forty people died of plague in Singapore. | Other... | http://trove.nla.gov.au/newspaper/page/24091866 | 24091866 |
24799 | 24799 | 1911-08-05 | 3 | b | Britain makes new warships | Britain plans to build 12 more new warships. | Britain | http://trove.nla.gov.au/newspaper/page/24091866 | 24091866 |
24800 | 24800 | 1911-08-05 | 3 | b | World of overseas Chinese students | Mei Yueyun graduated in American university. | America | http://trove.nla.gov.au/newspaper/page/24091866 | 24091866 |
24801 | 24801 | 1911-08-05 | 3 | b | Japan welcomes Chinese industrial delegation | Japan plans to spend 100,000 yen to entertain Chinese industrial delegation in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24091866 | 24091866 |
24802 | 24802 | 1911-08-05 | 3 | c | Beijing news | Yuan Shikai is to take office of Zi Zhen Yuan. Imperial meeting to deal with opposition to imperial cabinet. Foreign Affairs Ministry gives away a rich mine to the Japanese. No results got from Pian Ma negotiation. Duan Fang has a different view to removed officials. | China | http://trove.nla.gov.au/newspaper/page/24091866 | 24091866 |
24803 | 24803 | 1911-08-05 | 3 | c-d | Guangdong news | Police department in Guangdong bans the People Newspaper. New government building is to be constructed. Opposition to Portugal's conspiracy to invade Chinese sea right. Two imperial ministers investigate Guangzhou riots. Feng Ru is testing his plane. Fu Shang in Guangdong is flooding. Soldiers of Qing imperial army raped a woman in village. New chief takes office of National (Da Qing) Bank in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24091866 | 24091866 |
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]);