scrim 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_scrim_stats AS ( SELECT * FROM read_parquet( 'https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/scrim_stats.parquet' ) ); - Select Everything
-
SELECT * FROM v_scrim_stats;
CSV Usage
To link a CSV to your Google sheet
=importData("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/scrim_stats.csv")
JSON Usage
- Javascript
-
const scrim_stats = await fetch("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/scrim_stats.json").then(r => r.json()) - Python
-
import requests scrim_stats = requests.get("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/scrim_stats.json").json() - C#
-
using (var client = new HttpClient()) { var json = await client.GetStringAsync("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/scrim_stats.json"); var scrim_stats = JObject.Parse(json); } - Ruby
-
require 'net/http' require 'json' uri = URI.parse("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/scrim_stats.json") response = Net::HTTP.get_response(uri) scrim_stats = JSON.parse(response.body) - R
-
library(jsonlite) scrim_stats <- fromJSON("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/scrim_stats.json") - curl
-
curl https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/scrim_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 |
| weekof | TIMESTAMP | YES | None | None | None |
| played_rounds | BIGINT | YES | None | None | None |
| played_matches | BIGINT | YES | None | None | None |
| unique_players | BIGINT | YES | None | None | None |
| 2s_rounds | BIGINT | YES | None | None | None |
| 3s_rounds | BIGINT | YES | None | None | None |
| 2s_matches | BIGINT | YES | None | None | None |
| 3s_matches | BIGINT | YES | None | None | None |
Sample Data:
| as_of | weekof | played_rounds | played_matches | unique_players | 2s_rounds | 3s_rounds | 2s_matches | 3s_matches |
|---|---|---|---|---|---|---|---|---|
| 2024-06-09 17:11:45.855011-05:00 | 2022-09-12 00:00:00 | 660 | 220 | 345 | 573 | 87 | 191 | 29 |
| 2024-06-09 17:11:45.855011-05:00 | 2022-09-19 00:00:00 | 774 | 258 | 371 | 699 | 75 | 233 | 25 |
| 2024-06-09 17:11:45.855011-05:00 | 2022-09-26 00:00:00 | 1011 | 337 | 401 | 888 | 123 | 296 | 41 |
| 2024-06-09 17:11:45.855011-05:00 | 2022-10-03 00:00:00 | 2334 | 778 | 704 | 2016 | 318 | 672 | 106 |
| 2024-06-09 17:11:45.855011-05:00 | 2022-10-10 00:00:00 | 417 | 139 | 260 | 363 | 54 | 121 | 18 |
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.855011-05 | 2024-06-09 17:11:45.855011-05 | 1 | None | None | None | None | None | 91 | 0.0% |
| weekof | TIMESTAMP | 2022-09-12 00:00:00 | 2024-06-03 00:00:00 | 92 | None | None | None | None | None | 91 | 0.0% |
| played_rounds | BIGINT | 33 | 2334 | 86 | 1071.923076923077 | 664.4410722265281 | 431 | 1161 | 1654 | 91 | 0.0% |
| played_matches | BIGINT | 11 | 778 | 87 | 357.3076923076923 | 221.48035740884274 | 144 | 387 | 552 | 91 | 0.0% |
| unique_players | BIGINT | 26 | 734 | 88 | 370.0659340659341 | 203.6613639352127 | 194 | 373 | 561 | 91 | 0.0% |
| 2s_rounds | BIGINT | 33 | 2028 | 82 | 939.6263736263736 | 578.8992168734583 | 394 | 996 | 1426 | 91 | 0.0% |
| 3s_rounds | BIGINT | 0 | 360 | 59 | 132.2967032967033 | 99.02833427363596 | 34 | 123 | 204 | 91 | 0.0% |
| 2s_matches | BIGINT | 11 | 676 | 81 | 313.2087912087912 | 192.96640562448607 | 131 | 332 | 476 | 91 | 0.0% |
| 3s_matches | BIGINT | 0 | 120 | 60 | 44.0989010989011 | 33.00944475787866 | 11 | 41 | 68 | 91 | 0.0% |