Name: The Oscar Award, 1927 - 2024
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

The Oscar Award, 1927 - 2024

Please, If you enjoyed this dataset, don't forget to upvote it.

Context

The Academy Awards, also officially and popularly known as the Oscars, are awards for artistic and technical merit in the film industry. Given annually by the Academy of Motion Picture Arts and Sciences (AMPAS), the awards are an international recognition of excellence in cinematic achievements as assessed by the Academy's voting membership. The various category winners are awarded a copy of a golden statuette, officially called the "Academy Award of Merit", although more commonly referred to by its nickname "Oscar". The statuette depicts a knight rendered in Art Deco style.

Content

This file contains a scrape of The Academy Awards Database, recorded of past Academy Award winners and nominees between 1927 and 2024.

Acknowledgements

The awards data was scraped from the Official Academy Awards search site; nominees were listed with their name first and film following in some categories, such as Best Actor/Actress, and in the reverse for others.

Inspiration

Do the Academy Awards reflect the diversity of American films or are the #OscarsSoWhite?
Which actor/actress has received the most awards overall or in a single year?
Which film has received the most awards in a ceremony?
Which country received the most awards at a ceremony and overall?
Can you predict who will receive the awards next year?

Thank you @lopcio for the amazing helpful on fix this dataset missing values through the updates.

Tables

The Oscar Award

@kaggle.unanimad_the_oscar_award.the_oscar_award

273.69 kB
10,889 rows
7 columns

CREATE TABLE the_oscar_award (
  "year_film" BIGINT,
  "year_ceremony" BIGINT,
  "ceremony" BIGINT,
  "category" VARCHAR,
  "name" VARCHAR,
  "film" VARCHAR,
  "winner" BOOLEAN
);