rounds
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_rounds AS ( SELECT * FROM read_parquet( 'https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s17/rounds.parquet' ) ); - Select Everything
-
SELECT * FROM v_rounds;
CSV Usage
To link a CSV to your Google sheet
=importData("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s17/rounds.csv")
JSON Usage
- Javascript
-
const rounds = await fetch("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s17/rounds.json").then(r => r.json()) - Python
-
import requests rounds = requests.get("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s17/rounds.json").json() - C#
-
using (var client = new HttpClient()) { var json = await client.GetStringAsync("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s17/rounds.json"); var rounds = JObject.Parse(json); } - Ruby
-
require 'net/http' require 'json' uri = URI.parse("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s17/rounds.json") response = Net::HTTP.get_response(uri) rounds = JSON.parse(response.body) - R
-
library(jsonlite) rounds <- fromJSON("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s17/rounds.json") - curl
-
curl https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s17/rounds.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 |
| match_id | BIGINT | YES | None | None | None |
| round_id | BIGINT | YES | None | None | None |
| Home | VARCHAR | YES | None | None | None |
| Home Goals | BIGINT | YES | None | None | None |
| Away | VARCHAR | YES | None | None | None |
| Away Goals | BIGINT | YES | None | None | None |
Sample Data:
| as_of | match_id | round_id | Home | Home Goals | Away | Away Goals |
|---|---|---|---|---|---|---|
| 2025-02-02 23:02:55.157160+00:00 | 40359 | 111994 | Spartans | 0 | Knights | 2 |
| 2025-02-02 23:02:55.157160+00:00 | 40263 | 111141 | Tyrants | 2 | Puffins | 1 |
| 2025-02-02 23:02:55.157160+00:00 | 40258 | 111150 | Tyrants | 6 | Puffins | 5 |
| 2025-02-02 23:02:55.157160+00:00 | 40258 | 111151 | Tyrants | 3 | Puffins | 4 |
| 2025-02-02 23:02:55.157160+00:00 | 40258 | 111152 | Tyrants | 5 | Puffins | 2 |
Table Summary:
| column_name | column_type | min | max | approx_unique | avg | std | q25 | q50 | q75 | count | null_percentage |
|---|---|---|---|---|---|---|---|---|---|---|---|
| as_of | TIMESTAMP WITH TIME ZONE | 2025-02-02 23:02:55.15716+00 | 2025-02-02 23:02:55.15716+00 | 1 | None | None | None | None | None | 6311 | 0.0% |
| match_id | BIGINT | 40250 | 41529 | 1261 | 40888.88005070512 | 369.5750427643762 | 40569 | 40887 | 41210 | 6311 | 0.0% |
| round_id | BIGINT | 111141 | 132807 | 6311 | 123411.37997147837 | 7027.118316519382 | 118196 | 123672 | 130749 | 6311 | 0.0% |
| Home | VARCHAR | Aviators | Wolves | 32 | None | None | None | None | None | 6311 | 0.0% |
| Home Goals | BIGINT | 0 | 13 | 14 | 2.853905878624624 | 1.8359545732243054 | 1 | 3 | 4 | 6311 | 0.0% |
| Away | VARCHAR | Aviators | Wolves | 32 | None | None | None | None | None | 6311 | 0.0% |
| Away Goals | BIGINT | 0 | 21 | 14 | 2.7646965615591825 | 1.7949380485367306 | 1 | 3 | 4 | 6311 | 0.0% |