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/test/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/test/data/schedules/matches.csv")

JSON Usage

Javascript
const matches = await fetch("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/schedules/matches.json").then(r => r.json())
Python
import requests
matches = requests.get("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/schedules/matches.json").json()
C#
using (var client = new HttpClient())
{
    var json = await client.GetStringAsync("https://f004.backblazeb2.com/file/sprocket-artifacts/test/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/test/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/test/data/schedules/matches.json")
curl
curl https://f004.backblazeb2.com/file/sprocket-artifacts/test/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
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 home away league game_mode home_wins away_wins winning_team
2024-06-09 17:11:55.413001-05:00 504 1 6 Sabres Puffins Master League Doubles 0 0 Not Played / Data Unavailable
2024-06-09 17:11:55.413001-05:00 60 1 6 Sabres Puffins Champion League Doubles 0 0 Not Played / Data Unavailable
2024-06-09 17:11:55.413001-05:00 2292 1 6 Sabres Puffins Academy League Doubles 0 0 Not Played / Data Unavailable
2024-06-09 17:11:55.413001-05:00 450 1 6 Sabres Puffins Foundation League Doubles 0 0 Not Played / Data Unavailable
2024-06-09 17:11:55.413001-05:00 505 1 6 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 2024-06-09 17:11:55.413001-05 2024-06-09 17:11:55.413001-05 1 None None None None None 8409 0.0%
match_id BIGINT 1 41529 8505 14311.12962302295 14827.330056616363 2100 4205 28221 8409 0.0%
fixture_id BIGINT 1 9160 1682 2665.1136877155427 3206.0406027147105 369 809 6010 8409 0.0%
match_group_id BIGINT 6 229 87 94.56284932810084 85.32286796392398 27 49 208 8409 0.0%
home VARCHAR Aviators Wolves 32 None None None None None 8409 0.0%
away VARCHAR Aviators Wolves 32 None None None None None 8409 0.0%
league VARCHAR Academy League Premier League 5 None None None None None 8409 0.0%
game_mode VARCHAR Doubles Standard 2 None None None None None 8409 0.0%
home_wins BIGINT 0 5 6 1.1479367344511833 1.572614662612126 0 0 2 8409 0.0%
away_wins BIGINT 0 6 7 1.129860863360685 1.5565074691665117 0 0 2 8409 0.0%
winning_team VARCHAR Aviators Wolves 33 None None None None None 8409 0.0%

Downloads