This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
15192 | 15192 | 1905-12-30 | 2 | b-c | The abolition of imperial examinations and the influence of that change. High-level officials on their overseas tour of investigation. China to have parliament and constitutional monarchy. Military parade of Beiyang army and its significance. Progress of the railway building from Hankou to Guangzhou. Further report on the explosion at the Beijing railway station. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800865 | 26800865 | |
15212 | 15212 | 1905-12-30 | 6 | b-c | Kang Youwei's poems written in the United States. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800869 | 26800869 |
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]);