player stats 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_player_stats_s17 AS (
    SELECT * FROM read_parquet(
        'https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s17/player_stats_s17.parquet'
    )
);
Select Everything 
SELECT * FROM v_player_stats_s17;

CSV Usage

To link a CSV to your Google sheet

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

JSON Usage

Javascript 
const player_stats_s17 = await fetch("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s17/player_stats_s17.json").then(r => r.json())
Python
import requests
player_stats_s17 = requests.get("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s17/player_stats_s17.json").json()
C#
using (var client = new HttpClient())
{
    var json = await client.GetStringAsync("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s17/player_stats_s17.json");
    var player_stats_s17 = JObject.Parse(json);
}
Ruby
require 'net/http'
require 'json'
uri = URI.parse("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s17/player_stats_s17.json")
response = Net::HTTP.get_response(uri)
player_stats_s17 = JSON.parse(response.body)
R
library(jsonlite)
player_stats_s17 <- fromJSON("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s17/player_stats_s17.json")
curl
curl https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s17/player_stats_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
member_id BIGINT YES None None None
team_name VARCHAR YES None None None
skill_group VARCHAR YES None None None
gamemode VARCHAR YES None None None
match_id BIGINT YES None None None
round_id BIGINT YES None None None
replays_submitted_at TIMESTAMP YES None None None
home_won BOOLEAN YES None None None
dpi DECIMAL(4,2) YES None None None
gpi DECIMAL(4,2) YES None None None
opi DECIMAL(5,2) YES None None None
goals DECIMAL(4,2) YES None None None
saves DECIMAL(4,2) YES None None None
score DECIMAL(6,2) YES None None None
shots DECIMAL(4,2) YES None None None
assists DECIMAL(3,2) YES None None None
goals_against DECIMAL(4,2) YES None None None
shots_against DECIMAL(4,2) YES None None None

Sample Data:

as_of member_id team_name skill_group gamemode match_id round_id replays_submitted_at home_won dpi gpi opi goals saves score shots assists goals_against shots_against
2025-02-06 17:02:49.993866+00:00 4 Express Master League RL_DOUBLES 40348 111340 2024-05-11 03:18:10.277188 True 88.87 67.52 46.17 1.00 4.00 650.00 5.00 1.00 2.00 9.00
2025-02-06 17:02:49.993866+00:00 4 Express Master League RL_DOUBLES 40348 111341 2024-05-11 03:18:10.277188 True 87.81 58.20 28.58 2.00 4.00 689.00 3.00 0.00 2.00 10.00
2025-02-06 17:02:49.993866+00:00 4 Express Master League RL_DOUBLES 40348 111342 2024-05-11 03:18:10.277188 True 73.23 38.71 4.19 0.00 0.00 174.00 2.00 0.00 1.00 4.00
2025-02-06 17:02:49.993866+00:00 4 Express Master League RL_DOUBLES 40348 111343 2024-05-11 03:18:10.277188 True 61.12 60.00 58.88 0.00 1.00 345.00 4.00 2.00 2.00 8.00
2025-02-06 17:02:49.993866+00:00 4 Express Master League RL_DOUBLES 40348 111344 2024-05-11 03:18:10.277188 False 54.59 29.56 4.54 0.00 0.00 214.00 3.00 0.00 2.00 5.00

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-06 17:02:49.993866+00 2025-02-06 17:02:49.993866+00 1 None None None None None 31538 0.0%
member_id BIGINT 4 5493 918 3448.3022068615637 1497.3477021682802 2532 3669 4764 31538 0.0%
team_name VARCHAR Aviators Wolves 33 None None None None None 31538 0.0%
skill_group VARCHAR Academy League Premier League 5 None None None None None 31538 0.0%
gamemode VARCHAR RL_DOUBLES RL_STANDARD 2 None None None None None 31538 0.0%
match_id BIGINT 40250 41529 1261 40889.71459826241 369.6495257110736 40570 40889 41211 31538 0.0%
round_id BIGINT 111141 132807 6311 123426.80185807597 7027.515762370624 118204 123768 130771 31538 0.0%
replays_submitted_at TIMESTAMP 2024-05-11 02:21:20.581444 2024-07-29 17:33:50.00296 1264 None None None None None 31538 0.0%
home_won BOOLEAN false true 2 None None None None None 31538 0.0%
dpi DECIMAL(4,2) 0.00 99.99 1269 51.96367620013952 31.61187020498038 23 55 81 31538 0.0%
gpi DECIMAL(4,2) 0.00 99.33 7065 50.33533641955736 19.35729104781745 39 50 62 31538 0.0%
opi DECIMAL(5,2) 0.00 100.00 360 48.706781977297226 32.78274431991884 15 40 80 31538 0.0%
goals DECIMAL(4,2) 0.00 12.00 11 1.124484748557296 1.168593582475705 0 1 2 31538 0.0%
saves DECIMAL(4,2) 0.00 14.00 12 1.5013634345868476 1.2950747270957697 1 1 2 31538 0.0%
score DECIMAL(6,2) 0.00 2154.00 1132 425.54829095059927 201.29426519783794 277 395 543 31538 0.0%
shots DECIMAL(4,2) 0.00 16.00 16 3.1569535163929228 1.9776558879406114 2 3 4 31538 0.0%
assists DECIMAL(3,2) 0.00 7.00 8 0.6668146363117509 0.8437735705132782 0 0 1 31538 0.0%
goals_against DECIMAL(4,2) 0.00 21.00 15 2.7259813558247195 1.7853015459798982 1 3 4 31538 0.0%
shots_against DECIMAL(4,2) 0.00 33.00 26 7.8225632570232735 3.106041765552212 6 8 10 31538 0.0%

Downloads

Download as parquet

Download as csv

Download as json