BAFTA Scripted Comedy Awards: Winners & Nominees (2016–2025)

1. Business Question

Which scripted comedies have dominated the BAFTAs over the last decade?

I built an end-to-end pipeline in Python, SQL and APIs to go from a Wikipedia page to the final poster montage:

Scraping BAFTA data
- Pulled the “British Academy Television Award for Best Scripted Comedy” page with requests + BeautifulSoup.
- Parsed out year, show title and nominee vs. winner tags.
- Saved the raw table to CSV for sanity checks.
IMDB ID matching & database ingestion
- Loaded that CSV into a staging table in my local IMDb SQL Server.
- Used a small Python script (pandas + fuzzywuzzy) to match show titles to IMDb tconst IDs.
- Populated a bafta_comedy_awards table with awardyear, bafta_status and tconst.
Metadata enrichment via TMDb
- For each tconst, called TMDb’s “find” endpoint to get the poster_path.
- Downloaded the “original”-size poster images from TMDb’s CDN.
- Cached metadata (title, dimensions, poster URL) in a JSON file.
Visualization
- Wrote a Python script using Pillow (and matplotlib) to layout a two-row montage: winners large on left, nominees stacked to the right.
- Overlaid each poster with a hollow “year” label, keeping text legible and titles uncut.
- Produced both a high-resolution PNG and a mobile-optimized JPEG.

Full SQL → scripts/last_10_Bafta_scripted_comedy_winner.sql

BAFTA Scripted Comedy Awards Montage

Code & write-up: MIT
Data & images: