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% |