fixtures
About:
Details fixtures, which is the match-up of two teams within a match
Parquet Usage
Examples assume you have run the view alias first.- Alias a View
-
CREATE VIEW v_fixtures AS ( SELECT * FROM read_parquet( 'https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/schedules/fixtures.parquet' ) ); - Select Everything
-
SELECT * FROM v_fixtures;
CSV Usage
To link a CSV to your Google sheet
=importData("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/schedules/fixtures.csv")
JSON Usage
- Javascript
-
const fixtures = await fetch("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/schedules/fixtures.json").then(r => r.json()) - Python
-
import requests fixtures = requests.get("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/schedules/fixtures.json").json() - C#
-
using (var client = new HttpClient()) { var json = await client.GetStringAsync("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/schedules/fixtures.json"); var fixtures = JObject.Parse(json); } - Ruby
-
require 'net/http' require 'json' uri = URI.parse("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/schedules/fixtures.json") response = Net::HTTP.get_response(uri) fixtures = JSON.parse(response.body) - R
-
library(jsonlite) fixtures <- fromJSON("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/schedules/fixtures.json") - curl
-
curl https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/schedules/fixtures.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 |
| fixture_id | BIGINT | YES | None | None | None |
| match_group_id | BIGINT | YES | None | None | None |
| home | VARCHAR | YES | None | None | None |
| away | VARCHAR | YES | None | None | None |
Sample Data:
| as_of | fixture_id | match_group_id | home | away |
|---|---|---|---|---|
| 2025-04-14 22:03:43.970299+00:00 | 1 | 6 | Sabres | Puffins |
| 2025-04-14 22:03:43.970299+00:00 | 2 | 6 | Hive | Aviators |
| 2025-04-14 22:03:43.970299+00:00 | 3 | 6 | Shadow | Pandas |
| 2025-04-14 22:03:43.970299+00:00 | 18 | 6 | Hawks | Ducks |
| 2025-04-14 22:03:43.970299+00:00 | 19 | 6 | Knights | Jets |
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:43.970299+00 | 2025-04-14 22:03:43.970299+00 | 1 | None | None | None | None | None | 1956 | 0.0% |
| fixture_id | BIGINT | 1 | 9508 | 1970 | 3307.329754601227 | 3635.7510720562536 | 490 | 978 | 6186 | 1956 | 0.0% |
| match_group_id | BIGINT | 6 | 301 | 101 | 114.25357873210633 | 98.33822896609774 | 33 | 69 | 216 | 1956 | 0.0% |
| home | VARCHAR | Aviators | Wolves | 32 | None | None | None | None | None | 1956 | 0.0% |
| away | VARCHAR | Aviators | Wolves | 32 | None | None | None | None | None | 1956 | 0.0% |