player eligibility
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_eligibility AS ( SELECT * FROM read_parquet( 'https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/player_eligibility.parquet' ) ); - Select Everything
-
SELECT * FROM v_player_eligibility;
CSV Usage
To link a CSV to your Google sheet
=importData("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/player_eligibility.csv")
JSON Usage
- Javascript
-
const player_eligibility = await fetch("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/player_eligibility.json").then(r => r.json()) - Python
-
import requests player_eligibility = requests.get("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/player_eligibility.json").json() - C#
-
using (var client = new HttpClient()) { var json = await client.GetStringAsync("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/player_eligibility.json"); var player_eligibility = JObject.Parse(json); } - Ruby
-
require 'net/http' require 'json' uri = URI.parse("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/player_eligibility.json") response = Net::HTTP.get_response(uri) player_eligibility = JSON.parse(response.body) - R
-
library(jsonlite) player_eligibility <- fromJSON("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/player_eligibility.json") - curl
-
curl https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/player_eligibility.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 |
| mleid | BIGINT | YES | None | None | None |
| name | VARCHAR | YES | None | None | None |
| team_name | VARCHAR | YES | None | None | None |
| player_id | BIGINT | YES | None | None | None |
| points | BIGINT | YES | None | None | None |
Sample Data:
| as_of | mleid | name | team_name | player_id | points |
|---|---|---|---|---|---|
| 2024-05-30 23:55:16.656776-05:00 | 10002 | 1AMRamen | Express | 2506 | 30 |
| 2024-05-30 23:55:16.656776-05:00 | 10009 | Adi | Sharks | 2513 | 5 |
| 2024-05-30 23:55:16.656776-05:00 | 10026 | iAtomic | Sharks | 2529 | 80 |
| 2024-05-30 23:55:16.656776-05:00 | 10049 | FallenDan | Hawks | 2551 | 20 |
| 2024-05-30 23:55:16.656776-05:00 | 10050 | BigQ | Puffins | 2552 | 20 |
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-05-30 23:55:16.656776-05 | 2024-05-30 23:55:16.656776-05 | 1 | None | None | None | None | None | 939 | 0.0% |
| mleid | BIGINT | 10002 | 16425 | 943 | 13839.560170394036 | 1815.11666067081 | 12698 | 13919 | 15142 | 939 | 0.0% |
| name | VARCHAR | .bzy | zugz | 942 | None | None | None | None | None | 939 | 0.0% |
| team_name | VARCHAR | Aviators | Wolves | 37 | None | None | None | None | None | 939 | 0.0% |
| player_id | BIGINT | 2506 | 8329 | 921 | 6234.64536741214 | 1672.7605291097998 | 5020 | 6621 | 7698 | 939 | 0.0% |
| points | BIGINT | 5 | 1050 | 69 | 56.19275825346113 | 70.80608154795016 | 26 | 35 | 60 | 939 | 0.0% |