Juliebirkholz

SPARQL queries for RDF network analysis tool paper

WeChanged female authors and their kinship (siblings, father, mother, unmarried partner, spouse, children)

The following query uses these:

• Items: editor (Q1607826)   , female (Q6581072)   

• Properties: occupation (P106)   , WeChangEd ID (P7947)   , sex or gender (P21)   , date of birth (P569)   , date of death (P570)   , sibling (P3373)   , spouse (P26)   , unmarried partner (P451)   , father (P22)   , mother (P25)   , child (P40)   

  SELECT DISTINCT ?item ?o ?itemLabel  ?sibling ?spouse ?partner ?father ?mother ?child
  WHERE
  
  {
  # find occupation editors
  ?item wdt:P106 wd:Q1607826.
  ?item wdt:P7947 ?o .
  
  # that are female
  ?item wdt:P21 wd:Q6581072.
   
  # that have a birth and death date
  ?item wdt:P569 ?birthDate.
  ?item wdt:P570 ?deathDate .
    
  # with kinship: sibling
  OPTIONAL { ?item wdt:P3373 ?sibling .}
  # with kinship: spouse
  OPTIONAL { ?item wdt:P26 ?spouse .}
  # with kinship: unmarried partner
  OPTIONAL { ?item wdt:P451 ?partner .}
  
  # with kinship: father
  OPTIONAL { ?item wdt:P22 ?father .}
  # with kinship: mother
  OPTIONAL { ?item wdt:P25 ?mother .}
  # with kinship: child
  OPTIONAL { ?item wdt:P40 ?child .}
  
  # only active in the 19th century
  FILTER ( ?birthDate >= "1800-01-01T00:00:00Z"^^xsd:dateTime && ?deathDate <= "1898-12-31T00:00:00Z"^^xsd:dateTime )
   
  # labels
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  
  } ORDER BY ?birthDate ?deathDate
  

Try it!

SPARQL queries related to WeChangEd (Q86999151)

Items that have WeChangEd Id and Commons Category (meaning they will have IIIF images in your stories app)

The following query uses these:

• Properties: WeChangEd ID (P7947)   , Commons category (P373)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P7947 ?id.
    ?item wdt:P373 ?commons.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Items that have WeChangEd Id and Europeana ID

The following query uses these:

• Properties: WeChangEd ID (P7947)   , Europeana entity (P7704)   

  SELECT ?item ?itemLabel ?wechanged ?europeana
  WHERE 
  {
    ?item wdt:P7947 ?wechanged.
    ?item wdt:P7704 ?europeana.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Items that have WeChangEd Id and ODNB ID

The following query uses these:

• Properties: WeChangEd ID (P7947)   , Oxford Dictionary of National Biography ID (P1415)   

  SELECT ?item ?itemLabel ?wechanged ?odnb
  WHERE 
  {
    ?item wdt:P7947 ?wechanged.
    ?item wdt:P1415 ?odnb.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Items that have WeChangEd Id and country of citizenship is Russia

The following query uses these:

• Items: Russian Empire (Q34266)   

• Properties: WeChangEd ID (P7947)   , date of death (P570)   , country of citizenship (P27)   

  SELECT ?item ?itemLabel ?death WHERE {
    ?item wdt:P7947 ?id;
      wdt:P570 ?death;
      wdt:P27 wd:Q34266.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

SPARQL queries related to WeChangEd (Q86999151)

Items that have WeChangEd Id and Commons Category (meaning they will have IIIF images in your stories app)

The following query uses these:

• Properties: WeChangEd ID (P7947)   , Commons category (P373)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P7947 ?id.
    ?item wdt:P373 ?commons.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Items that have WeChangEd Id and Europeana ID

The following query uses these:

• Properties: WeChangEd ID (P7947)   , Europeana entity (P7704)   

  SELECT ?item ?itemLabel ?wechanged ?europeana
  WHERE 
  {
    ?item wdt:P7947 ?wechanged.
    ?item wdt:P7704 ?europeana.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Items that have WeChangEd Id and ODNB ID

The following query uses these:

• Properties: WeChangEd ID (P7947)   , Oxford Dictionary of National Biography ID (P1415)   

  SELECT ?item ?itemLabel ?wechanged ?odnb
  WHERE 
  {
    ?item wdt:P7947 ?wechanged.
    ?item wdt:P1415 ?odnb.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Items that have WeChangEd Id and country of citizenship is Russia

The following query uses these:

• Items: Russian Empire (Q34266)   

• Properties: WeChangEd ID (P7947)   , date of death (P570)   , country of citizenship (P27)   

  SELECT ?item ?itemLabel ?death WHERE {
    ?item wdt:P7947 ?id;
      wdt:P570 ?death;
      wdt:P27 wd:Q34266.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Items that have WeChangEd id and ODIS

SELECT DISTINCT ?item ?itemLabel WHERE {

 ?item wdt:P7947 ?wechanged.
 ?item wdt:P2372 ?odis.
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}