This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21945 | 21945 | 1909-11-13 | 2-3 | d-a | Beijing news/ Order to ban both local and imported opium. Russia and Japan compete against each other in Mongolia. Prince Qing recommends talents. Xi Liang reports on his negotiation with Japanese. Sun Jialai and other staff in the Political Consulting Institute (zi zheng yuan). Tsar of Russia presents gifts to the Chinese ministry of foreign affairs. | China | http://trove.nla.gov.au/newspaper/page/26802392 | 26802392 |
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]);