Name: LGBTQ+ Movies
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

LGBTQ+ Movies

Happy Pride Month (again)!

This data comes from the TidyRainbow, "a data project for the LGBTQ+ community who use the R language ecosystem."

The data sets in this repository focus on data pertaining to the LGBTQ+ community. We also look for data sets where LGBTQ+ folk are explicitly represented and where it is not assumed that gender is binary. Additionally, we include data sets that are relevant to LGBTQ+ folk because of the impact it has on the community.

This data comes from LGBTQ Movies database dataset curated by Cara Cuiule (She/Her).

Where do the most popular LGBTQ+ movies come from?
Are more LGBTQ+ movies being released over time?

Data Dictionary

`lgbtq_movies.csv`

variable	class	description
id	integer	unique ID
title	character	title of record in English
original_title	character	non-English characters
original_language	character	language of the record
overview	character	description of the record
release_date	Date	release date of movie
popularity	numeric	popularity rating
vote_average	numeric	average rating
vote_count	integer	the number of votes
adult	logical	Boolean to indicate an adult movie.
video	logical	Boolean to indicate video
genre_ids	character	a comma-separated array of integers

Data was collected and cleaned by Cara Cuiule (She/Her).

Tables

Lgbtq Movies

@kaggle.joebeachcapital_lgbtq_movies.lgbtq_movies

1.81 MB
7,165 rows
12 columns

CREATE TABLE lgbtq_movies (
  "id" BIGINT,
  "title" VARCHAR,
  "original_title" VARCHAR,
  "original_language" VARCHAR,
  "overview" VARCHAR,
  "release_date" TIMESTAMP,
  "popularity" DOUBLE,
  "vote_average" DOUBLE,
  "vote_count" BIGINT,
  "adult" BOOLEAN,
  "video" BOOLEAN,
  "genre_ids" VARCHAR
);