football.db

http://openfootball.github.io
Admin
An open-source, public domain football database and schema providing free structured data for world...
Tokens:15,342
Snippets:142
Trust Score:9.7
Update:4 months ago
Show doc for...
Tokens:
Raw
### Install sportweb Gem

Source: http://openfootball.github.io/news

Install the sportweb command-line tool, which bundles the sport.db.admin web app for browsing local SQLite databases.

```bash
$ gem install sportweb 

```

--------------------------------

### Check sqlite3 Installation

Source: http://openfootball.github.io/docs/sqlite.html

Verify if the sqlite3 command-line tool is installed on your system by running the help command.

```bash
$ sqlite3 -help
3.6.22

```

--------------------------------

### ojogo Output Example

Source: http://openfootball.github.io/news

Example output from the ojogo command, showing a list of matches scheduled for the current day in the World Cup 2014.

```text
Netherlands (NED) vs Mexico (MEX) 
Costa Rica (CRC) vs Greece (GRE) 


```

--------------------------------

### Football.TXT Dataset Example

Source: http://openfootball.github.io/index.html

An example of a Football.TXT dataset showing match schedules, scores, and goal scorers.

```text
▪ Quarter-finals - 1st Leg

Tue Apr 1
  20:45   FC Barcelona        v Atlético Madrid    1-1  @ Camp Nou, Barcelona
            (Neymar 71'; Diego 56')
  20:45   Manchester United   v Bayern München     1-1  @ Old Trafford, Manchester
            (Vidić 58'; Schweinsteiger 67')
Wed Apr 2
  20:45   Real Madrid         v Borussia Dortmund  3-0  @ Santiago Bernabéu, Madrid
            (Bale 3' Isco 27' Ronaldo 57')
  20:45   Paris Saint-Germain v Chelsea FC         3-1  @ Parc des Princes, Paris
            (Lavezzi 4' Luiz 61'og Pastore 90+3'; Hazard 27'pen)

...

```

--------------------------------

### English Premier League Squad Example

Source: http://openfootball.github.io/news

Example of a football club's squad list, including player numbers, names, nationalities, positions, and start years.

```text
(1)     Wojciech Szczęsny (POL)    GK  2007-

(3)     Kieran Gibbs               DF  2007-
(4)     Per Mertesacker (GER)      DF  2011-
(5)  (c) Thomas Vermaelen (BEL)    DF  2009-
(6)     Laurent Koscielny (FRA)    DF  2010-
(18)    Nacho Monreal (ESP)        DF  2013-
(25)    Carl Jenkinson             DF  2011-

(7)     Tomáš Rosický (CZE)        MF  2006-
(8)     Mikel Arteta (ESP)         MF  2011-
(10)    Jack Wilshere (ENG)        MF  2008-
(11)    Mesut Özil (GER)           MF  2013-
(16)    Aaron Ramsey (WAL)         MF  2008-
(19)    Santi Cazorla (ESP)        MF  2012-
(20)    Mathieu Flamini (FRA)      MF  2013-
(24)    Abou Diaby (FRA)           MF  2006-
(35)    Gedion Zelalem (GER)       MF  2013-
        Francis Coquelin (FRA)     MF  2008-

(9)     Lukas Podolski (GER)       FW  2012-
(12)    Olivier Giroud (FRA)       FW  2012-
(14)    Theo Walcott               FW  2006-
(15)    Alex Oxlade-Chamberlain    FW  2011-
(17)    Alexis Sánchez (CHI)       FW  2014-
...

```

--------------------------------

### Swiss Football League Schedule Example

Source: http://openfootball.github.io/news

Example of a match schedule for the Swiss Super League, including matchday headers, dates, times, teams, scores, and player goal information.

```text
Spieltag 1 

[Sa 19.7.] 
  17.45   FC Aarau       1:2 (0:2)  FC Basel             @ Brügglifeld, Aarau
            [Schultz 85'; Embolo 15' Aliji 38'] 
  20.00   FC St. Gallen  2:2 (1:1)  BSC Young Boys       @ AFG Arena, St. Gallen
              [Cavusevic 14' Gajic  52' (ET); Kubo 23' Afum 90' ] 
...

```

--------------------------------

### sportdb Goal Data Structure Example

Source: http://openfootball.github.io/news

Example of the goal records generated by the sportdb match schedule reader, showing player ID, team ID, minute, offset, and score.

```text
1 |   Marcelo  11'   (o.g.)   1-0   Croatia (Team 2) 
2 |   Neymar   29'            1-1   Brazil  (Team 1) 
3 |   Neymar   71'   (pen.)   2-1   Brazil  (Team 1) 
4 |   Oscar    90'+1'         3-1   Brazil  (Team 1)


```

--------------------------------

### Match Schedule with Goals Example

Source: http://openfootball.github.io/news

Example of a match schedule entry including goal scorers, minutes, and own goals. This format is used by the sportdb match schedule reader.

```text
(1) Thu Jun/12 17:00   Brazil 3-1 (1-1) Croatia       @ Arena de São Paulo, São Paulo
        [Neymar 29', 71' (pen.) Oscar 90+1';  Marcelo 11' (o.g.)]


```

--------------------------------

### Example API Request and Response

Source: http://openfootball.github.io/docs/json-api-games.html

Demonstrates a request for World Cup 2014 Matchday 2 and its expected JSON response, which includes event and round details along with a list of games.

```json
{
  "event":
    {"key":"world.2014","title":"World Cup 2014"},
  "round":
    {"pos":2,"title":"Matchday 2","start_at":"2014/06/13","end_at":"2014/06/13"},
  "games":[
    {"team1_key":"mex","team1_title":"Mexico","team1_code":"MEX","team2_key":"cmr","team2_title":"Cameroon","team2_code":"CMR","play_at":"2014/06/13","score1":null,"score2":null,"score1ot":null,"score2ot":null,"score1p":null,"score2p":null},
    {"team1_key":"esp","team1_title":"Spain","team1_code":"ESP","team2_key":"ned","team2_title":"Netherlands","team2_code":"NED","play_at":"2014/06/13","score1":null,"score2":null,"score1ot":null,"score2ot":null,"score1p":null,"score2p":null},
    {"team1_key":"chi","team1_title":"Chile","team1_code":"CHI","team2_key":"aus","team2_title":"Australia","team2_code":"AUS","play_at":"2014/06/13","score1":null,"score2":null,"score1ot":null,"score2ot":null,"score1p":null,"score2p":null}]
}
```

--------------------------------

### Query Games List using SQL View

Source: http://openfootball.github.io/news

Use the 'games_list' SQL view for simplified querying of game data. This example filters for games in the 'world.2014' event.

```sql
SELECT * 
FROM events_games_list 
WHERE e.key = 'world.2014'; 

```

--------------------------------

### Django Query Example: Leicester City Wins

Source: http://openfootball.github.io/docs/python.html

An example Django ORM query to count home games won by Leicester City by two or more goals in the 2015/16 English Premier League. Requires the 'Game' model and related event/league/season data to be defined.

```python
>>> Game.objects.filter(
    round__event__league__key="en",
    round__event__season__key="2015/16",
    team1__key="leicester",
    score1__gte=F("score2") + 2,
).count()

5

```

--------------------------------

### List Teams for an Event (JSONP)

Source: http://openfootball.github.io/docs/json-api-intro.html

Retrieve a list of teams participating in a specific event (league and season). This example shows a direct URL for fetching data.

```json
/event/world.2014/teams
```

```json
/event/en.2013_14/teams
```

--------------------------------

### List Rounds for an Event (JSONP)

Source: http://openfootball.github.io/docs/json-api-intro.html

Retrieve a list of all rounds (matchdays) for a given event (league and season). This example shows direct URLs for fetching round data.

```json
/event/world.2014/rounds
```

```json
/event/en.2013_14/rounds
```

--------------------------------

### Serve Football Data via HTTP JSON API

Source: http://openfootball.github.io/docs/intro.html

Start the sportdb command-line tool to serve football data through an HTTP JSON API. This command makes data like teams, rounds, and matches accessible.

```bash
$ sportdb serve

```

--------------------------------

### FIFA World Cup 2014 Match Schedule and Results

Source: http://openfootball.github.io/index.html

Example of match schedule and results for the FIFA World Cup 2014 in Football.TXT format.

```text
▪ Group A
Thu Jun 12
  17:00 UTC-3   Brazil   v Croatia   3-1 (1-1)      @ Arena de São Paulo, São Paulo
                 (Neymar 29', 71'pen Oscar 90+1'; Marcelo 11' og)
Fri Jun 13
  13:00 UTC-3   Mexico    v Cameroon  1-0 (0-0)     @ Estádio das Dunas, Natal 
                  (Oribe Peralta 61')
...

▪ Match for third place
Sat Jul 12 
  17:00 UTC-3   Brazil   v Netherlands   0-3 (0-2)   @ Estádio Nacional Mané Garrincha, Brasília
                  (Robin Van Persie 3'pen Daley Blind 17' Georginio Wijnaldum 90+1')
▪ Final
Sun Jul 13
  16:00 UTC-3   Germany  v Argentina   1-0 a.e.t. (0-0, 0-0)   @ Estádio do Maracanã, Rio de Janeiro
                  (Mario Götze 113')

```

--------------------------------

### Get All Teams via HTTP JSON API

Source: http://openfootball.github.io/docs/intro.html

Use this GET request to retrieve a list of all participating teams for a specific event, such as the 2014 World Cup. The response includes team keys, titles, and codes.

```http
GET /event/worldcup.2014/teams

{
  "event": {
    "key":   "worldcup.2014", "title": "World Cup 2014"
  },
  "teams": [
    { "key": "gre", "title": "Greece",      "code": "GRE" },
    { "key": "ned", "title": "Netherlands", "code": "NED" },
    { "key": "ger", "title": "Germany",     "code": "GER" },
    { "key": "por", "title": "Portugal",    "code": "POR" },
    ...
  ]
}

```

--------------------------------

### European Teams Data in CSV Format

Source: http://openfootball.github.io/docs/intro.html

Example of a plain text file listing European national football teams. Data is comma-separated and includes team codes, names, and affiliations.

```text
############
# UEFA (Union of European Football Associations)
# - 54 members

aut, Austria, AUT, at, fifa|uefa
bel, Belgium, BEL, be, fifa|uefa
cyp, Cyprus,  CYP, cy, fifa|uefa
...

```

--------------------------------

### Event Rounds JSON Response

Source: http://openfootball.github.io/docs/json-api-rounds.html

Example JSON response when fetching rounds for a specific event.

```json
{
  "event":{
    "key":"world.2014",
    "title":"World Cup 2014"},
  "rounds":[
    {"pos":1,"title":"Matchday 1","start_at":"2014/06/12","end_at":"2014/06/12"},
    {"pos":2,"title":"Matchday 2","start_at":"2014/06/13","end_at":"2014/06/13"},
    {"pos":3,"title":"Matchday 3","start_at":"2014/06/14","end_at":"2014/06/14"},
    {"pos":4,"title":"Matchday 4","start_at":"2014/06/15","end_at":"2014/06/15"},
    {"pos":5,"title":"Matchday 5","start_at":"2014/06/16","end_at":"2014/06/16"},
    {"pos":6,"title":"Matchday 6","start_at":"2014/06/17","end_at":"2014/06/17"},
    {"pos":7,"title":"Matchday 7","start_at":"2014/06/18","end_at":"2014/06/18"},
    {"pos":8,"title":"Matchday 8","start_at":"2014/06/19","end_at":"2014/06/19"},
    {"pos":9,"title":"Matchday 9","start_at":"2014/06/20","end_at":"2014/06/20"},
    {"pos":10,"title":"Matchday 10","start_at":"2014/06/21","end_at":"2014/06/21"},
    {"pos":11,"title":"Matchday 11","start_at":"2014/06/22","end_at":"2014/06/22"},
    {"pos":12,"title":"Matchday 12","start_at":"2014/06/23","end_at":"2014/06/23"},
    {"pos":13,"title":"Matchday 13","start_at":"2014/06/24","end_at":"2014/06/24"},
    {"pos":14,"title":"Matchday 14","start_at":"2014/06/25","end_at":"2014/06/25"},
    {"pos":15,"title":"Matchday 15","start_at":"2014/06/26","end_at":"2014/06/26"},
    {"pos":16,"title":"Round of 16","start_at":"1912/01/01","end_at":"1912/01/01"},
    {"pos":17,"title":"Quarter-finals","start_at":"1912/01/01","end_at":"1912/01/01"},
    {"pos":18,"title":"Semi-finals","start_at":"1912/01/01","end_at":"1912/01/01"},
    {"pos":19,"title":"Match for third place","start_at":"1912/01/01","end_at":"1912/01/01"},
    {"pos":20,"title":"Final","start_at":"1912/01/01","end_at":"1912/01/01"}]
}
```

--------------------------------

### Get Matches for a Specific Round via HTTP JSON API

Source: http://openfootball.github.io/docs/intro.html

Retrieve all matches for a given round (e.g., Matchday 1) of an event using this GET request. The response details the event, round, and a list of games with participating teams and scores.

```http
GET /event/world.2014/round/1

{
  "event": { "key": "world.2014", "title": "World Cup 2014" },
  "round": { "pos": 1, "title": "Matchday 1" },
  "games": [
    {
      "team1_key": "bra",
      "team1_title": "Brazil",
      "team1_code": "BRA",
      "team2_key": "cro",
      "team2_title": "Croatia",
      "team2_code": "CRO",
      "play_at": "2014/06/12",
      "score1": null,
      "score2": null,
      "score1ot": null,
      "score2ot": null,
      "score1p": null,
      "score2p": null
    }
  ]
}

```

--------------------------------

### FIFA World Cup 2014 Group Standings

Source: http://openfootball.github.io/index.html

Example of group standings for the FIFA World Cup 2014 in Football.TXT format.

```text
Group A  |  Brazil       Croatia              Mexico         Cameroon
Group B  |  Spain        Netherlands          Chile          Australia
Group C  |  Colombia     Greece               Côte d'Ivoire  Japan
Group D  |  Uruguay      Costa Rica           England        Italy
Group E  |  Switzerland  Ecuador              France         Honduras
Group F  |  Argentina    Bosnia-Herzegovina   Iran           Nigeria
Group G  |  Germany      Portugal             Ghana          United States
Group H  |  Belgium      Algeria              Russia         South Korea

...

```

--------------------------------

### Football.TXT Round Outline Format

Source: http://openfootball.github.io/index.html

Mandatory rule for round lines in Football.TXT format. Lines must start with '▪' or '::'.

```text
▪ Quarter-finals - 1st Leg
▪ Group A
▪ Match for third place
...
```

--------------------------------

### Parsed Football Squads (football.db Format Output)

Source: http://openfootball.github.io/news

Example of the structured 'football.db' format output generated from parsing Wikipedia wikitext. This format is used by the wikiscript organization.

```text
(1)  GK   Jefferson        #   9, Botafogo (BRA)
(2)  DF   Dani Alves       #  74, Barcelona (ESP)
...

```

--------------------------------

### List Rounds for Today or a Date (JSONP)

Source: http://openfootball.github.io/docs/json-api-intro.html

Retrieve all rounds scheduled for a specific date, including a special endpoint for today's rounds. This example shows direct URLs for fetching round data.

```json
/rounds/today
```

```json
/rounds/2014.6.30
```

--------------------------------

### RSSSF Football League Table Data (Plain Text Input)

Source: http://openfootball.github.io/news

Example of plain text football league table data from the RSSSF archive. This data can be imported into SQL databases.

```text
Round 1
[May 25]
Vasco da Gama   1-0 Portuguesa
 [Carlos Tenório 47']
Vitória         2-2 Internacional
 [Maxi Biancucchi 2', Gabriel Paulista 11'; Diego Forlán 29', Fred 63']
Corinthians     1-1 Botafogo
 [Paulinho 73'; Rafael Marques 24']
...

```

--------------------------------

### GET rounds for today or a date

Source: http://openfootball.github.io/docs/json-api-rounds.html

Retrieve rounds that are active today or on a specified date.

```APIDOC
## GET rounds for today or a date

### Description
Retrieves a list of rounds that are active on a specific date, or for the current day.

### Method
GET

### Endpoint
`/rounds/today` or `/rounds/:YYYY.MM.DD`

### Parameters
#### Path Parameters
- **YYYY.MM.DD** (string) - Optional - The specific date in YYYY.MM.DD format. If omitted, defaults to today.

### Response
#### Success Response (200)
- **rounds** (array) - A list of rounds active on the specified date.
  - **pos** (integer) - The position or number of the round.
  - **title** (string) - The title of the round (e.g., "20. Spieltag").
  - **start_at** (string) - The start date of the round (YYYY/MM/DD).
  - **end_at** (string) - The end date of the round (YYYY/MM/DD).
  - **event** (object) - Information about the event the round belongs to.
    - **key** (string) - The event key.
    - **title** (string) - The event title.

### Request Example
`GET /rounds/today`
`GET /rounds/2013.06.30`

### Response Example
```json
{
  "rounds":[
    {"pos":20,"title":"20. Spieltag","start_at":"2014/02/08","end_at":"2014/02/08",
     "event":{
       "key":"de.2013/14","title":"Deutsche Bundesliga 2013/14"}},
    {"pos":22,"title":"22. Runde","start_at":"2014/02/08","end_at":"2014/02/08",
     "event":{
       "key":"at.2013/14","title":"Österr. Bundesliga 2013/14"}}]
}
```
```

--------------------------------

### Get Rounds for an Event

Source: http://openfootball.github.io/docs/json-api-rounds.html

Retrieve all rounds for a given event (league and season). Use the event key to specify which event's rounds to fetch.

```bash
/event/world.2014/rounds – World Cup Rounds (Brazil 2014)
/event/de.2013_14/rounds – Deutsche Bundesliga Rounds (Season 2013/14)
```

--------------------------------

### GET teams for an event (league+season)

Source: http://openfootball.github.io/docs/json-api-teams.html

Retrieves a list of teams for a specified event, identified by a unique key. The key typically includes the league and season information.

```APIDOC
## GET /event/:key/teams

### Description
Retrieves a list of teams for a specified event, identified by a unique key. The key typically includes the league and season information.

### Method
GET

### Endpoint
/event/:key/teams

### Parameters
#### Path Parameters
- **key** (string) - Required - A unique identifier for the event, usually in the format 'league.season' or 'league.year'.

### Response
#### Success Response (200)
- **event** (object) - Information about the event.
  - **key** (string) - The unique key of the event.
  - **title** (string) - The title of the event.
- **teams** (array) - A list of teams participating in the event.
  - **key** (string) - The unique key of the team.
  - **title** (string) - The full name of the team.
  - **code** (string) - The short code or abbreviation for the team.

### Response Example
{
  "event": {
    "key":"world.2014",
    "title":"World Cup 2014"
  },
  "teams": [
    {"key":"gre","title":"Greece","code":"GRE"},
    {"key":"rus","title":"Russia","code":"RUS"}
  ]
}
```

--------------------------------

### Wikipedia Football Squads (Wikitext Input)

Source: http://openfootball.github.io/news

Example of wikitext used for football player data on Wikipedia. This format is parsed by the wikiscript organization.

```wikitext
{{nat fs player|no=1|pos=GK|name=[[Jefferson de Oliveira 
Galvão|Jefferson]]|age={{Birth date and 
age2|2014|6|12|1983|1|2|df=y}}|caps=9|club=[[Botafogo de Futebol e 
Regatas|Botafogo]]|clubnat=BRA}}
{{nat fs player|no=2|pos=DF|name=[[Dani Alves]]|age={{Birth date and 
age2|2014|6|12|1983|5|6|df=y}}|caps=74|club=[[FC 
Barcelona|Barcelona]]|clubnat=ESP}}
...

```

--------------------------------

### GET games in a round for an event

Source: http://openfootball.github.io/docs/json-api-games.html

Retrieves a list of games for a given event and round. The round can be specified by its position or as 'today'.

```APIDOC
## GET /event/:key/round/:pos|today

### Description
Retrieves a list of games for a specific event and round.

### Method
GET

### Endpoint
`/event/:key/round/:pos|today`

### Parameters
#### Path Parameters
- **key** (string) - Required - The unique key identifying the event (e.g., 'world.2014').
- **pos|today** (string) - Required - The position of the round (e.g., '2') or 'today' to get games for the current round.

### Request Example
`/event/world.2014/round/2`
`/event/de.2013_14/round/today`

### Response
#### Success Response (200)
- **event** (object) - Information about the event.
  - **key** (string) - The event key.
  - **title** (string) - The event title.
- **round** (object) - Information about the round.
  - **pos** (integer) - The round position.
  - **title** (string) - The round title.
  - **start_at** (string) - The start date of the round.
  - **end_at** (string) - The end date of the round.
- **games** (array) - A list of games played in the round.
  - **team1_key** (string) - The key of the first team.
  - **team1_title** (string) - The title of the first team.
  - **team1_code** (string) - The code of the first team.
  - **team2_key** (string) - The key of the second team.
  - **team2_title** (string) - The title of the second team.
  - **team2_code** (string) - The code of the second team.
  - **play_at** (string) - The date the game is played.
  - **score1** (integer|null) - The score for the first team (regular time).
  - **score2** (integer|null) - The score for the second team (regular time).
  - **score1ot** (integer|null) - The score for the first team (overtime).
  - **score2ot** (integer|null) - The score for the second team (overtime).
  - **score1p** (integer|null) - The score for the first team (penalties).
  - **score2p** (integer|null) - The score for the second team (penalties).

#### Response Example
```json
{
  "event":
    {"key":"world.2014","title":"World Cup 2014"},
  "round":
    {"pos":2,"title":"Matchday 2","start_at":"2014/06/13","end_at":"2014/06/13"},
  "games":[
    {"team1_key":"mex","team1_title":"Mexico","team1_code":"MEX","team2_key":"cmr","team2_title":"Cameroon","team2_code":"CMR","play_at":"2014/06/13","score1":null,"score2":null,"score1ot":null,"score2ot":null,"score1p":null,"score2p":null},
    {"team1_key":"esp","team1_title":"Spain","team1_code":"ESP","team2_key":"ned","team2_title":"Netherlands","team2_code":"NED","play_at":"2014/06/13","score1":null,"score2":null,"score1ot":null,"score2ot":null,"score1p":null,"score2p":null},
    {"team1_key":"chi","team1_title":"Chile","team1_code":"CHI","team2_key":"aus","team2_title":"Australia","team2_code":"AUS","play_at":"2014/06/13","score1":null,"score2":null,"score1ot":null,"score2ot":null,"score1p":null,"score2p":null}]
}
```
```

--------------------------------

### Date-Specific Rounds JSON Response

Source: http://openfootball.github.io/docs/json-api-rounds.html

Example JSON response when fetching rounds for a specific date.

```json
{
  "rounds":[
    {"pos":20,"title":"20. Spieltag","start_at":"2014/02/08","end_at":"2014/02/08",
     "event":{
       "key":"de.2013/14","title":"Deutsche Bundesliga 2013/14"}},
    {"pos":22,"title":"22. Runde","start_at":"2014/02/08","end_at":"2014/02/08",
     "event":{
       "key":"at.2013/14","title":"Österr. Bundesliga 2013/14"}}]
}
```

--------------------------------

### GET rounds for an event (league+season)

Source: http://openfootball.github.io/docs/json-api-rounds.html

Retrieve all rounds associated with a specific event, identified by its key (e.g., league and season).

```APIDOC
## GET rounds for an event (league+season)

### Description
Retrieves a list of rounds for a given event.

### Method
GET

### Endpoint
`/event/:key/rounds`

### Parameters
#### Path Parameters
- **key** (string) - Required - The unique key identifying the event (e.g., "world.2014", "de.2013_14").

### Response
#### Success Response (200)
- **event** (object) - Information about the event.
  - **key** (string) - The event key.
  - **title** (string) - The event title.
- **rounds** (array) - A list of rounds.
  - **pos** (integer) - The position or number of the round.
  - **title** (string) - The title of the round (e.g., "Matchday 1").
  - **start_at** (string) - The start date of the round (YYYY/MM/DD).
  - **end_at** (string) - The end date of the round (YYYY/MM/DD).

### Request Example
`GET /event/world.2014/rounds`

### Response Example
```json
{
  "event":{
    "key":"world.2014",
    "title":"World Cup 2014"},
  "rounds":[
    {"pos":1,"title":"Matchday 1","start_at":"2014/06/12","end_at":"2014/06/12"},
    {"pos":2,"title":"Matchday 2","start_at":"2014/06/13","end_at":"2014/06/13"}
  ]
}
```
```

--------------------------------

### Get Rounds for Today or a Specific Date

Source: http://openfootball.github.io/docs/json-api-rounds.html

Retrieve rounds for the current day or a specified date. The date should be in YYYY.MM.DD format.

```bash
/rounds/today
/rounds/2013.6.30
```

--------------------------------

### Wikipedia Mediawiki Markup for Group A Matches

Source: http://openfootball.github.io/docs/intro.html

Example of Mediawiki markup used on Wikipedia to display football match details. This format is used for wiki pages and can be parsed by Mediawiki software.

```mediawiki
===Group A===

{{{{main|2014 FIFA World Cup Group A}}}}
{{{{Fb cl2 header navbar}}}}
{{{{Fb cl2 team |t={{{{fb|BRA}}}} |w=0 |d=0 |l=0 |gf=0 |ga=0 |bc=}}}}
{{{{Fb cl2 team |t={{{{fb|CRO}}}} |w=0 |d=0 |l=0 |gf=0 |ga=0 |bc=|border=green}}}}
{{{{Fb cl2 team |t={{{{fb|MEX}}}} |w=0 |d=0 |l=0 |gf=0 |ga=0 |bc=}}}}
{{{{Fb cl2 team |t={{{{fb|CMR}}}} |w=0 |d=0 |l=0 |gf=0 |ga=0 |bc=}}}}
|

{{{{Football box
|date=12 June 2014
|time=17:00
|team1={{{{fb-rt|BRA}}}}
|score=[[2014 FIFA World Cup Group A#Brazil v Croatia|Match 1]]
|report=
|team2={{{{fb|CRO}}}}
|goals1=
|goals2=
|stadium=[[Arena Corinthians|Arena de São Paulo]], [[São Paulo]]
|attendance=
|referee=
}}}}
{{{{Football box
|date=13 June 2014
|time=13:00
|team1={{{{fb-rt|MEX}}}}
|score=[[2014 FIFA World Cup Group A#Mexico v Cameroon|Match 2]]
|report=
|team2={{{{fb|CMR}}}}
|goals1=
|goals2=
|stadium=[[Arena das Dunas]], [[Natal, Rio Grande do Norte|Natal]]
|attendance=
|referee=
}}}}



```

--------------------------------

### Get Teams for an Event

Source: http://openfootball.github.io/docs/json-api-teams.html

Use this endpoint to retrieve all teams participating in a given event, identified by its key. The response includes event details and a list of teams with their keys, titles, and codes.

```json
{
  "event": {
    "key":"world.2014",
    "title":"World Cup 2014"
  },
  "teams": [
    {"key":"gre","title":"Greece","code":"GRE"},
    {"key":"rus","title":"Russia","code":"RUS"},
    {"key":"ned","title":"Netherlands","code":"NED"},
    {"key":"ger","title":"Germany","code":"GER"},
    {"key":"por","title":"Portugal","code":"POR"},
    {"key":"esp","title":"Spain","code":"ESP"},
    {"key":"ita","title":"Italy","code":"ITA"},
    {"key":"cro","title":"Croatia","code":"CRO"},
    {"key":"fra","title":"France","code":"FRA"},
    {"key":"eng","title":"England","code":"ENG"},
    {"key":"sui","title":"Switzerland","code":"SUI"},
    {"key":"bel","title":"Belgium","code":"BEL"},
    {"key":"bih","title":"Bosnia-Herzegovina","code":"BIH"},
    {"key":"alg","title":"Algeria","code":"ALG"},
    {"key":"civ","title":"C000te d'Ivoire","code":"CIV"},
    {"key":"gha","title":"Ghana","code":"GHA"},
    {"key":"cmr","title":"Cameroon","code":"CMR"},
    {"key":"nga","title":"Nigeria","code":"NGA"},
    {"key":"mex","title":"Mexico","code":"MEX"},
    {"key":"usa","title":"United States","code":"USA"},
    {"key":"hon","title":"Honduras","code":"HON"},
    {"key":"crc","title":"Costa Rica","code":"CRC"},
    {"key":"arg","title":"Argentina","code":"ARG"},
    {"key":"bra","title":"Brazil","code":"BRA"},
    {"key":"chi","title":"Chile","code":"CHI"},
    {"key":"uru","title":"Uruguay","code":"URU"},
    {"key":"col","title":"Colombia","code":"COL"},
    {"key":"ecu","title":"Ecuador","code":"ECU"},
    {"key":"aus","title":"Australia","code":"AUS"},
    {"key":"jpn","title":"Japan","code":"JPN"},
    {"key":"kor","title":"South Korea","code":"KOR"},
    {"key":"irn","title":"Iran","code":"IRN"}
  ]
}
```

--------------------------------

### Get Games in a Round for an Event

Source: http://openfootball.github.io/docs/json-api-games.html

Use this endpoint to fetch all games scheduled for a specific round within a league or season. The round can be specified by its position or by using 'today' for the current day's matches.

```http
/event/:key/round/:pos|today
```

--------------------------------

### Build Football Database with Datafile

Source: http://openfootball.github.io/news

Use the Datafile DSL to define football data sources and then run 'sportdb build' to download, create tables, and import all datasets.

```ruby
world 'openmundi/world.db', setup: 'countries' 
football 'openfootball/national-teams' 
football 'openfootball/world-cup', setup: '2014' 

```

```bash
$ sportdb build 

```

--------------------------------

### Build Sport Database with sportdb

Source: http://openfootball.github.io/news

Use the `sportdb build` command to create a sport database, likely for testing or quick starter samples.

```bash
$ sportdb build 

```

--------------------------------

### Create Database from Datafile Template

Source: http://openfootball.github.io/news

Use the sportdb new command with a template name to automatically download a Datafile, set up the database schema, and import datasets.

```bash
$ sportdb new worldcup2014 

```

--------------------------------

### Query football.db with sqlite3

Source: http://openfootball.github.io/docs/sqlite.html

Connect to the football.db SQLite database and execute a sample query to retrieve all records from the 'teams' table.

```bash
$ sqlite3 football.db
sqlite> select * from teams;

```

--------------------------------

### Load Football.TXT Match Data into SQLite

Source: http://openfootball.github.io/news

Use the `football-to-sqlite` tool to load match data from Football.TXT files into a SQLite database. The database and its tables are auto-created if they do not exist.

```bash
$ football-to-sqlite england.db 2020-21\1-premierleague.txt

```

```bash
$ football-to-sqlite england.db 2020-21\1-premierleague.txt \
                                2020-21\2-championship.txt \
                                2020-21\3-league1.txt \
                                2020-21\4-league2.txt \
                                2020-21\5-nationalleague.txt

```

--------------------------------

### Rakefile for Building football.db

Source: http://openfootball.github.io/docs/build-script.html

This Rakefile defines tasks to clean, create, and import data for building a football.db database from scratch. It requires the worlddb, sportdb, and logutils gems.

```ruby
BUILD_DIR = "./build"

FOOTBALL_DB_PATH = "#{BUILD_DIR}/football.db"

DB_CONFIG = {
  :adapter   =>  'sqlite3',
  :database  =>  FOOTBALL_DB_PATH
}

directory BUILD_DIR

task :clean do
  rm FOOTBALL_DB_PATH if File.exists?( FOOTBALL_DB_PATH )
end

task :env => BUILD_DIR do
 require 'worlddb'  
 require 'sportdb'
 require 'logutils/db'

 LogUtils::Logger.root.level = :info

 pp DB_CONFIG
 ActiveRecord::Base.establish_connection( DB_CONFIG )
end

task :create => :env do
  LogDb.create
  WorldDb.create
  SportDb.create
end

task :importworld => :env do
  WorldDb.read_setup( 'setups/sport.db.admin', '../world.db', skip_tags: true )  # populate world tables
  # WorldDb.stats
end

task :importsport => :env do
  SportDb.read_builtin
  SportDb.read_setup( 'setups/all', '../openfootball/at-austria' )
  # SportDb.stats
end

desc 'footballdb - build from scratch'
task :build => [:clean, :create, :importworld, :importsport] do
  puts 'Done.'
end

```

--------------------------------

### List English Teams using SQL Table Query

Source: http://openfootball.github.io/docs/sql-queries-intro.html

Fetches team names and details for England by joining teams and countries tables. This query links teams to their respective countries.

```sql
SELECT c.name,
       t.*
  FROM teams t
       INNER JOIN countries c ON c.id = t.country_id
 WHERE c.key = 'en';
```

--------------------------------

### Pipe Downloaded Match Data to football-to-sqlite

Source: http://openfootball.github.io/news

Pipe match data downloaded via `curl` directly into the `football-to-sqlite` tool via standard input (STDIN).

```bash
$ curl https://raw.githubusercontent.com/openfootball/world-cup/master/2018--russia/cup.txt
| football-to-sqlite worldcup.db

```

--------------------------------

### ojogo Command for Today's Matches

Source: http://openfootball.github.io/news

Command to display today's World Cup 2014 matches using the ojogo tool. Defaults to the current date if no arguments are provided.

```shell
$ ojogo    # defaults to today's world cup 2014 matches 

```

--------------------------------

### Create New Football Season Data

Source: http://openfootball.github.io/news

Use the sportdb command to create new season data. Specify the season and country code for a targeted download, or omit for all seasons.

```bash
$ sportdb new en2015-16     # just the 2015-16 season, please
$ sportdb new en            # all seasons

```

--------------------------------

### JSONP Request with Plain JavaScript

Source: http://openfootball.github.io/docs/json-api-intro.html

Demonstrates how to make a JSONP request to the football.db API using plain JavaScript. Requires a callback function to handle the JSON response.

```javascript
<script>
  function handleGames( json ) {
    // Do something with the returned data
  }
</script>

<script src="http://footballdb.herokuapp.com/api/event/en.2013_14/round/4?callback=handleGames"></script>

```

--------------------------------

### World Cup Match Schedule in Mini Language

Source: http://openfootball.github.io/docs/intro.html

Demonstrates the mini football data language for structured match schedules. This format is designed to be human-readable while ensuring data accuracy.

```text
(1) Thu Jun/12 17:00   Brazil - Croatia    @ Arena de São Paulo, São Paulo (UTC-3)
(2) Fri Jun/13 13:00   Mexico - Cameroon   @ Estádio das Dunas, Natal (UTC-3)


```

--------------------------------

### Query Teams Table in Sport Database

Source: http://openfootball.github.io/news

Connect to a `sport.db` SQLite database and query the `teams` table.

```sql
sqlite> select * from teams;

```

--------------------------------

### Query Games List using SQL Tables (Before Views)

Source: http://openfootball.github.io/news

This is the older method of querying game data directly from tables, requiring joins for related information like team and round details.

```sql
SELECT t1.title, 
       t2.title, 
       g.*
  FROM games g 
       LEFT OUTER JOIN teams t1 ON t1.id = g.team1_id 
       LEFT OUTER JOIN teams t2 ON t2.id = g.team2_id 
       INNER JOIN rounds r ON r.id = g.round_id 
       INNER JOIN events e ON e.id = r.event_id 
 WHERE e.key = 'world.2014' 

```

--------------------------------

### JSONP Request with jQuery

Source: http://openfootball.github.io/docs/json-api-intro.html

Shows how to fetch data from the football.db API using jQuery's `getJSON()` function with JSONP enabled. The `callback=?` parameter is crucial for cross-domain requests.

```javascript
$.getJSON('http://footballdb.herokuapp.com/api/event/en.2013_14/round/4?callback=?', function(json) {
    // Do something with the returned data
});

```

--------------------------------

### List German Bundesliga Seasons using SQL Table Query

Source: http://openfootball.github.io/docs/sql-queries-intro.html

Retrieves season titles and details for the German Bundesliga by joining seasons, events, and leagues tables. This provides detailed season information linked to leagues.

```sql
SELECT l.title,
       s.*
  FROM seasons s
       INNER JOIN events e ON e.season_id = s.id
       INNER JOIN leagues l ON l.id = e.league_id
 WHERE l.key = 'de';
```

--------------------------------

### List World Cup 2014 Games using SQL View

Source: http://openfootball.github.io/docs/sql-queries-intro.html

Retrieves all game data for the World Cup 2014 from the events_games_list view. Use this to find all matches played in a specific event.

```sql
SELECT *
  FROM events_games_list
 WHERE event_key = 'world.2014';
```

--------------------------------

### List English Teams using SQL View

Source: http://openfootball.github.io/docs/sql-queries-intro.html

Fetches all team data for England from the teams_list view. This is useful for retrieving a list of teams associated with a specific country.

```sql
SELECT *
  FROM teams_list
 WHERE country_key = 'en';
```

--------------------------------

### Query Countries Table in Sport Database

Source: http://openfootball.github.io/news

Connect to a `sport.db` SQLite database and query the `countries` table.

```sql
sqlite> select * from countries;

```

--------------------------------

### List World Cup Brazil 2014 Teams using SQL Table Query

Source: http://openfootball.github.io/docs/sql-queries-intro.html

Fetches team details for the World Cup 2014 by joining teams, events_teams, and events tables. This query identifies teams participating in a specific event.

```sql
SELECT t.*
  FROM teams t
       INNER JOIN events_teams et ON et.team_id = t.id
       INNER JOIN events e ON e.id = et.event_id
 WHERE e.key = 'world.2014'
```

--------------------------------

### List German Bundesliga Events (Seasons) using SQL View

Source: http://openfootball.github.io/docs/sql-queries-intro.html

Retrieves all event data for the German Bundesliga from the events_list view. Use this to quickly access league-specific event information.

```sql
SELECT *
  FROM events_list
 WHERE league_key = 'de';
```

--------------------------------

### List all rounds for an event

Source: http://openfootball.github.io/docs/json-api-intro.html

Retrieves a list of all rounds (matchdays) for a specific event (league and season).

```APIDOC
## GET /event/:key/rounds

### Description
Retrieves a list of all rounds for a given event, identified by a unique key.

### Method
GET

### Endpoint
/event/:key/rounds

### Parameters
#### Path Parameters
- **key** (string) - Required - A unique identifier for the event (e.g., 'world.2014' or 'en.2013_14').

### Request Example
```
/event/world.2014/rounds
```

### Response
#### Success Response (200)
- rounds (array) - A list of round objects.

#### Response Example
(Example response structure not provided in source)
```

--------------------------------

### List Games in a Round for an Event (JSONP)

Source: http://openfootball.github.io/docs/json-api-intro.html

Retrieve all games within a specific round for an event (league and season). Supports fetching games for a specific round number or 'today'.

```json
/event/world.2014/round/20
```

```json
/event/en.2012_13/round/4
```

```json
/event/en.2013_14/round/today
```

--------------------------------

### List World Cup 2014 Games using SQL Table Query

Source: http://openfootball.github.io/docs/sql-queries-intro.html

Retrieves game details, including team titles and game information, for the World Cup 2014 by joining multiple tables. This query provides comprehensive game data linked to events.

```sql
SELECT t1.title,
       t2.title,
       g.*
  FROM games g
       INNER JOIN teams t1 ON t1.id = g.team1_id
       INNER JOIN teams t2 ON t2.id = g.team2_id
       INNER JOIN rounds r ON r.id = g.round_id
       INNER JOIN events e ON e.id = r.event_id
 WHERE e.key = 'world.2014'
```

--------------------------------

### Games API Reference

Source: http://openfootball.github.io/docs

Reference for accessing Game data via the HTTP JSON API.

```APIDOC
## GET /games

### Description
Retrieves a list of games.

### Method
GET

### Endpoint
/games

### Parameters
#### Query Parameters
None explicitly documented.

### Response
#### Success Response (200)
- **games** (array) - A list of game objects.

### Response Example
{
  "games": [
    {
      "id": 1,
      "home_team_id": 1,
      "away_team_id": 2
    }
  ]
}
```
Tokens:
Raw