nilsabdi’s gists

nilsabdi / nonretiredmajorwinners.json

Created February 12, 2025 10:54

	[
	{
	"id": "b20ec3d5-944f-4d01-93b9-d4626a7f3809",
	"nickname": "NiKo",
	"firstName": "Nikola",
	"lastName": "Kovač",
	"team": "Team Falcons",
	"majors": 13
	},
	{

nilsabdi / majorplayers.json

Created February 12, 2025 10:41

	[
	{
	"id": "b20ec3d5-944f-4d01-93b9-d4626a7f3809",
	"nickname": "NiKo",
	"firstName": "Nikola",
	"lastName": "Kovač",
	"team": "Team Falcons",
	"majors": 13
	},
	{

nilsabdi / themostbeautifulqueryofthemall.sql

Created November 1, 2024 11:48

	-- The reasoning behind running this continuously is due to how matches with new players' rank are continuously added, so we want to include them in the distribution.
	WITH
	reference_time AS (
	SELECT TIMESTAMP '2024-10-22 20:00:00+00' AS start_time -- Beginning of all (Deadlock) time, Tuesday at 20:00 GMT (when the first ranks were calculated)
	),
	-- The number of weeks since ranked started
	current_week AS (
	SELECT
	ceil(((EXTRACT(EPOCH FROM NOW() AT TIME ZONE 'GMT') - EXTRACT(EPOCH FROM reference_time.start_time)) / (7 * 24 * 60 * 60))) AS week
	FROM reference_time

nilsabdi / condiments.json

Created October 9, 2024 23:19

-

	[
	{
	"menuItemId": 190001102,
	"name": {
	"en-US": "Frokost Steak"
	},
	"familyGroupRef": 111,
	"definitions": [
	{
	"definitionSequence": 1,

nilsabdi / postmatchdetails.json

Last active September 16, 2024 11:29

postmatchdetails.json

{ "matchDetails": "EqGCBAiXBxAAGAAisR4IuoyQCBABIhAIDBDuzaeMDBgAIAAoADAAIhQIWRDuzaeMDBja6ZbEBSAAKAAwACIQCFkQ7t/h5gMYACAAKAAwACIQCG8Q/4Pg3QEYACAAKAAwACIUCHAQ7t/h5gMYy6bsmQUgACgAMAAiEQiIARD5gcGtBRgAIAAoADAAIhEIoQEQw7yqjg4YACAAKAAwACIRCNABEIGBorsLGAAgACgAMAAiEQjQARDJtMvhAxgAIAAoADAAIhEI0QEQzb7+iA4YACAAKAAwACIRCPQBEM6q6tUPGAAgACgAMAAiEQiFAhDdntLEDRgAIAAoADAAIhUIrAIQ7s2njAwY2KnX8QUgACgAMAAiEQjpAhD1jfO4BxgAIAAoADAAIhEI7AIQr+jhvAEYACAAKAAwACIVCJ4DEO7f4eYDGNrR3PkDIAAoADAAIhEI/QMQ6JizogUYACAAKAAwACIRCP4DENzMyrUBGAAgACgAMAAiFQjgBBDuzaeMDBj7562WBCAAKAAwACIRCIkFENeo5ugOGAAgACgAMAAiEQiJBRCCz9PZCRgAIAAoADAAIhEIigUQk77m1AwYACAAKAAwACIVCNsFEO7f4eYDGN/s+M8CIAAoADAAIhQIgQYQzqrq1Q8YktniYSAAKAAwACIRCI8GEM+nj/wIGAAgACgAMAAiFQiRBhDOqurVDxj8/sXQByAAKAAwACIVCO8GEM6q6tUPGNn3lY4DIAAoADAAIhUIjQcQw7yqjg4Y+6P8yQQgACgAMAAqpgQItAEQ4BEYhAMgMyjXAjAAOABAAEgAUHJYAGDgCmgAcAF4AIABAYgBE5ABAJgBE6ABqx2oAeoLsAGQAbgBAMABAcgB7wHQAQPYAe8B4AGgBegBgQbwAQD4AQSAAmmIAjuQAp4BmAKeAaACJKgCBLACALgCAMICDAgBEAEY6gsgvAIoM8ICDQgCEBMYqx0g4Aoo1wLCAgkIAxiQASAAKADCAgYIB

nilsabdi / 15.json

Created August 5, 2024 22:58

	[
	{
	"heroId": "15",
	"totalMatches": 30055,
	"totalWins": 15011,
	"winRate": 0.49945100648810514,
	"pickRate": 0.007915405372520494,
	"position": "POSITION_1",
	"rank": "ALL"
	},

nilsabdi / all.json

Created August 5, 2024 22:58

	[
	{
	"heroId": "1",
	"totalMatches": 239718,
	"totalWins": 117528,
	"winRate": 0.4902760743874052,
	"pickRate": 0.01249442301678307,
	"position": "ALL",
	"rank": "ALL"
	},

nilsabdi / realtime.json

Created July 26, 2024 15:31

	{
	"match": {
	"server_steam_id": "90200394262724614",
	"match_id": "7865912855",
	"timestamp": 2362,
	"game_time": 1231,
	"game_mode": 22,
	"league_id": 16540,
	"league_node_id": 0,
	"game_state": 5,

nilsabdi / synergy.json

Created July 16, 2024 13:41

	{
	"data": {
	"heroStats": {
	"matchUp": [
	{
	"heroId": 2,
	"with": [
	{
	"heroId1": 2,
	"heroId2": 102,

nilsabdi / AxeItems.json

Created July 16, 2024 13:35

	{
	"data": {
	"heroStats": {
	"itemFullPurchase": [
	{
	"position": "POSITION_1",
	"itemId": 90,
	"winsAverage": 0.574952561669829,
	"matchCount": 527,
	"winCount": 303,

Nils Abdi Andersen-Ale nilsabdi