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/test/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/test/data/members.csv")
JSON Usage
- Javascript
-
const members = await fetch("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/members.json").then(r => r.json()) - Python
-
import requests members = requests.get("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/members.json").json() - C#
-
using (var client = new HttpClient()) { var json = await client.GetStringAsync("https://f004.backblazeb2.com/file/sprocket-artifacts/test/data/members.json"); var members = JObject.Parse(json); } - Ruby
-
require 'net/http' require 'json' uri = URI.parse("https://f004.backblazeb2.com/file/sprocket-artifacts/test/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/test/data/members.json") - curl
-
curl https://f004.backblazeb2.com/file/sprocket-artifacts/test/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 |
|---|---|---|---|---|---|
| 2024-06-09 17:11:53.400718-05:00 | 2 | -j | 10000 | 2504 | 193497999589113857 |
| 2024-06-09 17:11:53.400718-05:00 | 3 | !Chino-096 | 10001 | 2505 | 255528067550674944 |
| 2024-06-09 17:11:53.400718-05:00 | 4 | 1AMRamen | 10002 | 2506 | 202141161295577088 |
| 2024-06-09 17:11:53.400718-05:00 | 5 | BuffaloDave | 10003 | 2507 | 453242350831927296 |
| 2024-06-09 17:11:53.400718-05: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 | 2024-06-09 17:11:53.400718-05 | 2024-06-09 17:11:53.400718-05 | 1 | None | None | None | None | None | 5265 | 0.0% |
| member_id | BIGINT | 2 | 5432 | 5406 | 2690.8400759734095 | 1559.3700614277543 | 1340 | 2690 | 4011 | 5265 | 0.0% |
| name | VARCHAR | !Chino-096 | Érid | 5227 | None | None | None | None | None | 5265 | 0.0% |
| mle_id | BIGINT | 10000 | 16442 | 5273 | 12918.325925925927 | 1800.5096103320263 | 11385 | 12881 | 14235 | 5265 | 0.0% |
| mle_player_id | BIGINT | 2504 | 8347 | 5201 | 5371.690028490028 | 1732.7531755196007 | 3842 | 5309 | 6929 | 5265 | 0.0% |
| discord_id | VARCHAR | 99989195493232640 | 5183 | None | None | None | None | None | 5265 | 0.0% |