Glossary
This page contains definitions for all the stats currently offered as betting markets by our partners.
Team & Match Stats
| Stat | Description | SQL |
|---|---|---|
| Shots | All team events where name is equal to 'shot'. | WHERE name = 'shot' |
| Shots on Target | All team events where name is equal to 'shot' and outcome is in 'goal', 'saved' or 'saved-to-post'. | WHERE (name = 'shot') AND (outcome IN ('goal', 'saved', 'saved-to-post')) |
| Goals | All team events where either name is equal to 'shot' and outcome is equal to 'goal', or name is equal to 'own-goal-for'. | WHERE ((name = 'shot') AND (outcome = 'goal')) OR (name = 'own-goal-for') |
| Passes | All team events where name is equal to 'pass'. | WHERE name = 'pass' |
| Successful Passes | All team events where name is equal to 'pass' and outcome is in 'success', 'complete' or 'won'. | WHERE (name = 'pass') AND (outcome IN ('success', 'complete', 'won')) |
| Tackles | All team events where name is equal to 'duel' and type is equal to 'tackle'. | WHERE (name = 'duel') AND (type = 'tackle') |
| Direct Free Kick Goals | All team events where name is equal to 'shot', type is equal to 'free-kick' and outcome is equal to 'goal'. | WHERE (name = 'shot') AND (type = 'free-kick') AND (outcome = 'goal') |
| Headed Goals | All team events where body part is equal to 'head', name is equal to 'shot' and outcome is equal to 'goal'. | WHERE (body_part = 'head') AND (name = 'shot') AND (outcome = 'goal') |
| Penalty Goals | All team events where name is equal to 'shot', type is equal to 'penalty' and outcome is equal to 'goal'. | WHERE (name = 'shot') AND (type = 'penalty') AND (outcome = 'goal') |
| Goals inside Penalty Box | All team events where is inside penalty box, name is equal to 'shot' and outcome is equal to 'goal'. | WHERE inside_penalty_box AND (name = 'shot') AND (outcome = 'goal') |
| Goals outside Penalty Box | All team events where either is not inside penalty box, or inside penalty box is null, name is equal to 'shot' and outcome is equal to 'goal'. | WHERE (NOT inside_penalty_box OR (inside_penalty_box IS NULL)) AND (name = 'shot') AND (outcome = 'goal') |
| Fouls By | All team events where name is equal to 'foul-committed', either is not advantage, or advantage is null and either type is not equal to 'offside', or type is null. | WHERE (name = 'foul-committed') AND (NOT advantage OR (advantage IS NULL)) AND ((type <> 'offside') OR (type IS NULL)) |
| Goalkeeper Saves | All team events where name is equal to 'goal-keeper' and type is in 'penalty-saved', 'penalty-saved-to-post', 'shot-saved', 'shot-saved-off-target' or 'shot-saved-to-post'. | WHERE (name = 'goal-keeper') AND (type IN ('penalty-saved', 'penalty-saved-to-post', 'shot-saved', 'shot-saved-off-target', 'shot-saved-to-post')) |
| Corners | All team events where type is equal to 'corner' and name is in 'pass' or 'shot'. | WHERE (type = 'corner') AND (name IN ('pass', 'shot')) |
| Cards | All team events where card is in 'yellow-card', 'red-card' or 'second-yellow' and name is in 'foul-committed' or 'bad-behaviour'. Cards can be given to players on the pitch and on the bench, during regular time (not including extra time) and not after the final whistle. | WHERE (card IN ('yellow-card', 'red-card', 'second-yellow')) AND (name IN ('foul-committed', 'bad-behaviour')) |
| Goal Kicks | All team events where name is equal to 'pass' and type is equal to 'goal-kick'. Time recorded when goal-kick taken. | WHERE (name = 'pass') AND (type = 'goal-kick') |
| Free Kicks | All team events where type is equal to 'free-kick' and name is in 'pass' or 'shot'. Time recorded when free-kick taken. | WHERE (type = 'free-kick') AND (name IN ('pass', 'shot')) |
| Throw Ins | All team events where name is equal to 'pass' and type is equal to 'throw-in'. Time recorded when throw-in taken. | WHERE (name = 'pass') AND (type = 'throw-in') |
| Offsides | All team events where name is equal to 'foul-committed' and type is equal to 'offside'. An offside is classified as where a player is deemed to be in an offside position, and a free kick is awarded. | WHERE (name = 'foul-committed') AND (type = 'offside') |
| Woodwork Shots | All team events where name is equal to 'shot' and outcome is in 'post' or 'saved-to-post'. | WHERE (name = 'shot') AND (outcome IN ('post', 'saved-to-post')) |
Player Stats
| Stat | Description | SQL |
|---|---|---|
| Shots | All player events where name is equal to 'shot'. | WHERE name = 'shot' |
| Shots on Target | All player events where name is equal to 'shot' and outcome is in 'goal', 'saved' or 'saved-to-post'. | WHERE (name = 'shot') AND (outcome IN ('goal', 'saved', 'saved-to-post')) |
| Goals | All player events where either name is equal to 'shot' and outcome is equal to 'goal', or name is equal to 'own-goal-for'. | WHERE ((name = 'shot') AND (outcome = 'goal')) OR (name = 'own-goal-for') |
| Passes | All player events where name is equal to 'pass'. | WHERE name = 'pass' |
| Successful Passes | All player events where name is equal to 'pass' and outcome is in 'success', 'complete' or 'won'. | WHERE (name = 'pass') AND (outcome IN ('success', 'complete', 'won')) |
| Tackles | All player events where name is equal to 'duel' and type is equal to 'tackle'. | WHERE (name = 'duel') AND (type = 'tackle') |
| Assists | All player events where is assist and name is in 'pass' or 'shot'. | WHERE assist AND (name IN ('pass', 'shot')) |
| Direct Free Kick Goals | All player events where name is equal to 'shot', type is equal to 'free-kick' and outcome is equal to 'goal'. | WHERE (name = 'shot') AND (type = 'free-kick') AND (outcome = 'goal') |
| Headed Goals | All player events where body part is equal to 'head', name is equal to 'shot' and outcome is equal to 'goal'. | WHERE (body_part = 'head') AND (name = 'shot') AND (outcome = 'goal') |
| Penalty Goals | All player events where name is equal to 'shot', type is equal to 'penalty' and outcome is equal to 'goal'. | WHERE (name = 'shot') AND (type = 'penalty') AND (outcome = 'goal') |
| Goals inside Penalty Box | All player events where is inside penalty box, name is equal to 'shot' and outcome is equal to 'goal'. | WHERE inside_penalty_box AND (name = 'shot') AND (outcome = 'goal') |
| Goals outside Penalty Box | All player events where either is not inside penalty box, or inside penalty box is null, name is equal to 'shot' and outcome is equal to 'goal'. | WHERE (NOT inside_penalty_box OR (inside_penalty_box IS NULL)) AND (name = 'shot') AND (outcome = 'goal') |
| Fouls By | All player events where name is equal to 'foul-committed', either is not advantage, or advantage is null and either type is not equal to 'offside', or type is null. | WHERE (name = 'foul-committed') AND (NOT advantage OR (advantage IS NULL)) AND ((type <> 'offside') OR (type IS NULL)) |
| Goalkeeper Saves | All player events where name is equal to 'goal-keeper' and type is in 'penalty-saved', 'penalty-saved-to-post', 'shot-saved', 'shot-saved-off-target' or 'shot-saved-to-post'. | WHERE (name = 'goal-keeper') AND (type IN ('penalty-saved', 'penalty-saved-to-post', 'shot-saved', 'shot-saved-off-target', 'shot-saved-to-post')) |
| Cards | All player events where card is in 'yellow-card', 'red-card' or 'second-yellow' and name is in 'foul-committed' or 'bad-behaviour'. Cards can be given to players on the pitch and on the bench, during regular time (not including extra time) and not after the final whistle. | WHERE (card IN ('yellow-card', 'red-card', 'second-yellow')) AND (name IN ('foul-committed', 'bad-behaviour')) |
| Goal Kicks | All player events where name is equal to 'pass' and type is equal to 'goal-kick'. Time recorded when goal-kick taken. | WHERE (name = 'pass') AND (type = 'goal-kick') |
| Free Kicks | All player events where type is equal to 'free-kick' and name is in 'pass' or 'shot'. Time recorded when free-kick taken. | WHERE (type = 'free-kick') AND (name IN ('pass', 'shot')) |
| Throw Ins | All player events where name is equal to 'pass' and type is equal to 'throw-in'. Time recorded when throw-in taken. | WHERE (name = 'pass') AND (type = 'throw-in') |
| Offsides | All player events where name is equal to 'foul-committed' and type is equal to 'offside'. An offside is classified as where a player is deemed to be in an offside position, and a free kick is awarded. | WHERE (name = 'foul-committed') AND (type = 'offside') |
| Woodwork Shots | All player events where name is equal to 'shot' and outcome is in 'post' or 'saved-to-post'. | WHERE (name = 'shot') AND (outcome IN ('post', 'saved-to-post')) |