| Country | Contributions | Between | Climbers | Crags | Summits | Climbs | Ascents | |
|---|---|---|---|---|---|---|---|---|
| 1 | United Kingdom | 50669 | 14th November 2023 – 23rd August 2026 | 1388 | 676 | 0 | 3005 | 4761 |
| 2 | USA | 24256 | 14th November 2023 – 22nd August 2026 | 786 | 179 | 2 | 843 | 2331 |
| 3 | France | 11809 | 14th November 2023 – 21st August 2026 | 258 | 125 | 1 | 542 | 1007 |
| 4 | Switzerland | 8839 | 14th November 2023 – 23rd August 2026 | 74 | 41 | 1 | 298 | 1048 |
| 5 | Spain | 8246 | 15th November 2023 – 18th August 2026 | 88 | 73 | 0 | 441 | 885 |
| 6 | Italy | 4332 | 16th November 2023 – 19th August 2026 | 115 | 57 | 0 | 178 | 333 |
| 7 | South Africa | 3544 | 16th November 2023 – 23rd August 2026 | 12 | 35 | 0 | 124 | 386 |
| 8 | Germany | 3065 | 16th November 2023 – 22nd August 2026 | 115 | 47 | 0 | 102 | 223 |
| 9 | Canada | 3006 | 16th November 2023 – 13th August 2026 | 62 | 21 | 3 | 105 | 256 |
| 10 | Austria | 2398 | 16th November 2023 – 23rd August 2026 | 69 | 26 | 0 | 99 | 212 |
| Date | Time | User | Type | Name | Attribute | ||
|---|---|---|---|---|---|---|---|
| 41801 | 15th January 2026 | 07:14:19 UTC | remus | ascent | Andrea Chelleris's ascent of Direct Into Your Fabelita | climber_id | |
|
Before
None
After
2850
|
|||||||
| 41802 | 15th January 2026 | 07:12:40 UTC | remus | list | James' List | list_definition | |
|
Before
WITH RECURSIVE months AS (
SELECT DATE_TRUNC('month', DATE '2024-01-01') AS month_start
UNION ALL
SELECT DATE_TRUNC('month', month_start + INTERVAL '1 month')
FROM months
WHERE month_start < DATE_TRUNC('month', CURRENT_DATE)
)
SELECT
date_part('year', month_start)::int as "Year"
,date_part('month', month_start)::int as "Month"
,'<a href="/climber/' || c.climber_id::varchar || '/a">' || c.climber_name || '</a>' as "Climber"
,'<a href="/climb/' || cl.climb_id::varchar || '/a">' || cl.climb_name || '</a>' as "Climb"
,g.grade || ' ' || ct.climb_type as "Grade"
,aty.ascent_type || ' (' || ast.ascent_style || ')' as "Style"
,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date"
FROM
months m
left join ascents a
on m.month_start = date_trunc('month', a.ascent_dt_start)
and a.deleted_on is null
and a.climber_id in (
2850
,2851
,836
,2852
,1152
,517
,369
,894
,2853
,2854
,495
,1004
,173
,942
,2855
,523
,913
,2856
,590
,2857
,637
,2858
,2724
,2859
,2860
,1576
,152
,2861
,1991
,2862
,1912
,2863
,467
,2436
,2864
,676
,1210
,322
,2247
,1537
,2865
,1082
,1201
,1790
,1441
,494
,1097
,1200
,2008
,593
,2217
,992
,831
,881
,686
,778
,1263
,166
,2866
,787
)
left join climbers c
on a.climber_id = c.climber_id
left join climbs cl
on a.climb_id = cl.climb_id
left join grades g
on cl.grade_id = g.grade_id
left join climb_types ct
on cl.climb_type_id = ct.climb_type_id
left join ascent_types aty
on a.ascent_type_id = aty.ascent_type_id
left join ascent_styles ast
on a.ascent_style_id = ast.ascent_style_id
ORDER BY
month_start desc
,order_dt(a.ascent_dt_start, a.ascent_dt_end) desc;
After
WITH RECURSIVE months AS (
SELECT DATE_TRUNC('month', DATE '2024-01-01') AS month_start
UNION ALL
SELECT DATE_TRUNC('month', month_start + INTERVAL '1 month')
FROM months
WHERE month_start < DATE_TRUNC('month', CURRENT_DATE)
)
SELECT
date_part('year', month_start)::int as "Year"
,date_part('month', month_start)::int as "Month"
,'<a href="/climber/' || c.climber_id::varchar || '/a">' || c.climber_name || '</a>' as "Climber"
,'<a href="/climb/' || cl.climb_id::varchar || '/a">' || cl.climb_name || '</a>' as "Climb"
,g.grade || ' ' || ct.climb_type as "Grade"
,aty.ascent_type || ' (' || ast.ascent_style || ')' as "Style"
,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date"
FROM
months m
left join ascents a
on m.month_start = date_trunc('month', a.ascent_dt_start)
and a.deleted_on is null
and a.climber_id in (
2850
,2851
,836
,2852
,1152
,517
,369
,894
,2853
,2854
,495
,1004
,173
,942
,2855
,523
,913
,2856
,590
,2857
,637
,2858
,2724
,2859
,2860
,1576
,152
,2861
,1991
,2862
,1912
,2863
,467
,2436
,2864
,676
,1210
,322
,2247
,1537
,2865
,1082
,1201
,1790
,1441
,494
,1097
,1200
,2008
,593
,2217
,992
,831
,881
,686
,778
,1263
,166
,2866
,787
,1431
,1547
,1798
,1085
,2107
,1457
)
left join climbers c
on a.climber_id = c.climber_id
left join climbs cl
on a.climb_id = cl.climb_id
left join grades g
on cl.grade_id = g.grade_id
left join climb_types ct
on cl.climb_type_id = ct.climb_type_id
left join ascent_types aty
on a.ascent_type_id = aty.ascent_type_id
left join ascent_styles ast
on a.ascent_style_id = ast.ascent_style_id
ORDER BY
month_start desc
,order_dt(a.ascent_dt_start, a.ascent_dt_end) desc;
Diff
--- before
|
|||||||
| 41803 | 15th January 2026 | 07:03:09 UTC | remus | climb | Running Man | notes_pretty | |
|
Before
None
After
<p>The line is a little eliminate. The non-eliminate version uses some good holds on the neighbouring <a href="/climb/6864/artificial-intelligence" rel="noopener noreferrer">Artificial Intelligence</a>, was first climbed by Will Nazarian and is about 8a+/13c.</p>
|
|||||||
| 41804 | 15th January 2026 | 07:03:09 UTC | remus | climb | Running Man | notes | |
|
Before
None
After
The line is a little eliminate. The non-eliminate version uses some good holds on the neighbouring [Artificial Intelligence](/climb/6864/artificial-intelligence), was first climbed by Will Nazarian and is about 8a+/13c.
Diff
--- before
|
|||||||
| 41805 | 15th January 2026 | 07:00:26 UTC | remus | climb | Artificial Intelligence | Alternate Grade | |
|
Before
None
After
11
|
|||||||
| 41806 | 15th January 2026 | 07:00:15 UTC | remus | climb | Artificial Intelligence | Website | |
|
Before
None
After
https://www.thecrag.com/en/climbing/united-states/shawangunks/route/14642479
|
|||||||
| 41807 | 15th January 2026 | 07:00:09 UTC | remus | climb | Artificial Intelligence | climb_name | |
|
Before
None
After
Artificial Intelligence
|
|||||||
| 41808 | 15th January 2026 | 07:00:09 UTC | remus | climb | Artificial Intelligence | climb_type | |
|
Before
None
After
3
|
|||||||
| 41809 | 15th January 2026 | 07:00:09 UTC | remus | climb | Artificial Intelligence | grade_id | |
|
Before
None
After
60
|
|||||||
| 41810 | 15th January 2026 | 06:58:27 UTC | remus | climb | Running Man | Bolted By | |
|
Before
None
After
3689
|
|||||||
| 41811 | 15th January 2026 | 06:58:14 UTC | remus | climber | Jeff Morris | climber_name | |
|
Before
None
After
Jeff Morris
|
|||||||
| 41812 | 15th January 2026 | 06:58:14 UTC | remus | climber | Jeff Morris | gender | |
|
Before
None
After
false
|
|||||||
| 41813 | 15th January 2026 | 06:58:14 UTC | remus | climber | Jeff Morris | nationality | |
|
Before
None
After
US
|
|||||||
| 41814 | 15th January 2026 | 06:58:14 UTC | remus | climber | Jeff Morris | country_id | |
|
Before
None
After
2
|
|||||||
| 41815 | 15th January 2026 | 06:58:14 UTC | remus | climber | Jeff Morris | country_name | |
|
Before
None
After
USA
|
|||||||
| 41816 | 15th January 2026 | 06:58:14 UTC | remus | climber | Jeff Morris | country_membership | |
|
Before
None
After
american
|
|||||||
| 41817 | 15th January 2026 | 06:58:14 UTC | remus | climber | Jeff Morris | country_flag | |
|
Before
None
After
🇺🇸
|
|||||||
| 41818 | 15th January 2026 | 06:57:50 UTC | remus | climb | Running Man | Website | |
|
Before
None
After
https://www.thecrag.com/en/climbing/united-states/shawangunks/route/14642527
|
|||||||
| 41819 | 15th January 2026 | 06:57:44 UTC | remus | climb | Running Man | notes | |
|
Before
Climb is on Bonticou, Shawanagunks, Native American reservation land where local policy is routes remain undocumented.
After
None
Diff
--- before
|
|||||||
| 41820 | 15th January 2026 | 06:57:44 UTC | remus | climb | Running Man | notes_pretty | |
|
Before
<p>Climb is on Bonticou, Shawanagunks, Native American reservation land where local policy is routes remain undocumented. </p>
After
None
|
|||||||