player stats s17

About:

Details per-game player stats from every league match they've played in during MLE Season 17.

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

JSON Usage

Javascript 
const player_stats_s17 = await fetch("https://f004.backblazeb2.com/file/sprocket-artifacts/test/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/test/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/test/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/test/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/test/data/s17/player_stats_s17.json")
curl
curl https://f004.backblazeb2.com/file/sprocket-artifacts/test/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
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(3,2) YES None None None
saves DECIMAL(3,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
member_id BIGINT YES None None None
round_id BIGINT YES None None None
match_id BIGINT YES None None None
gamemode VARCHAR YES None None None
skill_group 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 gamemode skill_group
2024-06-09 17:11:53.072996-05:00 85.40 79.16 72.92 2.00 1.00 447.00 2.00 0.00 1.00 4.00 3706 111141 40263 RL_STANDARD Academy League
2024-06-09 17:11:53.072996-05:00 69.29 38.10 6.91 0.00 0.00 162.00 0.00 0.00 1.00 4.00 4019 111141 40263 RL_STANDARD Academy League
2024-06-09 17:11:53.072996-05:00 85.40 62.48 39.56 0.00 1.00 262.00 2.00 1.00 2.00 4.00 3938 111141 40263 RL_STANDARD Academy League
2024-06-09 17:11:53.072996-05:00 69.29 50.09 30.90 1.00 0.00 234.00 1.00 0.00 2.00 4.00 4577 111141 40263 RL_STANDARD Academy League
2024-06-09 17:11:53.072996-05:00 69.29 38.46 7.63 0.00 0.00 104.00 1.00 0.00 2.00 4.00 5137 111141 40263 RL_STANDARD Academy League

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:53.072996-05 2024-06-09 17:11:53.072996-05 1 None None None None None 11679 0.0%
dpi DECIMAL(4,2) 0.00 99.97 1042 52.23436595598938 31.76845935250527 23 55 82 11679 0.0%
gpi DECIMAL(4,2) 0.00 99.04 4890 50.164155321517256 19.309831400544077 39 50 62 11679 0.0%
opi DECIMAL(5,2) 0.00 100.00 328 48.09366127236921 32.7780441025371 14 40 80 11679 0.0%
goals DECIMAL(3,2) 0.00 9.00 10 1.117218939977738 1.1670875917222565 0 1 2 11679 0.0%
saves DECIMAL(3,2) 0.00 8.00 9 1.5160544567171848 1.3029252854570217 1 1 2 11679 0.0%
score DECIMAL(6,2) 0.00 1471.00 986 425.5174244370237 202.06155815357337 276 394 545 11679 0.0%
shots DECIMAL(4,2) 0.00 12.00 13 3.1620857950166967 1.9854793046067094 2 3 4 11679 0.0%
assists DECIMAL(3,2) 0.00 6.00 7 0.6588749036732597 0.8450290667612386 0 0 1 11679 0.0%
goals_against DECIMAL(4,2) 0.00 12.00 13 2.6965493621029197 1.7786042368330357 1 2 4 11679 0.0%
shots_against DECIMAL(4,2) 0.00 22.00 22 7.803750321089134 3.076328136800329 6 8 10 11679 0.0%
member_id BIGINT 4 5413 790 3382.9701173045637 1492.4776489697729 2486 3616 4665 11679 0.0%
round_id BIGINT 111141 120557 2349 115600.03339326997 3282.105958675392 112071 114329 118569 11679 0.0%
match_id BIGINT 40250 40761 468 40490.90530011131 143.4552505519613 40368 40486 40605 11679 0.0%
gamemode VARCHAR RL_DOUBLES RL_STANDARD 2 None None None None None 11679 0.0%
skill_group VARCHAR Academy League Premier League 5 None None None None None 11679 0.0%

Downloads

Download as parquet

Download as csv

Download as json