This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18496 | 18496 | 1907-11-23 | 2 | c-d | Chinese community in Sydney sends telegram to Beijing on the birthday of Empress Dowager and requests to start constitutional reform by setting up the parliament. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801548 | 26801548 | |
18505 | 18505 | 1907-11-23 | 3 | c-d | Jiangsu and Zhejiang provinces are applying for loans from British source to build railways in their region, response from central government in Beijing, involvement of Zhang Zhidong, Yuan Shikai and other government officials. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801547 | 26801547 |
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]);