completeness · grid
spine 4 / 4 sports at 6 / 6 tables
Coverage Matrix
Every curated vertical carries the same six-table backbone, so a query written for one sport translates by swapping the schema name. Cells are real row counts, heat-shaded by magnitude.
Curated sports
4
asd_* verticals
Backbone tables
6
per schema
Spine coverage
100%
all sports 6/6
Total rows
621,307
across the backbone
Rows per backbone table
| Sport | competitors | events | competitions | results | event_results | seasons | total | spine |
|---|---|---|---|---|---|---|---|---|
Supercross / Motocross asd_smx | 1,074 | 59 | 611 | 16,794 | 4,115 | 6 | 22,659 | 6/6 |
World Surf League asd_wsl | 12,722 | 3,631 | 84,480 | 274,159 | 161,030 | 51 | 536,073 | 6/6 |
Major Arena Soccer League asd_masl | 47 | 2,077 | 8,620 | 17,240 | 4,150 | 13 | 32,147 | 6/6 |
High Limit Racing asd_hlr | 676 | 153 | 1,454 | 24,526 | 3,614 | 5 | 30,428 | 6/6 |
How to read it
Darker = more rows (log scale). Each column is one backbone table.
WSL (274,159 results) is two orders of magnitude larger than MASL (47 competitors — which are teams, not people). Always LIMIT exploratory WSL queries.
Pulled with AWS_PROFILE=asd against Redshift Serverless (us-west-1 / default-workgroup / dev).
Try it
See these exact counts come back from a query you can run.
Open the Query Playground