This data as json, CSV (advanced)
Suggested facets: source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 20672 | 20672 | 1909-02-20 | 3 | a-c | China news/ Preparation for constitutional reform. Security arrangements in the court to be checked. Discussion to bridge the gap between Manchurian and Han people. Qiu Jin's grave on the side of West Lake in Hangzhou has been removed. Salary increased for government officials. Couplet to Yuan Shikai on his birthday from overseas Chinese. Zhejiang and Fujian province will not send representative to the international opium conference. Empress comments on a speech by Prince Regent. Ministry of Communications prepares for future development plan. Japanese in Fengtian occupy imperial garden. Navigation in Songhuajiang River. Prince Regent punishes eunuchs. | China | http://trove.nla.gov.au/newspaper/page/26802083 | 26802083 | |
| 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 | |
| 20674 | 20674 | 1909-02-20 | 3 | d | Feud and fighting between two clans, Huang and Hu, on the border of Shunde and Xinhui counties. | 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]);