NY Philharmonic Performance History

All Performances, 1842-Present

@kaggle.nyphil_perf_history

Table List

4 tables(6.55 MB)

Concerts

Ny Phil

Soloists

Works

Soloists

@kaggle.nyphil_perf_history.soloists

741.89 KB
56194 rows
7 columns

soloistinstrument SoloistInstrument	soloistname SoloistName	soloistroles SoloistRoles	season Season	programid ProgramID	orchestra Orchestra	id Id
Soprano	Otto, Antoinette	S	1842-43	3853	New York Philharmonic	38e072a7-8fc9-4f9a-8eac-3957905c0002
Piano	Scharfenberg, William	A	1842-43	3853	New York Philharmonic	38e072a7-8fc9-4f9a-8eac-3957905c0002
Violin	Hill, Ureli Corelli	A	1842-43	3853	New York Philharmonic	38e072a7-8fc9-4f9a-8eac-3957905c0002
Viola	Derwort, G. H.	A	1842-43	3853	New York Philharmonic	38e072a7-8fc9-4f9a-8eac-3957905c0002
Cello	Boucher, Alfred	A	1842-43	3853	New York Philharmonic	38e072a7-8fc9-4f9a-8eac-3957905c0002
Contrabass	Rosier, F. W.	A	1842-43	3853	New York Philharmonic	38e072a7-8fc9-4f9a-8eac-3957905c0002
Soprano	Otto, Antoinette	S	1842-43	3853	New York Philharmonic	38e072a7-8fc9-4f9a-8eac-3957905c0002
Tenor	Horn, Charles Edward	S	1842-43	3853	New York Philharmonic	38e072a7-8fc9-4f9a-8eac-3957905c0002
Tenor	Horn, Charles Edward	S	1842-43	3853	New York Philharmonic	38e072a7-8fc9-4f9a-8eac-3957905c0002
Soprano	Otto, Antoinette	S	1842-43	3853	New York Philharmonic	38e072a7-8fc9-4f9a-8eac-3957905c0002


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