This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21472 | 21472 | 1909-08-14 | 3 | a | Correspondence from America/ American engineer is involved in river dredge project in Tianjin. Mai Hongjun is to visit America. Huang Kaijia's children attend American school. Chinese student Xiang Xiang in Columbia University. Chinese Empire Reform Association in America sets up a Chinese school. | America | http://trove.nla.gov.au/newspaper/page/26802287 | 26802287 |
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]);