This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 24758 | 24758 | 1911-07-29 | 3 | a | Corruption in Russia | Corrupted officials have been prosecuted. | Russia | http://trove.nla.gov.au/newspaper/page/24091858 | 24091858 |
| 24759 | 24759 | 1911-07-29 | 3 | a | Riots in Persia | Several riots in Persia. | Other... | http://trove.nla.gov.au/newspaper/page/24091858 | 24091858 |
| 24760 | 24760 | 1911-07-29 | 3 | a | Strikes in Britain | Strikes spread all over Britain and as a result several Chinese laundries were burned down. | Britain | http://trove.nla.gov.au/newspaper/page/24091858 | 24091858 |
| 24761 | 24761 | 1911-07-29 | 3 | a | Japanese King visits China | Japanese King is to visit China. | Other... | http://trove.nla.gov.au/newspaper/page/24091858 | 24091858 |
| 24762 | 24762 | 1911-07-29 | 3 | a | Canada issues entry restrictions on Chinese | Canada issues entry restrictions on Chinese. | Canada | http://trove.nla.gov.au/newspaper/page/24091858 | 24091858 |
| 24763 | 24763 | 1911-07-29 | 3 | a-b | Chinese overseas students | Numbers of overseas students in Japan and America. | Other... | http://trove.nla.gov.au/newspaper/page/24091858 | 24091858 |
| 24764 | 24764 | 1911-07-29 | 3 | b | Survey of railways in Germany | A survey is about railways in Germany. | Other... | http://trove.nla.gov.au/newspaper/page/24091858 | 24091858 |
| 24765 | 24765 | 1911-07-29 | 3 | b | A Chinese businessmen delegation visit Japan | Japan prepares for the visit of a Chinese businessmen delegation. | Other... | http://trove.nla.gov.au/newspaper/page/24091858 | 24091858 |
| 24766 | 24766 | 1911-07-29 | 3 | b | Copper mine in Gansu | A copper mine in Gansu was plundered by a Belgiam. | Other... | http://trove.nla.gov.au/newspaper/page/24091858 | 24091858 |
| 24767 | 24767 | 1911-07-29 | 3 | c | Beijing news | Budget for the new cabinet and the emperor's assistance office. Budget for the autumn military exercise. The emperor intends to extend its garden in Haidian, Beijing. Yuan Sikai and the imperial family. Military railways are to be built. Zegong asks government to handle salt dealings. Lu Zhengxiang is sent to Russia to revise China's treaty with Russia. | Other... | http://trove.nla.gov.au/newspaper/page/24091858 | 24091858 |
| 24768 | 24768 | 1911-07-29 | 3 | c-d | Guangdong news | Governor's office collects opinions about the nationalisation of railways. Governor takes action against drugs. A new plan of districts for Guangdong. Border issue with Macao. Religious fights. Two woman spies' romance. Governor sends someone to Shangdong to learn about new administration there. | Other... | http://trove.nla.gov.au/newspaper/page/24091858 | 24091858 |
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]);