TV Series Dataset
Over 150.000 details of every TV series on The Movie Database!
@kaggle.bourdier_all_tv_series_details_dataset
Over 150.000 details of every TV series on The Movie Database!
@kaggle.bourdier_all_tv_series_details_dataset
CREATE TABLE tvs (
"n__id" VARCHAR,
"id" BIGINT,
"name" VARCHAR,
"original_name" VARCHAR,
"overview" VARCHAR,
"tagline" VARCHAR,
"in_production" BOOLEAN,
"status" VARCHAR,
"original_language" VARCHAR,
"origin_country_0" VARCHAR,
"origin_country_1" VARCHAR,
"origin_country_2" VARCHAR,
"origin_country_3" VARCHAR,
"origin_country_4" VARCHAR,
"origin_country_5" VARCHAR,
"origin_country_6" VARCHAR,
"origin_country_7" VARCHAR,
"first_air_date" TIMESTAMP,
"last_air_date" VARCHAR,
"number_of_episodes" DOUBLE,
"number_of_seasons" BIGINT,
"poster_path" VARCHAR,
"genres_0_id" DOUBLE,
"genres_1_id" DOUBLE,
"genres_2_id" DOUBLE,
"genres_3_id" DOUBLE,
"genres_4_id" DOUBLE,
"genres_5_id" DOUBLE,
"genres_6_id" DOUBLE,
"genres_7_id" DOUBLE,
"genres_0_name" VARCHAR,
"genres_1_name" VARCHAR,
"genres_2_name" VARCHAR,
"genres_3_name" VARCHAR,
"genres_4_name" VARCHAR,
"genres_5_name" VARCHAR,
"genres_6_name" VARCHAR,
"genres_7_name" VARCHAR,
"genres_0_id_592134" VARCHAR,
"genres_1_id_b5e25a" VARCHAR,
"genres_2_id_127c5b" VARCHAR,
"genres_3_id_d690ca" VARCHAR,
"genres_4_id_470b2f" VARCHAR,
"genres_5_id_c017ae" VARCHAR,
"genres_6_id_f9cd3f" VARCHAR,
"genres_7_id_dec80a" VARCHAR,
"vote_average" DOUBLE,
"vote_count" BIGINT,
"popularity" DOUBLE,
"created_by_0_id" DOUBLE,
"created_by_1_id" DOUBLE,
"created_by_2_id" DOUBLE,
"created_by_3_id" DOUBLE,
"created_by_4_id" DOUBLE,
"created_by_5_id" DOUBLE,
"created_by_6_id" DOUBLE,
"created_by_7_id" DOUBLE,
"created_by_8_id" DOUBLE,
"created_by_9_id" DOUBLE,
"created_by_10_id" DOUBLE,
"created_by_11_id" DOUBLE,
"created_by_12_id" DOUBLE,
"created_by_13_id" DOUBLE,
"created_by_14_id" DOUBLE,
"created_by_15_id" DOUBLE,
"created_by_0_name" VARCHAR,
"created_by_1_name" VARCHAR,
"created_by_2_name" VARCHAR,
"created_by_3_name" VARCHAR,
"created_by_4_name" VARCHAR,
"created_by_5_name" VARCHAR,
"created_by_6_name" VARCHAR,
"created_by_7_name" VARCHAR,
"created_by_8_name" VARCHAR,
"created_by_9_name" VARCHAR,
"created_by_10_name" VARCHAR,
"created_by_11_name" VARCHAR,
"created_by_12_name" VARCHAR,
"created_by_13_name" VARCHAR,
"created_by_14_name" VARCHAR,
"created_by_15_name" VARCHAR,
"created_by_0_id_034185" VARCHAR,
"created_by_1_id_92ad9c" VARCHAR,
"created_by_2_id_2e6859" VARCHAR,
"created_by_3_id_39fb3e" VARCHAR,
"created_by_4_id_a7dbd0" VARCHAR,
"created_by_5_id_286e5d" VARCHAR,
"created_by_6_id_b393ca" VARCHAR,
"created_by_7_id_07af29" VARCHAR,
"created_by_8_id_a5d14f" VARCHAR,
"created_by_9_id_a1669c" VARCHAR,
"created_by_10_id_ca4a08" VARCHAR,
"created_by_11_id_e61cc7" VARCHAR,
"created_by_12_id_eb7d6e" VARCHAR,
"created_by_13_id_acf5b8" VARCHAR,
"created_by_14_id_8e04fc" VARCHAR,
"created_by_15_id_3ede1b" VARCHAR,
"production_companies_0_id" DOUBLE,
"production_companies_1_id" DOUBLE,
"production_companies_2_id" DOUBLE
);
Anyone who has the link will be able to view this.