glam-datasets
6 rows where author = "State Library of South Australia", publisher = "State Library of South Australia" and "start_date" is on date 1865-01-01
This data as json, CSV (advanced)
Suggested facets: file_title, file_size, dataset_issued (date), dataset_modified (date), start_date (date), end_date (date), file_created (date), file_modified (date)
| Link | rowid ▼ | dataset_title | publisher | author | dataset_issued | dataset_modified | dataset_description | source | info_url | start_date | end_date | file_title | download_url | format | file_description | file_created | file_modified | file_size | licence |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 660 | 660 | 19th Century Photographs by Captain Samuel Sweet | State Library of South Australia | State Library of South Australia | 2014-06-10T13:51:09.849031 | 2022-01-24T04:24:02.651995 | These photographs (approximately 920) were taken by Captain Samuel Sweet, sea captain and photograph… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/28baf505-4c5f-4e45-9fae-2605ee1cf7c1 | 1865-01-01 | 1902-12-31 | 19th Century Photographs by Captain Samuel Sweet | https://data.sa.gov.au/data/dataset/28baf505-4c5f-4e45-9fae-2605ee1cf7c1/resource/63aaa2e1-b689-4cc9-8835-95d76dd19e74/download/sweetphotographs.csv | CSV | **Explanation of fields** - **RECORD #** : SLSA unique identifier eg "b20223389" - **URL** : URL to… | 2017-07-06T15:53:39.871109 | 2017-07-06T05:53:39.717475 | Creative Commons Attribution | |
| 661 | 661 | 19th Century Photographs by Captain Samuel Sweet | State Library of South Australia | State Library of South Australia | 2014-06-10T13:51:09.849031 | 2022-01-24T04:24:02.651995 | These photographs (approximately 920) were taken by Captain Samuel Sweet, sea captain and photograph… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/28baf505-4c5f-4e45-9fae-2605ee1cf7c1 | 1865-01-01 | 1902-12-31 | 19th Century Photographs by Captain Samuel Sweet - Excel workbook | https://data.sa.gov.au/data/dataset/28baf505-4c5f-4e45-9fae-2605ee1cf7c1/resource/3be4e141-a116-4b3f-b9c1-7d1309608c8d/download/sweetphotographs.xlsx | XLSX | This Excel workbook contains the same data as the CSV file but has the advantage that URLs are activ… | 2017-07-06T15:23:13.410533 | 2017-07-06T05:23:13.308625 | Creative Commons Attribution | |
| 662 | 662 | 19th Century Photographs by Captain Samuel Sweet | State Library of South Australia | State Library of South Australia | 2014-06-10T13:51:09.849031 | 2022-01-24T04:24:02.651995 | These photographs (approximately 920) were taken by Captain Samuel Sweet, sea captain and photograph… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/28baf505-4c5f-4e45-9fae-2605ee1cf7c1 | 1865-01-01 | 1902-12-31 | 19th Century Photographs by Captain Samuel Sweet | https://data.sa.gov.au/data/dataset/28baf505-4c5f-4e45-9fae-2605ee1cf7c1/resource/e442f543-24bd-48be-b0a2-1510210f73c8/download/sweetphotographs.csv | CSV | Compiled 2016. This data set has been superseded by an updated version at the top of this Data and R… | 2016-07-01T13:47:00.730719 | 2016-07-01T03:47:00.594638 | Creative Commons Attribution | |
| 663 | 663 | 19th Century Photographs by Captain Samuel Sweet | State Library of South Australia | State Library of South Australia | 2014-06-10T13:51:09.849031 | 2022-01-24T04:24:02.651995 | These photographs (approximately 920) were taken by Captain Samuel Sweet, sea captain and photograph… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/28baf505-4c5f-4e45-9fae-2605ee1cf7c1 | 1865-01-01 | 1902-12-31 | 19th Century Photographs by Captain Samuel Sweet - Excel workbook | https://data.sa.gov.au/data/dataset/28baf505-4c5f-4e45-9fae-2605ee1cf7c1/resource/23435c1e-89c7-4840-9529-a14ba0e7759b/download/sweetphotographs.xlsx | XLSX | Compiled 2016. This data set has been superseded by an updated version at the top of this Data and R… | 2016-07-01T13:57:16.161176 | 2016-07-01T03:57:16.039581 | Creative Commons Attribution | |
| 664 | 664 | 19th Century Photographs by Captain Samuel Sweet | State Library of South Australia | State Library of South Australia | 2014-06-10T13:51:09.849031 | 2022-01-24T04:24:02.651995 | These photographs (approximately 920) were taken by Captain Samuel Sweet, sea captain and photograph… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/28baf505-4c5f-4e45-9fae-2605ee1cf7c1 | 1865-01-01 | 1902-12-31 | 19th Century Photographs by Captain Samuel Sweet | https://data.sa.gov.au/data/dataset/28baf505-4c5f-4e45-9fae-2605ee1cf7c1/resource/11263fd8-c13d-409e-b31a-ce8366a6b675/download/sweetphotos.csv | CSV | Compiled 2015. This data set has been superseded by an updated version at the top of this Data and R… | 2015-07-02T15:10:21.575727 | Creative Commons Attribution | ||
| 665 | 665 | 19th Century Photographs by Captain Samuel Sweet | State Library of South Australia | State Library of South Australia | 2014-06-10T13:51:09.849031 | 2022-01-24T04:24:02.651995 | These photographs (approximately 920) were taken by Captain Samuel Sweet, sea captain and photograph… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/28baf505-4c5f-4e45-9fae-2605ee1cf7c1 | 1865-01-01 | 1902-12-31 | 19th Century Photographs by Captain Samuel Sweet | https://data.sa.gov.au/data/dataset/28baf505-4c5f-4e45-9fae-2605ee1cf7c1/resource/24e1ae74-585b-4d6f-a7b4-ba9d0df4a44c/download/2014sweet.csv | CSV | Compiled 2014. This data set has been superseded by an updated version at the top of this Data and R… | 2014-06-10T13:54:26.160189 | 2022-01-24T04:23:39.967575 | 429962.0 | Creative Commons Attribution |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [glam-datasets] (
[dataset_title] TEXT,
[publisher] TEXT,
[author] TEXT,
[dataset_issued] TEXT,
[dataset_modified] TEXT,
[dataset_description] TEXT,
[source] TEXT,
[info_url] TEXT,
[start_date] TEXT,
[end_date] TEXT,
[file_title] TEXT,
[download_url] TEXT,
[format] TEXT,
[file_description] TEXT,
[file_created] TEXT,
[file_modified] TEXT,
[file_size] TEXT,
[licence] TEXT
);
CREATE INDEX [idx_glam-datasets_source_publisher_format_licence]
ON [glam-datasets] ([source], [publisher], [format], [licence]);