-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathHardAscents.sql
423 lines (416 loc) · 50.2 KB
/
HardAscents.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
drop view if exists routes;
drop table if exists ascents;
create table ascents (
ascent_id serial primary key
,route_name varchar(100) not null
,grade varchar(10) not null
,area varchar(100) not null
,country varchar(100) not null
,first_ascenionist varchar(100)
,first_ascent_date date
,climber varchar(100) not null
,ascent_date date
,style varchar(100)
,note text
,source varchar(1000)
);
insert into
ascents (route_name, grade, area, country, first_ascenionist, first_ascent_date, climber, ascent_date, style, note, source)
values
('Bibliographie','9c','Céüse','France','Alexander Megos','2020-08-05','Alexander Megos','2020-08-05','Redpoint',null,'https://www.grimper.com/news-alex-megos-enchaine-potentiel-9c-ceuse')
,('Silence','9c','Flatanger','Norway','Adam Ondra','2017-09-03','Adam Ondra','2017-09-03','Redpoint',null,null)
,('Change','9b+','Flatanger','Norway','Adam Ondra','2012-10-04','Adam Ondra','2012-10-04','Redpoint',null,null)
,('Change','9b+','Flatanger','Norway','Adam Ondra','2012-10-04','Stefano Ghisolfi','2020-09-28','Redpoint',null,'https://www.planetmountain.com/en/news/climbing/stefano-ghisolfi-repeats-change-world-first-9b-plus-flatanger-norway.html')
,('La Dura Dura','9b+','Oliana','Spain','Adam Ondra','2013-02-07','Adam Ondra','2013-02-07','Redpoint',null,null)
,('La Dura Dura','9b+','Oliana','Spain','Adam Ondra','2013-02-07','Chris Sharma','2013-03-23','Redpoint',null,null)
,('Perfecto Mundo','9b+','Margalef','Spain','Alexander Megos','2018-05-09','Alexander Megos','2018-05-09','Redpoint',null,null)
,('Perfecto Mundo','9b+','Margalef','Spain','Alexander Megos','2018-05-09','Stefano Ghisolfi','2018-12-05','Redpoint',null,null)
,('Perfecto Mundo','9b+','Margalef','Spain','Alexander Megos','2018-05-09','Jakob Schubert','2019-11-09','Redpoint',null,null)
,('Vasil Vasil','9b+','Sloup','Czechia','Adam Ondra','2013-12-04','Adam Ondra','2013-12-04','Redpoint',null,null)
,('La Rage d''Adam','9b/+','Verdon','France','Sébastien Bouin','2019-09-04','Sébastien Bouin','2019-09-04','Redpoint',null,null)
,('Move','9b/+','Flatanger','Norway','Adam Ondra','2013-08-20','Adam Ondra','2013-08-20','Redpoint',null,null)
,('Move','9b/+','Flatanger','Norway','Adam Ondra','2013-08-20','Sébastien Bouin','2019-06-17','Redpoint',null,null)
,('Akira','9b','Vilhonneur','France','Fred Rouhling','1995-01-01','Fred Rouhling','1995-01-01','Redpoint','No current access. Disputed ascent',null)
,('Ali Hulk (extension total sit start)','9b','Rodellar','Spain','Jonatan Flor','2019-07-29','Jonatan Flor','2019-07-29','Redpoint',null,null)
,('Ali Hulk (extension total sit start)','9b','Rodellar','Spain','Jonatan Flor','2019-07-29','Jorge Díaz-Rullo','2019-07-30','Redpoint',null,null)
,('Ali Hulk (extension total sit start)','9b','Rodellar','Spain','Jonatan Flor','2019-07-29','Laura Rogora','2020-07-25','Redpoint',null,'https://www.grimper.com/news-ali-hulk-sit-extension-total-9b-laura-rogora')
,('Ali Hulk (extension total sit start)','9b','Rodellar','Spain','Jonatan Flor','2019-07-29','Dani Fuertes','2020-09-20','Redpoint',null,'https://www.desnivel.com/escalada-roca/dani-fuertes-alcanza-el-9b-con-ali-hulk-extension-total-sit-start/')
,('Ali Hulk (extension total sit start)','9b','Rodellar','Spain','Jonatan Flor','2019-07-29','Dave Graham','2020-09-29','Redpoint',null,'https://www.grimper.com/news-rodellar-38-ans-dave-graham-toujours-top')
,('Ali Hulk (sitstart + extension)','9b','Rodellar','Spain','Dani Andrada','2007-01-01','Dani Andrada','2007-01-01','Redpoint',null,null)
,('Ali Hulk (sitstart + extension)','9b','Rodellar','Spain','Dani Andrada','2007-01-01','Magnus Midtbø','2010-08-01','Redpoint',null,null)
,('Ataxia hiperextension','9b','Crevillent','Spain','Jonathan Guadalcázar','2019-12-31','Jonathan Guadalcázar','2019-12-31','Redpoint','Extension of Ataxia extension...',null)
,('Chaxiraxi','9b','Oliana','Spain','Adam Ondra','2011-03-27','Adam Ondra','2011-03-27','Redpoint',null,null)
,('CRS','9b','Mollans sur Ouvèze','France','Adam Ondra','2015-11-02','Adam Ondra','2015-11-02','Redpoint',null,null)
,('Cryptography','9b','Saint-Loup','Switzerland','Alessandro Zeni','2020-05-01','Alessandro Zeni','2020-05-01','Redpoint','Link-up between Bain de sang and Bimbaluna',null)
,('Delincuente natural(extension)','9b','Rodellar','Spain','Dani Andrada','2008-09-13','Dani Andrada','2008-09-13','Redpoint',null,null)
,('Disbelief','9b','Acéphale','Canada','Adam Ondra','2018-07-01','Adam Ondra','2018-07-01','Redpoint',null,null)
,('Eagle-4','9b','Saint-Léger-du-Ventoux','France','Adam Ondra','2018-02-13','Adam Ondra','2018-02-13','Redpoint',null,null)
,('Eagle-4','9b','Saint-Léger-du-Ventoux','France','Adam Ondra','2018-02-13','Hugo Parmentier','2020-01-18','Redpoint',null,null)
,('Fight Club','9b','Raven''s crag','Canada','Alexander Megos','2016-08-14','Alexander Megos','2016-08-14','Redpoint','Tried by Ondra, possibly harder after breakage',null)
,('Fight or Flight','9b','Oliana','Spain','Chris Sharma','2011-05-05','Chris Sharma','2011-05-05','Redpoint',null,null)
,('Fight or Flight','9b','Oliana','Spain','Chris Sharma','2011-05-05','Adam Ondra','2013-02-10','Redpoint',null,null)
,('Fight or Flight','9b','Oliana','Spain','Chris Sharma','2011-05-05','Jakob Schubert','2014-12-31','Redpoint',null,null)
,('Fight or Flight','9b','Oliana','Spain','Chris Sharma','2011-05-05','Sachi Amma','2015-02-01','Redpoint',null,null)
,('Fight or Flight','9b','Oliana','Spain','Chris Sharma','2011-05-05','Matty Hong','2018-05-02','Redpoint',null,null)
,('Fight or Flight','9b','Oliana','Spain','Chris Sharma','2011-05-05','Piotr Schab','2019-04-26','Redpoint',null,null)
,('First Round First Minute','9b','Margalef','Spain','Chris Sharma','2011-04-19','Chris Sharma','2011-04-19','Redpoint',null,null)
,('First Round First Minute','9b','Margalef','Spain','Chris Sharma','2011-04-19','Adam Ondra','2014-02-03','Redpoint',null,null)
,('First Round First Minute','9b','Margalef','Spain','Chris Sharma','2011-04-19','Alexander Megos','2015-12-31','Redpoint',null,null)
,('First Round First Minute','9b','Margalef','Spain','Chris Sharma','2011-04-19','Stefano Ghisolfi','2017-01-30','Redpoint',null,null)
,('Golpe de Estado','9b','Siurana','Spain','Chris Sharma','2008-01-01','Chris Sharma','2008-01-01','Redpoint',null,null)
,('Golpe de Estado','9b','Siurana','Spain','Chris Sharma','2008-01-01','Adam Ondra','2010-03-13','Redpoint','Ondra broke a hold when working the route. Possibly harder than for FA',null)
,('Iron Curtain','9b','Flatanger','Norway','Adam Ondra','2013-08-03','Adam Ondra','2013-08-03','Redpoint',null,null)
,('Jumbo love','9b','Clark Mountain','United States','Chris Sharma','2008-09-11','Chris Sharma','2008-09-11','Redpoint',null,null)
,('Jumbo love','9b','Clark Mountain','United States','Chris Sharma','2008-09-11','Ethan Pringle','2015-05-17','Redpoint',null,null)
,('Jumbo love','9b','Clark Mountain','United States','Chris Sharma','2008-09-11','Jonathan Siegrist','2018-05-17','Redpoint',null,null)
,('La Barrière','9b','Jansegg','Switzerland','Pirmin Bertle','2018-08-26','Pirmin Bertle','2018-08-26','Redpoint',null,null)
,('La Capella','9b','Siurana','Spain','Adam Ondra','2011-02-16','Adam Ondra','2011-02-16','Redpoint',null,null)
,('La Capella','9b','Siurana','Spain','Adam Ondra','2011-02-16','Daniel Woods','2018-05-02','Redpoint',null,null)
,('La Capella','9b','Siurana','Spain','Adam Ondra','2011-02-16','Stefano Ghisolfi','2018-12-01','Redpoint',null,null)
,('La Capella','9b','Siurana','Spain','Adam Ondra','2011-02-16','William Bosi','2020-02-05','Redpoint','Only 3 days',null)
,('La Planta de Shiva','9b','Villanueva del Rosario','Spain','Adam Ondra','2011-04-17','Adam Ondra','2011-04-17','Redpoint',null,null)
,('La Planta de Shiva','9b','Villanueva del Rosario','Spain','Adam Ondra','2011-04-17','Jakob Schubert','2016-01-09','Redpoint',null,null)
,('La Planta de Shiva','9b','Villanueva del Rosario','Spain','Adam Ondra','2011-04-17','Angela Eiter','2017-10-01','Redpoint',null,null)
,('La Planta de Shiva','9b','Villanueva del Rosario','Spain','Adam Ondra','2011-04-17','Jonathan Siegrist','2019-05-05','Redpoint',null,null)
,('La Planta de Shiva','9b','Villanueva del Rosario','Spain','Adam Ondra','2011-04-17','Jorge Díaz-Rullo','2019-05-28','Redpoint',null,null)
,('Lapsus','9b','Andonno','Italy','Stefano Ghisolfi','2015-11-02','Stefano Ghisolfi','2015-11-02','Redpoint',null,null)
,('Lapsus','9b','Andonno','Italy','Stefano Ghisolfi','2015-11-02','Adam Ondra','2017-04-20','Redpoint',null,null)
,('Mamichula','9b','Oliana','Spain','Adam Ondra','2017-02-02','Adam Ondra','2017-02-02','Redpoint',null,null)
,('Mamichula','9b','Oliana','Spain','Adam Ondra','2017-02-02','Sébastien Bouin','2019-04-15','Redpoint',null,null)
,('Move Hard','9b','Flatanger','Norway','Adam Ondra','2017-07-10','Adam Ondra','2017-07-10','Redpoint',null,null)
,('Neanderthal','9b','Santa Linya','Spain','Chris Sharma','2009-12-18','Chris Sharma','2009-12-18','Redpoint',null,null)
,('Neanderthal','9b','Santa Linya','Spain','Chris Sharma','2009-12-18','Jakob Schubert','2018-01-01','Redpoint',null,null)
,('Neanderthal','9b','Santa Linya','Spain','Chris Sharma','2009-12-18','Adam Ondra','2019-02-12','Redpoint',null,null)
,('One Slap','9b','Arco','Italy','Adam Ondra','2017-11-13','Adam Ondra','2017-11-13','Redpoint',null,null)
,('One Slap','9b','Arco','Italy','Adam Ondra','2017-11-13','Stefano Ghisolfi','2017-11-22','Redpoint',null,null)
,('Queen Line','9b','Arco','Italy','Adam Ondra','2017-04-18','Adam Ondra','2017-04-18','Redpoint',null,null)
,('Queen Line','9b','Arco','Italy','Adam Ondra','2017-04-18','Stefano Ghisolfi','2019-02-26','Redpoint',null,null)
,('Rainman','9b','Malham Cove','United Kingdom','Steve McClure','2017-06-04','Steve McClure','2017-06-04','Redpoint',null,null)
,('Robin úd','9b','Alternatívna stena','Slovakia','Adam Ondra','2016-10-05','Adam Ondra','2016-10-05','Redpoint',null,null)
,('Soul Mate','9b','Okutama','Japan','Sachi Amma','2018-03-01','Sachi Amma','2018-03-01','Redpoint',null,null)
,('Soul Rock Dance','9b','“Near Seoul“','South Korea','Hyunbin Min','2020-09-29','Hyunbin Min','2020-09-29','Redpoint','FAs previously hardest route: 9a.','https://www.desnivel.com/escalada-roca/hyunbin-min-propone-9b-para-soul-rock-dance-en-corea/')
,('Stoking the fire','9b','Santa Linya','Spain','Chris Sharma','2013-02-06','Chris Sharma','2013-02-06','Redpoint',null,null)
,('Stoking the fire','9b','Santa Linya','Spain','Chris Sharma','2013-02-06','Adam Ondra','2016-02-19','Redpoint',null,null)
,('Stoking the fire','9b','Santa Linya','Spain','Chris Sharma','2013-02-06','Jakob Schubert','2018-01-05','Redpoint',null,null)
,('Stoking the fire','9b','Santa Linya','Spain','Chris Sharma','2013-02-06','Sachi Amma','2019-03-25','Redpoint',null,null)
,('Stoking the fire','9b','Santa Linya','Spain','Chris Sharma','2013-02-06','Stefano Ghisolfi','2019-12-28','Redpoint',null,null)
,('The Dream','9b','Brar','Albania','Sébastien Bouin','2019-12-16','Sébastien Bouin','2019-12-16','Redpoint','Bolted by A. Ondra',null)
,('Alasha','9a+/b','Majorque','Spain','Chris Sharma','2016-09-01','Chris Sharma','2016-09-01','Redpoint',null,null)
,('Artaburu','9a+/b','Margalef','Spain','Iker Pou','2018-12-19','Iker Pou','2018-12-19','Redpoint',null,null)
,('Catxasa (R2)','9a+/b','Santa Linya','Spain','Ramón Julián Puigblanqué','2012-06-29','Ramón Julián Puigblanqué','2012-06-29','Redpoint',null,null)
,('El bon combat','9a+/b','Cova de l''Ocell–Sant Miquel del Fai','Spain','Chris Sharma','2015-03-07','Chris Sharma','2015-03-07','Redpoint','Original grade 9b/b+',null)
,('El bon combat','9a+/b','Cova de l''Ocell–Sant Miquel del Fai','Spain','Chris Sharma','2015-03-07','Jakob Schubert','2018-12-01','Redpoint','Suggests 9a+/b',null)
,('El bon combat','9a+/b','Cova de l''Ocell–Sant Miquel del Fai','Spain','Chris Sharma','2015-03-07','Felipe Camargo','2019-04-19','Redpoint','Suggests 9b',null)
,('El bon combat','9a+/b','Cova de l''Ocell–Sant Miquel del Fai','Spain','Chris Sharma','2015-03-07','Jorge Díaz-Rullo','2020-09-28','Redpoint','Suggests 9b','https://www.desnivel.com/escalada-roca/jorge-diaz-rullo-repite-el-bon-combat-9b-en-la-cova-de-locell/')
,('Following the Leader','9a+/b','Cuenca','Spain','Pablo Barbero','2014-11-01','Jorge Díaz-Rullo','2019-10-16','Redpoint','Claims 9a+/b after breakage',null)
,('High Line','9a+/b','Kanjon Tjesno','Bosnia','Adam Ondra','2018-09-01','Adam Ondra','2018-09-01','Redpoint',null,null)
,('Las Meninas R2','9a+/b','Rodellar','Spain','Jorge Díaz-Rullo','2020-08-16','Jorge Díaz-Rullo','2020-08-16','Redpoint',null,'https://www.desnivel.com/escalada-roca/jorge-diaz-rullo-propone-9a-b-para-las-meninas-r2-en-rodellar/')
,('Las Meninas R2','9a+/b','Rodellar','Spain','Jorge Díaz-Rullo','2020-08-16','Jonatan Flor','2020-08-20','Redpoint',null,'https://www.desnivel.com/escalada-roca/jonatan-flor-repite-las-meninas-r2-9a-b-en-rodellar/')
,('Les yeux plus gros que l''antre','9a+/b','Russan','France','Sébastien Bouin','2018-04-03','Sébastien Bouin','2018-04-03','Redpoint',null,null)
,('Marina Superstar','9a+/b','Domusnovas','Italy','Adam Ondra','2009-10-01','Adam Ondra','2009-10-01','Redpoint',null,null)
,('Supernova','9a+/b','Frankenjura','Germany','Alexander Megos','2015-10-01','Alexander Megos','2015-10-01','Redpoint',null,null)
,('Torture physique','9a+/b','Gastlösen','Switzerland','Adam Ondra','2013-07-01','Adam Ondra','2013-07-01','Redpoint',null,null)
,('Viscious circle','9a+/b','Osp','Slovenia','Adam Ondra','2016-03-25','Adam Ondra','2016-03-25','Redpoint',null,null)
,('120 Degrees','9a+','Flatanger','Norway','Adam Ondra','2016-06-16','Adam Ondra','2016-06-16','Redpoint',null,null)
,('Ali Hulk (extension total)','9a+','Rodellar','Spain','Piotr Schab','2018-07-01','Piotr Schab','2018-07-01','Redpoint',null,null)
,('Ali Hulk (extension total)','9a+','Rodellar','Spain','Piotr Schab','2018-07-01','Jonatan Flor','2019-07-15','Redpoint',null,null)
,('Ali Hulk (extension total)','9a+','Rodellar','Spain','Piotr Schab','2018-07-01','Álex Garriga','2019-09-28','Redpoint',null,null)
,('Ali Hulk (extension total)','9a+','Rodellar','Spain','Piotr Schab','2018-07-01','Dani Fuertes','2020-09-14','Redpoint',null,'https://www.desnivel.com/escalada-roca/dani-fuertes-encadena-ali-hulk-extension-total-9a-en-rodellar/')
,('Ali Hulk (extension)','9a+','Rodellar','Spain','Dani Andrada','2007-09-12','Dani Andrada','2007-09-12','Redpoint',null,null)
,('Ali Hulk (extension)','9a+','Rodellar','Spain','Dani Andrada','2007-09-12','Magnus Midtbø','2010-01-01','Redpoint',null,null)
,('Ali Hulk (extension)','9a+','Rodellar','Spain','Dani Andrada','2007-09-12','Danilo Pereyra','2011-09-20','Redpoint',null,null)
,('Ali Hulk (extension)','9a+','Rodellar','Spain','Dani Andrada','2007-09-12','Dimitri Sharafutdinov','2012-07-27','Redpoint',null,null)
,('Ali Hulk (extension)','9a+','Rodellar','Spain','Dani Andrada','2007-09-12','Jorge Díaz-Rullo','2017-08-12','Redpoint',null,null)
,('Ali Hulk (extension)','9a+','Rodellar','Spain','Dani Andrada','2007-09-12','Piotr Schab','2018-07-01','Redpoint',null,null)
,('Ali Hulk (extension)','9a+','Rodellar','Spain','Dani Andrada','2007-09-12','Enrique Gallardo','2020-09-30','Redpoint',null,'https://www.desnivel.com/escalada-roca/enrique-gallardo-se-sube-al-9a-de-ali-hulk-extension-no-entraba-en-mis-planes/')
,('Ali Hulk (fin de extension total sitstart)','9a+','Rodellar','Spain',null,null,'Jorge Díaz-Rullo','2019-08-07','Redpoint',null,'https://escalando.eu/17180/jorge-diaz-rullo-se-hace-con-la-primera-de-fin-de-ali-hulk-extension-sit-start-un-nuevo-9a-en-la-cueva-de-rodellar/')
,('Ali Hulk (fin de extension total sitstart)','9a+','Rodellar','Spain',null,null,'Dave Graham','2020-09-28','Redpoint',null,'https://www.desnivel.com/escalada-roca/dave-graham-repite-fin-de-ali-extension-sit-start-9a-en-rodellar/')
,('Ali Hulk (fin de extension total sitstart)','9a+','Rodellar','Spain',null,null,'Dani Fuertes','2020-10-06','Redpoint',null,'https://www.desnivel.com/escalada-roca/dani-fuertes-se-regala-otro-9a-para-su-40-cumpleanos/')
,('Ali Hulk (sitstart)','9a+','Rodellar','Spain','Dani Andrada','2006-09-11','Dani Andrada','2006-09-11','Redpoint',null,null)
,('Ali Hulk (sitstart)','9a+','Rodellar','Spain','Dani Andrada','2006-09-11','Magnus Midtbø','2010-01-01','Redpoint',null,null)
,('All you can eat','9a+','Mount Potasi','United States','Jonathan Siegrist','2019-03-29','Jonathan Siegrist','2019-03-29','Redpoint',null,null)
,('Apocalipsis de la Gioconda','9a+','Rodellar','Spain','Jonatan Flor','2019-08-26','Jonatan Flor','2019-08-26','Redpoint','Originally given 9b downgraded by 2nd ascensionist',null)
,('Apocalipsis de la Gioconda','9a+','Rodellar','Spain','Jonatan Flor','2019-08-26','Jose Luis Palao','2020-06-29','Redpoint','Downgraded to 9a+ from 9b',null)
,('Apocalipsis de la Gioconda','9a+','Rodellar','Spain','Jonatan Flor','2019-08-26','Jorge Díaz-Rullo','2020-08-18','Redpoint','Agrees with 9a+','https://www.desnivel.com/escalada-roca/jorge-diaz-rullo-tacha-apocalipsis-de-la-gioconda-9a-en-rodellar/')
,('Ataxia Extension','9a+','Crevillent','Spain','Jonathan Guadalcázar','2019-10-01','Jonathan Guadalcázar','2019-10-01','Redpoint',null,null)
,('Aubade directe','9a+','Montagne Sainte-Victoire','France','Gérôme Pouvreau','2010-09-27','Gérôme Pouvreau','2010-09-27','Redpoint',null,null)
,('Aubade directe','9a+','Montagne Sainte-Victoire','France','Gérôme Pouvreau','2010-09-27','Enzo Oddo','2011-05-10','Redpoint',null,null)
,('Aubade directe','9a+','Montagne Sainte-Victoire','France','Gérôme Pouvreau','2010-09-27','Anatole Bosio','2020-10-11','Redpoint',null,'https://www.grimper.com/news-anatole-bosio-coche-9a-mythique-sainte-victoire')
,('Becoming','9a+','Frankenjura','Germany','Markus Bock','2014-06-30','Markus Bock','2014-06-30','Redpoint',null,null)
,('Becoming','9a+','Frankenjura','Germany','Markus Bock','2014-06-30','Alexander Megos','2016-10-01','Redpoint',null,null)
,('Big men','9a+','Fraguel','Spain','Iker Pou','2015-04-01','Iker Pou','2015-04-01','Redpoint',null,null)
,('Biographie/Realization','9a+','Céüse','France','Chris Sharma','2002-07-18','Chris Sharma','2002-07-18','Redpoint',null,null)
,('Biographie/Realization','9a+','Céüse','France','Chris Sharma','2002-07-18','Sylvain Millet','2004-05-24','Redpoint',null,null)
,('Biographie/Realization','9a+','Céüse','France','Chris Sharma','2002-07-18','Patxi Usobiaga','2004-07-29','Redpoint',null,null)
,('Biographie/Realization','9a+','Céüse','France','Chris Sharma','2002-07-18','Dave Graham','2007-07-30','Redpoint',null,null)
,('Biographie/Realization','9a+','Céüse','France','Chris Sharma','2002-07-18','Ethan Pringle','2007-09-03','Redpoint',null,null)
,('Biographie/Realization','9a+','Céüse','France','Chris Sharma','2002-07-18','Ramón Julián Puigblanqué','2008-07-28','Redpoint',null,null)
,('Biographie/Realization','9a+','Céüse','France','Chris Sharma','2002-07-18','Enzo Oddo','2010-08-17','Redpoint',null,null)
,('Biographie/Realization','9a+','Céüse','France','Chris Sharma','2002-07-18','Jonathan Siegrist','2014-06-01','Redpoint',null,null)
,('Biographie/Realization','9a+','Céüse','France','Chris Sharma','2002-07-18','Alexander Megos','2014-07-01','Redpoint',null,null)
,('Biographie/Realization','9a+','Céüse','France','Chris Sharma','2002-07-18','Adam Ondra','2014-07-23','Redpoint',null,null)
,('Biographie/Realization','9a+','Céüse','France','Chris Sharma','2002-07-18','Sachi Amma','2014-08-01','Redpoint',null,null)
,('Biographie/Realization','9a+','Céüse','France','Chris Sharma','2002-07-18','Stefano Ghisolfi','2015-06-21','Redpoint',null,null)
,('Biographie/Realization','9a+','Céüse','France','Chris Sharma','2002-07-18','Jon Cardwell','2016-05-25','Redpoint',null,null)
,('Biographie/Realization','9a+','Céüse','France','Chris Sharma','2002-07-18','Sean Bailey','2016-08-03','Redpoint',null,null)
,('Biographie/Realization','9a+','Céüse','France','Chris Sharma','2002-07-18','Margo Hayes','2017-09-24','Redpoint',null,null)
,('Biographie/Realization','9a+','Céüse','France','Chris Sharma','2002-07-18','Piotr Schab','2018-06-09','Redpoint',null,null)
,('Biographie/Realization','9a+','Céüse','France','Chris Sharma','2002-07-18','Stefano Carnati','2018-09-21','Redpoint',null,null)
,('Biographie/Realization','9a+','Céüse','France','Chris Sharma','2002-07-18','Jorge Díaz-Rullo','2019-07-13','Redpoint',null,null)
,('Biographie/Realization','9a+','Céüse','France','Chris Sharma','2002-07-18','Sébastien Bouin','2020-06-13','Redpoint',null,null)
,('Black Bock','9a+','Cuenca','Spain','Luis Alfonso Felix','2011-12-02','Luis Alfonso Felix','2011-12-02','Redpoint',null,null)
,('Catxasa','9a+','Santa Linya','Spain','Chris Sharma','2011-01-13','Chris Sharma','2011-01-13','Redpoint',null,null)
,('Catxasa','9a+','Santa Linya','Spain','Chris Sharma','2011-01-13','Ramón Julián Puigblanqué','2012-06-01','Redpoint',null,null)
,('Catxasa','9a+','Santa Linya','Spain','Chris Sharma','2011-01-13','Sachi Amma','2015-02-15','Redpoint',null,null)
,('Catxasa','9a+','Santa Linya','Spain','Chris Sharma','2011-01-13','Jakob Schubert','2018-01-09','Redpoint',null,null)
,('Catxasa','9a+','Santa Linya','Spain','Chris Sharma','2011-01-13','Piotr Schab','2018-04-09','Redpoint',null,null)
,('Catxasa','9a+','Santa Linya','Spain','Chris Sharma','2011-01-13','Jakub Konecny','2018-12-31','Redpoint',null,null)
,('Catxasa','9a+','Santa Linya','Spain','Chris Sharma','2011-01-13','Adam Ondra','2019-02-08','Redpoint',null,null)
,('Catxasa','9a+','Santa Linya','Spain','Chris Sharma','2011-01-13','Sébastien Bouin','2020-02-09','Redpoint','Says 9a with knee-pads. Edu Marin agrees',null)
,('Celedon','9a+','Ilarduia','Spain','Iker Pou','2012-09-21','Iker Pou','2012-09-21','Redpoint',null,null)
,('Celedon','9a+','Ilarduia','Spain','Iker Pou','2012-09-21','David Gambús','2012-10-29','Redpoint',null,null)
,('Chaxi','9a+','Oliana','Spain','Adam Ondra','2011-01-01','Adam Ondra','2011-03-01','Redpoint',null,null)
,('Chaxi','9a+','Oliana','Spain','Adam Ondra','2011-03-01','Chris Sharma','2011-05-07','Redpoint',null,null)
,('Chaxi','9a+','Oliana','Spain','Adam Ondra','2011-03-01','Cédric Lachat','2013-01-16','Redpoint',null,null)
,('Chaxi','9a+','Oliana','Spain','Adam Ondra','2011-03-01','Jonathan Siegrist','2017-04-26','Redpoint',null,null)
,('Chilam Balam','9a+','Villanueva del Rosario','Spain','Bernabé Fernández','2003-01-01','Bernabé Fernández','2003-01-01','Redpoint','Claimed at 9b+. Widely disbelieved FA with mystery belayer.',null)
,('Chilam Balam','9a+','Villanueva del Rosario','Spain','Bernabé Fernández','2003-01-01','Adam Ondra','2011-04-13','Redpoint','Downgrade to 9a+/b',null)
,('Chilam Balam','9a+','Villanueva del Rosario','Spain','Bernabé Fernández','2003-01-01','Sébastien Bouin','2015-05-28','Redpoint','Says hard 9a+ or easy 9b',null)
,('Chilam Balam','9a+','Villanueva del Rosario','Spain','Bernabé Fernández','2003-01-01','Dani Andrada','2015-11-01','Redpoint','Agrees on 9a+ or b',null)
,('Chilam Balam','9a+','Villanueva del Rosario','Spain','Bernabé Fernández','2003-01-01','Edu Marin','2015-11-01','Redpoint','agrees on 9a+',null)
,('Chilam Balam','9a+','Villanueva del Rosario','Spain','Bernabé Fernández','2003-01-01','Sindre Sæther','2019-12-01','Redpoint',null,null)
,('Clash of the Titans','9a+','Götterwandl','Austria','Alexander Megos','2017-06-18','Alexander Megos','2017-06-18','Redpoint',null,null)
,('Classified','9a+','Frankenjura','Germany','Alexander Megos','2013-04-01','Alexander Megos','2013-04-01','Redpoint',null,null)
,('Companion of Change','9a+','Zillertal','Austria','Jakob Schubert','2015-11-18','Jakob Schubert','2015-11-18','Redpoint',null,null)
,('Companion of Change','9a+','Zillertal','Austria','Jakob Schubert','2015-11-18','Alexander Megos','2017-06-01','Redpoint',null,null)
,('Corona','9a+','Frankenjura','Germany','Markus Bock','2006-01-01','Markus Bock','2006-01-01','Redpoint',null,null)
,('Corona','9a+','Frankenjura','Germany','Markus Bock','2006-01-01','Adam Ondra','2009-06-08','Redpoint',null,null)
,('Corona','9a+','Frankenjura','Germany','Markus Bock','2006-01-01','Alexander Megos','2013-05-13','Redpoint',null,null)
,('Corona','9a+','Frankenjura','Germany','Markus Bock','2006-01-01','Felix Neumärker','2014-03-21','Redpoint',null,null)
,('Corona','9a+','Frankenjura','Germany','Markus Bock','2006-01-01','Daniel Jung','2016-10-23','Redpoint',null,null)
,('Corona','9a+','Frankenjura','Germany','Markus Bock','2006-01-01','Dai Koyamada','2016-10-28','Redpoint',null,null)
,('Czech Trip','9a+','Mavrovo','Macedonia','Adam Ondra','2018-12-19','Adam Ondra','2018-12-19','Redpoint',null,null)
,('Deep Spot','9a+','La Balme de Yenne','France','Mathieu Bouyoud','2015-08-08','Mathieu Bouyoud','2015-08-08','Redpoint',null,null)
,('Demencia Senil','9a+','Margalef','Spain','Chris Sharma','2009-02-01','Chris Sharma','2009-02-01','Redpoint',null,null)
,('Demencia Senil','9a+','Margalef','Spain','Chris Sharma','2009-02-01','Iker Pou','2010-01-01','Redpoint',null,null)
,('Demencia Senil','9a+','Margalef','Spain','Chris Sharma','2009-02-01','Ramón Julián Puigblanqué','2010-10-12','Redpoint',null,null)
,('Demencia Senil','9a+','Margalef','Spain','Chris Sharma','2009-02-01','Stefano Ghisolfi','2015-03-14','Redpoint',null,null)
,('Demencia Senil','9a+','Margalef','Spain','Chris Sharma','2009-02-01','Stefano Carnati','2019-12-22','Redpoint',null,null)
,('Der Lange Atem','9a+','Höllental','Austria','Arthur Kubista','2009-10-31','Arthur Kubista','2009-10-31','Redpoint',null,null)
,('Dugi Rat','9a+','Vrulja','Croatia','Jernej Kruder','2018-12-31','Jernej Kruder','2018-12-31','Redpoint',null,null)
,('Empreintes','9a+','Saint Pierre de Faucigny','France','Fred Rouhling','2008-01-01','Fred Rouhling','2008-01-01','Redpoint',null,null)
,('Energia Cosmica','9a+','Bilico','Italy','Alessandro Zeni','2018-11-01','Alessandro Zeni','2018-11-01','Redpoint',null,null)
,('Es Pontas','9a+','Majorque','Spain','Chris Sharma','2006-01-01','Chris Sharma','2006-01-01','Redpoint','DWS',null)
,('Es Pontas','9a+','Majorque','Spain','Chris Sharma','2006-01-01','Jernej Kruder','2016-11-01','Redpoint','DWS',null)
,('Es Pontas','9a+','Majorque','Spain','Chris Sharma','2006-01-01','Jan Hojer','2018-10-01','Redpoint','DWS',null)
,('First Ley','9a+','Margalef','Spain','Chris Sharma','2010-03-02','Chris Sharma','2010-03-02','Redpoint',null,null)
,('First Ley','9a+','Margalef','Spain','Chris Sharma','2010-03-02','Alexander Megos','2016-01-01','Redpoint',null,null)
,('First Ley','9a+','Margalef','Spain','Chris Sharma','2010-03-02','Mateusz Haladaj','2016-03-31','Redpoint',null,null)
,('First Ley','9a+','Margalef','Spain','Chris Sharma','2010-03-02','Stefano Ghisolfi','2017-01-12','Redpoint',null,null)
,('First Ley','9a+','Margalef','Spain','Chris Sharma','2010-03-02','Daniel Woods','2018-03-12','Redpoint',null,null)
,('First Ley','9a+','Margalef','Spain','Chris Sharma','2010-03-02','Shawn Raboutou','2018-04-30','Redpoint',null,null)
,('Flat Mountain','9a+','Fugato','Japan','Yuji Hirayama','2003-03-01','Yuji Hirayama','2003-03-01','Redpoint',null,null)
,('Flat Mountain','9a+','Fugato','Japan','Yuji Hirayama','2003-03-01','Toru Nakajima','2012-12-01','Redpoint',null,null)
,('Flat Mountain','9a+','Fugato','Japan','Yuji Hirayama','2003-03-01','Alexander Megos','2015-03-01','Redpoint',null,null)
,('Flex Luthor','9a+','Rifle','United States','Tommy Caldwell','2003-01-01','Tommy Caldwell','2003-01-01','Redpoint',null,null)
,('Following the Leader','9a+','Cuenca','Spain','Pablo Barbero','2014-11-01','Pablo Barbero','2014-11-01','Redpoint',null,null)
,('Following the Leader','9a+','Cuenca','Spain','Pablo Barbero','2014-11-01','Ramón Julián Puigblanqué','2015-04-01','Redpoint',null,null)
,('Goldrake','9a+','Cornalba','Italy','Adam Ondra','2010-04-07','Adam Ondra','2010-04-07','Redpoint',null,null)
,('Goldrake','9a+','Cornalba','Italy','Adam Ondra','2010-04-07','Gabriele Moroni','2014-10-29','Redpoint',null,null)
,('Goldrake','9a+','Cornalba','Italy','Adam Ondra','2010-04-07','Stefano Carnati','2016-03-20','Redpoint',null,null)
,('Goldrake','9a+','Cornalba','Italy','Adam Ondra','2010-04-07','Stefano Ghisolfi','2016-04-03','Redpoint',null,null)
,('Goldrake','9a+','Cornalba','Italy','Adam Ondra','2010-04-07','Silvio Reffo','2016-05-15','Redpoint',null,null)
,('Hellracer','9a+','Hell','Norway','Adam Ondra','2013-09-22','Adam Ondra','2013-09-22','Redpoint',null,null)
,('Hyper finale','9a+','Rawyl','Switzerland','Adam Ondra','2016-07-17','Adam Ondra','2016-07-17','Redpoint',null,null)
,('Jaws II','9a+','Rumney','United States','Vasya Vorotnikov','2007-10-14','Vasya Vorotnikov','2007-10-14','Redpoint',null,null)
,('Jaws II','9a+','Rumney','United States','Vasya Vorotnikov','2007-10-14','Daniel Woods','2010-10-05','Redpoint',null,null)
,('Jaws II','9a+','Rumney','United States','Vasya Vorotnikov','2007-10-14','Mike Foley','2011-07-25','Redpoint',null,null)
,('Jaws II','9a+','Rumney','United States','Vasya Vorotnikov','2007-10-14','Andrew Palmer','2013-10-20','Redpoint',null,null)
,('Jaws II','9a+','Rumney','United States','Vasya Vorotnikov','2007-10-14','Paul Robinson','2013-10-30','Redpoint',null,null)
,('Jaws II','9a+','Rumney','United States','Vasya Vorotnikov','2007-10-14','Alexander Megos','2017-10-10','Redpoint',null,null)
,('Jaws II','9a+','Rumney','United States','Vasya Vorotnikov','2007-10-14','Tristan Chen','2018-08-31','Redpoint',null,null)
,('Joe Mama','9a+','Oliana','Spain','Klemen Becan','2016-03-01','Klemen Becan','2016-03-01','Redpoint',null,null)
,('Joe Mama','9a+','Oliana','Spain','Klemen Becan','2016-03-01','Chris Sharma','2016-10-01','Redpoint',null,null)
,('Joe Mama','9a+','Oliana','Spain','Klemen Becan','2016-03-01','Jakob Schubert','2016-12-27','Redpoint',null,null)
,('Joe Mama','9a+','Oliana','Spain','Klemen Becan','2016-03-01','Matty Hong','2017-03-17','Redpoint',null,null)
,('Joe Mama','9a+','Oliana','Spain','Klemen Becan','2016-03-01','Jonathan Siegrist','2017-04-20','Redpoint',null,null)
,('Joe Mama','9a+','Oliana','Spain','Klemen Becan','2016-03-01','Jon Cardwell','2019-02-27','Redpoint',null,null)
,('Joe Mama','9a+','Oliana','Spain','Klemen Becan','2016-03-01','Sean Bailey','2019-03-03','Redpoint',null,null)
,('Joe Mama','9a+','Oliana','Spain','Klemen Becan','2016-03-01','Anak Verhoeven','2019-11-07','Redpoint','More solid 9a+ after recent breakage',null)
,('Joe Mama','9a+','Oliana','Spain','Klemen Becan','2016-03-01','Sébastien Bouin','2020-02-07','Redpoint','Says 9a(+) on instagram',null)
,('Joe Mama','9a+','Oliana','Spain','Klemen Becan','2016-03-01','Cédric Lachat','2020-02-07','Redpoint','Says easy 9a+',null)
,('Joe Mama','9a+','Oliana','Spain','Klemen Becan','2016-03-01','Piotr Schab','2020-03-01','Redpoint',null,null)
,('Joe Mama','9a+','Oliana','Spain','Klemen Becan','2016-03-01','Jorge Díaz-Rullo','2020-03-07','Redpoint',null,null)
,('Jungle Boogie','9a+','Céüse','France','Adam Ondra','2012-06-07','Adam Ondra','2012-06-07','Redpoint',null,null)
,('Jungle Boogie','9a+','Céüse','France','Adam Ondra','2012-06-07','Sachi Amma','2015-09-01','Redpoint',null,null)
,('Jungle Boogie','9a+','Céüse','France','Adam Ondra','2012-06-07','Stefano Ghisolfi','2016-10-03','Redpoint',null,null)
,('Jungle Boogie','9a+','Céüse','France','Adam Ondra','2012-06-07','Alexander Megos','2017-06-21','Redpoint',null,null)
,('Jungle Boogie','9a+','Céüse','France','Adam Ondra','2012-06-07','Stefano Carnati','2020-07-06','Redpoint',null,null)
,('Kangoroo''s Limb','9a+','Flatanger','Norway','Adam Ondra','2013-09-21','Adam Ondra','2013-09-21','Redpoint',null,null)
,('Kangoroo''s Limb','9a+','Flatanger','Norway','Adam Ondra','2013-09-21','Jakob Schubert','2016-05-01','Redpoint',null,null)
,('Kmira','9a+','Pic St Loup','France','Sébastien Bouin','2015-07-09','Sébastien Bouin','2015-07-09','Redpoint',null,null)
,('L''étrange ivresse des lenteurs','9a+','Céüse','France','Adam Ondra','2010-09-06','Adam Ondra','2010-09-06','Redpoint',null,null)
,('L''étrange ivresse des lenteurs','9a+','Céüse','France','Adam Ondra','2010-09-06','Alexander Megos','2020-09-07','Redpoint','Claims 9a/b and much harder than other 9a+ at Céüse','https://www.desnivel.com/escalada-roca/alex-megos-propone-subir-a-9a-b-letrange-ivresse-des-lenteurs/')
,('La Castagne','9a+','Saint-Léger-du-Ventoux','France','Adam Ondra','2018-02-03','Adam Ondra','2018-02-03','Redpoint',null,null)
,('La Cène du Lézard','9a+','Jansegg','Switzerland','Pirmin Bertle','2017-12-01','Pirmin Bertle','2017-12-01','Redpoint',null,null)
,('La Cène du Lézard','9a+','Jansegg','Switzerland','Pirmin Bertle','2017-12-01','Cédric Lachat','2018-10-01','Redpoint',null,null)
,('La Côte d''Usure','9a+','Verdon','France','Sébastien Bouin','2018-09-23','Sébastien Bouin','2018-09-23','Redpoint',null,null)
,('La Madone','9a+','Lourmarin','France','Gérôme Pouvreau','2011-06-18','Gérôme Pouvreau','2011-06-18','Redpoint',null,null)
,('La Madone','9a+','Lourmarin','France','Gérôme Pouvreau','2011-06-18','Sébastien Bouin','2012-05-20','Redpoint',null,null)
,('La Moustache qui fâche','9a+','Entraygues','France','Enzo Oddo','2011-06-16','Enzo Oddo','2011-06-16','Redpoint',null,null)
,('La Moustache qui fâche','9a+','Entraygues','France','Enzo Oddo','2011-06-16','Stefano Ghisolfi','2014-08-23','Redpoint',null,null)
,('La Moustache qui fâche','9a+','Entraygues','France','Enzo Oddo','2011-06-16','Hugo Parmentier','2019-07-30','Redpoint',null,null)
,('La Moustache qui fâche','9a+','Entraygues','France','Enzo Oddo','2011-06-16','Sébastien Bouin','2020-08-28','Redpoint',null,'https://www.grimper.com/news-la-moustache-fache-9a-seb-bouin')
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Ramón Julián Puigblanqué','2003-03-08','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Edu Marin','2006-11-30','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Chris Sharma','2006-12-01','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Andreas Bindhammer','2007-05-02','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Patxi Usobiaga','2007-11-27','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Adam Ondra','2008-02-10','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Enzo Oddo','2011-12-23','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Sachi Amma','2012-11-29','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Felix Neumärker','2013-03-19','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Alexander Megos','2013-03-29','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Sangwon Son','2013-12-01','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Daniel Jung','2014-01-01','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Jonathan Siegrist','2015-03-05','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','David Firnenburg','2017-02-10','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Matty Hong','2017-02-25','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Margo Hayes','2017-02-26','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Stefano Ghisolfi','2017-03-21','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Jacopo Larcher','2017-03-21','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Klemen Becan','2017-04-15','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Sébastien Bouin','2017-12-06','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Tomas Ravanal','2018-01-10','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Gerard Rull','2018-02-23','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Jon Cardwell','2018-03-04','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Piotr Schab','2019-02-08','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Dave Graham','2019-03-02','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Gonzalo Larrocha','2019-03-16','Redpoint',null,null)
,('La Rambla','9a+','Siurana','Spain','Ramón Julián Puigblanqué','2003-03-08','Cédric Lachat','2019-11-01','Redpoint',null,null)
,('Le Vent Nous Portera','9a+','Socaire','Chile','Pirmin Bertle','2017-10-01','Pirmin Bertle','2017-10-01','Redpoint',null,null)
,('Licht une Schatten','9a+','Telli','Switzerland','Stefan Schibli','2015-11-15','Stefan Schibli','2015-11-15','Redpoint',null,null)
,('Maturity','9a+','Gozen-iwa','Japan','Sachi Amma','2017-12-01','Sachi Amma','2017-12-01','Redpoint',null,null)
,('Maya','9a+','Margalef','Spain','Ramón Julián Puigblanqué','2016-09-10','Ramón Julián Puigblanqué','2016-09-10','Redpoint',null,null)
,('Me, I eat dust','9a+','Austin Hill Country','United States','Cody Roth','2017-01-01','Cody Roth','2017-01-01','Redpoint','Secret crag, originally reported as 9a. Upgraded without repeats a year later?',null)
,('Meiose','9a+','Charmey','Switzerland','Pirmin Bertle','2015-11-19','Pirmin Bertle','2015-11-19','Redpoint',null,null)
,('Meiose','9a+','Charmey','Switzerland','Pirmin Bertle','2015-11-19','Adam Ondra','2018-01-27','Redpoint',null,null)
,('Minimalomania','9a+','Lindental','Switzerland','Pirmin Bertle','2013-03-01','Pirmin Bertle','2013-03-01','Redpoint',null,null)
,('Modified','9a+','Frankenjura','Germany','Alexander Megos','2014-06-17','Alexander Megos','2014-06-17','Redpoint',null,null)
,('Modified','9a+','Frankenjura','Germany','Alexander Megos','2014-06-17','Adam Ondra','2015-10-28','Redpoint',null,null)
,('Modified','9a+','Frankenjura','Germany','Alexander Megos','2014-06-17','David Firnenburg','2018-11-01','Redpoint',null,null)
,('Mona Lisa Integral','9a+','Rodellar','Spain','Jose Luis Palao','2020-06-14','Jose Luis Palao','2020-06-14','Redpoint',null,null)
,('Naturalmente','9a+','Camaiore','Italy','Adam Ondra','2017-04-21','Adam Ondra','2017-04-21','Redpoint',null,null)
,('Nit de Bruixes','9a+','Margalef','Spain','Iker Pou','2012-01-11','Iker Pou','2012-01-11','Redpoint',null,null)
,('Nit de Bruixes','9a+','Margalef','Spain','Iker Pou','2012-01-11','Ramón Julián Puigblanqué','2012-07-01','Redpoint',null,null)
,('Obrint el sistema','9a+','Santa Ana','Spain','Adam Ondra','2011-03-14','Adam Ondra','2011-03-14','Redpoint',null,null)
,('One Punch','9a+','Arco','Italy','Stefano Ghisolfi','2017-05-01','Stefano Ghisolfi','2017-05-01','Redpoint',null,null)
,('One Punch','9a+','Arco','Italy','Stefano Ghisolfi','2017-05-01','Adam Ondra','2017-11-01','Redpoint',null,null)
,('Open Air','9a+','Schleierwasserfall','Austria','Alexander Huber','1996-01-01','Alexander Huber','1996-01-01','Redpoint',null,null)
,('Open Air','9a+','Schleierwasserfall','Austria','Alexander Huber','1996-01-01','Adam Ondra','2008-11-17','Redpoint',null,null)
,('Orujo','9a+','Archidona','Spain','Bernabé Fernández','1998-01-01','Bernabé Fernández','1998-01-01','Redpoint','Disputed ascent',null)
,('Outro','9a+','Achleiten','Austria','Roland Hemetzberger','2015-12-01','Roland Hemetzberger','2015-12-01','Redpoint',null,null)
,('Overshadow','9a+','Malham Cove','United Kingdom','Steve McClure','2007-05-28','Steve McClure','2007-05-28','Redpoint',null,null)
,('Overshadow','9a+','Malham Cove','United Kingdom','Steve McClure','2007-05-28','Adam Ondra','2011-05-17','Redpoint',null,null)
,('Pachamama','9a+','Oliana','Spain','Chris Sharma','2009-01-01','Chris Sharma','2009-05-31','Redpoint',null,null)
,('Pachamama','9a+','Oliana','Spain','Chris Sharma','2009-01-01','Sachi Amma','2011-12-18','Redpoint',null,null)
,('Pachamama','9a+','Oliana','Spain','Chris Sharma','2009-01-01','Ramón Julián Puigblanqué','2015-04-03','Redpoint',null,null)
,('Pachamama','9a+','Oliana','Spain','Chris Sharma','2009-01-01','Jakob Schubert','2017-01-02','Redpoint',null,null)
,('Pachamama','9a+','Oliana','Spain','Chris Sharma','2009-01-01','Adam Ondra','2017-02-03','Redpoint',null,null)
,('Pachamama','9a+','Oliana','Spain','Chris Sharma','2009-01-01','Jonathan Siegrist','2017-04-12','Redpoint',null,null)
,('Pachamama','9a+','Oliana','Spain','Chris Sharma','2009-01-01','Patxi Usobiaga','2017-11-10','Redpoint',null,null)
,('Pachamama','9a+','Oliana','Spain','Chris Sharma','2009-01-01','Sébastien Bouin','2019-03-05','Redpoint',null,null)
,('Pachamama','9a+','Oliana','Spain','Chris Sharma','2009-01-01','Cédric Lachat','2020-01-19','Redpoint','Exact date not known.',null)
,('Panorama','9a+','Patones','Spain','Jorge Díaz-Rullo','2018-07-15','Jorge Díaz-Rullo','2018-07-15','Redpoint',null,null)
,('Papichulo','9a+','Oliana','Spain','Chris Sharma','2008-05-31','Chris Sharma','2008-05-31','Redpoint',null,null)
,('Papichulo','9a+','Oliana','Spain','Chris Sharma','2008-05-31','Adam Ondra','2009-02-24','Redpoint',null,null)
,('Papichulo','9a+','Oliana','Spain','Chris Sharma','2008-05-31','Ramón Julián Puigblanqué','2009-03-23','Redpoint',null,null)
,('Papichulo','9a+','Oliana','Spain','Chris Sharma','2008-05-31','Sachi Amma','2010-12-25','Redpoint',null,null)
,('Papichulo','9a+','Oliana','Spain','Chris Sharma','2008-05-31','Cédric Lachat','2011-04-03','Redpoint',null,null)
,('Papichulo','9a+','Oliana','Spain','Chris Sharma','2008-05-31','Jakob Schubert','2011-04-27','Redpoint',null,null)
,('Papichulo','9a+','Oliana','Spain','Chris Sharma','2008-05-31','Domen Skofic','2014-12-12','Redpoint',null,null)
,('Papichulo','9a+','Oliana','Spain','Chris Sharma','2008-05-31','Magnus Midtbø','2015-03-22','Redpoint',null,null)
,('Papichulo','9a+','Oliana','Spain','Chris Sharma','2008-05-31','Mateusz Haladaj','2015-05-30','Redpoint',null,null)
,('Papichulo','9a+','Oliana','Spain','Chris Sharma','2008-05-31','Jonathan Siegrist','2015-11-18','Redpoint',null,null)
,('Papichulo','9a+','Oliana','Spain','Chris Sharma','2008-05-31','Daniel Woods','2016-03-03','Redpoint',null,null)
,('Papichulo','9a+','Oliana','Spain','Chris Sharma','2008-05-31','Matty Hong','2016-03-23','Redpoint',null,null)
,('Papichulo','9a+','Oliana','Spain','Chris Sharma','2008-05-31','Said Belhaj','2016-04-01','Redpoint','Widely questioned',null)
,('Papichulo','9a+','Oliana','Spain','Chris Sharma','2008-05-31','Piotr Schab','2016-04-17','Redpoint',null,null)
,('Papichulo','9a+','Oliana','Spain','Chris Sharma','2008-05-31','Klemen Becan','2016-06-01','Redpoint',null,null)
,('Papichulo','9a+','Oliana','Spain','Chris Sharma','2008-05-31','Patxi Usobiaga','2017-03-31','Redpoint',null,null)
,('Papichulo','9a+','Oliana','Spain','Chris Sharma','2008-05-31','Jon Cardwell','2017-04-12','Redpoint',null,null)
,('Papichulo','9a+','Oliana','Spain','Chris Sharma','2008-05-31','Felipe Camargo','2017-04-22','Redpoint',null,null)
,('Papichulo','9a+','Oliana','Spain','Chris Sharma','2008-05-31','Margo Hayes','2019-03-22','Redpoint',null,null)
,('Papichulo','9a+','Oliana','Spain','Chris Sharma','2008-05-31','Kamil Ferenc','2019-04-15','Redpoint','Give or take a day for date',null)
,('Papichulo','9a+','Oliana','Spain','Chris Sharma','2008-05-31','Sébastien Bouin','2019-04-18','Redpoint',null,null)
,('Papichulo','9a+','Oliana','Spain','Chris Sharma','2008-05-31','David Firnenburg','2020-01-18','Redpoint',null,null)
,('Patanics','9a+','Rodellar','Spain','Jorge Díaz-Rullo','2019-08-26','Jorge Díaz-Rullo','2019-08-26','Redpoint','Claimed at 9b',null)
,('Patanics','9a+','Rodellar','Spain','Jorge Díaz-Rullo','2019-08-26','Sébastien Bouin','2019-10-30','Redpoint','Downgraded from 9b. Says 9a+ or easier',null)
,('Patanics','9a+','Rodellar','Spain','Jorge Díaz-Rullo','2019-08-26','Jonatan Flor','2020-07-03','Redpoint',null,'https://www.desnivel.com/escalada-roca/jonatan-flor-repite-patanics-9a-en-rodellar/')
,('Perlorodka','9a+','Moravsky kras','Czechia','Adam Ondra','2011-09-08','Adam Ondra','2011-09-08','Redpoint',null,null)
,('Peruvian Necktie','9a+','Pop tire cave','United States','James Litz','2013-01-01','James Litz','2013-01-01','Redpoint','Mystery ascent by strong dark horse',null)
,('Power Inverter','9a+','Oliana','Spain','Chris Sharma','2010-12-19','Chris Sharma','2010-12-19','Redpoint',null,null)
,('Power Inverter','9a+','Oliana','Spain','Chris Sharma','2010-12-19','Adam Ondra','2013-01-25','Redpoint',null,null)
,('Power Inverter','9a+','Oliana','Spain','Chris Sharma','2010-12-19','Ramón Julián Puigblanqué','2014-03-03','Redpoint',null,null)
,('Power Inverter','9a+','Oliana','Spain','Chris Sharma','2010-12-19','Sachi Amma','2015-02-16','Redpoint',null,null)
,('Power Inverter','9a+','Oliana','Spain','Chris Sharma','2010-12-19','Jonathan Siegrist','2015-12-02','Redpoint',null,null)
,('Punt X','9a+','Gorges du Loup','France','Pierre Le Cerf','2020-09-01','Pierre Le Cerf','2020-09-01','Redpoint','First ascent after major hold breakages','https://www.grimper.com/news-pierre-cerf-repete-punt-recote-voie-9a-explications')
,('Pure Dreaming plus','9a+','Arco','Italy','Adam Ondra','2018-02-25','Adam Ondra','2018-02-25','Redpoint',null,null)
,('Pure Dreaming plus','9a+','Arco','Italy','Adam Ondra','2018-02-25','Laura Rogora','2020-05-29','Redpoint',null,null)
,('Pure Dreaming plus','9a+','Arco','Italy','Adam Ondra','2018-02-25','Davide Picco','2020-07-11','Redpoint',null,null)
,('Red Ram','9a+','Margalef','Spain','Ramón Julián Puigblanqué','2013-08-30','Ramón Julián Puigblanqué','2013-08-30','Redpoint',null,null)
,('Rise','9a+','Futago-yama','Japan','Sachi Amma','2018-11-01','Sachi Amma','2018-11-01','Redpoint',null,null)
,('Sacrifice','9a+','Echo Valley','Canada','Adam Ondra','2018-07-23','Adam Ondra','2018-07-23','Redpoint',null,null)
,('Salamandre','9a+','Saint Pierre de Faucigny','France','Fred Rouhling','2007-11-01','Fred Rouhling','2007-11-01','Redpoint',null,null)
,('Salamandre','9a+','Saint Pierre de Faucigny','France','Fred Rouhling','2007-11-01','Baptiste Dherbilly','2017-10-26','Redpoint',null,null)
,('Sashidananda','9a+','Orgon','France','Gérôme Pouvreau','2009-05-28','Gérôme Pouvreau','2009-05-28','Redpoint',null,null)
,('Sashidananda','9a+','Orgon','France','Gérôme Pouvreau','2009-05-28','Loïc Zehani','2018-04-10','Redpoint',null,null)
,('Seleccio Anal','9a+','Santa Linya','Spain','Ramón Julián Puigblanqué','2013-12-21','Ramón Julián Puigblanqué','2013-12-21','Redpoint',null,null)
,('Seleccio Anal','9a+','Santa Linya','Spain','Ramón Julián Puigblanqué','2013-12-21','Sachi Amma','2015-02-19','Redpoint',null,null)
,('Seleccio Anal','9a+','Santa Linya','Spain','Ramón Julián Puigblanqué','2013-12-21','Edu Marin','2016-01-11','Redpoint',null,null)
,('Seleccio Anal','9a+','Santa Linya','Spain','Ramón Julián Puigblanqué','2013-12-21','Magnus Midtbø','2016-03-05','Redpoint',null,null)
,('Seleccio Anal','9a+','Santa Linya','Spain','Ramón Julián Puigblanqué','2013-12-21','Jakob Schubert','2017-01-08','Redpoint',null,null)
,('Seleccio Anal','9a+','Santa Linya','Spain','Ramón Julián Puigblanqué','2013-12-21','Piotr Schab','2017-02-10','Redpoint',null,null)
,('Seleccio Anal','9a+','Santa Linya','Spain','Ramón Julián Puigblanqué','2013-12-21','Kamil Ferenc','2017-04-01','Redpoint',null,null)
,('Seta ibérica','9a+','Cuenca','Spain','Jorge Díaz-Rullo','2019-09-26','Jorge Díaz-Rullo','2019-09-26','Redpoint',null,'https://woguclimbing.com/jorge-diaz-rullo-primera-ascension-seta-iberica/')
,('Seta ibérica','9a+','Cuenca','Spain','Jorge Díaz-Rullo','2019-09-28','Álex Garriga','2020-09-23','Redpoint',null,'https://www.desnivel.com/escalada-roca/alex-garriga-se-anota-la-primera-repeticion-de-seta-iberica-9a-en-cuenca/')
,('Stone Butterfly','9a+','Herculane','Romania','Adam Ondra','2018-05-15','Adam Ondra','2018-05-15','Redpoint',null,null)
,('Super Crackinette','9a+','Saint-Léger-du-Ventoux','France','Alexander Megos','2016-10-01','Alexander Megos','2016-10-01','Redpoint',null,null)
,('Super Crackinette','9a+','Saint-Léger-du-Ventoux','France','Alexander Megos','2016-10-01','Adam Ondra','2018-02-10','Flash',null,null)
,('Super Crackinette','9a+','Saint-Léger-du-Ventoux','France','Alexander Megos','2016-10-01','Gérôme Pouvreau','2018-04-01','Redpoint',null,null)
,('Super Crackinette','9a+','Saint-Léger-du-Ventoux','France','Alexander Megos','2016-10-01','Julia Chanourdie','2020-03-13','Redpoint',null,null)
,('The Bow','9a+','Arco','Italy','Stefano Ghisolfi','2020-07-13','Stefano Ghisolfi','2020-07-13','Redpoint',null,null)
,('The Clinic','9a+','Quzhou','China','Edu Marin','2019-12-03','Edu Marin','2019-12-03','Redpoint',null,null)
,('Thor''s Hammer R2','9a+','Flatanger','Norway','Adam Ondra','2017-09-01','Adam Ondra','2017-09-01','Redpoint',null,null)
,('Tinipi','9a+','Mont Kinabalu','Malaysia','Daniel Woods','2012-06-01','Daniel Woods','2012-06-01','Redpoint',null,null)
,('Tinipi','9a+','Mont Kinabalu','Malaysia','Daniel Woods','2012-06-01','Sachi Amma','2015-05-01','Redpoint',null,null)
,('Ultimatum','9a+','Arco','Italy','Stefano Ghisolfi','2016-12-19','Stefano Ghisolfi','2016-12-19','Redpoint',null,null)
,('Ultimatum','9a+','Arco','Italy','Stefano Ghisolfi','2016-12-19','Eric Albertini','2017-04-01','Redpoint',null,null)
,('Ultimatum','9a+','Arco','Italy','Stefano Ghisolfi','2016-12-19','Adam Ondra','2017-04-18','Redpoint',null,null)
,('Underground > Pure dreaming','9a+','Arco','Italy','Adam Ondra','2018-02-25','Adam Ondra','2018-02-25','Redpoint',null,null)
,('Valhalla P5','9a+','Getu','China','Edu Marin','2019-01-20','Edu Marin','2019-01-20','Redpoint','Integral ascent at later date',null)
,('Violent New Breed','9a+','Giggleswick','United Kingdom','John Gaskins','2004-06-01','John Gaskins','2004-06-01','Redpoint','Widely questioned ascent.',null);
create view routes
as
select
route_name
,grade
,area
,country
,first_ascenionist
,first_ascent_date
,count(*) as number_of_ascents
,max(ascent_date) as most_recent_ascent
from
ascents
group by
route_name
,grade
,area
,country
,first_ascenionist
,first_ascent_date
order by
grade desc
,first_ascent_date
,route_name;