This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22230 | 22230 | 1910-01-08 | 3 | a-b | Guangdong news/ Governor Yuan Shuxun on the expenditure of legislative assembly. Businessman Liu Xuexun seeks to undertake salt sales throughout the province. Progress of the Guangzhou-Kowloon railway project. Gao Er'qian brings all documents on his return to Beijing. Provincial authority to clear up and collect public money. Railway proposed from Foshan to Xinhui. A police station in the east of Guangzhou and its staff, responsibility and patrol area. A seafood shop in Guangzhou is on fire. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802455 | 26802455 | |
22231 | 22231 | 1910-01-08 | 3 | b | Paris to borrow money for its infrastructure building. | Britain | http://trove.nla.gov.au/newspaper/page/26802455 | 26802455 | |
22232 | 22232 | 1910-01-08 | 3 | c | Coal miners in South Wales negotiate with their employer on working hours. | Britain | http://trove.nla.gov.au/newspaper/page/26802455 | 26802455 | |
22233 | 22233 | 1910-01-08 | 3 | c | Russian parliament to increase army forces. | Britain | http://trove.nla.gov.au/newspaper/page/26802455 | 26802455 | |
22234 | 22234 | 1910-01-08 | 3 | c | American railway engineer comments on trade between China and America. | Britain | http://trove.nla.gov.au/newspaper/page/26802455 | 26802455 | |
22235 | 22235 | 1910-01-08 | 3 | c | Chinese government sends military officer to learn aircraft technology in Germany. | Britain | http://trove.nla.gov.au/newspaper/page/26802455 | 26802455 | |
22236 | 22236 | 1910-01-08 | 3 | c | Lushun will turn into a free trade port. | Britain | http://trove.nla.gov.au/newspaper/page/26802455 | 26802455 | |
22237 | 22237 | 1910-01-08 | 3 | c | Number of immigrants in Canada and their origin. | Britain | http://trove.nla.gov.au/newspaper/page/26802455 | 26802455 | |
22238 | 22238 | 1910-01-08 | 3 | c-d | Hubei news/ A soldier fights for railway rights. | China | http://trove.nla.gov.au/newspaper/page/26802455 | 26802455 | |
22239 | 22239 | 1910-01-08 | 3 | d | Imperial edict on October 13 on constitutional reform. | China | http://trove.nla.gov.au/newspaper/page/26802455 | 26802455 |
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]);