{"id":1989,"date":"2021-07-18T20:51:43","date_gmt":"2021-07-18T18:51:43","guid":{"rendered":"https:\/\/www.realbiathlon.com\/blog\/?p=1989"},"modified":"2021-07-27T11:23:35","modified_gmt":"2021-07-27T09:23:35","slug":"new-database-search-function","status":"publish","type":"post","link":"https:\/\/www.realbiathlon.com\/blog\/index.php\/2021\/07\/18\/new-database-search-function\/","title":{"rendered":"New database search function"},"content":{"rendered":"\n

I have been working on a new feature that allows to search the real biathlon<\/em> database for all-time records, seasonal data\/records or specific data subsets. You can search three separate categories: among all single races, aggregated seasonal data, and career statistics. I implemented a new web interface<\/a> available in the Patreon section<\/a> for more complex database searches that allows combined queries for multiple values\/ranges.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Below are a few examples of possible queries:<\/p>\n\n\n\n

Since 2001\u201302, there have been only 3 races in which an athlete topped all major stats (rank, ski rank, hit rate, shooting time): all these “perfect” races<\/a> where done by Ole Einar Bj\u00f8rndalen<\/a> between 2001 and 2005. There hasn’t been a single race like this on the women’s side.<\/p>\n\n\n\n

“Perfect” races, all time<\/strong><\/p>\n\n\n\n

No<\/th>Family Name<\/th>Given Name<\/th>Nation<\/th>Date<\/th>Level<\/th>Place<\/th>Discipline<\/th>Rank<\/th>Ski Rank<\/th>Total Percent<\/th>Shooting Time Rank<\/th><\/tr><\/thead>
No<\/th>Family Name<\/th>Given Name<\/th>Nation<\/th>Date<\/th>Level<\/th>Place<\/th>Discipline<\/th>Rank<\/th>Ski Rank<\/th>Total Percent<\/th>Shooting Time Rank<\/th><\/tr><\/thead>
1<\/td>Bjoerndalen<\/a><\/td>Ole Einar<\/td>NOR
<\/div><\/td>
2001-12-06<\/td>WC<\/td>Hochfilzen<\/td>SP<\/td>1<\/td>1<\/td>100<\/td>1<\/td><\/tr>
2<\/td>Bjoerndalen<\/a><\/td>Ole Einar<\/td>NOR
<\/div><\/td>
2004-12-11<\/td>WC<\/td>Oslo Holmenkollen<\/td>SP<\/td>1<\/td>1<\/td>100<\/td>1<\/td><\/tr>
3<\/td>Bjoerndalen<\/a><\/td>Ole Einar<\/td>NOR
<\/div><\/td>
2005-01-23<\/td>WC<\/td>Antholz-Anterselva<\/td>PU<\/td>1<\/td>1<\/td>100<\/td>1<\/td><\/tr>
4<\/td>Bjoerndalen<\/a><\/td>Ole Einar<\/td>NOR
<\/div><\/td>
2005-02-20<\/td>WC<\/td>Pokljuka<\/td>MS<\/td>1<\/td>2<\/td>100<\/td>2<\/td><\/tr>
5<\/td>Eberhard<\/a><\/td>Julian<\/td>AUT
<\/div><\/td>
2017-03-03<\/td>WC<\/td>PyeongChang<\/td>SP<\/td>1<\/td>2<\/td>100<\/td>1<\/td><\/tr><\/tbody><\/table>
<\/div><\/div><\/div><\/p>\n\n\n\n

Who was the fastest skier ever? That’s difficult to answer, because results will always differ depending on your criteria. But the list of the top female skiers<\/a> (per season) in terms of percent back from top 10 median isn’t a bad benchmark. <\/p>\n\n\n\n

Kaisa M\u00e4k\u00e4r\u00e4inen<\/a>, Magdalena Neuner<\/a> and Darya Domracheva<\/a> had 3 seasons each skiing at least 1.6% faster than the top 10 median. Interestingly, all seasons are from at least 6 years ago. Either the depth of the women’s field has increased a lot in just a couple of years, or there aren’t as many all-time great skiers in today’s field. <\/p>\n\n\n\n

Fastest skiers (top 10 median back) | Women’s seasons<\/strong><\/p>\n\n\n\n

No<\/th>Family Name<\/th>Given Name<\/th>Nation<\/th>Races<\/th>Season Id<\/th>Discipline<\/th>Year<\/th>Skiing Top 10 Median Back<\/th>Ski Rank<\/th>Speed<\/th><\/tr><\/thead>
No<\/th>Family Name<\/th>Given Name<\/th>Nation<\/th>Races<\/th>Season Id<\/th>Discipline<\/th>Year<\/th>Skiing Top 10 Median Back<\/th>Ski Rank<\/th>Speed<\/th><\/tr><\/thead>
1<\/td>Makarainen<\/a><\/td>Kaisa<\/td>FIN
<\/div><\/td>
25<\/td>1415<\/td>NonTeam<\/td>2015<\/td>-2.638<\/td>2.4<\/td>23.01<\/td><\/tr>
2<\/td>Neuner<\/a><\/td>Magdalena<\/td>GER
<\/div><\/td>
25<\/td>0708<\/td>NonTeam<\/td>2008<\/td>-2.502<\/td>1.32<\/td>22.255<\/td><\/tr>
3<\/td>Domracheva<\/a><\/td>Darya<\/td>BLR
<\/div><\/td>
26<\/td>1112<\/td>NonTeam<\/td>2012<\/td>-2.454<\/td>2.346<\/td>22.385<\/td><\/tr>
4<\/td>Domracheva<\/a><\/td>Darya<\/td>BLR
<\/div><\/td>
25<\/td>1415<\/td>NonTeam<\/td>2015<\/td>-2.064<\/td>2.125<\/td>22.852<\/td><\/tr>
5<\/td>Zidek<\/a><\/td>Anna Carin<\/td>SWE
<\/div><\/td>
23<\/td>0506<\/td>NonTeam<\/td>2006<\/td>-1.999<\/td>2.435<\/td>21.226<\/td><\/tr>
6<\/td>Domracheva<\/a><\/td>Darya<\/td>BLR
<\/div><\/td>
24<\/td>1314<\/td>NonTeam<\/td>2014<\/td>-1.89<\/td>1.917<\/td>22.472<\/td><\/tr>
7<\/td>Neuner<\/a><\/td>Magdalena<\/td>GER
<\/div><\/td>
25<\/td>1112<\/td>NonTeam<\/td>2012<\/td>-1.82<\/td>2.72<\/td>22.261<\/td><\/tr>
8<\/td>Neuner<\/a><\/td>Magdalena<\/td>GER
<\/div><\/td>
21<\/td>1011<\/td>NonTeam<\/td>2011<\/td>-1.774<\/td>1.952<\/td>22.14<\/td><\/tr>
9<\/td>Makarainen<\/a><\/td>Kaisa<\/td>FIN
<\/div><\/td>
26<\/td>1213<\/td>NonTeam<\/td>2013<\/td>-1.736<\/td>2.692<\/td>22.404<\/td><\/tr>
10<\/td>Makarainen<\/a><\/td>Kaisa<\/td>FIN
<\/div><\/td>
26<\/td>1112<\/td>NonTeam<\/td>2012<\/td>-1.735<\/td>2.615<\/td>22.211<\/td><\/tr>
11<\/td>Goessner<\/a><\/td>Miriam<\/td>GER
<\/div><\/td>
24<\/td>1213<\/td>NonTeam<\/td>2013<\/td>-1.6<\/td>4.083<\/td>22.375<\/td><\/tr><\/tbody><\/table>
<\/div><\/div><\/div><\/p>\n\n\n\n

Below are the fastest female shooters<\/a> \u2013 average of all career shooting times (at least 10 races). Unsurprisingly, that list is dominated by current athletes, as shooting speed have increased considerably over the last decade. Julia Simon<\/a> tops this ranking with a average 25.5s shooting time in her 80 career races to date.<\/p>\n\n\n\n

Fastest shooters (below 27 sec) | Women’s career data<\/strong><\/p>\n\n\n\n

No<\/th>Family Name<\/th>Given Name<\/th>Nation<\/th>First Year<\/th>Last Year<\/th>Races<\/th>Discipline<\/th>Total Shooting Time<\/th>Total Percent<\/th>Races<\/th><\/tr><\/thead>
No<\/th>Family Name<\/th>Given Name<\/th>Nation<\/th>First Year<\/th>Last Year<\/th>Races<\/th>Discipline<\/th>Total Shooting Time<\/th>Total Percent<\/th>Races<\/th><\/tr><\/thead>
1<\/td>Simon<\/a><\/td>Julia<\/td>FRA
<\/div><\/td>
2017<\/td>2021<\/td>80<\/td>NonTeam<\/td>25.478<\/td>77.857<\/td>80<\/td><\/tr>
2<\/td>Cadurisch<\/a><\/td>Irene<\/td>SUI
<\/div><\/td>
2012<\/td>2021<\/td>68<\/td>NonTeam<\/td>25.888<\/td>79.044<\/td>68<\/td><\/tr>
3<\/td>Kummer<\/a><\/td>Luise<\/td>GER
<\/div><\/td>
2014<\/td>2016<\/td>22<\/td>NonTeam<\/td>26.35<\/td>87.045<\/td>22<\/td><\/tr>
4<\/td>Merkushyna<\/a><\/td>Anastasiya<\/td>UKR
<\/div><\/td>
2015<\/td>2021<\/td>76<\/td>NonTeam<\/td>26.515<\/td>84.737<\/td>76<\/td><\/tr>
5<\/td>Bankes<\/a><\/td>Megan<\/td>CAN
<\/div><\/td>
2017<\/td>2021<\/td>43<\/td>NonTeam<\/td>26.629<\/td>74.39<\/td>43<\/td><\/tr>
6<\/td>Wierer<\/a><\/td>Dorothea<\/td>ITA
<\/div><\/td>
2009<\/td>2021<\/td>238<\/td>NonTeam<\/td>26.719<\/td>85.506<\/td>238<\/td><\/tr>
7<\/td>Ghilenko<\/a><\/td>Alla<\/td>MDA
<\/div><\/td>
2017<\/td>2021<\/td>36<\/td>NonTeam<\/td>26.824<\/td>79.545<\/td>36<\/td><\/tr>
8<\/td>Poje<\/a><\/td>Urska<\/td>SLO
<\/div><\/td>
2014<\/td>2020<\/td>36<\/td>NonTeam<\/td>26.868<\/td>84.583<\/td>36<\/td><\/tr><\/tbody><\/table>
<\/div><\/div><\/div><\/p>\n\n\n\n\n\n\n\n\n","protected":false},"excerpt":{"rendered":"

I have been working on a new feature that allows to search the real biathlon database for all-time records, seasonal data\/records or specific data subsets. You can search three separate categories: single races, seasons, and career statistics.<\/p>\n","protected":false},"author":5,"featured_media":1992,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[55],"class_list":["post-1989","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-website-updates","tag-data"],"_links":{"self":[{"href":"https:\/\/www.realbiathlon.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1989","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.realbiathlon.com\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.realbiathlon.com\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.realbiathlon.com\/blog\/index.php\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.realbiathlon.com\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=1989"}],"version-history":[{"count":27,"href":"https:\/\/www.realbiathlon.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1989\/revisions"}],"predecessor-version":[{"id":2021,"href":"https:\/\/www.realbiathlon.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1989\/revisions\/2021"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.realbiathlon.com\/blog\/index.php\/wp-json\/wp\/v2\/media\/1992"}],"wp:attachment":[{"href":"https:\/\/www.realbiathlon.com\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=1989"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.realbiathlon.com\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=1989"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.realbiathlon.com\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=1989"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}