NY Philharmonic Performance History

All Performances, 1842-Present

@kaggle.nyphil_perf_history

Table List

4 tables(6.55 MB)

Concerts

Ny Phil

Soloists

Works

Works

@kaggle.nyphil_perf_history.works

2.23 MB
82793 rows
11 columns

id ID	composername ComposerName	conductorname ConductorName	interval Interval	movement Movement	soloists Soloists	worktitle WorkTitle	season Season	programid ProgramID	orchestra Orchestra	id_3a3c28 Id
52446*	Beethoven, Ludwig van	Hill, Ureli Corelli	nan	nan	[]	SYMPHONY NO. 5 IN C MINOR, OP.67	1842-43	3853	New York Philharmonic	38e072a7-8fc9-4f9a-8eac-3957905c0002
8834*4	Weber, Carl Maria Von	Timm, Henry C.	nan	"Ozean, du Ungeheuer" (Ocean, thou mighty monster), Reiza (Scene and Aria), Act II	[{u'soloistName': u'Otto, Antoinette', u'soloistRoles': u'S', u'soloistInstrument': u'Soprano'}]	OBERON	1842-43	3853	New York Philharmonic	38e072a7-8fc9-4f9a-8eac-3957905c0002
3642*	Hummel, Johann	nan	nan	nan	[{u'soloistName': u'Scharfenberg, William', u'soloistRoles': u'A', u'soloistInstrument': u'Piano'}, {u'soloistName': u'Hill, Ureli Corelli', u'soloistRoles': u'A', u'soloistInstrument': u'Violin'}, {u'soloistName': u'Derwort, G. H.', u'soloistRoles': u'A', u'soloistInstrument': u'Viola'}, {u'soloist…	QUINTET, PIANO, D MINOR, OP. 74	1842-43	3853	New York Philharmonic	38e072a7-8fc9-4f9a-8eac-3957905c0002
0*	nan	nan	Intermission	nan	[]	nan	1842-43	3853	New York Philharmonic	38e072a7-8fc9-4f9a-8eac-3957905c0002
8834*3	Weber, Carl Maria Von	Etienne, Denis G.	nan	Overture	[]	OBERON	1842-43	3853	New York Philharmonic	38e072a7-8fc9-4f9a-8eac-3957905c0002
8835*1	Rossini, Gioachino	Timm, Henry C.	nan	Duet	[{u'soloistName': u'Otto, Antoinette', u'soloistRoles': u'S', u'soloistInstrument': u'Soprano'}, {u'soloistName': u'Horn, Charles Edward', u'soloistRoles': u'S', u'soloistInstrument': u'Tenor'}]	ARMIDA	1842-43	3853	New York Philharmonic	38e072a7-8fc9-4f9a-8eac-3957905c0002
8837*6	Beethoven, Ludwig van	Timm, Henry C.	nan	"In Des Lebens Fruhlingstagen...O spur ich nicht linde," Florestan (aria)	[{u'soloistName': u'Horn, Charles Edward', u'soloistRoles': u'S', u'soloistInstrument': u'Tenor'}]	FIDELIO, OP. 72	1842-43	3853	New York Philharmonic	38e072a7-8fc9-4f9a-8eac-3957905c0002
8336*4	Mozart, Wolfgang Amadeus	Timm, Henry C.	nan	"Ach Ich liebte," Konstanze (aria)	[{u'soloistName': u'Otto, Antoinette', u'soloistRoles': u'S', u'soloistInstrument': u'Soprano'}]	ABDUCTION FROM THE SERAGLIO,THE, K.384	1842-43	3853	New York Philharmonic	38e072a7-8fc9-4f9a-8eac-3957905c0002
5543*	Kalliwoda, Johann W.	Timm, Henry C.	nan	nan	[]	OVERTURE NO. 1, D MINOR, OP. 38	1842-43	3853	New York Philharmonic	38e072a7-8fc9-4f9a-8eac-3957905c0002
52437*	Beethoven, Ludwig van	Hill, Ureli Corelli	nan	nan	[]	SYMPHONY NO. 3 IN E FLAT MAJOR, OP. 55 (EROICA)	1842-43	5178	New York Philharmonic	c7b2b95c-5e0b-431c-a340-5b37fc860b34


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