1summarize @blt.ultimate_soccer_dataset.matches| column_name | column_type | min | max | approx_unique | avg | std | q25 | q50 | q75 | count | null_percentage |
|---|---|---|---|---|---|---|---|---|---|---|---|
| match_id | VARCHAR | 00002f63-2221-58e1-9743-bad40a33db34 | ffff5643-95b2-56e3-864e-02221e31828f | 96600 | null | null | null | null | null | 110774 | 0.00 |
| season_id | VARCHAR | 00f3da8c-e625-5ebf-b33c-39b4ce20dca7 | ff1e2558-f55e-52a9-b1d3-9bd29deebc8d | 799 | null | null | null | null | null | 110774 | 0.00 |
| competition_name | VARCHAR | Africa Cup of Nations | World Cup - Women | 65 | null | null | null | null | null | 110774 | 0.00 |
| season_year | BIGINT | 2008 | 2026 | 21 | 2018.7026287757055 | 4.3261260396392816 | 2015 | 2019 | 2022 | 110774 | 0.00 |
| date | TIMESTAMP WITH TIME ZONE | 2008-06-07 00:00:00+00 | 2026-05-24 00:00:00+00 | 5379 | 2019-06-29 16:17:03.055952+00 | null | 2015-12-23 03:20:42.34347+00 | 2019-11-13 03:22:39.838253+00 | 2023-03-10 07:08:41.586117+00 | 110774 | 0.00 |
| home_team_id | VARCHAR | 00069c39-82f0-50a4-b177-f60ef01a6379 | fffe688f-44af-5c83-86f0-5853068d10f4 | 6032 | null | null | null | null | null | 110774 | 0.00 |
| home_team_name | VARCHAR | 1. FC Heidenheim | Žilina | 2878 | null | null | null | null | null | 110774 | 0.00 |
| away_team_id | VARCHAR | 00040548-0e0e-5bdb-87b7-136baa97499c | ffddbe3f-8df3-5d53-9ed9-ce3a42801093 | 5716 | null | null | null | null | null | 110774 | 0.00 |
| away_team_name | VARCHAR | 1. FC Heidenheim | Žilina | 2363 | null | null | null | null | null | 110774 | 0.00 |
| venue_id | VARCHAR | 000cf5ec-0073-58d5-a0b7-8bf77cb59bc0 | ffe46738-11ff-5afb-bfe0-e6e3d36c96d4 | 5001 | null | null | null | null | null | 110774 | 0.00 |
| venue_name | VARCHAR | 11 June Stadium | Štadión na Sihoti | 6593 | null | null | null | null | null | 110774 | 0.00 |
| referee_id | VARCHAR | 000735c2-9f4c-5626-88ab-e3643e476257 | fff9e6e9-429d-5307-9b83-68ac65a5d25d | 3823 | null | null | null | null | null | 110774 | 0.00 |
| referee_name | VARCHAR | A. Woolmer | Əliyar Ağayev | 4058 | null | null | null | null | null | 110774 | 0.00 |
| status | VARCHAR | Halftime | Walkover | 10 | null | null | null | null | null | 110774 | 0.00 |
| home_score | DOUBLE | 0.0 | 17.0 | 18 | 1.5769418937227155 | 1.3871937643226528 | 0.998321992261386 | 1.0 | 2.0 | 110774 | 4.05 |
| away_score | DOUBLE | 0.0 | 15.0 | 17 | 1.259860003010688 | 1.254670039328411 | 0.0 | 1.0 | 2.0 | 110774 | 4.05 |
| home_extratime_score | DOUBLE | 0.0 | 8.0 | 9 | 0.8908160363946546 | 1.1222328321574422 | 0.0 | 0.9682644628099174 | 1.0103386275097392 | 110774 | 96.83 |
| away_extratime_score | DOUBLE | 0.0 | 7.0 | 9 | 0.8339493886835371 | 1.0870823957245348 | 0.0 | 0.0 | 1.0 | 110774 | 96.83 |
| home_penalty_score | DOUBLE | 0.0 | 16.0 | 17 | 3.223404255319149 | 2.1367514178329277 | 1.4513217279174728 | 3.0 | 4.0 | 110774 | 97.79 |
| away_penalty_score | DOUBLE | 0.0 | 15.0 | 17 | 3.2319967266775778 | 2.134780864474423 | 1.435847840103159 | 3.0 | 4.210096153846154 | 110774 | 97.79 |
| home_halftime_score | DOUBLE | 0.0 | 10.0 | 11 | 0.6762282289780885 | 0.8477687124723597 | 0.0 | 0.0 | 1.0 | 110774 | 13.23 |
| away_halftime_score | DOUBLE | 0.0 | 9.0 | 10 | 0.5241692157229956 | 0.7509066647456836 | 0.0 | 0.0 | 1.0 | 110774 | 13.23 |
| home_manager_name | VARCHAR | A. Abaurre | Željko Sopić | 6772 | null | null | null | null | null | 110774 | 0.00 |
| away_manager_name | VARCHAR | A. Abaurre | Željko Sopić | 5354 | null | null | null | null | null | 110774 | 0.00 |
| home_formation | VARCHAR | 3-1-4-2 | None | 24 | null | null | null | null | null | 110774 | 0.00 |
| away_formation | VARCHAR | 3-1-4-2 | None | 24 | null | null | null | null | null | 110774 | 0.00 |