data: glam-datasets: 1 row where 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." and format = "API"

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." and format = "API"

Search:

descending

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	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

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