historicalAggregatedPlayerStats
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_historicalAggregatedPlayerStats AS ( SELECT * FROM read_parquet( 'https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/historicalAggregatedPlayerStats.parquet' ) ); - Select Everything
-
SELECT * FROM v_historicalAggregatedPlayerStats;
CSV Usage
To link a CSV to your Google sheet
=importData("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/historicalAggregatedPlayerStats.csv")
JSON Usage
- Javascript
-
const historicalAggregatedPlayerStats = await fetch("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/historicalAggregatedPlayerStats.json").then(r => r.json()) - Python
-
import requests historicalAggregatedPlayerStats = requests.get("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/historicalAggregatedPlayerStats.json").json() - C#
-
using (var client = new HttpClient()) { var json = await client.GetStringAsync("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/historicalAggregatedPlayerStats.json"); var historicalAggregatedPlayerStats = JObject.Parse(json); } - Ruby
-
require 'net/http' require 'json' uri = URI.parse("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/historicalAggregatedPlayerStats.json") response = Net::HTTP.get_response(uri) historicalAggregatedPlayerStats = JSON.parse(response.body) - R
-
library(jsonlite) historicalAggregatedPlayerStats <- fromJSON("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/historicalAggregatedPlayerStats.json") - curl
-
curl https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/historicalAggregatedPlayerStats.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 |
| name | VARCHAR | YES | None | None | None |
| member_id | BIGINT | YES | None | None | None |
| gamemode | VARCHAR | YES | None | None | None |
| skill_group | VARCHAR | YES | None | None | None |
| team_name | VARCHAR | YES | None | None | None |
| season | VARCHAR | YES | None | None | None |
| games_played | BIGINT | YES | None | None | None |
| sprocket_rating | DECIMAL(18,16) | YES | None | None | None |
| dpi_per_game | DECIMAL(22,20) | YES | None | None | None |
| opi_per_game | DECIMAL(18,16) | YES | None | None | None |
| avg_score | DECIMAL(24,20) | YES | None | None | None |
| goals_per_game | DECIMAL(21,20) | YES | None | None | None |
| total_goals | DECIMAL(4,2) | YES | None | None | None |
| saves_per_game | DECIMAL(21,20) | YES | None | None | None |
| total_saves | DECIMAL(5,2) | YES | None | None | None |
| shots_per_game | DECIMAL(21,20) | YES | None | None | None |
| total_shots | DECIMAL(5,2) | YES | None | None | None |
| assists_per_game | DECIMAL(21,20) | YES | None | None | None |
| total_assists | DECIMAL(4,2) | YES | None | None | None |
| avg_goals_against | DECIMAL(22,20) | YES | None | None | None |
| total_goals_against | DECIMAL(5,2) | YES | None | None | None |
| avg_shots_against | DECIMAL(18,16) | YES | None | None | None |
| total_shots_against | DECIMAL(5,2) | YES | None | None | None |
| avg_demos_inflicted | DECIMAL(21,20) | YES | None | None | None |
| total_demos_inflicted | DECIMAL(5,2) | YES | None | None | None |
| avg_demos_taken | DECIMAL(21,20) | YES | None | None | None |
| total_demos_taken | DECIMAL(4,2) | YES | None | None | None |
Sample Data:
| as_of | name | member_id | gamemode | skill_group | team_name | season | games_played | sprocket_rating | dpi_per_game | opi_per_game | avg_score | goals_per_game | total_goals | saves_per_game | total_saves | shots_per_game | total_shots | assists_per_game | total_assists | avg_goals_against | total_goals_against | avg_shots_against | total_shots_against | avg_demos_inflicted | total_demos_inflicted | avg_demos_taken | total_demos_taken |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2025-04-14 22:03:35.388149+00:00 | .bzy | 3492 | RL_DOUBLES | Master League | Blizzard | Season 15 | 5 | 63.5960000000000000 | 49.90800000000000000000 | 77.2820000000000000 | 576.80000000000000000000 | 1.60000000000000000000 | 8.00 | 2.00000000000000000000 | 10.00 | 4.00000000000000000000 | 20.00 | 1.60000000000000000000 | 8.00 | 3.20000000000000000000 | 16.00 | 8.6000000000000000 | 43.00 | 0.20000000000000000000 | 1.00 | 0.60000000000000000000 | 3.00 |
| 2025-04-14 22:03:35.388149+00:00 | .bzy | 3492 | RL_DOUBLES | Master League | Dodgers | Season 16 | 16 | 50.3031250000000000 | 50.46625000000000000000 | 50.1412500000000000 | 514.56250000000000000000 | 1.18750000000000000000 | 19.00 | 1.81250000000000000000 | 29.00 | 3.62500000000000000000 | 58.00 | 1.12500000000000000000 | 18.00 | 2.93750000000000000000 | 47.00 | 8.1875000000000000 | 131.00 | 1.00000000000000000000 | 16.00 | 0.37500000000000000000 | 6.00 |
| 2025-04-14 22:03:35.388149+00:00 | .bzy | 3492 | RL_DOUBLES | Master League | Dodgers | Season 17 | 5 | 42.6700000000000000 | 41.06800000000000000000 | 44.2680000000000000 | 480.00000000000000000000 | 1.40000000000000000000 | 7.00 | 1.60000000000000000000 | 8.00 | 5.00000000000000000000 | 25.00 | 0.60000000000000000000 | 3.00 | 4.00000000000000000000 | 20.00 | 7.4000000000000000 | 37.00 | 0.60000000000000000000 | 3.00 | 0.40000000000000000000 | 2.00 |
| 2025-04-14 22:03:35.388149+00:00 | .bzy | 3492 | RL_DOUBLES | Master League | Puffins | Season 14 | 5 | 79.4800000000000000 | 69.85400000000000000000 | 89.1060000000000000 | 704.40000000000000000000 | 1.80000000000000000000 | 9.00 | 2.00000000000000000000 | 10.00 | 7.60000000000000000000 | 38.00 | 2.00000000000000000000 | 10.00 | 2.00000000000000000000 | 10.00 | 7.2000000000000000 | 36.00 | 1.00000000000000000000 | 5.00 | 0.80000000000000000000 | 4.00 |
| 2025-04-14 22:03:35.388149+00:00 | .bzy | 3492 | RL_DOUBLES | Master League | Tyrants | Season 18 | 10 | 56.7180000000000000 | 73.48700000000000000000 | 39.9480000000000000 | 571.80000000000000000000 | 1.20000000000000000000 | 12.00 | 2.80000000000000000000 | 28.00 | 4.10000000000000000000 | 41.00 | 0.70000000000000000000 | 7.00 | 4.50000000000000000000 | 45.00 | 11.8000000000000000 | 118.00 | 0.30000000000000000000 | 3.00 | 0.70000000000000000000 | 7.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-04-14 22:03:35.388149+00 | 2025-04-14 22:03:35.388149+00 | 1 | None | None | None | None | None | 9795 | 0.0% |
| name | VARCHAR | .bzy | zugz | 1834 | None | None | None | None | None | 9795 | 0.0% |
| member_id | BIGINT | 4 | 5792 | 1850 | 3156.600204185809 | 1461.27569457107 | 2328 | 3287 | 4265 | 9795 | 0.0% |
| gamemode | VARCHAR | RL_DOUBLES | RL_STANDARD | 2 | None | None | None | None | None | 9795 | 0.0% |
| skill_group | VARCHAR | Academy League | Premier League | 5 | None | None | None | None | None | 9795 | 0.0% |
| team_name | VARCHAR | Aviators | Wolves | 34 | None | None | None | None | None | 9795 | 0.0% |
| season | VARCHAR | Season 14 | Season 18 | 9 | None | None | None | None | None | 9795 | 0.0% |
| games_played | BIGINT | 1 | 40 | 40 | 14.818580908626851 | 9.290517991654722 | 5 | 15 | 20 | 9795 | 0.0% |
| sprocket_rating | DECIMAL(18,16) | 2.3100000000000000 | 86.0480000000000000 | 9003 | 49.31145906640003 | 8.129165686547285 | 45 | 50 | 54 | 9795 | 0.0% |
| dpi_per_game | DECIMAL(22,20) | 0.09000000000000000000 | 99.03000000000000000000 | 9371 | 52.34058593034276 | 12.68076390695792 | 45 | 52 | 60 | 9795 | 0.0% |
| opi_per_game | DECIMAL(18,16) | 3.5700000000000000 | 98.0500000000000000 | 9463 | 46.28209176419607 | 13.569312715772048 | 38 | 47 | 55 | 9795 | 0.0% |
| avg_score | DECIMAL(24,20) | 0.00000000000000000000 | 1126.00000000000000000000 | 7056 | 422.30606801215094 | 123.21032862127991 | 329 | 399 | 515 | 9795 | 0.0% |
| goals_per_game | DECIMAL(21,20) | 0.00000000000000000000 | 4.80000000000000000000 | 516 | 1.0974523718485656 | 0.5795828192434932 | 1 | 1 | 1 | 9795 | 0.0% |
| total_goals | DECIMAL(4,2) | 0.00 | 92.00 | 84 | 16.383665135273098 | 13.153661317166655 | 6 | 13 | 23 | 9795 | 0.0% |
| saves_per_game | DECIMAL(21,20) | 0.00000000000000000000 | 4.40000000000000000000 | 541 | 1.5036097932262091 | 0.5714866349110312 | 1 | 1 | 2 | 9795 | 0.0% |
| total_saves | DECIMAL(5,2) | 0.00 | 104.00 | 95 | 21.997753956100052 | 15.346285202974764 | 10 | 19 | 31 | 9795 | 0.0% |
| shots_per_game | DECIMAL(21,20) | 0.00000000000000000000 | 8.20000000000000000000 | 825 | 3.118361558760674 | 1.103072828507014 | 2 | 3 | 4 | 9795 | 0.0% |
| total_shots | DECIMAL(5,2) | 0.00 | 212.00 | 183 | 46.265339458907604 | 32.778125196499886 | 20 | 39 | 66 | 9795 | 0.0% |
| assists_per_game | DECIMAL(21,20) | 0.00000000000000000000 | 3.00000000000000000000 | 354 | 0.6452970491810455 | 0.33056331298860686 | 0 | 1 | 1 | 9795 | 0.0% |
| total_assists | DECIMAL(4,2) | 0.00 | 57.00 | 49 | 9.678407350689127 | 7.455353349296203 | 4 | 8 | 14 | 9795 | 0.0% |
| avg_goals_against | DECIMAL(22,20) | 0.00000000000000000000 | 11.00000000000000000000 | 620 | 2.8160647464336863 | 0.8722448021028905 | 2 | 3 | 3 | 9795 | 0.0% |
| total_goals_against | DECIMAL(5,2) | 0.00 | 149.00 | 130 | 39.73006636038795 | 24.614550102048355 | 19 | 35 | 56 | 9795 | 0.0% |
| avg_shots_against | DECIMAL(18,16) | 2.4000000000000000 | 18.0000000000000000 | 900 | 7.880397513584532 | 1.4344032156493094 | 7 | 8 | 9 | 9795 | 0.0% |
| total_shots_against | DECIMAL(5,2) | 3.00 | 367.00 | 331 | 114.67330270546196 | 71.67407353355716 | 51 | 100 | 163 | 9795 | 0.0% |
| avg_demos_inflicted | DECIMAL(21,20) | 0.00000000000000000000 | 7.00000000000000000000 | 510 | 0.8931662111271503 | 0.4959390092782393 | 1 | 1 | 1 | 9795 | 0.0% |
| total_demos_inflicted | DECIMAL(5,2) | 0.00 | 161.00 | 92 | 13.531801939765186 | 11.984439760577038 | 5 | 10 | 19 | 9795 | 0.0% |
| avg_demos_taken | DECIMAL(21,20) | 0.00000000000000000000 | 4.00000000000000000000 | 401 | 0.9078253712813937 | 0.3775160624862472 | 1 | 1 | 1 | 9795 | 0.0% |
| total_demos_taken | DECIMAL(4,2) | 0.00 | 63.00 | 62 | 13.530168453292497 | 9.908288018328943 | 6 | 11 | 19 | 9795 | 0.0% |