glam-datasets
2 rows where author = "Author Not Specified", "dataset_issued" is on date 2017-06-01 and source = "data.wa.gov.au"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1038 | 1038 | Geolocation index for WA townsite plans - AU WA S2168 | State Records Office of Western Australia | Author Not Specified | 2017-06-01T04:26:54.360060 | 2022-05-25T14:59:14.998365 | Geolocation and other data for townsite plans transcribed from _"Cancelled public plans" and related… | data.wa.gov.au | https://catalogue.data.wa.gov.au/dataset/7a4f046f-9b1d-4faa-9d42-7f229ca3b5a4 | Townsite index | https://catalogue.data.wa.gov.au/dataset/7a4f046f-9b1d-4faa-9d42-7f229ca3b5a4/resource/19d31ed3-cbd5-496b-bd4e-7862690e82bf/download/maps-of-wa-townsites-parts-1-2.csv | CSV | 2017-06-01T16:19:51.089202 | 2017-06-01T06:19:51.045417 | Creative Commons Attribution Non-Commercial 4.0 | ||||
| 1077 | 1077 | Historical index to government entities | State Records Office of Western Australia | Author Not Specified | 2017-06-01T08:30:23.055707 | 2022-05-25T14:59:22.157004 | Listing of government entities identified in the State archives collection | data.wa.gov.au | https://catalogue.data.wa.gov.au/dataset/6a3df6d1-f889-4059-892f-a335af6e1cc3 | Agency index | https://catalogue.data.wa.gov.au/dataset/6a3df6d1-f889-4059-892f-a335af6e1cc3/resource/89911fd3-075c-4b5b-82ce-dae1b53ad3b1/download/government-entities-identified-by-srowa.csv | CSV | 2017-06-01T18:30:47.628843 | 2017-06-01T08:30:47.579452 | Creative Commons Attribution Non-Commercial 4.0 |
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]);