match groups
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_match_groups AS ( SELECT * FROM read_parquet( 'https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/schedules/match_groups.parquet' ) ); - Select Everything
-
SELECT * FROM v_match_groups;
CSV Usage
To link a CSV to your Google sheet
=importData("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/schedules/match_groups.csv")
JSON Usage
- Javascript
-
const match_groups = await fetch("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/schedules/match_groups.json").then(r => r.json()) - Python
-
import requests match_groups = requests.get("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/schedules/match_groups.json").json() - C#
-
using (var client = new HttpClient()) { var json = await client.GetStringAsync("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/schedules/match_groups.json"); var match_groups = JObject.Parse(json); } - Ruby
-
require 'net/http' require 'json' uri = URI.parse("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/schedules/match_groups.json") response = Net::HTTP.get_response(uri) match_groups = JSON.parse(response.body) - R
-
library(jsonlite) match_groups <- fromJSON("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/schedules/match_groups.json") - curl
-
curl https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/schedules/match_groups.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_group_id | BIGINT | YES | None | None | None |
| start | TIMESTAMP | YES | None | None | None |
| end | TIMESTAMP | YES | None | None | None |
| match_group_title | VARCHAR | YES | None | None | None |
| parent_group_title | VARCHAR | YES | None | None | None |
Sample Data:
| as_of | match_group_id | start | end | match_group_title | parent_group_title |
|---|---|---|---|---|---|
| 2025-04-14 22:03:36.393875+00:00 | 6 | 2021-04-22 04:00:00 | 2021-04-26 04:00:00 | Match 1 | Season 12 |
| 2025-04-14 22:03:36.393875+00:00 | 16 | 2021-04-22 04:00:00 | 2021-05-03 04:00:00 | Match 11 | Season 12 |
| 2025-04-14 22:03:36.393875+00:00 | 7 | 2021-04-29 04:00:00 | 2021-05-03 04:00:00 | Match 2 | Season 12 |
| 2025-04-14 22:03:36.393875+00:00 | 8 | 2021-05-06 04:00:00 | 2021-05-10 04:00:00 | Match 3 | Season 12 |
| 2025-04-14 22:03:36.393875+00:00 | 17 | 2021-05-06 04:00:00 | 2021-05-17 04:00:00 | Match 12 | Season 12 |
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:36.393875+00 | 2025-04-14 22:03:36.393875+00 | 1 | None | None | None | None | None | 102 | 0.0% |
| match_group_id | BIGINT | 6 | 301 | 101 | 116.33333333333333 | 101.2351769697945 | 31 | 70 | 217 | 102 | 0.0% |
| start | TIMESTAMP | 2021-04-22 04:00:00 | 2025-04-24 00:00:00 | 93 | None | None | None | None | None | 102 | 0.0% |
| end | TIMESTAMP | 2021-04-26 04:00:00 | 2025-04-27 23:59:00 | 96 | None | None | None | None | None | 102 | 0.0% |
| match_group_title | VARCHAR | Conference Finals | Qualifiers | 27 | None | None | None | None | None | 102 | 0.0% |
| parent_group_title | VARCHAR | Season 12 | Season 18 | 13 | None | None | None | None | None | 102 | 0.0% |