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 |
---|---|---|---|---|---|---|---|---|---|
8267 | 8267 | 1901-07-31 | 2 | c | Amount of China's compensation to each country, Russia, Germany, France, Britain, America, Japan, Italy, Austria, the Netherlands, Spain and others. | China | http://trove.nla.gov.au/newspaper/page/24100126 | 24100126 | |
8268 | 8268 | 1901-07-31 | 2 | c | Guangdong is going to collect property tax in order to increase its revenue. | China | http://trove.nla.gov.au/newspaper/page/24100126 | 24100126 | |
8269 | 8269 | 1901-07-31 | 2 | c | Yuan Shikai in Shandong encouraged donations in order to pay indemnity. | China | http://trove.nla.gov.au/newspaper/page/24100126 | 24100126 | |
8270 | 8270 | 1901-07-31 | 2 | c | Fire of Wuying Palace in the Beijing court. | China | http://trove.nla.gov.au/newspaper/page/24100126 | 24100126 | |
8290 | 8290 | 1901-07-31 | 3 | c | Reply from the steamship company in regards to discount tickets provided to old and poor Chinese for their returning home. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100125 | 24100125 | |
8291 | 8291 | 1901-07-31 | 3 | c | A Shanghai newspaper says efforts should be made to restore the Emperor in power. | China | http://trove.nla.gov.au/newspaper/page/24100125 | 24100125 | |
8292 | 8292 | 1901-07-31 | 3 | c | A notice from The Tung Wah News for writing letter to the editor. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100125 | 24100125 | |
8293 | 8293 | 1901-07-31 | 3 | c | A meeting of the Sydney Chinese Empire Reform Association. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100125 | 24100125 |
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]);