glam-datasets
2 rows where dataset_title = "Fitzroy River 1850" and publisher = "State Records Office of Western Australia"
This data as json, CSV (advanced)
Suggested facets: dataset_issued (date), dataset_modified (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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1095 | 1095 | Fitzroy River 1850 | State Records Office of Western Australia | Author Not Specified | 2016-01-20T05:13:00.044813 | 2022-05-25T14:59:27.827761 | AU WA S236- cons3869 Kent 35 Vicinity of the Fitzroy River, Mt Campbell, Margaret & Cunningham Riv… | data.wa.gov.au | https://catalogue.data.wa.gov.au/dataset/9343f6a8-efac-4b4d-af2b-552d5992458b | Imagery File | https://catalogue.data.wa.gov.au/dataset/9343f6a8-efac-4b4d-af2b-552d5992458b/resource/c7125ba3-972a-446a-b3b0-e5bcdb8d3c27/download/series236_cons3869_itemkent35.img | IMG | This resource provides a once off snapshot of the dataset for the image. | 2021-05-03T04:24:01.960355 | 90026529.0 | ||||
| 1096 | 1096 | Fitzroy River 1850 | State Records Office of Western Australia | Author Not Specified | 2016-01-20T05:13:00.044813 | 2022-05-25T14:59:27.827761 | AU WA S236- cons3869 Kent 35 Vicinity of the Fitzroy River, Mt Campbell, Margaret & Cunningham Riv… | data.wa.gov.au | https://catalogue.data.wa.gov.au/dataset/9343f6a8-efac-4b4d-af2b-552d5992458b | Imagery File | https://catalogue.data.wa.gov.au/dataset/9343f6a8-efac-4b4d-af2b-552d5992458b/resource/c8c533db-2719-422e-abe3-4c841418953c/download/imagery-file.jpg | JPG | 2022-03-15T01:33:54.093211 | 2022-03-15T01:33:54.035619 |
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]);