home / imdb

Popular Genres

Custom SQL query returning 25 rows (hide)

                        SELECT
                            genres,
                            COUNT(*) as count
                        FROM titles
                        WHERE titleType = 'movie'
                        AND genres IS NOT NULL
                        GROUP BY genres
                        ORDER BY count DESC
                        LIMIT 25
                    

Edit SQL

This data as json, CSV

genrescount
Drama 136652
Documentary 114295
Comedy 50764
Horror 20978
Thriller 17906
Action 17056
Comedy,Drama 14922
Drama,Romance 14288
Romance 8634
Comedy,Romance 8096
Crime,Drama 6363
Comedy,Drama,Romance 6097
Crime 5751
Drama,Thriller 5302
Drama,Western 5088
Sci-Fi 5055
Adventure 4998
Action,Drama 4613
Action,Crime,Drama 4559
Horror,Thriller 4424
Family 4409
Documentary,Music 4325
Animation 3822
Biography,Documentary 3743
Fantasy 3364
Powered by Datasette · Queries took 4987.798ms