This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
20109 | 20109 | 1908-10-17 | 2 | b-c | First 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/26801915 | 26801915 | |
20123 | 20123 | 1908-10-17 | 6 | b-c | More Russian people are moving to live in Siberia. | Russia | http://trove.nla.gov.au/newspaper/page/26801919 | 26801919 | |
20141 | 20141 | 1908-10-17 | 8 | b-c | New regulation issued by Guangdong authority to ban opium throughout the province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801921 | 26801921 |
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]);