This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
19195 | 19195 | 1908-04-18 | 2 | b | Detailed report on negotiations between China and Japan over the capture of Japanese cargo ship for smuggling. | Other... | http://trove.nla.gov.au/newspaper/page/26801702 | 26801702 | |
19224 | 19224 | 1908-04-18 | 7 | b | Sydney Show is now open. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801705 | 26801705 | |
19225 | 19225 | 1908-04-18 | 7 | b | West's Pictures in Sydney has new pictures about China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801705 | 26801705 | |
19226 | 19226 | 1908-04-18 | 7 | b | Circus in the Palace Theatre. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801705 | 26801705 | |
19227 | 19227 | 1908-04-18 | 7 | b | Flooding in Boston of the United States and Hankou of China. | Britain | http://trove.nla.gov.au/newspaper/page/26801705 | 26801705 | |
19228 | 19228 | 1908-04-18 | 7 | b | Dong Fuxiang dies. Chinese government requests British authority in Singapore to deport Sun Yatsen and reply from British mission in Beijing. A coal mine in Panyu county under French management. British ambassador in Beijing demands compensation from China for negligence of Xiamen dockyard. Japanese ambassador in Beijing protests against Chinese ministry of foreign affairs for Japanese business in Zhejiang province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801705 | 26801705 | |
19233 | 19233 | 1908-04-18 | 7 | b | First part of the loan contract for the Shanghai-Hangzhou-Ningbo railway project and signed between Chinese ministry of foreign affairs and British company. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801705 | 26801705 |
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]);