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/test/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/test/data/schedules/fixtures.csv")
JSON Usage
- Javascript
-
const fixtures = await fetch("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/schedules/fixtures.json").then(r => r.json()) - Python
-
import requests fixtures = requests.get("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/schedules/fixtures.json").json() - C#
-
using (var client = new HttpClient()) { var json = await client.GetStringAsync("https://f004.backblazeb2.com/file/sprocket-artifacts/test/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/test/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/test/data/schedules/fixtures.json") - curl
-
curl https://f004.backblazeb2.com/file/sprocket-artifacts/test/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 |
|---|---|---|---|---|
| 2024-06-09 17:11:58.882505-05:00 | 1 | 6 | Sabres | Puffins |
| 2024-06-09 17:11:58.882505-05:00 | 2 | 6 | Hive | Aviators |
| 2024-06-09 17:11:58.882505-05:00 | 3 | 6 | Shadow | Pandas |
| 2024-06-09 17:11:58.882505-05:00 | 18 | 6 | Hawks | Ducks |
| 2024-06-09 17:11:58.882505-05: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 | 2024-06-09 17:11:58.882505-05 | 2024-06-09 17:11:58.882505-05 | 1 | None | None | None | None | None | 1678 | 0.0% |
| fixture_id | BIGINT | 1 | 9160 | 1682 | 2304.5005959475566 | 2885.9290596906108 | 420 | 840 | 5942 | 1678 | 0.0% |
| match_group_id | BIGINT | 6 | 229 | 87 | 88.10250297973778 | 79.52468505681425 | 29 | 50 | 205 | 1678 | 0.0% |
| home | VARCHAR | Aviators | Wolves | 32 | None | None | None | None | None | 1678 | 0.0% |
| away | VARCHAR | Aviators | Wolves | 32 | None | None | None | None | None | 1678 | 0.0% |