standings s17
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_s17 AS ( SELECT * FROM read_parquet( 'https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/s17/standings_s17.parquet' ) ); - Select Everything
-
SELECT * FROM v_standings_s17;
CSV Usage
To link a CSV to your Google sheet
=importData("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/s17/standings_s17.csv")
JSON Usage
- Javascript
-
const standings_s17 = await fetch("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/s17/standings_s17.json").then(r => r.json()) - Python
-
import requests standings_s17 = requests.get("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/s17/standings_s17.json").json() - C#
-
using (var client = new HttpClient()) { var json = await client.GetStringAsync("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/s17/standings_s17.json"); var standings_s17 = JObject.Parse(json); } - Ruby
-
require 'net/http' require 'json' uri = URI.parse("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/s17/standings_s17.json") response = Net::HTTP.get_response(uri) standings_s17 = JSON.parse(response.body) - R
-
library(jsonlite) standings_s17 <- fromJSON("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/s17/standings_s17.json") - curl
-
curl https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/s17/standings_s17.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(2,0) | YES | None | None | None |
| team_losses | DECIMAL(2,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:46.636447-05:00 | 1 | Sabres | Arctic | BLUE | 15 | 5 | Academy League | Doubles | Season 17 |
| 2024-06-09 17:11:46.636447-05:00 | 2 | Puffins | Arctic | BLUE | 14 | 6 | Academy League | Doubles | Season 17 |
| 2024-06-09 17:11:46.636447-05:00 | 3 | Tyrants | Arctic | BLUE | 4 | 11 | Academy League | Doubles | Season 17 |
| 2024-06-09 17:11:46.636447-05:00 | 4 | Foxes | Arctic | BLUE | 4 | 16 | Academy League | Doubles | Season 17 |
| 2024-06-09 17:11:46.636447-05:00 | 1 | Tyrants | Arctic | BLUE | 12 | 8 | Academy League | Standard | Season 17 |
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:46.636447-05 | 2024-06-09 17:11:46.636447-05 | 1 | None | None | None | None | None | 1920 | 0.0% |
| ranking | BIGINT | 1 | 32 | 32 | 6.9 | 7.233066332266144 | 2 | 4 | 10 | 1920 | 0.0% |
| name | VARCHAR | Aviators | Wolves | 32 | None | None | None | None | None | 1920 | 0.0% |
| division_name | VARCHAR | Arctic | Volcanic | 8 | None | None | None | None | None | 1920 | 50.0% |
| conference | VARCHAR | BLUE | ORANGE | 2 | None | None | None | None | None | 1920 | 50.0% |
| team_wins | DECIMAL(2,0) | 2 | 90 | 68 | 19.641666666666666 | 17.731620135064038 | 9 | 13 | 22 | 1920 | 0.0% |
| team_losses | DECIMAL(2,0) | 1 | 95 | 73 | 19.641666666666666 | 17.722919020491897 | 9 | 13 | 22 | 1920 | 0.0% |
| league | VARCHAR | Academy League | Premier League | 5 | None | None | None | None | None | 1920 | 20.0% |
| mode | VARCHAR | Doubles | Standard | 2 | None | None | None | None | None | 1920 | 33.33% |
| season | VARCHAR | Season 17 | Season 17 | 1 | None | None | None | None | None | 1920 | 0.0% |