This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18796 | 18796 | 1908-01-18 | 6 | a-b | First part of travel notes to Britain, written by Kang Youwei. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801616 | 26801616 | |
18797 | 18797 | 1908-01-18 | 6 | b | China borrows loans from British and German sources in order to build the railway from Tianjin to Zhenjiang. | Britain | http://trove.nla.gov.au/newspaper/page/26801616 | 26801616 | |
18798 | 18798 | 1908-01-18 | 6 | b | Ownership of railway. A large gathering in Zhejiang province protests against foreign involvement in railway projects. | China | http://trove.nla.gov.au/newspaper/page/26801616 | 26801616 | |
18799 | 18799 | 1908-01-18 | 6 | b-c | Miscellaneous notes/ The biggest painting in the world. The deepest lake. The longest plant. The longest letter of love. The oldest love letter. The oldest money. The longest tunnel. The biggest school. The oldest code. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801616 | 26801616 | |
18800 | 18800 | 1908-01-18 | 6 | c | Miscellaneous news/ Jiangsu and Zhejiang officials in Beijing discuss purchasing shares in the railway in their home province. Chinese communities in the Philippines and Vietnam welcome visit of Chinese warship Hairong and Haiqi. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801616 | 26801616 |
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]);