1 row where dataset_description = "Approximately 11,000 volumes of letters and diaries of WW1 Australian soldiers have been collected by the Library. For the WWI Centenary Commemoration we have committed to making them accessible to all through digitisation and transcription.", publisher = "State Library of NSW" and source = "data.nsw.gov.au"

View and edit SQL

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

source

  • data.nsw.gov.au · 1

publisher

  • State Library of NSW · 1

format

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
922 WW1 Diary and Letter Transcripts State Library of NSW State Library of NSW 2016-07-25T22:26:44.309321 2016-07-25T22:26:59.738806 Approximately 11,000 volumes of letters and diaries of WW1 Australian soldiers have been collected b… data.nsw.gov.au https://data.nsw.gov.au/data/dataset/4095e38b-785f-4f3c-917f-d041fce0e408     WW1 Diary and Letter Transcripts API http://www.sl.nsw.gov.au/api API   2016-07-26T08:26:59.285520     Creative Commons Attribution

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