Name: 2023 NPB Active Players
Creator: Kaggle
License: https://creativecommons.org/licenses/by-sa/4.0/

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

161.24 kB
4,239 rows
33 columns

CREATE TABLE npb_batting (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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  -- 2B,
  "n_3b" BIGINT  -- 3B,
  "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

159.31 kB
4,165 rows
33 columns

CREATE TABLE npb_batting2023 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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  -- 2B,
  "n_3b" BIGINT  -- 3B,
  "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

94.44 kB
2,007 rows
33 columns

CREATE TABLE npb_pitching (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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

93.38 kB
1,974 rows
33 columns

CREATE TABLE npb_pitching2023 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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
);