rounds 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_rounds_s17 AS ( SELECT * FROM read_parquet( 'https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s17/rounds_s17.parquet' ) ); - Select Everything
-
SELECT * FROM v_rounds_s17;
CSV Usage
To link a CSV to your Google sheet
=importData("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s17/rounds_s17.csv")
JSON Usage
- Javascript
-
const rounds_s17 = await fetch("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s17/rounds_s17.json").then(r => r.json()) - Python
-
import requests rounds_s17 = requests.get("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s17/rounds_s17.json").json() - C#
-
using (var client = new HttpClient()) { var json = await client.GetStringAsync("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s17/rounds_s17.json"); var rounds_s17 = JObject.Parse(json); } - Ruby
-
require 'net/http' require 'json' uri = URI.parse("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s17/rounds_s17.json") response = Net::HTTP.get_response(uri) rounds_s17 = JSON.parse(response.body) - R
-
library(jsonlite) rounds_s17 <- fromJSON("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s17/rounds_s17.json") - curl
-
curl https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s17/rounds_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 |
| 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-07 05:13:32.143404+00:00 | 40661 | 120318 | Jets | 4 | Wolves | 5 |
| 2025-02-07 05:13:32.143404+00:00 | 40385 | 113615 | Sabres | 5 | Puffins | 1 |
| 2025-02-07 05:13:32.143404+00:00 | 40430 | 113654 | Shadow | 2 | Lightning | 3 |
| 2025-02-07 05:13:32.143404+00:00 | 40430 | 113655 | Shadow | 2 | Lightning | 1 |
| 2025-02-07 05:13:32.143404+00:00 | 40430 | 113656 | Shadow | 1 | Lightning | 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-07 05:13:32.143404+00 | 2025-02-07 05:13:32.143404+00 | 1 | None | None | None | None | None | 6311 | 0.0% |
| match_id | BIGINT | 40250 | 41529 | 1261 | 40888.88005070512 | 369.5750427644102 | 40569 | 40888 | 41210 | 6311 | 0.0% |
| round_id | BIGINT | 111141 | 132807 | 6311 | 123411.37997147837 | 7027.118316519423 | 118192 | 123656 | 130750 | 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.8359545732243057 | 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.7949380485367263 | 1 | 3 | 4 | 6311 | 0.0% |