| 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 | ||
|---|---|---|---|---|---|---|---|
| 1201 | 16th May 2026 | 13:39:14 UTC | baz9 | list | Crags Without Coordinates | list_description_pretty | |
|
Before
<p>This is a list of crags that have no location coordinates. </p>
<p>Some crags in this list have secret locations so we have added a broad 'country' meta. </p>
<p>I have created another list of crags without Coordinates OR Country meta, here:
<a href="https://climbing-history.org/list/115/crags-without-coordinates-or-country-meta" rel="noopener noreferrer">https://climbing-history.org/list/115/crags-without-coordinates-or-country-meta</a></p>
After
<p>This is a list of crags that have no location coordinates. </p>
<p>Some crags in this list have secret locations so we have added a broad 'country' meta. </p>
<p>I have created another list of crags without Coordinates OR Country meta, here:
crag | climbs | ukc | 8a.nu | theCrag | 27crags
---- | ------ | --- | ----- | ------- | -------
<a href="/crag/34273/entrechaux" rel="noopener noreferrer">Entrechaux</a> | 1 | <a href="https://www.ukclimbing.com/logbook/crags/entrechaux-21022" rel="noopener noreferrer">UKC</a> | None | None | None
<a href="/crag/34283/grotti" rel="noopener noreferrer">Grotti</a> | 1 | <a href="https://www.ukclimbing.com/logbook/crags/grotti-18041" rel="noopener noreferrer">UKC</a> | None | None | None
<a href="/crag/34293/jogasaki" rel="noopener noreferrer">Jogasaki</a> | 1 | <a href="https://www.ukclimbing.com/logbook/crags/jogasaki-27229/" rel="noopener noreferrer">UKC</a> | None | None | None
<a href="/crag/34297/mill-creek-ut-moab-area" rel="noopener noreferrer">Mill Creek Ut Moab Area</a> | 1 | <a href="https://www.ukclimbing.com/logbook/crags/mill_creek_ut_moab_area-30314" rel="noopener noreferrer">UKC</a> | None | None | None
<a href="/crag/34339/öreg-lyuk" rel="noopener noreferrer">Öreg-lyuk</a> | 1 | None | <a href="https://www.8a.nu/crags/bouldering/hungary/oereg-lyuk/routes" rel="noopener noreferrer">8a.nu</a> | None | None
<a href="/crag/34306/riverside-guangxi" rel="noopener noreferrer">Riverside Guangxi</a> | 1 | <a href="https://www.ukclimbing.com/logbook/crags/riverside_guangxi-18521" rel="noopener noreferrer">UKC</a> | None | None | None
<a href="/crag/34279/secret-spot" rel="noopener noreferrer">Secret Spot</a> | 1 | <a href="https://www.ukclimbing.com/logbook/crags/secret_spot-29113" rel="noopener noreferrer">UKC</a> | None | None | None
<a href="/crag/34292/silver-lake" rel="noopener noreferrer">Silver Lake</a> | 1 | <a href="https://www.ukclimbing.com/logbook/crags/silver_lake-31107" rel="noopener noreferrer">UKC</a> | None | None | None
<a href="/crag/1580/staple-edge-quarry-ruspidge-west-quarry" rel="noopener noreferrer">Staple Edge Quarry Ruspidge West Quarry</a> | 1 | <a href="https://www.ukclimbing.com/logbook/crags/staple_edge_quarry_ruspidge_west_quarry-1580" rel="noopener noreferrer">UKC</a> | None | None | None
<a href="/crag/881/third-sister-to-zulu-zawn" rel="noopener noreferrer">Third Sister To Zulu Zawn</a> | 1 | <a href="https://www.ukclimbing.com/logbook/crags/third_sister_to_zulu_zawn-881" rel="noopener noreferrer">UKC</a> | None | None | None
<a href="/crag/34296/thompsons-point" rel="noopener noreferrer">Thompsons Point</a> | 1 | <a href="https://www.ukclimbing.com/logbook/crags/thompsons_point-3462" rel="noopener noreferrer">UKC</a> | None | None | None
<a href="/crag/26482/uig-sea-cliffs-north---crowlista" rel="noopener noreferrer">Uig Sea Cliffs North - Crowlista</a> | 1 | <a href="https://www.ukclimbing.com/logbook/crags/uig_sea_cliffs_north_-_crowlista-26482" rel="noopener noreferrer">UKC</a> | None | None | None
<a href="/crag/512/zawn-kellys-area" rel="noopener noreferrer">Zawn Kellys Area</a> | 1 | <a href="https://www.ukclimbing.com/logbook/crags/zawn_kellys_area-512" rel="noopener noreferrer">UKC</a> | None | None | None</p>
|
|||||||
| 1202 | 16th May 2026 | 13:38:52 UTC | baz9 | list | Crags Without Coordinates OR Country Meta | list_description | |
|
Before
This is a list of crags that have no location coordinates OR country meta.
We also have: [https://climbing-history.org/list/106/crags-without-coordinates](https://climbing-history.org/list/106/crags-without-coordinates)
After
This is a list of crags that have no location coordinates OR country meta.
We also have: [/list/106/crags-without-coordinates](/list/106/crags-without-coordinates)
Diff
--- before
|
|||||||
| 1203 | 16th May 2026 | 13:38:52 UTC | baz9 | list | Crags Without Coordinates OR Country Meta | list_description_pretty | |
|
Before
<p>This is a list of crags that have no location coordinates OR country meta.</p>
<p>We also have: <a href="https://climbing-history.org/list/106/crags-without-coordinates" rel="noopener noreferrer">https://climbing-history.org/list/106/crags-without-coordinates</a></p>
After
<p>This is a list of crags that have no location coordinates OR country meta.</p>
<p>We also have: <a href="/list/106/crags-without-coordinates" rel="noopener noreferrer">/list/106/crags-without-coordinates</a></p>
|
|||||||
| 1204 | 16th May 2026 | 13:38:20 UTC | baz9 | list | Crags Without Coordinates OR Country Meta | list_description_pretty | |
|
Before
<p>This is a list of crags that have no location coordinates OR country meta.</p>
After
<p>This is a list of crags that have no location coordinates OR country meta.</p>
<p>We also have: <a href="https://climbing-history.org/list/106/crags-without-coordinates" rel="noopener noreferrer">https://climbing-history.org/list/106/crags-without-coordinates</a></p>
|
|||||||
| 1205 | 16th May 2026 | 13:38:20 UTC | baz9 | list | Crags Without Coordinates OR Country Meta | list_description | |
|
Before
This is a list of crags that have no location coordinates OR country meta.
After
This is a list of crags that have no location coordinates OR country meta.
We also have: [https://climbing-history.org/list/106/crags-without-coordinates](https://climbing-history.org/list/106/crags-without-coordinates)
Diff
--- before
|
|||||||
| 1206 | 16th May 2026 | 13:37:40 UTC | baz9 | list | Crags Without Coordinates | list_description_pretty | |
|
Before
<p>This is a list of crags that have no location coordinates. </p>
After
<p>This is a list of crags that have no location coordinates. </p>
<p>Some crags in this list have secret locations so we have added a broad 'country' meta. </p>
<p>I have created another list of crags without Coordinates OR Country meta, here:
<a href="https://climbing-history.org/list/115/crags-without-coordinates-or-country-meta" rel="noopener noreferrer">https://climbing-history.org/list/115/crags-without-coordinates-or-country-meta</a></p>
|
|||||||
| 1207 | 16th May 2026 | 13:37:40 UTC | baz9 | list | Crags Without Coordinates | list_description | |
|
Before
This is a list of crags that have no location coordinates.
After
This is a list of crags that have no location coordinates.
Some crags in this list have secret locations so we have added a broad 'country' meta.
I have created another list of crags without Coordinates OR Country meta, here:
[https://climbing-history.org/list/115/crags-without-coordinates-or-country-meta](https://climbing-history.org/list/115/crags-without-coordinates-or-country-meta)
Diff
--- before
|
|||||||
| 1208 | 16th May 2026 | 13:34:38 UTC | baz9 | list | Crags Without Coordinates OR Country Meta | list_name | |
|
Before
None
After
Crags Without Coordinates OR Country Meta
|
|||||||
| 1209 | 16th May 2026 | 13:34:38 UTC | baz9 | list | Crags Without Coordinates OR Country Meta | list_description | |
|
Before
None
After
This is a list of crags that have no location coordinates OR country meta.
Diff
--- before
|
|||||||
| 1210 | 16th May 2026 | 13:34:38 UTC | baz9 | list | Crags Without Coordinates OR Country Meta | list_description_pretty | |
|
Before
None
After
<p>This is a list of crags that have no location coordinates OR country meta.</p>
|
|||||||
| 1211 | 16th May 2026 | 13:34:38 UTC | baz9 | list | Crags Without Coordinates OR Country Meta | list_type_id | |
|
Before
None
After
6
|
|||||||
| 1212 | 16th May 2026 | 13:34:38 UTC | baz9 | list | Crags Without Coordinates OR Country Meta | list_definition | |
|
Before
None
After
select
'<a href="' || c.url || '">' || c.crag_name || '</a>' as Crag
,coalesce(cc.cnt_climbs, 0) as Climbs
,case
when c.ukc_url is not null then '<a href="' || c.ukc_url || '">UKC</a>'
else null
end as UKC
,case
when c.eight_a_nu_url is not null then '<a href="' || c.eight_a_nu_url || '">8a.nu</a>'
else null
end as "8a.nu"
,case
when w.thecrag_url is not null then '<a href="' || w.thecrag_url || '">theCrag</a>'
else null
end as "theCrag"
,case
when w.crags27_url is not null then '<a href="' || w.crags27_url || '">27crags</a>'
else null
end as "27crags"
from
crags c
left join (
select
cl.crag_id
,count(*) as cnt_climbs
from
climbs cl
where
cl.deleted_on is null
group by
cl.crag_id
) cc
on cc.crag_id = c.crag_id
left join (
select
cm.crag_id
,max(case when cm.value ilike '%thecrag.com%' then cm.value end) as thecrag_url
,max(
case
when cm.value ilike '%27crags.com%'
or cm.value ilike '%thetopo.com%'
then cm.value
end
) as crags27_url
from
crag_meta cm
where
cm.crag_meta_key_id = 1
group by
cm.crag_id
) w
on w.crag_id = c.crag_id
where
c.deleted_on is null
and c.group_crag_id is null
and c.latitude is null
and c.longitude is null
and not exists (
select
1
from
crag_meta cm_country
where
cm_country.crag_id = c.crag_id
and cm_country.crag_meta_key_id = 6
)
order by
coalesce(cc.cnt_climbs, 0) desc
,c.crag_name
Diff
--- before
|
|||||||
| 1213 | 16th May 2026 | 13:34:38 UTC | baz9 | list | Crags Without Coordinates OR Country Meta | list_type_name | |
|
Before
None
After
Admin
|
|||||||
| 1214 | 16th May 2026 | 13:33:27 UTC | baz9 | list | Crags Without Coordinates | list_definition | |
|
Before
select
'<a href="' || c.url || '">' || c.crag_name || '</a>' as Crag
,coalesce(cc.cnt_climbs, 0) as Climbs
,case
when c.ukc_url is not null then '<a href="' || c.ukc_url || '">UKC</a>'
else null
end as UKC
,case
when c.eight_a_nu_url is not null then '<a href="' || c.eight_a_nu_url || '">8a.nu</a>'
else null
end as "8a.nu"
,case
when w.thecrag_url is not null then '<a href="' || w.thecrag_url || '">theCrag</a>'
else null
end as "theCrag"
,case
when w.crags27_url is not null then '<a href="' || w.crags27_url || '">27crags</a>'
else null
end as "27crags"
from
crags c
left join (
select
cl.crag_id
,count(*) as cnt_climbs
from
climbs cl
where
cl.deleted_on is null
group by
cl.crag_id
) cc
on cc.crag_id = c.crag_id
left join (
select
cm.crag_id
,max(case when cm.value ilike '%thecrag.com%' then cm.value end) as thecrag_url
,max(
case
when cm.value ilike '%27crags.com%'
or cm.value ilike '%thetopo.com%'
then cm.value
end
) as crags27_url
from
crag_meta cm
where
cm.crag_meta_key_id = 1
group by
cm.crag_id
) w
on w.crag_id = c.crag_id
where
c.deleted_on is null
and c.group_crag_id is null
and c.latitude is null
and c.longitude is null
and not exists (
select
1
from
crag_meta cm_country
where
cm_country.crag_id = c.crag_id
and cm_country.crag_meta_key_id = 6
)
order by
coalesce(cc.cnt_climbs, 0) desc
,c.crag_name
After
select
'<a href="' || c.url || '">' || c.crag_name || '</a>' as Crag
,coalesce(cc.cnt_climbs, 0) as Climbs
,case
when c.ukc_url is not null then '<a href="' || c.ukc_url || '">UKC</a>'
else null
end as UKC
,case
when c.eight_a_nu_url is not null then '<a href="' || c.eight_a_nu_url || '">8a.nu</a>'
else null
end as "8a.nu"
,case
when w.thecrag_url is not null then '<a href="' || w.thecrag_url || '">theCrag</a>'
else null
end as "theCrag"
,case
when w.crags27_url is not null then '<a href="' || w.crags27_url || '">27crags</a>'
else null
end as "27crags"
from
crags c
left join (
select
cl.crag_id
,count(*) as cnt_climbs
from
climbs cl
where
cl.deleted_on is null
group by
cl.crag_id
) cc
on cc.crag_id = c.crag_id
left join (
select
cm.crag_id
,max(case when cm.value ilike '%thecrag.com%' then cm.value end) as thecrag_url
,max(
case
when cm.value ilike '%27crags.com%'
or cm.value ilike '%thetopo.com%'
then cm.value
end
) as crags27_url
from
crag_meta cm
where
cm.crag_meta_key_id = 1
group by
cm.crag_id
) w
on w.crag_id = c.crag_id
where
c.deleted_on is null
and c.group_crag_id is null
and c.latitude is null
and c.longitude is null
order by
coalesce(cc.cnt_climbs, 0) desc
,c.crag_name
Diff
--- before
|
|||||||
| 1215 | 16th May 2026 | 13:32:59 UTC | baz9 | list | Crags Without Coordinates | list_name | |
|
Before
Crags Without Locations
After
Crags Without Coordinates
|
|||||||
| 1216 | 16th May 2026 | 13:32:02 UTC | baz9 | list | Crags Without Coordinates | list_definition | |
|
Before
select
'<a href="' || c.url || '">' || c.crag_name || '</a>' as Crag
,coalesce(cc.cnt_climbs, 0) as Climbs
,case
when c.ukc_url is not null then '<a href="' || c.ukc_url || '">UKC</a>'
else null
end as UKC
,case
when c.eight_a_nu_url is not null then '<a href="' || c.eight_a_nu_url || '">8a.nu</a>'
else null
end as "8a.nu"
,case
when w.thecrag_url is not null then '<a href="' || w.thecrag_url || '">theCrag</a>'
else null
end as "theCrag"
,case
when w.crags27_url is not null then '<a href="' || w.crags27_url || '">27crags</a>'
else null
end as "27crags"
from
crags c
left join (
select
cl.crag_id
,count(*) as cnt_climbs
from
climbs cl
where
cl.deleted_on is null
group by
cl.crag_id
) cc
on cc.crag_id = c.crag_id
left join (
select
cm.crag_id
,max(case when cm.value ilike '%thecrag.com%' then cm.value end) as thecrag_url
,max(
case
when cm.value ilike '%27crags.com%'
or cm.value ilike '%thetopo.com%'
then cm.value
end
) as crags27_url
from
crag_meta cm
where
cm.crag_meta_key_id = 1
group by
cm.crag_id
) w
on w.crag_id = c.crag_id
where
c.deleted_on is null
and c.group_crag_id is null
and c.latitude is null
and c.longitude is null
order by
coalesce(cc.cnt_climbs, 0) desc
,c.crag_name
After
select
'<a href="' || c.url || '">' || c.crag_name || '</a>' as Crag
,coalesce(cc.cnt_climbs, 0) as Climbs
,case
when c.ukc_url is not null then '<a href="' || c.ukc_url || '">UKC</a>'
else null
end as UKC
,case
when c.eight_a_nu_url is not null then '<a href="' || c.eight_a_nu_url || '">8a.nu</a>'
else null
end as "8a.nu"
,case
when w.thecrag_url is not null then '<a href="' || w.thecrag_url || '">theCrag</a>'
else null
end as "theCrag"
,case
when w.crags27_url is not null then '<a href="' || w.crags27_url || '">27crags</a>'
else null
end as "27crags"
from
crags c
left join (
select
cl.crag_id
,count(*) as cnt_climbs
from
climbs cl
where
cl.deleted_on is null
group by
cl.crag_id
) cc
on cc.crag_id = c.crag_id
left join (
select
cm.crag_id
,max(case when cm.value ilike '%thecrag.com%' then cm.value end) as thecrag_url
,max(
case
when cm.value ilike '%27crags.com%'
or cm.value ilike '%thetopo.com%'
then cm.value
end
) as crags27_url
from
crag_meta cm
where
cm.crag_meta_key_id = 1
group by
cm.crag_id
) w
on w.crag_id = c.crag_id
where
c.deleted_on is null
and c.group_crag_id is null
and c.latitude is null
and c.longitude is null
and not exists (
select
1
from
crag_meta cm_country
where
cm_country.crag_id = c.crag_id
and cm_country.crag_meta_key_id = 6
)
order by
coalesce(cc.cnt_climbs, 0) desc
,c.crag_name
Diff
--- before
|
|||||||
| 1217 | 16th May 2026 | 13:31:43 UTC | baz9 | crag | Eldora | Hidden Note | |
|
Before
None
After
No coordinates because it's a 'secret' crag.
|
|||||||
| 1218 | 16th May 2026 | 13:31:09 UTC | baz9 | crag | Eldora | notes | |
|
Before
I didn’t add coordinates bc the locals don’t like it known. It’s in CO, USA
After
CO, USA
Diff
--- before
|
|||||||
| 1219 | 16th May 2026 | 13:31:09 UTC | baz9 | crag | Eldora | notes_pretty | |
|
Before
<p>I didn’t add coordinates bc the locals don’t like it known. It’s in CO, USA</p>
After
<p>CO, USA</p>
|
|||||||
| 1220 | 16th May 2026 | 13:30:35 UTC | baz9 | crag | Eldora | Country | |
|
Before
None
After
2
|
|||||||