Wikidata:WikiProject Eurovision

From Wikidata
Jump to navigation Jump to search

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]

Other articles[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 and video game 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 Arena-
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 textshort 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), lyrics by (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), lyrics by (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: 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 or TV show
Wikidata qualifier = production company (P272)
Eurovision Song Contest 2018 <executive producer> -
original broadcasterP449Itemtelevision channel: network(s) or service(s) that originally broadcast a radio or television programEurovision Song Contest 2018 <original broadcaster> -
costP2130Quantitycost: amount of money spent on building or producing an object
Wikidata qualifier = title (P1476)
Eurovision Song Contest 2018 <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.: K2 is an instance of mountain; volcano is a subclass of mountain (and an instance of volcanic landform)Russia in the Eurovision Song Contest <subclass of> nation in the Eurovision Song Contest-
countryP17Itemcountry: 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 and video game 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.: K2 is an instance of mountain; volcano is a subclass of mountain (and an instance of volcanic landform)Nationaal Songfestival <subclass of> Eurovision Song Contest selection event-
countryP17Itemcountry: 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 and video game 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 and by 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:

Compact information about current event (maintenance needed)[edit]

The following query uses these:

  • Properties: part of the series (P179)  View with Reasonator View with SQID, point in time (P585)  View with Reasonator View with SQID, participant in (P1344)  View with Reasonator View with SQID, part of (P361)  View with Reasonator View with SQID, instance of (P31)  View with Reasonator View with SQID, country (P17)  View with Reasonator View with SQID, country of origin (P495)  View with Reasonator View with SQID, performer (P175)  View with Reasonator View with SQID
    #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
    

Songs of current event[edit]

The following query uses these:

  • Properties: part of the series (P179)  View with Reasonator View with SQID, point in time (P585)  View with Reasonator View with SQID, instance of (P31)  View with Reasonator View with SQID, participant in (P1344)  View with Reasonator View with SQID, title (P1476)  View with Reasonator View with SQID, performer (P175)  View with Reasonator View with SQID, country of origin (P495)  View with Reasonator View with SQID, language of work or name (P407)  View with Reasonator View with SQID, composer (P86)  View with Reasonator View with SQID, lyrics by (P676)  View with Reasonator View with SQID, genre (P136)  View with Reasonator View with SQID, publication date (P577)  View with Reasonator View with SQID, inception (P571)  View with Reasonator View with SQID, duration (P2047)  View with Reasonator View with SQID
    #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
    

Performers of current event[edit]

The following query uses these:

National pre-selections and country participations[edit]

The following query uses these:

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

The following query uses these:

  • Properties: subclass of (P279)  View with Reasonator View with SQID, country (P17)  View with Reasonator View with SQID, country of origin (P495)  View with Reasonator View with SQID, instance of (P31)  View with Reasonator View with SQID, part of the series (P179)  View with Reasonator View with SQID
    #title: Classes of national pre-selections for Eurovision
    SELECT distinct ?item ?itemLabel ?stateLabel (COUNT(?inst) AS ?cnt) WHERE {
      ?item (wdt:P279) 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
    

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]

[+] Add yourself to the list

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