SPARQL Query Examples

From Bradford Collections

References and tutorials

Query examples

All datasets

PREFIX bcwd:  <https://bradford-collections.wikibase.cloud/entity/>
PREFIX bcwdt: <https://bradford-collections.wikibase.cloud/prop/direct/>

SELECT ?dataset ?datasetLabel ?datasetDescription
WHERE
{
  # Entity is 'instance of (P13)' 'Dataset (Q1)'
  ?dataset bcwdt:P13 bcwd:Q1.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". } 
}
# sort the results alphabetically in ascending order, based on entity labels that have been 
# converted to string (language agnostic) and uppercase (case insensitive).
ORDER BY ASC(UCASE(STR(?datasetLabel)))

Try it!


All datasets including the holder information

PREFIX bcwd:  <https://bradford-collections.wikibase.cloud/entity/>
PREFIX bcwdt: <https://bradford-collections.wikibase.cloud/prop/direct/>
PREFIX bcp:   <https://bradford-collections.wikibase.cloud/prop/>
PREFIX bcps:  <https://bradford-collections.wikibase.cloud/prop/statement/>

SELECT ?dataset ?datasetLabel ?datasetDescription ?heldByLabel ?heldByWebsite ?heldByEmail
WHERE
{ 
  # Entity is 'instance of (P13)' 'Dataset (Q1)'
  ?dataset bcwdt:P13 bcwd:Q1.
  
  # and optionally has 'held by (P28)' statement whose value may or may not 
  # have 'official website (P26)' and/or 'email address (P27)'
  OPTIONAL {
    ?dataset bcp:P28 ?heldByStatement.
    ?heldByStatement bcps:P28 ?heldBy.
    OPTIONAL { ?heldBy bcwdt:P26 ?heldByWebsite. }
    OPTIONAL { ?heldBy bcwdt:P27 ?heldByEmail. }
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". }
}
# sort the results alphabetically in ascending order, based on entity labels that have been 
# converted to string (language agnostic) and uppercase (case insensitive).
ORDER BY ASC(UCASE(STR(?datasetLabel)))

Try it!


Datasets with URLs

PREFIX bcwd:  <https://bradford-collections.wikibase.cloud/entity/>
PREFIX bcwdt: <https://bradford-collections.wikibase.cloud/prop/direct/>

SELECT ?dataset ?datasetLabel ?datasetDescription ?availableAtURL
WHERE
{
  # Entity is 'instance of (P13)' 'Dataset (Q1)' and has 'available at URL (P22)'
  ?dataset bcwdt:P13 bcwd:Q1;
        bcwdt:P22 ?availableAtURL.
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". } 
}
# sort the results alphabetically in ascending order, based on entity labels that have been 
# converted to string (language agnostic) and uppercase (case insensitive).
ORDER BY ASC(UCASE(STR(?datasetLabel)))

Try it!


Datasets with URLs to CSV files

PREFIX bcwd:  <https://bradford-collections.wikibase.cloud/entity/>
PREFIX bcwdt: <https://bradford-collections.wikibase.cloud/prop/direct/>

SELECT ?dataset ?datasetLabel ?datasetDescription ?availableAtURL
WHERE
{
  # Entity is 'instance of (P13)' 'Dataset (Q1)' and has 'available at URL (P22)'
  ?dataset bcwdt:P13 bcwd:Q1;
        bcwdt:P22 ?availableAtURL.
  
  # and the value of 'available at URL (P22)' ends with '.csv'
  FILTER (REGEX(STR(?availableAtURL), '\\.csv$')).

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". } 
}
# sort the results alphabetically in ascending order, based on entity labels that have been 
# converted to string (language agnostic) and uppercase (case insensitive).
ORDER BY ASC(UCASE(STR(?datasetLabel)))

Try it!


Datasets with Digital Cultural Heritage Datasheet

PREFIX bcwd:  <https://bradford-collections.wikibase.cloud/entity/>
PREFIX bcwdt: <https://bradford-collections.wikibase.cloud/prop/direct/>

SELECT ?dataset ?datasetLabel ?datasetDescription ?datasheetURL
WHERE
{
  # Entity is 'instance of (P13)' 'Dataset (Q1)' and has 'Digital Cultural Heritage Datasheet URL (P24)'
  ?dataset bcwdt:P13 bcwd:Q1;
        bcwdt:P24 ?datasheetURL.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". } 
}
# sort the results alphabetically in ascending order, based on entity labels that have been 
# converted to string (language agnostic) and uppercase (case insensitive).
ORDER BY ASC(UCASE(STR(?datasetLabel)))

Try it!


All datasets including copyright information

PREFIX bcwd:  <https://bradford-collections.wikibase.cloud/entity/>
PREFIX bcwdt: <https://bradford-collections.wikibase.cloud/prop/direct/>

SELECT ?dataset ?datasetLabel ?datasetDescription ?copyrightStatus
WHERE
{
  # Entity is 'instance of (P13)' 'Dataset (Q1)' and has 'Copyright status (P21)'
  ?dataset bcwdt:P13 bcwd:Q1;
        bcwdt:P21 ?copyrightStatus.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". } 
}
# sort the results alphabetically in ascending order, based on entity labels that have been 
# converted to string (language agnostic) and uppercase (case insensitive).
ORDER BY ASC(UCASE(STR(?datasetLabel)))

Try it!


All datasets including copyright licence

PREFIX bcwd:  <https://bradford-collections.wikibase.cloud/entity/>
PREFIX bcwdt: <https://bradford-collections.wikibase.cloud/prop/direct/>

SELECT ?dataset ?datasetLabel ?datasetDescription ?copyrightLicence
WHERE
{
  # Entity is 'instance of (P13)' 'Dataset (Q1)' and has 'Copyright licence (P20)'
  ?dataset bcwdt:P13 bcwd:Q1;
        bcwdt:P20 ?copyrightLicence.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". } 
}
# sort the results alphabetically in ascending order, based on entity labels that have been 
# converted to string (language agnostic) and uppercase (case insensitive).
ORDER BY ASC(UCASE(STR(?datasetLabel)))

Try it!

Retrieved from "https://bradford-collections.wikibase.cloud/w/index.php?title=SPARQL_Query_Examples&oldid=436"