Wikidata:WikiProject Czech Republic/Maintenance Queries

Missing images

# Items in the Czech Republic that have coordinates missing an image
SELECT ?item ?itemLabel ?coord
WHERE
{
  ?item wdt:P17 wd:Q213; wdt:P625 ?coord .
  MINUS { ?item wdt:P18 ?image } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "cs" } .
}

Try it!

Also works with "WikiData Free Image Search Tool": [1]

Items without statements

Duplicates of monument IDs

See also /Duplicates of monument IDs

#Find duplicate monument IDs
SELECT * WHERE {
  {
    SELECT ?id (COUNT(?obj) AS ?count) (GROUP_CONCAT(?obj; SEPARATOR = " , ") AS ?items) WHERE { 
      ?obj wdt:P762 ?id. 
    }
    GROUP BY ?id
  }
  FILTER(?count > 1)
}

Try it!

Missing articles on cswiki

See also User:Matěj Suchánek/Czech not on cswiki

SELECT ?item ?sitelinks WHERE {
  ?item wdt:P17 wd:Q213 .
  MINUS { ?item ^schema:about/schema:isPartOf <https://cs.wikipedia.org/> } .
  ?item wikibase:sitelinks ?sitelinks .
} ORDER BY DESC(?sitelinks)

Try it!

Possible duplicates with zanikleobce.cz abandoned objects ID (P3003)

#defaultView:Map
SELECT DISTINCT ?item ?itemLabel ?coord ?layer {
  ?item1 wdt:P3003 []; wdt:P625 ?coord1; rdfs:label ?label .
  BIND( STRLANG( STR( IF( CONTAINS( ?label, ' (' ), STRBEFORE( ?label, ' (' ), ?label ) ), 'cs' ) AS ?itemLabel ) .
  ?itemLabel ^rdfs:label ?item2 .
  FILTER( ?item1 != ?item2 ) .
  FILTER EXISTS {
    ?item2 wdt:P17 wd:Q213; wdt:P625 ?coord2; wdt:P31/wdt:P279* wd:Q486972 .
    FILTER( geof:distance( ?coord1, ?coord2 ) < 2 ) .
  } .
  OPTIONAL { ?item2 wdt:P625 ?coord2 } .
  VALUES ?x { 1 2 } .
  BIND( IF( ?x = 1, ?item1, ?item2 ) AS ?item ) .
  BIND( IF( ?x = 1, ?coord1, ?coord2 ) AS ?coord ) .
  BIND( IF( ?x = 1, 'zaniklá', 'druhá' ) AS ?layer ) .
} ORDER BY ?itemLabel

Try it!

Possible duplicates with sv/cebwiki articles

#defaultView:Map
SELECT DISTINCT ?item ?itemLabel ?coord ?layer WITH {
  SELECT DISTINCT ?item1 ?coord1 ?itemLabel {
    VALUES ?links { 1 2 3 } .
    VALUES ?wikis { <https://ceb.wikipedia.org/> <https://sv.wikipedia.org/> } .
    ?item1 wdt:P17 wd:Q213; wikibase:sitelinks ?links; wdt:P625 ?coord1;
           ^schema:about/schema:isPartOf ?wikis; rdfs:label ?label .
    MINUS { ?item1 ^schema:about/schema:isPartOf <https://cs.wikipedia.org/> } .
    BIND( STRLANG( STR( IF( CONTAINS( ?label, ' (' ), STRBEFORE( ?label, ' (' ), ?label ) ), 'cs' ) AS ?itemLabel ) .
  }
} AS %sub WHERE {
  INCLUDE %sub .
  ?itemLabel ^rdfs:label ?item2 .
  FILTER( ?item2 != ?item1 ) .
  FILTER EXISTS {
    ?item2 wdt:P17 wd:Q213; wdt:P625 ?coord2 .
    FILTER( geof:distance( ?coord1, ?coord2 ) < 2 ) .
  } .
  OPTIONAL { ?item2 wdt:P625 ?coord2 } .
  VALUES ?x { 1 2 } .
  BIND( IF( ?x = 1, ?item1, ?item2 ) AS ?item ) .
  BIND( IF( ?x = 1, ?coord1, ?coord2 ) AS ?coord ) .
  BIND( IF( ?x = 1, 'sv/ceb', 'ok' ) AS ?layer ) .
} ORDER BY ?itemLabel

Try it!

New Czech persons

Manually update list

This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!

WDQS | PetScan | TABernacle | Find images | Recent changes

label	Gender	Given name	Date of birth	occupation	NKCR	abart	csfd	orcid	discogs	description	Sitelinks
Jolana Němcová	female	Jolana	1962	music educator secondary school teacher choir director						Czech music teacher and conductor (born 1962)	0
Nikolas Filip	male	Nikolas	2006-02-28	ice hockey player						Czech Ice-hockey Player	1
Anna Caldrova								0000-0001-5444-4940			0
Tereza Voborníková	female	Tereza		make-up artist			218522			Czech makeup artist	0
Martina	female		1980-10-02	pornographic actor						Czech pornographic actress, born 1980	0
Jacob Ficenec	male	Jacob	2006-02-20	ice hockey player							1
Martin Drdla	male			politician						Czech economist, businessman and local politician, councillor of the Brno-střed district	0
Jitka Šnejdrlová				linguist				0000-0001-7594-5605			0
Britney	female			pornographic actor						Czech pornographic actress	0
Johnny Majestic	male		1998-08-15	musician						Czech musician	0
Jan Gutwirth	male	Jan	1902-07-10	musician artist composer		96351				musician, artist, composer (1902-1968)	0
Antonín Jelínek	male	Antonín	1930-12-12	editing staff opinion journalist journalist		176444				Czech editor, journalist and publicist (1930–?)	0
Nicole Taylor	female		1976-06-14	pornographic actor erotic photography model						Czech pornographic actress, born 1976	0
Владимир Скупы	male	Vladimír	1977	politician							0
Эрик Седлачек	male	Erik	1981-04-09	politician							0
Josef Jindra	male		1958-03-26								1
Samuel Saudek	male	Samuel	1963-05-07	photographer tradesperson self-employed person		194026					0
Johnny Slovak	male		1976-06-26	pornographic actor						Czech pornographic actor, born 1976	0
Karel Janyška	male	Karel	1951	politician election agent opinion journalist							0
Isabella	female			pornographic actor						Czech pornographic actress	0
Tobias Boledovič	male	Tobias	2006-09-16	association football player						Czech footballer	1
Klára Vojtíková	female		2007	canoeist kayaker						Czech canoeist	1
Samuel Rouča	male		2002	canoeist kayaker						Czech canoeist	0
Martin Kratochvíl	male		2003	canoeist kayaker						Czech canoeist	0
Valentýna Kočířová	female		2008	canoeist						Czech canoeist	2
Anna Fabianová	female		2007	kayaker canoeist						Czech canoeist	0
Petr Vacek				designer artist						Czech architect, computational designer and kinetic artist	0
Tomáš Hellebrand	male	Tomáš	2007-08-31	association football player						Czech footballer	1
Vojtěch Sedlacek	male	Vojtěch	1999-04-22	sport cyclist						cyclist	0
Tomas Danačík	male			sport cyclist						cyclist	0
Marek Sipos	male			sport cyclist						cyclist	0
Lukas Smola	male			sport cyclist						cyclist	0
Radana Novotná	female	Radana	1976-09-07	sport cyclist							0
Marie Knížáková	male female	Marie				16061			1503572		0
Radka Spesna	female	Radka	1979-02-14	sport cyclist							0
Josef Kolářík	male	Josef	2007-01-16	association football player						Czech footballer	1
Jiří Míček	male	Jiří	2007-06-07	association football player						Czech footballer	1
Kateřina Kolářová	female	Katerina		sport cyclist							0
Robert Mečkovský	male	Robert	1977-04-21	art historian adviser university teacher	xx0035357	102969					0
Bella Karina	female		1983-08-09	pornographic actor							0
Eva Fortova	female	Eva	1978-05-16	sport cyclist							0
Petr Rubáš	male	Petr		entrepreneur musician			360888		4548338		0
Katerina Ebenhohova	female		2003-10-01	basketball player						Czech basketball player (born 2003)	0
Marie Holá	female	Marie	2005-03-31	basketball player						Czech basketball player (born 2005)	0
Natalie Durdova	female		2004-04-10	basketball player						Czech basketball player (born 2004)	0
Martina Stovickova	female		2004-04-02	basketball player						Czech basketball player (born 2004)	0
Michaela Hrbacova	female		2006-06-07	basketball player						Czech basketball player (born 2006)	0
Jonas Musil	male		2002-11-25	basketball player						Czech basketball player (born 2002)	0
Kateřina Chodorová	female	Kateřina	2005-11-29	basketball player						Czech basketball player (born 2005)	0
Michal Grill	male		2006-01-11	basketball player						Czech basketball player (born 2006)	0
Adéla Růžičková	female	Adéla	2010-03-29	basketball player						Czech basketball player (born 2010)	0
Laura Marcolova	female		2009-04-01	basketball player						Czech basketball player (born 2009)	0
Samuel Wangle	male		2006-08-29	basketball player						Czech basketball player (born 2006)	0
Jan Cikrle	male	Jan	2000-05-12	user experience designer product designer graphic designer illustrator						Czech product designer	0
Jiří Dvořák	male	Jiří	1962-10-15	photographer secondary school teacher						Czech photographer and secondary school teacher (born 1962)	0
Victoria Bervid	female	Victoria	2008-05-23	tennis player						Czech tennis player	1
Linda Botková	female		2010-02-06	athletics competitor						Czech hurdler (born 2010)	3
Jan Hušbauer	male	Jan	1988-07-08	politician manager						Czech politician and manager	1
Nancy Lee	female			pornographic actor erotic photography model						Czech pornographic actress	0
Jakub Feuerstein	male			entrepreneur						Czech entrepreneur and creative agency Co-Founder	0
Eva Cikánková	female		1940-02-19	architect						Czech architect	0
Tereza Heřmanová	female	Tereza	2009-06-27	tennis player						Czech tennis player	1
Pavel Kýček				entrepreneur writer						systematic trader, entrepreneur and author	0
Libor Bittner	male	Libor		businessperson manager						Czech businessman	0
Otakar Hobza	male			civil engineer entrepreneur						Czech construction supervisor	0
Jakub Olexa	male	Jakub		chief executive officer entrepreneur						Email geek since 2001, co-founder of Xchat.cz & Xko.cz, co-founder of Mailkit, co-founder of Omnivery	0
Gabriel Špaček	male		2007-04-14	basketball player						Czech basketball player (born 2007)	0
Pavel Pumpra	male		1986-06-13	basketball player						Czech basketball player (born 1986)	0
Marian Kamenistak	male			software engineer						software engineering leader, mentor, and founder of the Engineering Leaders Community	0
Sandra Volny	female	Sandra		visual artist teacher researcher							0
Simon Sloncik	male		2007-05-15	association football player						football player	0
Tomas Jelinek	male		2005-12-27	association football player						football player	0
Daniel Toula	male		2005-02-19	association football player						football player	0
Martin Kovar	male		2008-02-07	association football player						football player	0
Adam Rezek	male		2005-11-21	association football player						football player	0
Marek Naskos	male		2007-06-29	association football player						football player	0
Jiří Mayer	male	Jiří	1990-03-02	painter		185142				Czech painter (born 1990)	0
Ema Jancarkova	female		2006-11-22	basketball player						Czech basketball player (born 2006)	0
Dominik Prokes	male		2009-01-07	basketball player						Czech basketball player (born 2009)	0
Daniel Polacek	male		2009-03-15	basketball player						Czech basketball player (born 2009)	0
Ondrej Kubik	male		2009-06-25	basketball player						Czech basketball player (born 2009)	0
Tobiás Benda	male		2010-12-12	basketball player						Czech basketball player (born 2010)	0
Martin Matoušek	male	Martin	1973-02-21	opera singer operetta singer	mzk20201088884					opera singer	1
Michal Hamtil	male		2008-04-05	basketball player						Czech basketball player (born 2008)	0
Viktor Bulanek			1981-04-04								0
Zdeněk Plas	male			local politician							0
Magda Králíková	female	Magda	1980-01-25	volleyball player						Czech volleyball player	0
Barbora Vránková	female	Barbora	2006-07-29	figure skater							2
Tomáš Kučera	male		1958-07-19	demographer university teacher	uk2007301587			0000-0002-0476-9322		Czech demographer	0
Rodboy	male			pornographic actor						Czech pornographic actor	0
Rostislav Peška	male			product designer systems architect						Czech UX and product designer and system architect	0
DJ Transcave				disc jockey record producer					17935926	Czech trance producer and DJ	0
Petra Bendova	female		1981-12-26	pornographic actor erotic photography model						Czech pornographic actress, born 1981	0
Petra Stingrey	female		1986-08-01	pornographic actor						Czech pornographic actress, born 1986	0
Sunny Jay	female		1985-05-09	pornographic actor						Czech pornographic actress, born 1985	0
Wildy	female		1983-08-22	pornographic actor erotic photography model						Czech pornographic actress, born 1983	0
Katka Redil	female			pornographic actor						Czech pornographic actress, fl. 2007	0
Erik Devil	male			pornographic actor						Czech pornographic actor	0
George Reno	male		1973-05-06	pornographic actor						Czech pornographic actor, born 1973	0
Чарли Стиггер	male		1974	pornographic actor						Czech pornographic actor, born 1974	0

End of automatically generated list.

New Czech entities

Manually update list

This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!

WDQS | PetScan | TABernacle | Find images | Recent changes

label	instance	NKCR	description	Sitelinks
SK Popkovice	association football club		football club	1
Ars poetica	workshop			1
Hunger stone in Dolní Žleb	hunger stone			1
Vyšehradský hladový kámen	hunger stone			0
zahradní altán v Nových Hradech	gazebo			1
zámecký park Dobříčany	castle park			0
dům zahradníka	gardener's house			0
Českomoravská Zasilatelská s.r.o.	business former entity			0
fara v Rejšicích	clergy house			0
Bridge over Hamerský rybník drainer	bridge		bridge in Prague	0
Golf course in Záběhlice	golf course		golf course in Prague	0
KinderGarten Kunratice	kindergarten		kindergarten in Prague	0
Group PL s.r.o.	společnost s ručením omezeným		Czech real estate investment company, operator of NemovitostProdej.cz	0
Velké Přítočno	railway stop			0
Malé Přítočno	railway stop			0
Hostivice-Jeneček	railway stop			0
Advantiq Projects	business		project and interim management consultancy in the Czech Republic	0
Trautenberk Brewery	microbrewery		microbrewery in the Czech Republic	0
Politické hnutí NEZLOMNÍ	political movement			0
24/7	political movement			0
A bench in Charles IV Park in Karlovy Vary	stool		a place to relax in Charles IV Park	1
Advantage-fl.cz	business		Czech supplier ofsurface-finishing, ultrasonic-cleaning and jewellery technology	0
Sirael SW	business	hka20261305772		0
Nadace Eternity	business	xx0348314		0
Magazín PATRIOT	business	hka20261305831		0
Patriot Program	business	hka20261305828		0
Chornický železniční klub	business	ko20261305804		0
UNIAVEZ publishing	business	hka20261305793		0
Okrašlovací spolek Jistebnice	business	mzk20261305784		0
Q-art	business	mzk20261305729		0
Natura Hlinné	business	ko20261305715		0
Centrum pro rozvoj paliativní péče	business	hka20261305680		0
Kostnice Mělník	ossuary			1
VIVnetworks.com	business			1
Duha Zámeček	business	hka20261305628		0
Spoutané nakladatelstvi	business	ko20261305585		0
M Lordy	business	olak20261305582		0
Junák - český skaut, středisko Srdíčko Třebíč	business			0
Junák - český skaut, středisko Ladislava Ruska	business	olak20261305571		0
Orthodoxia Christiana	business	ko20261305565		0
Valdštejnské imaginárium	business	mzk20261305553		0
Nakladatelství Pražské příběhy	business	pna20261305552		0
PlasticPlanet	business	xx0348256		0
Epsillon	business	olak20261305522 xx0348273		0
Pozor Art	business	osd20261305473		0
Nadace Terezy Maxové dětem	business	ko20261305462		0
kaple v Tužicích	chapel	xx0348212		0
Kaple Panny Marie	chapel	xx0348213		0
Mighty Boys	business	xx0348208		0
Gazebo at the Jean de Carro Trail	gazebo		Gazebo at the Jean de Carro Trail in Karlovy Vary	1
Pralinka	rock pinnacle			0
CK Leiber Group 1997	cycling team season			0
Mural at Ke Kateřinkám elementary school	mural		mural in Prague	0
Mendelova 2	school building		school building in Prague	0
Mural at distribution substation TS 3037	mural		mural in Prague	0
Mural at distribution substation TS 1125	mural		mural in Prague	0
Skalka	quarry			0
Brave Czechia	political party, political movement		Czech political party	0
transmitter in Nový Hrozenkov	transmitter station truss		transmitter, Vsetín District, Czech Republic	1
Richardův dub	remarkable tree in the Czech Republic remarkable tree			1
Educational Trail Hradisko	educational trail marked hiking route			1
Relief - eyecatcher for a bookstore	relief sculpture		relief in Prague	0
Synagogue	synagogue former entity house		former synagogue in Vysoký Újezd in Beroun District	1
Synagogue	synagogue former entity house		former synagogue in Zámostí (Písková Lhota), Czech Republic	1
Zpřítomnění	sculpture		sculpture in Prague	0
judge of the Supreme Administrative Court of the Czech Republic	position		position at the Supreme Administrative Court of the Czech Republic	0
judge of the Supreme Court of the Czech Republic	position		position at the Supreme Court of the Czech Republic	0
Footbridge Sousedská lávka	footbridge			1
Villa Central	building		building in Janské Lázně	0
Oldřišov Castle	château		castle in Oldřišov	1
Masarykova střední škola zemědělská a přírodovědná	secondary school			1
Mural at Hagibor	mural former entity		mural in Prague	0
Kolimax	business			1
Czech Republic at the 2026 European Athletics Championships	nation at sport competition		sporting event delegation	2
2023 women's U21 european lacrosse championship	sports season european lacrosse women's U20/21 championships		2023 european lacrosse women's U21 field lacrosse championship Prague	0
2019 european lacrosse men's U20 championship	sports season european lacrosse men's U19/20 championships		2019 european lacrosse men's U20 championship Prague	0
Historická korespondence online	database		Database: Historical Correspondence Online	0
Západoslezské království - Brontosaurus Slezsko	business	mzk20261305347 mzk20261305348		0
Strobl.cz	business	ko20261305334		0
Reklama & tisk Chludil	business	mzk20261305331		0
DS Promotion	business	mzk20261305330		0
Studio 5	business	xx0348156		0
Antilopa	publishing house	ko20261305608		0
KVAK KS	business	olak20261305251		0
Valachia Media	business	xx0348148		0
Educa Service	business	ko20261305179		0
Varius Praha	business	mzk20261305112		0
Cross Na Bařině	wayside cross		wooden cross, Nový Hrozenkov, Czech Republic	1
Zbožná	hamlet			2
Tea	publishing house	ko20261305573		0
Grille of the gate to Na Karlově park	sculpture		sculpture in Prague	0
Untitled	business	olak20261305056		0
GOLF BRNO	business	olak20261305045		0
Brána do Brd	business	pna20261305019		0
PN média	business	xx0348117		0
Pink Troubadour	publishing house	xx0348115		0
Stolperstein of Eva Marie Vaňousová	Stolperstein		stolperstein in Prague	0
Stolperstein of Jiřina Žofie Neumannová	Stolperstein		stolperstein in Prague	0
Stolperstein of Božena Neumannová	Stolperstein		stolperstein in Prague	0
Stolperstein of Antonín Neumann	Stolperstein		stolperstein in Prague	0

End of automatically generated list.