Sprocket Public Datasets

standings s17

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

Select Everything

SELECT * FROM v_standings_s17;

CSV Usage

To link a CSV to your Google sheet

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

JSON Usage

Javascript

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

Python

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

C#

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

Ruby

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

R

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

curl

curl https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s17/standings_s17.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
ranking	BIGINT	YES	None	None	None
name	VARCHAR	YES	None	None	None
division_name	VARCHAR	YES	None	None	None
conference	VARCHAR	YES	None	None	None
team_wins	DECIMAL(3,0)	YES	None	None	None
team_losses	DECIMAL(3,0)	YES	None	None	None
league	VARCHAR	YES	None	None	None
mode	VARCHAR	YES	None	None	None
season	VARCHAR	YES	None	None	None

Sample Data:

as_of	ranking	name	division_name	conference	team_wins	team_losses	league	mode	season
2025-02-07 05:13:37.093907+00:00	1	Puffins	Arctic	BLUE	26	24	Academy League	Doubles	Season 17
2025-02-07 05:13:37.093907+00:00	2	Sabres	Arctic	BLUE	25	25	Academy League	Doubles	Season 17
2025-02-07 05:13:37.093907+00:00	3	Foxes	Arctic	BLUE	22	28	Academy League	Doubles	Season 17
2025-02-07 05:13:37.093907+00:00	4	Tyrants	Arctic	BLUE	20	30	Academy League	Doubles	Season 17
2025-02-07 05:13:37.093907+00:00	1	Sabres	Arctic	BLUE	26	24	Academy League	Standard	Season 17

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-02-07 05:13:37.093907+00	2025-02-07 05:13:37.093907+00	1	None	None	None	None	None	1920	0.0%
ranking	BIGINT	1	32	32	6.9	7.233066332266144	2	4	10	1920	0.0%
name	VARCHAR	Aviators	Wolves	32	None	None	None	None	None	1920	0.0%
division_name	VARCHAR	Arctic	Volcanic	8	None	None	None	None	None	1920	50.0%
conference	VARCHAR	BLUE	ORANGE	2	None	None	None	None	None	1920	50.0%
team_wins	DECIMAL(3,0)	11	244	115	53.333333333333336	47.24525318205976	25	32	58	1920	0.0%
team_losses	DECIMAL(3,0)	12	243	118	53.333333333333336	47.24525318205974	24	33	57	1920	0.0%
league	VARCHAR	Academy League	Premier League	5	None	None	None	None	None	1920	20.0%
mode	VARCHAR	Doubles	Standard	2	None	None	None	None	None	1920	33.33%
season	VARCHAR	Season 17	Season 17	1	None	None	None	None	None	1920	0.0%

Downloads

Download as parquet

Download as csv

Download as json