Dataset: Pokemon Stats All Gens With Competitive Values

About this Dataset

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.

Tables

Egvs 2016–2023 Sharelist

@kaggle.ingmateleal_pokemon_stats_all_gens_with_competitive_values.egvs_2016_2023_sharelist

11.23 KB
346 rows
4 columns


CREATE TABLE egvs_2016_2023_sharelist (
  "position" BIGINT,
  "pokemon" VARCHAR,
  "pts" BIGINT,
  "share" DOUBLE
);

Pkmnabilityrank

@kaggle.ingmateleal_pokemon_stats_all_gens_with_competitive_values.pkmnabilityrank

15.82 KB
297 rows
5 columns


CREATE TABLE pkmnabilityrank (
  "ability_name" VARCHAR,
  "pokemons_with" BIGINT,
  "description" VARCHAR,
  "gen_appears" BIGINT,
  "ability_share_rank" BIGINT
);

Pkmnbyexp Listall

@kaggle.ingmateleal_pokemon_stats_all_gens_with_competitive_values.pkmnbyexp_listall

18.4 KB
1010 rows
3 columns


CREATE TABLE pkmnbyexp_listall (
  "pokenum" BIGINT,
  "pokemonnmn" VARCHAR,
  "experience_type" VARCHAR
);

Pokedex Ver Sv2

@kaggle.ingmateleal_pokemon_stats_all_gens_with_competitive_values.pokedex_ver_sv2

94.66 KB
1203 rows
38 columns


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
);