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 |
---|---|---|---|---|---|---|---|---|---|
21203 | 21203 | 1909-06-26 | 2 | c | Tung Wah Column. China to redeem some territories and the cost. Foreign loans and railway construction in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802230 | 26802230 | |
21204 | 21204 | 1909-06-26 | 2 | c | Prince Regent is determined to relax the control on political party organisations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802230 | 26802230 | |
21205 | 21205 | 1909-06-26 | 2 | c | Germans are determined to stay in Shandong forever. | Britain | http://trove.nla.gov.au/newspaper/page/26802230 | 26802230 | |
21206 | 21206 | 1909-06-26 | 2 | c | Fund raising for the rebuilding of Chinese navy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802230 | 26802230 | |
21223 | 21223 | 1909-06-26 | 6 | c | Donations to the building of university in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/26802234 | 26802234 | |
21224 | 21224 | 1909-06-26 | 6 | c | British geographer comments on China and its Great Wall on his return. | Britain | http://trove.nla.gov.au/newspaper/page/26802234 | 26802234 | |
21225 | 21225 | 1909-06-26 | 6 | c | Chinese ministry of communications sets up a big steamship company. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802234 | 26802234 | |
21234 | 21234 | 1909-06-26 | 7 | c | Beijing news. Prince regent distrusts Zhang Zhidong. Zhang Zhidong in the imperial court, his attitude towards foreign negotiation and others. China sends another student supervisor to Europe. Security in the Summer Palace. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802233 | 26802233 | |
21235 | 21235 | 1909-06-26 | 7 | c | Donations to the Lin Yik Tong. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802233 | 26802233 | |
21239 | 21239 | 1909-06-26 | 8 | c | British writer on Macao (territory, household, city wall), part II. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802236 | 26802236 |
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]);