Wikidata

Wikidata:WikiProject Eurovision

All articles and data about Song contest Eurovision (and probably some smaller contests like dance contest).

 Info You can use AutoEdit tool to add quickly label and description on WikiProject Eurovision in many languages.

Main articles

edit
edit

Properties

edit

For editions

edit

All used qualifiers are listed (but some are ridiculous and are stroken).

Title ID Data type Description Examples Inverse
instance ofP31Iteminstance of: that class of which this subject is a particular example and member; different from P279 (subclass of); for example: K2 is an instance of mountain; volcano is a subclass of mountain (and an instance of volcanic landform)
Wikibase value = Eurovision Song Contest edition (Q110288240)		Eurovision Song Contest 2018 <instance of> Eurovision Song Contest edition-
part of the seriesP179Itemsequence, series of creative works, event sequence, book series, painting series, video game series and model series: series which contains the subject
Wikibase value = Eurovision Song Contest (Q276)
Wikidata qualifier = series ordinal (P1545), followed by (P156), follows (P155)		Eurovision Song Contest 2018 <part of the series> Eurovision Song Contest-
topic's main categoryP910ItemWikimedia category and category's main topic: main Wikimedia categoryEurovision Song Contest 2018 <topic's main category> Category:Eurovision Song Contest 2018category's main topic
Commons categoryP373StringCommons category: name of the Wikimedia Commons category containing files related to this item (without the prefix "Category:")Eurovision Song Contest 2018 <Commons category> -
locationP276Itemphysical location: location of the object, structure or event. In the case of an administrative entity as containing item use P131. For statistical entities use P8138. In the case of a geographic entity use P706. Use P7153 for locations associated with the object
Wikidata qualifier = official name (P1448), located in the administrative territorial entity (P131)		Eurovision Song Contest 2018 <location> MEO Arenacontains
point in timeP585Point in timepoint in time: date something took place, existed or a statement was true; for providing time use the "refine date" property (P4241)
May be multiple
Wikidata qualifier = end time (P582), start time (P580), applies to part (P518)		Eurovision Song Contest 2018 <point in time> 2018-
logo imageP154Commons media filelogo: graphic mark or emblem commonly used by commercial enterprises, organizations and productsEurovision Song Contest 2018 <logo image> ESC HONEY.svg-
imageP18Commons media fileillustration and image: image of relevant illustration of the subject; if available, also use more specific properties (sample: coat of arms image, locator map, flag image, signature image, logo image, collage image)
Preferrably of the hosts or the venue		Eurovision Song Contest 2018 <image> Eurovision 2018 Hosts.jpg-
motto textP1451Monolingual textmotto: short motivation sentence associated to itemEurovision Song Contest 2018 <motto text> "All Aboard!"-
presenterP371Itempresenter: main role in presenting a radio or television program or a performing arts show
Usually 2-4 humans
Wikidata qualifier = applies to part (P518)		Eurovision Song Contest 2018 <presenter> Filomena Cautela-
participantP710Itemparticipant: person, group of people or organization (object) that actively takes/took part in an event or process (subject). Preferably qualify with "object has role" (P3831). Use P1923 for participants that are teams.
Wikidata qualifier = depicts (P180), country (P17), number of points/goals/set scored (P1351), ranking (P1352), composer (P86), performer (P175), lyricist (P676), notable work (P800), native label (P1705), statement is subject of (P805)		Eurovision Song Contest 2018 <participant> ~40 participantsparticipant in
winnerP1346Itemwinner: winner of a competition or similar event, not to be used for awards (instead use "award received" (P166) on awardee's item, possibly qualified with "for work" (P1686)) or for wars or battles
Wikidata qualifier = country (P17), number of points/goals/set scored (P1351), ranking (P1352), lyricist (P676), performer (P175), composer (P86)		Eurovision Song Contest 2018 <winner> Netta Barzilai-
number of participantsP1132Quantitynumber of participants: number of participants of an event, e.g. people or groups of people that take part in the event (NO units)
Wikidata qualifier = applies to part (P518)		Eurovision Song Contest 2018 <number of participants> -
organizerP664Itemevent producer and impresario: person or institution organizing an event
Wikidata qualifier = short name (P1813)		Eurovision Song Contest 2018 <organizer> -
producerP162Itemproducer and dubbing producer: person(s) who produced the film, musical work, theatrical production, etc. (for film, this does not include executive producers, associate producers, etc.) [for production company, use P272, video games - use P178]Eurovision Song Contest 2018 <producer> -
executive producerP1431Itemexecutive producer: executive producer of a movie, TV show, or other piece of media or entertainment
Wikidata qualifier = production company (P272)		Eurovision Song Contest 2018 <executive producer> -
original broadcasterP449Itemtelevision channel and radio station: network(s) or service(s) that originally broadcast a radio or television programEurovision Song Contest 2018 <original broadcaster> -
capital costP2130Quantitycapital cost: amount of money spent on building or producing an object
Wikidata qualifier = title (P1476)		Eurovision Song Contest 2018 <capital cost> -

For countries

edit
Title ID Data type Description Examples Inverse
instance ofP31Iteminstance of: that class of which this subject is a particular example and member; different from P279 (subclass of); for example: K2 is an instance of mountain; volcano is a subclass of mountain (and an instance of volcanic landform)
Wikibase value = nation in the Eurovision Song Contest (Q35718073), Russia in the Eurovision Song Contest 2010 (Q2552034) and ~40 others
Wikidata qualifier = series ordinal (P1545), followed by (P156), follows (P155)		Russia in the Eurovision Song Contest 2010 <instance of> Russia in the Eurovision Song Contest-
subclass ofP279Itemsubclass of: this item is a subclass (subset) of that item; all instances of this item are instances of that item; different from P31 (instance of), e.g.: volcano is a subclass of mountain (and an instance of volcanic landform); Everest is an instance of mountainRussia in the Eurovision Song Contest <subclass of> nation in the Eurovision Song Contest-
countryP17Itemhistorical country, state and sovereign state: sovereign state that this item is in (not to be used for human beings)Israel in the Eurovision Song Contest 2018 <country> Israel-
participant inP1344Itemevent: event in which a person or organization was/is a participant; inverse of P710 or P1923Israel in the Eurovision Song Contest 2018 <participant in> Eurovision Song Contest 2018participant
part of the seriesP179Itemsequence, series of creative works, event sequence, book series, painting series, video game series and model series: series which contains the subject
Wikidata qualifier = followed by (P156), follows (P155)		Russia in the Eurovision Song Contest 2010 <part of the series> Russia in the Eurovision Song Contest-
topic's main categoryP910ItemWikimedia category and category's main topic: main Wikimedia categoryRussia in the Eurovision Song Contest <topic's main category> Category:Russia in the Eurovision Song Contestcategory's main topic
Commons categoryP373StringCommons category: name of the Wikimedia Commons category containing files related to this item (without the prefix "Category:")Israel in the Eurovision Song Contest 2018 <Commons category> Israel in the Eurovision Song Contest 2018-

National selections

edit
Title ID Data type Description Examples Inverse
instance ofP31Iteminstance of: that class of which this subject is a particular example and member; different from P279 (subclass of); for example: K2 is an instance of mountain; volcano is a subclass of mountain (and an instance of volcanic landform)
Wikibase value = Dansk Melodi Grand Prix (Q604109) and ~10 others
Wikidata qualifier = series ordinal (P1545), followed by (P156), follows (P155)		Q20524251 <instance of> Evrovizijska Melodija-
subclass ofP279Itemsubclass of: this item is a subclass (subset) of that item; all instances of this item are instances of that item; different from P31 (instance of), e.g.: volcano is a subclass of mountain (and an instance of volcanic landform); Everest is an instance of mountainNationaal Songfestival <subclass of> Eurovision Song Contest selection event-
countryP17Itemhistorical country, state and sovereign state: sovereign state that this item is in (not to be used for human beings)Q20524251 <country> Slovenia-
qualifies for eventP3085Itemthis event qualifies for that eventEMA 2021 <qualifies for event> Eurovision Song Contest 2021-
presenterP371Itempresenter: main role in presenting a radio or television program or a performing arts showEMA 2021 <presenter> Lea Sirk-
point in timeP585Point in timepoint in time: date something took place, existed or a statement was true; for providing time use the "refine date" property (P4241)EMA 2021 <point in time> 27.02.2021-
number of participantsP1132Quantitynumber of participants: number of participants of an event, e.g. people or groups of people that take part in the event (NO units)Q109417111 <number of participants> 10-
part of the seriesP179Itemsequence, series of creative works, event sequence, book series, painting series, video game series and model series: series which contains the subject
Wikidata qualifier = followed by (P156), follows (P155)		Sanremo Music Festival 2016 <part of the series> Sanremo Music Festival-
topic's main categoryP910ItemWikimedia category and category's main topic: main Wikimedia categorySöngvakeppni Sjónvarpsins <topic's main category> Category:Söngvakeppnincategory's main topic
Commons categoryP373StringCommons category: name of the Wikimedia Commons category containing files related to this item (without the prefix "Category:")Sanremo Music Festival <Commons category> Sanremo Music Festival-

For participants

edit

Only specific for Eurovision are listed.

property does not exist. Use "id=new" if it's to be created.

Title ID Data type Description Examples Inverse
instance ofP31Iteminstance of: that class of which this subject is a particular example and member; different from P279 (subclass of); for example: K2 is an instance of mountain; volcano is a subclass of mountain (and an instance of volcanic landform)
Wikibase value = human (Q5), musical ensemble (Q2088357) and its subclasses		Russia in the Eurovision Song Contest 2010 <instance of> Russia in the Eurovision Song Contest-
participant inP1344Itemevent: event in which a person or organization was/is a participant; inverse of P710 or P1923
Wikidata qualifier = followed by (P156), follows (P155), ranking (P1352), number of points/goals/set scored (P1351)		E.T. the Extra-Terrestrial <participant in> Eurovision Song Contest 2018participant

For songs

edit

Only specific for Eurovision are listed.

Title ID Data type Description Examples Inverse
titleP1476Monolingual textoriginal title and title: published name of a work, such as a newspaper article, a literary work, piece of music, a website, or a performance work
language = original language
Wikidata qualifier: ISO 9:1995 (P2183), transliteration or transcription (P2440)		Fuego <title> Fuego (Spanish)-
publication dateP577Point in timepublication date: date or point in time when a work was first published or released
Wikidata qualifier: place of publication (P291) (country, film festival, geographic region).		Fuego <publication date> 9.3.2018-
language of work or nameP407Itemlanguage: language associated with this creative work (such as books, shows, songs, broadcasts or websites) or a name (for persons use "native language" (P103) and "languages spoken, written or signed" (P1412))Fuego <language of work or name> English-
performerP175Itemperforming artist, music artist, musician, musical group, musical ensemble, singer, various artists, actor, artist, actress, by performer and voice actor: actor, musician, band or other performer associated with this role or musical workFuego <performer> Eleni Foureiracharacter role
durationP2047Quantityduration: length of time of an event or processFuego <duration> 183 (s)-
genreP136Itemgenre, by genre and award for best album (genre): creative work's genre or an artist's field of work (P101). Use main subject (P921) to relate creative works to their topicFuego <genre> Europop-

Subpages

edit

Useful queries

edit

Informational

edit

Information about all events per year

edit

The following query uses these:

Try it!

Compact information about current event (maintenance needed)

edit

The following query uses these:

  • Properties: part of the series (P179)     , point in time (P585)     , participant in (P1344)     , part of (P361)     , instance of (P31)     , country (P17)     , country of origin (P495)     , performer (P175)     
    #title: Countries, songs and participants at Eurovision 2024
SELECT distinct ?countryLabel ?item ?itemLabel ?song ?songLabel ?performer ?performerLabel WHERE
{
  ?euro wdt:P179 wd:Q276; wdt:P585 ?time. FILTER (YEAR(?time)=2024).
  ?item wdt:P1344|wdt:P361 ?euro.
  ?item wdt:P31 wd:Q35718073.
  ?item wdt:P17|wdt:P495 ?country. #use this when there are links froms songs to country
#  OPTIONAL {?item wdt:P17 ?country.} OPTIONAL {?item wdt:P495 ?country.} #use this for all (but wrong) combinations
  
  ?song wdt:P175 ?performer.
  ?song wdt:P495 ?country.
  ?song wdt:P1344 ?euro.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "ru,[AUTO_LANGUAGE],en". }
  }
ORDER BY ?countryLabel
Countries, songs and participants at Eurovision 2024

Songs of current event

edit

The following query uses these:

  • Properties: part of the series (P179)     , point in time (P585)     , instance of (P31)     , participant in (P1344)     , title (P1476)     , performer (P175)     , country of origin (P495)     , language of work or name (P407)     , composer (P86)     , lyricist (P676)     , genre (P136)     , publication date (P577)     , inception (P571)     , duration (P2047)     
    #title: Songs with all info
SELECT ?song 
(GROUP_CONCAT(DISTINCT(?songName); separator=" / ") as ?names)
?songLabel ?songDescription
(GROUP_CONCAT(DISTINCT(?countryLabel); separator=" + ") as ?countries)
(GROUP_CONCAT(DISTINCT(?langLabel); separator=" + ") as ?langs)
# ?performer ?performerLabel # several lines if several performers of the song
#or use this line for combined label:
(GROUP_CONCAT(DISTINCT(?performerLabel); separator=" + ") as ?performers)
(GROUP_CONCAT(DISTINCT(?composerLabel); separator="; ") as ?composers)
(GROUP_CONCAT(DISTINCT(?poetLabel); separator="; ") as ?poets) 
(GROUP_CONCAT(DISTINCT(?genreLabel); separator=", ") as ?genres) 
?pub ?creat ?length
WHERE
{
  SELECT ?song ?songName ?songLabel ?songDescription ?countryLabel ?langLabel ?performer ?performerLabel ?composerLabel ?poetLabel ?genreLabel ?pub ?creat ?length WHERE {
  ?euro wdt:P179 wd:Q276; wdt:P585 ?time. FILTER (YEAR(?time)=2024).
  VALUES ?format {wd:Q7366 wd:Q134556 wd:Q105543609}
  ?song wdt:P31 ?format.
  ?song wdt:P1344 ?euro.
  OPTIONAL {?song wdt:P1476 ?songName.}
  OPTIONAL {?song wdt:P175 ?performer.}
  OPTIONAL {?song wdt:P495 ?country.}
  OPTIONAL {?song wdt:P407 ?lang.}
  OPTIONAL {?song wdt:P86 ?composer.}
  OPTIONAL {?song wdt:P676 ?poet.}
  OPTIONAL {?song wdt:P136 ?genre.}
  OPTIONAL {?song wdt:P577 ?pub.}
  OPTIONAL {?song wdt:P571 ?creat.}
  OPTIONAL {?song wdt:P2047 ?length.}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
 }
GROUP BY ?song ?songLabel ?songDescription ?pub ?creat ?length
ORDER BY ?names
Songs with all info

Performers of current event

edit

The following query uses these:

Participants (groups and singers) at Eurovision 2024

National pre-selections and country participations

edit

The following query uses these:

  • Properties: instance of (P31)     , part of the series (P179)     , point in time (P585)     
    #title: All national pre-selections for Eurovision
SELECT ?item ?itemLabel ?partOf ?partOfLabel ?year WHERE {
  ?item wdt:P31|wdt:P179 ?partOf.
  ?partOf wdt:P31 wd:Q62584801.
  OPTIONAL {?item wdt:P585 ?year}
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?year
All national pre-selections for Eurovision

The following query uses these:

  • Properties: instance of (P31)     , country (P17)     , country of origin (P495)     , part of the series (P179)     
    #title: Classes of national pre-selections for Eurovision
SELECT distinct ?item ?itemLabel ?stateLabel (COUNT(?inst) AS ?cnt) WHERE {
  ?item (wdt:P31) wd:Q62584801 .
  OPTIONAL {?item wdt:P17|wdt:P495 ?state}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],ru,en"  }
  OPTIONAL {?inst wdt:P31|wdt:P179 ?item}
}
GROUP BY ?item ?itemLabel ?stateLabel
Classes of national pre-selections for Eurovision

Example tabular collaborative work for EMAs:

Not to be mix with participation at Eurovision:

Requested queries

edit
  • Image gallery of winning performers, ordered by the year that they won
  • Table of rankings and points for the final in a particular year
  • Bubble chart showing how many times each country has won the contest
  • Count of how many songs have been entered by each performer
  • For all countries, the highest ranking they have ever retrieved in the (final of the) contest

Maintenance

edit

All participations of all countries

edit 
SELECT distinct ?item ?itemLabel ?seqLabel ?eventLabel ?classLabel ?wholeLabel WHERE
{
  ?item wdt:P31/wdt:P279* wd:Q35718073.
  ?item wdt:P31 ?class.
  OPTIONAL {?item wdt:P1344 ?event.}
  OPTIONAL {?item wdt:P179 ?seq.}
  OPTIONAL {?item wdt:P361 ?whole.}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it! 
# All items linked to the current event
SELECT distinct ?item ?itemLabel ?connection ?seqLabel ?eventLabel ?classLabel ?wholeLabel WHERE
{
  ?item ?p wd:Q107599005.
  ?property ?ref ?p .
  ?property rdf:type wikibase:Property .
  ?property rdfs:label ?connection FILTER (lang(?connection) = "ru") 
  ?item wdt:P31 ?class.
  OPTIONAL {?item wdt:P1344 ?event.}
  OPTIONAL {?item wdt:P179 ?seq.}
  OPTIONAL {?item wdt:P361 ?whole.}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!

All national pre-selections for Eurovision

edit

A national pre-selection for Eurovision (local contest and TV program, with its own history and participants) should be separated from "country at Eurovision" (includes info about final attendance) so this list should be empty: 

#title: National pre-selections for Eurovision which are conflated with "country at Eurovision"
SELECT ?item ?itemLabel ?partOf ?partOfLabel ?year WHERE {
  ?item wdt:P31|wdt:P179 ?partOf.
  ?partOf wdt:P279 wd:Q62584801.
  ?item wdt:P31/wdt:P279* wd:Q35718073.
  OPTIONAL {?item wdt:P585 ?year}
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?year
National pre-selections for Eurovision which are conflated with "country at Eurovision"

result

Property discussions

edit

Participants

edit

The participants listed below can be notified using the following template in discussions:
{{Ping project|Eurovision}}

Retrieved from "https://www.wikidata.org/w/index.php?title=Wikidata:WikiProject_Eurovision&oldid=2178593975"