Skip to content

Instantly share code, notes, and snippets.

View SkatingScores's full-sized avatar

SkatingScores SkatingScores

3 followers · 0 following
View GitHub Profile
@SkatingScores
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 / 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
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
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
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
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
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
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
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
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']