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 |
|---|---|---|---|---|---|---|---|---|---|
| 23516 | 23516 | 1910-09-24 | 2 | a-b | A report submitted by Wu Tingfang, former Chinese ambassador to America, suggests to cut pigtails but to keep same official uniform. | China | http://trove.nla.gov.au/newspaper/page/26802778 | 26802778 | |
| 23520 | 23520 | 1910-09-24 | 2 | c-d | Beijing news/ Prince Regent on the people's petition for establishment of national parliament. Prince Qing is busy building his palace. Price of the position of provincial imperial commissioner. Provincial authorities are urged to take precaution against revolutionaries. Proposal to reform civil service system in Tibet. Japanese and the railway construction from Andong to Fengtian. American business delegation comes to visit China. Prince Qing on officialdom. | China | http://trove.nla.gov.au/newspaper/page/26802778 | 26802778 | |
| 23536 | 23536 | 1910-09-24 | 6 | a | French business and French missionary work in Yunnan province. | China | http://trove.nla.gov.au/newspaper/page/26802782 | 26802782 | |
| 23537 | 23537 | 1910-09-24 | 6 | a-b | Tens of thousands of people from Hubei province are forced to emigrate to Heilongjiang. | China | http://trove.nla.gov.au/newspaper/page/26802782 | 26802782 |
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]);