This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 23137 | 23137 | 1910-07-16 | 2 | b | Negotiation between China and Portugal on the demarcation of Macao border. | China | http://trove.nla.gov.au/newspaper/page/26802698 | 26802698 | |
| 23138 | 23138 | 1910-07-16 | 2 | b-c | Beijing news. Salary of local government officials: Manchurian and Han. Four key figures in the Research Institute for Constitutional Reform (xian zheng bian cha guan). Prince Regent is impartial in official appointment. Russian seek to control coal mines in Lubin prefecture of Heilongjiang province. Ministry of foreign affairs is eager to complete the Manchuria negotiation with Japan. | China | http://trove.nla.gov.au/newspaper/page/26802698 | 26802698 | |
| 23140 | 23140 | 1910-07-16 | 3 | a | Opening ceremony of the National Industrial Exposition in Nanjing on April 28. | China | http://trove.nla.gov.au/newspaper/page/26802697 | 26802697 | |
| 23141 | 23141 | 1910-07-16 | 3 | a | News in brief. Sa Yintu from St Petersburg reports on recent relations between Russia and Japan. Imperial scholar criticises the naval office. Prince Regent inquires about Russian troops in Mongolia. Hu Weide is recalled from Japan. Prince Regent on the marriage between Manchurian and Han people. Lu Chuanlin seeks to retire. Duan Fang might be rehabilitated. | China | http://trove.nla.gov.au/newspaper/page/26802697 | 26802697 | |
| 23156 | 23156 | 1910-07-16 | 3 | d | Russia, Japan and the future of the Korean peninsula. | China | http://trove.nla.gov.au/newspaper/page/26802697 | 26802697 | |
| 23160 | 23160 | 1910-07-16 | 6 | b | Prince Regent considers pardoning reformers of the 1898 Reform Movement. | China | http://trove.nla.gov.au/newspaper/page/26802702 | 26802702 | |
| 23161 | 23161 | 1910-07-16 | 6 | b | Revolutionary posters in Beijing and their plan to rebellion in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/26802702 | 26802702 | |
| 23162 | 23162 | 1910-07-16 | 6 | b | Chinese businessman from Nanyang, Liang Bingnong, purchases the first entry ticket of the National Industrial Exposition in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/26802702 | 26802702 | |
| 23163 | 23163 | 1910-07-16 | 6 | b | Prince Su urges to set up national parliament. | China | http://trove.nla.gov.au/newspaper/page/26802702 | 26802702 | |
| 23179 | 23179 | 1910-07-16 | 8 | a-b | Correspondence from Beijing/ Why Liang Dunyan seeks to resign. Xu Shichang in the ministry of communications. Grand scholar to be selected. | China | http://trove.nla.gov.au/newspaper/page/26802704 | 26802704 |
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]);