Dataset

tmdb

Tables: 1
File: tmdb.db
Path: db/tmdb.db
Size: 778.34 MB

movies

25 columns · 4 sample rows

Create SQL

CREATE TABLE movies (
    id INTEGER PRIMARY KEY,
    title TEXT NOT NULL,
    vote_average REAL,
    vote_count INTEGER,
    status TEXT,
    release_date TEXT, -- Stored as ISO8601 string YYYY-MM-DD
    revenue INTEGER,
    runtime INTEGER,
    adult BOOLEAN,
    backdrop_path TEXT,
    budget INTEGER,
    homepage TEXT,
    imdb_id TEXT,
    original_language TEXT,
    original_title TEXT,
    overview TEXT,
    popularity REAL,
    poster_path TEXT,
    tagline TEXT,
    genres TEXT, -- Stored as JSON string or comma-separated
    production_companies TEXT, -- Stored as JSON string or comma-separated
    production_countries TEXT, -- Stored as JSON string or comma-separated
    spoken_languages TEXT, -- Stored as JSON string or comma-separated
    keywords TEXT, -- Stored as JSON string or comma-separated
    -- Metadata
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)

Columns

Name	Type	Not Null	Default	PK
id	INTEGER	false	—	true
title	TEXT	true	—	false
vote_average	REAL	false	—	false
vote_count	INTEGER	false	—	false
status	TEXT	false	—	false
release_date	TEXT	false	—	false
revenue	INTEGER	false	—	false
runtime	INTEGER	false	—	false
adult	BOOLEAN	false	—	false
backdrop_path	TEXT	false	—	false
budget	INTEGER	false	—	false
homepage	TEXT	false	—	false
imdb_id	TEXT	false	—	false
original_language	TEXT	false	—	false
original_title	TEXT	false	—	false
overview	TEXT	false	—	false
popularity	REAL	false	—	false
poster_path	TEXT	false	—	false
tagline	TEXT	false	—	false
genres	TEXT	false	—	false
production_companies	TEXT	false	—	false
production_countries	TEXT	false	—	false
spoken_languages	TEXT	false	—	false
keywords	TEXT	false	—	false
created_at	TIMESTAMP	false	CURRENT_TIMESTAMP	false

Sample Data

id	title	vote_average	vote_count	status	release_date	revenue	runtime	backdrop_path	budget	homepage	imdb_id	original_language	original_title	overview	popularity	poster_path	tagline	genres	production_companies	production_countries	spoken_languages	keywords	created_at
2	Ariel	7.1	262	Released	1988-10-21	0	73	/dQL2wJZo05GDd21VgOacMeCuyZy.jpg	0	null	tt0094675	fi	Ariel	After the coal mine he works at closes and his father commits suicide, a Finnish man leaves for the city to make a living but there, he is framed and imprisoned for various crimes.	8.155	/ojDg0PGvs6R9xYFodRct2kdI6wC.jpg	null	Drama, Comedy, Romance	Villealfa Filmproductions	Finland	Finnish	["prison","underdog","helsinki","finland","factory worker","prisoner","falling in love"]	2026-01-25 19:02:17
3	Shadows in Paradise	7.199	281	Released	1986-10-17	0	74	/l94l89eMmFKh7na2a1u5q67VgNx.jpg	0	null	tt0092149	fi	Varjoja paratiisissa	Nikander, a rubbish collector and would-be entrepreneur finds his plans for success dashed when his business associate dies. One evening, he meets Ilona, a down-on-her luck cashier in a local supermarket—and, falteringly, a bond begins to d…	5.946	/nj01hspawPof0mJmlgfjuLyJuRN.jpg	null	Drama, Comedy, Romance	Villealfa Filmproductions	Finland	English, Finnish, Swedish	["helsinki","finland","salesclerk","garbage"]	2026-01-25 19:02:17
5	Four Rooms	5.784	2436	Released	1995-12-09	4257354	98	/f2t4JbUvQIjUF5FstG1zZFAp02N.jpg	4000000	https://www.miramax.com/movie/four-rooms/	tt0113101	en	Four Rooms	It's Ted the Bellhop's first night on the job...and the hotel's very unusual guests are about to place him in some outrageous predicaments. It seems that this evening's room service is serving up one unbelievable happening after another.	15.295	/75aHn1NOYXh4M7L5shoeQ6NGykP.jpg	Twelve outrageous guests. Four scandalous requests. And one lone bellhop, in his first day on the job, who's in for the wildest New year's Eve of his life.	Comedy	Miramax, A Band Apart	United States of America	English	["hotel","new year's eve","witch","bet","sperm","hotel room","anthology","los angeles","california","hoodlum","multiple storylines","woman director"]	2026-01-25 19:02:17
6	Judgment Night	6.533	302	Released	1993-10-15	12136938	109	/bGMqHn0H2UY6SPZ5Vch4YJM2jDO.jpg	21000000	null	tt0107286	en	Judgment Night	While racing to a boxing match, Frank, Mike, John and Rey get more than they bargained for. A wrong turn lands them directly in the path of Fallon, a vicious, wise-cracking drug lord. After accidentally witnessing Fallon murder a disloyal h…	13.564	/3rvvpS9YPM5HB2f4HYiNiJVtdam.jpg	Don't move. Don't whisper. Don't even breathe.	Action, Crime, Thriller	Largo Entertainment, JVC	United States of America	English	["drug dealer","chicago","illinois","escape","one night","boxing"]	2026-01-25 19:02:17