Name: Opera Performances
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Opera Performances

Opera performances and associated data (Composers, Year written, etc)

About this dataset

This dataset contains information on opera performances around the world. It includes data on the season, city, composer, work, and start date of each performance, as well as the number of performances and production type

How to use the dataset

This dataset contains information on opera performances around the world. The data includes the location, composer, work, start date, and type of performance

Research Ideas

Study Opera performances by season

Analyse the cities of the opera performances

Study the composers of the operas

Acknowledgements

License

> License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
> No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: city-level-runs.csv

Column name	Description
season	The season of the performance. (String)
iso	The country code of the performance. (String)
city	The city of the performance. (String)
composer	The composer of the opera. (String)
db	The date of birth of the composer. (String)
dd	The date of death of the composer. (String)
nat	The nationality of the composer. (String)
mf	The gender of the composer. (String)
work	The title of the opera. (String)
worknat	The nationality of the opera. (String)
type	The type of performance. (String)
start date	The start date of the performance. (String)
performances	The number of performances. (String)
production	The type of production. (String)

Tables

City Level Runs

@kaggle.thedevastator_world_s_largest_database_of_opera_performances.city_level_runs

618.08 kB
33,127 rows
15 columns

CREATE TABLE city_level_runs (
  "index" BIGINT,
  "season" BIGINT,
  "iso" VARCHAR,
  "city" VARCHAR,
  "composer" VARCHAR,
  "db" VARCHAR,
  "dd" VARCHAR,
  "nat" VARCHAR,
  "mf" VARCHAR,
  "work" VARCHAR,
  "worknat" VARCHAR,
  "type" VARCHAR,
  "start_date" BIGINT,
  "performances" BIGINT,
  "production" VARCHAR
);