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 136626
Documentary 114284
Comedy 50762
Horror 20973
Thriller 17904
Action 17050
Comedy,Drama 14920
Drama,Romance 14288
Romance 8634
Comedy,Romance 8094
Crime,Drama 6362
Comedy,Drama,Romance 6098
Crime 5751
Drama,Thriller 5300
Drama,Western 5088
Sci-Fi 5055
Adventure 4997
Action,Drama 4613
Action,Crime,Drama 4560
Horror,Thriller 4425
Family 4409
Documentary,Music 4318
Animation 3822
Biography,Documentary 3742
Fantasy 3363
Powered by Datasette · Queries took 1755.79ms