query-c0139573f6165011d179645789a7934f

added before 2019-02

Shows people raised in the public domain "life + 50 years".

SELECT ?item ?itemLabel ?genderLabel (GROUP_CONCAT(DISTINCT ?occupationLabel; SEPARATOR=", ") AS ?occupations) (GROUP_CONCAT(DISTINCT ?countryLabel; SEPARATOR=", ") AS ?countries) ?death ?articles { VALUES ?target_country { wd:Q16 wd:Q142 wd:Q39 wd:Q31 wd:Q30 } . #countries: Canada, France, Switzerland, Belgium, USA. Removing this line to get worldwide may cause a query timeout. VALUES ?occ { wd:Q2500638 wd:Q20826540 wd:Q215627 } . #occupation: creator, erudite, person. These 3 occupations will also look for subclasses. Example: Alan Turing is a cryptographer, a subclass of cryptologist, a subclass of mathematician, a subclass of scientist, a subclass of erudite. ?item wdt:P31 wd:Q5; wdt:P21 ?gender; wdt:P27 ?target_country; wdt:P27 ?country; wdt:P106/wdt:P279* ?occ ; wdt:P106 ?occupation; wikibase:sitelinks ?articles . #Service to count the number of articles in Wikipedia language versions. The higher the number, the greater the chances that the person is very notorious. ?item wdt:P570 ?death . hint:Prior hint:rangeSafe true . FILTER( ?death >= "1969-01-01T00:00:00"^^xsd:dateTime && ?death < "1970-01-01T00:00:00"^^xsd:dateTime ) #death: public domain "life+50 years". Change both years to get a list in different legislation. Example for USA: life+70 years SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,en" . #Service to retrieve the labels of items, in order of language. Example: if the label does not exist in French, the service will take the English label ?item rdfs:label ?itemLabel . ?gender rdfs:label ?genderLabel . ?occupation rdfs:label ?occupationLabel . ?country rdfs:label ?countryLabel . } . } GROUP BY ?item ?itemLabel ?genderLabel ?death ?articles ORDER BY DESC (?articles) #Order by the number of articles in Wikipedia language versions. The most notorious people will be at the top of the list. added before 2019-02

Shows people raised in the public domain "life + 50 years".

Use at

https://query.wikidata.org/sparql

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
#added before 2019-02

#Shows people raised in the public domain "life + 50 years".
SELECT ?item ?itemLabel ?genderLabel (GROUP_CONCAT(DISTINCT ?occupationLabel; SEPARATOR=", ") AS ?occupations) (GROUP_CONCAT(DISTINCT ?countryLabel; SEPARATOR=", ") AS ?countries) ?death ?articles {
  VALUES ?target_country { wd:Q16 wd:Q142 wd:Q39 wd:Q31 wd:Q30 } . #countries: Canada, France, Switzerland, Belgium, USA. Removing this line to get worldwide may cause a query timeout.
  VALUES ?occ { wd:Q2500638 wd:Q20826540 wd:Q215627 } . #occupation: creator, erudite, person. These 3 occupations will also look for subclasses. Example: Alan Turing is a cryptographer, a subclass of cryptologist, a subclass of mathematician, a subclass of scientist, a subclass of erudite.
   ?item wdt:P31 wd:Q5;
               wdt:P21 ?gender;
               wdt:P27 ?target_country;
               wdt:P27 ?country;
               wdt:P106/wdt:P279* ?occ ;
               wdt:P106 ?occupation;
               wikibase:sitelinks ?articles . #Service to count the number of articles in Wikipedia language versions. The higher the number, the greater the chances that the person is very notorious.
   ?item wdt:P570 ?death . 
   FILTER( ?death >= "1969-01-01T00:00:00"^^xsd:dateTime && ?death < "1970-01-01T00:00:00"^^xsd:dateTime ) #death: public domain "life+50 years". Change both years to get a list in different legislation. Example for USA: life+70 years
   SERVICE wikibase:label {
       bd:serviceParam wikibase:language "fr,en" . #Service to retrieve the labels of items, in order of language. Example: if the label does not exist in French, the service will take the English label
       ?item rdfs:label ?itemLabel .
       ?gender rdfs:label ?genderLabel .
       ?occupation rdfs:label ?occupationLabel .
       ?country rdfs:label ?countryLabel .
   } .
} GROUP BY ?item ?itemLabel ?genderLabel ?death ?articles ORDER BY DESC (?articles) #Order by the number of articles in Wikipedia language versions. The most notorious people will be at the top of the list.

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?articles"):::projected v14("?countries") v7("?country") v12("?countryLabel"):::projected v2("?death"):::projected v6("?gender") v10("?genderLabel"):::projected v5("?item"):::projected v9("?itemLabel"):::projected v4("?occ") v8("?occupation") v11("?occupationLabel"):::projected v13("?occupations") v3("?target_country") a1((" ")) c12(["bd:serviceParam"]):::iri c4(["wd:Q5"]):::iri c14(["fr,en"]):::literal f0[["?death >= '1969-01-01T00:00:00^^xsd:dateTime'?death < '1970-01-01T00:00:00^^xsd:dateTime'"]] f0 --> v2 bind1[/VALUES ?target_country/] bind1-->v3 bind10(["wd:Q16"]) bind10 --> bind1 bind11(["wd:Q142"]) bind11 --> bind1 bind12(["wd:Q39"]) bind12 --> bind1 bind13(["wd:Q31"]) bind13 --> bind1 bind14(["wd:Q30"]) bind14 --> bind1 bind2[/VALUES ?occ/] bind2-->v4 bind20(["wd:Q2500638"]) bind20 --> bind2 bind21(["wd:Q20826540"]) bind21 --> bind2 bind22(["wd:Q215627"]) bind22 --> bind2 v5 --"wdt:P31"--> c4 v5 --"wdt:P21"--> v6 v5 --"wdt:P27"--> v3 v5 --"wdt:P27"--> v7 v5 --"wdt:P106"--> a1 a1 --"wdt:P279"--> v4 v5 --"wdt:P106"--> v8 v5 --"wikibase:sitelinks"--> v1 v5 --"wdt:P570"--> v2 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c12 --"wikibase:language"--> c14 v5 --"rdfs:label"--> v9 v6 --"rdfs:label"--> v10 v8 --"rdfs:label"--> v11 v7 --"rdfs:label"--> v12 end bind5[/"?occupationLabel"/] v11 --o bind5 bind5 --as--o v13 bind6[/"?countryLabel"/] v12 --o bind6 bind6 --as--o v14