| Country | Contributions | Between | Climbers | Crags | Summits | Climbs | Ascents | |
|---|---|---|---|---|---|---|---|---|
| 1 | United Kingdom | 59888 | 14th November 2023 – 23rd October 2026 | 1796 | 705 | 0 | 3096 | 4956 |
| 2 | USA | 25404 | 14th November 2023 – 23rd October 2026 | 816 | 182 | 2 | 855 | 2397 |
| 3 | France | 12365 | 14th November 2023 – 20th October 2026 | 272 | 126 | 1 | 552 | 1039 |
| 4 | Switzerland | 9660 | 14th November 2023 – 22nd October 2026 | 79 | 43 | 1 | 311 | 1122 |
| 5 | Spain | 8747 | 15th November 2023 – 22nd October 2026 | 92 | 76 | 0 | 458 | 919 |
| 6 | Italy | 4751 | 16th November 2023 – 22nd October 2026 | 119 | 59 | 0 | 185 | 368 |
| 7 | South Africa | 3684 | 16th November 2023 – 16th October 2026 | 12 | 35 | 0 | 128 | 401 |
| 8 | Canada | 3359 | 16th November 2023 – 21st October 2026 | 67 | 21 | 3 | 110 | 282 |
| 9 | Germany | 3178 | 16th November 2023 – 13th October 2026 | 120 | 48 | 0 | 103 | 224 |
| 10 | Austria | 2638 | 16th November 2023 – 18th October 2026 | 75 | 26 | 0 | 105 | 226 |
| Date | Time | User | Type | Name | Attribute | ||
|---|---|---|---|---|---|---|---|
| 71161 | 3rd March 2026 | 15:56:46 UTC | remus | climb | Climpit | grade | |
|
Before
8B
After
8A+
|
|||||||
| 71162 | 3rd March 2026 | 15:56:46 UTC | remus | climb | Climpit | grade_id | |
|
Before
39
After
38
|
|||||||
| 71163 | 3rd March 2026 | 15:55:24 UTC | remus | climber | Beckett Hsin | age | |
|
Before
None
After
16
|
|||||||
| 71164 | 3rd March 2026 | 15:55:24 UTC | remus | climber | Beckett Hsin | date_of_birth_pretty | |
|
Before
After
12th Dec 2009
|
|||||||
| 71165 | 3rd March 2026 | 15:55:24 UTC | remus | climber | Beckett Hsin | date_of_birth_end | |
|
Before
None
After
2009-12-12
|
|||||||
| 71166 | 3rd March 2026 | 15:55:24 UTC | remus | climber | Beckett Hsin | date_of_birth_start | |
|
Before
None
After
2009-12-12
|
|||||||
| 71167 | 3rd March 2026 | 15:52:47 UTC | remus | list | Youngest Ascents | list_definition | |
|
Before
with climbers_with_dobs as (
select
c.climber_id
,c.climber_name
,cm.value::date as date_of_birth
,cm.value
from
climbers c
inner join climber_meta cm
on c.climber_id = cm.climber_id
and cm.climber_meta_key_id = 4
where
c.deleted_on is null
), ascents_with_ages as (
select
row_number() over (partition by g.grade_id order by a.ascent_dt_start - c.date_of_birth asc, a.ascent_dt_start asc) as row_number,
c.climber_id,
c.climber_name,
cl.climb_id,
cl.climb_name
,g.grade_id
,g.grade_system_id
,g.climb_type_id
,g.order_on
,g.grade
,a.ascent_dt_start
,c.date_of_birth
,a.ascent_dt_start - c.date_of_birth as age_in_days_at_ascent
,EXTRACT(YEAR FROM age(a.ascent_dt_start, c.date_of_birth))::integer AS age_in_years_at_ascent
,age(a.ascent_dt_start, c.date_of_birth) as age_interval_at_ascent
,a.ascent_id
from
ascents a
inner join climbers_with_dobs c
on a.climber_id = c.climber_id
and a.deleted_on is null
inner join climbs cl
on cl.climb_id = a.climb_id
and cl.deleted_on is null
inner join grades g
on cl.grade_id = g.grade_id
where
a.ascent_dt_start = a.ascent_dt_end
), youngest as (
select *
from ascents_with_ages
where row_number = 1
)
select
y.grade
,'<a href="/climber/' || y.climber_id::varchar || '">' || y.climber_name || '</a>' as "Climber"
,'<a href="/climb/' || y.climb_id::varchar || '">' || y.climb_name || '</a>' as "Climb"
,y.age_in_days_at_ascent as "Age (Days)"
,y.age_in_years_at_ascent || ' years ' || extract(days FROM y.ascent_dt_start - (y.date_of_birth + make_interval(years => y.age_in_years_at_ascent))) || ' days' AS "Age"
from
youngest y
where
case
when grade_system_id = 1 and order_on >= 13 then 1 -- sport
when grade_system_id = 2 and order_on >= 60 then 1 -- trad
when grade_system_id = 3 and order_on >= 37 then 1 -- boulder
else 0
end = 1
and climb_type_id in (1,2,3)
order by
grade_system_id
,order_on
After
with climbers_with_dobs as (
select
c.climber_id
,c.climber_name
,c.date_of_birth_start as date_of_birth
from
climbers c
where
c.deleted_on is null
and c.date_of_birth_start = c.date_of_birth_end
), ascents_with_ages as (
select
row_number() over (partition by g.grade_id order by a.ascent_dt_start - c.date_of_birth asc, a.ascent_dt_start asc) as row_number,
c.climber_id,
c.climber_name,
cl.climb_id,
cl.climb_name
,g.grade_id
,g.grade_system_id
,g.climb_type_id
,g.order_on
,g.grade
,a.ascent_dt_start
,c.date_of_birth
,a.ascent_dt_start - c.date_of_birth as age_in_days_at_ascent
,EXTRACT(YEAR FROM age(a.ascent_dt_start, c.date_of_birth))::integer AS age_in_years_at_ascent
,age(a.ascent_dt_start, c.date_of_birth) as age_interval_at_ascent
,a.ascent_id
from
ascents a
inner join climbers_with_dobs c
on a.climber_id = c.climber_id
and a.deleted_on is null
inner join climbs cl
on cl.climb_id = a.climb_id
and cl.deleted_on is null
inner join grades g
on cl.grade_id = g.grade_id
where
a.ascent_dt_start = a.ascent_dt_end
), youngest as (
select *
from ascents_with_ages
where row_number = 1
)
select
y.grade
,'<a href="/climber/' || y.climber_id::varchar || '">' || y.climber_name || '</a>' as "Climber"
,'<a href="/climb/' || y.climb_id::varchar || '">' || y.climb_name || '</a>' as "Climb"
,y.age_in_days_at_ascent as "Age (Days)"
,y.age_in_years_at_ascent || ' years ' || extract(days FROM y.ascent_dt_start - (y.date_of_birth + make_interval(years => y.age_in_years_at_ascent))) || ' days' AS "Age"
from
youngest y
where
case
when grade_system_id = 1 and order_on >= 13 then 1 -- sport
when grade_system_id = 2 and order_on >= 60 then 1 -- trad
when grade_system_id = 3 and order_on >= 37 then 1 -- boulder
else 0
end = 1
and climb_type_id in (1,2,3)
order by
grade_system_id
,order_on
Diff
--- before
|
|||||||
| 71168 | 3rd March 2026 | 15:06:09 UTC | remus | crag | Barker Dam | longitude | |
|
Before
None
After
-116.146275
|
|||||||
| 71169 | 3rd March 2026 | 15:06:09 UTC | remus | crag | Barker Dam | latitude | |
|
Before
None
After
34.031985
|
|||||||
| 71170 | 3rd March 2026 | 15:06:09 UTC | remus | crag | Barker Dam | eight_a_nu_url | |
|
Before
None
After
https://www.8a.nu/crags/bouldering/united-states/barker-dam/routes
Diff
--- before
|
|||||||
| 71171 | 3rd March 2026 | 15:04:45 UTC | remus | climb | Iron Resolution | See Also | |
|
Before
None
After
7193
|
|||||||
| 71172 | 3rd March 2026 | 15:04:32 UTC | remus | climb | Diamond Grit | See Also | |
|
Before
None
After
3589
|
|||||||
| 71173 | 3rd March 2026 | 15:04:24 UTC | remus | climb | Diamond Grit | crag_id | |
|
Before
None
After
2027
|
|||||||
| 71174 | 3rd March 2026 | 15:04:24 UTC | remus | climb | Diamond Grit | eight_a_nu_url | |
|
Before
None
After
https://www.8a.nu/crags/bouldering/united-states/barker-dam/sectors/unknown-sector/routes/diamond-grit
|
|||||||
| 71175 | 3rd March 2026 | 15:04:24 UTC | remus | climb | Diamond Grit | ukc_url | |
|
Before
None
After
https://www.ukclimbing.com/logbook/crags/barker_dam-2027/diamond_grit-790536
|
|||||||
| 71176 | 3rd March 2026 | 15:04:24 UTC | remus | climb | Diamond Grit | climb_type | |
|
Before
None
After
2
|
|||||||
| 71177 | 3rd March 2026 | 15:04:24 UTC | remus | climb | Diamond Grit | grade_id | |
|
Before
None
After
39
|
|||||||
| 71178 | 3rd March 2026 | 15:04:24 UTC | remus | climb | Diamond Grit | climb_name | |
|
Before
None
After
Diamond Grit
|
|||||||
| 71179 | 3rd March 2026 | 15:03:57 UTC | remus | climb | Iron Resolution | crag_name | |
|
Before
None
After
Barker Dam
|
|||||||
| 71180 | 3rd March 2026 | 15:03:57 UTC | remus | climb | Iron Resolution | crag_id | |
|
Before
None
After
2027
|
|||||||