This data as json, CSV (advanced)
Suggested facets: date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 26927 | 26927 | 1913-01-31 | 1-34 | a-d | Special edition for celebrating Chinese New Year. Features include Confucianism (photo of Confucius), First president and vice president of Republic China (their biographies and photos), Justice Minister Liang Qichao (his photo), Premier and Financial Minister Xiong Xilin (his photo), other government officials and governors (photos) of Republic China, the Summer Palace, Kang Youwei (photo), Hangzhou West Lake, Tianjin Park, Yue Fei tomb, Britain-Japan secret alliance, Hong Kong University students' photo, Guangdong history, Panama Canal, and Guanyin Mountain in Guangdong. | Other... |
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]);