glam-datasets
2 rows where "dataset_issued" is on date 2016-06-29, "file_created" is on date 2017-07-06, format = "CSV" and source = "data.sa.gov.au"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 748 | 748 | 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 | https://data.sa.gov.au/data/dataset/e52b0259-2b57-4121-8e04-be333025fb3b/resource/ab6cb1a4-44cc-4514-a38f-eac5c50d5aa1/download/shipphotographs.csv | CSV | Compiled 2017. This data set of 5672 photographs has been superseded by an updated version at the to… | 2017-07-06T16:46:20.810689 | 2017-07-06T06:46:20.707799 | Creative Commons Attribution | |
| 758 | 758 | 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 | https://data.sa.gov.au/data/dataset/387e2e32-f30c-4f9b-9d8f-848d06dfe18d/resource/36eb6481-5290-4edb-8392-b6b65478035e/download/saspeaks_oralhistory.csv | CSV | **Explanation of fields** - **URL** : URL of location of item online; audio file included in MP3 an… | 2017-07-06T16:29:33.848862 | 2018-06-20T07:54:20.141244 | 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]);