player stats

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

CSV Usage

To link a CSV to your Google sheet

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

JSON Usage

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

Sample Data:

as_of dpi gpi opi goals saves score shots assists goals_against shots_against member_id round_id match_id home_won gamemode skill_group team_name
2024-07-09 22:00:35.871103+00:00 98.15 52.89 7.63 0.00 2.00 235.00 1.00 0.00 4.00 12.00 5357 124429 41015 True RL_STANDARD Academy League Dodgers
2024-07-09 22:00:35.871103+00:00 49.82 64.30 78.78 2.00 1.00 507.00 5.00 0.00 1.00 3.00 3671 124425 40951 True RL_STANDARD Academy League Tyrants
2024-07-09 22:00:35.871103+00:00 27.69 34.92 42.15 0.00 0.00 178.00 3.00 1.00 1.00 3.00 5140 124425 40951 True RL_STANDARD Academy League Tyrants
2024-07-09 22:00:35.871103+00:00 27.69 17.66 7.63 0.00 0.00 106.00 1.00 0.00 1.00 3.00 3958 124425 40951 True RL_STANDARD Academy League Tyrants
2024-07-09 22:00:35.871103+00:00 74.56 56.35 38.14 1.00 2.00 434.00 4.00 0.00 2.00 8.00 1845 124427 40951 True RL_STANDARD Academy League Eclipse

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-07-09 22:00:35.871103+00 2024-07-09 22:00:35.871103+00 1 None None None None None 550163 0.0%
dpi DECIMAL(5,2) 0.00 100.00 1749 50.90884628737302 30.11708542329848 24 53 78 550163 0.0%
gpi DECIMAL(4,2) 0.00 99.77 9566 49.6973717425563 18.640686087857063 39 50 60 550163 0.0%
opi DECIMAL(5,2) 0.00 100.00 469 48.48574569718429 32.60297954264526 15 42 80 550163 0.0%
goals DECIMAL(4,2) 0.00 14.00 15 1.4130157789600537 1.2804945427263748 0 1 2 550163 0.0%
saves DECIMAL(4,2) 0.00 14.00 14 1.5879457542582835 1.318526656827701 1 1 2 550163 0.0%
score DECIMAL(6,2) 0.00 2154.00 1490 483.66051333877414 208.33609403037744 330 459 614 550163 0.0%
shots DECIMAL(4,2) 0.00 97.00 29 3.600818302939311 2.072346488739493 2 3 5 550163 0.0%
assists DECIMAL(3,2) 0.00 8.00 9 0.7263683671929956 0.8737768198647908 0 1 1 550163 0.0%
goals_against DECIMAL(4,2) 0.00 21.00 19 3.0265121427649624 1.8550774555171121 2 3 4 550163 0.0%
shots_against DECIMAL(5,2) 0.00 155.00 36 7.830648371482633 3.1072543345124854 6 8 10 550163 0.0%
member_id BIGINT 4 5494 2281 3132.7219096885833 1397.1266816722602 2350 3305 4206 550163 0.0%
round_id BIGINT 7 130252 127135 65205.20385231286 37550.85723337825 32773 65641 97726 550163 0.0%
match_id BIGINT 2705 47528 39253 24676.993178385314 12767.80338841602 13468 24244 35315 550163 0.0%
home_won BOOLEAN false true 2 None None None None None 550163 0.0%
gamemode VARCHAR RL_DOUBLES RL_STANDARD 2 None None None None None 550163 0.0%
skill_group VARCHAR Academy League Premier League 5 None None None None None 550163 0.0%
team_name VARCHAR Aviators Wolves 38 None None None None None 550163 0.0%

Downloads

Download as parquet

Download as csv

Download as json