This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
14594 | 14594 | 1905-07-15 | 2 | c | Prince Qing becomes more powerful. Qin Chunxuan recommends talented people. New Russian ambassador arrives Beijing. Chinese police students in Japan. Hunan sends female students to study in Japan. Yunnan sends female students to Japan. Governor Zhou Fu of Jiangsu province leases land to German troops. | China | http://trove.nla.gov.au/newspaper/page/26800732 | 26800732 |
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]);