NY Philharmonic Performance History

All Performances, 1842-Present

@kaggle.nyphil_perf_history

Table List

4 tables(6.55 MB)

Concerts

Ny Phil

Soloists

Works

Ny Phil

@kaggle.nyphil_perf_history.ny_phil

2.79 MB
806179 rows
17 columns

date Date	location Location	time Time	venue Venue	eventtype EventType	id Id	composername ComposerName	conductorname ConductorName	interval Interval	movement Movement	worktitle WorkTitle	soloistinstrument SoloistInstrument	soloistname SoloistName	soloistroles SoloistRoles	season Season	programid ProgramID	orchestra Orchestra
1842-12-07T05:00:00Z	Manhattan, NY	8:00PM	Apollo Rooms	Subscription Season	38e072a7-8fc9-4f9a-8eac-3957905c0002	Beethoven, Ludwig van	Hill, Ureli Corelli	nan	nan	SYMPHONY NO. 5 IN C MINOR, OP.67	Soprano	Otto, Antoinette	S	1842-43	3853	New York Philharmonic
1842-12-07T05:00:00Z	Manhattan, NY	8:00PM	Apollo Rooms	Subscription Season	38e072a7-8fc9-4f9a-8eac-3957905c0002	Beethoven, Ludwig van	Hill, Ureli Corelli	nan	nan	SYMPHONY NO. 5 IN C MINOR, OP.67	Piano	Scharfenberg, William	A	1842-43	3853	New York Philharmonic
1842-12-07T05:00:00Z	Manhattan, NY	8:00PM	Apollo Rooms	Subscription Season	38e072a7-8fc9-4f9a-8eac-3957905c0002	Beethoven, Ludwig van	Hill, Ureli Corelli	nan	nan	SYMPHONY NO. 5 IN C MINOR, OP.67	Violin	Hill, Ureli Corelli	A	1842-43	3853	New York Philharmonic
1842-12-07T05:00:00Z	Manhattan, NY	8:00PM	Apollo Rooms	Subscription Season	38e072a7-8fc9-4f9a-8eac-3957905c0002	Beethoven, Ludwig van	Hill, Ureli Corelli	nan	nan	SYMPHONY NO. 5 IN C MINOR, OP.67	Viola	Derwort, G. H.	A	1842-43	3853	New York Philharmonic
1842-12-07T05:00:00Z	Manhattan, NY	8:00PM	Apollo Rooms	Subscription Season	38e072a7-8fc9-4f9a-8eac-3957905c0002	Beethoven, Ludwig van	Hill, Ureli Corelli	nan	nan	SYMPHONY NO. 5 IN C MINOR, OP.67	Cello	Boucher, Alfred	A	1842-43	3853	New York Philharmonic
1842-12-07T05:00:00Z	Manhattan, NY	8:00PM	Apollo Rooms	Subscription Season	38e072a7-8fc9-4f9a-8eac-3957905c0002	Beethoven, Ludwig van	Hill, Ureli Corelli	nan	nan	SYMPHONY NO. 5 IN C MINOR, OP.67	Contrabass	Rosier, F. W.	A	1842-43	3853	New York Philharmonic
1842-12-07T05:00:00Z	Manhattan, NY	8:00PM	Apollo Rooms	Subscription Season	38e072a7-8fc9-4f9a-8eac-3957905c0002	Beethoven, Ludwig van	Hill, Ureli Corelli	nan	nan	SYMPHONY NO. 5 IN C MINOR, OP.67	Soprano	Otto, Antoinette	S	1842-43	3853	New York Philharmonic
1842-12-07T05:00:00Z	Manhattan, NY	8:00PM	Apollo Rooms	Subscription Season	38e072a7-8fc9-4f9a-8eac-3957905c0002	Beethoven, Ludwig van	Hill, Ureli Corelli	nan	nan	SYMPHONY NO. 5 IN C MINOR, OP.67	Tenor	Horn, Charles Edward	S	1842-43	3853	New York Philharmonic
1842-12-07T05:00:00Z	Manhattan, NY	8:00PM	Apollo Rooms	Subscription Season	38e072a7-8fc9-4f9a-8eac-3957905c0002	Beethoven, Ludwig van	Hill, Ureli Corelli	nan	nan	SYMPHONY NO. 5 IN C MINOR, OP.67	Tenor	Horn, Charles Edward	S	1842-43	3853	New York Philharmonic
1842-12-07T05:00:00Z	Manhattan, NY	8:00PM	Apollo Rooms	Subscription Season	38e072a7-8fc9-4f9a-8eac-3957905c0002	Beethoven, Ludwig van	Hill, Ureli Corelli	nan	nan	SYMPHONY NO. 5 IN C MINOR, OP.67	Soprano	Otto, Antoinette	S	1842-43	3853	New York Philharmonic


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