This data as json, CSV (advanced)
Suggested facets: source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 23705 | 23705 | 1910-10-29 | 2 | a-b | Editorial on diplomatic opportunities for China, selected from Eastern Times (Shanghai shi bao) in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/26802818 | 26802818 | |
| 23711 | 23711 | 1910-10-29 | 3 | a-b | Guangdong news/ Road project from Xiangzhou to Qianshan started. Shareholders of the Guangzhou-Hankou railway company agree to Zhan Tianyou's condition. Huang Zanting might be appointed to assist Zhan Tianyou. Tang Shaoyi is on the way to Beijing. Yuan Shuxun orders secret investigation on revolutionaries. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802817 | 26802817 | |
| 23721 | 23721 | 1910-10-29 | 6 | a-b | Third part of business report by Chinese consulate in New Zealand on commercial opportunities for Chinese business. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802822 | 26802822 | |
| 23738 | 23738 | 1910-10-29 | 8 | a-b | A speech at the celebration of the birthday of Confucius, by Ting Xian. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802824 | 26802824 |
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]);