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 |