glam-datasets
1 row where "dataset_modified" is on date 2021-12-14 and start_date = "2017-07-01"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 831 | 831 | Contractors engaged by the History Trust of South Australia | History Trust of South Australia | History Trust of South Australia | 2018-09-04T02:43:20.388353 | 2021-12-14T00:00:41.728886 | Contractors by History Trust of South Australia for the period 2019-20 for annual reporting purposes… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/acf3e43e-823b-4238-a620-3e4efaf61a28 | 2017-07-01 | 2020-06-30 | Contractors engaged by the History Trust of South Australia | https://data.sa.gov.au/data/dataset/acf3e43e-823b-4238-a620-3e4efaf61a28/resource/6041e625-5d33-4bf0-9ec0-10c2f87f3c0e/download/contractors-htsa-period-2020-21.csv | CSV | number of contractors engaged by the History Trust of SA 2019-20 | 2019-11-08T01:40:32.149049 | 2021-12-14T00:00:34.775471 | 1025.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]);