2 rows where "file_created" is on date 2017-06-29, format = "CSV", licence = "Creative Commons Attribution 4.0" and publisher = "Queensland State Archives"

View and edit SQL

Suggested facets: dataset_issued (date)

dataset_modified (date)

source

publisher

  • Queensland State Archives · 2

licence

  • Creative Commons Attribution 4.0 · 2

format

file_created (date)

  • 2017-06-29 · 2
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

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