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 139340
Documentary 117696
Comedy 51634
Horror 21709
Thriller 18389
Action 17399
Comedy,Drama 15287
Drama,Romance 14624
Romance 8873
Comedy,Romance 8228
Crime,Drama 6480
Comedy,Drama,Romance 6248
Crime 5935
Drama,Thriller 5500
Sci-Fi 5221
Drama,Western 5100
Adventure 5098
Documentary,Music 5089
Action,Crime,Drama 4671
Action,Drama 4650
Horror,Thriller 4593
Family 4514
Animation 3942
Biography,Documentary 3867
Fantasy 3464
Powered by Datasette · Queries took 2700.634ms