This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22226 | 22226 | 1910-01-08 | 2 | c | Flood victims in north Jiangsu province urgently need help for the winter. | Hong Kong | http://trove.nla.gov.au/newspaper/page/26802456 | 26802456 | |
22227 | 22227 | 1910-01-08 | 2 | c | News in brief/ Local residents near Yalu River are forced to change their Chinese names under new Japanese rule. Russians join the loan competition with other foreign countries for the railway project in Hunan and Hubei. Zhang Renjun reports Chinese business in Nanyang. Zai Ze and Na Tong comment on the proposed appointment of foreign financial advisor. Imperial commissioner of Guangxi reports that French troops from Vietnam are approaching the border. Tang Shaoyi is out of favour for his collaboration with Yuan Shikai. German to build an astronomical observatory in Jiaozhou, Shandong province. Lu Zhengxiang stays in Hague as representative of Chinese government. | China | http://trove.nla.gov.au/newspaper/page/26802456 | 26802456 | |
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 | |
22243 | 22243 | 1910-01-08 | 6 | c | A letter from Chinese consulate in New Zealand says they have no shares of the Chinese Bazaar, although they support the business initiative. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802460 | 26802460 | |
22244 | 22244 | 1910-01-08 | 6 | c | Six men in American compete with each other not to sleep. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802460 | 26802460 | |
22253 | 22253 | 1910-01-08 | 8 | c | A movie of 10 million dollars. Legacy of 2 million dollars. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802462 | 26802462 |
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]);