This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
16773 | 16773 | 1907-01-19 | 2 | b-c | Correspondence from America. An essay written by Huang Zancheng and Fang Muxu, two members of the Chinese Empire Reform Association in New Orleans, comments on the rejuvenation of the Chinese navy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801199 | 26801199 | |
16784 | 16784 | 1907-01-19 | 3 | b-c | Another Russian military general is assassinated. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801198 | 26801198 | |
16797 | 16797 | 1907-01-19 | 6 | b-c | Special report. Third and final part of the introduction written by Kang Youwei on the importance of industrial enterprise. Draft regulations for the Chinese Empire Reform Association. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801203 | 26801203 |
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]);