This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39334 | 39334 | 1923-01-27 | 6 | d | Hawaiian authority seeks to employ some Chinese labourers and the motives. | America | http://trove.nla.gov.au/newspaper/page/24094272 | 24094272 | |
39335 | 39335 | 1923-01-27 | 6 | d | Change of political situation in Europe. | Germany | http://trove.nla.gov.au/newspaper/page/24094272 | 24094272 | |
39343 | 39343 | 1923-01-27 | 7 | d | Mrs Florence Sun-Chong and family desire to thank friend for all floral tributes, telegrams and letters of sympathy in their recent sad bereavement in the death of their husband and father (Luo Shun). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094271 | 24094271 |
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]);