Sprocket Public Datasets

Total Scrim Stats

About:

No description has been provided for this set

Parquet Usage

Examples assume you have run the view alias first.

Alias a View

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

Select Everything

SELECT * FROM v_Total_Scrim_Stats;

CSV Usage

To link a CSV to your Google sheet

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

JSON Usage

Javascript

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

Python

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

C#

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

Ruby

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

R

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

curl

curl https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/Total_Scrim_Stats.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
scrim_date	TIMESTAMP	YES	None	None	None
salary	DOUBLE	YES	None	None	None
sprocket_player_id	BIGINT	YES	None	None	None
gamemode	VARCHAR	YES	None	None	None
skill_group	VARCHAR	YES	None	None	None
did_win	BOOLEAN	YES	None	None	None
dpi	DECIMAL(5,2)	YES	None	None	None
sprocket_rating	DECIMAL(5,2)	YES	None	None	None
opi	DECIMAL(5,2)	YES	None	None	None
score	DECIMAL(6,2)	YES	None	None	None
goals	DECIMAL(4,2)	YES	None	None	None
assists	DECIMAL(3,2)	YES	None	None	None
saves	DECIMAL(4,2)	YES	None	None	None
shots	DECIMAL(4,2)	YES	None	None	None
goals_against	DECIMAL(4,2)	YES	None	None	None
shots_against	DECIMAL(5,2)	YES	None	None	None
demos	DECIMAL(4,2)	YES	None	None	None

Sample Data:

as_of	name	scrim_date	salary	sprocket_player_id	gamemode	skill_group	did_win	dpi	sprocket_rating	opi	score	goals	assists	saves	shots	goals_against	shots_against	demos
2025-01-04 05:00:53.954762+00:00	ZackV	2023-04-15 04:33:38.404563	17.5	2267	RL_DOUBLES	Master League	True	65.42	77.46	89.50	855.00	3.00	1.00	4.00	7.00	2.00	10.00	3.00
2025-01-04 05:00:53.954762+00:00	ZackV	2023-04-15 04:33:38.404563	17.5	2267	RL_DOUBLES	Master League	True	81.78	56.04	30.31	630.00	2.00	0.00	3.00	4.00	2.00	9.00	1.00
2025-01-04 05:00:53.954762+00:00	Slvr.	2023-04-15 04:33:38.404563	18.5	4296	RL_DOUBLES	Master League	True	37.42	57.63	77.85	531.00	1.00	2.00	2.00	2.00	2.00	10.00	0.00
2025-01-04 05:00:53.954762+00:00	lildude1313	2023-04-15 04:33:38.404563	16.0	3970	RL_DOUBLES	Master League	False	81.78	62.94	44.11	574.00	1.00	1.00	3.00	4.00	3.00	10.00	0.00
2025-01-04 05:00:53.954762+00:00	Azivar	2023-04-15 04:43:39.655872	11.0	1562	RL_DOUBLES	Foundation League	False	2.41	6.43	10.46	339.00	1.00	0.00	2.00	1.00	8.00	12.00	0.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-01-04 05:00:53.954762+00	2025-01-04 05:00:53.954762+00	1	None	None	None	None	None	492369	0.0%
name	VARCHAR	.bzy	zugz	2348	None	None	None	None	None	492369	0.0%
scrim_date	TIMESTAMP	2022-09-13 23:38:35.21885	2025-01-04 04:42:55.917705	37465	None	None	None	None	None	492369	0.0%
salary	DOUBLE	5.0	20.0	31	13.329379997522183	3.5971000784421103	11.0	13.5	16.0	492369	0.0%
sprocket_player_id	BIGINT	3	5590	2336	3183.672603271124	1398.4159327270227	2382	3352	4229	492369	0.0%
gamemode	VARCHAR	RL_DOUBLES	RL_STANDARD	2	None	None	None	None	None	492369	0.0%
skill_group	VARCHAR	Academy League	Premier League	5	None	None	None	None	None	492369	0.0%
did_win	BOOLEAN	false	true	2	None	None	None	None	None	492369	0.0%
dpi	DECIMAL(5,2)	0.00	100.00	1705	50.557817104651186	29.759910904557838	24	52	77	492369	0.0%
sprocket_rating	DECIMAL(5,2)	0.00	100.00	9533	49.58195304740956	18.499741469861064	39	50	60	492369	0.0%
opi	DECIMAL(5,2)	0.00	100.00	466	48.605965261825986	32.594899896656436	16	42	80	492369	0.0%
score	DECIMAL(6,2)	0.00	2508.00	1496	499.4280630990172	208.04160282403015	347	476	630	492369	0.0%
goals	DECIMAL(4,2)	0.00	14.00	15	1.491322564986829	1.3015685923758005	0	1	2	492369	0.0%
assists	DECIMAL(3,2)	0.00	8.00	9	0.7457455688721264	0.8839560276411716	0	1	1	492369	0.0%
saves	DECIMAL(4,2)	0.00	20.00	16	1.612686826343657	1.3274597658076703	1	1	2	492369	0.0%
shots	DECIMAL(4,2)	0.00	97.00	29	3.7209816215074465	2.0825028455758936	2	4	5	492369	0.0%
goals_against	DECIMAL(4,2)	0.00	17.00	18	3.115571857692097	1.874740148703885	2	3	4	492369	0.0%
shots_against	DECIMAL(5,2)	0.00	155.00	34	7.853597606673044	3.1138030908007797	6	8	10	492369	0.0%
demos	DECIMAL(4,2)	0.00	18.00	16	0.8181201497251045	0.9949751647789894	0	1	1	492369	0.0%

Downloads

Download as parquet

Download as csv

Download as json