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 |
|---|---|---|---|---|---|---|---|---|---|
| 9630 | 9630 | 1902-01-22 | 2 | a | Imperial edicts on October 28. | China | http://trove.nla.gov.au/newspaper/page/24100307 | 24100307 | |
| 9633 | 9633 | 1902-01-22 | 2 | c | Power struggles in China's cabinet. | China | http://trove.nla.gov.au/newspaper/page/24100307 | 24100307 | |
| 9636 | 9636 | 1902-01-22 | 2 | d | Russia has controlled telecommunications in Manchuria. No secret codes are allowed to be transmitted. | China | http://trove.nla.gov.au/newspaper/page/24100307 | 24100307 | |
| 9637 | 9637 | 1902-01-22 | 2 | d | Administration in Shandong province has been disabled following Yuan Shikai's appointment to the governorship of Zhili province. | China | http://trove.nla.gov.au/newspaper/page/24100307 | 24100307 | |
| 9638 | 9638 | 1902-01-22 | 2 | d | Magistrate Liang Dingfen, of Wuchang, Hubei province, changes etiquette in meeting with subordinates. | China | http://trove.nla.gov.au/newspaper/page/24100307 | 24100307 | |
| 9641 | 9641 | 1902-01-22 | 2 | d | New policies in Fujian province are being implemented slowly. | China | http://trove.nla.gov.au/newspaper/page/24100307 | 24100307 | |
| 9642 | 9642 | 1902-01-22 | 2 | d | An public society has been established in Fuzhou, Fujian province, for discussion of political and public affairs. | China | http://trove.nla.gov.au/newspaper/page/24100307 | 24100307 | |
| 9643 | 9643 | 1902-01-22 | 2 | d-e | Report on a big fire in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24100307 | 24100307 | |
| 9652 | 9652 | 1902-01-22 | 3 | a | A magistrate in Jiangsu province refused to read mail. | China | http://trove.nla.gov.au/newspaper/page/24100306 | 24100306 | |
| 9653 | 9653 | 1902-01-22 | 3 | a-b | Selected antithetical couplets written by Liang Dingfen, new magistrate of Wuchang, Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24100306 | 24100306 | |
| 9655 | 9655 | 1902-01-22 | 3 | b | Market prices in Gaoyao county, Guangdong, are increasing due to poor weather. | China | http://trove.nla.gov.au/newspaper/page/24100306 | 24100306 | |
| 9661 | 9661 | 1902-01-22 | 3 | d | Report on the last words of Tan Sitong. | China | http://trove.nla.gov.au/newspaper/page/24100306 | 24100306 | |
| 9662 | 9662 | 1902-01-22 | 3 | d | Execution of Fu Cixiang and other reformers means the end of republic in China. | China | http://trove.nla.gov.au/newspaper/page/24100306 | 24100306 |
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]);