Pokemon Compendium
Unveiling the Strengths, Abilities, and Traits of Every Pokémon Type
@kaggle.noeyislearning_pokdex
Unveiling the Strengths, Abilities, and Traits of Every Pokémon Type
@kaggle.noeyislearning_pokdex
This dataset provides a comprehensive overview of various Pokémon versions, including their types, abilities, and base stats. The data is sourced from official Pokémon databases and other relevant sources, offering insights into the characteristics and strengths of each Pokémon.
CREATE TABLE pokemon_bw (
"no" BIGINT,
"name" VARCHAR,
"type" VARCHAR,
"abilities" VARCHAR,
"hp" BIGINT,
"att" BIGINT,
"def" BIGINT,
"s_att" BIGINT,
"s_def" BIGINT,
"spd" BIGINT
);CREATE TABLE pokemon_dp (
"no" BIGINT,
"name" VARCHAR,
"type" VARCHAR,
"abilities" VARCHAR,
"hp" BIGINT,
"att" BIGINT,
"def" BIGINT,
"s_att" BIGINT,
"s_def" BIGINT,
"spd" BIGINT
);CREATE TABLE pokemon_gs (
"no" BIGINT,
"name" VARCHAR,
"type" VARCHAR,
"abilities" VARCHAR,
"hp" BIGINT,
"att" BIGINT,
"def" BIGINT,
"s_att" BIGINT,
"s_def" BIGINT,
"spd" BIGINT
);CREATE TABLE pokemon_rb (
"no" BIGINT,
"name" VARCHAR,
"type" VARCHAR,
"abilities" VARCHAR,
"hp" BIGINT,
"att" BIGINT,
"def" BIGINT,
"s_att" BIGINT,
"s_def" VARCHAR,
"spd" BIGINT
);CREATE TABLE pokemon_rs (
"no" BIGINT,
"name" VARCHAR,
"type" VARCHAR,
"abilities" VARCHAR,
"hp" BIGINT,
"att" BIGINT,
"def" BIGINT,
"s_att" BIGINT,
"s_def" BIGINT,
"spd" BIGINT
);CREATE TABLE pokemon_sm (
"no" BIGINT,
"name" VARCHAR,
"type" VARCHAR,
"abilities" VARCHAR,
"hp" BIGINT,
"att" BIGINT,
"def" BIGINT,
"s_att" BIGINT,
"s_def" BIGINT,
"spd" BIGINT
);CREATE TABLE pokemon_sv (
"no" BIGINT,
"name" VARCHAR,
"type" VARCHAR,
"abilities" VARCHAR,
"hp" BIGINT,
"att" BIGINT,
"def" BIGINT,
"s_att" BIGINT,
"s_def" BIGINT,
"spd" BIGINT
);CREATE TABLE pokemon_swsh (
"no" BIGINT,
"name" VARCHAR,
"type" VARCHAR,
"abilities" VARCHAR,
"hp" BIGINT,
"att" BIGINT,
"def" BIGINT,
"s_att" BIGINT,
"s_def" BIGINT,
"spd" BIGINT
);CREATE TABLE pokemon_xy (
"no" BIGINT,
"name" VARCHAR,
"type" VARCHAR,
"abilities" VARCHAR,
"hp" BIGINT,
"att" BIGINT,
"def" BIGINT,
"s_att" BIGINT,
"s_def" BIGINT,
"spd" BIGINT
);Anyone who has the link will be able to view this.