Sprocket Public Datasets

standings s18

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

Select Everything

SELECT * FROM v_standings_s18;

CSV Usage

To link a CSV to your Google sheet

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

JSON Usage

Javascript

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

Python

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

C#

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

Ruby

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

R

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

curl

curl https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s18/standings_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
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-04-14 22:03:34.908940+00:00	1	Tyrants	Arctic	BLUE	28	17	Academy League	Doubles	Season 18
2025-04-14 22:03:34.908940+00:00	2	Puffins	Arctic	BLUE	24	21	Academy League	Doubles	Season 18
2025-04-14 22:03:34.908940+00:00	3	Sabres	Arctic	BLUE	21	24	Academy League	Doubles	Season 18
2025-04-14 22:03:34.908940+00:00	4	Foxes	Arctic	BLUE	10	35	Academy League	Doubles	Season 18
2025-04-14 22:03:34.908940+00:00	1	Sabres	Arctic	BLUE	26	19	Academy League	Standard	Season 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:34.90894+00	2025-04-14 22:03:34.90894+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)	10	210	99	47.24166666666667	41.70133683508951	22	29	51	1920	0.0%
team_losses	DECIMAL(3,0)	11	198	99	47.24166666666667	41.69548824267476	22	29	51	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 18	Season 18	1	None	None	None	None	None	1920	0.0%

Downloads

Download as parquet

Download as csv

Download as json