shaunhoang / eurovision-contest

Data scraping project to collect Eurovision Contestant information and overall rankings.

Eurovision Contest   🎤

The following project uses data from the Eurovision Song Contest site. Data was scraped using R and packages such as rvest and jsonlite. The resulting dataset represents information for all contestants for each year and by round (e.g. semi-final, final). It is important to note that changes in scoring system have occured through different points in time, e.g. semi-final rounds were not introduced until 2005.

About

Excerpt taken from Wikipedia:

The Eurovision Song Contest (French: Concours Eurovision de la chanson), sometimes abbreviated to ESC and often known simply as Eurovision, is an international songwriting competition organised annually by the European Broadcasting Union (EBU), featuring participants representing primarily European countries. Each participating country submits an original song to be performed on live television and radio, transmitted to national broadcasters via the EBU's Eurovision and Euroradio networks, with competing countries then casting votes for the other countries' songs to determine a winner.

Based on the Sanremo Music Festival held in Italy since 1951, Eurovision has been held annually since 1956 (apart from 2020), making it the longest-running annual international televised music competition and one of the world's longest-running television programmes. Active members of the EBU, as well as invited associate members, are eligible to compete, and as of 2022, 52 countries have participated at least once. Each participating broadcaster sends one original song of three minutes duration or less to be performed live by a singer or group of up to six people aged 16 or older. Each country awards two sets of 1–8, 10 and 12 points to their favourite songs, based on the views of an assembled group of music professionals and the country's viewing public, with the song receiving the most points declared the winner. Other performances feature alongside the competition, including a specially-commissioned opening and interval act and guest performances by musicians and other personalities, with past acts including Cirque du Soleil, Madonna and the first performance of Riverdance. Originally consisting of a single evening event, the contest has expanded as new countries joined (including countries outside of Europe, such as Australia), leading to the introduction of relegation procedures in the 1990s, and eventually the creation of semi-finals in the 2000s. As of 2022, Germany has competed more times than any other country, having participated in all but one edition, while Ireland holds the record for the most victories, with seven wins in total.

Data Dictionary

Data is available here. Short summary of fields in the dataset:

Field	Description
event	Event Name, e.g. Helsinki 2007
host_city	Host city name, e.g. Helsinki
host_country	Host city country, e.g. Finland
year	Event year, e.g. 2007
round	Round in contest, e.g. Semi-Final or Final
participant_name	Name of performer/participant
song	Song title name
participant_country	Participant country, e.g. Austria
running_order
total_points	Points
rank_ordinal	Numeric rank, e.g. 2
rank_ordinal	Ordinal rank, e.g. 2nd
qualified	Applicable to semi-final rounds only (TRUE or FALSE)
winner	Applicable to final & semi-final rounds (TRUE or FALSE)
partipant_link	Link to participant bio
event_link	Link to event