glam-datasets
7 rows where "dataset_modified" is on date 2019-08-29, "file_created" is on date 2017-07-06 and format = "XLSX"
This data as json, CSV (advanced)
Suggested facets: dataset_title, author, dataset_issued, dataset_modified, info_url, start_date, end_date, file_description, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 698 | 698 | 19th Century Photographs by Townsend Duryea | State Library of South Australia | State Library of South Australia | 2014-06-10T12:57:32.375370 | 2019-08-29T04:40:29.655895 | The photographs (approximately 165) were taken by Townsend Duryea, a noted photographer of colonial … | data.sa.gov.au | https://data.sa.gov.au/data/dataset/97f60b3e-9b50-4cc2-9960-73288d076c51 | 1856-01-01 | 1887-12-31 | 19th Century Photographs by Townsend Duryea - Excel workbook | https://data.sa.gov.au/data/dataset/97f60b3e-9b50-4cc2-9960-73288d076c51/resource/f1c626b4-17e7-49ce-9cea-ae4b3b02407a/download/duryeaphotographs.xlsx | XLSX | This Excel workbook contains the same data as the CSV file but has the advantage that URLs are activ… | 2017-07-06T16:16:57.988010 | 2017-07-06T06:16:57.906869 | Creative Commons Attribution | |
| 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 | |
| 749 | 749 | Ship Photographs | State Library of South Australia | State Library of South Australia | 2016-06-29T06:44:18.959542 | 2019-08-29T04:35:07.834064 | This dataset includes 5,799 selected photographs related to ships and shipping. Note that images in… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/e52b0259-2b57-4121-8e04-be333025fb3b | 1802-01-01 | 2014-12-31 | Ship Photographs - Excel workbook | https://data.sa.gov.au/data/dataset/e52b0259-2b57-4121-8e04-be333025fb3b/resource/3954cb7d-5225-405e-9c36-69e663615a3d/download/shipphotographs.xlsx | XLSX | Compiled 2017. This data set of 5672 photographs has been superseded by an updated version above in… | 2017-07-06T16:47:03.305963 | 2017-07-06T06:47:03.198596 | Creative Commons Attribution | |
| 759 | 759 | S. A. Speaks: An Oral History of Life in South Australia before 1930 | State Library of South Australia | State Library of South Australia | 2016-06-29T07:00:04.358496 | 2019-08-29T04:32:01.228089 | This dataset includes 45 oral histories from the project S. A. Speaks': An Oral History of Life in S… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/387e2e32-f30c-4f9b-9d8f-848d06dfe18d | 1960-01-01 | 2013-12-31 | S. A. Speaks: An Oral History of Life in South Australia before 1930 - Excel workbook | https://data.sa.gov.au/data/dataset/387e2e32-f30c-4f9b-9d8f-848d06dfe18d/resource/9c141a37-1c35-458f-a897-3a7c032a9138/download/saspeaks_oralhistory.xlsx | XLSX | This Excel workbook contains the same data as the CSV file but has the advantage that URLs are activ… | 2017-07-06T16:33:48.202152 | 2018-06-20T07:55:45.330981 | 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]);