Pokemon With Stats

721 Pokemon with stats and types

@kaggle.abcsds_pokemon

Table List

1 table(30.05 KB)

Pokemon

@kaggle.abcsds_pokemon.pokemon

30.05 KB
800 rows
13 columns

n #	name Name	type_1 Type 1	type_2 Type 2	total Total	hp HP	attack Attack	defense Defense	sp_atk Sp. Atk	sp_def Sp. Def	speed Speed	generation Generation
1	Bulbasaur	Grass	Poison	318	45	49	49	65	65	45	1
2	Ivysaur	Grass	Poison	405	60	62	63	80	80	60	1
3	Venusaur	Grass	Poison	525	80	82	83	100	100	80	1
3	VenusaurMega Venusaur	Grass	Poison	625	80	100	123	122	120	80	1
4	Charmander	Fire	nan	309	39	52	43	60	50	65	1
5	Charmeleon	Fire	nan	405	58	64	58	80	65	80	1
6	Charizard	Fire	Flying	534	78	84	78	109	85	100	1
6	CharizardMega Charizard X	Fire	Dragon	634	78	130	111	130	85	100	1
6	CharizardMega Charizard Y	Fire	Flying	634	78	104	78	159	115	100	1
7	Squirtle	Water	nan	314	44	48	65	50	64	43	1


CREATE TABLE pokemon (
  "n" BIGINT,
  "name" VARCHAR,
  "type_1" VARCHAR,
  "type_2" VARCHAR,
  "total" BIGINT,
  "hp" BIGINT,
  "attack" BIGINT,
  "defense" BIGINT,
  "sp_atk" BIGINT,
  "sp_def" BIGINT,
  "speed" BIGINT,
  "generation" BIGINT,
  "legendary" BOOLEAN
);