This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
19725 | 19725 | 1908-07-25 | 3 | a-b | Guangdong news/ Ministry of communications appoints Liang Yonghu to reconnoitre for the building of railway from Guangzhou to Kowloon. Investigation under way on the import of foreign medicine. Guangdong authority promotes local products. Industrial investment to be encouraged. China to build warships itself. Rebuilding of Humen fortifications in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801817 | 26801817 | |
19726 | 19726 | 1908-07-25 | 3 | b | All members of a secret society in Poland are arrested by Russian authority for attempting to assassinating the Tsar. | Britain | http://trove.nla.gov.au/newspaper/page/26801817 | 26801817 | |
19727 | 19727 | 1908-07-25 | 3 | b | Presidential election in America. | Australia | http://trove.nla.gov.au/newspaper/page/26801817 | 26801817 | |
19728 | 19728 | 1908-07-25 | 3 | b | Japanese Cabinet resigns and Duke Katsura Taro becomes prime minister once again. | Japan | http://trove.nla.gov.au/newspaper/page/26801817 | 26801817 | |
19729 | 19729 | 1908-07-25 | 3 | b | Royal navy of Britain has exercise. | Britain | http://trove.nla.gov.au/newspaper/page/26801817 | 26801817 | |
19730 | 19730 | 1908-07-25 | 3 | b | Japanese in Korea. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801817 | 26801817 | |
19731 | 19731 | 1908-07-25 | 3 | b | French president visits Russia, Sweden and Denmark. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801817 | 26801817 | |
19732 | 19732 | 1908-07-25 | 3 | b-c | A survey on opium consumption and number of addicts in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801817 | 26801817 | |
19733 | 19733 | 1908-07-25 | 3 | c-d | French governor in Vietnam issues new regulations on Asian migrants. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801817 | 26801817 | |
19734 | 19734 | 1908-07-25 | 3 | d | Miscellaneous notes. Britain in shortage of army officers. The new king of Portugal falls in love with maidservant. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801817 | 26801817 |
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]);