Skip to main contentSchema: flow.beta Table: dim_nfl_athletes Type: View
beta__dim_nfl_athletes
Description
A beta-dimensional table containing NFL athlete metadata from the ESPN Athletes Endpoint. This table
serves as an experimental data source for NFL AllDay NFT analytics and athlete-related analysis. The
table is in beta mode and subject to change, providing athlete information that may be used for NFT
moment analysis, player performance tracking, and sports analytics. Due to its experimental nature,
this table should not be used for production purposes without accepting the risk of sudden changes
or deletion.
Key Use Cases
- NFL AllDay Analytics: Supporting NFT moment analysis and athlete-related NFT performance
tracking
- Player Research: Providing athlete metadata for sports analytics and player performance
analysis
- Experimental Features: Supporting beta features and experimental analytics in the sports NFT
space
- Data Exploration: Investigating potential use cases for athlete data in blockchain
applications
- Prototype Development: Supporting prototype development for sports-related blockchain features
Important Relationships
- beta__dim_nfl_teams: Links to team information for athlete-team relationship analysis
- beta__dim_nflad_playoff_rosters: May link to playoff roster information for seasonal
analysis
- nft__dim_moment_metadata: May overlap with NFL AllDay NFT moment data
- beta__ez_moment_player_ids: May provide additional player identification and linking
capabilities
Commonly-used Fields
- Athlete identification fields: For player identification and analysis
- Team association fields: For athlete-team relationship analysis
- Metadata fields: For athlete information and categorization
Columns
| Column Name | Data Type | Description |
|---|
| REF | TEXT | |
| ID | TEXT | |
| UID | TEXT | |
| GUID | TEXT | |
| TYPE | TEXT | |
| ALTERNATE_IDS | TEXT | |
| FIRST_NAME | TEXT | |
| LAST_NAME | TEXT | |
| FULL_NAME | TEXT | |
| DISPLAY_NAME | TEXT | |
| SHORT_NAME | TEXT | |
| WEIGHT | FLOAT | |
| DISPLAY_WEIGHT | TEXT | |
| HEIGHT | FLOAT | |
| DISPLAY_HEIGHT | TEXT | |
| AGE | FLOAT | |
| DATE_OF_BIRTH | TEXT | |
| LINKS | TEXT | |
| BIRTH_PLACE | TEXT | |
| COLLEGE | TEXT | |
| SLUG | TEXT | |
| HEADSHOT | TEXT | |
| JERSEY | TEXT | |
| POSITION | TEXT | |
| LINKED | BOOLEAN | |
| TEAM | TEXT | |
| STATISTICS | TEXT | |
| CONTRACTS | TEXT | |
| EXPERIENCE | TEXT | |
| COLLEGE_ATHLETE | TEXT | |
| ACTIVE | BOOLEAN | |
| DRAFT | TEXT | |
| STATUS | TEXT | |
| STATISTICSLOG | TEXT | |
| DEBUT_YEAR | FLOAT | |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | |
