Data Of 1025 Pokemons

dataset of pokemons with description, name of the pokemon from which they evolve

@kaggle.hamzacyberpatcher_data_of_1010_pokemons

Table List

1 table(131.7 KB)

Pokemons

@kaggle.hamzacyberpatcher_data_of_1010_pokemons.pokemons

131.7 KB
1025 rows
18 columns

id Id	name Name	rank Rank	generation Generation	evolves_from Evolves From	type1 Type1	type2 Type2	hp Hp	atk Atk	def Def	spatk Spatk	spdef Spdef	speed Speed	total Total	height Height	weight Weight	abilities Abilities	desc Desc
1	bulbasaur	ordinary	generation-i	nothing	grass	poison	45	49	49	65	65	45	318	7	69	overgrow chlorophyll	A strange seed was planted on its back at birth. The plant sprouts and grows with this POKéMON.
2	ivysaur	ordinary	generation-i	bulbasaur	grass	poison	60	62	63	80	80	60	405	10	130	overgrow chlorophyll	When the bulb on its back grows large, it appears to lose the ability to stand on its hind legs.
3	venusaur	ordinary	generation-i	ivysaur	grass	poison	80	82	83	100	100	80	525	20	1000	overgrow chlorophyll	The plant blooms when it is absorbing solar energy. It stays on the move to seek sunlight.
4	charmander	ordinary	generation-i	nothing	fire	nan	39	52	43	60	50	65	309	6	85	blaze solar-power	Obviously prefers hot places. When it rains, steam is said to spout from the tip of its tail.
5	charmeleon	ordinary	generation-i	charmander	fire	nan	58	64	58	80	65	80	405	11	190	blaze solar-power	When it swings its burning tail, it elevates the temperature to unbearably high levels.
6	charizard	ordinary	generation-i	charmeleon	fire	flying	78	84	78	109	85	100	534	17	905	blaze solar-power	Spits fire that is hot enough to melt boulders. Known to cause forest fires unintentionally.
7	squirtle	ordinary	generation-i	nothing	water	nan	44	48	65	50	64	43	314	5	90	torrent rain-dish	After birth, its back swells and hardens into a shell. Powerfully sprays foam from its mouth.
8	wartortle	ordinary	generation-i	squirtle	water	nan	59	63	80	65	80	58	405	10	225	torrent rain-dish	Often hides in water to stalk unwary prey. For swimming fast, it moves its ears to maintain balance.
9	blastoise	ordinary	generation-i	wartortle	water	nan	79	83	100	85	105	78	530	16	855	torrent rain-dish	A brutal POKéMON with pressurized water jets on its shell. They are used for high speed tackles.
10	caterpie	ordinary	generation-i	nothing	bug	nan	45	30	35	20	20	45	195	3	29	shield-dust run-away	Its short feet are tipped with suction pads that enable it to tirelessly climb slopes and walls.


CREATE TABLE pokemons (
  "id" BIGINT,
  "name" VARCHAR,
  "rank" VARCHAR,
  "generation" VARCHAR,
  "evolves_from" VARCHAR,
  "type1" VARCHAR,
  "type2" VARCHAR,
  "hp" BIGINT,
  "atk" BIGINT,
  "def" BIGINT,
  "spatk" BIGINT,
  "spdef" BIGINT,
  "speed" BIGINT,
  "total" BIGINT,
  "height" BIGINT,
  "weight" BIGINT,
  "abilities" VARCHAR,
  "desc" VARCHAR
);