Name: All Pokemon Dataset
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

All Pokemon Dataset

Context

This Dataset contains data from all Pokemons and their forms from the eight generations. It includes their number, name, primary and secondary type, abilities, base stats, performance vs other types, etc. Data was scrapped from serebii bulbapedia and pokemon database

Content

Number: Number of the Pokemon in the National Pokedex
Name: Name of the Pokemon
Type 1: Primary Type of the Pokemon
Type 2: Secondary Type of the Pokemon
Abilities: A list that contains the abilities of the Pokemon
HP: Base Hit Points stat of the Pokemon
Att: Base Attack stat of the Pokemon
Def: Base Defense stat of the Pokemon
Spa: Base Special Attack stat of the Pokemon
Spd: Base Special Defense stat of the Pokemon
Spe: Base Speed stat of the Pokemon
BST: Sum of all the base stats
Mean: Mean of the base stats
Standard Deviation: Standard deviation of the base stats
Generation: The Generation in which the Pokemon was introduced
Experience Type: The Experience Group to which the Pokemon belongs
Experience to level 100: Amount of experience the Pokemon needs to level up to 100
Final Evolution: Denotes if the Pokemon is a Final Evolution
Catch Rate: Catch Rate of the Pokemon
Legendary: Denotes if the Pokemon is Legendary
Mega Evolution: Denotes if the Pokemon is a Mega Evolution
Alolan Form: Denotes if the Pokemon is an Alolan Form
Galarian Form: Denotes if the Pokemon is a Galarian Form
Against { }: Effectiveness of certain type against the Pokemon

Update

Three new columns have been added:

Height: The height of the Pokemon in metres
Weight: The weight of the Pokemon in kilograms
BMI: The Body mass index of the Pokemon (Weight / Height^2)

Tables

All Pokemon

@kaggle.maca11_all_pokemon_dataset.all_pokemon

92.51 kB
1,032 rows
44 columns

CREATE TABLE all_pokemon (
  "number" BIGINT,
  "name" VARCHAR,
  "type_1" VARCHAR,
  "type_2" VARCHAR,
  "abilities" VARCHAR,
  "hp" BIGINT,
  "att" BIGINT,
  "def" BIGINT,
  "spa" BIGINT,
  "spd" BIGINT,
  "spe" BIGINT,
  "bst" BIGINT,
  "mean" DOUBLE,
  "standard_deviation" DOUBLE,
  "generation" DOUBLE,
  "experience_type" VARCHAR,
  "experience_to_level_100" BIGINT,
  "final_evolution" DOUBLE,
  "catch_rate" BIGINT,
  "legendary" DOUBLE,
  "mega_evolution" DOUBLE,
  "alolan_form" DOUBLE,
  "galarian_form" DOUBLE,
  "against_normal" DOUBLE,
  "against_fire" DOUBLE,
  "against_water" DOUBLE,
  "against_electric" DOUBLE,
  "against_grass" DOUBLE,
  "against_ice" DOUBLE,
  "against_fighting" DOUBLE,
  "against_poison" DOUBLE,
  "against_ground" DOUBLE,
  "against_flying" DOUBLE,
  "against_psychic" DOUBLE,
  "against_bug" DOUBLE,
  "against_rock" DOUBLE,
  "against_ghost" DOUBLE,
  "against_dragon" DOUBLE,
  "against_dark" DOUBLE,
  "against_steel" DOUBLE,
  "against_fairy" DOUBLE,
  "height" DOUBLE,
  "weight" DOUBLE,
  "bmi" DOUBLE
);