Live Data API schema
Raw export of the LIVE Data API schema for reference.
Use Apollo Studio to interactively navigate the API
Hudl Statsbomb recommends using Apollo Studio GraphQL client, which provides an interactive way to navigate and search through the LIVE Data API.
schema {
query: query_root
subscription: subscription_root
}
"""whether this query should be cached (Hasura Cloud only)"""
directive @cached(
"""measured in seconds"""
ttl: Int! = 60
"""refresh the cache entry"""
refresh: Boolean! = false
) on QUERY
"""
Boolean expression to compare columns of type "Boolean". All fields are combined with logical 'AND'.
"""
input Boolean_comparison_exp {
_eq: Boolean
_gt: Boolean
_gte: Boolean
_in: [Boolean!]
_is_null: Boolean
_lt: Boolean
_lte: Boolean
_neq: Boolean
_nin: [Boolean!]
}
"""
Boolean expression to compare columns of type "Float". All fields are combined with logical 'AND'.
"""
input Float_comparison_exp {
_eq: Float
_gt: Float
_gte: Float
_in: [Float!]
_is_null: Boolean
_lt: Float
_lte: Float
_neq: Float
_nin: [Float!]
}
"""
Boolean expression to compare columns of type "Int". All fields are combined with logical 'AND'.
"""
input Int_comparison_exp {
_eq: Int
_gt: Int
_gte: Int
_in: [Int!]
_is_null: Boolean
_lt: Int
_lte: Int
_neq: Int
_nin: [Int!]
}
"""
Boolean expression to compare columns of type "String". All fields are combined with logical 'AND'.
"""
input String_comparison_exp {
_eq: String
_gt: String
_gte: String
"""does the column match the given case-insensitive pattern"""
_ilike: String
_in: [String!]
"""
does the column match the given POSIX regular expression, case insensitive
"""
_iregex: String
_is_null: Boolean
"""does the column match the given pattern"""
_like: String
_lt: String
_lte: String
_neq: String
"""does the column NOT match the given case-insensitive pattern"""
_nilike: String
_nin: [String!]
"""
does the column NOT match the given POSIX regular expression, case insensitive
"""
_niregex: String
"""does the column NOT match the given pattern"""
_nlike: String
"""
does the column NOT match the given POSIX regular expression, case sensitive
"""
_nregex: String
"""does the column NOT match the given SQL regular expression"""
_nsimilar: String
"""
does the column match the given POSIX regular expression, case sensitive
"""
_regex: String
"""does the column match the given SQL regular expression"""
_similar: String
}
scalar date
"""
Boolean expression to compare columns of type "date". All fields are combined with logical 'AND'.
"""
input date_comparison_exp {
_eq: date
_gt: date
_gte: date
_in: [date!]
_is_null: Boolean
_lt: date
_lte: date
_neq: date
_nin: [date!]
}
scalar event_status
"""
Boolean expression to compare columns of type "event_status". All fields are combined with logical 'AND'.
"""
input event_status_comparison_exp {
_eq: event_status
_gt: event_status
_gte: event_status
_in: [event_status!]
_is_null: Boolean
_lt: event_status
_lte: event_status
_neq: event_status
_nin: [event_status!]
}
scalar float8
"""
Boolean expression to compare columns of type "float8". All fields are combined with logical 'AND'.
"""
input float8_comparison_exp {
_eq: float8
_gt: float8
_gte: float8
_in: [float8!]
_is_null: Boolean
_lt: float8
_lte: float8
_neq: float8
_nin: [float8!]
}
scalar jsonb
"""
Boolean expression to compare columns of type "jsonb". All fields are combined with logical 'AND'.
"""
input jsonb_comparison_exp {
"""is the column contained in the given json value"""
_contained_in: jsonb
"""does the column contain the given json value at the top level"""
_contains: jsonb
_eq: jsonb
_gt: jsonb
_gte: jsonb
"""does the string exist as a top-level key in the column"""
_has_key: String
"""do all of these strings exist as top-level keys in the column"""
_has_keys_all: [String!]
"""do any of these strings exist as top-level keys in the column"""
_has_keys_any: [String!]
_in: [jsonb!]
_is_null: Boolean
_lt: jsonb
_lte: jsonb
_neq: jsonb
_nin: [jsonb!]
}
"""
columns and relationships of "live.area"
"""
type live_area {
area_code: String
area_id: Int
area_name: String
}
"""
Boolean expression to filter rows from the table "live.area". All fields are combined with a logical 'AND'.
"""
input live_area_bool_exp {
_and: [live_area_bool_exp!]
_not: live_area_bool_exp
_or: [live_area_bool_exp!]
area_code: String_comparison_exp
area_id: Int_comparison_exp
area_name: String_comparison_exp
}
"""Ordering options when selecting data from "live.area"."""
input live_area_order_by {
area_code: order_by
area_id: order_by
area_name: order_by
}
"""
select columns of table "live.area"
"""
enum live_area_select_column {
"""column name"""
area_code
"""column name"""
area_id
"""column name"""
area_name
}
"""
columns and relationships of "live.competition_season"
"""
type live_competition_season {
area_id: Int
competition_id: Int
competition_is_female: Boolean
competition_name: String
license_competition_id: Int
license_season_id: Int
season_id: Int
season_name: String
}
"""
Boolean expression to filter rows from the table "live.competition_season". All fields are combined with a logical 'AND'.
"""
input live_competition_season_bool_exp {
_and: [live_competition_season_bool_exp!]
_not: live_competition_season_bool_exp
_or: [live_competition_season_bool_exp!]
area_id: Int_comparison_exp
competition_id: Int_comparison_exp
competition_is_female: Boolean_comparison_exp
competition_name: String_comparison_exp
license_competition_id: Int_comparison_exp
license_season_id: Int_comparison_exp
season_id: Int_comparison_exp
season_name: String_comparison_exp
}
"""Ordering options when selecting data from "live.competition_season"."""
input live_competition_season_order_by {
area_id: order_by
competition_id: order_by
competition_is_female: order_by
competition_name: order_by
license_competition_id: order_by
license_season_id: order_by
season_id: order_by
season_name: order_by
}
"""
select columns of table "live.competition_season"
"""
enum live_competition_season_select_column {
"""column name"""
area_id
"""column name"""
competition_id
"""column name"""
competition_is_female
"""column name"""
competition_name
"""column name"""
license_competition_id
"""column name"""
license_season_id
"""column name"""
season_id
"""column name"""
season_name
}
"""
columns and relationships of "live.lineup"
"""
type live_lineup {
license_competition_id: Int
license_season_id: Int
lineup_jersey: Int
match_id: Int
player_country_of_birth: Int
player_date_of_birth: date
player_firstname: String
player_height: Float
player_id: Int
player_is_female: Boolean
player_lastname: String
player_lineup_selection_type: String
player_name: String
player_nationality: Int
player_nickname: String
player_preferred_foot: String
player_weight: Float
team_id: Int
team_name: String
}
"""
Boolean expression to filter rows from the table "live.lineup". All fields are combined with a logical 'AND'.
"""
input live_lineup_bool_exp {
_and: [live_lineup_bool_exp!]
_not: live_lineup_bool_exp
_or: [live_lineup_bool_exp!]
license_competition_id: Int_comparison_exp
license_season_id: Int_comparison_exp
lineup_jersey: Int_comparison_exp
match_id: Int_comparison_exp
player_country_of_birth: Int_comparison_exp
player_date_of_birth: date_comparison_exp
player_firstname: String_comparison_exp
player_height: Float_comparison_exp
player_id: Int_comparison_exp
player_is_female: Boolean_comparison_exp
player_lastname: String_comparison_exp
player_lineup_selection_type: String_comparison_exp
player_name: String_comparison_exp
player_nationality: Int_comparison_exp
player_nickname: String_comparison_exp
player_preferred_foot: String_comparison_exp
player_weight: Float_comparison_exp
team_id: Int_comparison_exp
team_name: String_comparison_exp
}
"""Ordering options when selecting data from "live.lineup"."""
input live_lineup_order_by {
license_competition_id: order_by
license_season_id: order_by
lineup_jersey: order_by
match_id: order_by
player_country_of_birth: order_by
player_date_of_birth: order_by
player_firstname: order_by
player_height: order_by
player_id: order_by
player_is_female: order_by
player_lastname: order_by
player_lineup_selection_type: order_by
player_name: order_by
player_nationality: order_by
player_nickname: order_by
player_preferred_foot: order_by
player_weight: order_by
team_id: order_by
team_name: order_by
}
"""
select columns of table "live.lineup"
"""
enum live_lineup_select_column {
"""column name"""
license_competition_id
"""column name"""
license_season_id
"""column name"""
lineup_jersey
"""column name"""
match_id
"""column name"""
player_country_of_birth
"""column name"""
player_date_of_birth
"""column name"""
player_firstname
"""column name"""
player_height
"""column name"""
player_id
"""column name"""
player_is_female
"""column name"""
player_lastname
"""column name"""
player_lineup_selection_type
"""column name"""
player_name
"""column name"""
player_nationality
"""column name"""
player_nickname
"""column name"""
player_preferred_foot
"""column name"""
player_weight
"""column name"""
team_id
"""column name"""
team_name
}
"""
columns and relationships of "live.match"
"""
type live_match {
competition_id: Int
license_competition_id: Int
license_season_id: Int
match_attendance: Int
match_away_penalty_score: Int
match_away_score: Int
match_away_team_id: Int
match_away_team_name: String
match_behind_closed_doors: Boolean
match_date: date
match_home_penalty_score: Int
match_home_score: Int
match_home_team_id: Int
match_home_team_name: String
match_id: Int
match_local_kick_off: time
match_name: String
match_neutral_ground: Boolean
match_play_status: String
match_weather: String
match_week: smallint
round_id: Int
round_type_name: String
season_id: Int
stadium_id: Int
stadium_name: String
}
"""
Boolean expression to filter rows from the table "live.match". All fields are combined with a logical 'AND'.
"""
input live_match_bool_exp {
_and: [live_match_bool_exp!]
_not: live_match_bool_exp
_or: [live_match_bool_exp!]
competition_id: Int_comparison_exp
license_competition_id: Int_comparison_exp
license_season_id: Int_comparison_exp
match_attendance: Int_comparison_exp
match_away_penalty_score: Int_comparison_exp
match_away_score: Int_comparison_exp
match_away_team_id: Int_comparison_exp
match_away_team_name: String_comparison_exp
match_behind_closed_doors: Boolean_comparison_exp
match_date: date_comparison_exp
match_home_penalty_score: Int_comparison_exp
match_home_score: Int_comparison_exp
match_home_team_id: Int_comparison_exp
match_home_team_name: String_comparison_exp
match_id: Int_comparison_exp
match_local_kick_off: time_comparison_exp
match_name: String_comparison_exp
match_neutral_ground: Boolean_comparison_exp
match_play_status: String_comparison_exp
match_weather: String_comparison_exp
match_week: smallint_comparison_exp
round_id: Int_comparison_exp
round_type_name: String_comparison_exp
season_id: Int_comparison_exp
stadium_id: Int_comparison_exp
stadium_name: String_comparison_exp
}
"""
columns and relationships of "live.match_event"
"""
type live_match_event {
advantage: Boolean
aerial_won: Boolean
assist: Boolean
backheel: Boolean
body_part: String
card: String
competition_id: Int
created_at: timestamp
defensive: Boolean
deflection: Boolean
distance_to_opponents_goal: Float
distance_to_own_goal: Float
duration: Float
end_x: Float
end_y: Float
end_z: Float
finished: Boolean
first_time: Boolean
formation: String
freeze_frame(
"""JSON select path"""
path: String
): jsonb
from_corner: Boolean
from_free_kick: Boolean
from_open_play: Boolean
from_set_piece: Boolean
from_throw_in: Boolean
from_penalty_box: Boolean
from_six_yard_box: Boolean
goal_against: Int
goal_for: Int
height: String
id: uuid
in_attacking_half: Boolean
in_defensive_half: Boolean
in_defensive_third: Boolean
in_final_third: Boolean
in_penalty_box: Boolean
in_six_yard_box: Boolean
index: Int
inside_attacking_half: Boolean
inside_defensive_half: Boolean
inside_defensive_third: Boolean
inside_final_third: Boolean
inside_penalty_box: Boolean
inside_six_yard_box: Boolean
into_attacking_half: Boolean
into_defensive_half: Boolean
into_defensive_third: Boolean
into_final_third: Boolean
into_penalty_box: Boolean
into_six_yard_box: Boolean
key_pass: Boolean
lineup(
"""JSON select path"""
path: String
): jsonb
match_clock_paused: Boolean
match_id: Int
minute: smallint
name: String
next_period: Int
no_touch: Boolean
nutmeg: Boolean
off_camera: Boolean
offensive: Boolean
opposition_id: Int
outcome: String
overrun: Boolean
penalty: Boolean
period: smallint
player_id: Int
position: String
recipient_id: Int
recovery_failure: Boolean
replacement_id: Int
save_block: Boolean
season_id: Int
second: smallint
start_x: Float
start_y: Float
start_z: Float
status: event_status
team_id: Int
technique: String
timestamp: time
type: String
updated_at: timestamp
xg: float8
}
"""
Boolean expression to filter rows from the table "live.match_event". All fields are combined with a logical 'AND'.
"""
input live_match_event_bool_exp {
_and: [live_match_event_bool_exp!]
_not: live_match_event_bool_exp
_or: [live_match_event_bool_exp!]
advantage: Boolean_comparison_exp
aerial_won: Boolean_comparison_exp
assist: Boolean_comparison_exp
backheel: Boolean_comparison_exp
body_part: String_comparison_exp
card: String_comparison_exp
competition_id: Int_comparison_exp
created_at: timestamp_comparison_exp
defensive: Boolean_comparison_exp
deflection: Boolean_comparison_exp
distance_to_opponents_goal: Float_comparison_exp
distance_to_own_goal: Float_comparison_exp
duration: Float_comparison_exp
end_x: Float_comparison_exp
end_y: Float_comparison_exp
end_z: Float_comparison_exp
finished: Boolean_comparison_exp
first_time: Boolean_comparison_exp
formation: String_comparison_exp
freeze_frame: jsonb_comparison_exp
from_corner: Boolean_comparison_exp
from_free_kick: Boolean_comparison_exp
from_open_play: Boolean_comparison_exp
from_set_piece: Boolean_comparison_exp
from_throw_in: Boolean_comparison_exp
from_penalty_box: Boolean_comparison_exp
from_six_yard_box: Boolean_comparison_exp
goal_against: Int_comparison_exp
goal_for: Int_comparison_exp
height: String_comparison_exp
id: uuid_comparison_exp
in_attacking_half: Boolean_comparison_exp
in_defensive_half: Boolean_comparison_exp
in_defensive_third: Boolean_comparison_exp
in_final_third: Boolean_comparison_exp
in_penalty_box: Boolean_comparison_exp
in_six_yard_box: Boolean_comparison_exp
index: Int_comparison_exp
inside_attacking_half: Boolean_comparison_exp
inside_defensive_half: Boolean_comparison_exp
inside_defensive_third: Boolean_comparison_exp
inside_final_third: Boolean_comparison_exp
inside_penalty_box: Boolean_comparison_exp
inside_six_yard_box: Boolean_comparison_exp
into_attacking_half: Boolean_comparison_exp
into_defensive_half: Boolean_comparison_exp
into_defensive_third: Boolean_comparison_exp
into_final_third: Boolean_comparison_exp
into_penalty_box: Boolean_comparison_exp
into_six_yard_box: Boolean_comparison_exp
key_pass: Boolean_comparison_exp
lineup: jsonb_comparison_exp
match_clock_paused: Boolean_comparison_exp
match_id: Int_comparison_exp
minute: smallint_comparison_exp
name: String_comparison_exp
next_period: Int_comparison_exp
no_touch: Boolean_comparison_exp
nutmeg: Boolean_comparison_exp
off_camera: Boolean_comparison_exp
offensive: Boolean_comparison_exp
opposition_id: Int_comparison_exp
outcome: String_comparison_exp
overrun: Boolean_comparison_exp
penalty: Boolean_comparison_exp
period: smallint_comparison_exp
player_id: Int_comparison_exp
position: String_comparison_exp
recipient_id: Int_comparison_exp
recovery_failure: Boolean_comparison_exp
replacement_id: Int_comparison_exp
save_block: Boolean_comparison_exp
season_id: Int_comparison_exp
second: smallint_comparison_exp
start_x: Float_comparison_exp
start_y: Float_comparison_exp
start_z: Float_comparison_exp
status: event_status_comparison_exp
team_id: Int_comparison_exp
technique: String_comparison_exp
timestamp: time_comparison_exp
type: String_comparison_exp
updated_at: timestamp_comparison_exp
xg: float8_comparison_exp
}
"""Ordering options when selecting data from "live.match_event"."""
input live_match_event_order_by {
advantage: order_by
aerial_won: order_by
assist: order_by
backheel: order_by
body_part: order_by
card: order_by
competition_id: order_by
created_at: order_by
defensive: order_by
deflection: order_by
distance_to_opponents_goal: order_by
distance_to_own_goal: order_by
duration: order_by
end_x: order_by
end_y: order_by
end_z: order_by
finished: order_by
first_time: order_by
formation: order_by
freeze_frame: order_by
from_corner: order_by
from_free_kick: order_by
from_open_play: order_by
from_set_piece: order_by
from_throw_in: order_by
from_penalty_box: order_by
from_six_yard_box: order_by
goal_against: order_by
goal_for: order_by
height: order_by
id: order_by
in_attacking_half: order_by
in_defensive_half: order_by
in_defensive_third: order_by
in_final_third: order_by
in_penalty_box: order_by
in_six_yard_box: order_by
index: order_by
inside_attacking_half: order_by
inside_defensive_half: order_by
inside_defensive_third: order_by
inside_final_third: order_by
inside_penalty_box: order_by
inside_six_yard_box: order_by
into_attacking_half: order_by
into_defensive_half: order_by
into_defensive_third: order_by
into_final_third: order_by
into_penalty_box: order_by
into_six_yard_box: order_by
key_pass: order_by
lineup: order_by
match_clock_paused: order_by
match_id: order_by
minute: order_by
name: order_by
next_period: order_by
no_touch: order_by
nutmeg: order_by
off_camera: order_by
offensive: order_by
opposition_id: order_by
outcome: order_by
overrun: order_by
penalty: order_by
period: order_by
player_id: order_by
position: order_by
recipient_id: order_by
recovery_failure: order_by
replacement_id: order_by
save_block: order_by
season_id: order_by
second: order_by
start_x: order_by
start_y: order_by
start_z: order_by
status: order_by
team_id: order_by
technique: order_by
timestamp: order_by
type: order_by
updated_at: order_by
xg: order_by
}
"""
select columns of table "live.match_event"
"""
enum live_match_event_select_column {
"""column name"""
advantage
"""column name"""
aerial_won
"""column name"""
assist
"""column name"""
backheel
"""column name"""
body_part
"""column name"""
card
"""column name"""
competition_id
"""column name"""
created_at
"""column name"""
defensive
"""column name"""
deflection
"""column name"""
distance_to_opponents_goal
"""column name"""
distance_to_own_goal
"""column name"""
duration
"""column name"""
end_x
"""column name"""
end_y
"""column name"""
end_z
"""column name"""
finished
"""column name"""
first_time
"""column name"""
formation
"""column name"""
freeze_frame
"""column name"""
from_corner
"""column name"""
from_free_kick
"""column name"""
from_open_play
"""column name"""
from_set_piece
"""column name"""
from_throw_in
"""column name"""
from_penalty_box
"""column name"""
from_six_yard_box
"""column name"""
goal_against
"""column name"""
goal_for
"""column name"""
height
"""column name"""
id
"""column name"""
in_attacking_half
"""column name"""
in_defensive_half
"""column name"""
in_defensive_third
"""column name"""
in_final_third
"""column name"""
in_penalty_box
"""column name"""
in_six_yard_box
"""column name"""
index
"""column name"""
inside_attacking_half
"""column name"""
inside_defensive_half
"""column name"""
inside_defensive_third
"""column name"""
inside_final_third
"""column name"""
inside_penalty_box
"""column name"""
inside_six_yard_box
"""column name"""
into_attacking_half
"""column name"""
into_defensive_half
"""column name"""
into_defensive_third
"""column name"""
into_final_third
"""column name"""
into_penalty_box
"""column name"""
into_six_yard_box
"""column name"""
key_pass
"""column name"""
lineup
"""column name"""
match_clock_paused
"""column name"""
match_id
"""column name"""
minute
"""column name"""
name
"""column name"""
next_period
"""column name"""
no_touch
"""column name"""
nutmeg
"""column name"""
off_camera
"""column name"""
offensive
"""column name"""
opposition_id
"""column name"""
outcome
"""column name"""
overrun
"""column name"""
penalty
"""column name"""
period
"""column name"""
player_id
"""column name"""
position
"""column name"""
recipient_id
"""column name"""
recovery_failure
"""column name"""
replacement_id
"""column name"""
save_block
"""column name"""
season_id
"""column name"""
second
"""column name"""
start_x
"""column name"""
start_y
"""column name"""
start_z
"""column name"""
status
"""column name"""
team_id
"""column name"""
technique
"""column name"""
timestamp
"""column name"""
type
"""column name"""
updated_at
"""column name"""
xg
}
"""Ordering options when selecting data from "live.match"."""
input live_match_order_by {
competition_id: order_by
license_competition_id: order_by
license_season_id: order_by
match_attendance: order_by
match_away_penalty_score: order_by
match_away_score: order_by
match_away_team_id: order_by
match_away_team_name: order_by
match_behind_closed_doors: order_by
match_date: order_by
match_home_penalty_score: order_by
match_home_score: order_by
match_home_team_id: order_by
match_home_team_name: order_by
match_id: order_by
match_local_kick_off: order_by
match_name: order_by
match_neutral_ground: order_by
match_play_status: order_by
match_weather: order_by
match_week: order_by
round_id: order_by
round_type_name: order_by
season_id: order_by
stadium_id: order_by
stadium_name: order_by
}
"""
select columns of table "live.match"
"""
enum live_match_select_column {
"""column name"""
competition_id
"""column name"""
license_competition_id
"""column name"""
license_season_id
"""column name"""
match_attendance
"""column name"""
match_away_penalty_score
"""column name"""
match_away_score
"""column name"""
match_away_team_id
"""column name"""
match_away_team_name
"""column name"""
match_behind_closed_doors
"""column name"""
match_date
"""column name"""
match_home_penalty_score
"""column name"""
match_home_score
"""column name"""
match_home_team_id
"""column name"""
match_home_team_name
"""column name"""
match_id
"""column name"""
match_local_kick_off
"""column name"""
match_name
"""column name"""
match_neutral_ground
"""column name"""
match_play_status
"""column name"""
match_weather
"""column name"""
match_week
"""column name"""
round_id
"""column name"""
round_type_name
"""column name"""
season_id
"""column name"""
stadium_id
"""column name"""
stadium_name
}
"""
columns and relationships of "live.player_match_aggregated_stat"
"""
type live_player_match_aggregated_stat {
competition_id: smallint
match_id: Int
player_id: Int
season_id: smallint
stat_name: String
team_id: Int
value: float8
}
"""
Boolean expression to filter rows from the table "live.player_match_aggregated_stat". All fields are combined with a logical 'AND'.
"""
input live_player_match_aggregated_stat_bool_exp {
_and: [live_player_match_aggregated_stat_bool_exp!]
_not: live_player_match_aggregated_stat_bool_exp
_or: [live_player_match_aggregated_stat_bool_exp!]
competition_id: smallint_comparison_exp
match_id: Int_comparison_exp
player_id: Int_comparison_exp
season_id: smallint_comparison_exp
stat_name: String_comparison_exp
team_id: Int_comparison_exp
value: float8_comparison_exp
}
"""
Ordering options when selecting data from "live.player_match_aggregated_stat".
"""
input live_player_match_aggregated_stat_order_by {
competition_id: order_by
match_id: order_by
player_id: order_by
season_id: order_by
stat_name: order_by
team_id: order_by
value: order_by
}
"""
select columns of table "live.player_match_aggregated_stat"
"""
enum live_player_match_aggregated_stat_select_column {
"""column name"""
competition_id
"""column name"""
match_id
"""column name"""
player_id
"""column name"""
season_id
"""column name"""
stat_name
"""column name"""
team_id
"""column name"""
value
}
"""
columns and relationships of "live.player_season_aggregated_stat"
"""
type live_player_season_aggregated_stat {
competition_id: smallint
player_id: Int
season_id: smallint
stat_name: String
value: float8
}
"""
Boolean expression to filter rows from the table "live.player_season_aggregated_stat". All fields are combined with a logical 'AND'.
"""
input live_player_season_aggregated_stat_bool_exp {
_and: [live_player_season_aggregated_stat_bool_exp!]
_not: live_player_season_aggregated_stat_bool_exp
_or: [live_player_season_aggregated_stat_bool_exp!]
competition_id: smallint_comparison_exp
player_id: Int_comparison_exp
season_id: smallint_comparison_exp
stat_name: String_comparison_exp
value: float8_comparison_exp
}
"""
Ordering options when selecting data from "live.player_season_aggregated_stat".
"""
input live_player_season_aggregated_stat_order_by {
competition_id: order_by
player_id: order_by
season_id: order_by
stat_name: order_by
value: order_by
}
"""
select columns of table "live.player_season_aggregated_stat"
"""
enum live_player_season_aggregated_stat_select_column {
"""column name"""
competition_id
"""column name"""
player_id
"""column name"""
season_id
"""column name"""
stat_name
"""column name"""
value
}
"""
columns and relationships of "live.player_team_season_aggregated_stat"
"""
type live_player_team_season_aggregated_stat {
competition_id: smallint
player_id: Int
season_id: smallint
stat_name: String
team_id: Int
value: float8
}
"""
Boolean expression to filter rows from the table "live.player_team_season_aggregated_stat". All fields are combined with a logical 'AND'.
"""
input live_player_team_season_aggregated_stat_bool_exp {
_and: [live_player_team_season_aggregated_stat_bool_exp!]
_not: live_player_team_season_aggregated_stat_bool_exp
_or: [live_player_team_season_aggregated_stat_bool_exp!]
competition_id: smallint_comparison_exp
player_id: Int_comparison_exp
season_id: smallint_comparison_exp
stat_name: String_comparison_exp
team_id: Int_comparison_exp
value: float8_comparison_exp
}
"""
Ordering options when selecting data from "live.player_team_season_aggregated_stat".
"""
input live_player_team_season_aggregated_stat_order_by {
competition_id: order_by
player_id: order_by
season_id: order_by
stat_name: order_by
team_id: order_by
value: order_by
}
"""
select columns of table "live.player_team_season_aggregated_stat"
"""
enum live_player_team_season_aggregated_stat_select_column {
"""column name"""
competition_id
"""column name"""
player_id
"""column name"""
season_id
"""column name"""
stat_name
"""column name"""
team_id
"""column name"""
value
}
"""
columns and relationships of "live.team_match_aggregated_stat"
"""
type live_team_match_aggregated_stat {
competition_id: smallint
match_id: Int
season_id: smallint
stat_name: String
team_id: Int
value: float8
}
"""
Boolean expression to filter rows from the table "live.team_match_aggregated_stat". All fields are combined with a logical 'AND'.
"""
input live_team_match_aggregated_stat_bool_exp {
_and: [live_team_match_aggregated_stat_bool_exp!]
_not: live_team_match_aggregated_stat_bool_exp
_or: [live_team_match_aggregated_stat_bool_exp!]
competition_id: smallint_comparison_exp
match_id: Int_comparison_exp
season_id: smallint_comparison_exp
stat_name: String_comparison_exp
team_id: Int_comparison_exp
value: float8_comparison_exp
}
"""
Ordering options when selecting data from "live.team_match_aggregated_stat".
"""
input live_team_match_aggregated_stat_order_by {
competition_id: order_by
match_id: order_by
season_id: order_by
stat_name: order_by
team_id: order_by
value: order_by
}
"""
select columns of table "live.team_match_aggregated_stat"
"""
enum live_team_match_aggregated_stat_select_column {
"""column name"""
competition_id
"""column name"""
match_id
"""column name"""
season_id
"""column name"""
stat_name
"""column name"""
team_id
"""column name"""
value
}
"""
columns and relationships of "live.team_season_aggregated_stat"
"""
type live_team_season_aggregated_stat {
competition_id: smallint
season_id: smallint
stat_name: String
team_id: Int
value: float8
}
"""
Boolean expression to filter rows from the table "live.team_season_aggregated_stat". All fields are combined with a logical 'AND'.
"""
input live_team_season_aggregated_stat_bool_exp {
_and: [live_team_season_aggregated_stat_bool_exp!]
_not: live_team_season_aggregated_stat_bool_exp
_or: [live_team_season_aggregated_stat_bool_exp!]
competition_id: smallint_comparison_exp
season_id: smallint_comparison_exp
stat_name: String_comparison_exp
team_id: Int_comparison_exp
value: float8_comparison_exp
}
"""
Ordering options when selecting data from "live.team_season_aggregated_stat".
"""
input live_team_season_aggregated_stat_order_by {
competition_id: order_by
season_id: order_by
stat_name: order_by
team_id: order_by
value: order_by
}
"""
select columns of table "live.team_season_aggregated_stat"
"""
enum live_team_season_aggregated_stat_select_column {
"""column name"""
competition_id
"""column name"""
season_id
"""column name"""
stat_name
"""column name"""
team_id
"""column name"""
value
}
"""column ordering options"""
enum order_by {
"""in ascending order, nulls last"""
asc
"""in ascending order, nulls first"""
asc_nulls_first
"""in ascending order, nulls last"""
asc_nulls_last
"""in descending order, nulls first"""
desc
"""in descending order, nulls first"""
desc_nulls_first
"""in descending order, nulls last"""
desc_nulls_last
}
type query_root {
"""
fetch data from the table: "live.area"
"""
live_area(
"""distinct select on columns"""
distinct_on: [live_area_select_column!]
"""limit the number of rows returned"""
limit: Int
"""skip the first n rows. Use only with order_by"""
offset: Int
"""sort the rows by one or more columns"""
order_by: [live_area_order_by!]
"""filter the rows returned"""
where: live_area_bool_exp
): [live_area!]!
"""
fetch data from the table: "live.competition_season"
"""
live_competition_season(
"""distinct select on columns"""
distinct_on: [live_competition_season_select_column!]
"""limit the number of rows returned"""
limit: Int
"""skip the first n rows. Use only with order_by"""
offset: Int
"""sort the rows by one or more columns"""
order_by: [live_competition_season_order_by!]
"""filter the rows returned"""
where: live_competition_season_bool_exp
): [live_competition_season!]!
"""
fetch data from the table: "live.lineup"
"""
live_lineup(
"""distinct select on columns"""
distinct_on: [live_lineup_select_column!]
"""limit the number of rows returned"""
limit: Int
"""skip the first n rows. Use only with order_by"""
offset: Int
"""sort the rows by one or more columns"""
order_by: [live_lineup_order_by!]
"""filter the rows returned"""
where: live_lineup_bool_exp
): [live_lineup!]!
"""
fetch data from the table: "live.match"
"""
live_match(
"""distinct select on columns"""
distinct_on: [live_match_select_column!]
"""limit the number of rows returned"""
limit: Int
"""skip the first n rows. Use only with order_by"""
offset: Int
"""sort the rows by one or more columns"""
order_by: [live_match_order_by!]
"""filter the rows returned"""
where: live_match_bool_exp
): [live_match!]!
"""
fetch data from the table: "live.match_event"
"""
live_match_event(
"""distinct select on columns"""
distinct_on: [live_match_event_select_column!]
"""limit the number of rows returned"""
limit: Int
"""skip the first n rows. Use only with order_by"""
offset: Int
"""sort the rows by one or more columns"""
order_by: [live_match_event_order_by!]
"""filter the rows returned"""
where: live_match_event_bool_exp
): [live_match_event!]!
"""
fetch data from the table: "live.player_match_aggregated_stat"
"""
live_player_match_aggregated_stat(
"""distinct select on columns"""
distinct_on: [live_player_match_aggregated_stat_select_column!]
"""limit the number of rows returned"""
limit: Int
"""skip the first n rows. Use only with order_by"""
offset: Int
"""sort the rows by one or more columns"""
order_by: [live_player_match_aggregated_stat_order_by!]
"""filter the rows returned"""
where: live_player_match_aggregated_stat_bool_exp
): [live_player_match_aggregated_stat!]!
"""
fetch data from the table: "live.player_season_aggregated_stat"
"""
live_player_season_aggregated_stat(
"""distinct select on columns"""
distinct_on: [live_player_season_aggregated_stat_select_column!]
"""limit the number of rows returned"""
limit: Int
"""skip the first n rows. Use only with order_by"""
offset: Int
"""sort the rows by one or more columns"""
order_by: [live_player_season_aggregated_stat_order_by!]
"""filter the rows returned"""
where: live_player_season_aggregated_stat_bool_exp
): [live_player_season_aggregated_stat!]!
"""
fetch data from the table: "live.player_team_season_aggregated_stat"
"""
live_player_team_season_aggregated_stat(
"""distinct select on columns"""
distinct_on: [live_player_team_season_aggregated_stat_select_column!]
"""limit the number of rows returned"""
limit: Int
"""skip the first n rows. Use only with order_by"""
offset: Int
"""sort the rows by one or more columns"""
order_by: [live_player_team_season_aggregated_stat_order_by!]
"""filter the rows returned"""
where: live_player_team_season_aggregated_stat_bool_exp
): [live_player_team_season_aggregated_stat!]!
"""
fetch data from the table: "live.team_match_aggregated_stat"
"""
live_team_match_aggregated_stat(
"""distinct select on columns"""
distinct_on: [live_team_match_aggregated_stat_select_column!]
"""limit the number of rows returned"""
limit: Int
"""skip the first n rows. Use only with order_by"""
offset: Int
"""sort the rows by one or more columns"""
order_by: [live_team_match_aggregated_stat_order_by!]
"""filter the rows returned"""
where: live_team_match_aggregated_stat_bool_exp
): [live_team_match_aggregated_stat!]!
"""
fetch data from the table: "live.team_season_aggregated_stat"
"""
live_team_season_aggregated_stat(
"""distinct select on columns"""
distinct_on: [live_team_season_aggregated_stat_select_column!]
"""limit the number of rows returned"""
limit: Int
"""skip the first n rows. Use only with order_by"""
offset: Int
"""sort the rows by one or more columns"""
order_by: [live_team_season_aggregated_stat_order_by!]
"""filter the rows returned"""
where: live_team_season_aggregated_stat_bool_exp
): [live_team_season_aggregated_stat!]!
}
scalar smallint
"""
Boolean expression to compare columns of type "smallint". All fields are combined with logical 'AND'.
"""
input smallint_comparison_exp {
_eq: smallint
_gt: smallint
_gte: smallint
_in: [smallint!]
_is_null: Boolean
_lt: smallint
_lte: smallint
_neq: smallint
_nin: [smallint!]
}
type subscription_root {
"""
fetch data from the table: "live.area"
"""
live_area(
"""distinct select on columns"""
distinct_on: [live_area_select_column!]
"""limit the number of rows returned"""
limit: Int
"""skip the first n rows. Use only with order_by"""
offset: Int
"""sort the rows by one or more columns"""
order_by: [live_area_order_by!]
"""filter the rows returned"""
where: live_area_bool_exp
): [live_area!]!
"""
fetch data from the table: "live.competition_season"
"""
live_competition_season(
"""distinct select on columns"""
distinct_on: [live_competition_season_select_column!]
"""limit the number of rows returned"""
limit: Int
"""skip the first n rows. Use only with order_by"""
offset: Int
"""sort the rows by one or more columns"""
order_by: [live_competition_season_order_by!]
"""filter the rows returned"""
where: live_competition_season_bool_exp
): [live_competition_season!]!
"""
fetch data from the table: "live.lineup"
"""
live_lineup(
"""distinct select on columns"""
distinct_on: [live_lineup_select_column!]
"""limit the number of rows returned"""
limit: Int
"""skip the first n rows. Use only with order_by"""
offset: Int
"""sort the rows by one or more columns"""
order_by: [live_lineup_order_by!]
"""filter the rows returned"""
where: live_lineup_bool_exp
): [live_lineup!]!
"""
fetch data from the table: "live.match"
"""
live_match(
"""distinct select on columns"""
distinct_on: [live_match_select_column!]
"""limit the number of rows returned"""
limit: Int
"""skip the first n rows. Use only with order_by"""
offset: Int
"""sort the rows by one or more columns"""
order_by: [live_match_order_by!]
"""filter the rows returned"""
where: live_match_bool_exp
): [live_match!]!
"""
fetch data from the table: "live.match_event"
"""
live_match_event(
"""distinct select on columns"""
distinct_on: [live_match_event_select_column!]
"""limit the number of rows returned"""
limit: Int
"""skip the first n rows. Use only with order_by"""
offset: Int
"""sort the rows by one or more columns"""
order_by: [live_match_event_order_by!]
"""filter the rows returned"""
where: live_match_event_bool_exp
): [live_match_event!]!
"""
fetch data from the table: "live.player_match_aggregated_stat"
"""
live_player_match_aggregated_stat(
"""distinct select on columns"""
distinct_on: [live_player_match_aggregated_stat_select_column!]
"""limit the number of rows returned"""
limit: Int
"""skip the first n rows. Use only with order_by"""
offset: Int
"""sort the rows by one or more columns"""
order_by: [live_player_match_aggregated_stat_order_by!]
"""filter the rows returned"""
where: live_player_match_aggregated_stat_bool_exp
): [live_player_match_aggregated_stat!]!
"""
fetch data from the table: "live.player_season_aggregated_stat"
"""
live_player_season_aggregated_stat(
"""distinct select on columns"""
distinct_on: [live_player_season_aggregated_stat_select_column!]
"""limit the number of rows returned"""
limit: Int
"""skip the first n rows. Use only with order_by"""
offset: Int
"""sort the rows by one or more columns"""
order_by: [live_player_season_aggregated_stat_order_by!]
"""filter the rows returned"""
where: live_player_season_aggregated_stat_bool_exp
): [live_player_season_aggregated_stat!]!
"""
fetch data from the table: "live.player_team_season_aggregated_stat"
"""
live_player_team_season_aggregated_stat(
"""distinct select on columns"""
distinct_on: [live_player_team_season_aggregated_stat_select_column!]
"""limit the number of rows returned"""
limit: Int
"""skip the first n rows. Use only with order_by"""
offset: Int
"""sort the rows by one or more columns"""
order_by: [live_player_team_season_aggregated_stat_order_by!]
"""filter the rows returned"""
where: live_player_team_season_aggregated_stat_bool_exp
): [live_player_team_season_aggregated_stat!]!
"""
fetch data from the table: "live.team_match_aggregated_stat"
"""
live_team_match_aggregated_stat(
"""distinct select on columns"""
distinct_on: [live_team_match_aggregated_stat_select_column!]
"""limit the number of rows returned"""
limit: Int
"""skip the first n rows. Use only with order_by"""
offset: Int
"""sort the rows by one or more columns"""
order_by: [live_team_match_aggregated_stat_order_by!]
"""filter the rows returned"""
where: live_team_match_aggregated_stat_bool_exp
): [live_team_match_aggregated_stat!]!
"""
fetch data from the table: "live.team_season_aggregated_stat"
"""
live_team_season_aggregated_stat(
"""distinct select on columns"""
distinct_on: [live_team_season_aggregated_stat_select_column!]
"""limit the number of rows returned"""
limit: Int
"""skip the first n rows. Use only with order_by"""
offset: Int
"""sort the rows by one or more columns"""
order_by: [live_team_season_aggregated_stat_order_by!]
"""filter the rows returned"""
where: live_team_season_aggregated_stat_bool_exp
): [live_team_season_aggregated_stat!]!
}
scalar time
"""
Boolean expression to compare columns of type "time". All fields are combined with logical 'AND'.
"""
input time_comparison_exp {
_eq: time
_gt: time
_gte: time
_in: [time!]
_is_null: Boolean
_lt: time
_lte: time
_neq: time
_nin: [time!]
}
scalar timestamp
"""
Boolean expression to compare columns of type "timestamp". All fields are combined with logical 'AND'.
"""
input timestamp_comparison_exp {
_eq: timestamp
_gt: timestamp
_gte: timestamp
_in: [timestamp!]
_is_null: Boolean
_lt: timestamp
_lte: timestamp
_neq: timestamp
_nin: [timestamp!]
}
scalar uuid
"""
Boolean expression to compare columns of type "uuid". All fields are combined with logical 'AND'.
"""
input uuid_comparison_exp {
_eq: uuid
_gt: uuid
_gte: uuid
_in: [uuid!]
_is_null: Boolean
_lt: uuid
_lte: uuid
_neq: uuid
_nin: [uuid!]
}