This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25931 | 25931 | 1912-03-30 | 2 | c-d | Sun Yatsen's letter to the senate | Sun Yatsen, temporary president of the Republic of China, offers resignation letter to the senate, recommending Yuan Shikai to be the candidate for president. | China | http://trove.nla.gov.au/newspaper/page/24092183 | 24092183 |
25947 | 25947 | 1912-03-30 | 3 | c-d | Guangdong news | Guangxi troop and the new troop conflicted over ownership of the confiscated gun from bandits. Old paper money is to be used as new currency has not been issued. Salt businessmen are ordered to prepay military funds. Guangdong people destroyed two Buddhist temples due to their alleged destruction on Fengsui. Guangdong customs changed their names to the republic. Two gentlemen were forced to give money to the bandits party in Dongwan, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24092182 | 24092182 |
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]);