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 | |
22629 | 22629 | 1910-04-09 | 6 | b-c | Opium ban in Shanxi province and the difficulties. | China | http://trove.nla.gov.au/newspaper/page/26802587 | 26802587 | |
22630 | 22630 | 1910-04-09 | 6 | c | Japan has new warship and its power. | Tung Wah | 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]);