This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22628 | 22628 | 1910-04-09 | 6 | a-b | A warning message from Zhou Ziting, Zhou Jialuo, Zhou Libin and other members of the Chinese Empire Reform Association in American to shareholders of the Zhenhua company on the misconduct of Ou Jujia. | America | http://trove.nla.gov.au/newspaper/page/26802587 | 26802587 |
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]);