Stores data from NBA data API into PostrgreSQL database.
NBA Data API »
build.py script creates the following tables in the PostreSQL database:
- teams
- players
- coaches
api.py script calls the following endpoints from the NBA data API.
- teams - /prod/v2/2019/teams.json
- leagueRosterPlayers - /prod/v1/2019/players.json
- leagueRosterCoaches - /prod/v1/2019/coaches.json
import.py script imports the data recieved by the API call into the tables that were created.
| Source | Target |
|---|---|
teamId |
team_id |
fullName |
name |
city |
city |
nickname |
nickname |
confName |
conference |
divName |
division |
tricode |
abbr |
| Source | Target |
|---|---|
personId |
player_id |
firstName |
first_name |
lastName |
last_name |
teamId |
team_id |
pos |
position |
jersey |
jersey |
heightFeet |
height_ft |
heightInches |
height_in |
heightMeters |
height_m |
weightPounds |
weight_lbs |
weightKilograms |
weight_kg |
dateOfBirthUTC |
dob_utc |
roundNum |
draft_round |
pickNum |
draft_pick |
teamId |
draft_team |
seasonYear |
draft_year |
nbaDebutYear |
debut_year |
yearsPro |
years_pro |
collegeName |
college_name |
lastAffiliation |
last_affiliation |
country |
country |
teams |
teams |
isActive |
is_active |
| Source | Target |
|---|---|
personId |
coach_id |
firstName |
first_name |
lastName |
last_name |
teamId |
team_id |
college |
college |
isAssistant |
is_assistant |
- Python
- PostgreSQL database