Pokemon Stats All Gens With Competitive Values
HP, Speed, Atk, SpAtk, Def, SpDef and some other all 9 gen statistics
@kaggle.ingmateleal_pokemon_stats_all_gens_with_competitive_values
HP, Speed, Atk, SpAtk, Def, SpDef and some other all 9 gen statistics
@kaggle.ingmateleal_pokemon_stats_all_gens_with_competitive_values
This .zip file containst different information from all 9 Pokémon generations. Those list on .csv does not cintain New Teal Mask DLC pokemons statistics. This file also incluse EGV competitive information of shareness, use of pokémon and also the points assigned by the use and winnings from the pokemon master above all the historic EGVs shows.
CREATE TABLE egvs_2016_2023_sharelist (
"position" BIGINT,
"pokemon" VARCHAR,
"pts" BIGINT,
"share" DOUBLE
);CREATE TABLE pkmnabilityrank (
"ability_name" VARCHAR,
"pokemons_with" BIGINT,
"description" VARCHAR,
"gen_appears" BIGINT,
"ability_share_rank" BIGINT
);CREATE TABLE pkmnbyexp_listall (
"pokenum" BIGINT,
"pokemonnmn" VARCHAR,
"experience_type" VARCHAR
);CREATE TABLE pokedex_ver_sv2 (
"no" BIGINT,
"branch_code" VARCHAR,
"original_name" VARCHAR,
"name" VARCHAR,
"generation" BIGINT,
"height" DOUBLE,
"weight" DOUBLE,
"type1" VARCHAR,
"type2" VARCHAR,
"ability1" VARCHAR,
"ability2" VARCHAR,
"ability_hidden" VARCHAR,
"color" VARCHAR,
"gender_male" DOUBLE,
"gender_female" DOUBLE,
"gender_unknown" BIGINT,
"egg_steps" BIGINT,
"egg_group1" VARCHAR,
"egg_group2" VARCHAR,
"get_rate" BIGINT,
"base_experience" BIGINT,
"experience_type" BIGINT,
"category" VARCHAR,
"mega_evolution_flag" VARCHAR,
"region_form" VARCHAR,
"hp" BIGINT,
"attack" BIGINT,
"defense" BIGINT,
"sp_attack" BIGINT,
"sp_defense" BIGINT,
"speed" BIGINT,
"total" BIGINT,
"e_hp" BIGINT,
"e_attack" BIGINT,
"e_defense" BIGINT,
"e_sp_attack" BIGINT,
"e_sp_defense" BIGINT,
"e_speed" BIGINT
);Anyone who has the link will be able to view this.