1 row where dataset_description = "Photographs 1914 - 1918. Out of copyright photographs and metadata from State Library of Queensland's collection, waiting to be mashed-up, hacked, and connected with other data. Images are available in three sizes. Descriptive metadata in Dublin Core. NOTE: when working with this dataset (CSV) in EXCEL you may find some irregularities with some of the data fields, particularly the date field and the description field in some records. Using the .txt file may eliminate these issues." and "file_created" is on date 2015-07-02

View and edit SQL

Suggested facets: dataset_issued (date), dataset_modified (date), file_modified (date)

source

format

file_created (date)

  • 2015-07-02 · 1

dataset_description

  • Photographs 1914 - 1918. Out of copyright photographs and metadata from State Library of Queensland's collection, waiting to be mashed-up, hacked, and connected with other data. Images are available in three sizes. Descriptive metadata in Dublin Core. NOTE: when working with this dataset (CSV) in EXCEL you may find some irregularities with some of the data fields, particularly the date field and the description field in some records. Using the .txt file may eliminate these issues. · 1
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
253 State Library of Queensland - Photographs 1914-1918 State Library of Queensland opendata@slq.qld.gov.au 2015-07-02T22:41:29.697651 2020-12-09T05:52:51.543830 Photographs 1914 - 1918. Out of copyright photographs and metadata from State Library of Queensland'… data.qld.gov.au https://data.qld.gov.au/dataset/6b3dc1c0-4ca3-48f4-8524-3731285cc412     Photographs 1914-1918 https://www.data.qld.gov.au/dataset/6b3dc1c0-4ca3-48f4-8524-3731285cc412/resource/2ac90530-58a0-4594-b6a2-04cc5c75114b/download/meadataandurl-worldwar1.csv CSV CSV of out of copyright photographs and metadata from our collection, waiting to be mashed-up, hacke… 2015-07-02T22:45:10.687859 2019-08-22T06:37:10.523859 27262976.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]);