members
About:
A member is a distinct person
A player is a member that plays a game
e.g.
- Tom plays both Rocket League and CS:2, he has 1 member, and 2 players
- Jane is a member of the community, but does not participate in any leagues, she has 1 member and 0 players
Parquet Usage
Examples assume you have run the view alias first.- Alias a View
-
CREATE VIEW v_members AS ( SELECT * FROM read_parquet( 'https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/members.parquet' ) ); - Select Everything
-
SELECT * FROM v_members;
CSV Usage
To link a CSV to your Google sheet
=importData("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/members.csv")
JSON Usage
- Javascript
-
const members = await fetch("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/members.json").then(r => r.json()) - Python
-
import requests members = requests.get("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/members.json").json() - C#
-
using (var client = new HttpClient()) { var json = await client.GetStringAsync("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/members.json"); var members = JObject.Parse(json); } - Ruby
-
require 'net/http' require 'json' uri = URI.parse("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/members.json") response = Net::HTTP.get_response(uri) members = JSON.parse(response.body) - R
-
library(jsonlite) members <- fromJSON("https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/members.json") - curl
-
curl https://f004.backblazeb2.com/file/sprocket-artifacts/public/data/members.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 |
| member_id | BIGINT | YES | None | None | None |
| name | VARCHAR | YES | None | None | None |
| mle_id | BIGINT | YES | None | None | None |
| mle_player_id | BIGINT | YES | None | None | None |
| discord_id | VARCHAR | YES | None | None | None |
Sample Data:
| as_of | member_id | name | mle_id | mle_player_id | discord_id |
|---|---|---|---|---|---|
| 2025-04-14 22:03:22.998088+00:00 | 2 | -j | 10000 | 2504 | 193497999589113857 |
| 2025-04-14 22:03:22.998088+00:00 | 3 | !Chino-096 | 10001 | 2505 | 255528067550674944 |
| 2025-04-14 22:03:22.998088+00:00 | 4 | 1AMRamen | 10002 | 2506 | 202141161295577088 |
| 2025-04-14 22:03:22.998088+00:00 | 5 | BuffaloDave | 10003 | 2507 | 453242350831927296 |
| 2025-04-14 22:03:22.998088+00:00 | 6 | AcePocket | 10004 | 2508 | 180151530651910144 |
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:22.998088+00 | 2025-04-14 22:03:22.998088+00 | 1 | None | None | None | None | None | 5628 | 0.0% |
| member_id | BIGINT | 2 | 5811 | 5798 | 2881.9182658137884 | 1672.1160013220006 | 1433 | 2874 | 4318 | 5628 | 0.0% |
| name | VARCHAR | !Chino-096 | Érid | 5602 | None | None | None | None | None | 5628 | 0.0% |
| mle_id | BIGINT | 10000 | 17146 | 5586 | 13172.502132196161 | 1990.0724480515187 | 11483 | 13066 | 14561 | 5628 | 0.0% |
| mle_player_id | BIGINT | 2504 | 8724 | 5556 | 5577.924484719261 | 1848.1723302516434 | 3935 | 5551 | 7234 | 5628 | 0.0% |
| discord_id | VARCHAR | 99989195493232640 | 5548 | None | None | None | None | None | 5628 | 0.0% |