Sprocket Public Datasets

role usages

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

Select Everything

SELECT * FROM v_role_usages;

CSV Usage

To link a CSV to your Google sheet

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

JSON Usage

Javascript

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

Python

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

C#

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

Ruby

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

R

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

curl

curl https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/role_usages.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
doubles_uses	BIGINT	YES	None	None	None
standard_uses	BIGINT	YES	None	None	None
total_uses	BIGINT	YES	None	None	None
season_number	BIGINT	YES	None	None	None
team_name	VARCHAR	YES	None	None	None
league	VARCHAR	YES	None	None	None
role	VARCHAR	YES	None	None	None

Sample Data:

as_of	doubles_uses	standard_uses	total_uses	season_number	team_name	league	role
2025-04-14 22:03:21.730938+00:00	2	6	8	18	Aviators	ACADEMY	PLAYERA
2025-04-14 22:03:21.730938+00:00	1	7	8	18	Aviators	ACADEMY	PLAYERB
2025-04-14 22:03:21.730938+00:00	2	5	7	18	Aviators	ACADEMY	PLAYERC
2025-04-14 22:03:21.730938+00:00	2	1	3	18	Aviators	ACADEMY	PLAYERD
2025-04-14 22:03:21.730938+00:00	6	1	7	18	Aviators	ACADEMY	PLAYERE

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:21.730938+00	2025-04-14 22:03:21.730938+00	1	None	None	None	None	None	6200	0.0%
doubles_uses	BIGINT	0	14	14	2.951935483870968	2.264266728774304	1	3	4	6200	0.0%
standard_uses	BIGINT	0	14	15	4.383870967741935	2.552952265137626	2	4	6	6200	0.0%
total_uses	BIGINT	1	24	23	7.335806451612903	3.988992172545356	4	7	10	6200	0.0%
season_number	BIGINT	-17	18	8	13.522741935483872	6.936077986373372	13	15	17	6200	0.0%
team_name	VARCHAR	Aviators	Wolves	34	None	None	None	None	None	6200	0.0%
league	VARCHAR	ACADEMY	PREMIER	5	None	None	None	None	None	6200	0.0%
role	VARCHAR	NONE	PLAYERH	9	None	None	None	None	None	6200	0.0%

Downloads

Download as parquet

Download as csv

Download as json