Sprocket Public Datasets

players

About:

This table contains a basic informational table about the current players in Minor League Esports

Parquet Usage

Examples assume you have run the view alias first.

Alias a View

CREATE VIEW v_players AS (
    SELECT * FROM read_parquet(
        'https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/players.parquet'
    )
);

Select Everything

SELECT * FROM v_players;

Select players on a given team

SELECT * FROM v_players WHERE franchise = 'team_name';

CSV Usage

To link a CSV to your Google sheet

=importData("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/players.csv")

JSON Usage

Javascript

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

Python

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

C#

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

Ruby

require 'net/http'
require 'json'
uri = URI.parse("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/players.json")
response = Net::HTTP.get_response(uri)
players = JSON.parse(response.body)

R

library(jsonlite)
players <- fromJSON("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/players.json")

curl

curl https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/players.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
name	VARCHAR	YES	None	None	None
salary	DOUBLE	YES	None	None	None
sprocket_player_id	BIGINT	YES	None	None	None
member_id	BIGINT	YES	None	None	None
skill_group	VARCHAR	YES	None	None	None
franchise	VARCHAR	YES	None	None	None
Franchise Staff Position	VARCHAR	YES	None	None	None
slot	VARCHAR	YES	None	None	None
current_scrim_points	BIGINT	YES	None	None	None
Eligible Until	VARCHAR	YES	None	None	None

Sample Data:

as_of	name	salary	sprocket_player_id	member_id	skill_group	franchise	Franchise Staff Position	slot	Eligible Until
2025-04-14 22:03:23.236340+00:00	-j	13.5	1	2	Champion League	FP	NA	NONE	Not Eligible
2025-04-14 22:03:23.236340+00:00	!Chino-096	12.5	2	3	Academy League	FP	NA	NONE	Not Eligible
2025-04-14 22:03:23.236340+00:00	1AMRamen	16.5	3	4	Master League	Pend	NA	NONE	Not Eligible
2025-04-14 22:03:23.236340+00:00	BuffaloDave	10.5	4	5	Academy League	FP	NA	NONE	Not Eligible
2025-04-14 22:03:23.236340+00:00	AcePocket	17.0	5	6	Premier League	FP	NA	NONE	Not Eligible

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:23.23634+00	2025-04-14 22:03:23.23634+00	1	None	None	None	None	None	5628	0.0%
name	VARCHAR	!Chino-096	Érid	5602	None	None	None	None	None	5628	0.0%
salary	DOUBLE	4.0	20.0	33	13.492093105899077	3.3656762263319786	11.490267639902678	13.5	16.0	5628	0.0%
sprocket_player_id	BIGINT	1	5752	5736	2838.089552238806	1654.7512215653544	1410	2816	4261	5628	0.0%
member_id	BIGINT	2	5811	5798	2881.9182658137884	1672.1160013220006	1433	2874	4318	5628	0.0%
skill_group	VARCHAR	Academy League	Premier League	5	None	None	None	None	None	5628	0.0%
franchise	VARCHAR	Aviators	Wolves	37	None	None	None	None	None	5628	0.0%
Franchise Staff Position	VARCHAR	Assistant General Manager	NA	5	None	None	None	None	None	5628	0.0%
slot	VARCHAR		PLAYERH	11	None	None	None	None	None	5628	0.0%
current_scrim_points	BIGINT	0	210	28	2.919331911869225	10.59526818723713	0	0	0	5628	0.0%
Eligible Until	VARCHAR	01 May 2025	Not Eligible	18	None	None	None	None	None	5628	0.0%

Downloads

Download as parquet

Download as csv

Download as json