Sprocket Public Datasets

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_scrim_stats AS (
    SELECT * FROM read_parquet(
        'https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/scrim_stats.parquet'
    )
);

Select Everything

SELECT * FROM v_scrim_stats;

CSV Usage

To link a CSV to your Google sheet

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

JSON Usage

Javascript

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

Python

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

C#

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

Ruby

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

R

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

curl

curl https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/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
weekof	TIMESTAMP	YES	None	None	None
played_rounds	BIGINT	YES	None	None	None
played_matches	BIGINT	YES	None	None	None
unique_players	BIGINT	YES	None	None	None
2s_rounds	BIGINT	YES	None	None	None
3s_rounds	BIGINT	YES	None	None	None
2s_matches	BIGINT	YES	None	None	None
3s_matches	BIGINT	YES	None	None	None

Sample Data:

as_of	weekof	played_rounds	played_matches	unique_players	2s_rounds	3s_rounds	2s_matches	3s_matches
2025-04-14 22:03:20.949396+00:00	2022-09-12 00:00:00	660	220	344	573	87	191	29
2025-04-14 22:03:20.949396+00:00	2022-09-19 00:00:00	774	258	371	699	75	233	25
2025-04-14 22:03:20.949396+00:00	2022-09-26 00:00:00	1011	337	400	888	123	296	41
2025-04-14 22:03:20.949396+00:00	2022-10-03 00:00:00	2334	778	703	2016	318	672	106
2025-04-14 22:03:20.949396+00:00	2022-10-10 00:00:00	417	139	259	363	54	121	18

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:20.949396+00	2025-04-14 22:03:20.949396+00	1	None	None	None	None	None	136	0.0%
weekof	TIMESTAMP	2022-09-12 00:00:00	2025-04-14 00:00:00	137	None	None	None	None	None	136	0.0%
played_rounds	BIGINT	6	2334	124	975.2426470588235	666.8899014727051	298	913	1588	136	0.0%
played_matches	BIGINT	2	778	126	325.08088235294116	222.29663382423507	100	304	530	136	0.0%
unique_players	BIGINT	8	733	121	341.8529411764706	206.3617294914268	139	339	547	136	0.0%
2s_rounds	BIGINT	6	2028	121	866.2941176470588	583.8883723560086	276	824	1404	136	0.0%
3s_rounds	BIGINT	0	360	69	108.94852941176471	96.75377836266122	16	95	182	136	0.0%
2s_matches	BIGINT	2	676	123	288.7647058823529	194.6294574520029	92	275	468	136	0.0%
3s_matches	BIGINT	0	120	69	36.31617647058823	32.251259454220424	6	32	60	136	0.0%

Downloads

Download as parquet

Download as csv

Download as json