This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22293 | 22293 | 1910-01-22 | 3 | a-b | Guangdong news/ Yuan Shuxun selects five members of the legislative assembly. Budget shares for the training of New Army. Progress of the railway project from Guangzhou to Kowloon. Guangdong army studies battle cases in the past decades. A telegram from Guangdong newspaper association to Shanghai magistrate for the closure of a newspaper (min yu bao) there. Ministry of foreign affairs inquires about Portuguese occupation of Chinese territory and Gao Er'qian's report on border demarcation. Ministry of communications sends inspectors to Guangdong for investigation of railway company. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802471 | 26802471 | |
22294 | 22294 | 1910-01-22 | 3 | b-c | Imperial palace on fire in St Petersburg, Russia. | Britain | http://trove.nla.gov.au/newspaper/page/26802471 | 26802471 | |
22295 | 22295 | 1910-01-22 | 3 | c | America, Britain and Germany respond to privileges enjoyed by Russia and Japan in Manchuria. | Britain | http://trove.nla.gov.au/newspaper/page/26802471 | 26802471 | |
22296 | 22296 | 1910-01-22 | 3 | c | King of Portugal is seriously injured in an assassination. | Britain | http://trove.nla.gov.au/newspaper/page/26802471 | 26802471 | |
22297 | 22297 | 1910-01-22 | 3 | c | Female workers in New York are on strike for more pay. | Britain | http://trove.nla.gov.au/newspaper/page/26802471 | 26802471 | |
22298 | 22298 | 1910-01-22 | 3 | c | German colony in southwest Africa is rich with diamonds. | Britain | http://trove.nla.gov.au/newspaper/page/26802471 | 26802471 | |
22299 | 22299 | 1910-01-22 | 3 | c | Both German and American governments have found it difficult to renew their trade treaty. | Britain | http://trove.nla.gov.au/newspaper/page/26802471 | 26802471 | |
22300 | 22300 | 1910-01-22 | 3 | c | Competition between German and British naval forces. | Britain | http://trove.nla.gov.au/newspaper/page/26802471 | 26802471 | |
22301 | 22301 | 1910-01-22 | 3 | d | Further report on the removal of Duan Fang. | China | http://trove.nla.gov.au/newspaper/page/26802471 | 26802471 |
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]);