User:YULdigitalpreservation/lovedata2018

This page is to organize my SPARQL queries for #lovedata2018

Monday

mentions & hashtags

@wikicite

1. datacitation
2. lovedata18

A query to demonstrate how Wikidata can be used to describe scientific articles and datasets.

Return a list of scientific articles that have a Wikidata statment indicating the URL of an external data set for the paper

The following query uses these:

• Items: scholarly article (Q13442814)   

• Properties: instance of (P31)   , external data available at URL (P1325)   

  SELECT ?article ?articleLabel ?urlLabel
  WHERE {
    ?article wdt:P31 wd:Q13442814 .
    ?article wdt:P1325 ?url.       
    SERVICE wikibase:label {
  		bd:serviceParam wikibase:language "en" .
  }
    }
  

Try it!

Tuesday

hashtags & mentions

https://twitter.com/theNASciences

1. womeninscience
2. lovedata18

Return a list of of women who have been elected to the National Academy of Sciences

The following query uses these:

• Items: National Academy of Sciences (Q270794)   , female (Q6581072)   

• Properties: member of (P463)   , sex or gender (P21)   

  SELECT ?person ?personLabel 
  
  WHERE {
    ?person wdt:P463 wd:Q270794.
    ?person wdt:P21 wd:Q6581072;
  
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    }
  

Try it!

Return an image grid of of women who have been elected to the National Academy of Sciences

The following query uses these:

• Items: National Academy of Sciences (Q270794)   , female (Q6581072)   , Doctor of Philosophy (Q752297)   

• Properties: member of (P463)   , sex or gender (P21)   , image (P18)   , educated at (P69)   , academic degree (P512)   

  SELECT ?personLabel ?schoolLabel  ?image
  WHERE {
    ?person wdt:P463 wd:Q270794.
    ?person wdt:P21 wd:Q6581072;
            p:P69 [ps:P69 ?school; pq:P512 wd:Q752297].
    OPTIONAL {?person wdt:P18 ?image.}
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    }
  

Try it!

Return a dimensions grid of women who have been elected to the National Academy of Sciences, the institution where they earned their PhD, and other organizations of which they are members

The following query uses these:

• Items: National Academy of Sciences (Q270794)   , female (Q6581072)   , Doctor of Philosophy (Q752297)   

• Properties: member of (P463)   , sex or gender (P21)   , educated at (P69)   , academic degree (P512)   

  #defaultView:Dimensions
  SELECT ?personLabel ?schoolLabel ?memLabel
  
  WHERE {
    ?person wdt:P463 wd:Q270794.
    ?person wdt:P21 wd:Q6581072;
            p:P69 [ps:P69 ?school; pq:P512 wd:Q752297].
    ?person wdt:P463 ?mem.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    }
  

Try it!

p:P463 [ps:P463 wd:Q270794; pq:P580 ?year].

Wednesday

hashtags & mentions

1. womeninscience
2. lovedata18

Return a list of science awards honoring women

The following query uses these:

• Items: Category:Awards honoring women (Q8281358)   

• Properties: topic's main category (P910)   , conferred by (P1027)   

  SELECT ?item ?itemLabel ?sponsorLabel  WHERE {
    ?item wdt:P910 wd:Q8281358.
    OPTIONAL {?item wdt:P1027 ?sponsor.}
    
   SERVICE wikibase:label {
      bd:serviceParam wikibase:language "en" .
  }
    }
  

Try it!

Return a list of women who have won a science award for women and the org the award was conferred by

The following query uses these:

• Items: Category:Awards honoring women (Q8281358)   

• Properties: topic's main category (P910)   , award received (P166)   , conferred by (P1027)   

  SELECT ?person ?personLabel ?awardLabel ?sponsorLabel  
  
  WHERE {
    
    ?award wdt:P910 wd:Q8281358.
    ?person wdt:P166 ?award.
    ?award wdt:P1027 ?sponsor.
    
   SERVICE wikibase:label {
      bd:serviceParam wikibase:language "en" .
  }
    }
  

Try it!

Return a list of women who have won a science award for women

The following query uses these:

• Items: Annie Jump Cannon Award in Astronomy (Q566886)   , Krieger–Nelson Prize (Q1354618)   , Women in Technology International (Q55200)   , Rachel Carson Prize (Q784097)   , Rosalind Franklin Award (Q1455366)   , FASEB Excellence in Science Award (Q5424476)   , Margaret Oakley Dayhoff Award (Q6759784)   , Maria Goeppert-Mayer Award (Q6761225)   , Pearl Meister Greengard Prize (Q7158133)   , WICB Junior and Senior Awards (Q7950590)   , Weizmann Women & Science Award (Q7980447)   , Anita Borg Institute Women of Vision Awards (Q13512515)   , Sharon Keillor Award for Women in Engineering Education (Q30593379)   , Garvan–Olin Medal (Q1996511)   , Ruth Lyttle Satter Prize in Mathematics (Q2177698)   , Agnes Fay Morgan Research Award (Q4693035)   , Margaret W. Rossiter History of Women in Science Prize (Q6759993)   , Elizabeth Blackwell Medal (Q17005505)   

• Properties: award received (P166)   , image (P18)   

  SELECT ?person ?personLabel ?image  WHERE {
    
    {?person wdt:P166 wd:Q566886}
     UNION {?person wdt:P166 wd:Q1354618.}
     UNION {?person wdt:P166 wd:Q55200.}
     UNION {?person wdt:P166 wd:Q784097.}
     UNION {?person wdt:P166 wd:Q1455366.}
     UNION {?person wdt:P166 wd:Q5424476.}
     UNION {?person wdt:P166 wd:Q6759784.}
     UNION {?person wdt:P166 wd:Q6761225.}
     UNION {?person wdt:P166 wd:Q7158133.}
    UNION {?person wdt:P166 wd:Q7950590.}
    UNION {?person wdt:P166 wd:Q7980447.}
    UNION {?person wdt:P166 wd:Q13512515.}
    UNION {?person wdt:P166 wd:Q30593379.}
    UNION {?person wdt:P166 wd:Q1996511.}
    UNION {?person wdt:P166 wd:Q2177698.}
    UNION {?person wdt:P166 wd:Q4693035.}
    UNION {?person wdt:P166 wd:Q6759993.}
    UNION {?person wdt:P166 wd:Q17005505.}
    OPTIONAL {?person wdt:P18 ?image.}
   SERVICE wikibase:label {
      bd:serviceParam wikibase:language "en" .
  }
    }
  

Try it!

Same with occupation added

The following query uses these:

• Items: Annie Jump Cannon Award in Astronomy (Q566886)   , Krieger–Nelson Prize (Q1354618)   , Women in Technology International (Q55200)   , Rachel Carson Prize (Q784097)   , Rosalind Franklin Award (Q1455366)   , FASEB Excellence in Science Award (Q5424476)   , Margaret Oakley Dayhoff Award (Q6759784)   , Maria Goeppert-Mayer Award (Q6761225)   , Pearl Meister Greengard Prize (Q7158133)   , WICB Junior and Senior Awards (Q7950590)   , Weizmann Women & Science Award (Q7980447)   , Anita Borg Institute Women of Vision Awards (Q13512515)   , Sharon Keillor Award for Women in Engineering Education (Q30593379)   , Garvan–Olin Medal (Q1996511)   , Ruth Lyttle Satter Prize in Mathematics (Q2177698)   , Agnes Fay Morgan Research Award (Q4693035)   , Margaret W. Rossiter History of Women in Science Prize (Q6759993)   , Elizabeth Blackwell Medal (Q17005505)   

• Properties: award received (P166)   , image (P18)   , occupation (P106)   

  SELECT ?person ?personLabel ?occupationLabel ?image  WHERE {
    
    {?person wdt:P166 wd:Q566886}
     UNION {?person wdt:P166 wd:Q1354618.}
     UNION {?person wdt:P166 wd:Q55200.}
     UNION {?person wdt:P166 wd:Q784097.}
     UNION {?person wdt:P166 wd:Q1455366.}
     UNION {?person wdt:P166 wd:Q5424476.}
     UNION {?person wdt:P166 wd:Q6759784.}
     UNION {?person wdt:P166 wd:Q6761225.}
     UNION {?person wdt:P166 wd:Q7158133.}
    UNION {?person wdt:P166 wd:Q7950590.}
    UNION {?person wdt:P166 wd:Q7980447.}
    UNION {?person wdt:P166 wd:Q13512515.}
    UNION {?person wdt:P166 wd:Q30593379.}
    UNION {?person wdt:P166 wd:Q1996511.}
    UNION {?person wdt:P166 wd:Q2177698.}
    UNION {?person wdt:P166 wd:Q4693035.}
    UNION {?person wdt:P166 wd:Q6759993.}
    UNION {?person wdt:P166 wd:Q17005505.}
    OPTIONAL {?person wdt:P18 ?image.}
    OPTIONAL {?person wdt:P106 ?occupation.}
   SERVICE wikibase:label {
      bd:serviceParam wikibase:language "en" .
  }
    }
  

Try it!

Thursday

1. datacitation
2. researchdata

Return a list of places to look for data

The following query uses these:

• Items: data library (Q5227308)   , terminology registry (Q22692845)   , disciplinary repository (Q5281480)   , digital library (Q212805)   , global species database (Q5570651)   , taxonomic database (Q7689673)   , biological database (Q4117139)   

• Properties: instance of (P31)   , subclass of (P279)   

  SELECT DISTINCT ?store ?storeLabel
  
  WHERE {
    
    {?store wdt:P31/wdt:P279* wd:Q5227308 }
    UNION {?store wdt:P31/wdt:P279* wd:Q22692845.}
    UNION {?store wdt:P31/wdt:P279* wd:Q5281480.}
    UNION {?store wdt:P31/wdt:P279* wd:Q212805.}
    UNION {?store wdt:P31/wdt:P279* wd:Q5570651.}     
    UNION {?store wdt:P31/wdt:P279* wd:Q7689673.} 
    UNION {?store wdt:P31/wdt:P279* wd:Q4117139.}  
    SERVICE wikibase:label {
  		bd:serviceParam wikibase:language "en" .
      
  }
    }
  

Try it!

Friday

hashtags & mentions

1. highered
2. lovedata18

@oberlincollege

Return a timeline of educational institutions in the united states and the date they began co-education (before 1900)

The following query uses these:

• Items: mixed-sex education (Q541394)   

• Properties: significant event (P793)   , image (P18)   , start time (P580)   

  #defaultView:Timeline
  
  SELECT ?institution ?institutionLabel ?date ?image
  
  WHERE 
  
  {
  
    ?institution wdt:P793 wd:Q541394;
  
                   p:P793 [pq:P580 ?date].
  
    OPTIONAL {?institution wdt:P18 ?image.}
  
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  
    FILTER(YEAR(?date) < 1900).
  
  }
  

Try it!