role usages
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_role_usages AS ( SELECT * FROM read_parquet( 'https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/role_usages.parquet' ) );
- Select Everything
-
SELECT * FROM v_role_usages;
CSV Usage
To link a CSV to your Google sheet
=importData("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/role_usages.csv")
JSON Usage
- Javascript
-
const role_usages = await fetch("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/role_usages.json").then(r => r.json())
- Python
-
import requests role_usages = requests.get("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/role_usages.json").json()
- C#
-
using (var client = new HttpClient()) { var json = await client.GetStringAsync("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/role_usages.json"); var role_usages = JObject.Parse(json); }
- Ruby
-
require 'net/http' require 'json' uri = URI.parse("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/role_usages.json") response = Net::HTTP.get_response(uri) role_usages = JSON.parse(response.body)
- R
-
library(jsonlite) role_usages <- fromJSON("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/role_usages.json")
- curl
-
curl https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/role_usages.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 |
doubles_uses | BIGINT | YES | None | None | None |
standard_uses | BIGINT | YES | None | None | None |
total_uses | BIGINT | YES | None | None | None |
season_number | BIGINT | YES | None | None | None |
team_name | VARCHAR | YES | None | None | None |
league | VARCHAR | YES | None | None | None |
role | VARCHAR | YES | None | None | None |
Sample Data:
as_of | doubles_uses | standard_uses | total_uses | season_number | team_name | league | role |
---|---|---|---|---|---|---|---|
2024-06-09 17:11:48.972769-05:00 | 1 | 2 | 3 | 17 | Aviators | ACADEMY | PLAYERA |
2024-06-09 17:11:48.972769-05:00 | 0 | 1 | 1 | 17 | Aviators | ACADEMY | PLAYERB |
2024-06-09 17:11:48.972769-05:00 | 3 | 4 | 7 | 17 | Aviators | ACADEMY | PLAYERC |
2024-06-09 17:11:48.972769-05:00 | 1 | 4 | 5 | 17 | Aviators | ACADEMY | PLAYERD |
2024-06-09 17:11:48.972769-05:00 | 2 | 1 | 3 | 17 | Aviators | ACADEMY | PLAYERE |
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:48.972769-05 | 2024-06-09 17:11:48.972769-05 | 1 | None | None | None | None | None | 5011 | 0.0% |
doubles_uses | BIGINT | 0 | 14 | 14 | 2.8255837158251844 | 2.353896848373072 | 1 | 2 | 4 | 5011 | 0.0% |
standard_uses | BIGINT | 0 | 14 | 15 | 4.193574136898823 | 2.677556348882083 | 2 | 4 | 6 | 5011 | 0.0% |
total_uses | BIGINT | 1 | 24 | 23 | 7.019157852724007 | 4.22449280863955 | 4 | 6 | 10 | 5011 | 0.0% |
season_number | BIGINT | 12 | 17 | 6 | 14.439832368788664 | 1.7123835367942024 | 13 | 14 | 16 | 5011 | 0.0% |
team_name | VARCHAR | Aviators | Wolves | 34 | None | None | None | None | None | 5011 | 0.0% |
league | VARCHAR | ACADEMY | PREMIER | 5 | None | None | None | None | None | 5011 | 0.0% |
role | VARCHAR | NONE | PLAYERH | 9 | None | None | None | None | None | 5011 | 0.0% |