STAT-API

PGA GraphQL Reference

Every professional golf tournament — the four majors, the PGA Tour stops, the FedExCup playoffs — broken down to the round, leaderboard, hole-by-hole and shot-by-shot ShotLink/TrackMan tracking, and the players, courses, season-long stats, and tournament odds behind them.

Every GraphQL type, relation, argument, and field — generated from the served schema, so it can never disagree with the API. Each column is documented inline; relations and foreign keys link straight to the type they resolve to. Root fields take the same filters as REST; requests are metered by rows resolved, nested lists included.

Main

playersPGAPlayers
Every professional golfer — active tour members, conditional-status players, alumni who have competed at the highest level, and country-of-origin information.
REST endpoint →Open in playground →
Fields (18)
idBigIntkey

Primary Key

league_idStringnullable

Official tour player identifier

ex: 52955
first_nameString
ex: Michael
last_nameString
ex: Kim
full_nameString
ex: Zach Johnson
league_player_idInt→ PGAPlayers

Official PGA Tour player id

ex: 52955
short_nameStringnullable
ex: C. Johnson
countryStringnullable
ex: USA
birth_dateStringnullable
ex: 1989-07-23T04:00:00.000Z
birth_cityStringnullable
ex: Seoul
birth_stateStringnullable
ex: California
birth_countryStringnullable
ex: United States
swingsStringnullable

Right, Left

collegeStringnullable
ex: Oklahoma State University
photo_urlStringnullable
pga_debut_yearIntnullable
ex: 2019
created_atString
updated_atString
Relations (12)
leaderboards[PGALeaderboards!]!→ PGALeaderboards

golf.leaderboards rows whose player_id references this row.

operator_player_lookups[PGAOperatorPlayerLookups!]!→ PGAOperatorPlayerLookups

golf.operator_player_lookups rows whose player_id references this row.

player_holes[PGAPlayerHoles!]!→ PGAPlayerHoles

golf.player_holes rows whose player_id references this row.

player_news[PGAPlayerNews!]!→ PGAPlayerNews

golf.player_news rows whose player_id references this row.

player_rounds[PGAPlayerRounds!]!→ PGAPlayerRounds

golf.player_rounds rows whose player_id references this row.

player_season_stats[PGAPlayerSeasonStats!]!→ PGAPlayerSeasonStats

golf.player_season_stats rows whose player_id references this row.

player_shots[PGAPlayerShots!]!→ PGAPlayerShots

golf.player_shots rows whose player_id references this row.

tournament_odds_by_player_id[PGATournamentOdds!]!→ PGATournamentOdds

golf.tournament_odds rows whose player_id references this row.

tournament_odds_by_matchup_opponent_id[PGATournamentOdds!]!→ PGATournamentOdds

golf.tournament_odds rows whose matchup_opponent_id references this row.

tournament_odds_by_round_matchup_opponent_id[PGATournamentOdds!]!→ PGATournamentOdds

golf.tournament_odds rows whose round_matchup_opponent_id references this row.

tournament_odds_by_three_ball_opponent1_id[PGATournamentOdds!]!→ PGATournamentOdds

golf.tournament_odds rows whose three_ball_opponent1_id references this row.

tournament_odds_by_three_ball_opponent2_id[PGATournamentOdds!]!→ PGATournamentOdds

golf.tournament_odds rows whose three_ball_opponent2_id references this row.

Arguments (2)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
seasonsPGASeasons
Each season on a professional golf tour — the year-long schedule of tournaments leading up to the FedExCup playoffs (PGA), the major championships, and the season-ending Tour Championship.
REST endpoint →Open in playground →
Fields (8)
league_idStringnullable

Official tour season identifier

ex: liv-2021
start_dateString
ex: 2021-01-01T00:00:00.000Z
end_dateStringnullable
ex: 2021-12-31T00:00:00.000Z
start_yearInt
ex: 2021
tour_idBigInt→ PGATours
ex: 14
created_atString
updated_atString
idBigIntkey

Primary Key

Relations (3)
tourPGATours→ PGATours

The golf.tours row referenced by tour_id; null when unlinked.

player_season_stats[PGAPlayerSeasonStats!]!→ PGAPlayerSeasonStats

golf.player_season_stats rows whose season_id references this row.

tournaments[PGATournaments!]!→ PGATournaments

golf.tournaments rows whose season_id references this row.

Arguments (2)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
tournamentsPGATournaments
Every professional golf tournament — the four majors (Masters, PGA Championship, U.S. Open, Open Championship), the PGA Tour stops, LIV events, the FedExCup playoffs, and Korn Ferry Tour events.
REST endpoint →Open in playground →
Required filters: one of season_id.
Fields (24)
idBigIntkey

Primary Key

league_idStringnullable

Official tour tournament identifier

ex: R2025016
nameString
ex: The RSM Classic
tournament_idInt→ PGATournaments
ex: 2025016
tour_idBigIntnullable→ PGATours
ex: 12
start_dateString
ex: 2025-03-06T00:00:00.000Z
end_dateStringnullable
is_overBoolean
ex: trueValues:truefalse
is_in_progressBoolean
ex: false
venueStringnullable
ex: Torrey Pines Golf Course (South Course)
parIntnullable
yardsIntnullable
purseBigIntnullable

Total prize money in cents

ex: 2000000000
start_date_timeStringnullable
canceledBoolean
ex: false
cityStringnullable
ex: Ponte Vedra Beach
stateStringnullable
ex: California
zipStringnullable
countryStringnullable
ex: United States of AmericaValues:United States of AmericaMexicoJapanBermudaPuerto RicoDominican RepublicScotlandCanadaEnglandNorthern IrelandFranceItalySouth KoreaPeople's Republic of ChinaAustralia
time_zoneStringnullable
roundsIntnullable
created_atString
updated_atString
season_idBigIntnullable→ PGASeasons
ex: 22
Relations (10)
seasonPGASeasons→ PGASeasons

The golf.seasons row referenced by season_id; null when unlinked.

tourPGATours→ PGATours

The golf.tours row referenced by tour_id; null when unlinked.

course_hole_stats[PGACourseHoleStats!]!→ PGACourseHoleStats

golf.course_hole_stats rows whose tournament_id references this row.

leaderboards[PGALeaderboards!]!→ PGALeaderboards

golf.leaderboards rows whose tournament_id references this row.

player_holes[PGAPlayerHoles!]!→ PGAPlayerHoles

golf.player_holes rows whose tournament_id references this row.

player_news[PGAPlayerNews!]!→ PGAPlayerNews

golf.player_news rows whose tournament_id references this row.

player_rounds[PGAPlayerRounds!]!→ PGAPlayerRounds

golf.player_rounds rows whose tournament_id references this row.

player_shots[PGAPlayerShots!]!→ PGAPlayerShots

golf.player_shots rows whose tournament_id references this row.

tournament_odds[PGATournamentOdds!]!→ PGATournamentOdds

golf.tournament_odds rows whose tournament_id references this row.

tournament_rounds[PGATournamentRounds!]!→ PGATournamentRounds

golf.tournament_rounds rows whose tournament_id references this row.

Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • season_idIntFilter to a single season. Defaults to the current season.
  • tour_idIntFilter by tour.

Plays

player_holesPGAPlayerHoles
Hole-by-hole scoring for each player at each professional tournament — strokes and score relative to par per hole. (Shot-level tracking — drive distance, approach result, putts — is not carried here.)
REST endpoint →Open in playground →
Required filters: one of player_id | tournament_id.
Fields (19)
idBigIntkey

Primary Key

tournament_idBigInt→ PGATournaments
ex: 255
player_idBigInt→ PGAPlayers
ex: 193
player_round_idBigInt
ex: 1
round_numberInt
ex: 1
hole_numberInt
ex: 1
parIntnullable
ex: 4
scoreIntnullable
ex: 4
to_parIntnullable

Score relative to par for this hole

ex: 0
hole_in_oneBooleannullable
ex: false
double_eagleBooleannullable
eagleBooleannullable
ex: falseValues:falsetrue
birdieBooleannullable
ex: falseValues:falsetrue
is_parBooleannullable
ex: trueValues:truefalse
bogeyBooleannullable
ex: falseValues:falsetrue
double_bogeyBooleannullable
ex: falseValues:falsetrue
worse_than_double_bogeyBooleannullable
ex: falseValues:falsetrue
created_atString
updated_atString
Relations (3)
playerPGAPlayers→ PGAPlayers

The golf.players row referenced by player_id; null when unlinked.

player_roundPGAPlayerRounds→ PGAPlayerRounds

The golf.player_rounds row referenced by player_round_id; null when unlinked.

tournamentPGATournaments→ PGATournaments

The golf.tournaments row referenced by tournament_id; null when unlinked.

Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • player_idIntFilter to a single player.
  • tournament_idIntFilter to a single tournament.
player_roundsPGAPlayerRounds
Each player's scoring line for each round of every professional golf tournament — total strokes, score relative to par, eagles, birdies, bogeys, and double-bogeys. (Ball-striking detail — fairways, greens in regulation, putts — is not carried here.)
REST endpoint →Open in playground →
Required filters: one of player_id | tournament_id.
Fields (28)
idBigIntkey

Primary Key

tournament_idBigInt→ PGATournaments
ex: 887
player_idBigInt→ PGAPlayers
ex: 194
player_round_idInt
ex: 475911
round_numberInt
ex: 1
dayStringnullable
tee_timeStringnullable
back_nine_startBooleannullable
parIntnullable
ex: 72
scoreIntnullable

Total strokes for round

ex: 70
double_eaglesIntnullable
ex: 0
eaglesIntnullable
ex: 0
birdiesIntnullable
ex: 4
parsIntnullable
ex: 12
bogeysIntnullable
ex: 2
double_bogeysIntnullable
ex: 0
worse_than_double_bogeyIntnullable
ex: 0
triple_bogeysIntnullable
ex: 0
worse_than_triple_bogeyIntnullable
ex: 0
holes_in_oneIntnullable
ex: 0
created_atString
updated_atString
sg_totalFloatnullable
ex: -0.1640
sg_off_teeFloatnullable
ex: 0.8570
sg_approachFloatnullable
ex: -0.8480
sg_around_greenFloatnullable
ex: 0.7610
sg_puttingFloatnullable
ex: 1.6950
sg_tee_to_greenFloatnullable
ex: 0.2610
Relations (3)
playerPGAPlayers→ PGAPlayers

The golf.players row referenced by player_id; null when unlinked.

tournamentPGATournaments→ PGATournaments

The golf.tournaments row referenced by tournament_id; null when unlinked.

player_holes[PGAPlayerHoles!]!→ PGAPlayerHoles

golf.player_holes rows whose player_round_id references this row.

Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • player_idIntFilter to a single player.
  • tournament_idIntFilter to a single tournament.
player_shotsPGAPlayerShots
Shot-by-shot tracking for each player at each professional tournament — every stroke with its type, start/end location, distance, ShotLink/TOURCAST course coordinates, and TrackMan radar metrics (club & ball speed, spin, launch angle, apex, carry). Available for regular PGA Tour events with ShotLink; majors such as the Masters do not publish shot tracking.
REST endpoint →Open in playground →
Required filters: one of player_id | tournament_id.
Fields (32)
idBigIntkey

Primary Key

tournament_idBigInt→ PGATournaments
ex: 255
player_idBigInt→ PGAPlayers
ex: 20
round_numberInt
ex: 3
hole_numberInt
ex: 9
shot_numberInt

Stroke sequence within the hole (1 = first stroke)

ex: 1
parIntnullable
ex: 4
stroke_typeStringnullable

STROKE, PENALTY, DROP, PROVISIONAL

ex: STROKEValues:STROKEDROPPENALTYPROVISIONAL
from_locationStringnullable
ex: GreenValues:GreenTee BoxFairwayPrimary RoughIntermediate RoughGreenside BunkerFairway BunkerNative AreaOtherFringe
to_locationStringnullable
ex: Green
from_location_codeStringnullable
ex: OGRValues:OGROTBOFWOROOIROGSOSTONAOTHOCO
to_location_codeStringnullable
ex: OGR
distance_yardsFloatnullable

Shot distance in yards (null when the source reports feet near the green)

ex: 289
distance_remaining_yardsFloatnullable

Distance to the hole after the shot, in yards

ex: 145
play_by_playStringnullable
ex: In the hole
final_strokeBooleannullable
ex: falseValues:falsetrue
from_xFloatnullable
ex: 7309.9
from_yFloatnullable
ex: 11300.88
from_zFloatnullable
ex: 246.065
to_xFloatnullable
ex: 5799.6
to_yFloatnullable
ex: 12140.75
to_zFloatnullable
ex: 358.62
club_speedFloatnullable
ex: 0
ball_speedFloatnullable
ex: 175.15
smash_factorFloatnullable
ex: 0
launch_spinFloatnullable
ex: 0
spin_axisFloatnullable
ex: 0
launch_angleFloatnullable

Vertical launch angle (degrees)

ex: 8.74
apex_heightFloatnullable
ex: 99.61
carry_distanceFloatnullable
ex: 269.59
created_atString
updated_atString
Relations (2)
playerPGAPlayers→ PGAPlayers

The golf.players row referenced by player_id; null when unlinked.

tournamentPGATournaments→ PGATournaments

The golf.tournaments row referenced by tournament_id; null when unlinked.

Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • player_idIntFilter to a single player.
  • tournament_idIntFilter to a single tournament.
tournament_roundsPGATournamentRounds
Each round of every professional golf tournament — round 1 (Thursday), round 2 (Friday cut day), and the weekend rounds (Saturday and Sunday) plus any playoff holes.
REST endpoint →Open in playground →
Required filters: one of tournament_id.
Fields (7)
idBigIntkey

Primary Key

tournament_idBigInt→ PGATournaments
ex: 1
round_idInt
ex: 20250161
round_numberInt
ex: 1
dayString
ex: 2025-03-05T05:00:00.000Z
created_atString
updated_atString
Relations (1)
tournamentPGATournaments→ PGATournaments

The golf.tournaments row referenced by tournament_id; null when unlinked.

Arguments (3)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • tournament_idIntFilter to a single tournament.

Stats

operator_player_lookupsPGAOperatorPlayerLookups
How each sportsbook and fantasy operator names every professional golfer — the mapping from each operator's player identifier to a unified player record.
REST endpoint →Open in playground →
Required filters: one of operator_id.
Fields (7)
idBigIntkey

Primary Key

operator_idBigInt→ ReferenceOperators

Operator id: 1 DraftKings, 2 FanDuel, 3 Yahoo, 13 sportsdata.io.

ex: 2228
operator_player_idString→ PGAPlayers

External player ID from operator

ex: 52955
player_idBigInt→ PGAPlayers

Internal golf.players.id reference

ex: 1
player_nameStringnullable

Player name for reconciliation

ex: Ludvig Åberg
created_atString
updated_atString
Relations (2)
operatorReferenceOperators→ ReferenceOperators

The main.operators row referenced by operator_id; null when unlinked.

playerPGAPlayers→ PGAPlayers

The golf.players row referenced by player_id; null when unlinked.

Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • operator_idIntFilter by operator.
  • player_idIntFilter to a single player.
player_season_statsPGAPlayerSeasonStats
Season totals for each professional golfer — events played, cuts made, top-10 finishes, wins, and prize money earned. Ball-striking and strokes-gained metrics are not carried here.
REST endpoint →Open in playground →
Required filters: one of season_id | player_id.
Fields (42)
idBigIntkey

Primary Key

player_idBigInt→ PGAPlayers
ex: 38
tour_idBigIntnullable→ PGATours
ex: 12
eventsIntnullable
ex: 1
cuts_madeIntnullable
ex: 1
winsIntnullable
ex: 0
second_placeIntnullable
ex: 0
third_placeIntnullable
ex: 0
top_fiveIntnullable
ex: 0
top_tenIntnullable
ex: 0
top_twenty_fiveIntnullable
ex: 0
roundsIntnullable
ex: 4
total_strokesIntnullable
ex: 5654
total_scoreIntnullable

Total score relative to par

ex: -120
double_eaglesIntnullable
ex: 0
eaglesIntnullable
ex: 0
birdiesIntnullable
ex: 17
parsIntnullable
ex: 46
bogeysIntnullable
ex: 9
double_bogeysIntnullable
ex: 0
worse_than_double_bogeyIntnullable
ex: 0
triple_bogeysIntnullable
ex: 0
worse_than_triple_bogeyIntnullable
ex: 0
holes_in_oneIntnullable
ex: 0
streaks_of_three_birdies_or_betterIntnullable
ex: 0
bogey_free_roundsIntnullable
ex: 0
rounds_under_seventyIntnullable
ex: 1
bounce_back_countIntnullable
consecutive_birdie_or_better_countIntnullable
created_atString
updated_atString
driving_distanceFloatnullable

Average driving distance in yards

ex: 295.6000
driving_accuracy_pctFloatnullable
ex: 55.2500
gir_pctFloatnullable

Greens in regulation percentage

ex: 66.3900
putts_per_roundFloatnullable
ex: 28.8900
scrambling_pctFloatnullable
ex: 58.6000
sg_totalFloatnullable
ex: -0.8370
sg_off_teeFloatnullable
ex: -0.2285
sg_approachFloatnullable
ex: 0.0663
sg_around_greenFloatnullable
ex: 0.4845
sg_puttingFloatnullable
ex: -1.2805
season_idBigIntnullable→ PGASeasons
ex: 5
Relations (3)
playerPGAPlayers→ PGAPlayers

The golf.players row referenced by player_id; null when unlinked.

seasonPGASeasons→ PGASeasons

The golf.seasons row referenced by season_id; null when unlinked.

tourPGATours→ PGATours

The golf.tours row referenced by tour_id; null when unlinked.

Arguments (5)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • season_idIntFilter to a single season. Defaults to the current season.
  • player_idIntFilter to a single player.
  • tour_idIntFilter by tour.
course_hole_statsPGACourseHoleStats
Per-hole scoring statistics for each round of a tournament — par, yardage, the field's scoring average and its relation to par, and the distribution of eagles, birdies, pars, and bogeys, plus difficulty rank.
REST endpoint →Open in playground →
Required filters: one of tournament_id.
Fields (17)
idBigIntkey

Primary Key

tournament_idBigInt→ PGATournaments
ex: 887
course_codeString

PGA Tour course code (e.g., 014 = Augusta National)

ex: 006
round_numberInt
ex: 2
hole_numberInt
ex: 1
parIntnullable
ex: 4
yardsIntnullable
ex: 450
scoring_averageFloatnullable
ex: 4.0000
scoring_average_diffFloatnullable

Scoring average relative to par

ex: 0.0000
eaglesIntnullable
ex: 0
birdiesIntnullable
ex: 8
parsIntnullable
ex: 50
bogeysIntnullable
ex: 4
double_bogeysIntnullable
ex: 0
rankIntnullable

Difficulty rank among holes (1 = hardest)

ex: 1
created_atString
updated_atString
Relations (1)
tournamentPGATournaments→ PGATournaments

The golf.tournaments row referenced by tournament_id; null when unlinked.

Arguments (3)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • tournament_idIntFilter to a single tournament.
leaderboardsPGALeaderboards
The full leaderboard of every professional golf tournament — each player's position, score relative to par, total strokes, made cut/missed cut status, and prize money.
REST endpoint →Open in playground →
Required filters: one of tournament_id | player_id.
Fields (25)
idBigIntkey

Primary Key

tournament_idBigInt→ PGATournaments
ex: 257
player_tournament_idInt→ PGATournaments
ex: 54591
player_idBigInt→ PGAPlayers
ex: 61
rankIntnullable
ex: 2
total_scoreIntnullable

Score relative to par

ex: -1
total_strokesIntnullable
ex: 143
total_throughIntnullable

Current hole of player for current round

earningsBigIntnullable

Prize money earned in cents

fedex_ptsIntnullable
made_cutIntnullable

1 if made cut, 0 if missed

ex: 1
made_cut_did_not_finishBooleannullable
winIntnullable

1 if won tournament

ex: 0
is_alternateBooleannullable
is_withdrawnBooleannullable
ex: falseValues:falsetrue
tournament_statusStringnullable

out, active, etc.

ex: COMPLETEValues:COMPLETEWITHDRAWNDISQUALIFIED
tee_timeStringnullable
created_atString
updated_atString
sg_totalFloatnullable
ex: -0.3120
sg_off_teeFloatnullable
ex: 0.6840
sg_approachFloatnullable
ex: 11.7050
sg_around_greenFloatnullable
ex: 4.4940
sg_puttingFloatnullable
ex: 7.1580
sg_tee_to_greenFloatnullable
ex: 16.4630
Relations (2)
playerPGAPlayers→ PGAPlayers

The golf.players row referenced by player_id; null when unlinked.

tournamentPGATournaments→ PGATournaments

The golf.tournaments row referenced by tournament_id; null when unlinked.

Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • tournament_idIntFilter to a single tournament.
  • player_idIntFilter to a single player.

Odds

tournament_oddsPGATournamentOdds
Outright betting odds for professional golf tournaments — who wins the event, top-5/top-10/top-20 finish markets, head-to-head matchups, and other tournament-level wagers from sportsbooks.
REST endpoint →Open in playground →
Required filters: one of tournament_id.
Fields (24)
idBigIntkey

Primary Key

tournament_idBigInt→ PGATournaments
ex: 604
player_idBigInt→ PGAPlayers
ex: 195
sportsbookStringnullable

DraftKings, FanDuel, BetMGM, etc.

ex: fanduelValues:fandueldraftkingsbetfairwilliamhill_usunibetintertopslowvigbetriversbetmgmbarstoolsugarhousebetonlineagfoxbetbovadasuperbookunibet_ustwinspiresgtbets
is_availableBooleannullable
ex: true
is_alternateBooleannullable
outright_oddsIntnullable

Odds to win tournament (American format)

ex: 15000
top_five_oddsIntnullable
top_ten_oddsIntnullable
top_twenty_oddsIntnullable
make_cut_oddsIntnullable
miss_cut_oddsIntnullable
first_round_leader_oddsIntnullable
matchup_opponent_idBigIntnullable
matchup_oddsIntnullable
matchup_opponent_oddsIntnullable
round_matchup_opponent_idBigIntnullable
round_matchup_oddsIntnullable
round_matchup_opponent_oddsIntnullable
three_ball_opponent1_idBigIntnullable
three_ball_opponent2_idBigIntnullable
three_ball_oddsIntnullable
updated_atString
created_atString
Relations (6)
playerPGAPlayers→ PGAPlayers

The golf.players row referenced by player_id; null when unlinked.

tournamentPGATournaments→ PGATournaments

The golf.tournaments row referenced by tournament_id; null when unlinked.

matchup_opponentPGAPlayers→ PGAPlayers

The golf.players row referenced by matchup_opponent_id; null when unlinked.

round_matchup_opponentPGAPlayers→ PGAPlayers

The golf.players row referenced by round_matchup_opponent_id; null when unlinked.

three_ball_opponent1PGAPlayers→ PGAPlayers

The golf.players row referenced by three_ball_opponent1_id; null when unlinked.

three_ball_opponent2PGAPlayers→ PGAPlayers

The golf.players row referenced by three_ball_opponent2_id; null when unlinked.

Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • tournament_idIntFilter to a single tournament.
  • player_idIntFilter to a single player.

Misc

toursPGATours
Professional golf tours — the PGA Tour, LIV Golf, the DP World Tour (formerly European Tour), the Korn Ferry Tour, the LPGA, and other competitive circuits.
REST endpoint →Open in playground →
Fields (9)
idBigIntkey

Primary Key

nameString
ex: PGA TourValues:PGA TourEuropean Tour (DP World Tour)LIV GolfLPGA TourChampions TourKorn Ferry Tour
codeString

Tour code (pga, european, liv, lpga, champions, korn_ferry)

ex: pgaValues:pgaeuropeanlivlpgachampionskorn_ferry
tour_idInt→ PGATours
ex: 1
descriptionStringnullable
ex: Professional Golf Association TourValues:Professional Golf Association TourDP World Tour (formerly European Tour)LIV Golf Invitational SeriesLadies Professional Golf Association TourPGA Tour Champions (senior tour)PGA Tour developmental tour
activeBoolean
ex: true
logo_urlStringnullable
created_atString
updated_atString
Relations (3)
player_season_stats[PGAPlayerSeasonStats!]!→ PGAPlayerSeasonStats

golf.player_season_stats rows whose tour_id references this row.

seasons[PGASeasons!]!→ PGASeasons

golf.seasons rows whose tour_id references this row.

tournaments[PGATournaments!]!→ PGATournaments

golf.tournaments rows whose tour_id references this row.

Arguments (3)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • activeBooleanFilter by active status (defaults to true to show only currently-active rows; pass active=false to include inactive).
coursesPGACourses
Golf courses that host professional events — Augusta National, Pebble Beach, St Andrews, TPC Sawgrass, and every other venue on the PGA, LIV, DP World, and Korn Ferry calendars.
REST endpoint →Open in playground →
Fields (17)
idBigIntkey

Primary Key

nameString
ex: Plantation Course at Kapalua
league_course_idIntnullable→ PGACourses

Official PGA Tour course id

ex: 656
cityStringnullable
ex: La Quinta
stateStringnullable
ex: California
countryStringnullable
ex: USAValues:USACANMEXSCOPURDOMFRAJPNBERBAH
zipStringnullable
longitudeFloatnullable
latitudeFloatnullable
elevationFloatnullable

Elevation in feet above sea level

parInt
ex: 72
yardsInt
ex: 7569
timezoneStringnullable

IANA timezone (e.g., America/New_York)

addressStringnullable
image_urlStringnullable

URL to aerial/overview image of course

ex: https://res.cloudinary.com/pgatour-prod/ar_0.667,c_crop/d_placeholders:tournamentBackgroundSolid.pn…
created_atString
updated_atString
Arguments (2)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
player_newsPGAPlayerNews
News about professional golfers — equipment changes, swing coach updates, sponsorships, tour-status changes, suspensions, and general beat-reporter updates.
REST endpoint →Open in playground →
Required filters: one of player_id | tournament_id.
Fields (19)
idBigIntkey

Primary Key

player_idBigIntnullable→ PGAPlayers
ex: 168
tournament_idBigIntnullable→ PGATournaments
sourceStringnullable
ex: pga_tour
titleString
ex: One-liners: Get to know all 70 players who made 2025 FedExCup Playoffs
contentStringnullable
ex: Pairings, predictions and betting odds for each Sunday Singles matchup
urlStringnullable
ex: https://www.pgatour.com/article/news/latest/2025/08/04/70-one-liners-for-fedexcup-playoffs-st-jude-…
terms_of_useStringnullable
authorStringnullable
categoriesStringnullable
ex: Latest
original_sourceStringnullable
original_source_urlStringnullable
news_timeString
ex: 2025-08-04T15:19:00.000Z
updated_timeStringnullable
ex: 2025-08-04T15:28:47.169Z
priorityInt
ex: 10
created_atString
updated_atString
ai_processedBoolean
ex: false
situational_impactJSONnullable
Relations (2)
playerPGAPlayers→ PGAPlayers

The golf.players row referenced by player_id; null when unlinked.

tournamentPGATournaments→ PGATournaments

The golf.tournaments row referenced by tournament_id; null when unlinked.

Arguments (8)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • player_idIntFilter to a single player.
  • tournament_idIntFilter to a tournament.
  • news_timeStringFilter by publication time (ISO 8601). Use news_time__gte to poll for items since your last check.
  • news_time__gteStringgte comparison on news_time.
  • news_time__lteStringlte comparison on news_time.
  • news_time__betweenStringRange filter on news_time — pass "lo,hi".