leagues
About:
This has the basic information about all the leagues in MLE
Parquet Usage
Examples assume you have run the view alias first.- Alias a View
-
CREATE VIEW v_leagues AS ( SELECT * FROM read_parquet( 'https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/leagues.parquet' ) ); - Select Everything
-
SELECT * FROM v_leagues;
CSV Usage
To link a CSV to your Google sheet
=importData("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/leagues.csv")
JSON Usage
- Javascript
-
const leagues = await fetch("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/leagues.json").then(r => r.json()) - Python
-
import requests leagues = requests.get("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/leagues.json").json() - C#
-
using (var client = new HttpClient()) { var json = await client.GetStringAsync("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/leagues.json"); var leagues = JObject.Parse(json); } - Ruby
-
require 'net/http' require 'json' uri = URI.parse("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/leagues.json") response = Net::HTTP.get_response(uri) leagues = JSON.parse(response.body) - R
-
library(jsonlite) leagues <- fromJSON("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/leagues.json") - curl
-
curl https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/leagues.json | jq
At a glance:
Table Schema:
| column_name | column_type | null | key | default | extra |
|---|---|---|---|---|---|
| as_of | TIMESTAMP WITH TIME ZONE | YES | None | None | None |
| skill_group_id | BIGINT | YES | None | None | None |
| league_code | VARCHAR | YES | None | None | None |
| league_name | VARCHAR | YES | None | None | None |
| color | VARCHAR | YES | None | None | None |
| league_photo_url | VARCHAR | YES | None | None | None |
| discord_emoji | VARCHAR | YES | None | None | None |
| max_salary | DOUBLE | YES | None | None | None |
Sample Data:
| as_of | skill_group_id | league_code | league_name | color | league_photo_url | discord_emoji | max_salary |
|---|---|---|---|---|---|---|---|
| 2025-04-14 22:03:29.697171+00:00 | 1 | PL | Premier League | #E2B22D | https://cdn.mlesports.dev/public/img/leagues/premier.png | <:pl:809925633186070599> | 94.5 |
| 2025-04-14 22:03:29.697171+00:00 | 2 | ML | Master League | #d10056 | https://cdn.mlesports.dev/public/img/leagues/master.png | <:ml:809925633618083870> | 82.0 |
| 2025-04-14 22:03:29.697171+00:00 | 3 | CL | Champion League | #7E55CE | https://cdn.mlesports.dev/public/img/leagues/champion.png | <:_cl:809925633642725427> | 69.5 |
| 2025-04-14 22:03:29.697171+00:00 | 4 | AL | Academy League | #0085fa | https://cdn.mlesports.dev/public/img/leagues/academy.png | <:al:809925633655570470> | 57.5 |
| 2025-04-14 22:03:29.697171+00:00 | 5 | FL | Foundation League | #4EBEEC | https://cdn.mlesports.dev/public/img/leagues/foundation.png | <:fl:809925633471545364> | 38.5 |
Table Summary:
| column_name | column_type | min | max | approx_unique | avg | std | q25 | q50 | q75 | count | null_percentage |
|---|---|---|---|---|---|---|---|---|---|---|---|
| as_of | TIMESTAMP WITH TIME ZONE | 2025-04-14 22:03:29.697171+00 | 2025-04-14 22:03:29.697171+00 | 1 | None | None | None | None | None | 5 | 0.0% |
| skill_group_id | BIGINT | 1 | 5 | 5 | 3.0 | 1.5811388300841898 | 2 | 3 | 4 | 5 | 0.0% |
| league_code | VARCHAR | AL | PL | 5 | None | None | None | None | None | 5 | 0.0% |
| league_name | VARCHAR | Academy League | Premier League | 5 | None | None | None | None | None | 5 | 0.0% |
| color | VARCHAR | #0085fa | #d10056 | 5 | None | None | None | None | None | 5 | 0.0% |
| league_photo_url | VARCHAR | https://cdn.mlesports.dev/public/img/leagues/academy.png | https://cdn.mlesports.dev/public/img/leagues/premier.png | 5 | None | None | None | None | None | 5 | 0.0% |
| discord_emoji | VARCHAR | <:_cl:809925633642725427> | <:pl:809925633186070599> | 5 | None | None | None | None | None | 5 | 0.0% |
| max_salary | DOUBLE | 38.5 | 94.5 | 5 | 68.4 | 21.680636522021214 | 52.75 | 69.5 | 85.125 | 5 | 0.0% |