film
1,000 rows where language_id = 1
This data as json, xlsx, CSV (advanced)
Suggested facets: rental_duration, rental_rate, replacement_cost, rating, special_features, last_update, last_update (date)
| film_id ▼ | title | description | release_year | language_id | original_language_id | rental_duration | rental_rate | length | replacement_cost | rating | special_features | last_update |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ACADEMY DINOSAUR | A Epic Drama of a Feminist And a Mad Scientist who must Battle a Teacher in The Canadian Rockies | 2006 | English 1 | 6 | 0.99 | 86 | 20.99 | PG | Deleted Scenes,Behind the Scenes | 2020-12-23 07:12:31 | |
| 2 | ACE GOLDFINGER | A Astounding Epistle of a Database Administrator And a Explorer who must Find a Car in Ancient China | 2006 | English 1 | 3 | 4.99 | 48 | 12.99 | G | Trailers,Deleted Scenes | 2020-12-23 07:12:31 | |
| 3 | ADAPTATION HOLES | A Astounding Reflection of a Lumberjack And a Car who must Sink a Lumberjack in A Baloon Factory | 2006 | English 1 | 7 | 2.99 | 50 | 18.99 | NC-17 | Trailers,Deleted Scenes | 2020-12-23 07:12:31 | |
| 4 | AFFAIR PREJUDICE | A Fanciful Documentary of a Frisbee And a Lumberjack who must Chase a Monkey in A Shark Tank | 2006 | English 1 | 5 | 2.99 | 117 | 26.99 | G | Commentaries,Behind the Scenes | 2020-12-23 07:12:31 | |
| 5 | AFRICAN EGG | A Fast-Paced Documentary of a Pastry Chef And a Dentist who must Pursue a Forensic Psychologist in The Gulf of Mexico | 2006 | English 1 | 6 | 2.99 | 130 | 22.99 | G | Deleted Scenes | 2020-12-23 07:12:31 | |
| 6 | AGENT TRUMAN | A Intrepid Panorama of a Robot And a Boy who must Escape a Sumo Wrestler in Ancient China | 2006 | English 1 | 3 | 2.99 | 169 | 17.99 | PG | Deleted Scenes | 2020-12-23 07:12:31 | |
| 7 | AIRPLANE SIERRA | A Touching Saga of a Hunter And a Butler who must Discover a Butler in A Jet Boat | 2006 | English 1 | 6 | 4.99 | 62 | 28.99 | PG-13 | Trailers,Deleted Scenes | 2020-12-23 07:12:31 | |
| 8 | AIRPORT POLLOCK | A Epic Tale of a Moose And a Girl who must Confront a Monkey in Ancient India | 2006 | English 1 | 6 | 4.99 | 54 | 15.99 | R | Trailers | 2020-12-23 07:12:31 | |
| 9 | ALABAMA DEVIL | A Thoughtful Panorama of a Database Administrator And a Mad Scientist who must Outgun a Mad Scientist in A Jet Boat | 2006 | English 1 | 3 | 2.99 | 114 | 21.99 | PG-13 | Trailers,Deleted Scenes | 2020-12-23 07:12:31 | |
| 10 | ALADDIN CALENDAR | A Action-Packed Tale of a Man And a Lumberjack who must Reach a Feminist in Ancient China | 2006 | English 1 | 6 | 4.99 | 63 | 24.99 | NC-17 | Trailers,Deleted Scenes | 2020-12-23 07:12:31 | |
| 11 | ALAMO VIDEOTAPE | A Boring Epistle of a Butler And a Cat who must Fight a Pastry Chef in A MySQL Convention | 2006 | English 1 | 6 | 0.99 | 126 | 16.99 | G | Commentaries,Behind the Scenes | 2020-12-23 07:12:31 | |
| 12 | ALASKA PHANTOM | A Fanciful Saga of a Hunter And a Pastry Chef who must Vanquish a Boy in Australia | 2006 | English 1 | 6 | 0.99 | 136 | 22.99 | PG | Commentaries,Deleted Scenes | 2020-12-23 07:12:31 | |
| 13 | ALI FOREVER | A Action-Packed Drama of a Dentist And a Crocodile who must Battle a Feminist in The Canadian Rockies | 2006 | English 1 | 4 | 4.99 | 150 | 21.99 | PG | Deleted Scenes,Behind the Scenes | 2020-12-23 07:12:31 | |
| 14 | ALICE FANTASIA | A Emotional Drama of a A Shark And a Database Administrator who must Vanquish a Pioneer in Soviet Georgia | 2006 | English 1 | 6 | 0.99 | 94 | 23.99 | NC-17 | Trailers,Deleted Scenes,Behind the Scenes | 2020-12-23 07:12:32 | |
| 15 | ALIEN CENTER | A Brilliant Drama of a Cat And a Mad Scientist who must Battle a Feminist in A MySQL Convention | 2006 | English 1 | 5 | 2.99 | 46 | 10.99 | NC-17 | Trailers,Commentaries,Behind the Scenes | 2020-12-23 07:12:32 | |
| 16 | ALLEY EVOLUTION | A Fast-Paced Drama of a Robot And a Composer who must Battle a Astronaut in New Orleans | 2006 | English 1 | 6 | 2.99 | 180 | 23.99 | NC-17 | Trailers,Commentaries | 2020-12-23 07:12:32 | |
| 17 | ALONE TRIP | A Fast-Paced Character Study of a Composer And a Dog who must Outgun a Boat in An Abandoned Fun House | 2006 | English 1 | 3 | 0.99 | 82 | 14.99 | R | Trailers,Behind the Scenes | 2020-12-23 07:12:32 | |
| 18 | ALTER VICTORY | A Thoughtful Drama of a Composer And a Feminist who must Meet a Secret Agent in The Canadian Rockies | 2006 | English 1 | 6 | 0.99 | 57 | 27.99 | PG-13 | Trailers,Behind the Scenes | 2020-12-23 07:12:32 | |
| 19 | AMADEUS HOLY | A Emotional Display of a Pioneer And a Technical Writer who must Battle a Man in A Baloon | 2006 | English 1 | 6 | 0.99 | 113 | 20.99 | PG | Commentaries,Deleted Scenes,Behind the Scenes | 2020-12-23 07:12:32 | |
| 20 | AMELIE HELLFIGHTERS | A Boring Drama of a Woman And a Squirrel who must Conquer a Student in A Baloon | 2006 | English 1 | 4 | 4.99 | 79 | 23.99 | R | Commentaries,Deleted Scenes,Behind the Scenes | 2020-12-23 07:12:32 | |
| 21 | AMERICAN CIRCUS | A Insightful Drama of a Girl And a Astronaut who must Face a Database Administrator in A Shark Tank | 2006 | English 1 | 3 | 4.99 | 129 | 17.99 | R | Commentaries,Behind the Scenes | 2020-12-23 07:12:32 | |
| 22 | AMISTAD MIDSUMMER | A Emotional Character Study of a Dentist And a Crocodile who must Meet a Sumo Wrestler in California | 2006 | English 1 | 6 | 2.99 | 85 | 10.99 | G | Commentaries,Behind the Scenes | 2020-12-23 07:12:32 | |
| 23 | ANACONDA CONFESSIONS | A Lacklusture Display of a Dentist And a Dentist who must Fight a Girl in Australia | 2006 | English 1 | 3 | 0.99 | 92 | 9.99 | R | Trailers,Deleted Scenes | 2020-12-23 07:12:32 | |
| 24 | ANALYZE HOOSIERS | A Thoughtful Display of a Explorer And a Pastry Chef who must Overcome a Feminist in The Sahara Desert | 2006 | English 1 | 6 | 2.99 | 181 | 19.99 | R | Trailers,Behind the Scenes | 2020-12-23 07:12:32 | |
| 25 | ANGELS LIFE | A Thoughtful Display of a Woman And a Astronaut who must Battle a Robot in Berlin | 2006 | English 1 | 3 | 2.99 | 74 | 15.99 | G | Trailers | 2020-12-23 07:12:32 | |
| 26 | ANNIE IDENTITY | A Amazing Panorama of a Pastry Chef And a Boat who must Escape a Woman in An Abandoned Amusement Park | 2006 | English 1 | 3 | 0.99 | 86 | 15.99 | G | Commentaries,Deleted Scenes | 2020-12-23 07:12:32 | |
| 27 | ANONYMOUS HUMAN | A Amazing Reflection of a Database Administrator And a Astronaut who must Outrace a Database Administrator in A Shark Tank | 2006 | English 1 | 7 | 0.99 | 179 | 12.99 | NC-17 | Deleted Scenes,Behind the Scenes | 2020-12-23 07:12:32 | |
| 28 | ANTHEM LUKE | A Touching Panorama of a Waitress And a Woman who must Outrace a Dog in An Abandoned Amusement Park | 2006 | English 1 | 5 | 4.99 | 91 | 16.99 | PG-13 | Deleted Scenes,Behind the Scenes | 2020-12-23 07:12:32 | |
| 29 | ANTITRUST TOMATOES | A Fateful Yarn of a Womanizer And a Feminist who must Succumb a Database Administrator in Ancient India | 2006 | English 1 | 5 | 2.99 | 168 | 11.99 | NC-17 | Trailers,Commentaries,Deleted Scenes | 2020-12-23 07:12:32 | |
| 30 | ANYTHING SAVANNAH | A Epic Story of a Pastry Chef And a Woman who must Chase a Feminist in An Abandoned Fun House | 2006 | English 1 | 4 | 2.99 | 82 | 27.99 | R | Trailers,Deleted Scenes,Behind the Scenes | 2020-12-23 07:12:32 | |
| 31 | APACHE DIVINE | A Awe-Inspiring Reflection of a Pastry Chef And a Teacher who must Overcome a Sumo Wrestler in A U-Boat | 2006 | English 1 | 5 | 4.99 | 92 | 16.99 | NC-17 | Commentaries,Deleted Scenes,Behind the Scenes | 2020-12-23 07:12:32 | |
| 32 | APOCALYPSE FLAMINGOS | A Astounding Story of a Dog And a Squirrel who must Defeat a Woman in An Abandoned Amusement Park | 2006 | English 1 | 6 | 4.99 | 119 | 11.99 | R | Trailers,Commentaries | 2020-12-23 07:12:32 | |
| 33 | APOLLO TEEN | A Action-Packed Reflection of a Crocodile And a Explorer who must Find a Sumo Wrestler in An Abandoned Mine Shaft | 2006 | English 1 | 5 | 2.99 | 153 | 15.99 | PG-13 | Trailers,Commentaries,Deleted Scenes,Behind the Scenes | 2020-12-23 07:12:32 | |
| 34 | ARABIA DOGMA | A Touching Epistle of a Madman And a Mad Cow who must Defeat a Student in Nigeria | 2006 | English 1 | 6 | 0.99 | 62 | 29.99 | NC-17 | Commentaries,Deleted Scenes | 2020-12-23 07:12:32 | |
| 35 | ARACHNOPHOBIA ROLLERCOASTER | A Action-Packed Reflection of a Pastry Chef And a Composer who must Discover a Mad Scientist in The First Manned Space Station | 2006 | English 1 | 4 | 2.99 | 147 | 24.99 | PG-13 | Trailers,Deleted Scenes,Behind the Scenes | 2020-12-23 07:12:32 | |
| 36 | ARGONAUTS TOWN | A Emotional Epistle of a Forensic Psychologist And a Butler who must Challenge a Waitress in An Abandoned Mine Shaft | 2006 | English 1 | 7 | 0.99 | 127 | 12.99 | PG-13 | Trailers,Commentaries | 2020-12-23 07:12:32 | |
| 37 | ARIZONA BANG | A Brilliant Panorama of a Mad Scientist And a Mad Cow who must Meet a Pioneer in A Monastery | 2006 | English 1 | 3 | 2.99 | 121 | 28.99 | PG | Trailers,Deleted Scenes | 2020-12-23 07:12:32 | |
| 38 | ARK RIDGEMONT | A Beautiful Yarn of a Pioneer And a Monkey who must Pursue a Explorer in The Sahara Desert | 2006 | English 1 | 6 | 0.99 | 68 | 25.99 | NC-17 | Trailers,Commentaries,Deleted Scenes,Behind the Scenes | 2020-12-23 07:12:32 | |
| 39 | ARMAGEDDON LOST | A Fast-Paced Tale of a Boat And a Teacher who must Succumb a Composer in An Abandoned Mine Shaft | 2006 | English 1 | 5 | 0.99 | 99 | 10.99 | G | Trailers | 2020-12-23 07:12:32 | |
| 40 | ARMY FLINTSTONES | A Boring Saga of a Database Administrator And a Womanizer who must Battle a Waitress in Nigeria | 2006 | English 1 | 4 | 0.99 | 148 | 22.99 | R | Trailers,Commentaries | 2020-12-23 07:12:32 | |
| 41 | ARSENIC INDEPENDENCE | A Fanciful Documentary of a Mad Cow And a Womanizer who must Find a Dentist in Berlin | 2006 | English 1 | 4 | 0.99 | 137 | 17.99 | PG | Trailers,Deleted Scenes,Behind the Scenes | 2020-12-23 07:12:32 | |
| 42 | ARTIST COLDBLOODED | A Stunning Reflection of a Robot And a Moose who must Challenge a Woman in California | 2006 | English 1 | 5 | 2.99 | 170 | 10.99 | NC-17 | Trailers,Behind the Scenes | 2020-12-23 07:12:32 | |
| 43 | ATLANTIS CAUSE | A Thrilling Yarn of a Feminist And a Hunter who must Fight a Technical Writer in A Shark Tank | 2006 | English 1 | 6 | 2.99 | 170 | 15.99 | G | Behind the Scenes | 2020-12-23 07:12:32 | |
| 44 | ATTACKS HATE | A Fast-Paced Panorama of a Technical Writer And a Mad Scientist who must Find a Feminist in An Abandoned Mine Shaft | 2006 | English 1 | 5 | 4.99 | 113 | 21.99 | PG-13 | Trailers,Behind the Scenes | 2020-12-23 07:12:32 | |
| 45 | ATTRACTION NEWTON | A Astounding Panorama of a Composer And a Frisbee who must Reach a Husband in Ancient Japan | 2006 | English 1 | 5 | 4.99 | 83 | 14.99 | PG-13 | Trailers,Behind the Scenes | 2020-12-23 07:12:32 | |
| 46 | AUTUMN CROW | A Beautiful Tale of a Dentist And a Mad Cow who must Battle a Moose in The Sahara Desert | 2006 | English 1 | 3 | 4.99 | 108 | 13.99 | G | Trailers,Commentaries,Deleted Scenes,Behind the Scenes | 2020-12-23 07:12:32 | |
| 47 | BABY HALL | A Boring Character Study of a A Shark And a Girl who must Outrace a Feminist in An Abandoned Mine Shaft | 2006 | English 1 | 5 | 4.99 | 153 | 23.99 | NC-17 | Commentaries | 2020-12-23 07:12:32 | |
| 48 | BACKLASH UNDEFEATED | A Stunning Character Study of a Mad Scientist And a Mad Cow who must Kill a Car in A Monastery | 2006 | English 1 | 3 | 4.99 | 118 | 24.99 | PG-13 | Trailers,Behind the Scenes | 2020-12-23 07:12:32 | |
| 49 | BADMAN DAWN | A Emotional Panorama of a Pioneer And a Composer who must Escape a Mad Scientist in A Jet Boat | 2006 | English 1 | 6 | 2.99 | 162 | 22.99 | R | Trailers,Commentaries,Behind the Scenes | 2020-12-23 07:12:32 | |
| 50 | BAKED CLEOPATRA | A Stunning Drama of a Forensic Psychologist And a Husband who must Overcome a Waitress in A Monastery | 2006 | English 1 | 3 | 2.99 | 182 | 20.99 | G | Commentaries,Behind the Scenes | 2020-12-23 07:12:32 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE film (
film_id int NOT NULL,
title VARCHAR(255) NOT NULL,
description BLOB SUB_TYPE TEXT DEFAULT NULL,
release_year VARCHAR(4) DEFAULT NULL,
language_id SMALLINT NOT NULL,
original_language_id SMALLINT DEFAULT NULL,
rental_duration SMALLINT DEFAULT 3 NOT NULL,
rental_rate DECIMAL(4,2) DEFAULT 4.99 NOT NULL,
length SMALLINT DEFAULT NULL,
replacement_cost DECIMAL(5,2) DEFAULT 19.99 NOT NULL,
rating VARCHAR(10) DEFAULT 'G',
special_features VARCHAR(100) DEFAULT NULL,
last_update TIMESTAMP NOT NULL,
PRIMARY KEY (film_id),
CONSTRAINT CHECK_special_features CHECK(special_features is null or
special_features like '%Trailers%' or
special_features like '%Commentaries%' or
special_features like '%Deleted Scenes%' or
special_features like '%Behind the Scenes%'),
CONSTRAINT CHECK_special_rating CHECK(rating in ('G','PG','PG-13','R','NC-17')),
CONSTRAINT fk_film_language FOREIGN KEY (language_id) REFERENCES language (language_id) ,
CONSTRAINT fk_film_language_original FOREIGN KEY (original_language_id) REFERENCES language (language_id)
);
CREATE INDEX idx_fk_language_id ON film(language_id)
;
CREATE INDEX idx_fk_original_language_id ON film(original_language_id)
;