data

Custom SQL query returning 10 rows (hide)

Query parameters

rowiddataset_titlepublisherauthordataset_issueddataset_modifieddataset_descriptionsourceinfo_urlstart_dateend_datefile_titledownload_urlformatfile_descriptionfile_createdfile_modifiedfile_sizelicence
672 South Australians of World War 1 Photographs Flickr set State Library of South Australia Andrew Piper 2013-05-21T09:06:33.212603 2020-02-24T02:07:29.790770 A selection (542) of portraits of soldiers. This set of portraits comes from our Chamberlain Collection and includes portraits of Soldiers prior to embarkation in studios and at various military camps in South Australia including Morphettville and Jubilee Oval. data.sa.gov.au https://data.sa.gov.au/data/dataset/0384a465-903c-4b2b-93ec-826acbe2c66b 1914-1916   Flickr API https://www.flickr.com/services/api/ API This dataset can be used in conjunction with the Flickr API. 2014-07-07T04:03:42.373664 2014-07-07T05:05:26.071019 20.0 Creative Commons Attribution
832 Passengers in History History Trust of South Australia History Trust of South Australia 2016-06-28T00:52:30.371967 2021-09-08T23:20:52.626089 _Passengers in History_ brings together two wonderful resources: <br /><br /> A passengers data base developed by the SA Maritime Museum, A list of ships’ logs and diaries, titled Log of Logs. <br /><br /> The passengers data base was produced by staff and volunteers at the South Australian Maritime Museum over 20 years. It includes entries for 328,000 passengers and 20,000 voyages to South Australia between 1836 and 1961. <br /><br /> This data set is presented as a search index that can expose most open data formats. data.sa.gov.au https://data.sa.gov.au/data/dataset/ffa75eb8-475a-460b-91d1-714f269016d5 1836-01-01 1961-01-01 Passengers in History Search Index https://data.history.sa.gov.au:8983/solr/passengers/select API #Passengers in History API Documentation# The Passengers in History data endpoint has been provided using an Apache Solr index (see https://lucene.apache.org/solr/) that uses a Drupal Solr 4.x schema (see https://www.drupal.org/project/search_api_solr). See [https://wiki.apache.org/solr/QueryParametersIndex](https://wiki.apache.org/solr/QueryParametersIndex) for more detail surrounding the query syntax. <br /> An example of a basic implementation can be viewed at https://data.history.sa.gov.au/gallery_pih.php?type=vessel&startindex=0 <br /> Replace the type parameter with any of the types listed below to return associated images eg. https://data.history.sa.gov.au/gallery_pih.php?type=passenger&startindex=0 <br /> The example code can be downloaded from https://data.history.sa.gov.au/gallery_pih.php.txt <br /> The open_data index contains 7 different types of content: <br /> * voyage * passenger * vessel * master * port * source * organisation <br/> Additionally, the photo index (photo_index) can be used to retrieve photos (specify the index using the index_id query parameter). <br/> A voyage is centric to most other content types contains references to passengers, vessels and ports. A join query should be used to get information about related content (see https://wiki.apache.org/solr/Join for information surrounding the query syntax for joins). The is_nid field is the unique identifier. <br/> The number of rows per query is limited to 999 so the start and rows query parameters would need to be used to iterate over the entire result set. <br/> There are many response formats available (see https://cwiki.apache.org/confluence/display/solr/Response+Writers). Just add the parameter 'wt' to the query and select the response format eg. json or csv. The default is xml. ##Examples## A typical workflow might be: <br/> Get the voyage/s that arrived in 1836: <br/> [https://data.history.sa.gov.au:8983/solr/passengers/select?q=index_id:open_data AND is_field_voyage_year:1836](https://data.history.sa.gov.au:8983/solr/passengers/select?q=index_id:open_data AND is_field_voyage_year:1836) <br/><br/> Use a join to get the passengers for one of the voyages (use the voyage is_nid field) <br/> [https://data.history.sa.gov.au:8983/solr/passengers/select?start=0&rows=50&q={!join from=im_field_passengers to=is_nid}index_id:open_data AND is_nid:944632](https://data.history.sa.gov.au:8983/solr/passengers/select?start=0&rows=50&q={!join from=im_field_passengers%20to=is_nid}index_id:open_data AND is_nid:944632) <br/><br/> Use a join to find the origin and destination of a particular voyage: <br/> [https://data.history.sa.gov.au:8983/solr/passengers/select?q={!join from=is_field_origin to=is_nid}index_id:open_data AND is_nid:944632](https://data.history.sa.gov.au:8983/solr/passengers/select?q={!join from=is_field_origin to=is_nid}index_id:open_data AND is_nid:944632) <br/> [https://data.history.sa.gov.au:8983/solr/passengers/select?q={!join from=is_field_destination to=is_nid}index_id:open_data AND is_nid:944632](https://data.history.sa.gov.au:8983/solr/passengers/select?q={!join from=is_field_destination to=is_nid}index_id:open_data AND is_nid:944632) <br/><br/> Use a join to find the vessel for the voyage: <br/> [https://data.history.sa.gov.au:8983/solr/passengers/select?q={!join from=is_field_vessel to=is_nid}index_id:open_data AND is_nid:944632](https://data.history.sa.gov.au:8983/solr/passengers/select?q={!join from=is_field_vessel to=is_nid}index_id:open_data AND is_nid:944632) <br/><br/> Use a join to find photos of the vessel (using the vessel is_nid): <br/> [https://data.history.sa.gov.au:8983/solr/passengers/select?q=index_id:photo_index AND im_file_usage_list:920026](https://data.history.sa.gov.au:8983/solr/passengers/select?q=index_id:photo_index AND im_file_usage_list:920026) <br/><br/> Use a join to find out where a vessel was built (using the vessel is_nid): <br/> [https://data.history.sa.gov.au:8983/solr/passengers/select?q={!join from=is_field_built_where to=is_nid}index_id:open_data AND is_nid:923958](https://data.history.sa.gov.au:8983/solr/passengers/select?q={!join from=is_field_built_where to=is_nid}index_id:open_data AND is_nid:923958) <br/><br/> Use a join to find the built by organisation for a particular vessel: <br/> [https://data.history.sa.gov.au:8983/solr/passengers/select?q={!join from=is_field_built_by to=is_nid}index_id:open_data AND is_nid:923958](https://data.history.sa.gov.au:8983/solr/passengers/select?q={!join%20from=is_field_built_by%20to=is_nid}index_id:open_data%20AND%20is_nid:923958) <br/><br/> Get organisation details (using the organisation is_nid): <br/> [https://data.history.sa.gov.au:8983/solr/passengers/select?q=index_id:open_data AND ss_type:organisation AND is_nid:916199](https://data.history.sa.gov.au:8983/solr/passengers/select?q=index_id:open_data%20AND%20ss_type:organisation%20AND%20is_nid:916199) <br/><br/> Or find all vessels built by the organisation (using the organisation is_nid): <br/> [https://data.history.sa.gov.au:8983/solr/passengers/select?q=index_id:open_data AND is_field_built_by:916199](https://data.history.sa.gov.au:8983/solr/passengers/select?q=index_id:open_data%20AND%20is_field_built_by:916199) <br/><br/> ##Other Useful Queries Find all photos that are attached to a passenger: <br/> data.history.sa.gov.au:8983/solr/passengers/select?q={!join from=is_nid to=im_file_usage_list}ss_type:(passenger OR image) <br/><br/> Or find all passengers that have a photo attached (the reverse): <br/> data.history.sa.gov.au:8983/solr/passengers/select?q={!join from=im_file_usage_list to=is_nid}ss_type:(passenger OR image) <br/><br/> All fields are searchable (see listing below). There are many search options using the Apache Solr query syntax. For instance to find all vessels that have the word ‘Adelaide’ in their tm_title field but not the word ‘port’: <br/> data.history.sa.gov.au:8983/solr/passengers/select?q=index_id:open_data AND ss_type:vessel AND tm_title:(adelaide -port) <br/> In this case ss_type is specifically set to be ‘vessel’. The – represents negation of the term. There are many more options – refer to a good blog here [https://yonik.com/solr/query-syntax/](https://yonik.com/solr/query-syntax/) <br/><br/> Facet search on the voyage destination for a date range between 1834 and 1836: <br/> https://data.history.sa.gov.au:8983/solr/passengers/select?rows=0&q={!join%20from=is_nid%20to=is_field_destination}index_id:open_data&fq=ds_field_depart_date:[1834-01-01T00:00:00Z%20TO%201836-12-31T12:59:59Z]&facet=on&facet.field=is_field_destination <br/> In this case use a port search by node to get the titles of the ports eg.(using the first facet): <br/> https://data.history.sa.gov.au:8983/solr/passengers/select?q=index_id:open_data%20AND%20is_nid:887339 <br/> The answer is most likely to be Sydney! <br/><br/> ##Content Type Fields## ###Passenger <br/> * is_nid * ss_type * tm_field_occupation * tm_field_surname * tm_field_firstname * is_field_age * is_arrival_year <br/> ###Voyage <br/> * is_nid * ss_type * ds_field_depart_date * is_field_destination * tm_field_master * is_field_origin * is_field_vessel * is_field_voyage_year * tm_title <br/> ###Vessel <br/> * is_nid * ss_type * tm_title * tm_field_services * im_field_sources * is_field_year_end * is_field_year_start * is_field_built_by * is_field_built_where * is_field_built_year * tm_field_demise * tm_field_rig * tm_field_dimensions * tm_field_tonnage <br/> ###Source <br/> * is_nid * ss_type * tm_title * tm_field_location * tm_field_reference <br/> ###Port <br/> * is_nid * ss_type * tm_title <br/> ###Organisation <br/> * is_nid * ss_type * tm_title <br/> ###Photos <br/> * is_fid: Unique ID for a file * tm_field_citation: Includes copyright information * tm_field_file_image_title_text: Image title * tm_field_location: Location of the image * tm_field_source: Source of the image * is_file_usage_count: Number of times this file is used in passengersinhistory.sa.gov.au * im_file_usage_list: List of content that uses this file * ss_url: Url to the file 2016-06-28T10:54:22.341773     Creative Commons Attribution
835 Bond Studios Glass Negative Collection History Trust of South Australia History Trust of South Australia 2017-06-27T01:57:42.716364 2017-07-28T07:37:33.822683 The collection comprises 2,558 glass negatives from Bond Studios in Port Adelaide. AE Bond was listed as a photographer in Commercial Road, Port Adelaide from 1901, although state collections include photographs credited to Bond that date back to 1867. In the 1930s the business shifted to St Vincent Street. The negatives are studio portraits of generations of Portonians. They capture individual rites of passage such as weddings, graduations, debuts, birthdays, and soldiers and sailors departing for war. Most of the negatives are labeled with surnames so it is possible to identify the subjects with further research. A collection description can be found here: http://maritime.history.sa.gov.au/collections/bond-studios-glass-negative-collection data.sa.gov.au https://data.sa.gov.au/data/dataset/94fb167a-65a2-491b-ab3e-c40f96351882 1867-01-01 1930-01-01 Bond Studios Glass Negative Collection https://data.history.sa.gov.au/bondstudio API Instructions are provided in the primary URL An example of a basic implementation can be viewed at http://data.history.sa.gov.au/gallery.php?collection=bondstudio&startindex=0 The example code can be downloaded from http://data.history.sa.gov.au/gallery.php.txt 2017-06-27T11:59:58.825973     Other (Open)
836 South Australian Government Photographic Collection History Trust of South Australia History Trust of South Australia 2017-06-23T06:53:25.398879 2017-07-28T07:36:38.007416 The collection broadly documents sixty-seven years of government activities, state celebrations, and the growth of industry, trade and townships between 1890 and 1957. The collection of 15,000 images includes 288 Frank Hurley images showcasing the state as part of its 1936 Centenary celebrations, as well as images of country shows and field days, educational institutions, hospitals and nursing, railway stations and infrastructure, shipping and ports, and the River Murray. The original glass plates are held by State Records of South Australia. The History Trust of South Australia holds the catalogue and digitised copy set of the collection. It is important to note that this is a historical collection and original information and photographic titles have been retained for research purposes in many instances. Some language used in the past by Government Departments may cause offence today but as a research collection we have maintained the original titles and language used to document this collection. data.sa.gov.au https://data.sa.gov.au/data/dataset/c5a3374b-bc28-41a5-9f7b-14d9b92e7350     South Australian Government Photographic Collection API https://data.history.sa.gov.au/sagpc API Refer to main page for information surrounding the end points. Meta data and images can be accessed through the API. An example of a basic implementation can be viewed at http://data.history.sa.gov.au/gallery.php?collection=sagpc&startindex=0 The example code can be downloaded from http://data.history.sa.gov.au/gallery.php.txt 2017-06-23T16:55:54.382324     Other (Open)
837 South Australian Government Photographic Collection History Trust of South Australia History Trust of South Australia 2017-06-23T06:53:25.398879 2017-07-28T07:36:38.007416 The collection broadly documents sixty-seven years of government activities, state celebrations, and the growth of industry, trade and townships between 1890 and 1957. The collection of 15,000 images includes 288 Frank Hurley images showcasing the state as part of its 1936 Centenary celebrations, as well as images of country shows and field days, educational institutions, hospitals and nursing, railway stations and infrastructure, shipping and ports, and the River Murray. The original glass plates are held by State Records of South Australia. The History Trust of South Australia holds the catalogue and digitised copy set of the collection. It is important to note that this is a historical collection and original information and photographic titles have been retained for research purposes in many instances. Some language used in the past by Government Departments may cause offence today but as a research collection we have maintained the original titles and language used to document this collection. data.sa.gov.au https://data.sa.gov.au/data/dataset/c5a3374b-bc28-41a5-9f7b-14d9b92e7350     SA Government Photographic Collection https://developers.sa.gov.au/docs/services/597822927515ee1398090666/operations/597a82807515ee0f204443b5 API Developer Portal. 2017-07-28T17:36:38.052331     Other (Open)
838 State History Collection (features) History Trust of South Australia History Trust of South Australia 2017-06-27T02:05:38.344832 2017-07-27T23:54:53.357526 The History Trust of South Australia is responsible for the State History Collection, a collection of objects relevant to the history of South Australia. Strengths of this collection reflect the collecting areas of our three museums: the Migration Museum, the South Australian Maritime Museum and the National Motor Museum. This dataset is a small feature selection of around 200 museum objects from across the organisation and will grow as we continue our digitisation program. Please note that the license selected on this dataset it is not a blanket CC-BY-NC as there are some items that have different and possible more restrictive copyright. These license conditions are specified in the metadata under the Copyright, License and Usage Restrictions fields. data.sa.gov.au https://data.sa.gov.au/data/dataset/a6457e37-6d36-4277-9318-dfe63ff28358 1836-01-01 1970-01-01 State History Collection https://data.history.sa.gov.au/collection API Instructions are provided in the primary URL An example of a basic implementation can be viewed at http://data.history.sa.gov.au/gallery.php?collection=collection&startindex=0 The example code can be downloaded from http://data.history.sa.gov.au/gallery.php.txt 2017-06-27T12:06:29.400254     Creative Commons Attribution-NonCommercial
839 Community History Live Stream History Trust of South Australia History Trust of South Australia 2015-05-15T01:26:37.366511 2017-06-27T02:08:43.727429 The community history website is a place for community organisations, historical groups and individuals to come together to share their interests in and explore South Australia's community history. This dataset provides access to organisations, events, news and blogs that are displayed on the website. data.sa.gov.au https://data.sa.gov.au/data/dataset/2ce2ab30-d17f-4902-b344-314e4b34538a 2011-04-01 2015-05-31 Community History Live Stream https://data.history.sa.gov.au/communityhistory/ API **Community History Endpoints** **Organisations** http://data.history.sa.gov.au/communityhistory/organisations **News** http://data.history.sa.gov.au/communityhistory/news **Events** http://data.history.sa.gov.au/communityhistory/events **Blogs** http://data.history.sa.gov.au/communityhistory/blogs **Article Detail** The nid field on each of the items (listed using any of the above endpoints) can be used to get specific detail using the following endpoint: http://data.history.sa.gov.au/communityhistory/{nid} Replace {nid} with the nid obtained from one of the above endpoints. **Files** The nid field on each of the events (listed using any of the above endpoints) can be used to get associated files (including base64 values) using the following endpoint: http://data.history.sa.gov.au/communityhistory/{nid}/files Replace {nid} with the nid obtained from one of the above endpoints. **Taxonomy** http://data.history.sa.gov.au/communityhistory/taxonomy/{id} Replace {id} with the taxonomy term id (represented by target_id throughout content) 2015-05-15T11:33:00.199640     Creative Commons Attribution
845 History Festival Archive History Trust of South Australia History Trust of South Australia 2015-05-14T07:15:48.169739 2017-06-27T02:07:34.579520 The History Festival is held every year in May. This dataset contains an archive of festival events for 2013, 2014, 2015 and 2016. data.sa.gov.au https://data.sa.gov.au/data/dataset/8606923a-8c21-4a2a-b31b-925f6fee4616 2013-05-01 2015-05-31 History Festival Events https://data.history.sa.gov.au/abouttime/ API **History Festival Endpoints** **Events** http://data.history.sa.gov.au/abouttime/events/{year} Replace {year} with 2013, 2014 or 2015 **Event Detail** The nid field on each of the events (listed using the 'Events' endpoint) can be used to get event specific detail using the following endpoint: http://data.history.sa.gov.au/abouttime/event/{year}/{nid} Replace {year} with 2013, 2014, 2015 or 2016 Replace {nid} with the nid obtained from one of the events listing. **Event Images** The nid field on each of the events (listed using the 'Events' endpoint) can be used to get event images (including base64 values) using the following endpoint: http://data.history.sa.gov.au/abouttime/event/{year}/{nid}/files Replace {year} with 2013, 2014, 2015 or 2016 Replace {nid} with the nid obtained from one of the events listing. 2015-05-14T17:18:33.373635     Creative Commons Attribution
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 by the Library. For the WWI Centenary Commemoration we have committed to making them accessible to all through digitisation and transcription. 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
943 OpenGov NSW API NSW State Archives   2013-05-28T05:04:20.514798 2015-02-03T06:33:14.130405 A repository of information published by NSW Government agencies, including Annual Reports and open access information released under the Government Information (Public Access) Act 2009 (GIPA Act). data.nsw.gov.au https://data.nsw.gov.au/data/dataset/e2c36616-36db-4bb3-a907-87db836481f0     OpenGov NSW API https://www.opengov.nsw.gov.au/api API OpenGov NSW data and functionality are available via an open web API. This service provides additional options for agencies wishing to integrate OpenGov NSW with their own websites. It also means that external developers, and members of the public more broadly, can easily extract and use OpenGov NSW data. For more information, visit: [https://www.opengov.nsw.gov.au/api](https://www.opengov.nsw.gov.au/api) 2013-05-28T01:05:30.921458     Creative Commons Attribution