This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30922 | 30922 | 1916-01-22 | 6 | a-b | Zhang Boquan's letter on relations between China's future and the Europe War. | China | http://trove.nla.gov.au/newspaper/page/24095122 | 24095122 | |
30923 | 30923 | 1916-01-22 | 6 | b | News miscellany/Liang Qichao is to go to America for treatment. Li Yuanhong decides to resign. Beijing hangs flags celebrating Yuan Shikai's coming to throne. Yuan Shikai claims to save China by sacrificing his life and his offspring. | China | http://trove.nla.gov.au/newspaper/page/24095122 | 24095122 | |
30924 | 30924 | 1916-01-22 | 6 | b | A satire story on the new emperor in China. | Other... | http://trove.nla.gov.au/newspaper/page/24095122 | 24095122 |
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]);