matches
About:
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% |