query-f6b90fa52728fb037af657c85396081b

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 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 ) . } . 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: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 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
   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  ) . } . 
   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: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
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; v34("?DOBs") v35("?DODs") v36("?LCCN_urls") v37("?VIAF_urls") v26("?abid") v27("?abidurl"):::projected v24("?anzi") v25("?anziurl"):::projected v20("?anzl") v21("?anzlurl") v10("?dnzb") v11("?dnzburl") v2("?dob"):::projected v3("?dod"):::projected v14("?fnza") v15("?fnzaurl") v16("?hnzp") v17("?hnzpurl") v8("?komi") v9("?komurl") v4("?lccn") v5("?lccnurl"):::projected v18("?mara") v19("?maraurl") v22("?nlnz") v23("?nlnzurl"):::projected v28("?nzoc") v29("?nzocurl"):::projected v30("?nzpi") v31("?nzpiurl"):::projected v32("?papa") v33("?papaurl"):::projected v1("?person"):::projected v12("?shof") v13("?shofurl") v6("?viaf") v7("?viafurl"):::projected 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:P569".-> v2 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P570".-> v3 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P244".-> v4 bind0[/"concat('https://lccn.loc.gov/',str(?lccn))"/] v4 --o bind0 bind0 --as--o v5 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P214".-> v6 bind1[/"concat('https://viaf.org/viaf/',str(?viaf))"/] v6 --o bind1 bind1 --as--o v7 end subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P12702".-> v8 bind2[/"concat('https://www.komako.org.nz/person/',str(?komi))"/] v8 --o bind2 bind2 --as--o v9 end subgraph optional5["(optional)"] style optional5 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P2745".-> v10 bind3[/"concat('https://teara.govt.nz/en/biographies/',str(?dnzb))"/] v10 --o bind3 bind3 --as--o v11 end subgraph optional6["(optional)"] style optional6 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P4418".-> v12 bind4[/"concat('https://www.nzhalloffame.co.nz/Inductees/',str(?shof))"/] v12 --o bind4 bind4 --as--o v13 end subgraph optional7["(optional)"] style optional7 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P6792".-> v14 bind5[/"concat('https://findnzartists.org.nz/en/artist/',str(?fnza))"/] v14 --o bind5 bind5 --as--o v15 end subgraph optional8["(optional)"] style optional8 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P11004".-> v16 bind6[/"concat('https://hockeynz.altiusrt.com/people/',str(?hnzp))"/] v16 --o bind6 bind6 --as--o v17 end subgraph optional9["(optional)"] style optional9 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P5640".-> v18 bind7[/"concat('https://www.read-nz.org/writer/',str(?mara))"/] v18 --o bind7 bind7 --as--o v19 end subgraph optional10["(optional)"] style optional10 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P5635".-> v20 bind8[/"concat('https://www.anzliterature.com/member/',str(?anzl))"/] v20 --o bind8 bind8 --as--o v21 end subgraph optional11["(optional)"] style optional11 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P7682".-> v22 bind9[/"concat('https://natlib.govt.nz/records/',str(?nlnz))"/] v22 --o bind9 bind9 --as--o v23 end subgraph optional12["(optional)"] style optional12 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P12985".-> v24 bind10[/"concat('https://www.anzrankings.org.nz/site/profiles_con/athlete/',str(?anzi))"/] v24 --o bind10 bind10 --as--o v25 end subgraph optional13["(optional)"] style optional13 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P3645".-> v26 bind11[/"concat('http://stats.allblacks.com/asp/profile.asp?ABID=',str(?abid))"/] v26 --o bind11 bind11 --as--o v27 end subgraph optional14["(optional)"] style optional14 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P4056".-> v28 bind12[/"concat('https://www.olympic.org.nz/athletes/',str(?nzoc))"/] v28 --o bind12 bind12 --as--o v29 end subgraph optional15["(optional)"] style optional15 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P10977".-> v30 bind13[/"concat('https://paralympics.org.nz/paralympians-profiles/',str(?nzpi))"/] v30 --o bind13 bind13 --as--o v31 end subgraph optional16["(optional)"] style optional16 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P3544".-> v32 bind14[/"concat('https://collections.tepapa.govt.nz/agent/',str(?papa))"/] v32 --o bind14 bind14 --as--o v33 end bind19[/"?dob"/] v2 --o bind19 bind19 --as--o v34 bind20[/"?dod"/] v3 --o bind20 bind20 --as--o v35 bind21[/"?lccnurl"/] v5 --o bind21 bind21 --as--o v36 bind22[/"?viafurl"/] v7 --o bind22 bind22 --as--o v37