NY Philharmonic Performance History

All Performances, 1842-Present

@kaggle.nyphil_perf_history

Table List

4 tables(6.55 MB)

Concerts

Ny Phil

Soloists

Works

Concerts

@kaggle.nyphil_perf_history.concerts

821.96 KB
21607 rows
9 columns

date Date	location Location	time Time	venue Venue	eventtype EventType	season Season	programid ProgramID	orchestra Orchestra	id Id
1842-12-07T05:00:00Z	Manhattan, NY	8:00PM	Apollo Rooms	Subscription Season	1842-43	3853	New York Philharmonic	38e072a7-8fc9-4f9a-8eac-3957905c0002
1843-02-18T05:00:00Z	Manhattan, NY	8:00PM	Apollo Rooms	Subscription Season	1842-43	5178	New York Philharmonic	c7b2b95c-5e0b-431c-a340-5b37fc860b34
1843-04-07T05:00:00Z	Manhattan, NY	8:00PM	Apollo Rooms	Special	1842-43	10785	Musicians from the New York Philharmonic	894e1a52-1ae5-4fa7-aec0-b99997555a37
1843-04-22T05:00:00Z	Manhattan, NY	8:00PM	Apollo Rooms	Subscription Season	1842-43	5887	New York Philharmonic	34ec2c2b-3297-4716-9831-b538310462b7
1843-11-18T05:00:00Z	Manhattan, NY	nan	Apollo Rooms	Subscription Season	1843-44	305	New York Philharmonic	610a4acc-94e4-4cd6-bdc1-8ad020edc7e9
1844-01-13T05:00:00Z	Manhattan, NY	8:00PM	Apollo Rooms	Subscription Season	1843-44	3368	New York Philharmonic	47b6e9e8-3b18-49ea-ae2a-b9b0ca18902c
1844-03-16T05:00:00Z	Manhattan, NY	nan	Apollo Rooms	Subscription Season	1843-44	4226	New York Philharmonic	5e533e4f-d4ac-4aaa-b8d2-e189f6806655
1844-05-18T05:00:00Z	Manhattan, NY	nan	Apollo Rooms	Subscription Season	1843-44	5087	New York Philharmonic	7550f75e-5c0c-4519-9196-05a6c4e2612c
1844-11-16T05:00:00Z	Manhattan, NY	8:00PM	Apollo Rooms	Subscription Season	1844-45	6310	New York Philharmonic	91f716fc-090d-4c3b-85da-41122eb3fe96
1845-01-11T05:00:00Z	Manhattan, NY	8:00PM	Apollo Rooms	Subscription Season	1844-45	1979	New York Philharmonic	253d22e1-9d44-410c-ae06-61abe434e5ec


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