Dataset: NY Philharmonic Performance History

About this Dataset

NY Philharmonic Performance History

Context:

The New York Philharmonic played its first concert on December 7, 1842. Since then, it has merged with the New York Symphony, the New/National Symphony, and had a long-running summer season at New York's Lewisohn Stadium. The Performance History database documents all known concerts of all of these organizations, amounting to more than 20,000 performances.

Content:

Dataset is a single csv with over 800k rows. Data contains information on season, orchestra, venue, date, time, conductor, work title, composer, movement, and soloists.

Acknowledgements:

This dataset was compiled by the New York Philharmonic. Original json files hosted here. Original json files were flattened and joined on guid to form a single csv file. Image courtesy of Larisa Birta.

Inspiration:

Nearly 175 years of performance history, covering over 11k unique works--which composers are most popular? Have there been any trends in popularity by conductor or by season?

Tables

Concerts

@kaggle.nyphil_perf_history.concerts

821.96 KB
21607 rows
9 columns


CREATE TABLE concerts (
  "date" VARCHAR,
  "location" VARCHAR,
  "time" VARCHAR,
  "venue" VARCHAR,
  "eventtype" VARCHAR,
  "season" VARCHAR,
  "programid" BIGINT,
  "orchestra" VARCHAR,
  "id" VARCHAR
);

Ny Phil

@kaggle.nyphil_perf_history.ny_phil

2.79 MB
806179 rows
17 columns


CREATE TABLE ny_phil (
  "date" VARCHAR,
  "location" VARCHAR,
  "time" VARCHAR,
  "venue" VARCHAR,
  "eventtype" VARCHAR,
  "id" VARCHAR,
  "composername" VARCHAR,
  "conductorname" VARCHAR,
  "interval" VARCHAR,
  "movement" VARCHAR,
  "worktitle" VARCHAR,
  "soloistinstrument" VARCHAR,
  "soloistname" VARCHAR,
  "soloistroles" VARCHAR,
  "season" VARCHAR,
  "programid" DOUBLE,
  "orchestra" VARCHAR
);

Soloists

@kaggle.nyphil_perf_history.soloists

741.89 KB
56194 rows
7 columns


CREATE TABLE soloists (
  "soloistinstrument" VARCHAR,
  "soloistname" VARCHAR,
  "soloistroles" VARCHAR,
  "season" VARCHAR,
  "programid" BIGINT,
  "orchestra" VARCHAR,
  "id" VARCHAR
);

Works

@kaggle.nyphil_perf_history.works

2.23 MB
82793 rows
11 columns


CREATE TABLE works (
  "id" VARCHAR,
  "composername" VARCHAR,
  "conductorname" VARCHAR,
  "interval" VARCHAR,
  "movement" VARCHAR,
  "soloists" VARCHAR,
  "worktitle" VARCHAR,
  "season" VARCHAR,
  "programid" BIGINT,
  "orchestra" VARCHAR,
  "id_3a3c28" VARCHAR
);