query-cee9ccb32607a3aecb439371caa4e7a7

title: Work in progress: all New Zealand people and all New Zealand attributes

SELECT DISTINCT ?person #?personLabel ?personDescription ?personAltLabel #(GROUP_CONCAT(DISTINCT ?dob; SEPARATOR = ";") AS ?DOBs) #(GROUP_CONCAT(DISTINCT ?dod; SEPARATOR = ";") AS ?DODs) #(GROUP_CONCAT(DISTINCT ?lccnurl; SEPARATOR = ";") AS ?LCCN_urls) #(GROUP_CONCAT(DISTINCT ?viafurl; SEPARATOR = ";") AS ?VIAF_urls)

# ?komurl ?dnzburl ?shofurl ?fnzaurl ?hnzpurl ?maraurl ?anzlurl #?nlnzurl ?anziurl ?abidurl ?nzocurl ?nzpiurl ?papaurl ?bfidurl ?fracurl ?szidurl ?mcidurl ?atliurl WHERE {

?person wdt:P31 wd:Q5 . # person is a person { ?person wdt:P27 wd:Q664 . # citizen of New Zealand } UNION { ?person wdt:P551 wd:Q664 . # residence of New Zealand }

SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } #OPTIONAL { ?person wdt:P569 ?dob . } .
#OPTIONAL { ?person wdt:P570 ?dod . } .
#OPTIONAL { ?person wdt:P244 ?lccn . BIND( IRI(CONCAT('https://lccn.loc.gov/', STR(?lccn))) AS ?lccnurl ) . } . #OPTIONAL { ?person wdt:P214 ?viaf . BIND( IRI(CONCAT('https://viaf.org/viaf/', STR(?viaf))) AS ?viafurl ) . } .

OPTIONAL { ?person wdt:P12702 ?komi . BIND( IRI(CONCAT('https://www.komako.org.nz/person/', STR(?komi))) AS ?komurl ) . } . # Kōmako author ID OPTIONAL { ?person wdt:P2745 ?dnzb . BIND( IRI(CONCAT('https://teara.govt.nz/en/biographies/', STR(?dnzb))) AS ?dnzburl ) . } . # Dictionary of New Zealand Biography ID OPTIONAL { ?person wdt:P4418 ?shof . BIND( IRI(CONCAT('https://www.nzhalloffame.co.nz/Inductees/', STR(?shof))) AS ?shofurl ) . } . # New Zealand Sports Hall of Fame ID OPTIONAL { ?person wdt:P6792 ?fnza . BIND( IRI(CONCAT('https://findnzartists.org.nz/en/artist/', STR(?fnza))) AS ?fnzaurl ) .} . # Find NZ Artists ID OPTIONAL { ?person wdt:P11004 ?hnzp . BIND( IRI(CONCAT('https://hockeynz.altiusrt.com/people/', STR(?hnzp))) AS ?hnzpurl ) .} . # Hockey New Zealand person ID OPTIONAL { ?person wdt:P5640 ?mara . BIND( IRI(CONCAT('https://www.read-nz.org/writer/', STR(?mara))) AS ?maraurl ) .} . # Read NZ Te Pou Muramura writer ID OPTIONAL { ?person wdt:P5635 ?anzl . BIND( IRI(CONCAT('https://www.anzliterature.com/member/', STR(?anzl))) AS ?anzlurl ) .} . # ANZL writer ID OPTIONAL { ?person wdt:P7682 ?nlnz . BIND( IRI(CONCAT('https://natlib.govt.nz/records/', STR(?nlnz))) AS ?nlnzurl ) .} . # National Library of New Zealand ID OPTIONAL { ?person wdt:P12985 ?anzi . BIND( IRI(CONCAT('https://www.anzrankings.org.nz/site/profiles_con/athlete/', STR(?anzi))) AS ?anziurl ) .} . # Athletics New Zealand athlete ID OPTIONAL { ?person wdt:P3645 ?abid . BIND( IRI(CONCAT('http://stats.allblacks.com/asp/profile.asp?ABID=', STR(?abid))) AS ?abidurl ) .} . # All Blacks player ID OPTIONAL { ?person wdt:P4056 ?nzoc . BIND( IRI(CONCAT('https://www.olympic.org.nz/athletes/', STR(?nzoc))) AS ?nzocurl ) .} . # New Zealand Olympic Committee athlete ID
OPTIONAL { ?person wdt:P10977 ?nzpi . BIND( IRI(CONCAT('https://paralympics.org.nz/paralympians-profiles/', STR(?nzpi))) AS ?nzpiurl ) .} . # Paralympics New Zealand athlete ID OPTIONAL { ?person wdt:P3544 ?papa . BIND( IRI(CONCAT('https://collections.tepapa.govt.nz/agent/', STR(?papa))) AS ?papaurl ) .} . # Te Papa agent ID OPTIONAL { ?person wdt:P5636 ?bfid . BIND( IRI(CONCAT('http://stats.allblacks.com/asp/profile_bf.asp?BFID=', STR(?bfid))) AS ?bfidurl ) .} . # Black Ferns player ID OPTIONAL { ?person wdt:P9136 ?szid . BIND( IRI(CONCAT('https://sounz.org.nz/contributors/', STR(?szid))) AS ?szidurl ) .} . # SOUNZ contributor ID OPTIONAL { ?person wdt:P8067 ?mcid . BIND( IRI(CONCAT('https://collection.canterburymuseum.com/objects/', STR(?mcid))) AS ?mcidurl ) .} . # identifier in the Macdonald Dictionary OPTIONAL { ?person wdt:P6683 ?atli . BIND( IRI(CONCAT('https://tiaki.natlib.govt.nz/#details=ethesaurus.', STR(?atli))) AS ?atliurl ) .} . # Alexander Turnbull Library ID

OPTIONAL { ?person wdt:P2745 ?dnzb . BIND( IRI(CONCAT('https://www.komako.org.nz/person/', STR(?dnzb))) AS ?dnzburl ) .} . # Dictionary of New Zealand Biography ID

} GROUP BY ?person # ?personLabel ?personDescription ?personAltLabel # ?komurl ?dnzburl ?shofurl ?fnzaurl ?hnzpurl ?maraurl ?anzlurl #?nlnzurl ?anziurl ?abidurl ?nzocurl ?nzpiurl ?papaurl ?bfidurl ?fracurl ?szidurl ?mcidurl ?atliurl

LIMIT 1000

Use at

https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title: Work in progress: all New Zealand people and all New Zealand attributes
#
SELECT DISTINCT 
   ?person 
   #?personLabel ?personDescription  ?personAltLabel 
   #(GROUP_CONCAT(DISTINCT ?dob; SEPARATOR = ";") AS ?DOBs)
   #(GROUP_CONCAT(DISTINCT ?dod; SEPARATOR = ";") AS ?DODs)
   #(GROUP_CONCAT(DISTINCT ?lccnurl; SEPARATOR = ";") AS ?LCCN_urls)
   #(GROUP_CONCAT(DISTINCT ?viafurl; SEPARATOR = ";") AS ?VIAF_urls)

   # ?komurl ?dnzburl ?shofurl ?fnzaurl ?hnzpurl ?maraurl ?anzlurl
   #?nlnzurl ?anziurl ?abidurl  ?nzocurl  ?nzpiurl ?papaurl ?bfidurl  ?fracurl ?szidurl 
   ?mcidurl ?atliurl
   WHERE {

   ?person wdt:P31 wd:Q5 . # person is a person
   {
      ?person wdt:P27 wd:Q664 .  # citizen of New Zealand
    } UNION {
      ?person wdt:P551 wd:Q664 .  # residence of New Zealand
   } 


   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" }
   #OPTIONAL { ?person wdt:P569 ?dob . } .   
   #OPTIONAL { ?person wdt:P570 ?dod . } .   
   #OPTIONAL { ?person wdt:P244 ?lccn .  BIND( IRI(CONCAT('https://lccn.loc.gov/', STR(?lccn)))  AS ?lccnurl ) .   } . 
   #OPTIONAL { ?person wdt:P214 ?viaf .  BIND( IRI(CONCAT('https://viaf.org/viaf/', STR(?viaf)))  AS ?viafurl ) . } . 

   OPTIONAL { ?person wdt:P12702 ?komi  .  BIND( IRI(CONCAT('https://www.komako.org.nz/person/',         STR(?komi)))  AS ?komurl  ) . } .  # Kōmako author ID
   OPTIONAL { ?person wdt:P2745  ?dnzb  .  BIND( IRI(CONCAT('https://teara.govt.nz/en/biographies/',         STR(?dnzb)))  AS ?dnzburl ) . } . # Dictionary of New Zealand Biography ID 
   OPTIONAL { ?person wdt:P4418  ?shof  .  BIND( IRI(CONCAT('https://www.nzhalloffame.co.nz/Inductees/', STR(?shof)))  AS ?shofurl ) . } . # New Zealand Sports Hall of Fame ID
   OPTIONAL { ?person wdt:P6792  ?fnza  .  BIND( IRI(CONCAT('https://findnzartists.org.nz/en/artist/', STR(?fnza)))  AS ?fnzaurl ) .} . # Find NZ Artists ID
   OPTIONAL { ?person wdt:P11004 ?hnzp  .  BIND( IRI(CONCAT('https://hockeynz.altiusrt.com/people/', STR(?hnzp)))  AS ?hnzpurl ) .} . # Hockey New Zealand person ID 
   OPTIONAL { ?person wdt:P5640  ?mara  .  BIND( IRI(CONCAT('https://www.read-nz.org/writer/', STR(?mara)))  AS ?maraurl ) .} . # Read NZ Te Pou Muramura writer ID
   OPTIONAL { ?person wdt:P5635  ?anzl  .  BIND( IRI(CONCAT('https://www.anzliterature.com/member/', STR(?anzl)))  AS ?anzlurl ) .} . # ANZL writer ID 
   OPTIONAL { ?person wdt:P7682  ?nlnz  .  BIND( IRI(CONCAT('https://natlib.govt.nz/records/', STR(?nlnz)))  AS ?nlnzurl ) .} . # National Library of New Zealand ID
   OPTIONAL { ?person wdt:P12985 ?anzi  .  BIND( IRI(CONCAT('https://www.anzrankings.org.nz/site/profiles_con/athlete/', STR(?anzi)))  AS ?anziurl ) .} . # Athletics New Zealand athlete ID
   OPTIONAL { ?person wdt:P3645  ?abid  .  BIND( IRI(CONCAT('http://stats.allblacks.com/asp/profile.asp?ABID=', STR(?abid)))  AS ?abidurl ) .} . # All Blacks player ID
   OPTIONAL { ?person wdt:P4056  ?nzoc  .  BIND( IRI(CONCAT('https://www.olympic.org.nz/athletes/', STR(?nzoc)))  AS ?nzocurl ) .} . # New Zealand Olympic Committee athlete ID  
   OPTIONAL { ?person wdt:P10977 ?nzpi  .  BIND( IRI(CONCAT('https://paralympics.org.nz/paralympians-profiles/', STR(?nzpi)))  AS ?nzpiurl ) .} . # Paralympics New Zealand athlete ID
   OPTIONAL { ?person wdt:P3544  ?papa  .  BIND( IRI(CONCAT('https://collections.tepapa.govt.nz/agent/', STR(?papa)))  AS ?papaurl ) .} . # Te Papa agent ID 
   OPTIONAL { ?person wdt:P5636  ?bfid  .  BIND( IRI(CONCAT('http://stats.allblacks.com/asp/profile_bf.asp?BFID=', STR(?bfid)))  AS ?bfidurl ) .} . # Black Ferns player ID
   OPTIONAL { ?person wdt:P9136  ?szid  .  BIND( IRI(CONCAT('https://sounz.org.nz/contributors/', STR(?szid)))  AS ?szidurl ) .} . # SOUNZ contributor ID
   OPTIONAL { ?person wdt:P8067  ?mcid  .  BIND( IRI(CONCAT('https://collection.canterburymuseum.com/objects/', STR(?mcid)))  AS ?mcidurl ) .} . # identifier in the Macdonald Dictionary
   OPTIONAL { ?person wdt:P6683  ?atli  .  BIND( IRI(CONCAT('https://tiaki.natlib.govt.nz/#details=ethesaurus.', STR(?atli)))  AS ?atliurl ) .} . # Alexander Turnbull Library ID 
#   OPTIONAL { ?person wdt:P2745  ?dnzb  .  BIND( IRI(CONCAT('https://www.komako.org.nz/person/', STR(?dnzb)))  AS ?dnzburl ) .} . # Dictionary of New Zealand Biography ID 
#   OPTIONAL { ?person wdt:P2745  ?dnzb  .  BIND( IRI(CONCAT('https://www.komako.org.nz/person/', STR(?dnzb)))  AS ?dnzburl ) .} . # Dictionary of New Zealand Biography ID 
#   OPTIONAL { ?person wdt:P2745  ?dnzb  .  BIND( IRI(CONCAT('https://www.komako.org.nz/person/', STR(?dnzb)))  AS ?dnzburl ) .} . # Dictionary of New Zealand Biography ID 
#   OPTIONAL { ?person wdt:P2745  ?dnzb  .  BIND( IRI(CONCAT('https://www.komako.org.nz/person/', STR(?dnzb)))  AS ?dnzburl ) .} . # Dictionary of New Zealand Biography ID 
#   OPTIONAL { ?person wdt:P2745  ?dnzb  .  BIND( IRI(CONCAT('https://www.komako.org.nz/person/', STR(?dnzb)))  AS ?dnzburl ) .} . # Dictionary of New Zealand Biography ID 
#   OPTIONAL { ?person wdt:P2745  ?dnzb  .  BIND( IRI(CONCAT('https://www.komako.org.nz/person/', STR(?dnzb)))  AS ?dnzburl ) .} . # Dictionary of New Zealand Biography ID 
#   OPTIONAL { ?person wdt:P2745  ?dnzb  .  BIND( IRI(CONCAT('https://www.komako.org.nz/person/', STR(?dnzb)))  AS ?dnzburl ) .} . # Dictionary of New Zealand Biography ID 
}
GROUP BY ?person # ?personLabel   ?personDescription   ?personAltLabel
   # ?komurl ?dnzburl ?shofurl ?fnzaurl ?hnzpurl ?maraurl ?anzlurl 
   #?nlnzurl ?anziurl ?abidurl  ?nzocurl ?nzpiurl ?papaurl ?bfidurl  ?fracurl ?szidurl 
   ?mcidurl ?atliurl
#LIMIT 1000

Query found at

https://www.wikidata.org/wiki/User:Stuartyeates/InterestingPeopleQuery

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v20("?abid") v21("?abidurl") v18("?anzi") v19("?anziurl") v14("?anzl") v15("?anzlurl") v34("?atli") v35("?atliurl"):::projected v28("?bfid") v29("?bfidurl") v4("?dnzb") v5("?dnzburl") v8("?fnza") v9("?fnzaurl") v10("?hnzp") v11("?hnzpurl") v2("?komi") v3("?komurl") v12("?mara") v13("?maraurl") v32("?mcid") v33("?mcidurl"):::projected v16("?nlnz") v17("?nlnzurl") v22("?nzoc") v23("?nzocurl") v24("?nzpi") v25("?nzpiurl") v26("?papa") v27("?papaurl") v1("?person"):::projected v6("?shof") v7("?shofurl") v30("?szid") v31("?szidurl") c9(["#91;AUTO_LANGUAGE#93;,mul,en"]):::literal c7(["bd:serviceParam"]):::iri c2(["wd:Q5"]):::iri c4(["wd:Q664"]):::iri v1 --"wdt:P31"--> c2 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; v1 --"wdt:P551"--> c4 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v1 --"wdt:P27"--> c4 end union0r <== or ==> union0l end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c7 --"wikibase:language"--> c9 end subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P12702".-> v2 bind0[/"concat('https://www.komako.org.nz/person/',str(?komi))"/] v2 --o bind0 bind0 --as--o v3 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P2745".-> v4 bind1[/"concat('https://teara.govt.nz/en/biographies/',str(?dnzb))"/] v4 --o bind1 bind1 --as--o v5 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P4418".-> v6 bind2[/"concat('https://www.nzhalloffame.co.nz/Inductees/',str(?shof))"/] v6 --o bind2 bind2 --as--o v7 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P6792".-> v8 bind3[/"concat('https://findnzartists.org.nz/en/artist/',str(?fnza))"/] v8 --o bind3 bind3 --as--o v9 end subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P11004".-> v10 bind4[/"concat('https://hockeynz.altiusrt.com/people/',str(?hnzp))"/] v10 --o bind4 bind4 --as--o v11 end subgraph optional5["(optional)"] style optional5 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P5640".-> v12 bind5[/"concat('https://www.read-nz.org/writer/',str(?mara))"/] v12 --o bind5 bind5 --as--o v13 end subgraph optional6["(optional)"] style optional6 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P5635".-> v14 bind6[/"concat('https://www.anzliterature.com/member/',str(?anzl))"/] v14 --o bind6 bind6 --as--o v15 end subgraph optional7["(optional)"] style optional7 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P7682".-> v16 bind7[/"concat('https://natlib.govt.nz/records/',str(?nlnz))"/] v16 --o bind7 bind7 --as--o v17 end subgraph optional8["(optional)"] style optional8 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P12985".-> v18 bind8[/"concat('https://www.anzrankings.org.nz/site/profiles_con/athlete/',str(?anzi))"/] v18 --o bind8 bind8 --as--o v19 end subgraph optional9["(optional)"] style optional9 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P3645".-> v20 bind9[/"concat('http://stats.allblacks.com/asp/profile.asp?ABID=',str(?abid))"/] v20 --o bind9 bind9 --as--o v21 end subgraph optional10["(optional)"] style optional10 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P4056".-> v22 bind10[/"concat('https://www.olympic.org.nz/athletes/',str(?nzoc))"/] v22 --o bind10 bind10 --as--o v23 end subgraph optional11["(optional)"] style optional11 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P10977".-> v24 bind11[/"concat('https://paralympics.org.nz/paralympians-profiles/',str(?nzpi))"/] v24 --o bind11 bind11 --as--o v25 end subgraph optional12["(optional)"] style optional12 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P3544".-> v26 bind12[/"concat('https://collections.tepapa.govt.nz/agent/',str(?papa))"/] v26 --o bind12 bind12 --as--o v27 end subgraph optional13["(optional)"] style optional13 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P5636".-> v28 bind13[/"concat('http://stats.allblacks.com/asp/profile_bf.asp?BFID=',str(?bfid))"/] v28 --o bind13 bind13 --as--o v29 end subgraph optional14["(optional)"] style optional14 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P9136".-> v30 bind14[/"concat('https://sounz.org.nz/contributors/',str(?szid))"/] v30 --o bind14 bind14 --as--o v31 end subgraph optional15["(optional)"] style optional15 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P8067".-> v32 bind15[/"concat('https://collection.canterburymuseum.com/objects/',str(?mcid))"/] v32 --o bind15 bind15 --as--o v33 end subgraph optional16["(optional)"] style optional16 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P6683".-> v34 bind16[/"concat('https://tiaki.natlib.govt.nz/#details=ethesaurus.',str(?atli))"/] v34 --o bind16 bind16 --as--o v35 end