glam-datasets
8 rows where "file_created" is on date 2018-06-18, publisher = "State Library of South Australia" and start_date = "1800-01-01"
This data as json, CSV (advanced)
Suggested facets: file_description, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 718 | 718 | 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 | https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455/resource/e6daaa58-dd5a-43cb-8a72-92c10a5041ad/download/sa_photographs_pre-1900.csv | CSV | Compiled 2018. This data set has been superseded by an updated version above in this Data and Resour… | 2018-06-18T05:56:26.517099 | 2018-06-18T05:56:26.344271 | Creative Commons Attribution | |
| 719 | 719 | 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 | https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455/resource/5961a2f4-e5a0-4046-b205-d22f09ab0029/download/sa_photographs_1900-1919.csv | CSV | Compiled 2018. This data set has been superseded by an updated version above in this Data and Resour… | 2018-06-18T05:57:41.313198 | 2018-06-18T05:57:41.026916 | Creative Commons Attribution | |
| 720 | 720 | 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 | https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455/resource/176e5c9d-559a-4d63-85b4-2caaf05c8ba0/download/sa_photographs_1920-1949.csv | CSV | Compiled 2018. This data set has been superseded by an updated version above in this Data and Resour… | 2018-06-18T05:58:54.031442 | 2018-06-18T05:58:53.906041 | Creative Commons Attribution | |
| 721 | 721 | 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 | https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455/resource/f783f22d-eff4-4312-bcc2-dd69dee374d5/download/sa_photographs_1950_onwards.csv | CSV | Compiled 2018. This data set has been superseded by an updated version above in this Data and Resour… | 2018-06-18T05:59:58.434704 | 2018-06-18T05:59:58.221042 | Creative Commons Attribution | |
| 722 | 722 | 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/7071511a-df9d-4ec0-9dd6-f885536c3b74/download/sa_photographs_pre-1900.xlsx | XLSX | Compiled 2018. This data set has been superseded by an updated version above in this Data and Resour… | 2018-06-18T06:03:51.884478 | 2018-06-18T06:03:51.559989 | Creative Commons Attribution | |
| 723 | 723 | 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/43ba749e-b31a-44de-b24c-d7021e257b9d/download/sa_photographs_1900-1919.xlsx | XLSX | Compiled 2018. This data set has been superseded by an updated version above in this Data and Resour… | 2018-06-18T06:05:05.216703 | 2018-06-18T06:05:04.684023 | Creative Commons Attribution | |
| 724 | 724 | 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/f1d53e0f-c97f-4fe8-94a7-607997592885/download/sa_photographs_1920-1949.xlsx | XLSX | Compiled 2018. This data set has been superseded by an updated version above in this Data and Resour… | 2018-06-18T06:06:07.905728 | 2018-06-18T06:06:07.152406 | Creative Commons Attribution | |
| 725 | 725 | 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/390264b3-18b8-4422-9c16-2f38c6d78558/download/sa_photographs_1950_onwards.xlsx | XLSX | Compiled 2018. This data set has been superseded by an updated version above in this Data and Resour… | 2018-06-18T06:07:09.582789 | 2018-06-18T06:07:09.172673 | 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]);