Simpsons Dataset

January 7, 2018

I was looking for some fun data to use during a database class I’m teaching, so I compiled and connected various Simpsons data sources.

If you’re looking for a sample dataset, this might come in handy.

You can access it online and execute SQL commands in a web based client:
https://simpsons-database.herokuapp.com/

And you can download a zip of the database:
simpsons.zip (250k)

Inside the zip:

simpsons
├── simpsons-database.pdf
├── simpsons-database.png
├── simpsons-dump-from-postgres.sql
├── simpsons-dump-from-sqlite3.sql
├── simpsons.sqlite3
└── text
    ├── actors.txt
    ├── catchphrases.txt
    ├── episodes.txt
    ├── quotes.txt
    └── seasons.txt


This includes:

  • data as a .sql (dumped from sqlite and postgres)
  • data as a .sqlite3 file
  • data as flat text files
  • data modeling diagram (as png and pdf)

Enjoy!