Name: Emmy Awards
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Emmy Awards

About

An Emmy Award, or simply Emmy, is an American award that recognizes excellence in the television industry. It is presented at numerous annual events held throughout the calendar year, each honoring one of the various sectors of the television industry. The two ceremonies that receive the most media coverage are the Primetime Emmy Awards and the Daytime Emmy Awards, which recognize outstanding work in American primetime and daytime entertainment programming, respectively. Other notable Emmy events include those honoring national sports programming, national news and documentary shows, and technological and engineering achievements in television, including the Primetime Engineering Emmy Awards. Regional Emmy Awards are also presented throughout the country at various times through the year, recognizing excellence in local and statewide television. In addition, the International Emmy Awards honor excellence in TV programming produced and initially aired outside the United States.

Method

The data were extracted from Awards' list page.

Inspiration

Which nominee has received the most awards overall or in a single year?
Which work has received the most awards in a event?
Which country received the most awards at a ceremony and overall?

Tables

Emmy Awards Categories

@kaggle.unanimad_emmy_awards.emmy_awards_categories

5.11 kB
124 rows
3 columns

CREATE TABLE emmy_awards_categories (
  "name" VARCHAR,
  "category" VARCHAR,
  "role" VARCHAR
);

The Emmy Awards

@kaggle.unanimad_emmy_awards.the_emmy_awards

1.16 MB
21,503 rows
8 columns

CREATE TABLE the_emmy_awards (
  "id" BIGINT,
  "year" BIGINT,
  "category" VARCHAR,
  "nominee" VARCHAR,
  "staff" VARCHAR,
  "company" VARCHAR,
  "producer" VARCHAR,
  "win" BOOLEAN
);