data: glam-datasets: 7 rows where where "start

7 rows where "start_date" is on date 1850-01-01

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
677	677	Departed spirits: Lost pubs of Adelaide	State Library of South Australia	State Library of South Australia	2016-06-29T04:35:15.964399	2020-01-15T06:47:38.894121	Known as the city of churches, Adelaide has also been described as the city of pubs. This dataset co…	data.sa.gov.au	https://data.sa.gov.au/data/dataset/e91c7cfa-341a-49d3-b7d9-074c0b138dd6	1850-01-01	1966-12-31	Departed spirits: Lost pubs of Adelaide Flickr album	https://www.flickr.com/photos/state_library_south_australia/sets/72157648540426502	JPEG	Link to Flickr album	2016-06-29T14:36:02.969926			Creative Commons Attribution
775	775	19th Century Photographs by Ernest Gall	State Library of South Australia	State Library of South Australia	2014-06-10T13:32:58.334603	2017-07-06T06:11:06.592081	The photographs (approximately 660) were taken by Ernest Gall, a South Australian born photographer …	data.sa.gov.au	https://data.sa.gov.au/data/dataset/54c50844-6653-4704-8dc8-5f5c8f5f14eb	1850-01-01	1920-12-31	19th Century Photographs by Ernest Gall	https://data.sa.gov.au/data/dataset/54c50844-6653-4704-8dc8-5f5c8f5f14eb/resource/ff7198a2-fb79-4858-9a4e-1bc9b9250f79/download/gallphotographs.csv	CSV	Explanation of fields - RECORD # : SLSA unique identifier eg "b20223389" - URL : URL to…	2017-07-06T16:07:57.922939	2017-07-06T06:07:57.838055		Creative Commons Attribution
776	776	19th Century Photographs by Ernest Gall	State Library of South Australia	State Library of South Australia	2014-06-10T13:32:58.334603	2017-07-06T06:11:06.592081	The photographs (approximately 660) were taken by Ernest Gall, a South Australian born photographer …	data.sa.gov.au	https://data.sa.gov.au/data/dataset/54c50844-6653-4704-8dc8-5f5c8f5f14eb	1850-01-01	1920-12-31	19th Century Photographs by Ernest Gall - Excel workbook	https://data.sa.gov.au/data/dataset/54c50844-6653-4704-8dc8-5f5c8f5f14eb/resource/847a664d-cfff-4cda-ab74-17221c46fd78/download/gallphotographs.xlsx	XLSX	This Excel workbook contains the same data as the CSV file but has the advantage that URLs are activ…	2017-07-06T16:10:00.215806	2017-07-06T06:10:00.128339		Creative Commons Attribution
777	777	19th Century Photographs by Ernest Gall	State Library of South Australia	State Library of South Australia	2014-06-10T13:32:58.334603	2017-07-06T06:11:06.592081	The photographs (approximately 660) were taken by Ernest Gall, a South Australian born photographer …	data.sa.gov.au	https://data.sa.gov.au/data/dataset/54c50844-6653-4704-8dc8-5f5c8f5f14eb	1850-01-01	1920-12-31	19th Century Photographs by Ernest Gall	https://data.sa.gov.au/data/dataset/54c50844-6653-4704-8dc8-5f5c8f5f14eb/resource/201ee805-a8ff-4fa7-9856-9625b3532b35/download/gallphotographs.csv	CSV	Compiled 2016. This data set has been superseded by an updated version at the top of this Data and R…	2016-07-01T14:20:36.682741	2016-07-01T04:20:36.441339		Creative Commons Attribution
778	778	19th Century Photographs by Ernest Gall	State Library of South Australia	State Library of South Australia	2014-06-10T13:32:58.334603	2017-07-06T06:11:06.592081	The photographs (approximately 660) were taken by Ernest Gall, a South Australian born photographer …	data.sa.gov.au	https://data.sa.gov.au/data/dataset/54c50844-6653-4704-8dc8-5f5c8f5f14eb	1850-01-01	1920-12-31	19th Century Photographs by Ernest Gall - Excel workbook	https://data.sa.gov.au/data/dataset/54c50844-6653-4704-8dc8-5f5c8f5f14eb/resource/2a2e9a1b-3101-4e07-b120-9c8520127192/download/gallphotographs.xlsx	XLSX	Compiled 2016. This data set has been superseded by an updated version at the top of this Data and R…	2016-07-01T14:21:56.713177	2016-07-01T04:21:56.589108		Creative Commons Attribution
779	779	19th Century Photographs by Ernest Gall	State Library of South Australia	State Library of South Australia	2014-06-10T13:32:58.334603	2017-07-06T06:11:06.592081	The photographs (approximately 660) were taken by Ernest Gall, a South Australian born photographer …	data.sa.gov.au	https://data.sa.gov.au/data/dataset/54c50844-6653-4704-8dc8-5f5c8f5f14eb	1850-01-01	1920-12-31	19th Century Photographs by Ernest Gall	https://data.sa.gov.au/data/dataset/54c50844-6653-4704-8dc8-5f5c8f5f14eb/resource/172c782e-5939-4db3-808f-77c9a6a5e238/download/gallphotos.csv	CSV	Compiled 2015. This data set has been superseded by an updated version at the top of this Data and R…	2015-07-02T15:03:04.999138			Creative Commons Attribution
780	780	19th Century Photographs by Ernest Gall	State Library of South Australia	State Library of South Australia	2014-06-10T13:32:58.334603	2017-07-06T06:11:06.592081	The photographs (approximately 660) were taken by Ernest Gall, a South Australian born photographer …	data.sa.gov.au	https://data.sa.gov.au/data/dataset/54c50844-6653-4704-8dc8-5f5c8f5f14eb	1850-01-01	1920-12-31	19th Century Photographs by Ernest Gall	https://data.sa.gov.au/data/storage/f/2014-06-10T13%3A33%3A42.402Z/2014gall.csv	CSV	Compiled 2014. This data set has been superseded by an updated version at the top of this Data and R…	2014-06-10T13:36:58.898503	2014-10-30T09:01:20	392612.0	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]);