In an effort to learn some SQL I've been loading a bunch of event results into some tables and am at the point where running queries is almost useful. So far I've loaded 2014-2016 results, and will gladly do more, if only I had access...
I've got some longer term goals with all of this (fancy graphs using d3.js), but for now, I'm content running searches for the sake of education. What do y'all want to know.
For example, here's a summary of penalties (indicating the June 5 2016 event was the best event ever):
Code:
Average cones/run Event totals
EventID entries run1 run2 run3 run4 run5 run6 cones dnfs
20160717 55 0.12 0.23 0.16 0.07 0.23 0.18 56 40
20160716 65 0.40 0.60 0.61 0.49 0.27 0.50 188 70
20160605 59 0.15 0.10 0.11 0.11 0.05 NULL 32 19
20160604 68 0.26 0.20 0.13 0.17 0.14 NULL 63 31
20160424 99 0.45 0.51 0.42 0.61 0.33 NULL 232 59
20160318 114 0.12 0.14 0.13 0.14 NULL NULL 61 61
20160305 87 0.25 0.39 0.32 0.27 0.32 NULL 136 105
20150927 46 0.56 0.84 0.80 0.56 0.39 NULL 146 27
20150802 58 0.25 0.18 0.27 0.41 0.27 0.41 106 34
20150718 81 0.40 0.44 0.53 0.46 0.40 NULL 183 108
20150628 67 0.25 0.22 0.20 0.17 0.19 0.14 81 101
20150627 44 0.38 0.54 0.54 0.50 0.65 0.40 134 41
20150517 94 0.41 0.54 0.40 0.47 0.36 NULL 207 32
20150426 70 0.44 0.57 0.84 0.82 0.55 NULL 227 119
20150329 75 0.77 0.72 0.68 0.76 0.52 NULL 259 42
20150308 97 0.64 0.47 0.62 0.61 0.53 NULL 282 55
20141116 84 0.42 0.27 0.39 0.29 0.36 0.29 173 58
20140914 130 0.30 0.23 0.20 0.24 0.00 NULL 128 59
20140913 81 0.38 0.22 0.22 0.17 0.29 0.00 105 83
20140830 75 0.41 0.44 0.30 0.33 0.44 0.48 181 49
20140713 69 0.26 0.30 0.43 0.43 0.59 0.23 156 41
20140628 94 0.11 0.15 0.14 0.10 0.11 NULL 61 34
20140510 87 0.45 0.70 0.64 0.96 0.74 0.49 349 113
20140301 65 0.41 0.32 0.61 0.58 0.61 0.52 200 93
Login
Register
FAQ
Search
