Sprocket Public Datasets

player stats s18

About:

Details per-game player stats from every league match they've played in during MLE Season 18.

Parquet Usage

Examples assume you have run the view alias first.

Alias a View

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

Select Everything

SELECT * FROM v_player_stats_s18;

CSV Usage

To link a CSV to your Google sheet

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

JSON Usage

Javascript

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

Python

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

C#

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

Ruby

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

R

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

curl

curl https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s18/player_stats_s18.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
member_id	BIGINT	YES	None	None	None
team_name	VARCHAR	YES	None	None	None
skill_group	VARCHAR	YES	None	None	None
gamemode	VARCHAR	YES	None	None	None
match_id	BIGINT	YES	None	None	None
round_id	BIGINT	YES	None	None	None
replays_submitted_at	TIMESTAMP	YES	None	None	None
home_won	BOOLEAN	YES	None	None	None
dpi	DECIMAL(4,2)	YES	None	None	None
gpi	DECIMAL(4,2)	YES	None	None	None
opi	DECIMAL(5,2)	YES	None	None	None
goals	DECIMAL(3,2)	YES	None	None	None
saves	DECIMAL(3,2)	YES	None	None	None
score	DECIMAL(6,2)	YES	None	None	None
shots	DECIMAL(4,2)	YES	None	None	None
assists	DECIMAL(3,2)	YES	None	None	None
goals_against	DECIMAL(4,2)	YES	None	None	None
shots_against	DECIMAL(4,2)	YES	None	None	None
demos_inflicted	DECIMAL(3,2)	YES	None	None	None
demos_taken	DECIMAL(3,2)	YES	None	None	None

Sample Data:

as_of	member_id	team_name	skill_group	gamemode	match_id	round_id	replays_submitted_at	home_won	dpi	gpi	opi	goals	saves	score	shots	assists	goals_against	shots_against	demos_inflicted	demos_taken
2025-04-14 22:03:32.954569+00:00	27	Sharks	Champion League	RL_STANDARD	53471	150638	2025-02-07 03:37:57.490265	True	85.40	46.52	7.63	0.00	1.00	253.00	1.00	0.00	2.00	12.00	1.00	0.00
2025-04-14 22:03:32.954569+00:00	27	Sharks	Champion League	RL_STANDARD	53471	150639	2025-02-07 03:37:57.490265	True	96.38	66.71	37.03	0.00	3.00	456.00	1.00	1.00	2.00	6.00	5.00	2.00
2025-04-14 22:03:32.954569+00:00	27	Sharks	Champion League	RL_STANDARD	53471	150640	2025-02-07 03:37:57.490265	False	8.09	51.68	95.26	3.00	2.00	562.00	5.00	0.00	1.00	5.00	2.00	1.00
2025-04-14 22:03:32.954569+00:00	27	Sharks	Champion League	RL_STANDARD	53471	150641	2025-02-07 03:37:57.490265	True	24.38	50.23	76.09	1.00	1.00	306.00	1.00	1.00	4.00	7.00	2.00	2.00
2025-04-14 22:03:32.954569+00:00	27	Sharks	Champion League	RL_STANDARD	53471	150642	2025-02-07 03:37:57.490265	True	99.03	69.29	39.56	0.00	4.00	522.00	2.00	1.00	3.00	12.00	0.00	3.00

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:32.954569+00	2025-04-14 22:03:32.954569+00	1	None	None	None	None	None	28033	0.0%
member_id	BIGINT	27	5792	875	3617.6163450219383	1555.5184137411236	2551	3797	4961	28033	0.0%
team_name	VARCHAR	Aviators	Wolves	33	None	None	None	None	None	28033	0.0%
skill_group	VARCHAR	Academy League	Premier League	5	None	None	None	None	None	28033	0.0%
gamemode	VARCHAR	RL_DOUBLES	RL_STANDARD	2	None	None	None	None	None	28033	0.0%
match_id	BIGINT	53404	54554	1135	53969.45903042842	329.50333646894256	53684	53966	54252	28033	0.0%
round_id	BIGINT	150574	166296	5693	159504.35508151108	5215.525523028445	154484	161002	164493	28033	0.0%
replays_submitted_at	TIMESTAMP	2025-02-07 00:43:18.204643	2025-04-14 21:58:57.800388	1113	None	None	None	None	None	28033	0.0%
home_won	BOOLEAN	false	true	2	None	None	None	None	None	28033	0.0%
dpi	DECIMAL(4,2)	0.00	99.97	1223	52.17547533264367	31.655075739269737	23	55	82	28033	0.0%
gpi	DECIMAL(4,2)	0.00	99.50	6803	50.32601648057646	19.115995029172566	39	50	62	28033	0.0%
opi	DECIMAL(5,2)	0.00	100.00	356	48.476321834980205	32.76091480799879	14	40	80	28033	0.0%
goals	DECIMAL(3,2)	0.00	9.00	10	1.1046266899725323	1.1456148076953965	0	1	2	28033	0.0%
saves	DECIMAL(3,2)	0.00	9.00	10	1.5158919844469019	1.2854445361701445	1	1	2	28033	0.0%
score	DECIMAL(6,2)	0.00	1546.00	1088	425.0889309028645	197.0574000395862	279	396	540	28033	0.0%
shots	DECIMAL(4,2)	0.00	14.00	15	3.1506795562372916	1.9494131240082404	2	3	4	28033	0.0%
assists	DECIMAL(3,2)	0.00	8.00	8	0.6635037277494381	0.8367118442606583	0	0	1	28033	0.0%
goals_against	DECIMAL(4,2)	0.00	12.00	13	2.681446866193415	1.7457682906870433	1	2	4	28033	0.0%
shots_against	DECIMAL(4,2)	0.00	22.00	23	7.8177505083294685	3.083051137202677	6	8	10	28033	0.0%
demos_inflicted	DECIMAL(3,2)	0.00	9.00	10	0.9301180751257446	1.0543536973317704	0	1	1	28033	0.0%
demos_taken	DECIMAL(3,2)	0.00	7.00	8	0.9301180751257446	0.9997520616785917	0	1	1	28033	0.0%

Downloads

Download as parquet

Download as csv

Download as json