4 rows where "file_created" is on date 2017-06-29

View and edit SQL

Suggested facets: dataset_title, author, dataset_issued, dataset_modified, info_url, file_size, dataset_issued (date), dataset_modified (date), file_modified (date)

format

file_created (date)

  • 2017-06-29 · 4
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
374 School Admissions Registers 1878-2001 Queensland State Archives web@archives.qld.gov.au 2017-06-29T05:54:35.461097 2022-06-29T02:06:47.270076 This index is a compilation of all series of school admission registers for all state schools from 1… data.qld.gov.au https://data.qld.gov.au/dataset/a524638c-c19c-4c18-9f44-9603a69fa07a     School Admission Registers 1878-2001 https://www.data.qld.gov.au/dataset/a524638c-c19c-4c18-9f44-9603a69fa07a/resource/6169abd8-a6dd-4cb0-a1de-7f698707d229/download/school-admissions-registers-1878-2001.csv CSV This index is a compilation of all series of school admission registers for all state schools from 1… 2017-06-29T15:56:01.051197 2017-06-29T05:56:00.874005 3879731.0 Creative Commons Attribution 4.0
388 Cabinet Minutes Queensland State Archives web@archives.qld.gov.au 2017-06-29T03:47:22.564346 2022-06-28T22:51:31.012585 Cabinet decisions are given the formal title 'Minutes'. The term 'Decisions' is not strictly applica… data.qld.gov.au https://data.qld.gov.au/dataset/8cfc4428-9c77-400c-9a9e-0225254411a5     1986 Cabinet Minutes https://www.data.qld.gov.au/dataset/8cfc4428-9c77-400c-9a9e-0225254411a5/resource/16a76e3c-f72b-445b-9fba-c0314de90724/download/cabinet-minutes-1986.csv CSV Cabinet decisions are given the formal title 'Minutes'. The term 'Decisions' is not strictly applica… 2017-06-29T13:48:02.179220 2018-08-30T00:00:00 1013248.0 Creative Commons Attribution 4.0
1091 Indexes State Records Office of Western Australia Author Not Specified 2017-06-29T03:21:53.456006 2022-05-25T14:59:27.433142 Images of index plans for cancelled public plans, 1900 and 1949. Shows boundaries for cancelled publ… data.wa.gov.au https://catalogue.data.wa.gov.au/dataset/69b465f2-602a-4cd9-8bcf-e6fa09a63f50     Index plan 1900 https://catalogue.data.wa.gov.au/dataset/69b465f2-602a-4cd9-8bcf-e6fa09a63f50/resource/622e3deb-526c-490f-8f75-15bc85530f91/download/index-map-1900.jpg JPG   2017-06-29T13:22:49.667226 2017-06-29T03:22:49.623280    
1092 Indexes State Records Office of Western Australia Author Not Specified 2017-06-29T03:21:53.456006 2022-05-25T14:59:27.433142 Images of index plans for cancelled public plans, 1900 and 1949. Shows boundaries for cancelled publ… data.wa.gov.au https://catalogue.data.wa.gov.au/dataset/69b465f2-602a-4cd9-8bcf-e6fa09a63f50     Index plan 1949 https://catalogue.data.wa.gov.au/dataset/69b465f2-602a-4cd9-8bcf-e6fa09a63f50/resource/2e73b886-74da-4359-b385-4c07427e391b/download/index-map-1949.jpg JPG Shows boundaries for cancelled public plans in SROWA Series 981 (Cancelled Public Plans - 80 Chain P… 2017-06-29T13:23:18.602192 2017-06-29T03:23:18.540131    

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);