Skip to main content
Breaking in 4.0.0
  • Integer id columns are decimal strings — Every id column of integers (id, *_id, game_pk, playerId, …) comes back as exact decimal strings on every surface — parsers, producers, loaders, HockeyTech analytics. Compare and join ids as strings; Number(row.game_id) for a safe number back. (changelog)
  • 400 / 422 raise InvalidParameterError — For every family (it was AssetFetchError), never retried; the message names host, path and status with a redacted excerpt of the body. (changelog)
  • Typed returns — generated row types for parsed: true — TypeScript only. A wrapper's raw payload resolves to unknown (was any); verified endpoints resolve to their row interfaces; the summary dispatchers to ParsedTables. Narrow or cast a raw payload. (changelog)
  • Typed wrapper params and loader rows; strict mode — TypeScript only. A param the endpoint does not have, a missing required path param or a non-boolean bool param is a type error; parser rows are Record<string, unknown>; loader rows are their generated row types. (changelog)
  • Wrapper failures raise NoDataError / AssetFetchError — Instead of raw axios errors. NoDataError = the fetch worked and there is nothing there (404, ESPN { code: 404 }); AssetFetchError = the fetch failed (403 / 429 / 5xx after retries, network). Retries follow DEFAULT_RETRY_STATUSES with backoff. (changelog)

on3 — native provider reference

  • namespace: sdv.on3 (standalone — not an ESPN league)
  • families: On3 Recruit Database
  • wrappers: 78 native

on3 is a cross-sport provider namespace (no ESPN {sport}/{league} nesting). Every method is exposed under BOTH its snake_case name (<family>_<endpoint>, py/R parity) and a camelCase canonical name (<family><Endpoint>) on sdv.on3. Pass { parsed: true } to any endpoint to get tidy rows instead of raw JSON.

import sdv from 'sportsdataverse';

// The On3 Recruit Database is keyless:
await sdv.on3.on3_player_profile({ person_key: 89617, parsed: true });

Native API — On3 Recruit Database​

Flat (non-ESPN) wrappers for the On3 public Recruit Database (RDB). Host: https://api.on3.com/public/rdb/v1. Each method is exposed under BOTH its snake_case name on3_<endpoint> (sdv-py's name, py/R parity) and its camelCase form (canonical) on sdv.on3. Pass { parsed: true } to run the payload through its tidy.js parser; omit it for the raw response.

MethodHTTPPath paramsQuery paramsParserAuth
on3_coaches_history / on3CoachesHistoryhttps://api.on3.com/public/rdb/v1/coaches/{person_key}/historyperson_key*page, page_size → pageSizeparse_on3_rdb—
on3_coaches_profile / on3CoachesProfilehttps://api.on3.com/public/rdb/v1/coaches/{person_key}/profileperson_key*—parse_on3_rdb—
on3_collective_groups / on3CollectiveGroupshttps://api.on3.com/public/rdb/v1/collective-groups—sport_key → sportKey, organization_key → organizationKey, query, page, page_size → pageSizeparse_on3_rdb—
on3_collective_groups_deals / on3CollectiveGroupsDealshttps://api.on3.com/public/rdb/v1/collective-groups/{key}/dealskey*page, page_size → pageSizeparse_on3_rdb—
on3_collective_groups_key / on3CollectiveGroupsKeyhttps://api.on3.com/public/rdb/v1/collective-groups/{key}key*—parse_on3_rdb—
on3_commits_latest / on3CommitsLatesthttps://api.on3.com/public/rdb/v1/commits/latest—sport_key → sportKey, page, page_size → pageSizeparse_on3_rdb—
on3_commits_organizations_latest_commits / on3CommitsOrganizationsLatestCommitshttps://api.on3.com/public/rdb/v1/commits/organizations/{org_key}/latest-commitsorg_key*—parse_on3_rdb—
on3_commits_organizations_org_key / on3CommitsOrganizationsOrgKeyhttps://api.on3.com/public/rdb/v1/commits/organizations/{org_key}org_key*—parse_on3_rdb—
on3_draft_organization_rank / on3DraftOrganizationRankhttps://api.on3.com/public/rdb/v1/draft-organization-rank—sport_key → sportKey, year, page, page_size → pageSizeparse_on3_rdb—
on3_draft_pick_organization_rank / on3DraftPickOrganizationRankhttps://api.on3.com/public/rdb/v1/draft-pick-organization-rank—sport_key → sportKey, year, page, page_size → pageSizeparse_on3_rdb—
on3_drafts / on3Draftshttps://api.on3.com/public/rdb/v1/drafts—sport_key → sportKey, round, yearparse_on3_rdb—
on3_drafts_by_stars / on3DraftsByStarshttps://api.on3.com/public/rdb/v1/drafts-by-stars—sport_key → sportKey, year, year_span → yearSpanparse_on3_rdb—
on3_drafts_by_stars_summary / on3DraftsByStarsSummaryhttps://api.on3.com/public/rdb/v1/drafts-by-stars-summary—sport_key → sportKey, yearparse_on3_rdb—
on3_drafts_players / on3DraftsPlayershttps://api.on3.com/public/rdb/v1/drafts/{org_key}/playersorg_key*yearparse_on3_rdb—
on3_filters_conferences / on3FiltersConferenceshttps://api.on3.com/public/rdb/v1/filters/conferences—year, sport_key → sportKeyparse_on3_rdb—
on3_filters_draft_rounds / on3FiltersDraftRoundshttps://api.on3.com/public/rdb/v1/filters/draft-rounds—year, sport_key → sportKeyparse_on3_rdb—
on3_filters_positions / on3FiltersPositionshttps://api.on3.com/public/rdb/v1/filters/positions—sport_key → sportKey, position_type → positionTypeparse_on3_rdb—
on3_filters_sports / on3FiltersSportshttps://api.on3.com/public/rdb/v1/filters/sports——parse_on3_rdb—
on3_filters_status / on3FiltersStatushttps://api.on3.com/public/rdb/v1/filters/status——parse_on3_rdb—
on3_filters_teams / on3FiltersTeamshttps://api.on3.com/public/rdb/v1/filters/teams—group_by → groupBy, year, sport_key → sportKeyparse_on3_rdb—
on3_filters_years / on3FiltersYearshttps://api.on3.com/public/rdb/v1/filters/years——parse_on3_rdb—
on3_nil_100 / on3Nil100https://api.on3.com/public/rdb/v1/nil-100—yearparse_on3_rdb—
on3_nil_100_v2 / on3Nil100V2https://api.on3.com/public/rdb/v2/nil-100—year, org_key → orgKey, limit, pageparse_on3_rdb—
on3_nil_compliances_state / on3NilCompliancesStatehttps://api.on3.com/public/rdb/v1/nil-compliances/state—state_key → stateKeyparse_on3_rdb—
on3_nil_rankings / on3NilRankingshttps://api.on3.com/public/rdb/v1/nil-rankings—sport_key → sportKey, gender, year, org_type → orgType, position_abbr → positionAbbr, state_abbr → stateAbbrparse_on3_rdb—
on3_organizations_draft_class_by_state / on3OrganizationsDraftClassByStatehttps://api.on3.com/public/rdb/v1/organizations/{organization_key}/draft-class-by-stateorganization_key*page, page_size → pageSizeparse_on3_rdb—
on3_organizations_draft_class_by_year / on3OrganizationsDraftClassByYearhttps://api.on3.com/public/rdb/v1/organizations/{organization_key}/draft-class-by-yearorganization_key*page, page_size → pageSizeparse_on3_rdb—
on3_organizations_draft_count_by_stars / on3OrganizationsDraftCountByStarshttps://api.on3.com/public/rdb/v1/organizations/{organization_key}/draft-count-by-starsorganization_key*—parse_on3_rdb—
on3_organizations_draft_count_by_year / on3OrganizationsDraftCountByYearhttps://api.on3.com/public/rdb/v1/organizations/{organization_key}/draft-count-by-yearorganization_key*page, page_size → pageSizeparse_on3_rdb—
on3_organizations_draft_ranking_summary / on3OrganizationsDraftRankingSummaryhttps://api.on3.com/public/rdb/v1/organizations/{organization_key}/draft-ranking-summaryorganization_key*yearparse_on3_rdb—
on3_organizations_drafted_players / on3OrganizationsDraftedPlayershttps://api.on3.com/public/rdb/v1/organizations/{organization_key}/drafted-playersorganization_key*page, page_size → pageSizeparse_on3_rdb—
on3_organizations_drafts_by_stars_summary / on3OrganizationsDraftsByStarsSummaryhttps://api.on3.com/public/rdb/v1/organizations/{organization_key}/drafts-by-stars-summaryorganization_key*yearparse_on3_rdb—
on3_organizations_roster / on3OrganizationsRosterhttps://api.on3.com/public/rdb/v1/organizations/{organization_key}/rosterorganization_key*sport_key → sportKey, year, page, page_size → pageSizeparse_on3_rdb—
on3_organizations_roster_header / on3OrganizationsRosterHeaderhttps://api.on3.com/public/rdb/v1/organizations/{organization_key}/roster-headerorganization_key*sport_key → sportKey, yearparse_on3_rdb—
on3_people_combine_measurements / on3PeopleCombineMeasurementshttps://api.on3.com/public/rdb/v1/people/{person_key}/combine-measurementsperson_key*—parse_on3_rdb—
on3_people_latest_valuation / on3PeopleLatestValuationhttps://api.on3.com/public/rdb/v1/people/{person_key}/latest-valuationperson_key*—parse_on3_rdb—
on3_people_measurements / on3PeopleMeasurementshttps://api.on3.com/public/rdb/v1/people/{person_key}/measurementsperson_key*—parse_on3_rdb—
on3_people_measurements_averages / on3PeopleMeasurementsAverageshttps://api.on3.com/public/rdb/v1/people/{person_key}/measurements/averagesperson_key*page, page_size → pageSizeparse_on3_rdb—
on3_people_person_connections / on3PeoplePersonConnectionshttps://api.on3.com/public/rdb/v1/people/{person_key}/person-connectionsperson_key*page, page_size → pageSizeparse_on3_rdb—
on3_people_social / on3PeopleSocialhttps://api.on3.com/public/rdb/v1/people/{person_key}/socialperson_key*—parse_on3_rdb—
on3_people_social_post_summary / on3PeopleSocialPostSummaryhttps://api.on3.com/public/rdb/v1/people/{person_key}/social-post-summaryperson_key*—parse_on3_rdb—
on3_people_track_and_field_measurements / on3PeopleTrackAndFieldMeasurementshttps://api.on3.com/public/rdb/v1/people/{person_key}/track-and-field-measurementsperson_key*—parse_on3_rdb—
on3_people_valuation_growth / on3PeopleValuationGrowthhttps://api.on3.com/public/rdb/v1/people/{person_key}/valuation-growthperson_key*—parse_on3_rdb—
on3_person_connections_connection_key / on3PersonConnectionsConnectionKeyhttps://api.on3.com/public/rdb/v1/person-connections/{connection_key}connection_key*—parse_on3_rdb—
on3_person_primary_recruitment_evaluation / on3PersonPrimaryRecruitmentEvaluationhttps://api.on3.com/public/rdb/v1/person/{person_key}/primary-recruitment-evaluationperson_key*—parse_on3_rdb—
on3_person_recruitment_evaluations / on3PersonRecruitmentEvaluationshttps://api.on3.com/public/rdb/v1/person/{person_key}/recruitment-evaluationsperson_key*—parse_on3_rdb—
on3_person_sport_profile_recruit / on3PersonSportProfileRecruithttps://api.on3.com/public/rdb/v1/person-sport/{ps_key}/profile-recruitps_key*—parse_on3_rdb—
on3_person_sport_rankings / on3PersonSportRankingshttps://api.on3.com/public/rdb/v1/person-sport-rankings—sport_key → sportKey, year, page, page_size → pageSizeparse_on3_rdb—
on3_player_all_rankings / on3PlayerAllRankingshttps://api.on3.com/public/rdb/v1/player/{person_key}/all-rankingsperson_key*—parse_on3_rdb—
on3_player_database_updates / on3PlayerDatabaseUpdateshttps://api.on3.com/public/rdb/v1/player/{person_key}/database-updatesperson_key*—parse_on3_rdb—
on3_player_images / on3PlayerImageshttps://api.on3.com/public/rdb/v1/player/{person_key}/imagesperson_key*—parse_on3_rdb—
on3_player_organizations / on3PlayerOrganizationshttps://api.on3.com/public/rdb/v1/player/{person_key}/organizationsperson_key*—parse_on3_rdb—
on3_player_organizations_org_key / on3PlayerOrganizationsOrgKeyhttps://api.on3.com/public/rdb/v1/player/{player_key}/organizations/{org_key}player_key*, org_key*—parse_on3_rdb—
on3_player_person_rankings / on3PlayerPersonRankingshttps://api.on3.com/public/rdb/v1/player/{person_key}/rankingsperson_key*—parse_on3_rdb—
on3_player_profile / on3PlayerProfilehttps://api.on3.com/public/rdb/v1/player/{person_key}/profileperson_key*—parse_on3_rdb—
on3_player_team_targets / on3PlayerTeamTargetshttps://api.on3.com/public/rdb/v1/player/{player_key}/team-targetsplayer_key*—parse_on3_rdb—
on3_player_verified / on3PlayerVerifiedhttps://api.on3.com/public/rdb/v1/player/verified—sport_key → sportKey, page, page_size → pageSizeparse_on3_rdb—
on3_player_videos / on3PlayerVideoshttps://api.on3.com/public/rdb/v1/player/{person_key}/videosperson_key*—parse_on3_rdb—
on3_player_visit_center / on3PlayerVisitCenterhttps://api.on3.com/public/rdb/v1/player/{player_key}/visit-centerplayer_key*—parse_on3_rdb—
on3_players_industry_comparision / on3PlayersIndustryComparisionhttps://api.on3.com/public/rdb/v1/players/industry-comparision—sport_key → sportKey, year, state_abbr → stateAbbr, position_abbr → positionAbbr, page, sort_by_industry → sortByIndustryparse_on3_rdb—
on3_players_industry_comparision_list / on3PlayersIndustryComparisionListhttps://api.on3.com/public/rdb/v1/players/industry-comparision-list—sport_key → sportKey, year, page, page_size → pageSizeparse_on3_rdb—
on3_predictions_user_key / on3PredictionsUserKeyhttps://api.on3.com/public/rdb/v1/predictions/{user_key}user_key*page, page_size → pageSizeparse_on3_rdb—
on3_quotes / on3Quoteshttps://api.on3.com/public/rdb/v1/quotes—page, page_size → pageSizeparse_on3_rdb—
on3_quotes_key / on3QuotesKeyhttps://api.on3.com/public/rdb/v1/quotes/{key}key*—parse_on3_rdb—
on3_recruitment_primary_recruitment_evaluation / on3RecruitmentPrimaryRecruitmentEvaluationhttps://api.on3.com/public/rdb/v1/recruitment/{recruitment_key}/primary-recruitment-evaluationrecruitment_key*—parse_on3_rdb—
on3_recruitment_recruitment_evaluations / on3RecruitmentRecruitmentEvaluationshttps://api.on3.com/public/rdb/v1/recruitment/{recruitment_key}/recruitment-evaluationsrecruitment_key*—parse_on3_rdb—
on3_recruitments_latest_rpm_picks / on3RecruitmentsLatestRpmPickshttps://api.on3.com/public/rdb/v1/recruitments/latest-rpm-picks—org_key → orgKey, year, page, page_size → pageSizeparse_on3_rdb—
on3_recruitments_profile / on3RecruitmentsProfilehttps://api.on3.com/public/rdb/v1/recruitments/{rec_key}/profilerec_key*—parse_on3_rdb—
on3_recruitments_rpm_picks / on3RecruitmentsRpmPickshttps://api.on3.com/public/rdb/v1/recruitments/{rec_key}/rpm-picksrec_key*—parse_on3_rdb—
on3_recruitments_rpm_summary / on3RecruitmentsRpmSummaryhttps://api.on3.com/public/rdb/v1/recruitments/{rec_key}/rpm-summaryrec_key*—parse_on3_rdb—
on3_team_ranking / on3TeamRankinghttps://api.on3.com/public/rdb/v1/team-ranking—sport_key → sportKey, year, page, page_size → pageSizeparse_on3_rdb—
on3_team_ranking_bluechips_team_rankings / on3TeamRankingBluechipsTeamRankingshttps://api.on3.com/public/rdb/v1/team-ranking/{sport_slug}-{year}/bluechips-team-rankingssport_slug*, year*—parse_on3_rdb—
on3_team_ranking_consensus_team_rankings / on3TeamRankingConsensusTeamRankingshttps://api.on3.com/public/rdb/v1/team-ranking/{sport_slug}-{year}/consensus-team-rankingssport_slug*, year*—parse_on3_rdb—
on3_team_ranking_organizations_summary / on3TeamRankingOrganizationsSummaryhttps://api.on3.com/public/rdb/v1/team-ranking/organizations/{org_key}/summaryorg_key*—parse_on3_rdb—
on3_team_ranking_team_rankings / on3TeamRankingTeamRankingshttps://api.on3.com/public/rdb/v1/team-ranking/{sport_slug}-{year}/team-rankingssport_slug*, year*—parse_on3_rdb—
on3_transfers_best_available / on3TransfersBestAvailablehttps://api.on3.com/public/rdb/v1/transfers/best-available—org_key → orgKey, sport_key → sportKey, year, position_abbr → positionAbbr, status, page, cutoff, order_by → orderByparse_on3_rdb—
on3_transfers_latest / on3TransfersLatesthttps://api.on3.com/public/rdb/v1/transfers/latest—org_key → orgKey, sport_key → sportKey, year, position_abbr → positionAbbr, status, pageparse_on3_rdb—
on3_videos_video_key / on3VideosVideoKeyhttps://api.on3.com/public/rdb/v1/videos/{video_key}video_key*—parse_on3_rdb—

Returns — on3_coaches_history / on3CoachesHistory​

No returns table is published for this endpoint: no committed capture with rows, and the response type is only heuristically mapped (x-source: call-site); names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_coaches_profile / on3CoachesProfile​

No returns table is published for this endpoint: no committed capture with rows, and the response type is only heuristically mapped (x-source: call-site); names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_collective_groups / on3CollectiveGroups​

col_nametypedescription
keyintegerOn3 RDB key for the NIL collective group.
namecharacterDisplay name of the row's record.
default_asset_keyintegerOn3 asset key for the collective's primary logo image.
social_asset_keyintegerOn3 asset key for the collective's social-media image.
organization_keyintegerOn3 organization key of the school the collective supports.
launch_datecharacterDate the NIL collective launched.
organization_typecharacterLegal form of the collective (e.g. LLC, 501(c)(3)).
twitter_handlecharacterCollective's Twitter/X account handle.
instagram_handlecharacterCollective's Instagram account handle.
tik_tok_handlecharacterCollective's TikTok account handle.
youtube_handlecharacterCollective's YouTube channel handle.
linked_in_handlecharacterCollective's LinkedIn account handle.
website_namecharacterDisplay name of the collective's website.
website_urlcharacterURL of the collective's website.
mission_statementcharacterCollective's stated mission, as published to On3.
descriptioncharacterFree-text description or biography shipped by On3.
annual_goal_amountnumericCollective's annual fundraising goal in dollars, as reported to On3.
confirmed_raised_amountnumericDollar amount the collective has confirmed raising, per On3.
merged_into_group_keyintegerOn3 key of the collective this group merged into, when applicable.
merged_into_groupcharacterNested On3 record for the collective this group merged into (stringified).
slugcharacterURL slug of the row's record on On3.
founderscharacterFounders of the collective, as a stringified list.
sportscharacterSports the collective funds, as a stringified list.
default_asset_key_2integerAsset key repeated from the nested default-asset object (json_normalize de-duplication suffix).
default_asset_domain_overridecharacterCDN domain override for the record's default asset (usually null).
default_asset_domaincharacterCDN domain serving the default asset.
default_asset_source_overridecharacterSource-path override for the default asset (usually null).
default_asset_sourcecharacterCDN-relative source path of the default asset.
default_asset_titlecharacterEditorial title attached to the default asset.
default_asset_descriptioncharacterEditorial description attached to the default asset (usually null).
default_asset_captioncharacterEditorial caption attached to the default asset (usually null).
default_asset_categorycharacterEditorial category label of the default asset (usually null).
default_asset_alt_textcharacterAccessibility alt text of the default asset (usually null).
default_asset_heightintegerPixel height of the default asset.
default_asset_widthintegerPixel width of the default asset.
default_asset_asset_typecharacterOn3 asset-type discriminator of the default asset (e.g. Image).
default_asset_file_systemcharacterStorage file-system flag of the default asset.
default_asset_pathcharacterStorage path of the default asset.
default_asset_typecharacterMedia type field of the default asset (file extension, e.g. png).
default_asset_thumbnailcharacterThumbnail variant of the default asset (video assets; usually null).
default_asset_durationintegerDuration of the default asset when it is a video (usually null or 0).
default_asset_mime_typecharacterMIME type of the default asset.
social_asset_key_2integerAsset key repeated from the nested social-asset object (json_normalize de-duplication suffix).
social_asset_domain_overridecharacterCDN domain override for the social-media asset (usually null).
social_asset_domaincharacterCDN domain serving the social-media asset.
social_asset_source_overridecharacterSource-path override for the social-media asset (usually null).
social_asset_sourcecharacterCDN-relative source path of the social-media asset.
social_asset_titlecharacterEditorial title attached to the social-media asset.
social_asset_descriptioncharacterEditorial description attached to the social-media asset (usually null).
social_asset_captioncharacterEditorial caption attached to the social-media asset (usually null).
social_asset_categorycharacterEditorial category label of the social-media asset (usually null).
social_asset_alt_textcharacterAccessibility alt text of the social-media asset (usually null).
social_asset_heightintegerPixel height of the social-media asset.
social_asset_widthintegerPixel width of the social-media asset.
social_asset_asset_typecharacterOn3 asset-type discriminator of the social-media asset (e.g. Image).
social_asset_file_systemcharacterStorage file-system flag of the social-media asset.
social_asset_pathcharacterStorage path of the social-media asset.
social_asset_typecharacterMedia type field of the social-media asset (file extension, e.g. png).
social_asset_thumbnailcharacterThumbnail variant of the social-media asset (video assets; usually null).
social_asset_durationintegerDuration of the social-media asset when it is a video (usually null or 0).
social_asset_mime_typecharacterMIME type of the social-media asset.
organization_key_2integerOrganization key repeated from the nested organization object (json_normalize de-duplication suffix).
organization_full_namecharacterFull name of the program (e.g. 'Alabama Crimson Tide').
organization_namecharacterShort name of the program.
organization_known_ascharacterCommon short name of the program, when On3 lists one.
organization_mascotcharacterMascot of the program.
organization_abbreviationcharacterAbbreviation of the program.
organization_asset_urlcharacterConvenience CDN URL of the program's logo.
organization_default_asset_keyintegerOn3 asset key of the program's logo asset.
organization_default_asset_domain_overridecharacterCDN domain override for the program's logo asset (usually null).
organization_default_asset_domaincharacterCDN domain serving the program's logo asset.
organization_default_asset_source_overridecharacterSource-path override for the program's logo asset (usually null).
organization_default_asset_sourcecharacterCDN-relative source path of the program's logo asset.
organization_default_asset_titlecharacterEditorial title attached to the program's logo asset.
organization_default_asset_descriptioncharacterEditorial description attached to the program's logo asset (usually null).
organization_default_asset_captioncharacterEditorial caption attached to the program's logo asset (usually null).
organization_default_asset_categorycharacterEditorial category label of the program's logo asset (usually null).
organization_default_asset_alt_textcharacterAccessibility alt text of the program's logo asset (usually null).
organization_default_asset_heightintegerPixel height of the program's logo asset.
organization_default_asset_widthintegerPixel width of the program's logo asset.
organization_default_asset_asset_typecharacterOn3 asset-type discriminator of the program's logo asset (e.g. Image).
organization_default_asset_file_systemcharacterStorage file-system flag of the program's logo asset.
organization_default_asset_pathcharacterStorage path of the program's logo asset.
organization_default_asset_typecharacterMedia type field of the program's logo asset (file extension, e.g. png).
organization_default_asset_thumbnailcharacterThumbnail variant of the program's logo asset (video assets; usually null).
organization_default_asset_durationintegerDuration of the program's logo asset when it is a video (usually null or 0).
organization_default_asset_mime_typecharacterMIME type of the program's logo asset.
organization_slugcharacterURL slug of the program on On3.
organization_primary_colorcharacterPrimary hex color of the program.
organization_org_typecharacterOrganization type label of the program (e.g. HighSchool, College).
organization_org_type_enumcharacterOrganization type enum of the program (same vocabulary as org_type).
organization_divisioncharacterDivision or classification of the program (e.g. NCAA-FB).
organization_site_keyscharacterJSON-encoded On3 site keys covering the program (usually null).
organization_url_slugcharacterURL slug variant of the program's page, with the key appended.

Row type: On3CollectiveGroupsRow (exported from the package root).

Returns — on3_collective_groups_deals / on3CollectiveGroupsDeals​

No returns table is published for this endpoint: no committed capture with rows, and the response type is only heuristically mapped (x-source: call-site); names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_collective_groups_key / on3CollectiveGroupsKey​

No returns table is published for this endpoint: no committed capture with rows, and the response type is only heuristically mapped (x-source: call-site); names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_commits_organizations_latest_commits / on3CommitsOrganizationsLatestCommits​

No returns table is published for this endpoint: no committed capture with rows, and the row has nested objects whose flattened column names depend on which are null in the data; names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_commits_organizations_org_key / on3CommitsOrganizationsOrgKey​

No returns table is published for this endpoint: no committed capture with rows; names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_draft_organization_rank / on3DraftOrganizationRank​

No returns table is published for this endpoint: no committed capture with rows, and the response type is only heuristically mapped (x-source: call-site); names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_draft_pick_organization_rank / on3DraftPickOrganizationRank​

No returns table is published for this endpoint: no committed capture with rows, and the response type is only heuristically mapped (x-source: call-site); names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_drafts / on3Drafts​

No returns table is published for this endpoint: its committed capture has 0 rows, so the parser emits no columns; names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_drafts_by_stars / on3DraftsByStars​

col_nametypedescription
blue_chip_percentnumericPercent of the drafted group who were blue-chip (four- or five-star) recruits.
population_percentnumericPercent of the overall recruit population holding this star rating.
talent_rationumericRatio of the star tier's draft share to its population share (On3's talent ratio).
five_starsintegerNumber of drafted players who were five-star recruits.
four_starsintegerNumber of drafted players who were four-star recruits.
three_starsintegerNumber of drafted players who were three-star recruits.
zero_starsintegerNumber of drafted players who were unrated (zero-star) recruits.
totalintegerTotal drafted players counted in the row.
state_keyintegerOn3 numeric key of the state.
state_namecharacterName of the state the row aggregates (e.g. Alabama).
state_abbreviationcharacterTwo-letter state abbreviation.
state_country_keyintegerOn3 numeric key of the state's country.

Row type: On3DraftsByStarsRow (exported from the package root).

Returns — on3_drafts_by_stars_summary / on3DraftsByStarsSummary​

No returns table is published for this endpoint: no committed capture with rows, and the response type is only heuristically mapped (x-source: call-site); names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_drafts_players / on3DraftsPlayers​

No returns table is published for this endpoint: no committed capture with rows, and the response type is only heuristically mapped (x-source: call-site); names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_filters_conferences / on3FiltersConferences​

No returns table is published for this endpoint: no committed capture with rows; names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_filters_draft_rounds / on3FiltersDraftRounds​

col_nametypedescription
roundintegerDraft round number.

Row type: On3FiltersDraftRoundsRow (exported from the package root).

Returns — on3_filters_positions / on3FiltersPositions​

No returns table is published for this endpoint: no committed capture with rows; names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_filters_sports / on3FiltersSports​

No returns table is published for this endpoint: no committed capture with rows; names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_filters_status / on3FiltersStatus​

col_nametypedescription
valuecharacterFilter value as On3 lists it.

Row type: On3FiltersStatusRow (exported from the package root).

Returns — on3_filters_teams / on3FiltersTeams​

No returns table is published for this endpoint: no committed capture with rows; names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_filters_years / on3FiltersYears​

No returns table is published for this endpoint: no committed capture with rows, and each row is a bare scalar with no named fields; names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_nil_100 / on3Nil100​

No returns table is published for this endpoint: no committed capture with rows, and the row has nested objects whose flattened column names depend on which are null in the data; names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_nil_100_v2 / on3Nil100V2​

col_nametypedescription
person_rating_consensus_ratingnumericIndustry-consensus numeric rating paired with the person's On3 rating (0-100 scale).
person_rating_consensus_starsintegerIndustry-consensus star rating paired with the person's On3 rating (2-5).
person_rating_consensus_national_rankintegerIndustry-consensus national rank paired with the person's On3 rating.
person_rating_consensus_position_rankintegerIndustry-consensus position rank paired with the person's On3 rating.
person_rating_consensus_state_rankintegerIndustry-consensus state rank paired with the person's On3 rating.
person_rating_keyintegerOn3 key of the person's On3 rating record.
person_rating_ratingnumericNumeric value of the person's On3 rating (0-100 scale).
person_rating_starsintegerStar rating of the person's On3 rating (2-5).
person_rating_national_rankintegerNational rank of the person's On3 rating.
person_rating_position_rankintegerPosition rank of the person's On3 rating.
person_rating_state_rankintegerState rank of the person's On3 rating.
person_rating_position_abbrcharacterPosition abbreviation the person's On3 rating was assigned at.
person_rating_state_abbrcharacterState abbreviation the person's On3 rating was assigned in.
person_rating_five_star_pluslogicalFive-star-plus flag on the person's On3 rating.
person_divisioncharacterDivision of the person's current organization (e.g. NCAA-FB, NCAA-BK).
person_default_sport_keyintegerOn3 numeric key of the person's primary sport.
person_default_sport_namecharacterName of the person's primary sport (e.g. Football).
person_organization_levelcharacterLevel of the person's current organization (e.g. HighSchool, College, Professional).
person_agenumericAge of the person in years, when known.
person_tagscharacterJSON-encoded list of On3 profile tags on the person (e.g. Influencer).
person_keyintegerOn3 numeric key of the person.
person_recruitment_keyintegerOn3 key of the person's active recruitment record.
person_namecharacterDisplay name of the person.
person_slugcharacterURL slug of the person's On3 profile.
person_high_school_namecharacterHigh-school display name on the person's record.
person_high_school_keyintegerOn3 numeric key of the person's high school.
person_high_school_full_namecharacterFull name of the person's high school (e.g. 'Alabama Crimson Tide').
person_high_school_name_2characterHigh-school display name on the person's record (json_normalize de-duplication suffix).
person_high_school_known_ascharacterCommon short name of the person's high school, when On3 lists one.
person_high_school_mascotcharacterMascot of the person's high school.
person_high_school_abbreviationcharacterAbbreviation of the person's high school.
person_high_school_asset_urlcharacterConvenience CDN URL of the person's high school's logo.
person_high_school_default_asset_keynumericOn3 asset key of the person's high school's logo asset.
person_high_school_default_asset_domain_overridecharacterCDN domain override for the person's high school's logo asset (usually null).
person_high_school_default_asset_domaincharacterCDN domain serving the person's high school's logo asset.
person_high_school_default_asset_source_overridecharacterSource-path override for the person's high school's logo asset (usually null).
person_high_school_default_asset_sourcecharacterCDN-relative source path of the person's high school's logo asset.
person_high_school_default_asset_titlecharacterEditorial title attached to the person's high school's logo asset.
person_high_school_default_asset_descriptioncharacterEditorial description attached to the person's high school's logo asset (usually null).
person_high_school_default_asset_captioncharacterEditorial caption attached to the person's high school's logo asset (usually null).
person_high_school_default_asset_categorycharacterEditorial category label of the person's high school's logo asset (usually null).
person_high_school_default_asset_alt_textcharacterAccessibility alt text of the person's high school's logo asset (usually null).
person_high_school_default_asset_heightnumericPixel height of the person's high school's logo asset.
person_high_school_default_asset_widthnumericPixel width of the person's high school's logo asset.
person_high_school_default_asset_asset_typecharacterOn3 asset-type discriminator of the person's high school's logo asset (e.g. Image).
person_high_school_default_asset_file_systemcharacterStorage file-system flag of the person's high school's logo asset.
person_high_school_default_asset_pathcharacterStorage path of the person's high school's logo asset.
person_high_school_default_asset_typecharacterMedia type field of the person's high school's logo asset (file extension, e.g. png).
person_high_school_default_asset_thumbnailcharacterThumbnail variant of the person's high school's logo asset (video assets; usually null).
person_high_school_default_asset_durationnumericDuration of the person's high school's logo asset when it is a video (usually null or 0).
person_high_school_default_asset_mime_typecharacterMIME type of the person's high school's logo asset.
person_high_school_slugcharacterURL slug of the person's high school on On3.
person_high_school_primary_colorcharacterPrimary hex color of the person's high school.
person_high_school_org_typecharacterOrganization type label of the person's high school (e.g. HighSchool, College).
person_high_school_org_type_enumcharacterOrganization type enum of the person's high school (same vocabulary as org_type).
person_high_school_divisioncharacterDivision or classification of the person's high school (e.g. NCAA-FB).
person_high_school_site_keyscharacterJSON-encoded On3 site keys covering the person's high school (usually null).
person_high_school_url_slugcharacterURL slug variant of the person's high school's page, with the key appended.
person_home_town_namecharacterHome town of the person as On3 lists it (e.g. 'Belleville, MI').
person_early_enrolleelogicalWhether the person early-enrolled at college.
person_early_signeelogicalWhether the person signed during the early signing period.
person_default_asset_urlcharacterConvenience CDN URL of the person's headshot.
person_class_yearintegerHigh-school graduating class year of the person.
person_athlete_verifiedlogicalWhether the person's athlete profile is verified by On3.
person_prospect_verifiedlogicalWhether the person's prospect measurables are verified by On3.
person_default_asset_keyintegerOn3 asset key of the person's headshot asset.
person_default_asset_domain_overridecharacterCDN domain override for the person's headshot asset (usually null).
person_default_asset_domaincharacterCDN domain serving the person's headshot asset.
person_default_asset_source_overridecharacterSource-path override for the person's headshot asset (usually null).
person_default_asset_sourcecharacterCDN-relative source path of the person's headshot asset.
person_default_asset_titlecharacterEditorial title attached to the person's headshot asset.
person_default_asset_descriptioncharacterEditorial description attached to the person's headshot asset (usually null).
person_default_asset_captioncharacterEditorial caption attached to the person's headshot asset (usually null).
person_default_asset_categorycharacterEditorial category label of the person's headshot asset (usually null).
person_default_asset_alt_textcharacterAccessibility alt text of the person's headshot asset (usually null).
person_default_asset_heightintegerPixel height of the person's headshot asset.
person_default_asset_widthintegerPixel width of the person's headshot asset.
person_default_asset_asset_typecharacterOn3 asset-type discriminator of the person's headshot asset (e.g. Image).
person_default_asset_file_systemcharacterStorage file-system flag of the person's headshot asset.
person_default_asset_pathcharacterStorage path of the person's headshot asset.
person_default_asset_typecharacterMedia type field of the person's headshot asset (file extension, e.g. png).
person_default_asset_thumbnailcharacterThumbnail variant of the person's headshot asset (video assets; usually null).
person_default_asset_durationintegerDuration of the person's headshot asset when it is a video (usually null or 0).
person_default_asset_mime_typecharacterMIME type of the person's headshot asset.
person_position_abbreviationcharacterPosition abbreviation on the person's record.
person_heightcharacterHeight of the person: a formatted string (e.g. '6-8') or inches, depending on the endpoint.
person_weightintegerWeight of the person in pounds.
person_roster_ratingcharacterOn3 roster (transfer-portal-adjusted) rating of the person, when published.
person_commit_status_typecharacterType of the person's commitment status (e.g. Committed, Signed, Enrolled, None).
person_commit_status_short_term_signeelogicalShort-term-signee flag of the person's commitment status (null when not applicable).
person_commit_status_datecharacterDate the person's commitment status took effect (ISO timestamp string).
person_commit_status_committed_assetcharacterNested asset of the committed-to program (the person's commitment status; usually null).
person_commit_status_committed_asset_rescharacterNested logo asset of the committed-to program (the person's commitment status; usually null).
person_commit_status_transferred_asset_keyintegerOn3 numeric key of the person's commitment status's program transferred to.
person_commit_status_transferred_asset_urlcharacterCDN URL of the person's commitment status's program transferred to's logo.
person_commit_status_transferred_asset_slugcharacterURL slug of the person's commitment status's program transferred to on On3.
person_commit_status_transferred_asset_full_namecharacterFull name of the person's commitment status's program transferred to (e.g. 'Alabama Crimson Tide').
person_commit_status_transferred_asset_rescharacterNested logo asset of the program transferred to (the person's commitment status; usually null).
person_commit_status_committed_organization_keyintegerOn3 key of the committed-to program (the person's commitment status).
person_commit_status_committed_organization_full_namecharacterFull name of the person's commitment status's committed-to program (e.g. 'Alabama Crimson Tide').
person_commit_status_committed_organization_namecharacterShort name of the person's commitment status's committed-to program.
person_commit_status_committed_organization_mascotcharacterMascot of the person's commitment status's committed-to program.
person_commit_status_committed_organization_abbreviationcharacterAbbreviation of the person's commitment status's committed-to program.
person_commit_status_committed_organization_asset_urlcharacterCDN URL of the committed-to program's logo (the person's commitment status).
person_commit_status_committed_organization_asset_keyintegerOn3 asset key of the person's commitment status's committed-to program's logo asset.
person_commit_status_committed_organization_asset_domain_overridecharacterCDN domain override for the person's commitment status's committed-to program's logo asset (usually null).
person_commit_status_committed_organization_asset_domaincharacterCDN domain serving the person's commitment status's committed-to program's logo asset.
person_commit_status_committed_organization_asset_source_overridecharacterSource-path override for the person's commitment status's committed-to program's logo asset (usually null).
person_commit_status_committed_organization_asset_sourcecharacterCDN-relative source path of the person's commitment status's committed-to program's logo asset.
person_commit_status_committed_organization_asset_titlecharacterEditorial title attached to the person's commitment status's committed-to program's logo asset.
person_commit_status_committed_organization_asset_descriptioncharacterEditorial description attached to the person's commitment status's committed-to program's logo asset (usually null).
person_commit_status_committed_organization_asset_captioncharacterEditorial caption attached to the person's commitment status's committed-to program's logo asset (usually null).
person_commit_status_committed_organization_asset_categorycharacterEditorial category label of the person's commitment status's committed-to program's logo asset (usually null).
person_commit_status_committed_organization_asset_alt_textcharacterAccessibility alt text of the person's commitment status's committed-to program's logo asset (usually null).
person_commit_status_committed_organization_asset_heightintegerPixel height of the person's commitment status's committed-to program's logo asset.
person_commit_status_committed_organization_asset_widthintegerPixel width of the person's commitment status's committed-to program's logo asset.
person_commit_status_committed_organization_asset_asset_typecharacterOn3 asset-type discriminator of the person's commitment status's committed-to program's logo asset (e.g. Image).
person_commit_status_committed_organization_asset_file_systemcharacterStorage file-system flag of the person's commitment status's committed-to program's logo asset.
person_commit_status_committed_organization_asset_pathcharacterStorage path of the person's commitment status's committed-to program's logo asset.
person_commit_status_committed_organization_asset_typecharacterMedia type field of the person's commitment status's committed-to program's logo asset (file extension, e.g. png).
person_commit_status_committed_organization_asset_thumbnailcharacterThumbnail variant of the person's commitment status's committed-to program's logo asset (video assets; usually null).
person_commit_status_committed_organization_asset_durationintegerDuration of the person's commitment status's committed-to program's logo asset when it is a video (usually null or 0).
person_commit_status_committed_organization_asset_mime_typecharacterMIME type of the person's commitment status's committed-to program's logo asset.
person_commit_status_committed_organization_slugcharacterURL slug of the committed-to program (the person's commitment status).
person_commit_status_committed_organization_primary_colorcharacterPrimary hex color of the person's commitment status's committed-to program.
person_commit_status_class_rankcharacterAcademic class standing recorded on the person's commitment status (e.g. Senior).
person_commit_status_transfer_enteredcharacterDate the player entered the transfer portal (the person's commitment status; null when never entered).
person_commit_status_recruitment_yearintegerRecruiting-cycle year the person's commitment status belongs to.
person_commit_status_decommitted_assetcharacterNested asset of the program decommitted from (the person's commitment status; usually null).
person_commit_status_transferlogicalTransfer flag of the person's commitment status (null when not applicable).
person_commit_status_expected_to_transferlogicalExpected-to-transfer flag of the person's commitment status (null when not applicable).
person_commit_status_recruitment_keyintegerOn3 key of the recruitment record the person's commitment status belongs to.
person_commit_status_withdrawn_transferlogicalWhether the player withdrew from the transfer portal (the person's commitment status).
person_commit_status_withdrawn_transfer_datecharacterDate the player withdrew from the transfer portal (the person's commitment status; null when never withdrawn).
person_predictionscharacterJSON-encoded On3 RPM (Recruiting Prediction Machine) entries for the person.
person_nil_statuscharacterOn3 NIL valuation status of the person (e.g. Normal).
person_nil_valuenumericOn3 NIL valuation of the person in US dollars.
person_sportcharacterSport slug the video belongs to.
valuation_nil_statuscharacterStatus of the NIL valuation (e.g. Normal).
valuation_valuationintegerThe NIL valuation in US dollars.
valuation_valuation_changeintegerChange in the NIL valuation since the previous update, in US dollars.
valuation_followersintegerSocial-media follower count feeding the NIL valuation.
valuation_rankintegerOverall rank of the NIL valuation across On3's NIL 100.
valuation_last_updatedintegerUnix timestamp (seconds) of the last update to the NIL valuation.
valuation_whispernumericOn3 whisper valuation (reported deal value) behind the NIL valuation, in US dollars.
valuation_whisper_changenumericChange in the whisper valuation behind the NIL valuation, in US dollars.
valuation_social_valuationscharacterJSON-encoded per-platform social valuations behind the NIL valuation.
valuation_group_rankintegerRank of the NIL valuation within its group (sport or position).
valuation_group_namecharacterName of the group the NIL valuation is ranked within (usually null).
valuation_tagscharacterJSON-encoded list of NIL tags on the NIL valuation (e.g. Influencer).
valuation_roster_valuecharacterNested roster-value object of the NIL valuation (usually null).
valuation_nil_valuecharacterNested NIL-value object of the NIL valuation (usually null).
person_high_school_default_assetcharacterNested default-asset object of the person's high school (null when On3 ships none).

Row type: On3Nil100V2Row (exported from the package root).

Returns — on3_nil_compliances_state / on3NilCompliancesState​

No returns table is published for this endpoint: no committed capture with rows, and the response type is only heuristically mapped (x-source: call-site); names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_nil_rankings / on3NilRankings​

col_nametypedescription
person_default_sport_keyintegerOn3 numeric key of the person's primary sport.
person_default_sport_namecharacterName of the person's primary sport (e.g. Football).
person_default_sport_slugcharacterURL slug of the person's primary sport.
person_default_sport_abbreviationcharacterAbbreviation of the person's primary sport.
person_default_sport_is_rankablelogicalWhether On3 ranks players in the person's primary sport.
person_default_sport_is_industry_rankablelogicalWhether industry-consensus rankings exist for the person's primary sport.
person_default_sport_is_scoutablelogicalWhether On3 scouting reports exist for the person's primary sport.
person_rating_consensus_ratingnumericIndustry-consensus numeric rating paired with the person's On3 rating (0-100 scale).
person_rating_consensus_starsintegerIndustry-consensus star rating paired with the person's On3 rating (2-5).
person_rating_consensus_national_rankintegerIndustry-consensus national rank paired with the person's On3 rating.
person_rating_consensus_position_rankintegerIndustry-consensus position rank paired with the person's On3 rating.
person_rating_consensus_state_rankintegerIndustry-consensus state rank paired with the person's On3 rating.
person_rating_keyintegerOn3 key of the person's On3 rating record.
person_rating_ratingnumericNumeric value of the person's On3 rating (0-100 scale).
person_rating_starsintegerStar rating of the person's On3 rating (2-5).
person_rating_national_rankintegerNational rank of the person's On3 rating.
person_rating_position_rankintegerPosition rank of the person's On3 rating.
person_rating_state_rankintegerState rank of the person's On3 rating.
person_rating_position_abbrcharacterPosition abbreviation the person's On3 rating was assigned at.
person_rating_state_abbrcharacterState abbreviation the person's On3 rating was assigned in.
person_rating_five_star_pluslogicalFive-star-plus flag on the person's On3 rating.
person_status_is_committedlogicalWhether the recruit is committed (the person's recruiting status).
person_status_is_signedlogicalWhether the recruit has signed (the person's recruiting status).
person_status_is_transferlogicalWhether the recruit is a transfer (the person's recruiting status).
person_status_is_enrolledlogicalWhether the recruit is enrolled (the person's recruiting status).
person_status_commitment_datecharacterDate of the commitment (the person's recruiting status; ISO timestamp string).
person_status_committed_organization_keynumericOn3 key of the committed-to program (the person's recruiting status).
person_status_committed_organization_slugcharacterURL slug of the committed-to program (the person's recruiting status).
person_status_committed_organization_asset_urlcharacterCDN URL of the committed-to program's logo (the person's recruiting status).
person_status_committed_organization_asset_keynumericOn3 asset key of the person's recruiting status's committed-to program's logo asset.
person_status_committed_organization_asset_domain_overridecharacterCDN domain override for the person's recruiting status's committed-to program's logo asset (usually null).
person_status_committed_organization_asset_domaincharacterCDN domain serving the person's recruiting status's committed-to program's logo asset.
person_status_committed_organization_asset_source_overridecharacterSource-path override for the person's recruiting status's committed-to program's logo asset (usually null).
person_status_committed_organization_asset_sourcecharacterCDN-relative source path of the person's recruiting status's committed-to program's logo asset.
person_status_committed_organization_asset_titlecharacterEditorial title attached to the person's recruiting status's committed-to program's logo asset.
person_status_committed_organization_asset_descriptioncharacterEditorial description attached to the person's recruiting status's committed-to program's logo asset (usually null).
person_status_committed_organization_asset_captioncharacterEditorial caption attached to the person's recruiting status's committed-to program's logo asset (usually null).
person_status_committed_organization_asset_categorycharacterEditorial category label of the person's recruiting status's committed-to program's logo asset (usually null).
person_status_committed_organization_asset_alt_textcharacterAccessibility alt text of the person's recruiting status's committed-to program's logo asset (usually null).
person_status_committed_organization_asset_heightnumericPixel height of the person's recruiting status's committed-to program's logo asset.
person_status_committed_organization_asset_widthnumericPixel width of the person's recruiting status's committed-to program's logo asset.
person_status_committed_organization_asset_asset_typecharacterOn3 asset-type discriminator of the person's recruiting status's committed-to program's logo asset (e.g. Image).
person_status_committed_organization_asset_file_systemcharacterStorage file-system flag of the person's recruiting status's committed-to program's logo asset.
person_status_committed_organization_asset_pathcharacterStorage path of the person's recruiting status's committed-to program's logo asset.
person_status_committed_organization_asset_typecharacterMedia type field of the person's recruiting status's committed-to program's logo asset (file extension, e.g. png).
person_status_committed_organization_asset_thumbnailcharacterThumbnail variant of the person's recruiting status's committed-to program's logo asset (video assets; usually null).
person_status_committed_organization_asset_durationnumericDuration of the person's recruiting status's committed-to program's logo asset when it is a video (usually null or 0).
person_status_committed_organization_asset_mime_typecharacterMIME type of the person's recruiting status's committed-to program's logo asset.
person_status_committed_organization_primary_colorcharacterPrimary hex color of the person's recruiting status's committed-to program.
person_status_transferred_from_organization_asset_urlcharacterConvenience CDN URL of the person's recruiting status's program transferred from's logo.
person_status_transferred_from_organization_slugcharacterURL slug of the person's recruiting status's program transferred from on On3.
person_status_highest_interest_levelnumericHighest interest level a program has logged for the recruit (the person's recruiting status).
person_status_interest_countintegerNumber of programs with logged interest in the recruit (the person's recruiting status).
person_status_recruitment_yearintegerRecruiting-cycle year the person's recruiting status belongs to.
person_status_sport_namecharacterSport the person's recruiting status applies to.
person_status_short_term_signeelogicalShort-term-signee flag of the person's recruiting status (null when not applicable).
person_predictionscharacterJSON-encoded On3 RPM (Recruiting Prediction Machine) entries for the person.
person_tagscharacterJSON-encoded list of On3 profile tags on the person (e.g. Influencer).
person_keyintegerOn3 numeric key of the person.
person_namecharacterDisplay name of the person.
person_slugcharacterURL slug of the person's On3 profile.
person_high_school_namecharacterHigh-school display name on the person's record.
person_high_school_keyintegerOn3 numeric key of the person's high school.
person_high_school_full_namecharacterFull name of the person's high school (e.g. 'Alabama Crimson Tide').
person_high_school_name_2characterHigh-school display name on the person's record (json_normalize de-duplication suffix).
person_high_school_known_ascharacterCommon short name of the person's high school, when On3 lists one.
person_high_school_mascotcharacterMascot of the person's high school.
person_high_school_abbreviationcharacterAbbreviation of the person's high school.
person_high_school_asset_urlcharacterConvenience CDN URL of the person's high school's logo.
person_high_school_default_asset_keyintegerOn3 asset key of the person's high school's logo asset.
person_high_school_default_asset_domain_overridecharacterCDN domain override for the person's high school's logo asset (usually null).
person_high_school_default_asset_domaincharacterCDN domain serving the person's high school's logo asset.
person_high_school_default_asset_source_overridecharacterSource-path override for the person's high school's logo asset (usually null).
person_high_school_default_asset_sourcecharacterCDN-relative source path of the person's high school's logo asset.
person_high_school_default_asset_titlecharacterEditorial title attached to the person's high school's logo asset.
person_high_school_default_asset_descriptioncharacterEditorial description attached to the person's high school's logo asset (usually null).
person_high_school_default_asset_captioncharacterEditorial caption attached to the person's high school's logo asset (usually null).
person_high_school_default_asset_categorycharacterEditorial category label of the person's high school's logo asset (usually null).
person_high_school_default_asset_alt_textcharacterAccessibility alt text of the person's high school's logo asset (usually null).
person_high_school_default_asset_heightintegerPixel height of the person's high school's logo asset.
person_high_school_default_asset_widthintegerPixel width of the person's high school's logo asset.
person_high_school_default_asset_asset_typecharacterOn3 asset-type discriminator of the person's high school's logo asset (e.g. Image).
person_high_school_default_asset_file_systemcharacterStorage file-system flag of the person's high school's logo asset.
person_high_school_default_asset_pathcharacterStorage path of the person's high school's logo asset.
person_high_school_default_asset_typecharacterMedia type field of the person's high school's logo asset (file extension, e.g. png).
person_high_school_default_asset_thumbnailcharacterThumbnail variant of the person's high school's logo asset (video assets; usually null).
person_high_school_default_asset_durationintegerDuration of the person's high school's logo asset when it is a video (usually null or 0).
person_high_school_default_asset_mime_typecharacterMIME type of the person's high school's logo asset.
person_high_school_slugcharacterURL slug of the person's high school on On3.
person_high_school_primary_colorcharacterPrimary hex color of the person's high school.
person_high_school_org_typecharacterOrganization type label of the person's high school (e.g. HighSchool, College).
person_high_school_org_type_enumcharacterOrganization type enum of the person's high school (same vocabulary as org_type).
person_high_school_divisioncharacterDivision or classification of the person's high school (e.g. NCAA-FB).
person_high_school_site_keyscharacterJSON-encoded On3 site keys covering the person's high school (usually null).
person_high_school_url_slugcharacterURL slug variant of the person's high school's page, with the key appended.
person_home_town_namecharacterHome town of the person as On3 lists it (e.g. 'Belleville, MI').
person_default_asset_urlcharacterConvenience CDN URL of the person's headshot.
person_default_asset_keyintegerOn3 asset key of the person's headshot asset.
person_default_asset_domain_overridecharacterCDN domain override for the person's headshot asset (usually null).
person_default_asset_domaincharacterCDN domain serving the person's headshot asset.
person_default_asset_source_overridecharacterSource-path override for the person's headshot asset (usually null).
person_default_asset_sourcecharacterCDN-relative source path of the person's headshot asset.
person_default_asset_titlecharacterEditorial title attached to the person's headshot asset.
person_default_asset_descriptioncharacterEditorial description attached to the person's headshot asset (usually null).
person_default_asset_captioncharacterEditorial caption attached to the person's headshot asset (usually null).
person_default_asset_categorycharacterEditorial category label of the person's headshot asset (usually null).
person_default_asset_alt_textcharacterAccessibility alt text of the person's headshot asset (usually null).
person_default_asset_heightintegerPixel height of the person's headshot asset.
person_default_asset_widthintegerPixel width of the person's headshot asset.
person_default_asset_asset_typecharacterOn3 asset-type discriminator of the person's headshot asset (e.g. Image).
person_default_asset_file_systemcharacterStorage file-system flag of the person's headshot asset.
person_default_asset_pathcharacterStorage path of the person's headshot asset.
person_default_asset_typecharacterMedia type field of the person's headshot asset (file extension, e.g. png).
person_default_asset_thumbnailcharacterThumbnail variant of the person's headshot asset (video assets; usually null).
person_default_asset_durationintegerDuration of the person's headshot asset when it is a video (usually null or 0).
person_default_asset_mime_typecharacterMIME type of the person's headshot asset.
person_early_signeelogicalWhether the person signed during the early signing period.
person_early_enrolleelogicalWhether the person early-enrolled at college.
person_position_abbreviationcharacterPosition abbreviation on the person's record.
person_heightnumericHeight of the person: a formatted string (e.g. '6-8') or inches, depending on the endpoint.
person_formatted_heightcharacterHuman-formatted height of the person (e.g. '6-3.5').
person_weightintegerWeight of the person in pounds.
person_class_yearintegerHigh-school graduating class year of the person.
person_athlete_verifiedlogicalWhether the person's athlete profile is verified by On3.
person_prospect_verifiedlogicalWhether the person's prospect measurables are verified by On3.
person_class_rankcharacterAcademic class standing of the person (e.g. Senior, RedShirt Senior).
person_recruitment_keyintegerOn3 key of the person's active recruitment record.
person_ageintegerAge of the person in years, when known.
valuation_nil_statuscharacterStatus of the NIL valuation (e.g. Normal).
valuation_valuationintegerThe NIL valuation in US dollars.
valuation_valuation_changeintegerChange in the NIL valuation since the previous update, in US dollars.
valuation_followersintegerSocial-media follower count feeding the NIL valuation.
valuation_rankintegerOverall rank of the NIL valuation across On3's NIL 100.
valuation_last_updatedintegerUnix timestamp (seconds) of the last update to the NIL valuation.
valuation_whispercharacterOn3 whisper valuation (reported deal value) behind the NIL valuation, in US dollars.
valuation_whisper_changecharacterChange in the whisper valuation behind the NIL valuation, in US dollars.
valuation_social_valuationscharacterJSON-encoded per-platform social valuations behind the NIL valuation.
valuation_group_rankintegerRank of the NIL valuation within its group (sport or position).
valuation_group_namecharacterName of the group the NIL valuation is ranked within (usually null).
valuation_tagscharacterJSON-encoded list of NIL tags on the NIL valuation (e.g. Influencer).
valuation_roster_valuecharacterNested roster-value object of the NIL valuation (usually null).
valuation_nil_valuecharacterNested NIL-value object of the NIL valuation (usually null).
person_status_committed_organization_assetcharacterNested logo asset of the committed-to program (the person's recruiting status; stringified or null).

Row type: On3NilRankingsRow (exported from the package root).

Returns — on3_organizations_draft_class_by_state / on3OrganizationsDraftClassByState​

No returns table is published for this endpoint: no committed capture with rows, and the response type is only heuristically mapped (x-source: call-site); names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_organizations_draft_class_by_year / on3OrganizationsDraftClassByYear​

No returns table is published for this endpoint: no committed capture with rows, and the response type is only heuristically mapped (x-source: call-site); names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_organizations_draft_count_by_stars / on3OrganizationsDraftCountByStars​

No returns table is published for this endpoint: no committed capture with rows, and the response type is only heuristically mapped (x-source: call-site); names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_organizations_draft_count_by_year / on3OrganizationsDraftCountByYear​

No returns table is published for this endpoint: no committed capture with rows, and the response type is only heuristically mapped (x-source: call-site); names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_organizations_draft_ranking_summary / on3OrganizationsDraftRankingSummary​

No returns table is published for this endpoint: no committed capture with rows, and the response type is only heuristically mapped (x-source: call-site); names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_organizations_drafted_players / on3OrganizationsDraftedPlayers​

No returns table is published for this endpoint: no committed capture with rows, and the response type is only heuristically mapped (x-source: call-site); names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_organizations_drafts_by_stars_summary / on3OrganizationsDraftsByStarsSummary​

No returns table is published for this endpoint: no committed capture with rows, and the response type is only heuristically mapped (x-source: call-site); names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_organizations_roster_header / on3OrganizationsRosterHeader​

col_nametypedescription
talent_rankcharacterProgram's current national roster-talent rank per On3.
prev_talent_rankcharacterProgram's roster-talent rank in the previous cycle.
conference_rankcharacterProgram's roster-talent rank within its conference.
prev_conference_rankcharacterProgram's conference roster-talent rank in the previous cycle.
average_ratingcharacterAverage On3 rating across the roster.
prev_average_ratingcharacterAverage On3 roster rating in the previous cycle.
average_nil_valuenumericAverage On3 NIL valuation across the roster, in dollars.
total_nil_valueintegerTotal On3 NIL valuation across the roster, in dollars.
head_coach_keyintegerOn3 numeric key of the head coach.
head_coach_first_namecharacterFirst name of the head coach.
head_coach_last_namecharacterLast name of the head coach.
head_coach_known_as_namecharacterPreferred name of the head coach, when it differs from the given name.
head_coach_full_namecharacterFull name of the head coach.
head_coach_slugcharacterURL slug of the head coach's On3 profile.
head_coach_default_asset_keyintegerOn3 asset key of the head coach's headshot asset.
head_coach_default_asset_domain_overridecharacterCDN domain override for the head coach's headshot asset (usually null).
head_coach_default_asset_domaincharacterCDN domain serving the head coach's headshot asset.
head_coach_default_asset_source_overridecharacterSource-path override for the head coach's headshot asset (usually null).
head_coach_default_asset_sourcecharacterCDN-relative source path of the head coach's headshot asset.
head_coach_default_asset_titlecharacterEditorial title attached to the head coach's headshot asset.
head_coach_default_asset_descriptioncharacterEditorial description attached to the head coach's headshot asset (usually null).
head_coach_default_asset_captioncharacterEditorial caption attached to the head coach's headshot asset (usually null).
head_coach_default_asset_categorycharacterEditorial category label of the head coach's headshot asset (usually null).
head_coach_default_asset_alt_textcharacterAccessibility alt text of the head coach's headshot asset (usually null).
head_coach_default_asset_heightintegerPixel height of the head coach's headshot asset.
head_coach_default_asset_widthintegerPixel width of the head coach's headshot asset.
head_coach_default_asset_asset_typecharacterOn3 asset-type discriminator of the head coach's headshot asset (e.g. Image).
head_coach_default_asset_file_systemcharacterStorage file-system flag of the head coach's headshot asset.
head_coach_default_asset_pathcharacterStorage path of the head coach's headshot asset.
head_coach_default_asset_typecharacterMedia type field of the head coach's headshot asset (file extension, e.g. png).
head_coach_default_asset_thumbnailcharacterThumbnail variant of the head coach's headshot asset (video assets; usually null).
head_coach_default_asset_durationintegerDuration of the head coach's headshot asset when it is a video (usually null or 0).
head_coach_default_asset_mime_typecharacterMIME type of the head coach's headshot asset.
head_coach_organization_keyintegerOn3 numeric key of the head coach's program.
head_coach_organization_full_namecharacterFull name of the head coach's program (e.g. 'Alabama Crimson Tide').
head_coach_organization_namecharacterShort name of the head coach's program.
head_coach_organization_known_ascharacterCommon short name of the head coach's program, when On3 lists one.
head_coach_organization_mascotcharacterMascot of the head coach's program.
head_coach_organization_abbreviationcharacterAbbreviation of the head coach's program.
head_coach_organization_asset_urlcharacterConvenience CDN URL of the head coach's program's logo.
head_coach_organization_default_asset_keyintegerOn3 asset key of the head coach's program's logo asset.
head_coach_organization_default_asset_domain_overridecharacterCDN domain override for the head coach's program's logo asset (usually null).
head_coach_organization_default_asset_domaincharacterCDN domain serving the head coach's program's logo asset.
head_coach_organization_default_asset_source_overridecharacterSource-path override for the head coach's program's logo asset (usually null).
head_coach_organization_default_asset_sourcecharacterCDN-relative source path of the head coach's program's logo asset.
head_coach_organization_default_asset_titlecharacterEditorial title attached to the head coach's program's logo asset.
head_coach_organization_default_asset_descriptioncharacterEditorial description attached to the head coach's program's logo asset (usually null).
head_coach_organization_default_asset_captioncharacterEditorial caption attached to the head coach's program's logo asset (usually null).
head_coach_organization_default_asset_categorycharacterEditorial category label of the head coach's program's logo asset (usually null).
head_coach_organization_default_asset_alt_textcharacterAccessibility alt text of the head coach's program's logo asset (usually null).
head_coach_organization_default_asset_heightintegerPixel height of the head coach's program's logo asset.
head_coach_organization_default_asset_widthintegerPixel width of the head coach's program's logo asset.
head_coach_organization_default_asset_asset_typecharacterOn3 asset-type discriminator of the head coach's program's logo asset (e.g. Image).
head_coach_organization_default_asset_file_systemcharacterStorage file-system flag of the head coach's program's logo asset.
head_coach_organization_default_asset_pathcharacterStorage path of the head coach's program's logo asset.
head_coach_organization_default_asset_typecharacterMedia type field of the head coach's program's logo asset (file extension, e.g. png).
head_coach_organization_default_asset_thumbnailcharacterThumbnail variant of the head coach's program's logo asset (video assets; usually null).
head_coach_organization_default_asset_durationintegerDuration of the head coach's program's logo asset when it is a video (usually null or 0).
head_coach_organization_default_asset_mime_typecharacterMIME type of the head coach's program's logo asset.
head_coach_organization_slugcharacterURL slug of the head coach's program on On3.
head_coach_organization_primary_colorcharacterPrimary hex color of the head coach's program.
head_coach_organization_org_typecharacterOrganization type label of the head coach's program (e.g. HighSchool, College).
head_coach_organization_org_type_enumcharacterOrganization type enum of the head coach's program (same vocabulary as org_type).
head_coach_organization_divisioncharacterDivision or classification of the head coach's program (e.g. NCAA-FB).
head_coach_organization_site_keyscharacterJSON-encoded On3 site keys covering the head coach's program (usually null).
head_coach_organization_url_slugcharacterURL slug variant of the head coach's program's page, with the key appended.
head_coach_primary_position_keyintegerOn3 numeric key of the head coach's primary position.
head_coach_primary_position_namecharacterName of the head coach's primary position (e.g. Quarterback).
head_coach_primary_position_abbrcharacterAbbreviation of the head coach's primary position (e.g. QB).
head_coach_secondary_positioncharacterSecondary position of the head coach, when listed.
head_coach_org_season_countintegerSeasons the head coach has spent at the program.
head_coach_years_activeintegerYears the head coach has been active in coaching.

Row type: On3OrganizationsRosterHeaderRow (exported from the package root).

Returns — on3_people_combine_measurements / on3PeopleCombineMeasurements​

No returns table is published for this endpoint: its committed capture has 0 rows, so the parser emits no columns; names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_people_latest_valuation / on3PeopleLatestValuation​

col_nametypedescription
nil_statuscharacterStatus of the athlete's On3 NIL valuation (e.g. active, inactive).
valuationintegerAthlete's latest On3 NIL valuation in dollars.
valuation_changeintegerChange in the NIL valuation since the previous update, in dollars.
followersintegerTotal social-media followers counted toward the valuation.
rankintegerOverall rank of the player's NIL valuation across On3's NIL 100.
last_updatedintegerUnix timestamp (seconds) of the last update to the NIL valuation.
whispernumericOn3 whisper valuation (reported deal value) behind the NIL valuation, in US dollars.
whisper_changenumericChange in the whisper valuation since the previous update, in US dollars.
social_valuationscharacterPer-platform breakdown of the social components of the valuation (stringified list).
group_rankintegerRank of the NIL valuation within its group (sport or position).
group_namecharacterName of the group the NIL valuation is ranked within (usually null).
tagscharacterJSON-encoded list of NIL tags on the valuation (e.g. Influencer).
roster_valuecharacterNested roster-value object of the NIL valuation (usually null).
nil_valuecharacterOn3 NIL valuation in US dollars.

Row type: On3PeopleLatestValuationRow (exported from the package root).

Returns — on3_people_measurements / on3PeopleMeasurements​

col_nametypedescription
player_measurementscharacterJSON-encoded list of the player's measurement records (type, value, verification).

Row type: On3PeopleMeasurementsRow (exported from the package root).

Returns — on3_people_person_connections / on3PeoplePersonConnections​

No returns table is published for this endpoint: its committed capture has 0 rows, so the parser emits no columns; names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_people_social / on3PeopleSocial​

col_nametypedescription
typecharacterType label of the row (vocabulary depends on the endpoint).
handlecharacterAthlete's account handle on the social platform.
handshakelogicalOn3 RDB handshake field on the social-account record (platform link/verification metadata).

Row type: On3PeopleSocialRow (exported from the package root).

Returns — on3_people_social_post_summary / on3PeopleSocialPostSummary​

col_nametypedescription
social_typecharacterSocial platform the post summary covers (e.g. Twitter/X, Instagram).
typecharacterType label of the row (vocabulary depends on the endpoint).
followersintegerAthlete's follower count on the platform.

Row type: On3PeopleSocialPostSummaryRow (exported from the package root).

Returns — on3_people_track_and_field_measurements / on3PeopleTrackAndFieldMeasurements​

No returns table is published for this endpoint: no committed capture with rows, and the response type is only heuristically mapped (x-source: call-site); names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_people_valuation_growth / on3PeopleValuationGrowth​

col_nametypedescription
nil_statuscharacterStatus of the athlete's On3 NIL valuation at the snapshot (e.g. active, inactive).
valuationintegerAthlete's On3 NIL valuation in dollars at the snapshot.
valuation_changenumericChange in the NIL valuation versus the previous snapshot, in dollars.
datecharacterDate of the On3 NIL valuation snapshot.
date_unixintegerUnix timestamp of the valuation snapshot.

Row type: On3PeopleValuationGrowthRow (exported from the package root).

Returns — on3_person_connections_connection_key / on3PersonConnectionsConnectionKey​

No returns table is published for this endpoint: no committed capture with rows, and the response type is only heuristically mapped (x-source: call-site); names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_person_primary_recruitment_evaluation / on3PersonPrimaryRecruitmentEvaluation​

No returns table is published for this endpoint: no committed capture with rows; names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_person_recruitment_evaluations / on3PersonRecruitmentEvaluations​

No returns table is published for this endpoint: no committed capture with rows; names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_person_sport_profile_recruit / on3PersonSportProfileRecruit​

No returns table is published for this endpoint: no committed capture with rows, and the row has nested objects whose flattened column names depend on which are null in the data; names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_person_sport_rankings / on3PersonSportRankings​

No returns table is published for this endpoint: no committed capture with rows, and the response type is only heuristically mapped (x-source: call-site); names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_player_all_rankings / on3PlayerAllRankings​

col_nametypedescription
typecharacterType label of the row (vocabulary depends on the endpoint).
linkcharacterSite-relative On3 link for the row, when any.
ranking_keyintegerOn3 key of the ranking cycle the row belongs to.
ranking_yearintegerRanking cycle year.
ranking_typecharacterRanking type (e.g. Player, TransferPortal, Team).
ratingnumericOn3 rating of the player (0-100 scale), when published.
sportcharacterNested On3 sport object for the ranking row (stringified).
class_yearintegerRecruiting class year the ranking covers.
state_rankintegerRank within the player's state in the ranking.
state_abbrcharacterTwo-letter abbreviation of the player's home state.
position_rankintegerRank at the player's position in the ranking.
position_abbrcharacterPosition abbreviation the ranking entry was assigned at.
overall_rankintegerOverall national rank in the ranking.
starsintegerStar rating (2-5).
five_star_pluslogicalWhether On3 designates the player a Five-Star Plus+ prospect.
nearly_five_star_pluslogicalOn3 flag that the player narrowly missed the Five-Star Plus+ designation.
change_1characterDirection of the rating change since the previous update (e.g. Increase); the numeric suffix is a json_normalize de-duplication artefact.

Row type: On3PlayerAllRankingsRow (exported from the package root).

Returns — on3_player_database_updates / on3PlayerDatabaseUpdates​

col_nametypedescription
keyintegerOn3 RDB key for the database-update entry.
typecharacterType label of the row (vocabulary depends on the endpoint).
textcharacterText of the update as On3 displays it.
replacement_textcharacterRendered text of the update entry (with references substituted in).
linkcharacterSite-relative On3 link for the row, when any.
date_addedintegerDate the update entry was logged.
date_occurredintegerDate the underlying event occurred.
object_keyintegerOn3 key of the object the update refers to.
sport_keyintegerOn3 sport key the update is scoped to.
person_keyintegerOn3 person key of the player the update concerns.
organization_keyintegerOn3 organization key involved in the update, when any.

Row type: On3PlayerDatabaseUpdatesRow (exported from the package root).

Returns — on3_player_images / on3PlayerImages​

col_nametypedescription
keyintegerOn3 asset key for the image.
domain_overridecharacterOverride CDN domain for serving the image, when set.
domaincharacterCDN domain the image is served from.
source_overridecharacterOverride source attribution for the image, when set.
sourcecharacterCDN-relative source path of the image asset.
titlecharacterTitle of the row's record.
descriptioncharacterFree-text description or biography shipped by On3.
captioncharacterCaption text for the image.
categorycharacterCategory label On3 attaches to the row.
alt_textcharacterAlt text for the image.
heightintegerHeight as a formatted string (e.g. '6-3.5').
widthintegerImage width in pixels.
asset_typecharacterType of the asset (e.g. image) in On3's asset system.
file_systemcharacterStorage file system the asset lives on (On3 asset metadata).
pathcharacterStorage path of the image file.
typecharacterType label of the row (vocabulary depends on the endpoint).
thumbnailcharacterURL or path of the image's thumbnail rendition.
durationintegerDuration of the asset when it is a video (0 for images).
mime_typecharacterMIME type of the image file (e.g. image/jpeg).

Row type: On3PlayerImagesRow (exported from the package root).

Returns — on3_player_organizations / on3PlayerOrganizations​

No returns table is published for this endpoint: no committed capture with rows, and the response type is only heuristically mapped (x-source: call-site); names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_player_organizations_org_key / on3PlayerOrganizationsOrgKey​

No returns table is published for this endpoint: no committed capture with rows, and the row has nested objects whose flattened column names depend on which are null in the data; names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_player_person_rankings / on3PlayerPersonRankings​

col_nametypedescription
keyintegerOn3 RDB key for the player's ranking row.
ranking_keyintegerOn3 key of the ranking cycle the row belongs to.
ratingintegerOn3 rating of the player (0-100 scale), when published.
state_rankintegerRank within the player's state in the ranking.
state_abbrcharacterTwo-letter abbreviation of the player's home state.
position_rankintegerRank at the player's position in the ranking.
position_abbrcharacterPosition abbreviation the ranking entry was assigned at.
overall_rankintegerOverall national rank in the ranking.
starsintegerStar rating (2-5).
consensus_ratingnumericPlayer's industry-consensus rating (blend of the major recruiting services).
consensus_state_rankintegerPlayer's consensus rank within their home state.
consensus_position_rankintegerPlayer's consensus rank at their position.
consensus_overall_rankintegerPlayer's national consensus rank.
consensus_starsintegerPlayer's star rating under the industry consensus.
strengthintegerStrength score On3 attaches to the ranking entry.
five_star_pluslogicalWhether On3 designates the player a Five-Star Plus+ prospect.
ranking_typecharacterRanking type (e.g. Player, TransferPortal, Team).
ranking_key_2integerRanking key repeated from the nested ranking object (json_normalize de-duplication suffix).
ranking_sport_keyintegerOn3 numeric key of the sport the ranking is in.
ranking_sport_key_2integerOn3 numeric key of the sport the ranking is in (json_normalize de-duplication suffix).
ranking_sport_namecharacterName of the sport the ranking is in (e.g. Football).
ranking_yearintegerRanking cycle year.
change_38characterDirection of the On3 rating change since the previous update (e.g. Increase); the numeric suffix is a json_normalize de-duplication artefact.
consensus_change_41characterDirection of the consensus rating change since the previous update (e.g. Increase); the numeric suffix is a json_normalize de-duplication artefact.

Row type: On3PlayerPersonRankingsRow (exported from the package root).

Returns — on3_player_profile / on3PlayerProfile​

col_nametypedescription
keyintegerOn3 RDB key for the player profile.
class_year_recruitment_keyintegerOn3 recruitment key for the player's recruiting-class cycle.
recruitment_keyintegerOn3 key of the player's active recruitment record.
person_can_manage_recruitmentlogicalWhether the athlete can self-manage the recruitment on On3.
ranking_keyintegerOn3 key of the ranking cycle the profile's rating belongs to.
person_sport_keyintegerOn3 key of the athlete-sport profile (person x sport).
oracle_keycharacterOn3's internal oracle identifier for the player record.
namecharacterDisplay name of the row's record.
slugcharacterURL slug of the row's record on On3.
high_school_namecharacterHigh-school display name (top-level field).
hometown_namecharacterPlayer's hometown, as listed by On3.
position_abbreviationcharacterPosition abbreviation on the record.
class_rankcharacterPlayer's rank within their recruiting class.
heightcharacterHeight as a formatted string (e.g. '6-3.5').
weightintegerWeight in pounds.
class_yearintegerPlayer's recruiting class year.
degreecharacterDegree the player earned or is pursuing, when listed.
ageintegerAge in years, when known.
sportscharacterSports the player is profiled in, as a stringified list.
descriptioncharacterFree-text description or biography shipped by On3.
bio_pro_prospectcharacterBio text framing the player as a pro prospect (On3 RDB).
bio_college_recruitcharacterBio text framing the player as a college recruit (On3 RDB).
organization_levelcharacterLevel of the player's current organization (e.g. high school, college, professional).
high_school_org_keyintegerOn3 organization key of the player's high school.
prep_school_org_keycharacterOn3 organization key of the player's prep school, when attended.
junior_college_org_keycharacterOn3 organization key of the player's junior college, when attended.
college_org_keyintegerOn3 organization key of the player's college.
nil_valueintegerPlayer's On3 NIL valuation in dollars.
athlete_verifiedlogicalWhether the athlete has verified their own On3 profile.
prospect_verifiedlogicalWhether On3 has verified the prospect's profile information.
is_coachlogicalWhether the person record is a coach.
is_athletelogicalWhether the person record is an athlete.
visibilitycharacterProfile visibility setting on On3.
tiercharacterOn3 profile tier classification for the player.
review_statuscharacterEditorial review status of the profile in the On3 database.
jersey_numberintegerJersey number, when listed.
badgecharacterProfile badge assigned by On3, when any.
ncaa_idcharacterPlayer's NCAA identifier, when known to On3.
managed_by_userlogicalOn3 user account that manages the player's profile, when claimed.
ranking_key_2integerRanking key repeated from the nested ranking object (json_normalize de-duplication suffix).
ranking_ratingnumericNumeric value of the ranking (0-100 scale).
ranking_starsintegerStar rating of the ranking (2-5).
ranking_national_rankintegerNational rank of the ranking.
ranking_position_rankintegerPosition rank of the ranking.
ranking_state_rankintegerState rank of the ranking.
ranking_position_abbrcharacterPosition abbreviation the ranking was assigned at.
ranking_state_abbrcharacterState abbreviation the ranking was assigned in.
ranking_five_star_pluslogicalFive-star-plus flag on the ranking.
high_school_keyintegerOn3 numeric key of the high school.
high_school_full_namecharacterFull name of the high school (with mascot).
high_school_name_2characterName field of the nested high-school object (json_normalize de-duplication of high_school_name).
high_school_known_ascharacterCommon short name of the high school, when On3 lists one.
high_school_mascotcharacterHigh-school mascot.
high_school_abbreviationcharacterHigh-school abbreviation.
high_school_asset_urlcharacterConvenience CDN URL of the high-school logo.
high_school_default_asset_keyintegerOn3 asset key of the high school's logo asset.
high_school_default_asset_domain_overridecharacterCDN domain override for the high school's logo asset (usually null).
high_school_default_asset_domaincharacterCDN domain serving the high school's logo asset.
high_school_default_asset_source_overridecharacterSource-path override for the high school's logo asset (usually null).
high_school_default_asset_sourcecharacterCDN-relative source path of the high school's logo asset.
high_school_default_asset_titlecharacterEditorial title attached to the high school's logo asset.
high_school_default_asset_descriptioncharacterEditorial description attached to the high school's logo asset (usually null).
high_school_default_asset_captioncharacterEditorial caption attached to the high school's logo asset (usually null).
high_school_default_asset_categorycharacterEditorial category label of the high school's logo asset (usually null).
high_school_default_asset_alt_textcharacterAccessibility alt text of the high school's logo asset (usually null).
high_school_default_asset_heightintegerPixel height of the high school's logo asset.
high_school_default_asset_widthintegerPixel width of the high school's logo asset.
high_school_default_asset_asset_typecharacterOn3 asset-type discriminator of the high school's logo asset (e.g. Image).
high_school_default_asset_file_systemcharacterStorage file-system flag of the high school's logo asset.
high_school_default_asset_pathcharacterStorage path of the high school's logo asset.
high_school_default_asset_typecharacterMedia type field of the high school's logo asset (file extension, e.g. png).
high_school_default_asset_thumbnailcharacterThumbnail variant of the high school's logo asset (video assets; usually null).
high_school_default_asset_durationintegerDuration of the high school's logo asset when it is a video (usually null or 0).
high_school_default_asset_mime_typecharacterMIME type of the high school's logo asset.
high_school_slugcharacterURL slug of the high school on On3.
high_school_primary_colorcharacterPrimary hex color of the high school.
high_school_org_typecharacterOrganization type label of the school (e.g. HighSchool).
high_school_org_type_enumcharacterOrganization type enum of the school.
high_school_divisioncharacterDivision or classification of the high school, when listed.
high_school_site_keyscharacterJSON-encoded On3 site keys covering the school (usually null).
high_school_url_slugcharacterURL slug variant of the high-school page, with the key appended.
hometown_state_keyintegerOn3 numeric key of the home-town state.
hometown_state_namecharacterName of the home-town state.
hometown_state_abbreviationcharacterTwo-letter abbreviation of the home-town state.
hometown_state_country_keyintegerOn3 numeric key of the home-town state's country.
current_state_keyintegerOn3 numeric key of the current state.
current_state_namecharacterName of the current state.
current_state_abbreviationcharacterTwo-letter abbreviation of the current state.
current_state_country_keyintegerOn3 numeric key of the current state's country.
default_asset_keyintegerOn3 asset key of the default asset.
default_asset_domain_overridecharacterCDN domain override for the record's default asset (usually null).
default_asset_domaincharacterCDN domain serving the default asset.
default_asset_source_overridecharacterSource-path override for the default asset (usually null).
default_asset_sourcecharacterCDN-relative source path of the default asset.
default_asset_titlecharacterEditorial title attached to the default asset.
default_asset_descriptioncharacterEditorial description attached to the default asset (usually null).
default_asset_captioncharacterEditorial caption attached to the default asset (usually null).
default_asset_categorycharacterEditorial category label of the default asset (usually null).
default_asset_alt_textcharacterAccessibility alt text of the default asset (usually null).
default_asset_heightintegerPixel height of the default asset.
default_asset_widthintegerPixel width of the default asset.
default_asset_asset_typecharacterOn3 asset-type discriminator of the default asset (e.g. Image).
default_asset_file_systemcharacterStorage file-system flag of the default asset.
default_asset_pathcharacterStorage path of the default asset.
default_asset_typecharacterMedia type field of the default asset (file extension, e.g. png).
default_asset_thumbnailcharacterThumbnail variant of the default asset (video assets; usually null).
default_asset_durationintegerDuration of the default asset when it is a video (usually null or 0).
default_asset_mime_typecharacterMIME type of the default asset.
primary_position_keyintegerOn3 numeric key of the primary position.
primary_position_namecharacterName of the primary position (e.g. Quarterback).
primary_position_abbreviationcharacterAbbreviation of the primary position (e.g. QB).
primary_position_sport_keyintegerOn3 numeric key of the primary position's sport.
primary_position_sport_key_2integerOn3 numeric key of the primary position's sport (json_normalize de-duplication suffix).
primary_position_sport_namecharacterName of the primary position's sport (e.g. Football).
primary_position_sport_slugcharacterURL slug of the primary position's sport.
primary_position_sport_abbreviationcharacterAbbreviation of the primary position's sport.
primary_position_sport_is_rankablelogicalWhether On3 ranks players in the primary position's sport.
primary_position_sport_is_industry_rankablelogicalWhether industry-consensus rankings exist for the primary position's sport.
primary_position_sport_is_scoutablelogicalWhether On3 scouting reports exist for the primary position's sport.
primary_position_position_typecharacterPosition type of the primary position (e.g. Offense, Defense).
default_sport_keyintegerOn3 numeric key of the primary sport.
default_sport_namecharacterName of the primary sport (e.g. Football).
player_status_typecharacterType of the player's recruiting status (e.g. Committed, Signed, Enrolled, None).
player_status_short_term_signeelogicalShort-term-signee flag of the player's recruiting status (null when not applicable).
player_status_datecharacterDate the player's recruiting status took effect (ISO timestamp string).
player_status_committed_asset_keyintegerOn3 numeric key of the player's recruiting status's committed-to program.
player_status_committed_asset_urlcharacterCDN URL of the player's recruiting status's committed-to program's logo.
player_status_committed_asset_slugcharacterURL slug of the player's recruiting status's committed-to program on On3.
player_status_committed_asset_full_namecharacterFull name of the player's recruiting status's committed-to program (e.g. 'Alabama Crimson Tide').
player_status_committed_asset_res_keyintegerOn3 asset key of the player's recruiting status's committed-to program's logo asset.
player_status_committed_asset_res_domain_overridecharacterCDN domain override for the player's recruiting status's committed-to program's logo asset (usually null).
player_status_committed_asset_res_domaincharacterCDN domain serving the player's recruiting status's committed-to program's logo asset.
player_status_committed_asset_res_source_overridecharacterSource-path override for the player's recruiting status's committed-to program's logo asset (usually null).
player_status_committed_asset_res_sourcecharacterCDN-relative source path of the player's recruiting status's committed-to program's logo asset.
player_status_committed_asset_res_titlecharacterEditorial title attached to the player's recruiting status's committed-to program's logo asset.
player_status_committed_asset_res_descriptioncharacterEditorial description attached to the player's recruiting status's committed-to program's logo asset (usually null).
player_status_committed_asset_res_captioncharacterEditorial caption attached to the player's recruiting status's committed-to program's logo asset (usually null).
player_status_committed_asset_res_categorycharacterEditorial category label of the player's recruiting status's committed-to program's logo asset (usually null).
player_status_committed_asset_res_alt_textcharacterAccessibility alt text of the player's recruiting status's committed-to program's logo asset (usually null).
player_status_committed_asset_res_heightintegerPixel height of the player's recruiting status's committed-to program's logo asset.
player_status_committed_asset_res_widthintegerPixel width of the player's recruiting status's committed-to program's logo asset.
player_status_committed_asset_res_asset_typecharacterOn3 asset-type discriminator of the player's recruiting status's committed-to program's logo asset (e.g. Image).
player_status_committed_asset_res_file_systemcharacterStorage file-system flag of the player's recruiting status's committed-to program's logo asset.
player_status_committed_asset_res_pathcharacterStorage path of the player's recruiting status's committed-to program's logo asset.
player_status_committed_asset_res_typecharacterMedia type field of the player's recruiting status's committed-to program's logo asset (file extension, e.g. png).
player_status_committed_asset_res_thumbnailcharacterThumbnail variant of the player's recruiting status's committed-to program's logo asset (video assets; usually null).
player_status_committed_asset_res_durationintegerDuration of the player's recruiting status's committed-to program's logo asset when it is a video (usually null or 0).
player_status_committed_asset_res_mime_typecharacterMIME type of the player's recruiting status's committed-to program's logo asset.
player_status_transferred_asset_keyintegerOn3 numeric key of the player's recruiting status's program transferred to.
player_status_transferred_asset_urlcharacterCDN URL of the player's recruiting status's program transferred to's logo.
player_status_transferred_asset_slugcharacterURL slug of the player's recruiting status's program transferred to on On3.
player_status_transferred_asset_full_namecharacterFull name of the player's recruiting status's program transferred to (e.g. 'Alabama Crimson Tide').
player_status_transferred_asset_res_keyintegerOn3 asset key of the player's recruiting status's program transferred to's logo asset.
player_status_transferred_asset_res_domain_overridecharacterCDN domain override for the player's recruiting status's program transferred to's logo asset (usually null).
player_status_transferred_asset_res_domaincharacterCDN domain serving the player's recruiting status's program transferred to's logo asset.
player_status_transferred_asset_res_source_overridecharacterSource-path override for the player's recruiting status's program transferred to's logo asset (usually null).
player_status_transferred_asset_res_sourcecharacterCDN-relative source path of the player's recruiting status's program transferred to's logo asset.
player_status_transferred_asset_res_titlecharacterEditorial title attached to the player's recruiting status's program transferred to's logo asset.
player_status_transferred_asset_res_descriptioncharacterEditorial description attached to the player's recruiting status's program transferred to's logo asset (usually null).
player_status_transferred_asset_res_captioncharacterEditorial caption attached to the player's recruiting status's program transferred to's logo asset (usually null).
player_status_transferred_asset_res_categorycharacterEditorial category label of the player's recruiting status's program transferred to's logo asset (usually null).
player_status_transferred_asset_res_alt_textcharacterAccessibility alt text of the player's recruiting status's program transferred to's logo asset (usually null).
player_status_transferred_asset_res_heightintegerPixel height of the player's recruiting status's program transferred to's logo asset.
player_status_transferred_asset_res_widthintegerPixel width of the player's recruiting status's program transferred to's logo asset.
player_status_transferred_asset_res_asset_typecharacterOn3 asset-type discriminator of the player's recruiting status's program transferred to's logo asset (e.g. Image).
player_status_transferred_asset_res_file_systemcharacterStorage file-system flag of the player's recruiting status's program transferred to's logo asset.
player_status_transferred_asset_res_pathcharacterStorage path of the player's recruiting status's program transferred to's logo asset.
player_status_transferred_asset_res_typecharacterMedia type field of the player's recruiting status's program transferred to's logo asset (file extension, e.g. png).
player_status_transferred_asset_res_thumbnailcharacterThumbnail variant of the player's recruiting status's program transferred to's logo asset (video assets; usually null).
player_status_transferred_asset_res_durationintegerDuration of the player's recruiting status's program transferred to's logo asset when it is a video (usually null or 0).
player_status_transferred_asset_res_mime_typecharacterMIME type of the player's recruiting status's program transferred to's logo asset.
player_status_committed_organization_keyintegerOn3 key of the committed-to program (the player's recruiting status).
player_status_committed_organization_full_namecharacterFull name of the player's recruiting status's committed-to program (e.g. 'Alabama Crimson Tide').
player_status_committed_organization_namecharacterShort name of the player's recruiting status's committed-to program.
player_status_committed_organization_mascotcharacterMascot of the player's recruiting status's committed-to program.
player_status_committed_organization_abbreviationcharacterAbbreviation of the player's recruiting status's committed-to program.
player_status_committed_organization_asset_urlcharacterCDN URL of the committed-to program's logo (the player's recruiting status).
player_status_committed_organization_asset_keyintegerOn3 asset key of the player's recruiting status's committed-to program's logo asset.
player_status_committed_organization_asset_domain_overridecharacterCDN domain override for the player's recruiting status's committed-to program's logo asset (usually null).
player_status_committed_organization_asset_domaincharacterCDN domain serving the player's recruiting status's committed-to program's logo asset.
player_status_committed_organization_asset_source_overridecharacterSource-path override for the player's recruiting status's committed-to program's logo asset (usually null).
player_status_committed_organization_asset_sourcecharacterCDN-relative source path of the player's recruiting status's committed-to program's logo asset.
player_status_committed_organization_asset_titlecharacterEditorial title attached to the player's recruiting status's committed-to program's logo asset.
player_status_committed_organization_asset_descriptioncharacterEditorial description attached to the player's recruiting status's committed-to program's logo asset (usually null).
player_status_committed_organization_asset_captioncharacterEditorial caption attached to the player's recruiting status's committed-to program's logo asset (usually null).
player_status_committed_organization_asset_categorycharacterEditorial category label of the player's recruiting status's committed-to program's logo asset (usually null).
player_status_committed_organization_asset_alt_textcharacterAccessibility alt text of the player's recruiting status's committed-to program's logo asset (usually null).
player_status_committed_organization_asset_heightintegerPixel height of the player's recruiting status's committed-to program's logo asset.
player_status_committed_organization_asset_widthintegerPixel width of the player's recruiting status's committed-to program's logo asset.
player_status_committed_organization_asset_asset_typecharacterOn3 asset-type discriminator of the player's recruiting status's committed-to program's logo asset (e.g. Image).
player_status_committed_organization_asset_file_systemcharacterStorage file-system flag of the player's recruiting status's committed-to program's logo asset.
player_status_committed_organization_asset_pathcharacterStorage path of the player's recruiting status's committed-to program's logo asset.
player_status_committed_organization_asset_typecharacterMedia type field of the player's recruiting status's committed-to program's logo asset (file extension, e.g. png).
player_status_committed_organization_asset_thumbnailcharacterThumbnail variant of the player's recruiting status's committed-to program's logo asset (video assets; usually null).
player_status_committed_organization_asset_durationintegerDuration of the player's recruiting status's committed-to program's logo asset when it is a video (usually null or 0).
player_status_committed_organization_asset_mime_typecharacterMIME type of the player's recruiting status's committed-to program's logo asset.
player_status_committed_organization_slugcharacterURL slug of the committed-to program (the player's recruiting status).
player_status_committed_organization_primary_colorcharacterPrimary hex color of the player's recruiting status's committed-to program.
player_status_class_rankcharacterAcademic class standing recorded on the player's recruiting status (e.g. Senior).
player_status_transfer_enteredcharacterDate the player entered the transfer portal (the player's recruiting status; null when never entered).
player_status_recruitment_yearcharacterRecruiting-cycle year the player's recruiting status belongs to.
player_status_decommitted_assetcharacterNested asset of the program decommitted from (the player's recruiting status; usually null).
player_status_transferlogicalTransfer flag of the player's recruiting status (null when not applicable).
player_status_expected_to_transferlogicalExpected-to-transfer flag of the player's recruiting status (null when not applicable).
player_status_recruitment_keyintegerOn3 key of the recruitment record the player's recruiting status belongs to.
player_status_withdrawn_transferlogicalWhether the player withdrew from the transfer portal (the player's recruiting status).
player_status_withdrawn_transfer_datecharacterDate the player withdrew from the transfer portal (the player's recruiting status; null when never withdrawn).

Row type: On3PlayerProfileRow (exported from the package root).

Returns — on3_player_team_targets / on3PlayerTeamTargets​

No returns table is published for this endpoint: no committed capture with rows, and the row has nested objects whose flattened column names depend on which are null in the data; names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_player_videos / on3PlayerVideos​

col_nametypedescription
keyintegerOn3 RDB key for the video record.
source_urlcharacterSource URL of the hosted video.
titlecharacterTitle of the row's record.
thumbnailcharacterURL of the video's thumbnail image.
descriptioncharacterFree-text description or biography shipped by On3.
dateintegerPublication date of the video, per On3.
person_keyintegerOn3 person key of the featured athlete.
person_sportcharacterNested athlete-sport profile the video is attached to (stringified).
is_featuredlogicalWhether the video is featured on the player's On3 profile.
featured_ordercharacterDisplay order among featured videos, when featured.
category_keyintegerOn3 key of the video category.
category_valuecharacterVideo category label (e.g. Highlights).

Row type: On3PlayerVideosRow (exported from the package root).

Returns — on3_player_visit_center / on3PlayerVisitCenter​

No returns table is published for this endpoint: no committed capture with rows, and the row has nested objects whose flattened column names depend on which are null in the data; names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_players_industry_comparision / on3PlayersIndustryComparision​

col_nametypedescription
ratingscharacterList of per-service rating entries (On3, Rivals, 247, ESPN) composing the industry comparison.
nil_valueintegerOn3 NIL valuation for the player (US dollars).
person_keyintegerOn3 numeric key of the person.
person_namecharacterDisplay name of the person.
person_slugcharacterURL slug of the person's On3 profile.
person_high_school_namecharacterHigh-school display name on the person's record.
person_high_school_keyintegerOn3 numeric key of the person's high school.
person_high_school_full_namecharacterFull name of the person's high school (e.g. 'Alabama Crimson Tide').
person_high_school_name_2characterHigh-school display name on the person's record (json_normalize de-duplication suffix).
person_high_school_known_ascharacterCommon short name of the person's high school, when On3 lists one.
person_high_school_mascotcharacterMascot of the person's high school.
person_high_school_abbreviationcharacterAbbreviation of the person's high school.
person_high_school_asset_urlcharacterConvenience CDN URL of the person's high school's logo.
person_high_school_default_asset_keyintegerOn3 asset key of the person's high school's logo asset.
person_high_school_default_asset_domain_overridecharacterCDN domain override for the person's high school's logo asset (usually null).
person_high_school_default_asset_domaincharacterCDN domain serving the person's high school's logo asset.
person_high_school_default_asset_source_overridecharacterSource-path override for the person's high school's logo asset (usually null).
person_high_school_default_asset_sourcecharacterCDN-relative source path of the person's high school's logo asset.
person_high_school_default_asset_titlecharacterEditorial title attached to the person's high school's logo asset.
person_high_school_default_asset_descriptioncharacterEditorial description attached to the person's high school's logo asset (usually null).
person_high_school_default_asset_captioncharacterEditorial caption attached to the person's high school's logo asset (usually null).
person_high_school_default_asset_categorycharacterEditorial category label of the person's high school's logo asset (usually null).
person_high_school_default_asset_alt_textcharacterAccessibility alt text of the person's high school's logo asset (usually null).
person_high_school_default_asset_heightintegerPixel height of the person's high school's logo asset.
person_high_school_default_asset_widthintegerPixel width of the person's high school's logo asset.
person_high_school_default_asset_asset_typecharacterOn3 asset-type discriminator of the person's high school's logo asset (e.g. Image).
person_high_school_default_asset_file_systemcharacterStorage file-system flag of the person's high school's logo asset.
person_high_school_default_asset_pathcharacterStorage path of the person's high school's logo asset.
person_high_school_default_asset_typecharacterMedia type field of the person's high school's logo asset (file extension, e.g. png).
person_high_school_default_asset_thumbnailcharacterThumbnail variant of the person's high school's logo asset (video assets; usually null).
person_high_school_default_asset_durationintegerDuration of the person's high school's logo asset when it is a video (usually null or 0).
person_high_school_default_asset_mime_typecharacterMIME type of the person's high school's logo asset.
person_high_school_slugcharacterURL slug of the person's high school on On3.
person_high_school_primary_colorcharacterPrimary hex color of the person's high school.
person_high_school_org_typecharacterOrganization type label of the person's high school (e.g. HighSchool, College).
person_high_school_org_type_enumcharacterOrganization type enum of the person's high school (same vocabulary as org_type).
person_high_school_divisioncharacterDivision or classification of the person's high school (e.g. NCAA-FB).
person_high_school_site_keyscharacterJSON-encoded On3 site keys covering the person's high school (usually null).
person_high_school_url_slugcharacterURL slug variant of the person's high school's page, with the key appended.
person_home_town_namecharacterHome town of the person as On3 lists it (e.g. 'Belleville, MI').
person_default_asset_urlcharacterConvenience CDN URL of the person's headshot.
person_default_asset_keyintegerOn3 asset key of the person's headshot asset.
person_default_asset_domain_overridecharacterCDN domain override for the person's headshot asset (usually null).
person_default_asset_domaincharacterCDN domain serving the person's headshot asset.
person_default_asset_source_overridecharacterSource-path override for the person's headshot asset (usually null).
person_default_asset_sourcecharacterCDN-relative source path of the person's headshot asset.
person_default_asset_titlecharacterEditorial title attached to the person's headshot asset.
person_default_asset_descriptioncharacterEditorial description attached to the person's headshot asset (usually null).
person_default_asset_captioncharacterEditorial caption attached to the person's headshot asset (usually null).
person_default_asset_categorycharacterEditorial category label of the person's headshot asset (usually null).
person_default_asset_alt_textcharacterAccessibility alt text of the person's headshot asset (usually null).
person_default_asset_heightintegerPixel height of the person's headshot asset.
person_default_asset_widthintegerPixel width of the person's headshot asset.
person_default_asset_asset_typecharacterOn3 asset-type discriminator of the person's headshot asset (e.g. Image).
person_default_asset_file_systemcharacterStorage file-system flag of the person's headshot asset.
person_default_asset_pathcharacterStorage path of the person's headshot asset.
person_default_asset_typecharacterMedia type field of the person's headshot asset (file extension, e.g. png).
person_default_asset_thumbnailcharacterThumbnail variant of the person's headshot asset (video assets; usually null).
person_default_asset_durationintegerDuration of the person's headshot asset when it is a video (usually null or 0).
person_default_asset_mime_typecharacterMIME type of the person's headshot asset.
person_early_signeelogicalWhether the person signed during the early signing period.
person_early_enrolleelogicalWhether the person early-enrolled at college.
person_position_abbreviationcharacterPosition abbreviation on the person's record.
person_heightnumericHeight of the person: a formatted string (e.g. '6-8') or inches, depending on the endpoint.
person_formatted_heightcharacterHuman-formatted height of the person (e.g. '6-3.5').
person_weightintegerWeight of the person in pounds.
person_class_yearintegerHigh-school graduating class year of the person.
person_athlete_verifiedlogicalWhether the person's athlete profile is verified by On3.
person_prospect_verifiedlogicalWhether the person's prospect measurables are verified by On3.
person_class_rankcharacterAcademic class standing of the person (e.g. Senior, RedShirt Senior).
person_recruitment_keyintegerOn3 key of the person's active recruitment record.
person_ageintegerAge of the person in years, when known.

Row type: On3PlayersIndustryComparisionRow (exported from the package root).

Returns — on3_players_industry_comparision_list / on3PlayersIndustryComparisionList​

No returns table is published for this endpoint: no committed capture with rows, and the response type is only heuristically mapped (x-source: call-site); names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_predictions_user_key / on3PredictionsUserKey​

No returns table is published for this endpoint: no committed capture with rows, and the response type is only heuristically mapped (x-source: call-site); names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_quotes / on3Quotes​

col_nametypedescription
keyintegerOn3 RDB key for the quote record.
bodycharacterFull text of the quote.
categorycharacterCategory label On3 attaches to the row.
person_keyintegerOn3 person key of the person quoted or quoted about.
date_addedcharacterDate the quote was added to the On3 database.
date_updatedcharacterDate the quote was last updated.
person_key_2integerPerson key repeated from the nested person object (json_normalize de-duplication suffix).
person_known_as_namecharacterPreferred name of the person, when it differs from the given name.
person_first_namecharacterFirst name of the person.
person_last_namecharacterLast name of the person.
person_twitter_handlecharacterTwitter/X handle of the person, when listed.
person_instagram_profilecharacterInstagram profile of the person, when listed.
person_tik_tok_handlecharacterTikTok handle of the person, when listed.
person_espn_profilecharacterESPN profile link of the person, when listed.
person_class_yearintegerHigh-school graduating class year of the person.
person_two_four_seven_profilecharacter247Sports profile link of the person, when listed.
person_rivals_profilecharacterRivals profile link of the person, when listed.

Row type: On3QuotesRow (exported from the package root).

Returns — on3_quotes_key / on3QuotesKey​

No returns table is published for this endpoint: no committed capture with rows, and the response type is only heuristically mapped (x-source: call-site); names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_recruitment_primary_recruitment_evaluation / on3RecruitmentPrimaryRecruitmentEvaluation​

No returns table is published for this endpoint: no committed capture with rows; names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_recruitment_recruitment_evaluations / on3RecruitmentRecruitmentEvaluations​

No returns table is published for this endpoint: its committed capture has 0 rows, so the parser emits no columns; names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_recruitments_profile / on3RecruitmentsProfile​

col_nametypedescription
class_yearintegerRecruiting class year of the recruitment.
high_schoolcharacterHigh-school display name on the record.
home_towncharacterHome town as On3 lists it (e.g. 'Pewaukee, WI').
rating_keyintegerOn3 key of the On3 rating record.
rating_ratingnumericNumeric value of the On3 rating (0-100 scale).
rating_starsintegerStar rating of the On3 rating (2-5).
rating_national_rankintegerNational rank of the On3 rating.
rating_position_rankintegerPosition rank of the On3 rating.
rating_state_rankintegerState rank of the On3 rating.
rating_position_abbrcharacterPosition abbreviation the On3 rating was assigned at.
rating_state_abbrcharacterState abbreviation the On3 rating was assigned in.
rating_five_star_pluslogicalFive-star-plus flag on the On3 rating.
committed_status_typecharacterType of the commitment status (e.g. Committed, Signed, Enrolled, None).
committed_status_short_term_signeelogicalShort-term-signee flag of the commitment status (null when not applicable).
committed_status_datecharacterDate the commitment status took effect (ISO timestamp string).
committed_status_committed_asset_keyintegerOn3 numeric key of the committed-to program.
committed_status_committed_asset_urlcharacterCDN URL of the committed-to program's logo.
committed_status_committed_asset_slugcharacterURL slug of the committed-to program on On3.
committed_status_committed_asset_full_namecharacterFull name of the committed-to program (e.g. 'Alabama Crimson Tide').
committed_status_committed_asset_res_keyintegerOn3 asset key of the committed-to program's logo asset.
committed_status_committed_asset_res_domain_overridecharacterCDN domain override for the committed-to program's logo asset (usually null).
committed_status_committed_asset_res_domaincharacterCDN domain serving the committed-to program's logo asset.
committed_status_committed_asset_res_source_overridecharacterSource-path override for the committed-to program's logo asset (usually null).
committed_status_committed_asset_res_sourcecharacterCDN-relative source path of the committed-to program's logo asset.
committed_status_committed_asset_res_titlecharacterEditorial title attached to the committed-to program's logo asset.
committed_status_committed_asset_res_descriptioncharacterEditorial description attached to the committed-to program's logo asset (usually null).
committed_status_committed_asset_res_captioncharacterEditorial caption attached to the committed-to program's logo asset (usually null).
committed_status_committed_asset_res_categorycharacterEditorial category label of the committed-to program's logo asset (usually null).
committed_status_committed_asset_res_alt_textcharacterAccessibility alt text of the committed-to program's logo asset (usually null).
committed_status_committed_asset_res_heightintegerPixel height of the committed-to program's logo asset.
committed_status_committed_asset_res_widthintegerPixel width of the committed-to program's logo asset.
committed_status_committed_asset_res_asset_typecharacterOn3 asset-type discriminator of the committed-to program's logo asset (e.g. Image).
committed_status_committed_asset_res_file_systemcharacterStorage file-system flag of the committed-to program's logo asset.
committed_status_committed_asset_res_pathcharacterStorage path of the committed-to program's logo asset.
committed_status_committed_asset_res_typecharacterMedia type field of the committed-to program's logo asset (file extension, e.g. png).
committed_status_committed_asset_res_thumbnailcharacterThumbnail variant of the committed-to program's logo asset (video assets; usually null).
committed_status_committed_asset_res_durationintegerDuration of the committed-to program's logo asset when it is a video (usually null or 0).
committed_status_committed_asset_res_mime_typecharacterMIME type of the committed-to program's logo asset.
committed_status_transferred_assetcharacterNested asset of the program transferred to (the commitment status; usually null).
committed_status_transferred_asset_rescharacterNested logo asset of the program transferred to (the commitment status; usually null).
committed_status_committed_organization_keyintegerOn3 key of the committed-to program (the commitment status).
committed_status_committed_organization_full_namecharacterFull name of the commitment status's committed-to program (e.g. 'Alabama Crimson Tide').
committed_status_committed_organization_namecharacterShort name of the commitment status's committed-to program.
committed_status_committed_organization_mascotcharacterMascot of the commitment status's committed-to program.
committed_status_committed_organization_abbreviationcharacterAbbreviation of the commitment status's committed-to program.
committed_status_committed_organization_asset_urlcharacterCDN URL of the committed-to program's logo (the commitment status).
committed_status_committed_organization_assetcharacterNested logo asset of the committed-to program (the commitment status; stringified or null).
committed_status_committed_organization_slugcharacterURL slug of the committed-to program (the commitment status).
committed_status_committed_organization_primary_colorcharacterPrimary hex color of the commitment status's committed-to program.
committed_status_class_rankcharacterAcademic class standing recorded on the commitment status (e.g. Senior).
committed_status_transfer_enteredcharacterDate the player entered the transfer portal (the commitment status; null when never entered).
committed_status_recruitment_yearcharacterRecruiting-cycle year the commitment status belongs to.
committed_status_decommitted_assetcharacterNested asset of the program decommitted from (the commitment status; usually null).
committed_status_transferlogicalTransfer flag of the commitment status (null when not applicable).
committed_status_expected_to_transferlogicalExpected-to-transfer flag of the commitment status (null when not applicable).
committed_status_recruitment_keyintegerOn3 key of the recruitment record the commitment status belongs to.
committed_status_withdrawn_transferlogicalWhether the player withdrew from the transfer portal (the commitment status).
committed_status_withdrawn_transfer_datecharacterDate the player withdrew from the transfer portal (the commitment status; null when never withdrawn).
high_school_org_keyintegerOn3 numeric key of the high school.
high_school_org_full_namecharacterFull name of the high school (e.g. 'Alabama Crimson Tide').
high_school_org_namecharacterShort name of the high school.
high_school_org_known_ascharacterCommon short name of the high school, when On3 lists one.
high_school_org_mascotcharacterMascot of the high school.
high_school_org_abbreviationcharacterAbbreviation of the high school.
high_school_org_asset_urlcharacterConvenience CDN URL of the high school's logo.
high_school_org_default_asset_keyintegerOn3 asset key of the high school's logo asset.
high_school_org_default_asset_domain_overridecharacterCDN domain override for the high school's logo asset (usually null).
high_school_org_default_asset_domaincharacterCDN domain serving the high school's logo asset.
high_school_org_default_asset_source_overridecharacterSource-path override for the high school's logo asset (usually null).
high_school_org_default_asset_sourcecharacterCDN-relative source path of the high school's logo asset.
high_school_org_default_asset_titlecharacterEditorial title attached to the high school's logo asset.
high_school_org_default_asset_descriptioncharacterEditorial description attached to the high school's logo asset (usually null).
high_school_org_default_asset_captioncharacterEditorial caption attached to the high school's logo asset (usually null).
high_school_org_default_asset_categorycharacterEditorial category label of the high school's logo asset (usually null).
high_school_org_default_asset_alt_textcharacterAccessibility alt text of the high school's logo asset (usually null).
high_school_org_default_asset_heightintegerPixel height of the high school's logo asset.
high_school_org_default_asset_widthintegerPixel width of the high school's logo asset.
high_school_org_default_asset_asset_typecharacterOn3 asset-type discriminator of the high school's logo asset (e.g. Image).
high_school_org_default_asset_file_systemcharacterStorage file-system flag of the high school's logo asset.
high_school_org_default_asset_pathcharacterStorage path of the high school's logo asset.
high_school_org_default_asset_typecharacterMedia type field of the high school's logo asset (file extension, e.g. png).
high_school_org_default_asset_thumbnailcharacterThumbnail variant of the high school's logo asset (video assets; usually null).
high_school_org_default_asset_durationintegerDuration of the high school's logo asset when it is a video (usually null or 0).
high_school_org_default_asset_mime_typecharacterMIME type of the high school's logo asset.
high_school_org_slugcharacterURL slug of the high school on On3.
high_school_org_primary_colorcharacterPrimary hex color of the high school.
high_school_org_org_typecharacterOrganization type label of the high school (e.g. HighSchool, College).
high_school_org_org_type_enumcharacterOrganization type enum of the high school (same vocabulary as org_type).
high_school_org_divisioncharacterDivision or classification of the high school (e.g. NCAA-FB).
high_school_org_site_keyscharacterJSON-encoded On3 site keys covering the high school (usually null).
high_school_org_url_slugcharacterURL slug variant of the high school's page, with the key appended.

Row type: On3RecruitmentsProfileRow (exported from the package root).

Returns — on3_recruitments_rpm_picks / on3RecruitmentsRpmPicks​

No returns table is published for this endpoint: its committed capture has 0 rows, so the parser emits no columns; names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_recruitments_rpm_summary / on3RecruitmentsRpmSummary​

col_nametypedescription
predictionscharacterPer-team RPM prediction percentages for the recruitment, as a stringified list.
lockedlogicalWhether the RPM prediction for the recruitment is locked (no longer updating).

Row type: On3RecruitmentsRpmSummaryRow (exported from the package root).

Returns — on3_team_ranking / on3TeamRanking​

No returns table is published for this endpoint: no committed capture with rows, and the response type is only heuristically mapped (x-source: call-site); names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_team_ranking_bluechips_team_rankings / on3TeamRankingBluechipsTeamRankings​

No returns table is published for this endpoint: no committed capture with rows, and the row has nested objects whose flattened column names depend on which are null in the data; names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_team_ranking_consensus_team_rankings / on3TeamRankingConsensusTeamRankings​

No returns table is published for this endpoint: no committed capture with rows, and the row has nested objects whose flattened column names depend on which are null in the data; names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_team_ranking_organizations_summary / on3TeamRankingOrganizationsSummary​

No returns table is published for this endpoint: no committed capture with rows, and the row has nested objects whose flattened column names depend on which are null in the data; names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Returns — on3_team_ranking_team_rankings / on3TeamRankingTeamRankings​

col_nametypedescription
keyintegerOn3 organization-ranking key for the class row.
yearintegerRecruiting class year of the row.
applied_total_ratingnumericTotal On3 rating applied to the class after deductions.
applied_total_consensus_ratingnumericTotal consensus rating applied to the class after deductions.
applied_average_ratingnumericAverage On3 rating applied to the class after deductions.
applied_average_consensus_ratingnumericAverage consensus rating applied to the class after deductions.
commitsintegerNumber of commits in the recruiting class.
applied_commitsintegerNumber of commits counted toward the applied class rating.
deductionsnumericRating deductions applied to the class (e.g. for roster limits).
deductions_descriptioncharacterHuman-readable explanation of any applied deductions.
five_starsintegerCount of On3 five-star commits in the class.
consensus_five_starsintegerCount of consensus five-star commits in the class.
four_starsintegerCount of On3 four-star commits in the class.
consensus_four_starsintegerCount of consensus four-star commits in the class.
three_starsintegerCount of On3 three-star commits in the class.
consensus_three_starsintegerCount of consensus three-star commits in the class.
overall_rankintegerNational rank of the class by On3 score.
overall_consensus_rankintegerNational rank of the class by consensus score.
dispay_consensus_scorenumericDisplay consensus score for the class (On3 sic spelling of "display").
dispay_on3_scorenumericDisplay On3 score for the class (On3 sic spelling of "display").
average_nil_valuenumericAverage On3 NIL valuation across the class's commits (US dollars).
conference_rankintegerRank of the class within its conference by On3 score.
conference_consensus_rankintegerRank of the class within its conference by consensus score.
organization_keyintegerOn3 numeric key of the program.
organization_full_namecharacterFull name of the program (e.g. 'Alabama Crimson Tide').
organization_namecharacterShort name of the program.
organization_mascotcharacterMascot of the program.
organization_abbreviationcharacterAbbreviation of the program.
organization_asset_urlcharacterConvenience CDN URL of the program's logo.
organization_asset_keyintegerOn3 asset key of the program's logo asset.
organization_asset_domain_overridecharacterCDN domain override for the program's logo asset (usually null).
organization_asset_domaincharacterCDN domain serving the program's logo asset.
organization_asset_source_overridecharacterSource-path override for the program's logo asset (usually null).
organization_asset_sourcecharacterCDN-relative source path of the program's logo asset.
organization_asset_titlecharacterEditorial title attached to the program's logo asset.
organization_asset_descriptioncharacterEditorial description attached to the program's logo asset (usually null).
organization_asset_captioncharacterEditorial caption attached to the program's logo asset (usually null).
organization_asset_categorycharacterEditorial category label of the program's logo asset (usually null).
organization_asset_alt_textcharacterAccessibility alt text of the program's logo asset (usually null).
organization_asset_heightintegerPixel height of the program's logo asset.
organization_asset_widthintegerPixel width of the program's logo asset.
organization_asset_asset_typecharacterOn3 asset-type discriminator of the program's logo asset (e.g. Image).
organization_asset_file_systemcharacterStorage file-system flag of the program's logo asset.
organization_asset_pathcharacterStorage path of the program's logo asset.
organization_asset_typecharacterMedia type field of the program's logo asset (file extension, e.g. png).
organization_asset_thumbnailcharacterThumbnail variant of the program's logo asset (video assets; usually null).
organization_asset_durationintegerDuration of the program's logo asset when it is a video (usually null or 0).
organization_asset_mime_typecharacterMIME type of the program's logo asset.
organization_slugcharacterURL slug of the program on On3.
organization_primary_colorcharacterPrimary hex color of the program.

Row type: On3TeamRankingTeamRankingsRow (exported from the package root).

Returns — on3_videos_video_key / on3VideosVideoKey​

No returns table is published for this endpoint: no committed capture with rows, and the row has nested objects whose flattened column names depend on which are null in the data; names derived from the OpenAPI response type matched parse_on3_rdb's output on only 7 of the 9 checkable endpoints, so none are published

Rows are untyped Row[] (not parity-verified yet).

Generated by tools/codegen/generate.mjs from tools/codegen/endpoints/on3.yaml (vendored from sdv-py) — see How this library is built.