This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
44258 | 44258 | 1925-12-12 | 8 | a-d | Guangdong news/ Guangzhou government discusses the proposal for southern expedition. Wu Peifu and his attitude towards the current situations. Guangzhou government authority takes over charity properties. Ban on gambling in Guangzhou. Pressgang in Gaoyao county. | China | http://trove.nla.gov.au/newspaper/page/24101389 | 24101389 |
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]);