rounds s18
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_s18 AS ( SELECT * FROM read_parquet( 'https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s18/rounds_s18.parquet' ) ); - Select Everything
-
SELECT * FROM v_rounds_s18;
CSV Usage
To link a CSV to your Google sheet
=importData("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s18/rounds_s18.csv")
JSON Usage
- Javascript
-
const rounds_s18 = await fetch("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s18/rounds_s18.json").then(r => r.json()) - Python
-
import requests rounds_s18 = requests.get("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s18/rounds_s18.json").json() - C#
-
using (var client = new HttpClient()) { var json = await client.GetStringAsync("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s18/rounds_s18.json"); var rounds_s18 = JObject.Parse(json); } - Ruby
-
require 'net/http' require 'json' uri = URI.parse("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s18/rounds_s18.json") response = Net::HTTP.get_response(uri) rounds_s18 = JSON.parse(response.body) - R
-
library(jsonlite) rounds_s18 <- fromJSON("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s18/rounds_s18.json") - curl
-
curl https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/s18/rounds_s18.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-04-14 22:03:33.605318+00:00 | 53496 | 151461 | Dodgers | 2 | Elite | 3 |
| 2025-04-14 22:03:33.605318+00:00 | 53428 | 150574 | Eclipse | 3 | Spectre | 1 |
| 2025-04-14 22:03:33.605318+00:00 | 53428 | 150575 | Eclipse | 2 | Spectre | 3 |
| 2025-04-14 22:03:33.605318+00:00 | 53428 | 150576 | Eclipse | 2 | Spectre | 1 |
| 2025-04-14 22:03:33.605318+00:00 | 53428 | 150577 | Eclipse | 1 | Spectre | 4 |
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-04-14 22:03:33.605318+00 | 2025-04-14 22:03:33.605318+00 | 1 | None | None | None | None | None | 5609 | 0.0% |
| match_id | BIGINT | 53404 | 54554 | 1135 | 53969.65091816723 | 329.7015056497101 | 53685 | 53967 | 54252 | 5609 | 0.0% |
| round_id | BIGINT | 150574 | 166296 | 5689 | 159498.37849884114 | 5219.643790272742 | 154452 | 161002 | 164514 | 5609 | 0.0% |
| Home | VARCHAR | Aviators | Wolves | 32 | None | None | None | None | None | 5609 | 0.0% |
| Home Goals | BIGINT | 0 | 12 | 13 | 2.7521839900160456 | 1.7625409489340833 | 1 | 3 | 4 | 5609 | 0.0% |
| Away | VARCHAR | Aviators | Wolves | 32 | None | None | None | None | None | 5609 | 0.0% |
| Away Goals | BIGINT | 0 | 12 | 13 | 2.7618113745765736 | 1.7875670231957628 | 1 | 3 | 4 | 5609 | 0.0% |