home

games

Custom SQL query

Queries

  • Year over Year Performance
  • Team Performance By Day

Tables

arena

id, Arena, Latitude, Longitude, Capacity, Opened, Closed, Team

36 rows

conference

id, name

2 rows

dim_date

date, season, season_phase

4,776 rows

division

id, name, conference_id

6 rows

franchise

id, Franchise, Year_Founded

2 rows

games

game_id, away_team, away_team_score, home_team, home_team_score, game_status, game_date, game_attendance, home_team_shots, away_team_shots

24,833 rows

season

season, current_yn

19 rows

sqlite_sequence

name, seq

6 rows

team

id, name, year_founded, division_id, franchise_id

53 rows

team_date_point

id, team_id, date, wins, loses, otl, sol, total_points

0 rows

unplayed_games

game_id

176 rows

Powered by Datasette