Books per year

How many books did I read in which year?

Custom SQL query returning 22 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 25
2005 26
2006 30
2007 31
2008 35
2009 28
2010 21
2011 14
2012 11
2013 10
2014 32
2015 21
2016 52
2017 86
2018 183
2019 98
Powered by Datasette · Query took 9.228ms