This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24166 | 24166 | 1911-01-14 | 6 | a | Beijing correspondence | The progress relating to the production of new money coins and notes in Beijing Mint; problems relating to the employee selection system of the Department of Mint; an example of one poorly qualified Hubei Mint manager. | China | http://trove.nla.gov.au/newspaper/page/24091601 | 24091601 |
25557 | 25557 | 1912-01-13 | 2 | b-c | Beijing correspondence | Government bans publication of notices against government found in Beijing. Navy department sends two spies to persuade foreign warships in Shanghai against revolutionaries. Corruption of the parliament for selling Shangdong for money. Yuan Shikai intends to borrow more foreign loans from Britain, France and Belgium. Republic sympathiser Yang Du hides in Tianjin. Princes set ban on all newspapers and close all universities. | Other... | http://trove.nla.gov.au/newspaper/page/24092067 | 24092067 |
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]);