sport.db free open public domain sports data

Home | Data, Repos | What's New? · Forum (Questions? Comments?)

Welcome

What’s sport.db?

A free open public domain sports database ‘n’ schema for use in any (programming) language (e.g. uses plain text fixtures/data sets).

Data Sets

Formula 1

See the formula1.db repo for more. Example:

##########################################################
# Grand Prix Monaco 2013 - Round 6 of 19 // 26 May 2013 

# | Pos | Driver | Team | Laps | Time/Retired

1 Nico Rosberg Mercedes 78 2:17:52.056
2 Sebastian Vettel Red Bull 78 +3.8 secs
3 Mark Webber Red Bull 78 +6.3 secs
4 Lewis Hamilton Mercedes 78 +13.8 secs
5 Adrian Sutil Force India 78 +21.4 secs
6 Jenson Button McLaren 78 +23.1 secs
7 Fernando Alonso Ferrari 78 +26.7 secs

(Alpine) Ski

See the ski.db repo for more. Example:

#############################
# Ski Alpine 2013/14 - Men

(1)  27 Oct 2013  9:30  Sölden (AUT)       / Riesenslalom

(2)  17 Nov 2013 10:00  Levi (FIN)         / Slalom
(3)  30 Nov 2013 20:00  Lake Louise (CAN)  / Abfahrt

(4)   1 Dec 2013 19:00  Lake Louise (CAN)  / Super G
(5)   6 Dec 2013 19:00  Beaver Creek (USA) / Abfahrt
(6)   7 Dec 2013 18:45  Beaver Creek (USA) / Super G
(7)   8 Dec 2013 17:45  Beaver Creek (USA) / Riesenslalom
(8)  14 Dec 2013 10:00  Val d'Isere (FRA)  / Riesenslalom
(9)  15 Dec 2013  9:30  Val d'Isere (FRA)  / Slalom
(10) 20 Dec 2013 12:15  Val Gardena (ITA)  / Super G
(11) 21 Dec 2013 12:15  Val d'Isere (FRA)  / Abfahrt
(12) 22 Dec 2013  9:30  Alta Badia (ITA)   / Riesenslalom

American Football / Nation Football League (NFL)

See the american-football.db repo for more. Example:

###################################################
# National Football League (NFL) 2012/13 Playoffs

(19) Round 19 - Divisional Playoffs  (Knockout)

Jan/12  Baltimore Ravens   38-35  Denver Broncos        (AFC)  # Sports Authority Field
Jan/13  Houston Texans     28-41  New England Patriots  (AFC)  # Gillette Stadium

Jan/12  Green Bay Backers  31-45  San Francisco 49ers  (NFC)   # Candlestick Park
Jan/13  Seattle Seahawks   28-30  Atlanta Falcons      (NFC)   # Georgia Dome


(20) Round 20 - Conference Championships (Knockout)

Jan/20  Baltimore Ravens      28-13  New England Patriots   (AFC Championship)   # Gillette Stadium
Jan/20  San Francisco 49ers   28-24  Atlanta Falcons        (NFC Championsip)    # Georgia Dome


##########################
# Super Bowl XLVII

(21) Round 21 - Super Bowl XLVII  (Knockout)   //  February 3

Feb/3  Baltimore Ravens   34-31 (7-3, 14-3, 7-17, 6-8)  San Francisco 49ers   # Superdome  - New Orleans, Louisiana

(Ice) Hockey / National Hockey League (NHL)

See the hockey.db repo for more. Example:

######################################
# National Hockey League (NHL) Teams

njdevils,     New Jersey Devils,   East/Atlantic, NJD, us, city:newark
nyislanders,  New York Islanders,  East/Atlantic, NYI, us, city:newyork
nyrangers,    New York Rangers,    East/Atlantic, NYR, us, city:newyork
phiflyers,    Philadelphia Flyers, East/Atlantic, PHI, us, city:philadelphia
pitpenguins,  Pittsburgh Penguins, East/Atlantic, PIT, us, city:pittsburgh

bosbruis,   Boston Bruis,        East/Northeast, BOS, us, city:boston
bufabres,  Buffalo Sabres,      East/Northeast, BUF, us, city:buffalo
montreal, Montreal Canadiens,  East/Northeast, MTL, ca, city:montreal
ottawa,   Ottawa Senators,     East/Northeast, OTT, ca, city:ottawa
toronto,  Toronto Maple Leafs, East/Northeast, TOR, ca, city:toronto
...

Anything missing? Add your leagues, teams, fixtures and more.

Command Line Tool

Use the sportdb command line tool to build your own sport.db copy. See the sportdb command line tool project for more.

Tables, Schema

The sport.db includes the following tables:

• teams
• games
• leagues
• seasons
• events
  • events_teams (join table)
• rounds
• groups
  • groups_teams (join table)
• tracks
• races
• records

Real World Usage

sport.db Web Admin - sport.db Web Admin Tool in Ruby on Rails (version 3.2 and up).

sport.db HTTP JSON API Web Service - sport.db Web Service / HTTP JSON API

Sportbook - A free, open source sports betting pool in Ruby on Rails (version 3.2 and up).

Alternatives

SportsDB - open database schema for sports information (formerly known as XTOSS: The XML Team Open Sports Schema.)

openLigaDB - community-based sport results

License

The sport.db schema, data and scripts are dedicated to the public domain. Use it as you please with no restrictions whatsoever.

Questions? Comments?

Send them along to the Open Sports Database & Friends Forum/Mailing List. Thanks!