This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25834 | 25834 | 1912-03-09 | 2 | c-d | Foreigners urge the emperor's abdication | A number of American and British priests urge Qing emperor to abdicate for the sake of the country. | China | http://trove.nla.gov.au/newspaper/page/24092157 | 24092157 |
25843 | 25843 | 1912-03-09 | 3 | c-d | Guangdong news | Income of Guangdong railways increases after revolution. Guangdong government notice for removing Wu Yang Chen and constructing high way. Tade Association of Guangdong can hardly provide funds to various organisations and activities and it is in dilemma. Hair is replaced for glue to make weapon parts in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24092156 | 24092156 |
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]);