Sebastian Wallroth
Joined 26 November 2012
Create family name with Quickstatements
editCopy code below into text editor, replace "Schaxel" with new family name, and use https://quickstatements.toolforge.org/#/batch to create new family name.
CREATE /* replace Schaxel with family name */ LAST P1705 de:"Schaxel" LAST P31 Q101352 LAST P282 Q8229 LAST Laf "Schaxel" LAST Lan "Schaxel" LAST Last "Schaxel" LAST Latj "Schaxel" LAST Laz "Schaxel" LAST Lbar "Schaxel" LAST Lbm "Schaxel" LAST Lbr "Schaxel" LAST Lbs "Schaxel" LAST Lca "Schaxel" LAST Lcs "Schaxel" LAST Lcsb "Schaxel" LAST Lcy "Schaxel" LAST Lda "Schaxel" LAST Lde "Schaxel" LAST Lde-at "Schaxel" LAST Lde-ch "Schaxel" LAST Len "Schaxel" LAST Len-ca "Schaxel" LAST Len-gb "Schaxel" LAST Leo "Schaxel" LAST Les "Schaxel" LAST Let "Schaxel" LAST Leu "Schaxel" LAST Lfi "Schaxel" LAST Lfo "Schaxel" LAST Lfr "Schaxel" LAST Lfrc "Schaxel" LAST Lfy "Schaxel" LAST Lga "Schaxel" LAST Lgl "Schaxel" LAST Lgsw "Schaxel" LAST Lha "Schaxel" LAST Lhr "Schaxel" LAST Lhsb "Schaxel" LAST Lhu "Schaxel" LAST Lid "Schaxel" LAST Lig "Schaxel" LAST Lio "Schaxel" LAST Lis "Schaxel" LAST Lit "Schaxel" LAST Ljbo "Schaxel" LAST Ljv "Schaxel" LAST Lkk-latn "Schaxel" LAST Lkk-tr "Schaxel" LAST Lksh "Schaxel" LAST Lku-latn "Schaxel" LAST Lla "Schaxel" LAST Llad "Schaxel" LAST Llb "Schaxel" LAST Llt "Schaxel" LAST Llv "Schaxel" LAST Lmin "Schaxel" LAST Lms "Schaxel" LAST Lnan "Schaxel" LAST Lnb "Schaxel" LAST Lnds "Schaxel" LAST Lnl "Schaxel" LAST Lnn "Schaxel" LAST Loc "Schaxel" LAST Lpl "Schaxel" LAST Lpms "Schaxel" LAST Lpt "Schaxel" LAST Lpt-br "Schaxel" LAST Lro "Schaxel" LAST Lse "Schaxel" LAST Lsgs "Schaxel" LAST Lsh "Schaxel" LAST Lsje "Schaxel" LAST Lsk "Schaxel" LAST Lsl "Schaxel" LAST Lsma "Schaxel" LAST Lsmj "Schaxel" LAST Lsmn "Schaxel" LAST Lsms "Schaxel" LAST Lsn "Schaxel" LAST Lsq "Schaxel" LAST Lsr-el "Schaxel" LAST Lsv "Schaxel" LAST Lsw "Schaxel" LAST Ltl "Schaxel" LAST Ltr "Schaxel" LAST Luz "Schaxel" LAST Lvep "Schaxel" LAST Lvi "Schaxel" LAST Lvro "Schaxel" LAST Lwa "Schaxel" LAST Lwar "Schaxel" LAST Lyo "Schaxel" LAST Lza "Schaxel" LAST Lzu "Schaxel" LAST Daf "van" LAST Dam "የአያት ስም" LAST Dan "apelliu" LAST Dar "اسم العائلة" LAST Das "উপাধি" LAST Dast "apellíu" LAST Datj "icinikasowin" LAST Daz "soyad" LAST Dazb "سویآد" LAST Dba "фамилия" LAST Dbar "Schreibnam" LAST Dbe "прозвішча" LAST Dbe-tarask "прозьвішча" LAST Dbg "фамилно име" LAST Dbm "jamu" LAST Dbn "পদবি" LAST Dbr "anv-tiegezh" LAST Dbs "prezime" LAST Dca "cognom" LAST Dcs "příjmení" LAST Dcsb "nôzwëskò" LAST Dcv "хушамат" LAST Dcy "cyfenw" LAST Dda "efternavn" LAST Dde "Familienname" LAST Dde-at "Familienname" LAST Dde-ch "Familienname" LAST Del "επώνυμο" LAST Den "family name" LAST Den-ca "family name" LAST Den-gb "surname" LAST Deo "familia nomo" LAST Des "apellido" LAST Det "perekonnanimi" LAST Deu "abizen" LAST Dfa "نام خانوادگی" LAST Dfi "sukunimi" LAST Dfo "ættarnavn" LAST Dfr "nom de famille" LAST Dfrc "nom de famille" LAST Dfy "efternamme" LAST Dga "sloinne" LAST Dgan "姓氏箋釋" LAST Dgan-hans "姓氏笺释" LAST Dgan-hant "姓氏箋釋" LAST Dgl "apelido" LAST Dgsw "Familiename" LAST Dgu "અટક" LAST Dha "sunan gida" LAST Dhe "שם משפחה" LAST Dhi "उपनाम" LAST Dhr "prezime" LAST Dhsb "swójbne mjeno" LAST Dhu "családnév" LAST Dhy "ազգանուն" LAST Dhyw "Մականուն" LAST Did "marga" LAST Dig "ahà nnà" LAST Dio "surnomo" LAST Dis "ættarnafn" LAST Dit "cognome" LAST Diu "ᑐᑐ" LAST Dja "姓" LAST Djbo "lazme'e" LAST Djv "jeneng pancer" LAST Dka "გვარი" LAST Dkk "тек, ата-тек, әулет есім" LAST Dkk-arab "تەك، اتا-تەك، اۋلەت ەسىم" LAST Dkk-cn "تەك، اتا-تەك، اۋلەت ەسىم" LAST Dkk-cyrl "тек, ата-тек, әулет есім" LAST Dkk-kz "тек, ата-тек, әулет есім" LAST Dkk-latn "tek, ata-tek, äwlet esim" LAST Dkk-tr "tek, ata-tek, äwlet esim" LAST Dkn "ಕೌಟುಂಬಿಕ ನಾಮ ಅಥವಾ ಮನೆತನದ ಹೆಸರು" LAST Dko "성씨" LAST Dksh "Nohnahme" LAST Dku-latn "paşnav" LAST Dky "үй-бүлө аты" LAST Dla "nomen gentilicium" LAST Dlad "alkunya" LAST Dlb "Familljennumm" LAST Dlt "pavardė" LAST Dlv "uzvārds" LAST Dlzh "姓氏" LAST Dmhr "тукымлӱм" LAST Dmin "namo asli" LAST Dmk "презиме" LAST Dml "കുടുംബ നാമം" LAST Dmr "आडनाव" LAST Dms "nama keluarga" LAST Dmyv "буелем" LAST Dnan "Jī-sèⁿ" LAST Dnb "etternavn" LAST Dnds "Familiennaam" LAST Dne "थर" LAST Dnew "उपनां" LAST Dnl "familienaam" LAST Dnn "slektsnamn" LAST Dnqo "ߛߌ" LAST Doc "nom d'ostal" LAST Dor "ସାଙ୍ଗିଆ" LAST Dos "мыггаг" LAST Dpl "nazwisko" LAST Dpms "cognòm" LAST Dpt "sobrenome" LAST Dpt-br "sobrenome" LAST Dro "nume de familie" LAST Dru "фамилия" LAST Drue "Призвиско" LAST Dsa "उपनामध्येयम्" LAST Dsd "ذات" LAST Dse "sohkanamma" LAST Dsgs "Pavardie" LAST Dsh "prezime" LAST Dsje "maŋŋepnamma" LAST Dsk "priezvisko" LAST Dsl "priimek" LAST Dsma "fuelhkienomme" LAST Dsmj "maŋepnamma" LAST Dsmn "suhânommâ" LAST Dsms "sokknõmm" LAST Dsn "Mazita eMhuri" LAST Dsq "mbiemër" LAST Dsr "презиме" LAST Dsr-ec "презиме" LAST Dsr-el "prezime" LAST Dsv "efternamn" LAST Dsw "jina la ukoo" LAST Dta "குடும்பப் பெயர்" LAST Dte "ఇంటి పేర్లు" LAST Dtg "насаб" LAST Dtg-cyrl "насаб" LAST Dth "นามสกุล" LAST Dtl "Apelyido" LAST Dtr "soyadı" LAST Dtt "фамилия" LAST Dtt-cyrl "фамилия" LAST Duk "прізвище" LAST Dur "خاندانی نام" LAST Duz "familiya" LAST Dvep "familii" LAST Dvi "họ" LAST Dvro "Väärnimi" LAST Dwa "no d' famile" LAST Dwar "apelyidu" LAST Dwuu "姓氏" LAST Dyi "פֿאַמיליע נאָמען" LAST Dyo "orúkọ ẹbí" LAST Dyue "姓" LAST Dza "singq" LAST Dzh "姓氏" LAST Dzh-cn "姓" LAST Dzh-hans "姓" LAST Dzh-hant "姓氏" LAST Dzh-hk "姓氏" LAST Dzh-mo "姓氏" LAST Dzh-my "姓" LAST Dzh-sg "姓氏" LAST Dzh-tw "姓氏" LAST Dzu "isibongo"
Menschen aus dem Deutschen Reich ohne Familienname
editSELECT ?item ?itemLabel WHERE {
?item wdt:P27 wd:Q1206012.
MINUS { ?item wdt:P734 _:b0. }
SERVICE wikibase:label { bd:serviceParam wikibase:language "de". }
}
LIMIT 8
Urheber, die 1946 verstorben sind
editSELECT ?Objekt ?Name ?Beschreibung ?Bild (COUNT(DISTINCT ?sitelink) as ?Artikel)
WHERE
{
?Objekt wdt:P31 wd:Q5 .
?Objekt wdt:P570 ?Tod FILTER (YEAR(?Tod)=1946) .
?Objekt wdt:P106/wdt:P279* wd:Q2500638 .
?sitelink schema:about ?Objekt
SERVICE wikibase:label {
bd:serviceParam wikibase:language "de,en" .
?Objekt rdfs:label ?Name .
?Objekt schema:description ?Beschreibung
}
OPTIONAL { ?Objekt wdt:P18 ?Bild }
}
GROUP BY ?Objekt ?Name ?Beschreibung ?Bild
ORDER BY DESC (?Artikel)
LIMIT 1000
V2
editNew version by Dipsacus fullonum. --Sebastian Wallroth (talk) 08:55, 4 January 2021 (UTC)
SELECT DISTINCT ?item ?articlecount
WITH
{
SELECT ?item
WHERE
{
?item wdt:P570 ?deathdate .
hint:Prior hint:rangeSafe true .
FILTER ( ?deathdate < "1947-00-00"^^xsd:dateTime && ?deathdate >= "1946-00-00"^^xsd:dateTime )
}
}
AS %subquery
WHERE
{
INCLUDE %subquery
?item wikibase:sitelinks ?articlecount .
?item p:P106 ?occupationStatement .
?occupationStatement ps:P106/wdt:P279* wd:Q2500638 .
hint:Prior hint:gearing "forward" .
MINUS { ?occupationStatement wikibase:rank wikibase:DeprecatedRank . }
}
ORDER BY DESC (?articlecount)
Menschen mit "Zika" in der Bezeichnung (label)
edit#Menschen mit "Zika" in der Bezeichnung (label)
SELECT ?item ?itemLabel
WITH {
SELECT * WHERE {
BIND ("zika" AS ?searchfor)
}
} AS %p
WITH {
SELECT ?item
WHERE {
INCLUDE %p
BIND (CONCAT("haswbstatement:P31=Q5 ", ?searchfor) AS ?searchstr)
SERVICE wikibase:mwapi {
bd:serviceParam wikibase:endpoint "www.wikidata.org" .
bd:serviceParam wikibase:api "Generator" .
bd:serviceParam mwapi:generator "search" .
bd:serviceParam mwapi:gsrsearch ?searchstr .
bd:serviceParam mwapi:gsrlimit "max" .
bd:serviceParam mwapi:gsrnamespace "0" .
bd:serviceParam mwapi:gsrprop "" .
?item wikibase:apiOutputItem mwapi:title .
}
}
} AS %i
WHERE {
INCLUDE %i
INCLUDE %p
?item rdfs:label ?itemLabel .
FILTER (LANG(?itemLabel)="en")
FILTER(CONTAINS(LCASE(?itemLabel), ?searchfor))
OPTIONAL { ?item wdt:P698 ?PMID. }
OPTIONAL { ?item wdt:P356 ?DOI. }
}
This person participated in the International Museum Day 2022 Wikidata Competition. |
This person participated in the Wikidata contest Coordinate Me 2024. |