matches

About:

Details matches, which is the parent of rounds and summarizes the results of two teams playing each other in the same leage and game mode. Each week, there are multiple matches played within each fixture: one per league and game mode of the two franchises playing against each other.

Parquet Usage

Examples assume you have run the view alias first.
Alias a View 
CREATE VIEW v_matches AS (
    SELECT * FROM read_parquet(
        'https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/schedules/matches.parquet'
    )
);
Select Everything 
SELECT * FROM v_matches;

CSV Usage

To link a CSV to your Google sheet

=importData("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/schedules/matches.csv")

JSON Usage

Javascript 
const matches = await fetch("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/schedules/matches.json").then(r => r.json())
Python
import requests
matches = requests.get("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/schedules/matches.json").json()
C#
using (var client = new HttpClient())
{
    var json = await client.GetStringAsync("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/schedules/matches.json");
    var matches = JObject.Parse(json);
}
Ruby
require 'net/http'
require 'json'
uri = URI.parse("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/schedules/matches.json")
response = Net::HTTP.get_response(uri)
matches = JSON.parse(response.body)
R
library(jsonlite)
matches <- fromJSON("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/schedules/matches.json")
curl
curl https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/schedules/matches.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
fixture_id BIGINT YES None None None
match_group_id BIGINT YES None None None
scheduling_start_time TIMESTAMP YES None None None
scheduling_end_time TIMESTAMP YES None None None
home VARCHAR YES None None None
away VARCHAR YES None None None
league VARCHAR YES None None None
game_mode VARCHAR YES None None None
home_wins BIGINT YES None None None
away_wins BIGINT YES None None None
winning_team VARCHAR YES None None None

Sample Data:

as_of match_id fixture_id match_group_id scheduling_start_time scheduling_end_time home away league game_mode home_wins away_wins winning_team
2025-04-14 22:03:47.089167+00:00 504 1 6 2021-04-22 04:00:00 2021-04-26 04:00:00 Sabres Puffins Master League Doubles 0 0 Not Played / Data Unavailable
2025-04-14 22:03:47.089167+00:00 60 1 6 2021-04-22 04:00:00 2021-04-26 04:00:00 Sabres Puffins Champion League Doubles 0 0 Not Played / Data Unavailable
2025-04-14 22:03:47.089167+00:00 2292 1 6 2021-04-22 04:00:00 2021-04-26 04:00:00 Sabres Puffins Academy League Doubles 0 0 Not Played / Data Unavailable
2025-04-14 22:03:47.089167+00:00 450 1 6 2021-04-22 04:00:00 2021-04-26 04:00:00 Sabres Puffins Foundation League Doubles 0 0 Not Played / Data Unavailable
2025-04-14 22:03:47.089167+00:00 505 1 6 2021-04-22 04:00:00 2021-04-26 04:00:00 Sabres Puffins Master League Standard 0 0 Not Played / Data Unavailable

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:47.089167+00 2025-04-14 22:03:47.089167+00 1 None None None None None 9807 0.0%
match_id BIGINT 1 54683 9921 19902.332007749566 19416.098051363926 2452 13196 40476 9807 0.0%
fixture_id BIGINT 1 9508 1970 3627.311716121138 3792.533217225838 419 1008 8110 9807 0.0%
match_group_id BIGINT 6 301 101 122.65759151626389 105.01352835370615 30 71 221 9807 0.0%
scheduling_start_time TIMESTAMP 2021-04-22 04:00:00 2025-04-24 00:00:00 93 None None None None None 9807 0.0%
scheduling_end_time TIMESTAMP 2021-04-26 04:00:00 2025-04-27 23:59:00 96 None None None None None 9807 0.0%
home VARCHAR Aviators Wolves 32 None None None None None 9807 0.0%
away VARCHAR Aviators Wolves 32 None None None None None 9807 0.0%
league VARCHAR Academy League Premier League 5 None None None None None 9807 0.0%
game_mode VARCHAR Doubles Standard 2 None None None None None 9807 0.0%
home_wins BIGINT 0 5 6 1.5186091567247884 1.6509119547594597 0 1 3 9807 0.0%
away_wins BIGINT 0 6 7 1.476496380136637 1.6241325966111304 0 1 3 9807 0.0%
winning_team VARCHAR Aviators Wolves 33 None None None None None 9807 0.0%

Downloads

Download as parquet

Download as csv

Download as json