baz9

	Name	Type	# Changes	Last Updated	First Updated
1	https://www.instagram.com/p/DLG3qSwxRoF/	media	45	26th April 2026	8th April 2026
2	https://www.instagram.com/reel/DKttE1YNfkN/	media	39	9th April 2026	8th April 2026
3	https://www.instagram.com/reel/DFIq7X8NAIi/	media	36	29th March 2026	29th March 2026
4	Jordan Cannon	climber	32	27th April 2026	23rd March 2026
5	Notable Queer Climbers	list	32	27th April 2026	23rd March 2026
6	https://open.spotify.com/episode/5EREAaZGQcasxpoY6oDXor	media	31	6th March 2026	4th February 2026
7	Chuck Odette	climber	28	26th March 2026	25th March 2026
8	https://open.spotify.com/episode/5NHG7EfwMMQnphpUyAIm2Z	media	28	27th March 2026	27th March 2026
9	Oldest Ascents (with date ranges)	list	28	24th March 2026	23rd March 2026
10	Six Degrees	climb	27	20th February 2026	20th November 2025

	Date	Time	User	Type	Name	Attribute
1721	24th March 2026	00:53:35 UTC	baz9	list	Oldest Ascents (with date ranges)	list_description
Before `Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents) The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum age of ascent based on the data we have. Ideally we want to source the exact dates for the ascents listed here.` After `Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents) The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum age of ascent. Ideally we want to source the exact dates for the ascents listed here.` Diff --- before +++ after @@ -1,3 +1,3 @@ Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents) -The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum age of ascent based on the data we have. Ideally we want to source the exact dates for the ascents listed here. +The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum age of ascent. Ideally we want to source the exact dates for the ascents listed here.
1722	24th March 2026	00:53:35 UTC	baz9	list	Oldest Ascents (with date ranges)	list_description_pretty
Before `<p>Main list here: <a href="https://climbing-history.org/list/82/oldest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/82/oldest-ascents</a></p> <p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers <em>minimum age of ascent</em> based on the data we have. Ideally we want to source the exact dates for the ascents listed here.</p>` After `<p>Main list here: <a href="https://climbing-history.org/list/82/oldest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/82/oldest-ascents</a></p> <p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers <em>minimum</em> age of ascent. Ideally we want to source the exact dates for the ascents listed here.</p>`
1723	24th March 2026	00:53:13 UTC	baz9	list	Oldest Ascents (with date ranges)	list_description
Before `Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents) The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age of ascent based on the data we have. Ideally we want to source the exact dates for the ascents listed here.` After `Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents) The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum age of ascent based on the data we have. Ideally we want to source the exact dates for the ascents listed here.` Diff --- before +++ after @@ -1,3 +1,3 @@ Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents) -The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age of ascent based on the data we have. Ideally we want to source the exact dates for the ascents listed here. +The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum age of ascent based on the data we have. Ideally we want to source the exact dates for the ascents listed here.
1724	24th March 2026	00:53:13 UTC	baz9	list	Oldest Ascents (with date ranges)	list_description_pretty
Before <p>Main list here: <a href="https://climbing-history.org/list/82/oldest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/82/oldest-ascents</a></p> <p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers <em>minimum possible age of ascent</em> based on the data we have. Ideally we want to source the exact dates for the ascents listed here.</p> After `<p>Main list here: <a href="https://climbing-history.org/list/82/oldest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/82/oldest-ascents</a></p> <p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers <em>minimum age of ascent</em> based on the data we have. Ideally we want to source the exact dates for the ascents listed here.</p>`
1725	24th March 2026	00:52:56 UTC	baz9	list	Oldest Ascents (with date ranges)	list_description_pretty
Before `<p>Main list here: <a href="https://climbing-history.org/list/82/oldest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/82/oldest-ascents</a></p> <p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.</p>` After <p>Main list here: <a href="https://climbing-history.org/list/82/oldest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/82/oldest-ascents</a></p> <p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers <em>minimum possible age of ascent</em> based on the data we have. Ideally we want to source the exact dates for the ascents listed here.</p>
1726	24th March 2026	00:52:56 UTC	baz9	list	Oldest Ascents (with date ranges)	list_description
Before `Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents) The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.` After `Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents) The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age of ascent based on the data we have. Ideally we want to source the exact dates for the ascents listed here.` Diff --- before +++ after @@ -1,3 +1,3 @@ Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents) -The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here. +The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age of ascent based on the data we have. Ideally we want to source the exact dates for the ascents listed here.
1727	24th March 2026	00:52:18 UTC	baz9	list	Youngest Ascents (with date ranges)	list_description
Before `Main list here: [https://climbing-history.org/list/57/youngest-ascents](https://climbing-history.org/list/57/youngest-ascents) The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers maximum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.` After `Main list here: [https://climbing-history.org/list/57/youngest-ascents](https://climbing-history.org/list/57/youngest-ascents) The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers maximum possible age of ascent based on the data we have. Ideally we want to source the exact dates for the ascents listed here.` Diff --- before +++ after @@ -1,3 +1,3 @@ Main list here: [https://climbing-history.org/list/57/youngest-ascents](https://climbing-history.org/list/57/youngest-ascents) -The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers maximum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here. +The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers maximum possible age of ascent based on the data we have. Ideally we want to source the exact dates for the ascents listed here.
1728	24th March 2026	00:52:18 UTC	baz9	list	Youngest Ascents (with date ranges)	list_description_pretty
Before `<p>Main list here: <a href="https://climbing-history.org/list/57/youngest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/57/youngest-ascents</a></p> <p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers <em>maximum</em> possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.</p>` After <p>Main list here: <a href="https://climbing-history.org/list/57/youngest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/57/youngest-ascents</a></p> <p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers <em>maximum possible age of ascent</em> based on the data we have. Ideally we want to source the exact dates for the ascents listed here.</p>
1729	24th March 2026	00:51:54 UTC	baz9	list	Youngest Ascents (with date ranges)	list_description_pretty
Before `<p>Main list here: <a href="https://climbing-history.org/list/57/youngest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/57/youngest-ascents</a></p> <p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.</p>` After `<p>Main list here: <a href="https://climbing-history.org/list/57/youngest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/57/youngest-ascents</a></p> <p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers <em>maximum</em> possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.</p>`
1730	24th March 2026	00:51:54 UTC	baz9	list	Youngest Ascents (with date ranges)	list_description
Before `Main list here: [https://climbing-history.org/list/57/youngest-ascents](https://climbing-history.org/list/57/youngest-ascents) The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.` After `Main list here: [https://climbing-history.org/list/57/youngest-ascents](https://climbing-history.org/list/57/youngest-ascents) The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers maximum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.` Diff --- before +++ after @@ -1,3 +1,3 @@ Main list here: [https://climbing-history.org/list/57/youngest-ascents](https://climbing-history.org/list/57/youngest-ascents) -The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here. +The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers maximum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.
1731	24th March 2026	00:50:55 UTC	baz9	list	Youngest Ascents (with date ranges)	list_description_pretty
Before `None` After `<p>Main list here: <a href="https://climbing-history.org/list/57/youngest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/57/youngest-ascents</a></p> <p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.</p>`
1732	24th March 2026	00:50:55 UTC	baz9	list	Youngest Ascents (with date ranges)	list_type_id
Before `None` After `5`
1733	24th March 2026	00:50:55 UTC	baz9	list	Youngest Ascents (with date ranges)	list_type_name
Before `None` After `Misc.`
1734	24th March 2026	00:50:55 UTC	baz9	list	Youngest Ascents (with date ranges)	list_name
Before `None` After `Youngest Ascents (with date ranges)`
1735	24th March 2026	00:50:55 UTC	baz9	list	Youngest Ascents (with date ranges)	list_description
Before `None` After `Main list here: [https://climbing-history.org/list/57/youngest-ascents](https://climbing-history.org/list/57/youngest-ascents) The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.` Diff `--- before +++ after @@ -1 +1,3 @@ - +Main list here: [https://climbing-history.org/list/57/youngest-ascents](https://climbing-history.org/list/57/youngest-ascents) + +The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.`
1736	24th March 2026	00:50:55 UTC	baz9	list	Youngest Ascents (with date ranges)	list_definition
Before `None` After with climbers_with_dobs as ( select c.climber_id ,c.climber_name ,c.date_of_birth_start ,c.date_of_birth_end from climbers c where c.deleted_on is null and c.date_of_birth_start is not null and c.date_of_birth_end is not null ), ascents_with_ages as ( select row_number() over ( partition by g.grade_id order by a.ascent_dt_end - c.date_of_birth_start 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 ,a.ascent_dt_end ,c.date_of_birth_start ,c.date_of_birth_end ,a.ascent_dt_start - c.date_of_birth_end as min_age_in_days_at_ascent ,a.ascent_dt_end - c.date_of_birth_start as max_age_in_days_at_ascent ,extract(year from age(a.ascent_dt_start, c.date_of_birth_end))::integer as min_age_in_years_at_ascent ,extract(year from age(a.ascent_dt_end, c.date_of_birth_start))::integer as max_age_in_years_at_ascent 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 is not null and a.ascent_dt_end is not null ), oldest as ( select * from ascents_with_ages where row_number = 1 ) select o.grade ,'<a href="/climber/' \|\| o.climber_id::varchar \|\| '">' \|\| o.climber_name \|\| '</a>' as "Climber" ,'<a href="/climb/' \|\| o.climb_id::varchar \|\| '">' \|\| o.climb_name \|\| '</a>' as "Climb" ,o.min_age_in_days_at_ascent as "Minimum age (days)" ,case when o.min_age_in_days_at_ascent = o.max_age_in_days_at_ascent then o.min_age_in_years_at_ascent \|\| ' years ' \|\| extract(days from o.ascent_dt_start - (o.date_of_birth_end + make_interval(years => o.min_age_in_years_at_ascent))) \|\| ' days' else o.min_age_in_years_at_ascent \|\| ' years ' \|\| extract(days from o.ascent_dt_start - (o.date_of_birth_end + make_interval(years => o.min_age_in_years_at_ascent))) \|\| ' days to ' \|\| o.max_age_in_years_at_ascent \|\| ' years ' \|\| extract(days from o.ascent_dt_end - (o.date_of_birth_start + make_interval(years => o.max_age_in_years_at_ascent))) \|\| ' days' end as "Age" ,case when o.min_age_in_days_at_ascent = o.max_age_in_days_at_ascent then '' else '✓' end as "Dates Needed" from oldest o where case when o.grade_system_id = 1 and o.order_on >= 13 then 1 when o.grade_system_id = 2 and o.order_on >= 60 then 1 when o.grade_system_id = 3 and o.order_on >= 37 then 1 else 0 end = 1 and o.climb_type_id in (1,2,3) order by o.grade_system_id ,o.order_on Diff --- before +++ after @@ -1 +1,102 @@ +with climbers_with_dobs as ( + select + c.climber_id + ,c.climber_name + ,c.date_of_birth_start + ,c.date_of_birth_end + + from + climbers c + + where + c.deleted_on is null + and c.date_of_birth_start is not null + and c.date_of_birth_end is not null +), ascents_with_ages as ( + select + row_number() over ( + partition by g.grade_id + order by a.ascent_dt_end - c.date_of_birth_start 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 + ,a.ascent_dt_end + ,c.date_of_birth_start + ,c.date_of_birth_end + ,a.ascent_dt_start - c.date_of_birth_end as min_age_in_days_at_ascent + ,a.ascent_dt_end - c.date_of_birth_start as max_age_in_days_at_ascent + ,extract(year from age(a.ascent_dt_start, c.date_of_birth_end))::integer as min_age_in_years_at_ascent + ,extract(year from age(a.ascent_dt_end, c.date_of_birth_start))::integer as max_age_in_years_at_ascent + + 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 is not null + and a.ascent_dt_end is not null +), oldest as ( + select + * + + from + ascents_with_ages + + where + row_number = 1 +) + +select + o.grade + ,'' \|\| o.climber_name \|\| '' as "Climber" + ,'' \|\| o.climb_name \|\| '' as "Climb" + ,o.min_age_in_days_at_ascent as "Minimum age (days)" + ,case + when o.min_age_in_days_at_ascent = o.max_age_in_days_at_ascent then + o.min_age_in_years_at_ascent \|\| ' years ' \|\| + extract(days from o.ascent_dt_start - (o.date_of_birth_end + make_interval(years => o.min_age_in_years_at_ascent))) \|\| + ' days' + else + o.min_age_in_years_at_ascent \|\| ' years ' \|\| + extract(days from o.ascent_dt_start - (o.date_of_birth_end + make_interval(years => o.min_age_in_years_at_ascent))) \|\| + ' days to ' \|\| + o.max_age_in_years_at_ascent \|\| ' years ' \|\| + extract(days from o.ascent_dt_end - (o.date_of_birth_start + make_interval(years => o.max_age_in_years_at_ascent))) \|\| + ' days' + end as "Age" + ,case + when o.min_age_in_days_at_ascent = o.max_age_in_days_at_ascent then '' + else '✓' + end as "Dates Needed" + +from + oldest o + +where + case + when o.grade_system_id = 1 and o.order_on >= 13 then 1 + when o.grade_system_id = 2 and o.order_on >= 60 then 1 + when o.grade_system_id = 3 and o.order_on >= 37 then 1 + else 0 + end = 1 + and o.climb_type_id in (1,2,3) + +order by + o.grade_system_id + ,o.order_on
1737	24th March 2026	00:27:12 UTC	baz9	list	Oldest Ascents (with date ranges)	list_description_pretty
Before `<p>Main list here: <a href="https://climbing-history.org/list/82/oldest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/82/oldest-ascents</a></p> <p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact info for the ascents listed here.</p>` After `<p>Main list here: <a href="https://climbing-history.org/list/82/oldest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/82/oldest-ascents</a></p> <p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.</p>`
1738	24th March 2026	00:27:12 UTC	baz9	list	Oldest Ascents (with date ranges)	list_description
Before `Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents) The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact info for the ascents listed here.` After `Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents) The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.` Diff --- before +++ after @@ -1,3 +1,3 @@ Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents) -The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact info for the ascents listed here. +The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.
1739	24th March 2026	00:26:56 UTC	baz9	list	Oldest Ascents (with date ranges)	list_description
Before `See also [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents) This is a list of the oldest ascents at each grade.` After `Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents) The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact info for the ascents listed here.` Diff --- before +++ after @@ -1,3 +1,3 @@ -See also [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents) +Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents) -This is a list of the oldest ascents at each grade. +The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact info for the ascents listed here.
1740	24th March 2026	00:26:56 UTC	baz9	list	Oldest Ascents (with date ranges)	list_description_pretty
Before `<p>See also <a href="https://climbing-history.org/list/82/oldest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/82/oldest-ascents</a></p> <p>This is a list of the oldest ascents at each grade.</p>` After `<p>Main list here: <a href="https://climbing-history.org/list/82/oldest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/82/oldest-ascents</a></p> <p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact info for the ascents listed here.</p>`

Before

Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents)

The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers *minimum age of ascent* based on the data we have. Ideally we want to source the exact dates for the ascents listed here.

After

Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents)

The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers *minimum* age of ascent. Ideally we want to source the exact dates for the ascents listed here.

Diff

--- before

+++ after

@@ -1,3 +1,3 @@

 Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents)

 

-The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers *minimum age of ascent* based on the data we have. Ideally we want to source the exact dates for the ascents listed here.
+The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers *minimum* age of ascent. Ideally we want to source the exact dates for the ascents listed here.

Before

<p>Main list here: <a href="https://climbing-history.org/list/82/oldest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/82/oldest-ascents</a></p>
<p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers <em>minimum age of ascent</em> based on the data we have. Ideally we want to source the exact dates for the ascents listed here.</p>

After

<p>Main list here: <a href="https://climbing-history.org/list/82/oldest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/82/oldest-ascents</a></p>
<p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers <em>minimum</em> age of ascent. Ideally we want to source the exact dates for the ascents listed here.</p>

Before

Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents)

The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers *minimum possible age of ascent* based on the data we have. Ideally we want to source the exact dates for the ascents listed here.

After

Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents)

The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers *minimum age of ascent* based on the data we have. Ideally we want to source the exact dates for the ascents listed here.

Diff

--- before

+++ after

@@ -1,3 +1,3 @@

 Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents)

 

-The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers *minimum possible age of ascent* based on the data we have. Ideally we want to source the exact dates for the ascents listed here.
+The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers *minimum age of ascent* based on the data we have. Ideally we want to source the exact dates for the ascents listed here.

Before

<p>Main list here: <a href="https://climbing-history.org/list/82/oldest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/82/oldest-ascents</a></p>
<p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers <em>minimum possible age of ascent</em> based on the data we have. Ideally we want to source the exact dates for the ascents listed here.</p>

After

<p>Main list here: <a href="https://climbing-history.org/list/82/oldest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/82/oldest-ascents</a></p>
<p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers <em>minimum age of ascent</em> based on the data we have. Ideally we want to source the exact dates for the ascents listed here.</p>

Before

<p>Main list here: <a href="https://climbing-history.org/list/82/oldest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/82/oldest-ascents</a></p>
<p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.</p>

After

<p>Main list here: <a href="https://climbing-history.org/list/82/oldest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/82/oldest-ascents</a></p>
<p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers <em>minimum possible age of ascent</em> based on the data we have. Ideally we want to source the exact dates for the ascents listed here.</p>

Before

Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents)

The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.

After

Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents)

The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers *minimum possible age of ascent* based on the data we have. Ideally we want to source the exact dates for the ascents listed here.

Diff

--- before

+++ after

@@ -1,3 +1,3 @@

 Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents)

 

-The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.
+The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers *minimum possible age of ascent* based on the data we have. Ideally we want to source the exact dates for the ascents listed here.

Before

Main list here: [https://climbing-history.org/list/57/youngest-ascents](https://climbing-history.org/list/57/youngest-ascents)

The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers *maximum* possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.

After

Main list here: [https://climbing-history.org/list/57/youngest-ascents](https://climbing-history.org/list/57/youngest-ascents)

The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers *maximum possible age of ascent* based on the data we have. Ideally we want to source the exact dates for the ascents listed here.

Diff

--- before

+++ after

@@ -1,3 +1,3 @@

 Main list here: [https://climbing-history.org/list/57/youngest-ascents](https://climbing-history.org/list/57/youngest-ascents)

 

-The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers *maximum* possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.
+The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers *maximum possible age of ascent* based on the data we have. Ideally we want to source the exact dates for the ascents listed here.

Before

<p>Main list here: <a href="https://climbing-history.org/list/57/youngest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/57/youngest-ascents</a></p>
<p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers <em>maximum</em> possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.</p>

After

<p>Main list here: <a href="https://climbing-history.org/list/57/youngest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/57/youngest-ascents</a></p>
<p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers <em>maximum possible age of ascent</em> based on the data we have. Ideally we want to source the exact dates for the ascents listed here.</p>

Before

<p>Main list here: <a href="https://climbing-history.org/list/57/youngest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/57/youngest-ascents</a></p>
<p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.</p>

After

<p>Main list here: <a href="https://climbing-history.org/list/57/youngest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/57/youngest-ascents</a></p>
<p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers <em>maximum</em> possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.</p>

Before

Main list here: [https://climbing-history.org/list/57/youngest-ascents](https://climbing-history.org/list/57/youngest-ascents)

The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.

After

Main list here: [https://climbing-history.org/list/57/youngest-ascents](https://climbing-history.org/list/57/youngest-ascents)

The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers *maximum* possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.

Diff

--- before

+++ after

@@ -1,3 +1,3 @@

 Main list here: [https://climbing-history.org/list/57/youngest-ascents](https://climbing-history.org/list/57/youngest-ascents)

 

-The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.
+The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers *maximum* possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.

Before

None

After

<p>Main list here: <a href="https://climbing-history.org/list/57/youngest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/57/youngest-ascents</a></p>
<p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.</p>

Before

None

After

5

Before

None

After

Misc.

Before

None

After

Youngest Ascents (with date ranges)

Before

None

After

Main list here: [https://climbing-history.org/list/57/youngest-ascents](https://climbing-history.org/list/57/youngest-ascents)

The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.

Diff

--- before

+++ after

@@ -1 +1,3 @@

-
+Main list here: [https://climbing-history.org/list/57/youngest-ascents](https://climbing-history.org/list/57/youngest-ascents)

+

+The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.

Before

None

After

with climbers_with_dobs as (
  select
    c.climber_id
    ,c.climber_name
    ,c.date_of_birth_start
    ,c.date_of_birth_end

  from
    climbers c

  where
    c.deleted_on is null
    and c.date_of_birth_start is not null
    and c.date_of_birth_end is not null
), ascents_with_ages as (
  select
    row_number() over (
      partition by g.grade_id
      order by a.ascent_dt_end - c.date_of_birth_start 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
    ,a.ascent_dt_end
    ,c.date_of_birth_start
    ,c.date_of_birth_end
    ,a.ascent_dt_start - c.date_of_birth_end as min_age_in_days_at_ascent
    ,a.ascent_dt_end - c.date_of_birth_start as max_age_in_days_at_ascent
    ,extract(year from age(a.ascent_dt_start, c.date_of_birth_end))::integer as min_age_in_years_at_ascent
    ,extract(year from age(a.ascent_dt_end, c.date_of_birth_start))::integer as max_age_in_years_at_ascent

  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 is not null
    and a.ascent_dt_end is not null
), oldest as (
  select
    *

  from
    ascents_with_ages

  where
    row_number = 1
)

select
  o.grade
  ,'<a href="/climber/' || o.climber_id::varchar || '">' || o.climber_name || '</a>' as "Climber"
  ,'<a href="/climb/' || o.climb_id::varchar || '">' || o.climb_name || '</a>' as "Climb"
  ,o.min_age_in_days_at_ascent as "Minimum age (days)"
  ,case
    when o.min_age_in_days_at_ascent = o.max_age_in_days_at_ascent then
      o.min_age_in_years_at_ascent || ' years ' ||
      extract(days from o.ascent_dt_start - (o.date_of_birth_end + make_interval(years => o.min_age_in_years_at_ascent))) ||
      ' days'
    else
      o.min_age_in_years_at_ascent || ' years ' ||
      extract(days from o.ascent_dt_start - (o.date_of_birth_end + make_interval(years => o.min_age_in_years_at_ascent))) ||
      ' days to ' ||
      o.max_age_in_years_at_ascent || ' years ' ||
      extract(days from o.ascent_dt_end - (o.date_of_birth_start + make_interval(years => o.max_age_in_years_at_ascent))) ||
      ' days'
  end as "Age"
  ,case
    when o.min_age_in_days_at_ascent = o.max_age_in_days_at_ascent then ''
    else '✓'
  end as "Dates Needed"

from
  oldest o

where
  case
    when o.grade_system_id = 1 and o.order_on >= 13 then 1
    when o.grade_system_id = 2 and o.order_on >= 60 then 1
    when o.grade_system_id = 3 and o.order_on >= 37 then 1
    else 0
  end = 1
  and o.climb_type_id in (1,2,3)

order by
  o.grade_system_id
  ,o.order_on

Diff

--- before

+++ after

@@ -1 +1,102 @@

+with climbers_with_dobs as (

+  select

+    c.climber_id

+    ,c.climber_name

+    ,c.date_of_birth_start

+    ,c.date_of_birth_end

+

+  from

+    climbers c

+

+  where

+    c.deleted_on is null

+    and c.date_of_birth_start is not null

+    and c.date_of_birth_end is not null

+), ascents_with_ages as (

+  select

+    row_number() over (

+      partition by g.grade_id

+      order by a.ascent_dt_end - c.date_of_birth_start 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

+    ,a.ascent_dt_end

+    ,c.date_of_birth_start

+    ,c.date_of_birth_end

+    ,a.ascent_dt_start - c.date_of_birth_end as min_age_in_days_at_ascent

+    ,a.ascent_dt_end - c.date_of_birth_start as max_age_in_days_at_ascent

+    ,extract(year from age(a.ascent_dt_start, c.date_of_birth_end))::integer as min_age_in_years_at_ascent

+    ,extract(year from age(a.ascent_dt_end, c.date_of_birth_start))::integer as max_age_in_years_at_ascent

+

+  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 is not null

+    and a.ascent_dt_end is not null

+), oldest as (

+  select

+    *

+

+  from

+    ascents_with_ages

+

+  where

+    row_number = 1

+)

+

+select

+  o.grade

+  ,'' || o.climber_name || '' as "Climber"

+  ,'' || o.climb_name || '' as "Climb"

+  ,o.min_age_in_days_at_ascent as "Minimum age (days)"

+  ,case

+    when o.min_age_in_days_at_ascent = o.max_age_in_days_at_ascent then

+      o.min_age_in_years_at_ascent || ' years ' ||

+      extract(days from o.ascent_dt_start - (o.date_of_birth_end + make_interval(years => o.min_age_in_years_at_ascent))) ||

+      ' days'

+    else

+      o.min_age_in_years_at_ascent || ' years ' ||

+      extract(days from o.ascent_dt_start - (o.date_of_birth_end + make_interval(years => o.min_age_in_years_at_ascent))) ||

+      ' days to ' ||

+      o.max_age_in_years_at_ascent || ' years ' ||

+      extract(days from o.ascent_dt_end - (o.date_of_birth_start + make_interval(years => o.max_age_in_years_at_ascent))) ||

+      ' days'

+  end as "Age"

+  ,case

+    when o.min_age_in_days_at_ascent = o.max_age_in_days_at_ascent then ''

+    else '✓'

+  end as "Dates Needed"

+

+from

+  oldest o

+

+where

+  case

+    when o.grade_system_id = 1 and o.order_on >= 13 then 1

+    when o.grade_system_id = 2 and o.order_on >= 60 then 1

+    when o.grade_system_id = 3 and o.order_on >= 37 then 1

+    else 0

+  end = 1

+  and o.climb_type_id in (1,2,3)

+

+order by

+  o.grade_system_id

+  ,o.order_on

Before

<p>Main list here: <a href="https://climbing-history.org/list/82/oldest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/82/oldest-ascents</a></p>
<p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact info for the ascents listed here.</p>

After

<p>Main list here: <a href="https://climbing-history.org/list/82/oldest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/82/oldest-ascents</a></p>
<p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.</p>

Before

Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents)

The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact info for the ascents listed here.

After

Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents)

The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.

Diff

--- before

+++ after

@@ -1,3 +1,3 @@

 Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents)

 

-The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact info for the ascents listed here.
+The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact dates for the ascents listed here.

Before

See also [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents)

This is a list of the oldest ascents at each grade.

After

Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents)

The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact info for the ascents listed here.

Diff

--- before

+++ after

@@ -1,3 +1,3 @@

-See also [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents)

+Main list here: [https://climbing-history.org/list/82/oldest-ascents](https://climbing-history.org/list/82/oldest-ascents)

 

-This is a list of the oldest ascents at each grade.
+The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact info for the ascents listed here.

Before

<p>See also <a href="https://climbing-history.org/list/82/oldest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/82/oldest-ascents</a></p>
<p>This is a list of the oldest ascents at each grade.</p>

After

<p>Main list here: <a href="https://climbing-history.org/list/82/oldest-ascents" rel="noopener noreferrer">https://climbing-history.org/list/82/oldest-ascents</a></p>
<p>The above list will only show an ascent where we can calculate a climbers exact age at time of ascent. This list instead calculates the range of possible ages and sorts based on the climbers minimum possible age based on the data we have. Ideally we want to source the exact info for the ascents listed here.</p>

Badges

Contributions

Posts

0

145

999

3553

3

8

Top Contributions

Recent Contributions

< Page 87 >