This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25675 | 25675 | 1912-02-03 | 2 | c-d | World of overseas Chinese students | American Columbia University provided free tuition fees for some Chinese students. Cheng Huacan, Chen Jiangshi, Jiang Fuzhen, and Cheng Kangen received degrees in California university. Chen Chongyuan is returning China after having received PhD in America. | Other... | http://trove.nla.gov.au/newspaper/page/24092091 | 24092091 |
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]);