Baselight

LGBTQ+ Movies

Where do the most popular LGBTQ+ movies come from?

@kaggle.joebeachcapital_lgbtq_movies

Loading...
Loading...

About this Dataset

LGBTQ+ Movies

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.72 MB
  • 7165 rows
  • 12 columns
Loading...

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
);

Share link

Anyone who has the link will be able to view this.