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 |
---|---|---|---|---|---|---|---|---|---|
37564 | 37564 | 1921-09-10 | 6 | a | Prose/ Herding horses in the late autumn. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093683 | 24093683 | |
37568 | 37568 | 1921-09-10 | 7 | a | Health authority in the city of Alexandria, Sydney, to ban Chinese gardeners washing vegetables in the pond. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093682 | 24093682 | |
37569 | 37569 | 1921-09-10 | 7 | a | Some flour mills in Sydney to be closed down and the workers will be unemployed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093682 | 24093682 | |
37570 | 37570 | 1921-09-10 | 7 | a | Four unemployed men in Sydney are penalised for refusing to pay the restaurant. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093682 | 24093682 | |
37571 | 37571 | 1921-09-10 | 7 | a | A shoe repairer in Sydney is penalised for selling wine without licence. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093682 | 24093682 | |
37572 | 37572 | 1921-09-10 | 7 | a | New South Wales parliament and government try to solve the unemployment problem. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093682 | 24093682 |
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]);