completeness · retail
4 verticals · 6 / 6 spine each
Sport Profile Cards
One card per curated asd_* vertical, product-catalog style. Each shows the sport's shape, its six-table backbone with real row counts, how fresh it is, what tier it targets, and any honest gaps that keep it from climbing. Every number is the 2026-08-10 snapshot.
Supercross / Motocross
asd_smx
race
6/6 backbone
competitors are athletes
Backbone rows22,659 total
- competitors1,074
- events59
- competitions611
- results16,794
- event_results4,115
- seasons6
current
target: silver
points column
lag_days negative: a loaded event is dated ahead of the vendor's last completed event.
Depth tables (3)
athlete_detailsrace_lineage*_crosswalk
World Surf League
asd_wsl
judged
6/6 backbone
competitors are athletes
Backbone rows536,073 total
- competitors12,722
- events3,631
- competitions84,480
- results274,159
- event_results161,030
- seasons51
current
target: silver
points column
Two orders of magnitude larger than the others — always LIMIT exploratory queries here.
Depth tables (3)
wsl_tourswsl_wave_scoreswsl_event_money
Major Arena Soccer League
asd_masl
match
6/6 backbone
competitors are TEAMS; people live in
masl_playersBackbone rows32,147 total
- competitors47
- events2,077
- competitions8,620
- results17,240
- event_results4,150
- seasons13
current
target: silver
points column
competitors = 47 TEAMS, not people. Real people live in masl_players.
Depth tables (5)
masl_playersmasl_player_game_statsmasl_goalie_game_statsmasl_game_detailsmasl_team_seasons
High Limit Racing
asd_hlr
race
6/6 backbone
competitors are athletes
Backbone rows30,428 total
- competitors676
- events153
- competitions1,454
- results24,526
- event_results3,614
- seasons5
vendor unknown
target: silver
no points column — F4
vendor cursor could not be read (NO_KEPT_SESSIONS=1). A MONITORING gap, not stale data.
Depth tables (3)
event_seriesresult_timingrace_lineage
Known gaps (2)
- F4results missing score/points (and region) vs other verticals — cross-sport queries explode.
- F8ops.freshness coverage_status = vendor_unknown; currency not answerable.
Pulled with AWS_PROFILE=asd against Redshift Serverless (us-west-1 / default-workgroup / dev).
View in playground