Wikidata:WikiProject Czech Republic/Maintenance Queries
Jump to navigation
Jump to search
Try it!
Try it!
Try it!
Try it!
Try it!
|
|
Missing images
[edit]# 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" } .
}
Also works with "WikiData Free Image Search Tool": [1]
Items without statements
[edit]Duplicates of monument IDs
[edit]- 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)
}
Missing articles on cswiki
[edit]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)
Possible duplicates with zanikleobce.cz abandoned objects ID (P3003)
[edit]#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
Possible duplicates with sv/cebwiki articles
[edit]#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
New Czech persons
[edit]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 changeslabel | Gender | Given name | Date of birth | occupation | NKCR | abart | csfd | orcid | discogs | description | Sitelinks |
---|---|---|---|---|---|---|---|---|---|---|---|
Robert Alger | male | Robert | 1968 | sculptor | Czech-American sculptor | 1 | |||||
Aleš Jirátko | male | Ales | gynaecologist | xx0098874 | M.D., private gynecologist | 0 | |||||
Igor Jíra | male | Igor | head of department | xx0098872 | MUDr., radiodiagnostician (in 1991-92 head of the Department of Paediatric Radiology of the University Hospital in Brno). Former director of the University Children's Hospital in Brno. | 0 | |||||
Pavel Jinoch | male | Pavel | hematologist | xx0098871 | MUDr., hematologist (IHBT - coagulation laboratory), director of VIDIA. He publishes in the field | 0 | |||||
Bogna Jiravská Godula | female | Bogna | internist | xx0098868 | M.D., internist, sports doctor (Sports Outpatient Clinic of Podlesí Hospital). | 0 | |||||
Miroslav Jíra | male | Miroslav | researcher | xx0098865 | MUDr., Mgr., PhD, research and development worker (Institute of Physiology, Faculty of Medicine, Masaryk University, Brno). | 0 | |||||
Jitka Jindřišková | female | Jitka | nurse | xx0098864 | Nurse (Department of Orthopaedics and Traumatology, University Hospital Královské Vinohrady, Prague) | 0 | |||||
Zuzana Jindráková | female | Zuzana | biologist | xx0098863 | Mgr., biologist. Graduate of the Faculty of Science, Charles University, Department of Genetics and Microbiology | 0 | |||||
František Jimramovský | male | František | pediatrician | xx0098862 | MUDr., paediatrician - specialist in gastroenterology and nutrition, head of the children's department of the Boskovice Hospital. He publishes in the field | 0 | |||||
Hana Jirků | female | Hana | nurse | xx0098860 | Bc. Head nurse of the Spinal Unit at the Motol-Prague University Hospital. He publishes in nursing | 0 | |||||
Libor Jindrák | male | Libor | writer | xx0098859 | Publications in the field of parasitology (formerly: Institute of Parasitology of the Czech Academy of Sciences, České Budějovice) | 0 | |||||
Hana Jičínská | female | Hana | pediatrician | xx0098856 | MUDr., paediatrician, cardiologist at the Second Children's Clinic of the University Hospital Brno | 0 | |||||
Tomáš Tulinger | male | Tomas | university teacher | xx0098849 | Mgr., teacher, editor and translator from English | 0 | |||||
Martin Kmínek | male | Martin | translator | xx0098848 | Translator from English | 0 | |||||
Š. Vladařová | female | nurse | Nurse (1st Department of Internal Medicine, University Hospital and Faculty of Medicine, Palacký University, Olomouc). Author of articles in the fields of nursing and internal medicine | 0 | |||||||
Andrea Šipková | female | Andrea | nurse | xx0098840 | DiS., nurse (3rd Department of Internal Medicine - Department of Endocrinology and Metabolism, 1st Faculty of Medicine, Charles University and General Teaching Hospital, Prague). Author of articles in the field of nursing and internal medicine | 0 | |||||
Markéta Řehová | female | Markéta | nurse | xx0098819 | Bc., nurse (3rd Department of Internal Medicine, General Teaching Hospital and 1st Faculty of Medicine, Charles University, Prague). Author of articles on the harmfulness of tobacco | 0 | |||||
Dušan Zábrodský | male | Dušan | writer | xx0098814 | Czech author of publications from the textile industry | 0 | |||||
K. Tinl | writer | xx0098811 | Author of a publication in the field of agriculture | 0 | |||||||
Jan Jetmar | male | Jan | translator | xx0098808 | Translator of publications from Spanish | 0 | |||||
S. Hauser | writer | xx0098807 | Author of publications in the field of pedagogy and pioneer organization | 0 | |||||||
František Šmíd | male | František | writer | xx0098806 | Co-author of a publication on occupational safety | 0 | |||||
Josef Pezinek | male | Josef | writer | xx0098805 | Co-author of a publication on occupational safety | 0 | |||||
Josef Šulc | male | Josef | writer | xx0098803 | Co-author of a publication on occupational safety | 0 | |||||
J. Jirásek | writer | xx0098802 | Author of publications in the field of mechanical engineering | 0 | |||||||
Josef Dittert | male | Josef | writer | xx0098801 | Ing., author of publications in mechanical engineering | 0 | |||||
Jitka Otrubová | female | Jitka | writer | xx0098796 | Author of publications in healthcare | 0 | |||||
František Vosyka | male | František | writer | xx0098790 | Author of publications in the field of geology | 0 | |||||
Milada Grossmannová | female | Milada | writer | xx0098789 | Author of publications in the field of geology | 0 | |||||
Ilona Benušová | female | Ilona | nurse | Preventive Cardiology Nurse (1st Internal Clinic, University Hospital and Faculty of Medicine, Palacký University, Olomouc) | 0 | ||||||
Boris Moravec ml. | male | Boris | 1950-02-14 | production designer | 0 | ||||||
Adolf Šádek | male | Adolf | 1975-03-04 | entrepreneur | 0 | ||||||
David Parish | male | David Anthony |
1963-05-12 | (* 1963) Canadian-Czech entrepreneur | 1 | ||||||
Karel Pacovský | male | Karel | historian | pna20211121670 | Czech historian and translator | 0 | |||||
Igor Kisch | Igor | 1954-03-01 1954 |
politician physician official |
1 | |||||||
Julie Paštiková | female | Julie | 2008-05-31 | tennis player | czech tennis player | 1 | |||||
Oliver Velich | male | Oliver | 2001-06-17 | association football player | Czech footballer | 0 | |||||
Xnapy | male | Petr | 1996 | online streamer YouTuber pundit professional gamer |
1 | ||||||
Roman Miesler | male | Roman | writer | mzk2005309253 | Author of works on bird breeding | 0 | |||||
Aleš Kolář | male | Ales | cyberneticist | mzk2005309250 | MSc., thesis in the field of applied cybernetics | 0 | |||||
Marie Kalivodová | female | Marie | programmer | mzk2005309249 | Programmer, thesis on programming languages | 0 | |||||
Irča Drápalová-Kulišťáková | female | local historian | mzk2005309235 | Regional historian of the Rožnov region | 0 | ||||||
Bohumila Slováková | female | Bohumila | poet | mzk2005309225 | Poetess, bibliophile editions of poetry | 0 | |||||
Stanislav Palička | male | Stanislav | docent | mzk2005309196 | MSc. in economics, university lecturer, professional works in financial mathematics | 0 | |||||
Jiří Maršík | male | Jiří | writer | mzk2005309193 | Author of books of cooking recipes | 0 | |||||
Pavel Kaňovský | male | Pavel | nuclear engineer | mzk2005309187 | Ing., professional work in nuclear energy | 0 | |||||
Ivan Kolomazník | male | Ivan | mathematician | mzk2005309178 | Doc., Dr., Mgr., mathematician, university lecturer, work in the field of mathematics and computer technology | 0 | |||||
Helena Klečková | female | Helena | publisher | mzk2005309163 | Publisher Editor | 0 | |||||
Aleš Varga | male | Ales | writer | mzk2005309162 | Author of textbooks for professional German | 0 | |||||
Vilém Vostal | male | Vilém | 2005-03-10 | sport cyclist | Czech cyclist | 0 | |||||
Tomáš Novák | male | Tomáš | 2005-02-17 | sport cyclist | Czech cyclist | 0 | |||||
Miroslav Pýcha | male | 0 | |||||||||
Tomáš Podivinský | male | 2005-02-04 | student | 0 | |||||||
Tomáš Podivinský | male | 1973-12-04 | chief executive officer manager |
0 | |||||||
David Hofmann | male | David | cinematographer | 0 | |||||||
Lukas Fischer | male | 2006-09-09 | ice hockey player | Czech-American ice hockey player | 0 | ||||||
Dominik Badinka | male | 2005-11-27 | ice hockey player | Czech ice hockey player | 1 | ||||||
Adam Jecho | male | 2006-03-24 | ice hockey player | Czech ice hockey player | 0 | ||||||
Jakub Fibigr | male | 2006-07-22 | ice hockey player | Czech ice hockey player | 0 | ||||||
Jakub Milota | male | 2006-04-14 | ice hockey player | Czech ice hockey player | 0 | ||||||
Maxmilian Curran | male | 2006-08-27 | ice hockey player | Czech ice hockey player | 0 | ||||||
Tomas Järvinen | male | 2005-10-21 | decathlete | Czech-Finnish decathlete | 0 | ||||||
Pierre Fontane | male | pornographic actor | Czech pornographic actor and adult model | 0 | |||||||
Yannis Paluan | male | Vojtěch | 1997-04-10 | bodybuilder pornographic actor webcam model |
Czech bodybuilder, pornographic actor, adult and webcam model | 0 | |||||
Jiří Mikula | male | Jiří | film editor | 206731 | 0 | ||||||
Petr Příkaský | male | Petr | cinematographer | 145990 | 0 | ||||||
Simon Štekl | male | Simon | 1977-07-26 | manager businessperson |
Czech businessman | 0 | |||||
Liam Efron | male | 1996-08-08 | pornographic actor | Czech Pornographic actor | 0 | ||||||
Jarrod Lanvin | male | Martin | 1997-09-09 | pornographic actor | Czech Pornographic actor | 0 | |||||
Bjorn Nkyvist | male | 1996-10-31 | pornographic actor | Czech Pornographic actor | 0 | ||||||
Adolf Řepa | male | Adolf | 1896-06-23 | teamster Czechoslovak legionary |
0 | ||||||
Ignác Houška | male | Ignác | 1914-01-24 | official resistance fighter |
0 | ||||||
Jiří Šustera | male | Jiří | drummer | 0 | |||||||
Ivan Lytvynov | male | 2000-07-12 | ice hockey player | Ukrainian-Czech ice hockey player | 0 | ||||||
Eva Vyplelová | female | Eva | 1946-12-24 | make-up artist wigmaker hairdresser |
0 | ||||||
Niko Vangelis | male | Martin | 1996-05-25 | pornographic actor | Czech Pornographic actor | 0 | |||||
Roman West | male | Roman | 1981-09-16 | association football coach | Czech football coach | 0 | |||||
Martin Tučka | male | Martin | 1980-11-15 | mountaineer official |
jo20241229616 | Czech mountaineer and government official | 0 | ||||
Denisa Tomanová | female | Denisa | journalist translator |
French-speaking Czech journalist | 0 | ||||||
Jana Milec Jiřincová | female | Jana | 1986-09-16 | sport cyclist | 0 | ||||||
Daniel Gracík | male | Daniel | 2004-10-15 | swimmer | 3 | ||||||
Emiliia Okhrymovych-Holubovska | female | Emiliya | 1903-05-30 | painter | Ukrainian artist of decorative and applied arts | 2 | |||||
Tomáš Plhoň | male | 1986 | actor | 63062 | 1 | ||||||
Magdaléna Jehlářová | female | Magdaléna | 2000-01-16 | volleyball player | 1 | ||||||
Helena Tavelová | female | Helena | costume designer | 364150 | 0 | ||||||
Ondřej Šošolík | male | Ondřej | 1983-10-15 | film editor | 268305 | 0 | |||||
Valentyna Kukova | female | show jumper | 0 | ||||||||
Ilona Sinzelle Poňavičová | female | Ilona | linguist librarian language teacher translator |
Czech linguist | 0 | ||||||
Martina Exnerová | female | Martina | 2001-06-16 | ice hockey player | Czech ice hockey player | 0 | |||||
Štěpánka Eibinová | female | Štěpánka | 1994-07-26 | ice hockey player | Czech ice hockey player | 0 | |||||
David Homer | male | 1993-10-30 | ice hockey player | Czech ice hockey player | 1 | ||||||
Jan Vybíral | male | Jan | entomologist | Czech entomologist | 1 | ||||||
Ondra Taryk | male | Daniel | 1993-02-17 | pornographic actor erotic photography model |
Czech pornographic actor, CrossFit athlete, webcam and adult model. | 0 | |||||
Jana Václavíková | female | journalist | journalist in the Czech Republic | 0 | |||||||
Edita Chrápavá | female | Edita | 1999-04-03 | swimmer | Czech swimmer | 0 | |||||
Jan Vianney Dohnal | male | Jan | 1955-10-13 | Latin Catholic priest religious |
1 | ||||||
Milan Pastrňák | male | Milan | 1961-12-09 | ice hockey player | Czech ice hockey player | 0 | |||||
Michal Renok | male | pornographic actor | Czech pornographic actor | 0 | |||||||
Denny Chriss | male | Dalibor | 1983-01-24 | pornographic actor disc jockey erotic photography model |
Czech pornographic actor, disc jockey and adult model | 0 | |||||
Viktorie Bulínová | female | Viktorie | 1998-04-21 | Thai boxer kickboxer |
Czech Muay Thai kickboxer | 1 |
End of automatically generated list.
New Czech entities
[edit]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 changesEnd of automatically generated list.