Wikidata

User:Data Gamer/Greek given names

< User:Data Gamer

Check

edit

All Greek names must have

  1. instance of (P31) -> male given name (Q12308941) or female given name (Q11879590). They must not have given name (Q202444) or unisex given name (Q3409032).
  2. language of work or name (P407) -> Greek (Q9129) (or/and Modern Greek (Q36510) or/and Ancient Greek (Q35497) or/and Cypriot Greek (Q245899))
  3. writing system (P282) -> Greek alphabet (Q8216)
  4. native label (P1705) -> something in el language
  1. Description in el: ανδρικό όνομα
  2. Description in en: male given name ()

The may also have: said to be the same as (P460), transliteration or transcription (P2440) and name day (P1750), given name version for other gender (P1560)

(For surnames family name identical to this given name (P1533))





Queries

edit

country of citizenship (P27) -> Cyprus (Q229) Greece (Q41) British Cyprus (Q15240466) 

SELECT ?gn ?gnLabel ?gnDescription ?ws ?nl (COUNT(DISTINCT ?item) as ?count) (SAMPLE(?item) as ?sample) (SAMPLE(?itemLabel) as ?sampleLabel) 
{
    VALUES ?countries { wd:Q229 wd:Q41 wd:Q15240466 }
    ?item wdt:P27 wd:Q229 .
    ?item wdt:P31 wd:Q5 .
    ?item wdt:P735 ?gn .
    OPTIONAL { ?gn wdt:P1705 ?nl }
    OPTIONAL { ?gn wdt:P282 / wdt:P506 ?ws }  
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?gn ?gnLabel ?gnDescription ?ws ?nl
ORDER BY DESC(?count) ?gn ?ws
Try it!

Έχει το όνομα Andreas (Q4926263) ενώ θα έπρεπε να έχει Andreas (Q87263878). 

SELECT ?item ?itemLabel ?wikipedia_article
{
    VALUES ?countries { wd:Q229 wd:Q41 wd:Q15240466 }
    ?item wdt:P27 ?countries .
    ?item wdt:P31 wd:Q5 .
    ?item wdt:P735 wd:Q87263878 .
    OPTIONAL { ?wikipedia_article schema:about ?item ; schema:isPartOf <https://en.wikipedia.org/> . }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Try it!

Others

edit

a) a query with all items that have given name (P735) -> a value that have writing system (P282) -> Greek alphabet (Q8216), but they don't have name in native language (P1559). For example, Nikolas Englezou (Q7036597) has given name (P735) -> Nikolas (Q97619413) which is an item that have writing system (P282) -> Greek alphabet (Q8216). Nikolas Englezou (Q7036597) has no name in native language (P1559) (in any language) so it must be in the results. 

SELECT ?item ?itemLabel ?givenname ?givennameLabel
WHERE
{
  ?item wdt:P735 ?givenname .
  ?givenname wdt:P282 wd:Q8216 . # writing system is Greek alphabet
  MINUS
  {
    ?item wdt:P1559 [] . # No name in native language
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],el,en" . }
}
Try it!

b) a query with all items that have given name (P735) -> a value that have writing system (P282) -> Greek alphabet (Q8216), and they have name in native language (P1559) in a language different that Greek. (for example they may have only one value with P1559 in English, or they may have two values with P1559: one in English and one in Greek). For example, Nikitas Tsakiroglou (Q12881733) has given name (P735) -> Nikitas (Q39292409) which is an item that have writing system (P282) -> Greek alphabet (Q8216). Nikitas Tsakiroglou (Q12881733) has name in native language (P1559) in a language that is not Greek. So it must be in the results. 

SELECT ?item ?itemLabel ?nativename (LANG(?nativename) AS ?language_code)
WHERE
{
  ?item wdt:P735 ?givenname .
  ?givenname wdt:P282 wd:Q8216 . # writing system is Greek alphabet
  ?item wdt:P1559 ?nativename .
  FILTER (LANG(?nativename) != "el")
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],el,en" . }
}
Try it!

c) a query with all items that country of citizenship (P27) -> Cyprus (Q229) or Greece (Q41) or British Cyprus (Q15240466) that have no given name (P735). It will be helpful if there is a column with P27 and a column with el label. 

SELECT ?q ?label ?country WHERE {
  VALUES ?country { wd:Q229 wd:Q41 wd:Q15240466 }
  ?q wdt:P27 ?country ; rdfs:label ?label .
  FILTER (lang(?label) = "el"). 
  MINUS { ?q wdt:P735 [] }
}
Try it!


[1] [2]

User:Data Gamer/Names with WP User:Data Gamer/Names with WP2

Retrieved from "https://www.wikidata.org/w/index.php?title=User:Data_Gamer/Greek_given_names&oldid=1314135990"