home / hth

hth: gigs_per_year

Custom SQL query returning 20 rows (hide)

select strftime('%Y', date) as year, count(id) as gigs from published_gigs group by year

Edit SQL

This data as json, CSV

yeargigs
2005 2
2006 17
2007 41
2008 40
2009 50
2010 20
2011 8
2012 25
2013 15
2014 21
2015 13
2016 16
2017 8
2018 8
2019 4
2020 7
2021 3
2022 4
2023 7
2024 2
Powered by Datasette · Queries took 0.884ms