Dataset: 2023 NPB Active Players

About this Dataset

2023 NPB Active Players

These data are taken from npb.com, representing the current career statistics for active Nippon Professional Baseball (NPB) players in Japan. Included are both a Batting and Pitching data set. In each there are demographic data:

Player ID (unique identifier for each player)
Last Name
First Name
Position
Bats (both, left, right)
Throws (left, right)
Height (cm)
Weight (kg)
Born (birthdate)
Year
Team

Then, each data set has BOBBC (back of baseball card) batting and pitching statistics, respectively.

Tables

Npb Batting

@kaggle.egerber1_2022_npb_active_players.npb_batting

157.46 KB
4239 rows
33 columns


CREATE TABLE npb_batting (
  "unnamed_0" BIGINT,
  "player_id" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "position" VARCHAR,
  "bats" VARCHAR,
  "throws" VARCHAR,
  "height" DOUBLE,
  "weight" DOUBLE,
  "born" VARCHAR,
  "year" BIGINT,
  "team" VARCHAR,
  "g" BIGINT,
  "pa" BIGINT,
  "ab" BIGINT,
  "r" BIGINT,
  "h" BIGINT,
  "n_2b" BIGINT,
  "n_3b" BIGINT,
  "hr" BIGINT,
  "tb" BIGINT,
  "rbi" BIGINT,
  "sb" BIGINT,
  "cs" BIGINT,
  "sh" BIGINT,
  "sf" BIGINT,
  "bb" BIGINT,
  "hp" BIGINT,
  "so" BIGINT,
  "gdp" BIGINT,
  "avg" DOUBLE,
  "slg" DOUBLE,
  "obp" DOUBLE
);

Npb Batting2023

@kaggle.egerber1_2022_npb_active_players.npb_batting2023

155.58 KB
4165 rows
33 columns


CREATE TABLE npb_batting2023 (
  "unnamed_0" BIGINT,
  "player_id" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "position" VARCHAR,
  "bats" VARCHAR,
  "throws" VARCHAR,
  "height" DOUBLE,
  "weight" DOUBLE,
  "born" VARCHAR,
  "year" BIGINT,
  "team" VARCHAR,
  "g" BIGINT,
  "pa" BIGINT,
  "ab" BIGINT,
  "r" BIGINT,
  "h" BIGINT,
  "n_2b" BIGINT,
  "n_3b" BIGINT,
  "hr" BIGINT,
  "tb" BIGINT,
  "rbi" BIGINT,
  "sb" BIGINT,
  "cs" BIGINT,
  "sh" BIGINT,
  "sf" BIGINT,
  "bb" BIGINT,
  "hp" BIGINT,
  "so" BIGINT,
  "gdp" BIGINT,
  "avg" DOUBLE,
  "slg" DOUBLE,
  "obp" DOUBLE
);

Npb Pitching

@kaggle.egerber1_2022_npb_active_players.npb_pitching

92.23 KB
2007 rows
33 columns


CREATE TABLE npb_pitching (
  "unnamed_0" BIGINT,
  "player_id" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "position" VARCHAR,
  "bats" VARCHAR,
  "throws" VARCHAR,
  "height" DOUBLE,
  "weight" DOUBLE,
  "born" VARCHAR,
  "year" BIGINT,
  "team" VARCHAR,
  "g" BIGINT,
  "w" BIGINT,
  "l" BIGINT,
  "sv" BIGINT,
  "hld" BIGINT,
  "hp" BIGINT,
  "cg" DOUBLE,
  "sho" BIGINT,
  "pct" DOUBLE,
  "bf" DOUBLE,
  "ip" DOUBLE,
  "h" BIGINT,
  "hr" BIGINT,
  "bb" BIGINT,
  "hb" BIGINT,
  "so" BIGINT,
  "wp" BIGINT,
  "bk" BIGINT,
  "r" DOUBLE,
  "er" DOUBLE,
  "era" DOUBLE
);

Npb Pitching2023

@kaggle.egerber1_2022_npb_active_players.npb_pitching2023

91.19 KB
1974 rows
33 columns


CREATE TABLE npb_pitching2023 (
  "unnamed_0" BIGINT,
  "player_id" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "position" VARCHAR,
  "bats" VARCHAR,
  "throws" VARCHAR,
  "height" DOUBLE,
  "weight" DOUBLE,
  "born" VARCHAR,
  "year" BIGINT,
  "team" VARCHAR,
  "g" BIGINT,
  "w" BIGINT,
  "l" BIGINT,
  "sv" BIGINT,
  "hld" BIGINT,
  "hp" BIGINT,
  "cg" DOUBLE,
  "sho" BIGINT,
  "pct" DOUBLE,
  "bf" DOUBLE,
  "ip" DOUBLE,
  "h" BIGINT,
  "hr" BIGINT,
  "bb" BIGINT,
  "hb" BIGINT,
  "so" BIGINT,
  "wp" BIGINT,
  "bk" BIGINT,
  "r" DOUBLE,
  "er" DOUBLE,
  "era" DOUBLE
);