This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21807 | 21807 | 1909-10-16 | 3 | a-b | Guangdong news/ Guangdong pays its shares for naval rebuilding. A temple is closed in Xinning county for the railway project. Li Jiaju seeks to resign from the legislature assembly. New governor Yuan Shuxun and his office hour. Staff of the office of the new governor general Yuan Shuxun. Yuan Shuxun to ban gambling. New budget for local self-government office. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802359 | 26802359 | |
21808 | 21808 | 1909-10-16 | 3 | b | Japanese Prime Minister on financial issues faced by Japan. | Britain | http://trove.nla.gov.au/newspaper/page/26802359 | 26802359 | |
21809 | 21809 | 1909-10-16 | 3 | b | A coal mine in Canada is on fire, claiming 14 lives. | Britain | http://trove.nla.gov.au/newspaper/page/26802359 | 26802359 | |
21810 | 21810 | 1909-10-16 | 3 | b | American Secretary of State blocks the appointment of new ambassador to China. | Britain | http://trove.nla.gov.au/newspaper/page/26802359 | 26802359 | |
21811 | 21811 | 1909-10-16 | 3 | b | Archeologist finds in south France human bones of 20,000 years ago. | Britain | http://trove.nla.gov.au/newspaper/page/26802359 | 26802359 | |
21813 | 21813 | 1909-10-16 | 3 | b | Canadian parliament approves of naval development plan. | Britain | http://trove.nla.gov.au/newspaper/page/26802359 | 26802359 | |
21814 | 21814 | 1909-10-16 | 3 | b-c | Tsar of Russia visits Italy. | Britain | http://trove.nla.gov.au/newspaper/page/26802359 | 26802359 | |
21815 | 21815 | 1909-10-16 | 3 | c | Number of dockyard and employees in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/26802359 | 26802359 | |
21816 | 21816 | 1909-10-16 | 3 | c | American naval fleet may visit China, Japan and the Philippines. | America | http://trove.nla.gov.au/newspaper/page/26802359 | 26802359 | |
21817 | 21817 | 1909-10-16 | 3 | c | An agricultural fair to be held in Omsk, Russia. | Other... | http://trove.nla.gov.au/newspaper/page/26802359 | 26802359 | |
21818 | 21818 | 1909-10-16 | 3 | c-d | American newspaper publishes an interview with Prince Regent of China. | America | http://trove.nla.gov.au/newspaper/page/26802359 | 26802359 | |
21819 | 21819 | 1909-10-16 | 3 | d | Warning message to Zhili people on Japan's plot, published by a Beijing newspaper. | China | http://trove.nla.gov.au/newspaper/page/26802359 | 26802359 |
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]);