datasets real and made-up data to practise on

Datasets

Data for the Playground, Database Lab and Performance Lab. Pick one and open its files.

dataset

size

A fictional film catalogue with users’ half-star ratings and free-text tags.

4,810 ratings6 tablesJan 2015 – Dec 2025

what to watch for

Tricky rows

files

Open a file to see what one row means, its columns and a preview. Open in Playground starts a new file there with code that loads it.

movies2,123 rows · 10 columns · CSV

One film. Titles can repeat across years (remakes).

In your code: data/movies.csv

genres18 rows · 2 columns · CSV

One genre.

In your code: data/genres.csv

movie_genres3,673 rows · 2 columns · CSV

A film belongs to one to three genres.

In your code: data/movie_genres.csv

users120 rows · 4 columns · CSV

One user account. Some users never rate anything.

In your code: data/users.csv

ratings4,810 rows · 4 columns · CSV

One user’s rating of one film (0.5 to 5 in half stars). A user rates a film at most once.

In your code: data/ratings.csv

tags91 rows · 4 columns · CSV

A free-text tag a user put on a film. Same idea, different spellings: "sci-fi", "Sci-Fi", "scifi".

In your code: data/tags.csv

relationships

How to join these tables. Left column matches the right column.