standings
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_standings AS ( SELECT * FROM read_parquet( 'https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/standings.parquet' ) );
- Select Everything
-
SELECT * FROM v_standings;
CSV Usage
To link a CSV to your Google sheet
=importData("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/standings.csv")
JSON Usage
- Javascript
-
const standings = await fetch("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/standings.json").then(r => r.json())
- Python
-
import requests standings = requests.get("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/standings.json").json()
- C#
-
using (var client = new HttpClient()) { var json = await client.GetStringAsync("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/standings.json"); var standings = JObject.Parse(json); }
- Ruby
-
require 'net/http' require 'json' uri = URI.parse("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/standings.json") response = Net::HTTP.get_response(uri) standings = JSON.parse(response.body)
- R
-
library(jsonlite) standings <- fromJSON("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/standings.json")
- curl
-
curl https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/standings.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 |
ranking | BIGINT | YES | None | None | None |
name | VARCHAR | YES | None | None | None |
division_name | VARCHAR | YES | None | None | None |
conference | VARCHAR | YES | None | None | None |
team_wins | DECIMAL(3,0) | YES | None | None | None |
team_losses | DECIMAL(3,0) | YES | None | None | None |
league | VARCHAR | YES | None | None | None |
mode | VARCHAR | YES | None | None | None |
season | VARCHAR | YES | None | None | None |
Sample Data:
as_of | ranking | name | division_name | conference | team_wins | team_losses | league | mode | season |
---|---|---|---|---|---|---|---|---|---|
2024-06-09 17:11:45.972640-05:00 | 1 | Sabres | Arctic | BLUE | 0 | 0 | Academy League | Doubles | Season 12 |
2024-06-09 17:11:45.972640-05:00 | 2 | Puffins | Arctic | BLUE | 0 | 0 | Academy League | Doubles | Season 12 |
2024-06-09 17:11:45.972640-05:00 | 3 | Tyrants | Arctic | BLUE | 0 | 0 | Academy League | Doubles | Season 12 |
2024-06-09 17:11:45.972640-05:00 | 4 | Foxes | Arctic | BLUE | 0 | 0 | Academy League | Doubles | Season 12 |
2024-06-09 17:11:45.972640-05:00 | 1 | Foxes | Arctic | BLUE | 0 | 0 | Academy League | Doubles | Season 13 |
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.97264-05 | 2024-06-09 17:11:45.97264-05 | 1 | None | None | None | None | None | 11304 | 0.0% |
ranking | BIGINT | 1 | 32 | 32 | 6.862791932059448 | 7.305726141780461 | 2 | 4 | 10 | 11304 | 0.0% |
name | VARCHAR | Aviators | Wolves | 32 | None | None | None | None | None | 11304 | 0.0% |
division_name | VARCHAR | Arctic | Volcanic | 8 | None | None | None | None | None | 11304 | 50.0% |
conference | VARCHAR | BLUE | ORANGE | 2 | None | None | None | None | None | 11304 | 50.0% |
team_wins | DECIMAL(3,0) | 0 | 257 | 177 | 25.19037508846426 | 36.5804918216958 | 0 | 15 | 31 | 11304 | 0.0% |
team_losses | DECIMAL(3,0) | 0 | 264 | 181 | 25.19037508846426 | 36.60275514045894 | 0 | 15 | 31 | 11304 | 0.0% |
league | VARCHAR | Academy League | Premier League | 5 | None | None | None | None | None | 11304 | 20.38% |
mode | VARCHAR | Doubles | Standard | 2 | None | None | None | None | None | 11304 | 33.33% |
season | VARCHAR | Season 12 | Season 17 | 6 | None | None | None | None | None | 11304 | 0.0% |