This data as json, CSV (advanced)
Suggested facets: page, column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27846 | 27846 | 1913-09-13 | 2 | a-b | Editorial advises Chinese people should retain the system of republic. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092817 | 24092817 | |
27847 | 27847 | 1913-09-13 | 2 | b-c | Orders issued by interim president Yuan Shikai on July 26 and 27 on national renovation and appointment of officials in Anhui province. | China | http://trove.nla.gov.au/newspaper/page/24092817 | 24092817 | |
27848 | 27848 | 1913-09-13 | 2 | c | Outline of the constitution drafted by the Beijing government. | China | http://trove.nla.gov.au/newspaper/page/24092817 | 24092817 | |
27849 | 27849 | 1913-09-13 | 2 | c | Telegram from Cai Yuanpei, Wang Zhaoming and Tang Shaoyi in Shanghai to Yuan Shikai in Beijing. And the reply from Yuan Shikai. | China | http://trove.nla.gov.au/newspaper/page/24092817 | 24092817 | |
27850 | 27850 | 1913-09-13 | 2 | d | Vice President Li Yuanhong talks to journalist on current situations. | China | http://trove.nla.gov.au/newspaper/page/24092817 | 24092817 | |
27851 | 27851 | 1913-09-13 | 2-3 | d-a | The end of Chen Jiongming, Qin Chunxuan and Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24092817 | 24092817 |
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]);