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

JSON Usage

Javascript
const trackers = await fetch("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/trackers.json").then(r => r.json())
Python
import requests
trackers = requests.get("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/trackers.json").json()
C#
using (var client = new HttpClient())
{
    var json = await client.GetStringAsync("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/trackers.json");
    var trackers = JObject.Parse(json);
}
Ruby
require 'net/http'
require 'json'
uri = URI.parse("https://f004.backblazeb2.com/file/sprocket-artifacts/test/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/test/data/trackers.json")
curl
curl https://f004.backblazeb2.com/file/sprocket-artifacts/test/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
2024-06-09 17:11:47.776099-05:00 3065 10565 Blaster_RL https://rocketleague.tracker.network/rocket-league/profile/psn/Blaster_RLonStea PS4 Blaster_RLonStea
2024-06-09 17:11:47.776099-05:00 3065 10565 Blaster_RL https://rocketleague.tracker.network/rocket-league/profile/psn/elegant_cub690 PS4 elegant_cub690
2024-06-09 17:11:47.776099-05:00 3067 10567 TheGamingBear https://rocketleague.tracker.network/rocket-league/profile/psn/King_Panda4 PS4 King_Panda4
2024-06-09 17:11:47.776099-05:00 3068 10568 TheHamburglar https://rocketleague.tracker.network/rocket-league/profile/psn/TheHamburglar3 PS4 TheHamburglar3
2024-06-09 17:11:47.776099-05: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 2024-06-09 17:11:47.776099-05 2024-06-09 17:11:47.776099-05 1 None None None None None 9485 0.0%
MLE Player ID BIGINT 2504 8347 5140 5498.859884027412 1750.9009553662695 4033 5529 7116 9485 0.0%
mleid BIGINT 10000 16442 5223 13053.694570374275 1830.2201430579432 11584 13043 14419 9485 0.0%
name VARCHAR !Chino-096 Érid 5168 None None None None None 9485 0.0%
tracker VARCHAR FINDME https://rocketleague.tracker.network/rocket-league/profile/xbox/ShelbyCyan 9486 None None None None None 9485 0.0%
platform VARCHAR EPIC XBOX 5 None None None None None 9485 0.0%
platform_id VARCHAR %C2%B5cwood zwarteroos 9429 None None None None None 9485 0.0%

Downloads