| 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 | 608 | 19th November 2025 – 26th August 2026 | 34 | 14 | 0 | 23 | 47 |
| 4 | Switzerland | 271 | 24th January 2026 – 28th August 2026 | 6 | 3 | 0 | 12 | 35 |
| 5 | France | 264 | 6th January 2026 – 28th June 2026 | 14 | 3 | 0 | 12 | 31 |
| 6 | Austria | 210 | 12th November 2025 – 22nd June 2026 | 5 | 2 | 0 | 8 | 22 |
| 7 | Italy | 152 | 18th November 2025 – 11th August 2026 | 9 | 3 | 0 | 12 | 11 |
| 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 | ||
|---|---|---|---|---|---|---|---|
| 541 | 27th May 2026 | 12:39:26 UTC | baz9 | media | https://open.spotify.com/episode/3xpGNGkv0wiqkxEdmVRinu | url | |
|
Before
None
After
https://open.spotify.com/episode/3xpGNGkv0wiqkxEdmVRinu
|
|||||||
| 542 | 27th May 2026 | 12:39:26 UTC | baz9 | ascent | Aidan Roberts's ascent of The Singularity | ascent_type_id | |
|
Before
None
After
2
|
|||||||
| 543 | 27th May 2026 | 12:39:26 UTC | baz9 | ascent | Aidan Roberts's ascent of The Singularity | climb_id | |
|
Before
None
After
115
|
|||||||
| 544 | 27th May 2026 | 12:39:26 UTC | baz9 | ascent | Aidan Roberts's ascent of The Singularity | ascent_dt_end | |
|
Before
None
After
2026-05-27
|
|||||||
| 545 | 27th May 2026 | 12:39:26 UTC | baz9 | ascent | Aidan Roberts's ascent of The Singularity | ascent_style_id | |
|
Before
None
After
1
|
|||||||
| 546 | 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>
|
|||||||
| 547 | 27th May 2026 | 12:39:26 UTC | baz9 | ascent | Aidan Roberts's ascent of The Singularity | climber_id | |
|
Before
None
After
227
|
|||||||
| 548 | 27th May 2026 | 12:39:26 UTC | baz9 | ascent | Aidan Roberts's ascent of The Singularity | notes | |
|
Before
None
After
### References
[1] [https://open.spotify.com/episode/3xpGNGkv0wiqkxEdmVRinu](https://open.spotify.com/episode/3xpGNGkv0wiqkxEdmVRinu)
Diff
--- before
|
|||||||
| 549 | 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
|
|||||||
| 550 | 26th May 2026 | 18:05:10 UTC | baz9 | list | The Hardest Sport Climbs in Sweden | list_type_id | |
|
Before
None
After
2
|
|||||||
| 551 | 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>
|
|||||||
| 552 | 26th May 2026 | 18:05:10 UTC | baz9 | list | The Hardest Sport Climbs in Sweden | list_type_name | |
|
Before
None
After
Sport Climbing
|
|||||||
| 553 | 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
|
|||||||
| 554 | 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
|
|||||||
| 555 | 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>
|
|||||||
| 556 | 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
|
|||||||
| 557 | 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
|
|||||||
| 558 | 26th May 2026 | 18:04:06 UTC | baz9 | list | The Hardest Boulder Problems in Sweden | list_type_id | |
|
Before
None
After
1
|
|||||||
| 559 | 26th May 2026 | 18:04:06 UTC | baz9 | list | The Hardest Boulder Problems in Sweden | list_type_name | |
|
Before
None
After
Bouldering
|
|||||||
| 560 | 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
|
|||||||