Published unlisted
Edited
Dec 13, 2020
1 fork
3 stars
kilterClimbs.filter(({ name }) => name === "Bad Girls Club Top")
kilterClimb = ({
...kilterClimbs.filter(({ uuid }) => uuid === sampleClimb)[0],
climb_stats: await kilter.exec(
`SELECT * FROM climb_stats WHERE climb_uuid = '${sampleClimb}'`
),
placements: await kilter.exec(
`SELECT * FROM climbs_placements
LEFT JOIN placements ON climbs_placements.placement_id = placements.id
LEFT JOIN holes ON holes.id = placements.hole_id
WHERE climb_uuid = '${sampleClimb}'`
)
})
top50Climbs = kilter.exec(`SELECT climb_uuid, SUM(ascensionist_count) as ascents FROM climb_stats GROUP BY climb_uuid
order by ascents desc limit 50`)
kilterClimbs = kilter.exec("SELECT * FROM climbs")
kilterBetaLinks = kilter.exec("select * from beta_links")
tensionBetaLinks = tension.exec("select * from beta_links")
someUsernames = Object.keys(climbsBySetter)
climbsBySetter = R.groupBy(({ setter_username }) => setter_username, climbs)
kilterPlacements = kilter.exec("select * from placements")
tensionClimbs = climbs
kilterTotalAscents = kilter.exec(
"select sum(ascensionist_count) from climb_stats"
)
tensionClimbStats = tension.exec("select * from climb_stats")
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
