This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
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 | |
44259 | 44259 | 1925-12-12 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101389 | 24101389 | |
44260 | 44260 | 1925-12-12 | 8 | e | Liner timetable. | Tung Wah | 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]);