Books per year

How many books did I read in which year?

Custom SQL query returning 23 rows (hide)

select substr(reviews.read_at, 0, 5) as year, count(1) as n from reviews join reviews_shelves on reviews.id = reviews_shelves.reviews_id join shelves on reviews_shelves.shelves_id = shelves.id join books on reviews.book_id = books.id where shelves.name="read" and reviews.read_at group by year;

yearn
1998 2
1999 6
2000 7
2001 26
2002 16
2003 27
2004 24
2005 26
2006 31
2007 31
2008 35
2009 28
2010 21
2011 14
2012 11
2013 10
2014 33
2015 21
2016 52
2017 87
2018 183
2019 119
2020 71
Powered by Datasette · Query took 14.305ms