This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32110 | 32110 | 1917-02-24 | 3 | b-c | A plot to overthrow the Chinese cabinet. | China | http://trove.nla.gov.au/newspaper/page/24095608 | 24095608 | |
32115 | 32115 | 1917-02-24 | 6 | b-c | Beijing news/ Speech by the Chinese President Li Yuanhong on the Chinese New Year. Many people support that the Constitution should include provincial system. Liang Qichao on the Chinese cabinet. Framework of the Chinese cabinet is to be drafted. Christians in Beijing and other provinces demand freedom of religious belief. Sun Yatsen explains why he demand financial subsidy from the Chinese national parliament. Foreign minister Wu Tingfang and his policy. | China | http://trove.nla.gov.au/newspaper/page/24095613 | 24095613 | |
32120 | 32120 | 1917-02-24 | 7 | b-c | Miscellaneous report on the Chinese politics. | China | http://trove.nla.gov.au/newspaper/page/24095612 | 24095612 |
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]);