This data as json, CSV (advanced)
Suggested facets: source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 22154 | 22154 | 1909-12-25 | 2 | a-b | Editorial on the protest from Western countries against the Manchurian agreement signed by Japan and China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802440 | 26802440 | |
| 22162 | 22162 | 1909-12-25 | 3 | a-b | Guangdong news/ Yuan Shuxun orders business investigation in port cities. Election of the Guangzhou-Hankou railway company has failed and the reason. Yuan Shuxun reports to Beijing the solution to the Dongsha island dispute. Railway project between Guangdong and Guangxi. The Guangzhou-Kowloon railway construction will be completed in 1911. Station of the Guangdong armies. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802439 | 26802439 | |
| 22172 | 22172 | 1909-12-25 | 6 | a-b | Opening ceremony of the Zhenhua industrial company (Jun Wah Sut Yip Co. Ltd) in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/26802444 | 26802444 | |
| 22186 | 22186 | 1909-12-25 | 8 | a-b | Zhang Binglin lists crimes committed by revolutionary rebel Sun Yatsen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802446 | 26802446 |
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]);