strictly-come-dancing-results

The Strictly Come Dancing Results Open Dataset

Contents

• Celebrities
• Professionals
• Results

Reading into a database - SQLite

Create data-source without headers

$ tail -n+2 results.csv > results_no_header.csv

-- Set up table
CREATE TABLE IF NOT EXISTS results (
    celebrity_id INTEGER,
    professional_id INTEGER,
    celebrity TEXT,
    professional TEXT,
    dance TEXT,
    song TEXT,
    series INTEGER,
    week INTEGER,
    running_order INTEGER,
    score_craig INTEGER,
    score_arlene INTEGER,
    score_len INTEGER,
    score_bruno INTEGER,
    score_alesha INTEGER,
    score_darcey INTEGER,
    score_jennifer INTEGER,
    score_donny INTEGER,
    score_shirley INTEGER,
    total INTEGER
);

-- Import data
.mode csv
.import results_no_header.csv results

Data

This data was initially sourced and collated from Ultimate Strictly (link to their excellent source page), manually sanitised and normalised, with additional data sourced from Wikipedia.