teams
About:
This has the basic information about all the teams in MLE
Parquet Usage
Examples assume you have run the view alias first.- Alias a View
-
CREATE VIEW v_teams AS ( SELECT * FROM read_parquet( 'https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/teams.parquet' ) ); - Select Everything
-
SELECT * FROM v_teams;
CSV Usage
To link a CSV to your Google sheet
=importData("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/teams.csv")
JSON Usage
- Javascript
-
const teams = await fetch("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/teams.json").then(r => r.json()) - Python
-
import requests teams = requests.get("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/teams.json").json() - C#
-
using (var client = new HttpClient()) { var json = await client.GetStringAsync("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/teams.json"); var teams = JObject.Parse(json); } - Ruby
-
require 'net/http' require 'json' uri = URI.parse("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/teams.json") response = Net::HTTP.get_response(uri) teams = JSON.parse(response.body) - R
-
library(jsonlite) teams <- fromJSON("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/teams.json") - curl
-
curl https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/teams.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 |
| conference | VARCHAR | YES | None | None | None |
| division_name | VARCHAR | YES | None | None | None |
| name | VARCHAR | YES | None | None | None |
| callsign | VARCHAR | YES | None | None | None |
| logo_img_link | VARCHAR | YES | None | None | None |
| primary_color | VARCHAR | YES | None | None | None |
| secondary_color | VARCHAR | YES | None | None | None |
Sample Data:
| as_of | conference | division_name | name | callsign | logo_img_link | primary_color | secondary_color |
|---|---|---|---|---|---|---|---|
| 2024-06-09 17:11:44.983030-05:00 | Orange | Sun | Bears | BEA | https://cdn.mlesports.dev/public/img/team-logos/256/Bears_256.png | #62b6fe | #030029 |
| 2024-06-09 17:11:44.983030-05:00 | Orange | Volcanic | Dodgers | DOD | https://cdn.mlesports.dev/public/img/team-logos/256/Dodgers_256.png | #041e42 | #e7e9ea |
| 2024-06-09 17:11:44.983030-05:00 | Orange | Tropic | Hawks | HAW | https://cdn.mlesports.dev/public/img/team-logos/256/Hawks_256.png | #c30000 | #0199b5 |
| 2024-06-09 17:11:44.983030-05:00 | Blue | Storm | Lightning | LIT | https://cdn.mlesports.dev/public/img/team-logos/256/Lightning_256.png | #002868 | #ffffff |
| 2024-06-09 17:11:44.983030-05:00 | Orange | Volcanic | Elite | ELI | https://cdn.mlesports.dev/public/img/team-logos/256/Elite_256.png | #572a84 | #ea9300 |
Table Summary:
| column_name | column_type | min | max | approx_unique | avg | std | q25 | q50 | q75 | count | null_percentage |
|---|---|---|---|---|---|---|---|---|---|---|---|
| as_of | TIMESTAMP WITH TIME ZONE | 2024-06-09 17:11:44.98303-05 | 2024-06-09 17:11:44.98303-05 | 1 | None | None | None | None | None | 32 | 0.0% |
| conference | VARCHAR | Blue | Orange | 2 | None | None | None | None | None | 32 | 0.0% |
| division_name | VARCHAR | Arctic | Volcanic | 8 | None | None | None | None | None | 32 | 0.0% |
| name | VARCHAR | Aviators | Wolves | 32 | None | None | None | None | None | 32 | 0.0% |
| callsign | VARCHAR | AVI | WOL | 32 | None | None | None | None | None | 32 | 0.0% |
| logo_img_link | VARCHAR | https://cdn.mlesports.dev/public/img/team-logos/256/Aviators_256.png | https://cdn.mlesports.dev/public/img/team-logos/256/Wolves_256.png | 31 | None | None | None | None | None | 32 | 0.0% |
| primary_color | VARCHAR | #00254c | #ffa000 | 30 | None | None | None | None | None | 32 | 0.0% |
| secondary_color | VARCHAR | #0199b5 | #ffffff | 27 | None | None | None | None | None | 32 | 0.0% |