This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
23561 | 23561 | 1910-10-01 | 2 | c | News in brief/ Prince Zai Tao has some new ideas after his overseas tour. China to purchase gunboat from Germany. Tang Shouqian is dismissed. Lu Chuanlin dies. Zai Xun is once again on an overseas tour. | China | http://trove.nla.gov.au/newspaper/page/26802786 | 26802786 | |
23573 | 23573 | 1910-10-01 | 3 | c | Japan prepares for a new shipping line to America following the opening of Panama Canal. Balloon study in Japan for military purpose. | Japan | http://trove.nla.gov.au/newspaper/page/26802785 | 26802785 |
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]);