SkatingScores’s gists

SkatingScores / gp_nse.txt

Last active November 11, 2021 21:42

All Skaters/Teams who ever did 3 GP events in a single season

	03/04 men 🇨🇳 CHN Chengjiang Li : ['gpcan', 'gpchn', 'gprus']
	03/04 men 🇫🇷 FRA Brian Joubert : ['gpchn', 'gpfra', 'gpjpn']
	03/04 men 🇷🇺 RUS Evgeni Plushenko : ['gpcan', 'gpfra', 'gprus']
	03/04 men 🇺🇸 USA Michael Weiss : ['gpusa', 'gpfra', 'gprus']
	03/04 women 🇯🇵 JPN Shizuka Arakawa : ['gpusa', 'gpcan', 'gpfra']
	03/04 women 🇺🇦 UKR Elena Liashenko : ['gpchn', 'gprus', 'gpjpn']
	03/04 women 🇺🇸 USA Sasha Cohen : ['gpusa', 'gpcan', 'gpfra']
	03/04 pairs 🇨🇦 CAN Langlois / Archetto : ['gpcan', 'gpfra', 'gpjpn']
	03/04 pairs 🇨🇳 CHN Zhang / Zhang : ['gpusa', 'gpfra', 'gprus']
	03/04 pairs 🇨🇳 CHN Pang / Tong : ['gpusa', 'gpchn', 'gprus']

SkatingScores / ijs_scoring_errors.csv

Last active February 11, 2021 17:41

Scoring Errors in Official IJS Results

We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 14 columns, instead of 12 in line 5.

	Season,Event,Discipline,Segment,Nat,Skater/Team,Fixed,Type,Item,Expected Value,Awarded Value,Description,URL,Tweet
	2004-05,GPFRA,Ladies,FS,🇮🇹,Valentina Marchei,No,GOE Total,2Lo,0.00,0.10,The high mark (1) was not dropped?,https://skatingscores.com/2005/gpfra/ladies/long/ita_valentina_marchei/element/14,
	2004-05,EC,Pairs,SP,🇺🇦,Tatiana VOLOSOZHAR/Stanislav MOROZOV,No,GOE Total,SpSt2,0.00,0.07,The high mark (1) was not dropped?,https://skatingscores.com/0405/ec/pairs/short/ukr_tatiana_volosozhar_stanislav_morozov/element/7,
	2004-05,EC,Pairs,SP,🇫🇷,Marylin PLA/Yannick BONHEUR,No,GOE Total,3T,-2.00,-2.14,The low mark (-3) was not dropped?,https://skatingscores.com/2005/ec/pairs/short/fra_marylin_pla_yannick_bonheur/element/1,
	2007-08,JGPEST,ALL,ALL,,ALL,No,PCS/GOE Total,,,,No High and Low marks were dropped across the entire event,https://skatingscores.com/2008/jgpest/,
	2012-13,JGPCRO,Dance,SD,🇨🇦,Melinda Meng/Andrew Meng,No,GOE Total,2BL4+kpYYY,0.07,0.14,Either the High GOE Mark was not dropped or +1 GOE was errone

SkatingScores / consistency.sql

Last active May 20, 2019 20:56

Consistency.sql

	WITH

	'key' AS (
	SELECT
	'men' 'dis_code',
	2019 'season_code'
	),

	'season_jump' AS (
	SELECT

SkatingScores / IJS_CoP_Panel_Structure.csv

Last active July 6, 2020 19:30

IJS/CoP Panel Structure

Season	MAX # OF JUDGES	ANONYMOUS	JUDGES RANDOMIZED PER SKATER ON PROTOCOL	HI/LO DROPPED	DROP MORE
2003-04	12	✅	❌	✅	✅
2004-05	12	✅	❌	✅	✅
2005-06	12	✅	❌	✅	✅ (3)
2006-07	12	✅	❌	✅	✅
2007-08	12	✅	❌	✅	✅
2008-09	10/09	✅	❌	✅	✅
2009-10	09	✅	✅	✅	✅ (2)
2010-11	09	✅	✅	✅	❌
2011-12	09	✅	✅	✅	❌

SkatingScores / 2019_eu_seq.csv

Last active March 26, 2019 01:17

2018-19 Season Jumping Passes containing both "+1Eu" and "+SEQ" (in either order)

Season	Event	Seg	Nat	Nat	#	Jump	B?	BV	GOE Total	Score	Video (with timestamp)	Protocol
2018-19	JGPSLO	FS	🇱🇺	Gemma MARSHALL	7.	2Lz+1Eu+SEQ+2S*	x	2.29	-0.18	2.11	https://youtu.be/e0CU8klsUk4?t=159	http://skatingscores.com/2019/jgpslo/long/unit/lux/gemma_marshall/
2018-19	CSFIN	FS	🇸🇪	Nikolaj MAJOROV	1.	3Lz+SEQ+1Eu+2S		4.72	-2.16	2.56	https://youtu.be/WPvf_n9GD30?t=33	http://skatingscores.com/2019/csfin/long/unit/swe/nikolaj_majorov/
2018-19	JGPARM	FS	🇦🇲	Marina ASOYAN	5.	2F+1Eu+SEQ+2Lo*		1.84	-0.44	1.40	https://youtu.be/Af3Vhb242Gw?t=120	http://skatingscores.com/2019/jgparm/long/unit/arm/marina_asoyan/
2018-19	CSCRO	FS	🇭🇰	Lap Kan YUEN	6.	2S+SEQ+1Eu<+1S		1.04	-0.49	0.55		http://skatingscores.com/2019/cscro/long/unit/hkg/lap_kan_yuen/
2018-19	WJC	FS	🇮🇹	Gabriele FRANGIPANI	7.	1A+1Eu+SEQ+2S*	x	1.41	-0.33	1.08	https://youtu.be/F5qidEXt4LM?t=168	http://skatingscores.com/2019/wjc/long/unit/ita/gabriele_frangipani/

SkatingScores / isu_comms.txt

Last active April 9, 2019 19:57

ISU Communications containing SOVs that I already have

	SOV for Singles/Pairs:
	2003-04 Comm. 1207
	2004-05 MISSING
	2005-06 Comm. ???? (I have the score tables of this one, but not the whole doc. dunno the #)
	2006-07 Comm. 1396
	2007-08 Comm. 1445 & 1459 (updated)
	2008-09 Comm. 1494
	2009-10 MISSING
	2010-11 Comm. 1611
	2011-12 Comm. 1672

SkatingScores / CoP_Critique_Sources.csv

Last active April 9, 2019 19:45

CoP/IJS Critique Sources

We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 5 columns, instead of 4 in line 5.

	Author,Date,Pub,Title,Link
	Sandra Loosemoore,May 2003,Frogs On Ice,Code of Points Considered Harmful,http://www.frogsonice.com/skateweb/articles/code-of-points.shtml
	Katherine Godfrey PhD,May 2003?,SkateFair.org,Statistical Consequences of the ISU's New Cumulative Scoring System,https://web.archive.org/web/20100131081126/http://www.skatefair.org/media/copanalysis.php
	Eric Zitzewitz,06 Jan 2006,Journal of Economics and Management Strategy,Nationalism in Winter Sports Judgingand Its Lessons for OrganizationalDecision Making,https://onlinelibrary.wiley.com/doi/epdf/10.1111/j.1530-9134.2006.00092.x?referrer_access_token=Ivpkk0cEoXt8ZclKtWknKIta6bR2k8jH0KrdpFOxC65gKbkIAGZYRBVcC8hWgYQKvtKv8WnoGleJPgED3rAUMnMyjshQVd2xam8FrOsQxTpLXD9EiJnxir0SXcoZABBP3AZzyfsm3C69aVnQNClkfw%3D%3D
	,16 Feb 2006,Seed Magazine,Finding Flaws in Figure Skating,https://web.archive.org/web/20120714095006/http://seedmagazine.com/content/article/finding_flaws_in_figure_skating/
	John Emerson,Spring/Summer 2006?,Yale,The Computer: A Phantom Figure

SkatingScores / CoP_Critique_Sources.html

Last active February 27, 2019 15:32

CoP Critique Sources

	<html>
	<body>
	<table border="1" cellpadding="3">
	<tr>
	<td>Author</td>
	<td>Date</td>
	<td>Pub</td>
	<td>Title/Link</td>
	</tr>
	<tr>

SkatingScores / goe_rank2.sql

Last active November 10, 2018 18:20

Improved "ties" column.

	WITH

	'season_element' AS (
	SELECT
	el.id 'id',
	uf.flag 'nat',
	u.first_name \|\| ' ' \|\| u.last_name 'unit',
	el.name 'element',
	(
	SELECT avg(goe.score) FROM scores_goemark goe

SkatingScores / goe_rank.sql

Created November 9, 2018 23:45

This Season's Elements ranked by Mean Raw GOE Mark

	WITH

	'season_element' AS (
	SELECT
	el.id 'id',
	uf.flag 'nat',
	u.first_name \|\| ' ' \|\| u.last_name 'unit',
	el.name 'element',
	(
	SELECT avg(goe.score) FROM scores_goemark goe

SkatingScores SkatingScores