Open main menu

User:YULdigitalpreservation/lovedata2018

This page is to organize my SPARQL queries for #lovedata2018Edit

MondayEdit

mentions & hashtagsEdit

@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 paperEdit

The following query uses these:

TuesdayEdit

hashtags & mentionsEdit

https://twitter.com/theNASciences

  1. womeninscience
  2. lovedata18

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

The following query uses these:

  • Properties: member of (P463)    , sex or gender (P21)    
    1 SELECT ?person ?personLabel 
    2 
    3 WHERE {
    4   ?person wdt:P463 wd:Q270794.
    5   ?person wdt:P21 wd:Q6581072;
    6 
    7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    8   }
    

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

The following query uses these:


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 membersEdit

The following query uses these:

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

WednesdayEdit

hashtags & mentionsEdit

  1. womeninscience
  2. lovedata18

Return a list of science awards honoring womenEdit

The following query uses these:

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

The following query uses these:

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

The following query uses these:

  • Properties: award received (P166)    , image (P18)    
     1 SELECT ?person ?personLabel ?image  WHERE {
     2   
     3   {?person wdt:P166 wd:Q566886}
     4    UNION {?person wdt:P166 wd:Q1354618.}
     5    UNION {?person wdt:P166 wd:Q55200.}
     6    UNION {?person wdt:P166 wd:Q784097.}
     7    UNION {?person wdt:P166 wd:Q1455366.}
     8    UNION {?person wdt:P166 wd:Q5424476.}
     9    UNION {?person wdt:P166 wd:Q6759784.}
    10    UNION {?person wdt:P166 wd:Q6761225.}
    11    UNION {?person wdt:P166 wd:Q7158133.}
    12   UNION {?person wdt:P166 wd:Q7950590.}
    13   UNION {?person wdt:P166 wd:Q7980447.}
    14   UNION {?person wdt:P166 wd:Q13512515.}
    15   UNION {?person wdt:P166 wd:Q30593379.}
    16   UNION {?person wdt:P166 wd:Q1996511.}
    17   UNION {?person wdt:P166 wd:Q2177698.}
    18   UNION {?person wdt:P166 wd:Q4693035.}
    19   UNION {?person wdt:P166 wd:Q6759993.}
    20   UNION {?person wdt:P166 wd:Q17005505.}
    21   OPTIONAL {?person wdt:P18 ?image.}
    22  SERVICE wikibase:label {
    23     bd:serviceParam wikibase:language "en" .
    24 }
    25   }
    

Same with occupation addedEdit

The following query uses these:

  • Properties: award received (P166)    , image (P18)    , occupation (P106)    
     1 SELECT ?person ?personLabel ?occupationLabel ?image  WHERE {
     2   
     3   {?person wdt:P166 wd:Q566886}
     4    UNION {?person wdt:P166 wd:Q1354618.}
     5    UNION {?person wdt:P166 wd:Q55200.}
     6    UNION {?person wdt:P166 wd:Q784097.}
     7    UNION {?person wdt:P166 wd:Q1455366.}
     8    UNION {?person wdt:P166 wd:Q5424476.}
     9    UNION {?person wdt:P166 wd:Q6759784.}
    10    UNION {?person wdt:P166 wd:Q6761225.}
    11    UNION {?person wdt:P166 wd:Q7158133.}
    12   UNION {?person wdt:P166 wd:Q7950590.}
    13   UNION {?person wdt:P166 wd:Q7980447.}
    14   UNION {?person wdt:P166 wd:Q13512515.}
    15   UNION {?person wdt:P166 wd:Q30593379.}
    16   UNION {?person wdt:P166 wd:Q1996511.}
    17   UNION {?person wdt:P166 wd:Q2177698.}
    18   UNION {?person wdt:P166 wd:Q4693035.}
    19   UNION {?person wdt:P166 wd:Q6759993.}
    20   UNION {?person wdt:P166 wd:Q17005505.}
    21   OPTIONAL {?person wdt:P18 ?image.}
    22   OPTIONAL {?person wdt:P106 ?occupation.}
    23  SERVICE wikibase:label {
    24     bd:serviceParam wikibase:language "en" .
    25 }
    26   }
    

ThursdayEdit

  1. datacitation
  2. researchdata

Return a list of places to look for dataEdit

The following query uses these:

  • Properties: instance of (P31)    , subclass of (P279)    
     1 SELECT DISTINCT ?store ?storeLabel
     2 
     3 WHERE {
     4   
     5   {?store wdt:P31/wdt:P279* wd:Q5227308 }
     6   UNION {?store wdt:P31/wdt:P279* wd:Q22692845.}
     7   UNION {?store wdt:P31/wdt:P279* wd:Q5281480.}
     8   UNION {?store wdt:P31/wdt:P279* wd:Q212805.}
     9   UNION {?store wdt:P31/wdt:P279* wd:Q5570651.}     
    10   UNION {?store wdt:P31/wdt:P279* wd:Q7689673.} 
    11   UNION {?store wdt:P31/wdt:P279* wd:Q4117139.}  
    12   SERVICE wikibase:label {
    13 		bd:serviceParam wikibase:language "en" .
    14     
    15 }
    16   }
    

FridayEdit

hashtags & mentionsEdit

  1. highered
  2. lovedata18

@oberlincollege

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

The following query uses these:

  • Properties: significant event (P793)    , image (P18)    , start time (P580)    
     1 #defaultView:Timeline
     2 
     3 SELECT ?institution ?institutionLabel ?date ?image
     4 
     5 WHERE 
     6 
     7 {
     8 
     9   ?institution wdt:P793 wd:Q541394;
    10 
    11                  p:P793 [pq:P580 ?date].
    12 
    13   OPTIONAL {?institution wdt:P18 ?image.}
    14 
    15   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    16 
    17   FILTER(YEAR(?date) < 1900).
    18 
    19 }