This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25057 | 25057 | 1911-09-30 | 3 | a | Disaster from riots against foreign loans | There are disasters from riots against borrowing foreign loans for railways in Sichuan. | China | http://trove.nla.gov.au/newspaper/page/24091937 | 24091937 |
25058 | 25058 | 1911-09-30 | 3 | a | Herd (nnn) dies | Former Chinese taxation chief Herd (nnn) died. | Britain | http://trove.nla.gov.au/newspaper/page/24091937 | 24091937 |
25059 | 25059 | 1911-09-30 | 3 | a | Japanese spy | A Japanese diplomat might be a spy. | America | http://trove.nla.gov.au/newspaper/page/24091937 | 24091937 |
25060 | 25060 | 1911-09-30 | 3 | a-b | Russian president dies | Russian president died of shooting by a jewdish several weeks ago. | Russia | http://trove.nla.gov.au/newspaper/page/24091937 | 24091937 |
25061 | 25061 | 1911-09-30 | 3 | b | British King is to visit India | British King is to visit India at the end of the year. | Britain | http://trove.nla.gov.au/newspaper/page/24091937 | 24091937 |
25062 | 25062 | 1911-09-30 | 3 | b | Canadian conservative party wins | The Canadian conservative party wins the election. | Canada | http://trove.nla.gov.au/newspaper/page/24091937 | 24091937 |
25063 | 25063 | 1911-09-30 | 3 | b | Thousands of Indians die of epidemic | Thousands of Indians died of epidemic. | Other... | http://trove.nla.gov.au/newspaper/page/24091937 | 24091937 |
25064 | 25064 | 1911-09-30 | 3 | b | German debt | German debt has increased. | Other... | http://trove.nla.gov.au/newspaper/page/24091937 | 24091937 |
25065 | 25065 | 1911-09-30 | 3 | b | World drug smoking ban conference | The world drug smoking ban conference is to be held in Haigue this year. | Britain | http://trove.nla.gov.au/newspaper/page/24091937 | 24091937 |
25066 | 25066 | 1911-09-30 | 3 | b | China's foreign loans | It is sad to learn that China has been borrowing a large amount of foreign loans. | Other... | http://trove.nla.gov.au/newspaper/page/24091937 | 24091937 |
25067 | 25067 | 1911-09-30 | 3 | c | Beijing news | The Regent is to chair a cabinet meeting. The issue of salary for cabinet members. Prince Zhen proposes pigtails cutting and change of Chinese traditional uniform. Navy budget. Prince Zhen might be promoted. An American adviser in the Department of Transport. Corrupted inspector to Sichuan and Guangdong railways. Foreign troops in Beijing and Tianjin. | Other... | http://trove.nla.gov.au/newspaper/page/24091937 | 24091937 |
25068 | 25068 | 1911-09-30 | 3 | c-d | Guangdong news | A good army general in Guangdong. Governor entertains airboat maker Feng Ru. Several graduates from American universities return to China. Funds for floods in Sanshui county, Guangdong. The organisation of the assassin party. Shunde, Guangdong becomes a base of thieves. An immoral woman poisoned her husband. | Other... | http://trove.nla.gov.au/newspaper/page/24091937 | 24091937 |
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]);