Eurovision Festival Voting Dynamics by Kaggle | Politics and Governance

About this Dataset

Eurovision Festival Voting Dynamics

Country Interactions between 2002-2023

About this dataset

Voting has been a central part of the Eurovision Festival for over two decades. This dataset contains a comprehensive analysis of voting dynamics between countries that participated in the Eurovision Festival between 2002 and 2023. It includes key information such as country codes, vote values, types of votes given, songs performed by countries, and qualifications for the next round. By examining this dataset we can gain an in-depth understanding of voting dynamics among participating nations, uncovering trends and insights that could potentially shape future editions of Eurovision

More Datasets

For more datasets, click here.

Featured Notebooks

🚨 Your notebook can be here! 🚨!

How to use the dataset

This dataset provides a comprehensive analysis of voting dynamics between countries that are participating in the Eurovision Festival between 2002 and 2023. From this data, we can investigate which countries are most likely to vote for each other, as well as which types of votes (televote or jury) are helping each country to receive more points. We can also compare the results of individual festivals and identify any emerging trends in voting behavior over time.

This dataset contains several columns: edition_year, country_code_column, value, country_code_row, vote_type,country,years,songs,artists,places,points,and qualification. These columns should be used together in order to get an overall picture of a country’s voting patterns within the event. For example, a lookup of a particular edition year will provide information about which countries participated in that edition year, who gave out what votes and values for individual performances from other nations, as well as whether these performances scored enough points to qualify for the next round or not.. Additionally, an artist name or song title search allows us to identify trends and characteristics towards particular performers/tracks across editions when factoring in voter bias according to vote type (eg markings from juries V televote).

Additionally by looking at overall performance over multiple editions at once - we can use metrics such as ‘most voted’ nation per edition; ‘most popular performers’; ‘scores received by nation vs points given out by nation' etc - allows us to form inferences towards wider international opinion & identity public tastes concerning cultural expression & music at any given moment amongst our own citizens & foreigners alike - facilitating further understanding of how preferences 'move' along Nations over time too!.

In summary: you will be able aggregate various insights with this data set due its ability measure both qualitative( biased perceptions- eg jury v televote )& quantitative( numerical statistics- eg totals) elements from particular festivals/editions all in one place! Good luck mining your results!

Research Ideas

Analyzing voting patterns of countries in Eurovision Festivals over time to identify common factors or trends.

Examining how different countries’ votes affect each other and whether they are correlated with one another.

Investigating how points and rankings correlate with country popularity, geographical location, cultural similarities/differences, political alliances (e.g., members of the European Union) etc., to understand voting dynamics better across various Eurovision Festivals between 2002-2023

Acknowledgements

If you use this dataset in your research, please credit the original authors.
Data Source

License

License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: Votes_From_Scoreboard.csv

Column name	Description
edition_year	The year of the Eurovision Festival. (Integer)
country_code_column	The country code of the country giving the vote. (String)
value	The points awarded by the country giving the vote. (Integer)
country_code_row	The country code of the country receiving the vote. (String)
vote_type	The type of vote (jury or televote). (String)

File: Countries_Editions_Songs.csv

Column name	Description
country	The country participating in the Eurovision Festival. (String)
years	The year the Eurovision Festival took place. (Integer)
songs	The song performed by the country. (String)
artists	The artist performing the song. (String)
places	The placement of the country in the Eurovision Festival. (Integer)
points	The points awarded to the country by other countries. (Integer)
qualification	Whether the country qualified for subsequent rounds. (Boolean)

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit .

Tables

Countries

@kaggle.thedevastator_eurovision_festival_voting_dynamics.countries

2.85 KB
50 rows
2 columns


CREATE TABLE countries (
  "country_code" VARCHAR,
  "country_name" VARCHAR
);

Countries Editions Songs

@kaggle.thedevastator_eurovision_festival_voting_dynamics.countries_editions_songs

59.84 KB
1705 rows
7 columns


CREATE TABLE countries_editions_songs (
  "country" VARCHAR,
  "years" BIGINT,
  "songs" VARCHAR,
  "artists" VARCHAR,
  "places" VARCHAR,
  "points" VARCHAR,
  "qualification" VARCHAR
);

Odds Rate Table 2023

@kaggle.thedevastator_eurovision_festival_voting_dynamics.odds_rate_table_2023

7.24 KB
39 rows
9 columns


CREATE TABLE odds_rate_table_2023 (
  "country" VARCHAR,
  "winning_chance" VARCHAR,
  "betfair_sport" VARCHAR,
  "william_hill" VARCHAR,
  "sky_bet" VARCHAR,
  "smarkets" VARCHAR,
  "betway" VARCHAR,
  "betfair_exchange" VARCHAR,
  "scrapped_day" TIMESTAMP
);

Polled Eurovision 2022

@kaggle.thedevastator_eurovision_festival_voting_dynamics.polled_eurovision_2022

3.32 KB
40 rows
3 columns


CREATE TABLE polled_eurovision_2022 (
  "country" VARCHAR,
  "winrate" VARCHAR,
  "n_votes" BIGINT
);

Tweets Count With Eurovision Hashtag

@kaggle.thedevastator_eurovision_festival_voting_dynamics.tweets_count_with_eurovision_hashtag

5.54 KB
169 rows
3 columns


CREATE TABLE tweets_count_with_eurovision_hashtag (
  "end_timestamp" VARCHAR,
  "start_timestamp" VARCHAR,
  "tweet_count" BIGINT
);