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%

Downloads