User:YULdigitalpreservation/ScienceStories/NAS

From Wikidata
Jump to navigation Jump to search

The National Academy of Sciences[edit]

SPARQL Queries[edit]

These are queries written for the Wikidata Query Service.

Members of the National Academy of Science[edit]

The following query uses these:

  • Properties: member of (P463) View with Reasonator View with SQID
    1 SELECT ?person ?personLabel WHERE {
    2   ?person wdt:P463 wd:Q270794.
    3   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    4 }
    

Members of the National Academy of Science by gender[edit]

The following query uses these:

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

People who have P21 female and are members of National Academy of Sciences[edit]

The following query uses these:

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

People who have P21 female and are members of National Academy of Sciences who have a Ted Talk speaker ID[edit]

The following query uses these:

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

People who have P21 female and are members of National Academy of Sciences and occupations[edit]

The following query uses these:

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

People who have P21 female and are members of National Academy of Sciences and the institution from which they got their PhD[edit]

The following query uses these:

Dimensions chart of all other organizations to which they have memberships[edit]

The following query uses these:

  • Properties: member of (P463) View with Reasonator View with SQID, sex or gender (P21) View with Reasonator View with SQID, educated at (P69) View with Reasonator View with SQID, academic degree (P512) View with Reasonator View with SQID
     1 #defaultView:Dimensions
     2 SELECT ?personLabel ?schoolLabel ?memLabel
     3 
     4 WHERE {
     5   ?person wdt:P463 wd:Q270794.
     6   ?person wdt:P21 wd:Q6581072;
     7           p:P69 [ps:P69 ?school; pq:P512 wd:Q752297].
     8   ?person wdt:P463 ?mem.
     9   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    10   }
    

People who have P21 female and are members of National Academy of Sciences where they got their PhD and the year they were elected to NAS[edit]

The following query uses these:

People who have P21 female and the year they were elected to the NAS[edit]

The following query uses these:

  • Properties: sex or gender (P21) View with Reasonator View with SQID, member of (P463) View with Reasonator View with SQID, start time (P580) View with Reasonator View with SQID
    1 SELECT ?person ?personLabel ?year
    2 
    3 WHERE {
    4   ?person wdt:P21 wd:Q6581072.
    5   ?person wdt:P463 wd:Q270794;
    6           p:P463 [ps:P463 wd:Q270794; pq:P580 ?year].
    7 
    8   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    9 }
    

Women educated at Yale who are members of NAS and the year they were elected[edit]

The following query uses these:

Average age of women when they get elected to NAS vs. average age of men when they are elected to the NAS[edit]