This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, 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 | |
21956 | 21956 | 1909-11-13 | 3 | c-d | China to set up consulate in German Samoa. | China | http://trove.nla.gov.au/newspaper/page/26802391 | 26802391 | |
21958 | 21958 | 1909-11-13 | 3 | d | Correspondence from Beijing/ Returned students sit for government examination. | China | http://trove.nla.gov.au/newspaper/page/26802391 | 26802391 |
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]);