This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
44365 | 44365 | 1926-01-23 | 8 | a-d | Guangdong news/ Commercial chambers in Guangzhou appoints their representatives to end the strike. Police bureau in Guangzhou takes precautions against robbery. Zou Lu is removed from his current position. Ferries in Xinhui county are armed with weapons. Warning to the passengers of Hong Kong ferries. | China | http://trove.nla.gov.au/newspaper/page/24101437 | 24101437 |
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]);