| Country | Contributions | Between | Climbers | Crags | Summits | Climbs | Ascents | |
|---|---|---|---|---|---|---|---|---|
| 1 | United Kingdom | 61422 | 14th November 2023 – 5th November 2026 | 1800 | 711 | 0 | 3142 | 5081 |
| 2 | USA | 25581 | 14th November 2023 – 6th November 2026 | 818 | 182 | 2 | 859 | 2421 |
| 3 | France | 12391 | 14th November 2023 – 4th November 2026 | 272 | 126 | 1 | 553 | 1042 |
| 4 | Switzerland | 9695 | 14th November 2023 – 2nd November 2026 | 79 | 43 | 1 | 311 | 1126 |
| 5 | Spain | 8822 | 15th November 2023 – 4th November 2026 | 92 | 76 | 0 | 459 | 927 |
| 6 | Italy | 4902 | 16th November 2023 – 6th November 2026 | 120 | 59 | 0 | 189 | 377 |
| 7 | South Africa | 3688 | 16th November 2023 – 5th November 2026 | 12 | 35 | 0 | 128 | 401 |
| 8 | Canada | 3363 | 16th November 2023 – 1st November 2026 | 67 | 21 | 3 | 110 | 283 |
| 9 | Germany | 3190 | 16th November 2023 – 27th October 2026 | 120 | 48 | 0 | 103 | 225 |
| 10 | Austria | 2659 | 16th November 2023 – 24th October 2026 | 76 | 26 | 0 | 105 | 226 |
| Date | Time | User | Type | Name | Attribute | ||
|---|---|---|---|---|---|---|---|
| 78741 | 4th February 2026 | 23:05:31 UTC | remus | ascent | Elias Iagnemma's ascent of The Big Island | ascent_type_id | |
|
Before
None
After
2
|
|||||||
| 78742 | 4th February 2026 | 23:05:31 UTC | remus | ascent | Elias Iagnemma's ascent of The Big Island | notes_pretty | |
|
Before
None
After
<h3>References</h3>
<p>[1] <a href="https://www.instagram.com/p/DUWeAVRjASI/" rel="noopener noreferrer">https://www.instagram.com/p/DUWeAVRjASI/</a></p>
|
|||||||
| 78743 | 4th February 2026 | 23:05:31 UTC | remus | ascent | Elias Iagnemma's ascent of The Big Island | notes | |
|
Before
None
After
### References
[1] [https://www.instagram.com/p/DUWeAVRjASI/](https://www.instagram.com/p/DUWeAVRjASI/)
Diff
--- before
|
|||||||
| 78744 | 4th February 2026 | 23:05:31 UTC | remus | ascent | Elias Iagnemma's ascent of The Big Island | ascent_style_id | |
|
Before
None
After
1
|
|||||||
| 78745 | 4th February 2026 | 23:05:31 UTC | remus | ascent | Elias Iagnemma's ascent of The Big Island | climb_id | |
|
Before
None
After
109
|
|||||||
| 78746 | 4th February 2026 | 23:05:31 UTC | remus | ascent | Elias Iagnemma's ascent of The Big Island | climber_id | |
|
Before
None
After
913
|
|||||||
| 78747 | 4th February 2026 | 14:48:51 UTC | remus | list | UK E6 and Above | list_type_name | |
|
Before
None
After
Trad Climbing
|
|||||||
| 78748 | 4th February 2026 | 14:48:51 UTC | remus | list | UK E6 and Above | list_type_id | |
|
Before
None
After
3
|
|||||||
| 78749 | 4th February 2026 | 14:48:51 UTC | remus | list | UK E6 and Above | list_description_pretty | |
|
Before
None
After
<p>A list to help out with the history section write up for Ultimate Rock.</p>
|
|||||||
| 78750 | 4th February 2026 | 14:48:51 UTC | remus | list | UK E6 and Above | list_definition | |
|
Before
None
After
select
'<a href="' || c.url || '">' || c.climb_name || '</a>' as "Climb"
,g.grade as Grade
,'<a href="' || cl.url || '">' || cl.climber_name || '</a>' as "Climber"
,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date"
from
climbs c
inner join grades g
on c.grade_id = g.grade_id
inner join ascents a
on a.climb_id = c.climb_id
and a.deleted_on is null
and a.fa = true
inner join climbers cl
on a.climber_id = cl.climber_id
and cl.deleted_on is null
inner join crags cr
on c.ukc_crag_id = cr.crag_id
left join crags cr2
on cr.group_crag_id = cr2.crag_id
where
c.deleted_on is null
and c.climb_type_id = 3
and g.order_on >= 59
and (
coalesce(cr2.location_breadcrumb, cr.location_breadcrumb) like '%England%'
or coalesce(cr2.location_breadcrumb, cr.location_breadcrumb) like '%Wales%'
or coalesce(cr2.location_breadcrumb, cr.location_breadcrumb) like '%Scotland%'
)
order by
order_dt(a.ascent_dt_start, a.ascent_dt_end)
,g.order_on
Diff
--- before
|
|||||||
| 78751 | 4th February 2026 | 14:48:51 UTC | remus | list | UK E6 and Above | list_description | |
|
Before
None
After
A list to help out with the history section write up for Ultimate Rock.
Diff
--- before
|
|||||||
| 78752 | 4th February 2026 | 14:48:51 UTC | remus | list | UK E6 and Above | list_name | |
|
Before
None
After
UK E6 and Above
|
|||||||
| 78753 | 4th February 2026 | 14:24:03 UTC | remus | crag | Newstones and Baldstones | longitude | |
|
Before
None
After
-1.972689
|
|||||||
| 78754 | 4th February 2026 | 14:24:03 UTC | remus | crag | Newstones and Baldstones | latitude | |
|
Before
None
After
53.173647
|
|||||||
| 78755 | 4th February 2026 | 14:23:02 UTC | remus | crag | Newstones and Baldstones | crag_name | |
|
Before
Newstones And Baldstones
After
Newstones and Baldstones
|
|||||||
| 78756 | 4th February 2026 | 13:11:58 UTC | remus | climb | Distillery | grade_approx | |
|
Before
false
After
true
|
|||||||
| 78757 | 4th February 2026 | 13:08:33 UTC | remus | crag | Clogwyn Blaen Coed | rock_type | |
|
Before
None
After
Rhyolite
|
|||||||
| 78758 | 4th February 2026 | 13:08:33 UTC | remus | crag | Clogwyn Blaen Coed | rock_type_id | |
|
Before
None
After
4
|
|||||||
| 78759 | 4th February 2026 | 13:08:33 UTC | remus | crag | Clogwyn Blaen Coed | longitude | |
|
Before
None
After
-4.035236
|
|||||||
| 78760 | 4th February 2026 | 13:08:33 UTC | remus | crag | Clogwyn Blaen Coed | latitude | |
|
Before
None
After
53.085269
|
|||||||