Wikidata

Sebastian Wallroth

Joined 26 November 2012

→ meta:User:Sebastian Wallroth

Create family name with Quickstatements edit

Copy 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 edit 

SELECT ?item ?itemLabel WHERE {
  ?item wdt:P27 wd:Q1206012.
  MINUS { ?item wdt:P734 _:b0. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "de". }
}
LIMIT 8
Try it!

Urheber, die 1946 verstorben sind edit 

SELECT ?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
Try it!

V2 edit

New 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)
Try it!

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. }
}
Try it!
 This person participated in the
International Museum Day 2022 Wikidata Competition.
Retrieved from "https://www.wikidata.org/w/index.php?title=User:Sebastian_Wallroth&oldid=1878890339"