This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50542 | 50542 | 1931-07-25 | 5 | a | Hong Kong news/ Guangdong confronts the Nanjing government and their preparation. Zhongshan businessmen in Hong Kong protest against the land bureau director in their home town for land disputes. Street beggars to be collected. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090462 | 24090462 |
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]);