Top 1000s In IMDB
TOP RATED MOVIES,SERIES AND VIDEO GAMES on IMDB ( updated in June 2022)
@kaggle.ramjasmaurya_top_250s_in_imdb
TOP RATED MOVIES,SERIES AND VIDEO GAMES on IMDB ( updated in June 2022)
@kaggle.ramjasmaurya_top_250s_in_imdb
IMDb (an abbreviation of Internet Movie Database)[2] is an online database of information related to films, television series, home videos, video games, and streaming content online – including cast, production crew and personal biographies, plot summaries, trivia, ratings, and fan and critical reviews. IMDb began as a fan-operated movie database on the Usenet group "rec.arts.movies" in 1990, and moved to the web in 1993. It is now owned and operated by IMDb.com, Inc., a subsidiary of Amazon.
As of June 2021, the database contained some 8 million titles (including television episodes) and 10.4 million person records.[3] Additionally, the site had 83 million registered users. The site's well-used message boards were disabled in February 2017.
CREATE TABLE imdb_1000_movies_in_june_2022 (
"ranking_of_movie" DOUBLE,
"movie_name" VARCHAR,
"year" VARCHAR,
"certificate" VARCHAR,
"runtime" VARCHAR,
"genre" VARCHAR,
"rating" DOUBLE,
"metascore" DOUBLE,
"detail_about_movie" VARCHAR,
"director" VARCHAR,
"actor_1" VARCHAR,
"actor_2" VARCHAR,
"actor_3" VARCHAR,
"actor_4" VARCHAR,
"votes" BIGINT,
"gross_collection" VARCHAR
);CREATE TABLE imdb_1000_tv_series_june_2022 (
"ranking" DOUBLE,
"series_name" VARCHAR,
"year" VARCHAR,
"certificate" VARCHAR,
"runtime" VARCHAR,
"genre" VARCHAR,
"rating" DOUBLE,
"details" VARCHAR,
"actor_1" VARCHAR,
"actor_2" VARCHAR,
"actor_3" VARCHAR,
"actor_4" VARCHAR,
"votes" BIGINT
);CREATE TABLE imdb_movies (
"ranking_of_movie" BIGINT,
"movie_name" VARCHAR,
"year" VARCHAR,
"certificate" VARCHAR,
"runtime" VARCHAR,
"genre" VARCHAR,
"rating" DOUBLE,
"detail_about_movie" VARCHAR,
"director" VARCHAR,
"actor_1" VARCHAR,
"actor_2" VARCHAR,
"actor_3" VARCHAR,
"actor_4" VARCHAR,
"votes" BIGINT,
"metascore" DOUBLE,
"gross_collection" VARCHAR
);CREATE TABLE imdb_series (
"ranking" BIGINT,
"series_name" VARCHAR,
"year" VARCHAR,
"certificate" VARCHAR,
"runtime" VARCHAR,
"genre" VARCHAR,
"rating" DOUBLE,
"details" VARCHAR,
"actor_1" VARCHAR,
"actor_2" VARCHAR,
"actor_3" VARCHAR,
"actor_4" VARCHAR,
"votes" BIGINT
);CREATE TABLE imdb_video_games (
"ranking" BIGINT,
"video_game_name" VARCHAR,
"year" VARCHAR,
"genre" VARCHAR,
"rating" DOUBLE,
"details" VARCHAR,
"director" VARCHAR,
"actor_1" VARCHAR,
"actor_2" VARCHAR,
"actor_3" VARCHAR,
"actor_4" VARCHAR,
"votes" BIGINT,
"certificate" VARCHAR
);Anyone who has the link will be able to view this.