This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
20670 | 20670 | 1909-02-20 | 2 | c-d | Beijing news/ The last days of Emperor Guangxu and Empress Dowager. Jiang Chunlin in Beijing. Security arrangement in the court. Board of Revenue tries to reform tax system. Reform of postal service. Preparation to redeem the Beijing-Hankou railway. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802084 | 26802084 | |
20673 | 20673 | 1909-02-20 | 3 | c-d | Guangdong news/ China has the capability to manufacture warships. Another commercial town under construction in Xiangshan county. A meeting of self-government association. Process of railway construction in Guangdong. A welcome ceremony for American missionary in Guangzhou. Liang Zhendong seeks to resign. New calendar for the new reign. British authority in Singapore detains two Chinese criminal suspects. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802083 | 26802083 |
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]);