This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26141 | 26141 | 1912-05-18 | 2 | b-c | Preident Yuan's orders | Yuan Shikai orders that all chief officers in all provinces are to change their names into governors. Some appointments for government officials are announced. Soldiers are ordered to obey laws and regulations. | China | http://trove.nla.gov.au/newspaper/page/24092240 | 24092240 |
26164 | 26164 | 1912-05-18 | 6 | b-c | Memorandum for Tan Sitong and Tan Caichang | A memorandum should be built for memorising Two Tans' revolutionary deeds for China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092244 | 24092244 |
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]);