| Country | Contributions | Between | Climbers | Crags | Summits | Climbs | Ascents | |
|---|---|---|---|---|---|---|---|---|
| 1 | USA | 1507 | 20th November 2025 – 30th June 2026 | 47 | 20 | 0 | 87 | 97 |
| 2 | Australia | 767 | 27th September 2025 – 29th June 2026 | 6 | 38 | 0 | 61 | 33 |
| 3 | United Kingdom | 576 | 19th November 2025 – 8th July 2026 | 33 | 14 | 0 | 22 | 43 |
| 4 | France | 264 | 6th January 2026 – 28th June 2026 | 14 | 3 | 0 | 12 | 31 |
| 5 | Switzerland | 257 | 24th January 2026 – 10th July 2026 | 6 | 3 | 0 | 12 | 33 |
| 6 | Austria | 210 | 12th November 2025 – 22nd June 2026 | 5 | 2 | 0 | 8 | 22 |
| 7 | Italy | 129 | 18th November 2025 – 29th May 2026 | 9 | 3 | 0 | 11 | 10 |
| 8 | Pakistan | 118 | 11th April 2026 – 26th April 2026 | 0 | 0 | 0 | 1 | 7 |
| 9 | Spain | 105 | 20th February 2026 – 16th May 2026 | 5 | 0 | 0 | 10 | 11 |
| 10 | Germany | 103 | 3rd February 2026 – 26th June 2026 | 7 | 0 | 0 | 7 | 10 |
| Date | Time | User | Type | Name | Attribute | ||
|---|---|---|---|---|---|---|---|
| 401 | 27th May 2026 | 12:39:26 UTC | baz9 | ascent | Aidan Roberts's ascent of The Singularity | climb_id | |
|
Before
None
After
115
|
|||||||
| 402 | 27th May 2026 | 12:39:26 UTC | baz9 | ascent | Aidan Roberts's ascent of The Singularity | notes_pretty | |
|
Before
None
After
<h3>References</h3>
<p>[1] <a href="https://open.spotify.com/episode/3xpGNGkv0wiqkxEdmVRinu" rel="noopener noreferrer">https://open.spotify.com/episode/3xpGNGkv0wiqkxEdmVRinu</a></p>
|
|||||||
| 403 | 27th May 2026 | 12:39:26 UTC | baz9 | ascent | Aidan Roberts's ascent of The Singularity | ascent_style_id | |
|
Before
None
After
1
|
|||||||
| 404 | 26th May 2026 | 18:05:10 UTC | baz9 | list | The Hardest Sport Climbs in Sweden | list_type_id | |
|
Before
None
After
2
|
|||||||
| 405 | 26th May 2026 | 18:05:10 UTC | baz9 | list | The Hardest Sport Climbs in Sweden | list_description_pretty | |
|
Before
None
After
<p>Sport climbs in Sweden graded 8c or harder, ordered hardest first then by date of first ascent.</p>
|
|||||||
| 406 | 26th May 2026 | 18:05:10 UTC | baz9 | list | The Hardest Sport Climbs in Sweden | list_description | |
|
Before
None
After
Sport climbs in Sweden graded 8c or harder, ordered hardest first then by date of first ascent.
Diff
--- before
|
|||||||
| 407 | 26th May 2026 | 18:05:10 UTC | baz9 | list | The Hardest Sport Climbs in Sweden | list_type_name | |
|
Before
None
After
Sport Climbing
|
|||||||
| 408 | 26th May 2026 | 18:05:10 UTC | baz9 | list | The Hardest Sport Climbs in Sweden | list_definition | |
|
Before
None
After
select
c.climb_uuid as row_uuid
,'<a href="/climb/' || c.climb_id::varchar || '">' || c.climb_name || '</a>' as "Name"
,g.grade as "Grade"
,'<a href="/climber/' || cl.climber_id::varchar || '">' || cl.climber_name || '</a>, ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent"
,(
select count(*)
from ascents a3
inner join ascent_styles ast on a3.ascent_style_id = ast.ascent_style_id
where a3.climb_id = c.climb_id
and a3.deleted_on is null
and ast.ascent_successful
) as "# Ascents"
from
climbs c
inner join grades g
on c.grade_id = g.grade_id
inner join crags cr
on c.crag_id = cr.crag_id
left join crag_meta cm_country
on cr.crag_id = cm_country.crag_id
and cm_country.crag_meta_key_id = 6
left join countries co_country
on cm_country.value::int = co_country.country_id
left join climb_meta cm_project
on c.climb_id = cm_project.climb_id
and cm_project.climb_meta_key_id = 20
left join ascents a
on a.climb_id = c.climb_id
and a.fa = true
and a.deleted_on is null
left join climbers cl
on a.climber_id = cl.climber_id
where
c.deleted_on is null
and c.climb_type = 1
and g.order_on >= 17
and cm_project.value is null
and (
cr.location_breadcrumb ilike 'Sweden%'
or (
(cr.location_breadcrumb is null or cr.location_breadcrumb = '')
and co_country.name = 'Sweden'
)
)
order by
g.order_on desc
,order_dt(a.ascent_dt_start, a.ascent_dt_end)
Diff
--- before
|
|||||||
| 409 | 26th May 2026 | 18:05:10 UTC | baz9 | list | The Hardest Sport Climbs in Sweden | list_name | |
|
Before
None
After
The Hardest Sport Climbs in Sweden
|
|||||||
| 410 | 26th May 2026 | 18:04:06 UTC | baz9 | list | The Hardest Boulder Problems in Sweden | list_definition | |
|
Before
None
After
select
c.climb_uuid as row_uuid
,'<a href="/climb/' || c.climb_id::varchar || '">' || c.climb_name || '</a>' as "Name"
,g.grade as "Grade"
,'<a href="/climber/' || cl.climber_id::varchar || '">' || cl.climber_name || '</a>, ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent"
,(
select count(*)
from ascents a3
inner join ascent_styles ast on a3.ascent_style_id = ast.ascent_style_id
where a3.climb_id = c.climb_id
and a3.deleted_on is null
and ast.ascent_successful
) as "# Ascents"
from
climbs c
inner join grades g
on c.grade_id = g.grade_id
inner join crags cr
on c.crag_id = cr.crag_id
left join crag_meta cm_country
on cr.crag_id = cm_country.crag_id
and cm_country.crag_meta_key_id = 6
left join countries co_country
on cm_country.value::int = co_country.country_id
left join climb_meta cm_project
on c.climb_id = cm_project.climb_id
and cm_project.climb_meta_key_id = 20
left join ascents a
on a.climb_id = c.climb_id
and a.fa = true
and a.deleted_on is null
left join climbers cl
on a.climber_id = cl.climber_id
where
c.deleted_on is null
and c.climb_type = 2
and g.order_on >= 39
and cm_project.value is null
and (
cr.location_breadcrumb ilike 'Sweden%'
or (
(cr.location_breadcrumb is null or cr.location_breadcrumb = '')
and co_country.name = 'Sweden'
)
)
order by
g.order_on desc
,order_dt(a.ascent_dt_start, a.ascent_dt_end)
Diff
--- before
|
|||||||
| 411 | 26th May 2026 | 18:04:06 UTC | baz9 | list | The Hardest Boulder Problems in Sweden | list_description_pretty | |
|
Before
None
After
<p>Boulder problems in Sweden graded 8B or harder, ordered hardest first then by date of first ascent.</p>
|
|||||||
| 412 | 26th May 2026 | 18:04:06 UTC | baz9 | list | The Hardest Boulder Problems in Sweden | list_name | |
|
Before
None
After
The Hardest Boulder Problems in Sweden
|
|||||||
| 413 | 26th May 2026 | 18:04:06 UTC | baz9 | list | The Hardest Boulder Problems in Sweden | list_type_name | |
|
Before
None
After
Bouldering
|
|||||||
| 414 | 26th May 2026 | 18:04:06 UTC | baz9 | list | The Hardest Boulder Problems in Sweden | list_description | |
|
Before
None
After
Boulder problems in Sweden graded 8B or harder, ordered hardest first then by date of first ascent.
Diff
--- before
|
|||||||
| 415 | 26th May 2026 | 18:04:06 UTC | baz9 | list | The Hardest Boulder Problems in Sweden | list_type_id | |
|
Before
None
After
1
|
|||||||
| 416 | 22nd May 2026 | 10:17:57 UTC | baz9 | ascent | Katie Lamb's ascent of 130 BPM | notes | |
|
Before
### References
[1] [https://open.spotify.com/episode/6rJ0gdBK8sJxJ06S1P68Te](https://open.spotify.com/episode/6rJ0gdBK8sJxJ06S1P68Te)
[2] [https://www.instagram.com/p/DYhzlNXG9TQ/](https://www.instagram.com/p/DYhzlNXG9TQ/)
[3] [https://www.instagram.com/p/DYiNJhPEWo_/](https://www.instagram.com/p/DYiNJhPEWo_/)
After
### References
[1] [https://open.spotify.com/episode/6rJ0gdBK8sJxJ06S1P68Te](https://open.spotify.com/episode/6rJ0gdBK8sJxJ06S1P68Te)
[2] [https://www.instagram.com/p/DYhzlNXG9TQ/](https://www.instagram.com/p/DYhzlNXG9TQ/)
[3] [https://www.instagram.com/p/DYiNJhPEWo_/](https://www.instagram.com/p/DYiNJhPEWo_/)
[4] [https://gripped.com/news/katie-lamb-makes-v15-first-ascent-in-yosemite/](https://gripped.com/news/katie-lamb-makes-v15-first-ascent-in-yosemite/)
Diff
--- before
|
|||||||
| 417 | 22nd May 2026 | 10:17:57 UTC | baz9 | ascent | Katie Lamb's ascent of 130 BPM | notes_pretty | |
|
Before
<h3>References</h3>
<p>[1] <a href="https://open.spotify.com/episode/6rJ0gdBK8sJxJ06S1P68Te" rel="noopener noreferrer">https://open.spotify.com/episode/6rJ0gdBK8sJxJ06S1P68Te</a></p>
<p>[2] <a href="https://www.instagram.com/p/DYhzlNXG9TQ/" rel="noopener noreferrer">https://www.instagram.com/p/DYhzlNXG9TQ/</a></p>
<p>[3] <a href="https://www.instagram.com/p/DYiNJhPEWo_/" rel="noopener noreferrer">https://www.instagram.com/p/DYiNJhPEWo_/</a></p>
After
<h3>References</h3>
<p>[1] <a href="https://open.spotify.com/episode/6rJ0gdBK8sJxJ06S1P68Te" rel="noopener noreferrer">https://open.spotify.com/episode/6rJ0gdBK8sJxJ06S1P68Te</a></p>
<p>[2] <a href="https://www.instagram.com/p/DYhzlNXG9TQ/" rel="noopener noreferrer">https://www.instagram.com/p/DYhzlNXG9TQ/</a></p>
<p>[3] <a href="https://www.instagram.com/p/DYiNJhPEWo_/" rel="noopener noreferrer">https://www.instagram.com/p/DYiNJhPEWo_/</a></p>
<p>[4] <a href="https://gripped.com/news/katie-lamb-makes-v15-first-ascent-in-yosemite/" rel="noopener noreferrer">https://gripped.com/news/katie-lamb-makes-v15-first-ascent-in-yosemite/</a></p>
|
|||||||
| 418 | 21st May 2026 | 01:20:14 UTC | baz9 | ascent | Drew Ruana's ascent of Everything Gneiss | Sessions (More Than) | |
|
Before
None
After
15
|
|||||||
| 419 | 21st May 2026 | 01:19:37 UTC | baz9 | ascent | Matt Fultz's ascent of Everything Gneiss | suggested_grade_id | |
|
Before
None
After
178
|
|||||||
| 420 | 21st May 2026 | 01:19:37 UTC | baz9 | ascent | Matt Fultz's ascent of Everything Gneiss | notes_pretty | |
|
Before
<h3>References</h3>
<p>[1] <a href="https://www.youtube.com/watch?v=0JYeNNGb6ns">https://www.youtube.com/watch?v=0JYeNNGb6ns</a></p>
After
<h3>References</h3>
<p>[1] <a href="https://www.youtube.com/watch?v=0JYeNNGb6ns" rel="noopener noreferrer">https://www.youtube.com/watch?v=0JYeNNGb6ns</a></p>
|
|||||||