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/test/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/test/data/s17/standings_s17.csv")

JSON Usage

Javascript
const standings_s17 = await fetch("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/s17/standings_s17.json").then(r => r.json())
Python
import requests
standings_s17 = requests.get("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/s17/standings_s17.json").json()
C#
using (var client = new HttpClient())
{
    var json = await client.GetStringAsync("https://f004.backblazeb2.com/file/sprocket-artifacts/test/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/test/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/test/data/s17/standings_s17.json")
curl
curl https://f004.backblazeb2.com/file/sprocket-artifacts/test/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(2,0) YES None None None
team_losses DECIMAL(2,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
2024-06-09 17:11:46.636447-05:00 1 Sabres Arctic BLUE 15 5 Academy League Doubles Season 17
2024-06-09 17:11:46.636447-05:00 2 Puffins Arctic BLUE 14 6 Academy League Doubles Season 17
2024-06-09 17:11:46.636447-05:00 3 Tyrants Arctic BLUE 4 11 Academy League Doubles Season 17
2024-06-09 17:11:46.636447-05:00 4 Foxes Arctic BLUE 4 16 Academy League Doubles Season 17
2024-06-09 17:11:46.636447-05:00 1 Tyrants Arctic BLUE 12 8 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 2024-06-09 17:11:46.636447-05 2024-06-09 17:11:46.636447-05 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(2,0) 2 90 68 19.641666666666666 17.731620135064038 9 13 22 1920 0.0%
team_losses DECIMAL(2,0) 1 95 73 19.641666666666666 17.722919020491897 9 13 22 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