This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27181 | 27181 | 1913-03-22 | 7 | b | Australian news/ Chinese consul general to Australia's response to Jingdong Newspaper's attack on him. Australian capital foundation stone laying ceremony held. New New South Wales' governor takes office. South Australia church society appeals to government for Pan Ru's case. | Other... | http://trove.nla.gov.au/newspaper/page/24092620 | 24092620 |
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]);