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/test/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/test/data/player_stats.csv")
JSON Usage
- Javascript
-
const player_stats = await fetch("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/player_stats.json").then(r => r.json()) - Python
-
import requests player_stats = requests.get("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/player_stats.json").json() - C#
-
using (var client = new HttpClient()) { var json = await client.GetStringAsync("https://f004.backblazeb2.com/file/sprocket-artifacts/test/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/test/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/test/data/player_stats.json") - curl
-
curl https://f004.backblazeb2.com/file/sprocket-artifacts/test/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 |
| 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:45.356098-05:00 | 49.52 | 38.21 | 26.91 | 2.00 | 5.00 | 767.00 | 2.00 | 0.00 | 5.00 | 14.00 | 5364 | 114286 | 43325 | RL_DOUBLES | Master League |
| 2024-06-09 17:11:45.356098-05:00 | 83.11 | 62.63 | 42.15 | 0.00 | 2.00 | 304.00 | 3.00 | 1.00 | 2.00 | 4.00 | 4895 | 114281 | 40441 | RL_STANDARD | Premier League |
| 2024-06-09 17:11:45.356098-05:00 | 90.03 | 83.48 | 76.94 | 2.00 | 2.00 | 505.00 | 4.00 | 0.00 | 1.00 | 8.00 | 1729 | 114282 | 40441 | RL_STANDARD | Premier League |
| 2024-06-09 17:11:45.356098-05:00 | 90.03 | 64.08 | 38.14 | 1.00 | 2.00 | 399.00 | 4.00 | 0.00 | 1.00 | 8.00 | 4895 | 114282 | 40441 | RL_STANDARD | Premier League |
| 2024-06-09 17:11:45.356098-05:00 | 90.03 | 85.37 | 80.72 | 0.00 | 2.00 | 366.00 | 1.00 | 2.00 | 1.00 | 8.00 | 3128 | 114282 | 40441 | RL_STANDARD | Premier 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:45.356098-05 | 2024-06-09 17:11:45.356098-05 | 1 | None | None | None | None | None | 509008 | 0.0% |
| dpi | DECIMAL(5,2) | 0.00 | 100.00 | 1740 | 50.938244015811144 | 30.11119819391845 | 24 | 53 | 78 | 509008 | 0.0% |
| gpi | DECIMAL(4,2) | 0.00 | 99.77 | 9563 | 49.68514357338195 | 18.63720020065321 | 39 | 50 | 60 | 509008 | 0.0% |
| opi | DECIMAL(5,2) | 0.00 | 100.00 | 467 | 48.43188824144218 | 32.59168822643063 | 15 | 42 | 80 | 509008 | 0.0% |
| goals | DECIMAL(4,2) | 0.00 | 14.00 | 14 | 1.4097126174834187 | 1.2786774983133515 | 0 | 1 | 2 | 509008 | 0.0% |
| saves | DECIMAL(4,2) | 0.00 | 14.00 | 14 | 1.5855959041901109 | 1.3182402598200145 | 1 | 1 | 2 | 509008 | 0.0% |
| score | DECIMAL(6,2) | 0.00 | 1876.00 | 1479 | 482.9232742903844 | 208.08088737200015 | 329 | 458 | 613 | 509008 | 0.0% |
| shots | DECIMAL(4,2) | 0.00 | 97.00 | 28 | 3.594874736742841 | 2.072383784362454 | 2 | 3 | 5 | 509008 | 0.0% |
| assists | DECIMAL(3,2) | 0.00 | 8.00 | 9 | 0.724670339169522 | 0.8726825540793947 | 0 | 1 | 1 | 509008 | 0.0% |
| goals_against | DECIMAL(4,2) | 0.00 | 17.00 | 18 | 3.0213768742338036 | 1.85225842195273 | 2 | 3 | 4 | 509008 | 0.0% |
| shots_against | DECIMAL(5,2) | 0.00 | 155.00 | 34 | 7.823405526042813 | 3.1087608713975734 | 6 | 8 | 10 | 509008 | 0.0% |
| member_id | BIGINT | 4 | 5429 | 2214 | 3091.517663769528 | 1381.5022974318401 | 2321 | 3274 | 4169 | 509008 | 0.0% |
| round_id | BIGINT | 7 | 120629 | 117064 | 60337.44173372521 | 34737.58295232226 | 30675 | 59660 | 90397 | 509008 | 0.0% |
| match_id | BIGINT | 2705 | 45028 | 36676 | 23039.596831483985 | 11827.439110206886 | 13058 | 22221 | 32838 | 509008 | 0.0% |
| gamemode | VARCHAR | RL_DOUBLES | RL_STANDARD | 2 | None | None | None | None | None | 509008 | 0.0% |
| skill_group | VARCHAR | Academy League | Premier League | 5 | None | None | None | None | None | 509008 | 0.0% |