FiveThirtyEight MLB Allstar Teams Dataset

Explore Data from FiveThirtyEight

@kaggle.fivethirtyeight_fivethirtyeight_mlb_allstar_teams_dataset

Table List

2 tables(228.59 KB)

Allstar Player Talent

@kaggle.fivethirtyeight_fivethirtyeight_mlb_allstar_teams_dataset.allstar_player_talent

201.33 KB
3930 rows
15 columns

bbref_id Bbref ID	yearid YearID	gameid GameID	lgid LgID	startingpos StartingPos	off600 OFF600	def600 DEF600	pitch200 PITCH200	asg_pa Asg PA	asg_ip Asg IP	offper9innasg OFFper9innASG	defper9innasg DEFper9innASG	pitper9innasg PITper9innASG	totper9innasg TOTper9innASG
goldspa01	2015	NLS201507140	NL	3	36.75572404	-0.117213522		3		0.18377862	-0.000586068		0.183192553
mccutan01	2015	NLS201507140	NL	8	33.67616805	-0.168658418		3		0.16838084	-0.000843292		0.167537548
harpebr03	2015	NLS201507140	NL	9	30.92545388	1.382969372		3		0.154627269	0.006914847		0.161542116
greinza01	2015	NLS201507140	NL	1			15.64561093		2			0.156456109	0.156456109
poseybu01	2015	NLS201507140	NL	2	21.69296916	7.59554639		2		0.072309897	0.025318488		0.097628385
frazito01	2015	NLS201507140	NL	5	14.53426139	4.787243006		3		0.072671307	0.023936215		0.096607522
rizzoan01	2015	NLS201507140	NL		22.17114817	0.670664775		2		0.073903827	0.002235549		0.076139376
kershcl01	2015	NLS201507140	NL				14.69587484		1			0.073479374	0.073479374
peraljh01	2015	NLS201507140	NL	6	7.193125866	10.38504755		2		0.023977086	0.034616825		0.058593911
crawfbr01	2015	NLS201507140	NL		2.372143139	13.07962617		2		0.007907144	0.043598754		0.051505898


CREATE TABLE allstar_player_talent (
  "bbref_id" VARCHAR,
  "yearid" BIGINT,
  "gamenum" BIGINT,
  "gameid" VARCHAR,
  "lgid" VARCHAR,
  "startingpos" DOUBLE,
  "off600" DOUBLE,
  "def600" DOUBLE,
  "pitch200" DOUBLE,
  "asg_pa" BIGINT,
  "asg_ip" DOUBLE,
  "offper9innasg" DOUBLE,
  "defper9innasg" DOUBLE,
  "pitper9innasg" DOUBLE,
  "totper9innasg" DOUBLE
);