This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21687 | 21687 | 1909-09-25 | 2 | d | Beijing news/ Duan Fang and his political proposal. China to purchase speedboat from America. Negotiation and agreement between Japan and China on the Changchun railroad. Transportation network designed for Manchuria and Mongolia. Government departments in Beijing to be reshuffled. | China | http://trove.nla.gov.au/newspaper/page/26802336 | 26802336 | |
21698 | 21698 | 1909-09-25 | 3 | c-d | Opium export from India to Hong Kong (1905-1908). | China | http://trove.nla.gov.au/newspaper/page/26802335 | 26802335 |
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]);