Sprocket Public Datasets

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/public/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/public/data/teams.csv")

JSON Usage

Javascript

const teams = await fetch("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/teams.json").then(r => r.json())

Python

import requests
teams = requests.get("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/teams.json").json()

C#

using (var client = new HttpClient())
{
    var json = await client.GetStringAsync("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/teams.json");
    var teams = JObject.Parse(json);
}

Ruby

require 'net/http'
require 'json'
uri = URI.parse("https://f004.backblazeb2.com/file/sprocket-artifacts/public/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/public/data/teams.json")

curl

curl https://f004.backblazeb2.com/file/sprocket-artifacts/public/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
Super Division	VARCHAR	YES	None	None	None
Division	VARCHAR	YES	None	None	None
Franchise	VARCHAR	YES	None	None	None
Code	VARCHAR	YES	None	None	None
Primary Color	VARCHAR	YES	None	None	None
Secondary Color	VARCHAR	YES	None	None	None
Photo URL	VARCHAR	YES	None	None	None

Sample Data:

as_of	Conference	Super Division	Division	Franchise	Code	Primary Color	Secondary Color	Photo URL
2025-04-14 22:03:28.125586+00:00	Blue	North	Arctic	Foxes	FOX	#ea6409	#ffffff	https://cdn.mlesports.dev/public/img/team-logos/256/Foxes_256.png
2025-04-14 22:03:28.125586+00:00	Blue	North	Arctic	Puffins	PUF	#ec2c0d	#9bf9ff	https://cdn.mlesports.dev/public/img/team-logos/256/Puffins_256.png
2025-04-14 22:03:28.125586+00:00	Blue	North	Arctic	Sabres	SAB	#f36a22	#111111	https://cdn.mlesports.dev/public/img/team-logos/256/Sabres_256.png
2025-04-14 22:03:28.125586+00:00	Blue	North	Arctic	Tyrants	TYR	#98012e	#c4a87d	https://cdn.mlesports.dev/public/img/team-logos/256/Tyrants_256.png
2025-04-14 22:03:28.125586+00:00	Blue	North	Mystic	Comets	COM	#2db4e3	#f6518d	https://cdn.mlesports.dev/public/img/team-logos/256/Comets_256.png

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:28.125586+00	2025-04-14 22:03:28.125586+00	1	None	None	None	None	None	32	0.0%
Conference	VARCHAR	Blue	Orange	2	None	None	None	None	None	32	0.0%
Super Division	VARCHAR	East	West	4	None	None	None	None	None	32	0.0%
Division	VARCHAR	Arctic	Volcanic	8	None	None	None	None	None	32	0.0%
Franchise	VARCHAR	Aviators	Wolves	32	None	None	None	None	None	32	0.0%
Code	VARCHAR	AVI	WOL	32	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%
Photo URL	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%

Downloads

Download as parquet

Download as csv

Download as json