This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
20182 | 20182 | 1908-10-31 | 3 | a-b | Imperial edict on August 27 rewards Ma Yukun on his death. | China | http://trove.nla.gov.au/newspaper/page/26801931 | 26801931 | |
20186 | 20186 | 1908-10-31 | 6 | a-b | Fourth and final part of the report from the Constitutional Research Institution (xian zheng bian cha guan) on necessary preparation for constitutional reform, establishment of parliament and the draft of new constitution of China. | China | http://trove.nla.gov.au/newspaper/page/26801936 | 26801936 | |
20196 | 20196 | 1908-10-31 | 7 | a-b | Fifth part of the speech by missionary George Heralton on recent development in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801935 | 26801935 |
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]);