This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24672 | 24672 | 1911-07-08 | 2 | c | The Regent appeals | The Regent appeals for reappointment of Wuxu party members. | Other... | http://trove.nla.gov.au/newspaper/page/24091835 | 24091835 |
24686 | 24686 | 1911-07-08 | 3 | c | Beijing news | China's indemnities to foreign nations. Budget for the imperial family. An unease cabinet. The advisory committee decided to overthrow the Emperor. The corruption of Guizhou inspector. New money tries in East China. A British battleship intrudes Fuzhou, Fujian. | Other... | http://trove.nla.gov.au/newspaper/page/24091834 | 24091834 |
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]);