CFB — On3 Recruit Database (api.on3.com) — Other
on3_coaches_history
GET /rdb/v1/coaches/{personKey}/history
Endpoint URL: GET https://api.on3.com/public/rdb/v1/coaches/{person_key}/history
Valid URL: https://api.on3.com/public/rdb/v1/coaches/89617/history
| API Parameter | Python | Pattern | Required | Nullable | Description |
|---|---|---|---|---|---|
person_key | person_key | Y | person_key path parameter. | ||
page | page | Y | page query parameter. | ||
pageSize | page_size | Y | pageSize query parameter. |
Returns
return_parsed=True (default) — the output of parse_on3_rdb; pass return_as_pandas=True for a pandas.DataFrame.
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.
return_parsed=False — the raw JSON Dict payload, unparsed.
Example
on3_coaches_history(person_key=89617)
Last validated n/a.
on3_coaches_profile
GET /rdb/v1/coaches/{personKey}/profile
Endpoint URL: GET https://api.on3.com/public/rdb/v1/coaches/{person_key}/profile
Valid URL: https://api.on3.com/public/rdb/v1/coaches/89617/profile
| API Parameter | Python | Pattern | Required | Nullable | Description |
|---|---|---|---|---|---|
person_key | person_key | Y | person_key path parameter. |
Returns
return_parsed=True (default) — the output of parse_on3_rdb; pass return_as_pandas=True for a pandas.DataFrame.
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.
return_parsed=False — the raw JSON Dict payload, unparsed.
Example
on3_coaches_profile(person_key=89617)
Last validated n/a.
on3_draft_organization_rank
GET /rdb/v1/draft-organization-rank
Endpoint URL: GET https://api.on3.com/public/rdb/v1/draft-organization-rank
Valid URL: https://api.on3.com/public/rdb/v1/draft-organization-rank
| API Parameter | Python | Pattern | Required | Nullable | Description |
|---|---|---|---|---|---|
sportKey | sport_key | Y | sportKey query parameter. | ||
year | year | Y | year query parameter. | ||
page | page | Y | page query parameter. | ||
pageSize | page_size | Y | pageSize query parameter. |
Returns
return_parsed=True (default) — the output of parse_on3_rdb; pass return_as_pandas=True for a pandas.DataFrame.
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.
return_parsed=False — the raw JSON Dict payload, unparsed.
Example
on3_draft_organization_rank()
Last validated n/a.
on3_draft_pick_organization_rank
GET /rdb/v1/draft-pick-organization-rank
Endpoint URL: GET https://api.on3.com/public/rdb/v1/draft-pick-organization-rank
Valid URL: https://api.on3.com/public/rdb/v1/draft-pick-organization-rank
| API Parameter | Python | Pattern | Required | Nullable | Description |
|---|---|---|---|---|---|
sportKey | sport_key | Y | sportKey query parameter. | ||
year | year | Y | year query parameter. | ||
page | page | Y | page query parameter. | ||
pageSize | page_size | Y | pageSize query parameter. |
Returns
return_parsed=True (default) — the output of parse_on3_rdb; pass return_as_pandas=True for a pandas.DataFrame.
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.
return_parsed=False — the raw JSON Dict payload, unparsed.
Example
on3_draft_pick_organization_rank()
Last validated n/a.
on3_drafts
GET /rdb/v1/drafts
Endpoint URL: GET https://api.on3.com/public/rdb/v1/drafts
Valid URL: https://api.on3.com/public/rdb/v1/drafts
| API Parameter | Python | Pattern | Required | Nullable | Description |
|---|---|---|---|---|---|
sportKey | sport_key | Y | sportKey query parameter. | ||
round | round | Y | round query parameter. | ||
year | year | Y | year query parameter. |
Returns
return_parsed=True (default) — the output of parse_on3_rdb; pass return_as_pandas=True for a pandas.DataFrame.
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.
return_parsed=False — the raw JSON Dict payload, unparsed.
Example
on3_drafts()
Last validated n/a.
on3_drafts_by_stars
GET /rdb/v1/drafts-by-stars
Endpoint URL: GET https://api.on3.com/public/rdb/v1/drafts-by-stars
Valid URL: https://api.on3.com/public/rdb/v1/drafts-by-stars
| API Parameter | Python | Pattern | Required | Nullable | Description |
|---|---|---|---|---|---|
sportKey | sport_key | Y | sportKey query parameter. | ||
year | year | Y | year query parameter. | ||
yearSpan | year_span | Y | yearSpan query parameter. |
Returns
return_parsed=True (default) — a tidy polars.DataFrame with the columns below; pass return_as_pandas=True for a pandas.DataFrame.
| col_name | type | description |
|---|---|---|
blue_chip_percent | numeric | Percent of the drafted group who were blue-chip (four- or five-star) recruits. |
population_percent | numeric | Percent of the overall recruit population holding this star rating. |
talent_ratio | numeric | Ratio of the star tier's draft share to its population share (On3's talent ratio). |
five_stars | integer | Number of drafted players who were five-star recruits. |
four_stars | integer | Number of drafted players who were four-star recruits. |
three_stars | integer | Number of drafted players who were three-star recruits. |
zero_stars | integer | Number of drafted players who were unrated (zero-star) recruits. |
total | integer | Total drafted players counted in the row. |
state_key | integer | On3 numeric key of the state. |
state_name | character | Name of the state the row aggregates (e.g. Alabama). |
state_abbreviation | character | Two-letter state abbreviation. |
state_country_key | integer | On3 numeric key of the state's country. |
return_parsed=False — the raw JSON Dict payload, unparsed.
Example
on3_drafts_by_stars()
Last validated n/a.
on3_drafts_by_stars_summary
GET /rdb/v1/drafts-by-stars-summary
Endpoint URL: GET https://api.on3.com/public/rdb/v1/drafts-by-stars-summary
Valid URL: https://api.on3.com/public/rdb/v1/drafts-by-stars-summary
| API Parameter | Python | Pattern | Required | Nullable | Description |
|---|---|---|---|---|---|
sportKey | sport_key | Y | sportKey query parameter. | ||
year | year | Y | year query parameter. |
Returns
return_parsed=True (default) — the output of parse_on3_rdb; pass return_as_pandas=True for a pandas.DataFrame.
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.
return_parsed=False — the raw JSON Dict payload, unparsed.
Example
on3_drafts_by_stars_summary()
Last validated n/a.
on3_drafts_players
GET /rdb/v1/drafts/{orgKey}/players
Endpoint URL: GET https://api.on3.com/public/rdb/v1/drafts/{org_key}/players
Valid URL: https://api.on3.com/public/rdb/v1/drafts/1867/players
| API Parameter | Python | Pattern | Required | Nullable | Description |
|---|---|---|---|---|---|
org_key | org_key | Y | org_key path parameter. | ||
year | year | Y | year query parameter. |
Returns
return_parsed=True (default) — the output of parse_on3_rdb; pass return_as_pandas=True for a pandas.DataFrame.
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.
return_parsed=False — the raw JSON Dict payload, unparsed.
Example
on3_drafts_players(org_key=1867)
Last validated n/a.
on3_filters_conferences
GET /rdb/v1/filters/conferences
Endpoint URL: GET https://api.on3.com/public/rdb/v1/filters/conferences
Valid URL: https://api.on3.com/public/rdb/v1/filters/conferences
| API Parameter | Python | Pattern | Required | Nullable | Description |
|---|---|---|---|---|---|
year | year | Y | year query parameter. | ||
sportKey | sport_key | Y | sportKey query parameter. |
Returns
return_parsed=True (default) — the output of parse_on3_rdb; pass return_as_pandas=True for a pandas.DataFrame.
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.
return_parsed=False — the raw JSON Dict payload, unparsed.
Example
on3_filters_conferences()
Last validated n/a.
on3_filters_draft_rounds
GET /rdb/v1/filters/draft-rounds
Endpoint URL: GET https://api.on3.com/public/rdb/v1/filters/draft-rounds
Valid URL: https://api.on3.com/public/rdb/v1/filters/draft-rounds
| API Parameter | Python | Pattern | Required | Nullable | Description |
|---|---|---|---|---|---|
year | year | Y | year query parameter. | ||
sportKey | sport_key | Y | sportKey query parameter. |
Returns
return_parsed=True (default) — a tidy polars.DataFrame with the columns below; pass return_as_pandas=True for a pandas.DataFrame.
| col_name | type | description |
|---|---|---|
round | integer | Draft round number. |
return_parsed=False — the raw JSON Dict payload, unparsed.
Example
on3_filters_draft_rounds()
Last validated n/a.
on3_filters_positions
GET /rdb/v1/filters/positions
Endpoint URL: GET https://api.on3.com/public/rdb/v1/filters/positions
Valid URL: https://api.on3.com/public/rdb/v1/filters/positions
| API Parameter | Python | Pattern | Required | Nullable | Description |
|---|---|---|---|---|---|
sportKey | sport_key | Y | sportKey query parameter. | ||
positionType | position_type | Y | positionType query parameter. |
Returns
return_parsed=True (default) — the output of parse_on3_rdb; pass return_as_pandas=True for a pandas.DataFrame.
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.
return_parsed=False — the raw JSON Dict payload, unparsed.
Example
on3_filters_positions()
Last validated n/a.
on3_filters_sports
GET /rdb/v1/filters/sports
Endpoint URL: GET https://api.on3.com/public/rdb/v1/filters/sports
Valid URL: https://api.on3.com/public/rdb/v1/filters/sports
| API Parameter | Python | Pattern | Required | Nullable | Description |
|---|
Returns
return_parsed=True (default) — the output of parse_on3_rdb; pass return_as_pandas=True for a pandas.DataFrame.
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.
return_parsed=False — the raw JSON Dict payload, unparsed.
Example
on3_filters_sports()
Last validated n/a.
on3_filters_status
GET /rdb/v1/filters/status
Endpoint URL: GET https://api.on3.com/public/rdb/v1/filters/status
Valid URL: https://api.on3.com/public/rdb/v1/filters/status
| API Parameter | Python | Pattern | Required | Nullable | Description |
|---|
Returns
return_parsed=True (default) — a tidy polars.DataFrame with the columns below; pass return_as_pandas=True for a pandas.DataFrame.
| col_name | type | description |
|---|---|---|
value | character | Filter value as On3 lists it. |
return_parsed=False — the raw JSON Dict payload, unparsed.
Example
on3_filters_status()
Last validated n/a.
on3_filters_teams
GET /rdb/v1/filters/teams
Endpoint URL: GET https://api.on3.com/public/rdb/v1/filters/teams
Valid URL: https://api.on3.com/public/rdb/v1/filters/teams
| API Parameter | Python | Pattern | Required | Nullable | Description |
|---|---|---|---|---|---|
groupBy | group_by | Y | groupBy query parameter. | ||
year | year | Y | year query parameter. | ||
sportKey | sport_key | Y | sportKey query parameter. |
Returns
return_parsed=True (default) — the output of parse_on3_rdb; pass return_as_pandas=True for a pandas.DataFrame.
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.
return_parsed=False — the raw JSON Dict payload, unparsed.
Example
on3_filters_teams()
Last validated n/a.
on3_filters_years
GET /rdb/v1/filters/years
Endpoint URL: GET https://api.on3.com/public/rdb/v1/filters/years
Valid URL: https://api.on3.com/public/rdb/v1/filters/years
| API Parameter | Python | Pattern | Required | Nullable | Description |
|---|
Returns
return_parsed=True (default) — the output of parse_on3_rdb; pass return_as_pandas=True for a pandas.DataFrame.
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.
return_parsed=False — the raw JSON Dict payload, unparsed.
Example
on3_filters_years()
Last validated n/a.
on3_person_connections_connection_key
GET /rdb/v1/person-connections/{connectionKey}
Endpoint URL: GET https://api.on3.com/public/rdb/v1/person-connections/{connection_key}
Valid URL: https://api.on3.com/public/rdb/v1/person-connections/89617
| API Parameter | Python | Pattern | Required | Nullable | Description |
|---|---|---|---|---|---|
connection_key | connection_key | Y | connection_key path parameter. |
Returns
return_parsed=True (default) — the output of parse_on3_rdb; pass return_as_pandas=True for a pandas.DataFrame.
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.
return_parsed=False — the raw JSON Dict payload, unparsed.
Example
on3_person_connections_connection_key(connection_key=89617)
Last validated n/a.
on3_person_primary_recruitment_evaluation
GET /rdb/v1/person/{personKey}/primary-recruitment-evaluation
Endpoint URL: GET https://api.on3.com/public/rdb/v1/person/{person_key}/primary-recruitment-evaluation
Valid URL: https://api.on3.com/public/rdb/v1/person/89617/primary-recruitment-evaluation
| API Parameter | Python | Pattern | Required | Nullable | Description |
|---|---|---|---|---|---|
person_key | person_key | Y | person_key path parameter. |
Returns
return_parsed=True (default) — the output of parse_on3_rdb; pass return_as_pandas=True for a pandas.DataFrame.
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.
return_parsed=False — the raw JSON Dict payload, unparsed.
Example
on3_person_primary_recruitment_evaluation(person_key=89617)
Last validated n/a.
on3_person_recruitment_evaluations
GET /rdb/v1/person/{personKey}/recruitment-evaluations
Endpoint URL: GET https://api.on3.com/public/rdb/v1/person/{person_key}/recruitment-evaluations
Valid URL: https://api.on3.com/public/rdb/v1/person/89617/recruitment-evaluations
| API Parameter | Python | Pattern | Required | Nullable | Description |
|---|---|---|---|---|---|
person_key | person_key | Y | person_key path parameter. |
Returns
return_parsed=True (default) — the output of parse_on3_rdb; pass return_as_pandas=True for a pandas.DataFrame.
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.
return_parsed=False — the raw JSON Dict payload, unparsed.
Example
on3_person_recruitment_evaluations(person_key=89617)
Last validated n/a.
on3_person_sport_profile_recruit
GET /rdb/v1/person-sport/{psKey}/profile-recruit
Endpoint URL: GET https://api.on3.com/public/rdb/v1/person-sport/{ps_key}/profile-recruit
Valid URL: https://api.on3.com/public/rdb/v1/person-sport/89617/profile-recruit
| API Parameter | Python | Pattern | Required | Nullable | Description |
|---|---|---|---|---|---|
ps_key | ps_key | Y | ps_key path parameter. |
Returns
return_parsed=True (default) — the output of parse_on3_rdb; pass return_as_pandas=True for a pandas.DataFrame.
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.
return_parsed=False — the raw JSON Dict payload, unparsed.
Example
on3_person_sport_profile_recruit(ps_key=89617)
Last validated n/a.
on3_person_sport_rankings
GET /rdb/v1/person-sport-rankings
Endpoint URL: GET https://api.on3.com/public/rdb/v1/person-sport-rankings
Valid URL: https://api.on3.com/public/rdb/v1/person-sport-rankings
| API Parameter | Python | Pattern | Required | Nullable | Description |
|---|---|---|---|---|---|
sportKey | sport_key | Y | sportKey query parameter. | ||
year | year | Y | year query parameter. | ||
page | page | Y | page query parameter. | ||
pageSize | page_size | Y | pageSize query parameter. |
Returns
return_parsed=True (default) — the output of parse_on3_rdb; pass return_as_pandas=True for a pandas.DataFrame.
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.
return_parsed=False — the raw JSON Dict payload, unparsed.
Example
on3_person_sport_rankings()
Last validated n/a.
on3_predictions_user_key
Expert prediction accuracy + feed (see PredictionAccuracies)
Endpoint URL: GET https://api.on3.com/public/rdb/v1/predictions/{user_key}
Valid URL: https://api.on3.com/public/rdb/v1/predictions/89617
| API Parameter | Python | Pattern | Required | Nullable | Description |
|---|---|---|---|---|---|
user_key | user_key | Y | user_key path parameter. | ||
page | page | Y | page query parameter. | ||
pageSize | page_size | Y | pageSize query parameter. |
Returns
return_parsed=True (default) — the output of parse_on3_rdb; pass return_as_pandas=True for a pandas.DataFrame.
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.
return_parsed=False — the raw JSON Dict payload, unparsed.
Example
on3_predictions_user_key(user_key=89617)
Last validated n/a.
on3_quotes
GET /rdb/v1/quotes
Endpoint URL: GET https://api.on3.com/public/rdb/v1/quotes
Valid URL: https://api.on3.com/public/rdb/v1/quotes
| API Parameter | Python | Pattern | Required | Nullable | Description |
|---|---|---|---|---|---|
page | page | Y | page query parameter. | ||
pageSize | page_size | Y | pageSize query parameter. |
Returns
return_parsed=True (default) — a tidy polars.DataFrame with the columns below; pass return_as_pandas=True for a pandas.DataFrame.
| col_name | type | description |
|---|---|---|
key | integer | On3 RDB key for the quote record. |
body | character | Full text of the quote. |
category | character | Category label On3 attaches to the row. |
person_key | integer | On3 person key of the person quoted or quoted about. |
date_added | character | Date the quote was added to the On3 database. |
date_updated | character | Date the quote was last updated. |
person_key_2 | integer | Person key repeated from the nested person object (json_normalize de-duplication suffix). |
person_known_as_name | character | Preferred name of the person, when it differs from the given name. |
person_first_name | character | First name of the person. |
person_last_name | character | Last name of the person. |
person_twitter_handle | character | Twitter/X handle of the person, when listed. |
person_instagram_profile | character | Instagram profile of the person, when listed. |
person_tik_tok_handle | character | TikTok handle of the person, when listed. |
person_espn_profile | character | ESPN profile link of the person, when listed. |
person_class_year | integer | High-school graduating class year of the person. |
person_two_four_seven_profile | character | 247Sports profile link of the person, when listed. |
person_rivals_profile | character | Rivals profile link of the person, when listed. |
return_parsed=False — the raw JSON Dict payload, unparsed.
Example
on3_quotes()
Last validated n/a.
on3_quotes_key
GET /rdb/v1/quotes/{key}
Endpoint URL: GET https://api.on3.com/public/rdb/v1/quotes/{key}
Valid URL: https://api.on3.com/public/rdb/v1/quotes/1
| API Parameter | Python | Pattern | Required | Nullable | Description |
|---|---|---|---|---|---|
key | key | Y | key path parameter. |
Returns
return_parsed=True (default) — the output of parse_on3_rdb; pass return_as_pandas=True for a pandas.DataFrame.
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.
return_parsed=False — the raw JSON Dict payload, unparsed.
Example
on3_quotes_key(key=1)
Last validated n/a.
on3_videos_video_key
GET /rdb/v1/videos/{videoKey}
Endpoint URL: GET https://api.on3.com/public/rdb/v1/videos/{video_key}
Valid URL: https://api.on3.com/public/rdb/v1/videos/1
| API Parameter | Python | Pattern | Required | Nullable | Description |
|---|---|---|---|---|---|
video_key | video_key | Y | video_key path parameter. |
Returns
return_parsed=True (default) — the output of parse_on3_rdb; pass return_as_pandas=True for a pandas.DataFrame.
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.
return_parsed=False — the raw JSON Dict payload, unparsed.
Example
on3_videos_video_key(video_key=1)
Last validated n/a.