17 rows where "file_created" is on date 2015-07-02 and licence = "Creative Commons Attribution"

View and edit SQL

Suggested facets: dataset_title, author, dataset_issued, dataset_modified, dataset_description, info_url, start_date, end_date, file_description, dataset_issued (date), dataset_modified (date), start_date (date), end_date (date), file_created (date)

format

source

licence

  • Creative Commons Attribution · 17
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
664 19th Century Photographs by Captain Samuel Sweet State Library of South Australia State Library of South Australia 2014-06-10T13:51:09.849031 2022-01-24T04:24:02.651995 These photographs (approximately 920) were taken by Captain Samuel Sweet, sea captain and photograph… data.sa.gov.au https://data.sa.gov.au/data/dataset/28baf505-4c5f-4e45-9fae-2605ee1cf7c1 1865-01-01 1902-12-31 19th Century Photographs by Captain Samuel Sweet https://data.sa.gov.au/data/dataset/28baf505-4c5f-4e45-9fae-2605ee1cf7c1/resource/11263fd8-c13d-409e-b31a-ce8366a6b675/download/sweetphotos.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:10:21.575727     Creative Commons Attribution
701 19th Century Photographs by Townsend Duryea State Library of South Australia State Library of South Australia 2014-06-10T12:57:32.375370 2019-08-29T04:40:29.655895 The photographs (approximately 165) were taken by Townsend Duryea, a noted photographer of colonial … data.sa.gov.au https://data.sa.gov.au/data/dataset/97f60b3e-9b50-4cc2-9960-73288d076c51 1856-01-01 1887-12-31 19th Century Photographs by Townsend Duryea. https://data.sa.gov.au/data/dataset/97f60b3e-9b50-4cc2-9960-73288d076c51/resource/fd8121b6-7529-4d29-b2d0-1a293154b9a6/download/duryeaphotos.csv CSV Compiled 2015. This data set has been superseded by an updated version at the top of this Data and R… 2015-07-02T14:33:58.129673     Creative Commons Attribution
742 South Australian Photographs State Library of South Australia Andrew Piper 2013-03-07T14:40:31.091907 2019-08-29T04:36:26.010768 Photographs relating to South Australia feature localities across the state, houses and buildings, p… data.sa.gov.au https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455 1800-01-01 2019-05-20 South Australian Photographs: pre 1900 https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455/resource/d1375c32-fd80-4534-8147-d8c5f8795a42/download/slsaphotospre1900.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:50:10.781914     Creative Commons Attribution
743 South Australian Photographs State Library of South Australia Andrew Piper 2013-03-07T14:40:31.091907 2019-08-29T04:36:26.010768 Photographs relating to South Australia feature localities across the state, houses and buildings, p… data.sa.gov.au https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455 1800-01-01 2019-05-20 South Australian Photographs: 1900 - 1919 https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455/resource/7774cd59-c88b-4576-b8f1-86e5d0c4bcbc/download/slsaphotos19001919.csv CSV Compiled 2015. This data set has been superseded by an updated version at the top of this Data and R… 2015-07-02T16:07:10.369999     Creative Commons Attribution
744 South Australian Photographs State Library of South Australia Andrew Piper 2013-03-07T14:40:31.091907 2019-08-29T04:36:26.010768 Photographs relating to South Australia feature localities across the state, houses and buildings, p… data.sa.gov.au https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455 1800-01-01 2019-05-20 South Australian Photographs: 1920 - 1949 https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455/resource/ec3051c0-d61b-44a3-9538-639d676cf8b0/download/slsaphotos19201949.csv CSV Compiled 2015. This data set has been superseded by an updated version at the top of this Data and R… 2015-07-02T16:09:11.345535     Creative Commons Attribution
745 South Australian Photographs State Library of South Australia Andrew Piper 2013-03-07T14:40:31.091907 2019-08-29T04:36:26.010768 Photographs relating to South Australia feature localities across the state, houses and buildings, p… data.sa.gov.au https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455 1800-01-01 2019-05-20 South Australian Photographs: 1950 onwards https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455/resource/490d47bc-a9db-434b-8064-b46c7c60b07e/download/slsaphotos1950onwards.csv CSV Compiled 2015. This data set has been superseded by an updated version at the top of this Data and R… 2015-07-02T16:10:50.592692     Creative Commons Attribution
769 Heroes of the Great War Chronicle Newspaper Portraits 1915-1919 State Library of South Australia State Library of South Australia 2013-05-21T09:41:06.618734 2019-08-07T04:35:58.574343 Heroes of the Great War Indexing Project - over 17,000 references to notices published in the South … data.sa.gov.au https://data.sa.gov.au/data/dataset/11ed7815-8efa-4e72-a932-aea9f00e3d4f 1915-01-01 1919-12-31 Heroes of the Great War Chronicle Portraits 1915-1919 https://data.sa.gov.au/data/dataset/11ed7815-8efa-4e72-a932-aea9f00e3d4f/resource/a946b38d-be5a-4f36-a8d0-d96a2a84bf61/download/heroesofthegreatwarchronicleportraits.csv CSV Heroes of the Great War Indexing Project - over 17,000 references to notices published in the South … 2015-07-02T13:50:52.137035     Creative Commons Attribution
770 Heroes of the Great War Chronicle Newspaper Portraits 1915-1919 State Library of South Australia State Library of South Australia 2013-05-21T09:41:06.618734 2019-08-07T04:35:58.574343 Heroes of the Great War Indexing Project - over 17,000 references to notices published in the South … data.sa.gov.au https://data.sa.gov.au/data/dataset/11ed7815-8efa-4e72-a932-aea9f00e3d4f 1915-01-01 1919-12-31 Heroes of the Great War Chronicle Portraits - Additional Information https://data.sa.gov.au/data/dataset/11ed7815-8efa-4e72-a932-aea9f00e3d4f/resource/6e22e83f-eb09-47bb-a680-5efa98a375b3/download/heroesofthegreatwarchronicleportraitsdescriptionofdataset.doc DOC Heroes of the Great War Indexing Project - over 17,000 references to notices published in the South … 2015-07-02T14:04:02.836618     Creative Commons Attribution
772 Heroes of the Great War Chronicle Newspaper 1915-1919 State Library of South Australia State Library of South Australia 2013-05-21T09:33:48.665233 2019-08-07T04:30:27.193034 Heroes of the Great War Indexing Project - over 17,000 references to notices published in the South … data.sa.gov.au https://data.sa.gov.au/data/dataset/a3fe22b1-0807-4409-bdab-46dbbad6c300 1915-01-01 1919-12-31 Heroes of the Great War Chronicle 1915-1919 https://data.sa.gov.au/data/dataset/a3fe22b1-0807-4409-bdab-46dbbad6c300/resource/456285e1-ac4a-476c-9e7c-791dd6d58ff5/download/heroesofthegreatwarchroniclepersonalnotices.csv CSV Heroes of the Great War Indexing Project - over 17,000 references to notices published in the South … 2015-07-02T12:51:23.023143     Creative Commons Attribution
773 Heroes of the Great War Chronicle Newspaper 1915-1919 State Library of South Australia State Library of South Australia 2013-05-21T09:33:48.665233 2019-08-07T04:30:27.193034 Heroes of the Great War Indexing Project - over 17,000 references to notices published in the South … data.sa.gov.au https://data.sa.gov.au/data/dataset/a3fe22b1-0807-4409-bdab-46dbbad6c300 1915-01-01 1919-12-31 Heroes of the Great War Chronicle - Additional Information https://data.sa.gov.au/data/dataset/a3fe22b1-0807-4409-bdab-46dbbad6c300/resource/615163bd-ffb2-4a1a-9899-41654bc3caed/download/heroesofthegreatwarchronicledescriptionofdataset.doc DOC Heroes of the Great War Indexing Project - over 17,000 references to notices published in the South … 2015-07-02T12:53:09.807933     Creative Commons Attribution
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
786 Election Ephemera State Library of South Australia State Library of South Australia 2013-05-06T03:19:09.193539 2016-07-01T05:44:24.139830 365 catalogue records including material that has been collected from Local, State and Federal elect… data.sa.gov.au https://data.sa.gov.au/data/dataset/d2633f93-d2e9-4d32-acb8-2c3883db8651 1879-01-01 2014-12-31 Election Leaflets https://data.sa.gov.au/data/dataset/d2633f93-d2e9-4d32-acb8-2c3883db8651/resource/92abbc3b-955c-44d5-8b73-f5eb5790198a/download/electionleaflets.csv CSV Compiled 2015. This data set has been superseded by an updated version at the top of this Data and R… 2015-07-02T13:11:56.216154     Creative Commons Attribution
787 Election Ephemera State Library of South Australia State Library of South Australia 2013-05-06T03:19:09.193539 2016-07-01T05:44:24.139830 365 catalogue records including material that has been collected from Local, State and Federal elect… data.sa.gov.au https://data.sa.gov.au/data/dataset/d2633f93-d2e9-4d32-acb8-2c3883db8651 1879-01-01 2014-12-31 Election Posters https://data.sa.gov.au/data/dataset/d2633f93-d2e9-4d32-acb8-2c3883db8651/resource/03a27394-2d6c-4c22-b5e6-362f7f122ec6/download/electionposters.csv CSV Compiled 2015. This data set has been superseded by an updated version at the top of this Data and R… 2015-07-02T13:13:24.709727     Creative Commons Attribution
840 SA History Hub History Trust of South Australia History Trust of South Australia 2015-07-02T05:59:59.012059 2017-06-27T02:08:18.983918 The SA History Hub website is an interactive way of engaging with the history of our state. This sit… data.sa.gov.au https://data.sa.gov.au/data/dataset/53b4d7c2-a1b0-4b59-b7e0-28ee57db546e 1836-01-01 Current Historical Places https://data.history.sa.gov.au/sahistoryhub/place GeoJSON #SA History Hub GEOJSON Endpoint http://data.history.sa.gov.au/sahistoryhub/{type} Replace {ty… 2015-07-02T16:03:37.435850     Creative Commons Attribution
841 SA History Hub History Trust of South Australia History Trust of South Australia 2015-07-02T05:59:59.012059 2017-06-27T02:08:18.983918 The SA History Hub website is an interactive way of engaging with the history of our state. This sit… data.sa.gov.au https://data.sa.gov.au/data/dataset/53b4d7c2-a1b0-4b59-b7e0-28ee57db546e 1836-01-01 Current Historical Things https://data.history.sa.gov.au/sahistoryhub/thing GeoJSON #SA History Hub GEOJSON Endpoint http://data.history.sa.gov.au/sahistoryhub/{type} Replace {ty… 2015-07-02T16:06:51.936296     Creative Commons Attribution
842 SA History Hub History Trust of South Australia History Trust of South Australia 2015-07-02T05:59:59.012059 2017-06-27T02:08:18.983918 The SA History Hub website is an interactive way of engaging with the history of our state. This sit… data.sa.gov.au https://data.sa.gov.au/data/dataset/53b4d7c2-a1b0-4b59-b7e0-28ee57db546e 1836-01-01 Current Historical Organisations https://data.history.sa.gov.au/sahistoryhub/organisation GeoJSON #SA History Hub GEOJSON Endpoint http://data.history.sa.gov.au/sahistoryhub/{type} Replace {ty… 2015-07-02T16:08:28.752458     Creative Commons Attribution
843 SA History Hub History Trust of South Australia History Trust of South Australia 2015-07-02T05:59:59.012059 2017-06-27T02:08:18.983918 The SA History Hub website is an interactive way of engaging with the history of our state. This sit… data.sa.gov.au https://data.sa.gov.au/data/dataset/53b4d7c2-a1b0-4b59-b7e0-28ee57db546e 1836-01-01 Current Historical Events https://data.history.sa.gov.au/sahistoryhub/event GeoJSON #SA History Hub GEOJSON Endpoint http://data.history.sa.gov.au/sahistoryhub/{type} Replace {ty… 2015-07-02T16:09:11.644509     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]);