Global Movies (World)

Movies (industry) database of the world

Data Structure

character [129,080]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
mediumtext
+ biography (7.1%)
mediumtext
+ quotes (37.1%)
company [98,244]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
country [216]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
gallery [1,547,429]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
gallery2character [91,279]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ gallery_id (100%)
bigint(20) unsigned
+ character_id (100%)
gallery2movie [476,223]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ gallery_id (100%)
bigint(20) unsigned
+ movie_id (100%)
varchar(255)
+ gallery_slug (100%)
varchar(255)
+ movie_slug (100%)
gallery2person [1,475,474]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ gallery_id (100%)
bigint(20) unsigned
+ person_id (100%)
varchar(255)
+ gallery_slug (100%)
varchar(255)
+ person_slug (100%)
genre [28]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
keyword [37,648]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
language [287]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
movie [291,473]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
int(10) unsigned
+ year (100%)
varchar(255)
+ also_known_as (47.7%)
varchar(255)
+ users_rating_10 (50.1%)
varchar(255)
+ users_rating_10_total_votes (50.1%)
mediumtext
+ description (40.3%)
mediumtext
+ storyline (40.3%)
text
+ tagline (16.2%)
text
+ mpaa_motion_picture_rating (4.2%)
varchar(255)
+ mpaa_rating (4.2%)
varchar(255)
+ release_date (74.4%)
varchar(255)
+ budget (12.5%)
varchar(255)
+ opening_weekend (2.7%)
varchar(255)
+ gross (4.8%)
varchar(255)
+ runtime (45.5%)
text
+ sound_mix (47.5%)
varchar(255)
+ color (90.2%)
varchar(255)
+ aspect_ratio (34.8%)
text
+ awards (15.6%)
text
+ filming_locations (33.7%)
movie2character [178,557]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ movie_id (100%)
bigint(20) unsigned
+ character_id (100%)
bigint(20) unsigned
+ person_id (100%)
movie2company [311,948]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ movie_id (100%)
bigint(20) unsigned
+ company_id (100%)
movie2country [315,073]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ movie_id (100%)
bigint(20) unsigned
+ country_id (100%)
movie2genre [362,216]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ movie_id (100%)
bigint(20) unsigned
+ genre_id (100%)
movie2keyword [442,792]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ movie_id (100%)
bigint(20) unsigned
+ keyword_id (100%)
movie2language [293,979]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ movie_id (100%)
bigint(20) unsigned
+ language_id (100%)
movie2person [3,374,110]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ movie_id (100%)
bigint(20) unsigned
+ person_id (100%)
varchar(255)
+ job_title (100%)
varchar(255)
+ job_description (10.4%)
person [944,639]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
varchar(255)
+ is_a (99.4%)
bigint(20) unsigned
+ gallery_id (10.2%)
varchar(255)
+ born_name (7.2%)
varchar(255)
+ born_date (19.5%)
varchar(255)
+ born_place (18.3%)
mediumtext
+ awards (7.2%)
varchar(255)
+ height (8.2%)
mediumtext
+ alternate_names (17.3%)
varchar(255)
+ star_sign (17%)
year [132]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
int(10) unsigned
+ title (100%)

Description

This is a content rich and highly structural database of worldwide movies of all possible genres and languages. You can query for a movie by title, year, director, producer, screen writer, actor / actress, genre, keyword, language, country, or production company.

Data Profile

Size 2.08G
Tables 20
Last Commit 2016-12-07 00:36:33

Updates / Commits

Time Size Tables Columns Rows
2016-12-07 00:36:33 2.08G 20 115 10370827
2016-08-11 05:39:07 2.08G 20 115 10370827

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
character 129,080 .001 129.08
company 98,244 .001 98.244
country 216 .001 0.216
gallery 1,547,429 .001 1547.429
gallery2character 91,279 .001 91.279
gallery2movie 476,223 .001 476.223
gallery2person 1,475,474 .001 1475.474
genre 28 .001 0.028
keyword 37,648 .001 37.648
language 287 .001 0.287
movie 291,473 .001 291.473
movie2character 178,557 .001 178.557
movie2company 311,948 .001 311.948
movie2country 315,073 .001 315.073
movie2genre 362,216 .001 362.216
movie2keyword 442,792 .001 442.792
movie2language 293,979 .001 293.979
movie2person 3,374,110 .001 3374.11
person 944,639 .001 944.639
year 132 .001 0.132
Total Credits 10370.827 Credits (1) (2)
(1). Plus cost by query time at 0.1 credits per second. A typical query takes about 0.001 seconds which would then charge you 0.0001 credits.
(2). This is the total amount of credits required for ALL rows in these tables. You are free to query for only a selected part of them, even a single row, and pay only for that.

How to Access

Click to see how to access this dataset.