trackers
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_trackers AS ( SELECT * FROM read_parquet( 'https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/trackers.parquet' ) ); - Select Everything
-
SELECT * FROM v_trackers;
CSV Usage
To link a CSV to your Google sheet
=importData("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/trackers.csv")
JSON Usage
- Javascript
-
const trackers = await fetch("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/trackers.json").then(r => r.json()) - Python
-
import requests trackers = requests.get("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/trackers.json").json() - C#
-
using (var client = new HttpClient()) { var json = await client.GetStringAsync("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/trackers.json"); var trackers = JObject.Parse(json); } - Ruby
-
require 'net/http' require 'json' uri = URI.parse("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/trackers.json") response = Net::HTTP.get_response(uri) trackers = JSON.parse(response.body) - R
-
library(jsonlite) trackers <- fromJSON("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/trackers.json") - curl
-
curl https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/trackers.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 |
| MLE Player ID | BIGINT | YES | None | None | None |
| mleid | BIGINT | YES | None | None | None |
| name | VARCHAR | YES | None | None | None |
| tracker | VARCHAR | YES | None | None | None |
| platform | VARCHAR | YES | None | None | None |
| platform_id | VARCHAR | YES | None | None | None |
Sample Data:
| as_of | MLE Player ID | mleid | name | tracker | platform | platform_id |
|---|---|---|---|---|---|---|
| 2025-04-14 22:03:31.520879+00:00 | 3065 | 10565 | Blaster_RL | https://rocketleague.tracker.network/rocket-league/profile/psn/Blaster_RLonStea | PS4 | Blaster_RLonStea |
| 2025-04-14 22:03:31.520879+00:00 | 3065 | 10565 | Blaster_RL | https://rocketleague.tracker.network/rocket-league/profile/psn/elegant_cub690 | PS4 | elegant_cub690 |
| 2025-04-14 22:03:31.520879+00:00 | 3067 | 10567 | TheGamingBear | https://rocketleague.tracker.network/rocket-league/profile/psn/King_Panda4 | PS4 | King_Panda4 |
| 2025-04-14 22:03:31.520879+00:00 | 3068 | 10568 | TheHamburglar | https://rocketleague.tracker.network/rocket-league/profile/psn/TheHamburglar3 | PS4 | TheHamburglar3 |
| 2025-04-14 22:03:31.520879+00:00 | 3069 | 10569 | TheLegend27 | https://rocketleague.tracker.network/rocket-league/profile/psn/TheGitarLegend | PS4 | TheGitarLegend |
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:31.520879+00 | 2025-04-14 22:03:31.520879+00 | 1 | None | None | None | None | None | 10630 | 0.0% |
| MLE Player ID | BIGINT | 2504 | 8724 | 5494 | 5751.432549388523 | 1859.0727238394957 | 4179 | 5828 | 7436 | 10630 | 0.0% |
| mleid | BIGINT | 10000 | 17146 | 5542 | 13362.05239887112 | 2017.5323800814915 | 11736 | 13285 | 14821 | 10630 | 0.0% |
| name | VARCHAR | !Chino-096 | Érid | 5538 | None | None | None | None | None | 10630 | 0.0% |
| tracker | VARCHAR | **naruto.ugenin#0:** https://rocketleague.tracker.network/rocket-league/profile/epic/clixxon_ | https://rocketleague.tracker.network/rocket-league/profile/xbox/ShelbyCyan | 10648 | None | None | None | None | None | 10630 | 0.0% |
| platform | VARCHAR | EPIC | XBOX | 5 | None | None | None | None | None | 10630 | 0.0% |
| platform_id | VARCHAR | %C2%B5cwood | zwarteroos | 10610 | None | None | None | None | None | 10630 | 0.0% |