glam-datasets
4 rows where file_description = "Compiled 2017. This data set has been superseded by an updated version above in this Data and Resources list. This Excel workbook contains the same data as the corresponding CSV file but has the advantage that URLs are active hyperlinks." and format = "XLSX"
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 730 | 730 | South Australian Photographs | State Library of South Australia | Andrew Piper | 2013-03-07T14:40:31.091907 | 2019-08-29T04:36:26.010768 | Photographs relating to South Australia feature localities across the state, houses and buildings, p… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455 | 1800-01-01 | 2019-05-20 | South Australian Photographs: pre 1900 (Excel workbook) | https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455/resource/ce71fd1a-35b7-4684-9fd9-9ea38a8c8b0f/download/saphotographspre-1900.xlsx | XLSX | Compiled 2017. This data set has been superseded by an updated version above in this Data and Resour… | 2017-07-06T17:27:45.118876 | 2017-07-06T07:27:44.961179 | Creative Commons Attribution | |
| 731 | 731 | South Australian Photographs | State Library of South Australia | Andrew Piper | 2013-03-07T14:40:31.091907 | 2019-08-29T04:36:26.010768 | Photographs relating to South Australia feature localities across the state, houses and buildings, p… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455 | 1800-01-01 | 2019-05-20 | South Australian Photographs: 1900 - 1919 (Excel workbook) | https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455/resource/6d0192a1-bead-46a4-bca7-58e518c1b2e6/download/saphotographs1900-1919.xlsx | XLSX | Compiled 2017. This data set has been superseded by an updated version above in this Data and Resour… | 2017-07-06T17:29:25.356733 | 2017-07-06T07:29:25.194336 | Creative Commons Attribution | |
| 732 | 732 | South Australian Photographs | State Library of South Australia | Andrew Piper | 2013-03-07T14:40:31.091907 | 2019-08-29T04:36:26.010768 | Photographs relating to South Australia feature localities across the state, houses and buildings, p… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455 | 1800-01-01 | 2019-05-20 | South Australian Photographs: 1920 - 1949 (Excel workbook) | https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455/resource/c3a69245-6133-4a3b-8af9-4e6e042d8062/download/saphotographs1920-1949.xlsx | XLSX | Compiled 2017. This data set has been superseded by an updated version above in this Data and Resour… | 2017-07-06T17:30:12.441360 | 2017-07-06T07:30:12.301962 | Creative Commons Attribution | |
| 733 | 733 | South Australian Photographs | State Library of South Australia | Andrew Piper | 2013-03-07T14:40:31.091907 | 2019-08-29T04:36:26.010768 | Photographs relating to South Australia feature localities across the state, houses and buildings, p… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455 | 1800-01-01 | 2019-05-20 | South Australian Photographs: 1950 onwards (Excel workbook) | https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455/resource/8a661400-bf41-4543-b506-51da9fa33107/download/saphotographs1950onwards.xlsx | XLSX | Compiled 2017. This data set has been superseded by an updated version above in this Data and Resour… | 2017-07-06T17:31:12.522406 | 2017-07-06T07:31:12.340410 | 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]);