Global Movies Database (28 Genres, 291,473 Titles, 287 Languages & 1.6 Million Images)

Database Description:

This is the ultimate movies / films database (MySQL, CSV) with a total of 291,473 movie titles of 28 genres across 132 years (1887 - 2018) from 216 countries in 287 languages, produced by 98,244 companies, tagged by 37,648 keywords, involving 129,080 characters, played, written, directed, and created by 944,639 people including playwrights, screen writers, directors, producers, actors, and actresses, whose detailed information are listed in the 'person' table.

There are also over 1.6 million JPEG images (1,547,429 general images + 64,817 movie posters / covers) of the movies, characters / roles, directors, actors / actresses, writers, producers, etc. Each gallery item / image is associated with a 'person' record, a 'character' record, or a 'movie' record.

Database Meta:

• Size: 1.5 GB + 65.9 GB
• Images / Multi-media: 1,623,576 JPEG image files, 65.9 GB. General images: ab/cd/{gallery.id}.jpg (abcd = last 4 digits of file name, e.g. 888abcd.jpg); Movie covers: covers/{movie.id}.jpg
• Last updated: Dec. 19th, 2014
• Formats Included: MySQL dump .sql text file, CSV, MS Excel
• Tables: 20

Buy Now & Download: $189.00 (USD)

phpMyAdmin Screenshots:

Table Details (Data Structure / Schema):

• character

  Records:129,080

  Characters / roles in the movies.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. biography: mediumtext
  5. quotes: mediumtext

• company

  Records:98,244

  Companies that produce the movies.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)

• country

  Records:216

  Production countries.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)

• gallery

  Records:1,547,429

  Image gallery of this database.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)

• gallery2character

  Records:91,279

  Character images / pictures in the gallery.

  Data fields

  1. id: int(11)
  2. gallery_id: int(11)
  3. character_id: int(11)

• gallery2movie

  Records:476,223

  Movie images / pictures in the gallery.

  Data fields

  1. id: int(11)
  2. gallery_id: int(11)
  3. movie_id: int(11)
  4. gallery_slug: varchar(255)
  5. movie_slug: varchar(255)

• gallery2person

  Records:1,475,474

  Person images / pictures in the gallery.

  Data fields

  1. id: int(11)
  2. gallery_id: int(11)
  3. person_id: int(11)
  4. gallery_slug: varchar(255)
  5. person_slug: varchar(255)

• genre

  Records:28

  Different genres of the movies.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)

• keyword

  Records:37,648

  Keywords of the movies.

  Data fields

  1. id: int(11)
  2. title: varchar(255)

• language

  Records:287

  Languages of the movies.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)

• movie

  Records:291,473

  Table containing all the movie titles and their detailed information.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. year: int(10) unsigned
  5. also_known_as: varchar(255)
  6. users_rating_10: varchar(255)
  7. users_rating_10_total_votes: varchar(255)
  8. description: mediumtext
  9. storyline: mediumtext
  10. tagline: text
  11. mpaa_motion_picture_rating: text
  12. mpaa_rating: varchar(255)
  13. release_date: varchar(255)
  14. budget: varchar(255)
  15. opening_weekend: varchar(255)
  16. gross: varchar(255)
  17. runtime: varchar(255)
  18. sound_mix: text
  19. color: varchar(255)
  20. aspect_ratio: varchar(255)
  21. awards: text
  22. filming_locations: text

• movie2character

  Records:178,557

  Association table of movies and characters.

  Data fields

  1. id: int(11)
  2. movie_id: int(11)
  3. character_id: int(11)
  4. person_id: int(11)

• movie2company

  Records:311,948

  Association table of movies and companies.

  Data fields

  1. id: int(11)
  2. movie_id: int(11)
  3. company_id: int(11)

• movie2country

  Records:315,073

  Association table of movies and countries.

  Data fields

  1. id: int(11)
  2. movie_id: int(11)
  3. country_id: int(11)

• movie2genre

  Records:362,216

  Association table of movies and genres.

  Data fields

  1. id: int(11)
  2. movie_id: int(11)
  3. genre_id: int(11)

• movie2keyword

  Records:442,792

  Association table of movies and keywords.

  Data fields

  1. id: int(11)
  2. movie_id: int(11)
  3. keyword_id: int(11)

• movie2language

  Records:293,979

  Association table of movies and languages.

  Data fields

  1. id: int(11)
  2. movie_id: int(11)
  3. language_id: int(11)

• movie2person

  Records:3,374,110

  Association table of movies and people.

  Data fields

  1. id: int(11)
  2. movie_id: int(11)
  3. person_id: int(11)
  4. job_title: varchar(255)
  5. job_description: varchar(255)

• person

  Records:944,639

  People involved in making of the movies, writers, directors, producers, actors, actresses, etc.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. is_a: varchar(255)
  5. gallery_id: int(11)
  6. born_name: varchar(255)
  7. born_date: varchar(255)
  8. born_place: varchar(255)
  9. awards: mediumtext
  10. height: varchar(255)
  11. alternate_names: mediumtext
  12. star_sign: varchar(255)

• year

  Records:132

  Years in which movies are produced / released.

  Data fields

  1. id: int(11)
  2. title: int(10) unsigned

Buy Now & Download: $189.00 (USD)

Potential Applications / Usage:

• Movies portal
• Movies website / application

Other Available Formats:

Some of these formats are available on extra charge, depending on the database.

• Plain CSV
• CSV for Microsoft Excel
• Microsoft Excel .XLS file (2008, 2007, 2003, 2000)
• Microsoft Word .DOC file (2008, 2007, 2003, 2000)
• LaTeX
• Open Document Spreadsheet
• Open Document Text
• PDF
• XML
• YAML
• WordPress Category / Post Database
• Single Table Format