SELECT * FROM london_stages WHERE eventid IN (1213, 1283, 7646, 16327, 16791, 16814, 16868, 17100, 28972, 30043, 30094, 30551, 32282, 32283, 32287, 32294, 32299, 32304, 32309, 32785, 32789, 32794, 32799, 39585, 39599, 39650, 39665, 39677, 39692, 39706, 39720, 39815, 39839, 41395, 41400, 41405, 41409, 41418, 41426, 41431, 41443, 41448, 41456, 41463, 41472, 41540, 41550, 41574, 41578, 41627, 41628, 41629, 42438, 42443, 42446, 42453, 42459, 42468, 42487, 42497, 42511, 42523, 42537, 42547, 42572, 42595, 42604, 42617, 42626, 42710, 43462, 43465, 43473, 43490, 43502, 43557, 43645, 43660, 43675, 43690, 43733, 43740, 43748, 43806, 43864, 44219, 44228, 44231, 44240, 44245, 44254, 44375, 44491, 44511, 44536, 44539, 44541, 44544, 44545, 44546, 44550, 44552, 44553, 44571, 44581, 45056, 45283, 45285, 45287, 45289, 45291, 45293, 45295, 45297, 45300, 45305, 45310, 45314, 45316, 45319, 45324, 45328, 45335, 45352, 45378, 45384, 45397, 45954, 45958, 45965, 45971, 45984, 46044, 46049, 46054, 46067, 46089, 46099, 46180, 46185, 46190, 46191, 46199, 46201, 46204, 46207, 46210, 46211, 46216, 46219, 46225, 46227, 46228, 46230, 46236, 46237, 46240, 46241, 46245, 46246, 46247, 46248, 46249, 46251, 46254, 46255, 46256, 46257, 46258, 46259, 46360, 46362, 46364, 46368, 46372, 46376, 46378, 46380, 46384, 46388, 46390, 46392, 46396, 46398, 46400, 46404, 46408, 46416, 46420, 46424, 46428, 46432, 46437, 46442, 46447, 46451, 46456, 46461, 46465, 46470, 46475, 46477, 46480, 46482, 46487, 46491, 46496, 46501, 46505, 46510, 46518, 46528, 46542, 46556, 46563, 46570, 46584, 46599, 46608, 46613, 46621, 46628, 46638, 46643, 46658, 46672, 46827, 46842, 46845, 46850, 46859, 46862, 46872, 46878, 46882, 46890, 46894, 46899, 46901, 46902, 46903, 46907, 46911, 46914, 46915, 46926, 46938, 46950, 46956, 46962, 46968, 46972, 46986, 47095, 47103, 47138, 47166, 47182, 47213, 47230, 47254, 47269, 47296, 47443, 47445, 47460, 47471, 47481, 47483, 47492, 47494, 47567, 47571, 47594, 47622, 47646, 47677, 47682, 47692, 47703, 47718, 47743, 47763, 47778, 47817, 47859, 47995, 47996, 48009, 48014, 48056, 48242, 48424, 48634, 48640, 48642, 48645, 48654, 48656, 48664, 48669, 48727, 48738, 48750, 48755, 48768, 48772, 48780, 48788, 48792, 48797, 48804, 48818, 48819, 48820, 48831, 48836, 48843, 48847, 48850, 48852, 48855, 48857, 48859, 48866, 48869, 48873, 48875, 48880, 48883, 48888, 48891, 48893, 48900, 48903, 48910, 48917, 48919, 48924, 48928, 48931, 48934, 48946, 48957, 49066, 49080, 49089, 49091, 49094, 49096, 49099, 49101, 49102, 49103, 49105, 49107, 49109, 49110, 49111, 49112, 49114, 49117, 49119, 49163, 49170, 49173, 49174, 49179, 49181, 49187, 49198, 49200, 49202, 49205, 49210, 49213, 49218, 49221, 49225, 49227, 49230, 49249, 49255, 49261, 49273, 49279, 49285, 49297, 49304, 49311, 49320, 49325, 49344, 49347, 49349, 49363, 49367, 49370, 49377, 49381, 49389, 49395, 49407, 49412, 49415, 49771, 49773, 49774, 49778, 49782, 49790, 49795, 49802, 49812, 49824, 49830, 49838, 49846, 49850, 49858, 49862, 49866, 49870, 49874, 49876, 49887, 49901, 49911, 49914, 49937, 49997, 50012, 50034, 50047, 50093, 50098, 50101, 50103, 50105, 50107, 50115, 50117, 50120, 50122, 50130, 50133, 50152, 50190, 50229, 50231, 50250, 50262, 50275, 50279, 50280, 50290, 50300, 50301, 50308, 50592, 50596, 50601, 50610, 50615, 50619, 50627, 50631, 50634, 50637, 50639, 50643, 50646, 50649, 50651, 50655, 50658, 50661, 50687, 50689, 50692, 50706, 50713, 50727, 50730, 50735, 50743, 50746, 50748, 50751, 50761, 50773, 50781, 50783, 50785, 50789, 50794, 50796, 50799, 50829, 50851, 50853, 50867, 50883, 50884, 50897, 50906, 50943, 50970, 51026, 51230, 51233, 51236, 51240, 51243, 51248, 51251, 51253, 51257, 51260, 51262, 51267, 51270, 51276, 51284, 51289, 51294, 51299, 51301, 51303, 51308, 51318, 51323, 51328, 51337, 51344, 51382, 51386, 51441, 51467, 51480, 51505, 51506, 51511, 51513, 51514, 51517, 51519, 51521, 51522, 51524, 51525, 51527, 51528, 51529, 51531, 51532, 51533, 51535, 51537, 51540, 51541, 51543, 51545, 51552, 51557, 51561, 51562, 51565, 51566, 51569, 51573, 51574, 51577, 51581, 51587, 51591, 51600, 51613, 51639, 51647, 51650, 51657, 51672, 51675, 51677, 51680, 51682, 51683, 51685, 51687, 51690, 51693, 51694, 51696, 51698, 51700, 51703, 51709, 51710, 51712, 51715, 51721, 51722, 51724, 51727, 51728, 51729, 51733, 51736, 51739, 51742, 51746, 51750, 51762, 51788, 51789, 51793, 51802, 51840, 51842, 51846, 51884, 51916, 51926, 51943, 51953, 51961, 51986, 51991, 51992, 51994, 52000, 52004, 52013, 52021, 52035, 52045, 52046, 52081, 52102, 52155, 52169, 52193, 52194, 52204, 52211, 52213, 52215, 52220, 52224, 52226, 52230, 52233, 52238, 52240, 52244, 52249, 52254, 52261, 52266, 52270, 52273, 52276, 52279, 52281, 52295, 52297, 52299, 52302, 52304, 52307, 52309, 52311, 52313, 52316, 52318, 52322, 52325, 52328, 52330, 52337, 52361, 52366, 52373, 52378, 52388, 52390, 52393, 52395, 52397, 52399, 52400, 52407, 52428, 52431, 52436, 52441, 52448, 52455, 52462, 52467, 52470, 52475, 52480, 52494, 52497, 52498, 52515) GROUP BY eventid ORDER BY eventdate ASC OPTION

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?

Performances

Mainpiece Title: Robin Hood

Cast
Role: Baron Fitzherbert Actor: Wilson

Afterpiece Title: The Lying Valet

Dance: As17841201

Performances

Mainpiece Title: Il Pittore Parigino

Cast
Role: : D Barone Cricca Actor: Tasca

Dance: As17850122 throughout

Performances

Mainpiece Title: Il Pittore Parigino

Cast
Role: : D Barone Cricca Actor: Tasca

Dance: As17850122 throughout

Performances

Mainpiece Title: Il Pittore Parigino

Cast
Role: : D Barone Cricca Actor: Tasca

Dance: As17850205 throughout

Performances

Mainpiece Title: Il Pittore Parigino

Cast
Role: : D Barone Cricca Actor: Tasca

Dance: End of Act I Le Jugement de Paris, as17850212; End of Opera The Deserter, as17850122

Performances

Mainpiece Title: Il Pittore Parigino

Cast
Role: : D Barone Cricca Actor: Tasca

Dance: End of Act I Divertissement, as17850224; End of Opera The Deserter, as17850226

Performances

Mainpiece Title: Robin Hood

Cast
Role: Baron Fitzherbert Actor: Wilson

Afterpiece Title: Midas

Performances

Mainpiece Title: Il Pittore Parigino

Cast
Role: : D Barone Cricca Actor: Tasca

Dance: As17850312hroughout

Performances

Mainpiece Title: Robin Hood

Cast
Role: Baron Fitzherbert Actor: Wilson

Afterpiece Title: Comus

Dance: As17850409

Song: As17850405

Performances

Mainpiece Title: Ii Pittore Parigino

Cast
Role: : D Barone Cricca Actor: Tasca

Dance: End of Act I New Divertissement, as17850303but omitted: Frederic, and Dance in Wooden Shoes; End of Opera Il Convitato di Pietra, as17850312athi

Performances

Mainpiece Title: Il Marchese Tulipano

Cast
Role: Il Barone Actor: Schinotti
Role: La Baronessa Actor: Sga Sestini

Dance: End of Act I a new Divertissement Serieux (composed by Giroux) by Vestris, Sga Carolina, the two Mlles Simonet, Duquesney Jun., Mlle Mozon, &c, and to conclude with a Grand Chaconne, [the music] composed by Sacchini; End of Opera a new Divertissement Villageois (composed by D'Egville) by Vestris, Sga Carolina, Mme Crespi, the two Mlles Simonet, Duquesney Jun., Spozzi, Mlle Mozon, &c

Performances

Mainpiece Title: Il Marchese Tulipano

Cast
Role: Il Barone Actor: Schinotti
Role: La Baronessa Actor: Sga Sestini

Dance: As17860124 throughout

Performances

Mainpiece Title: Il Marchese Tulipano

Cast
Role: Il Barone Actor: Schinotti
Role: La Baronessa Actor: Sga Sestini

Dance: As17860124 throughout

Performances

Mainpiece Title: Il Marchese Tulipano

Cast
Role: Il Barone Actor: Schinotti
Role: La Baronessa Actor: Sga Sestini

Dance: As17860124 throughout

Performances

Mainpiece Title: Il Marchese Tulipano

Cast
Role: Il Barone Actor: Schinotti
Role: La Baronessa Actor: Sga Sestini

Dance: As17860124 throughout

Performances

Mainpiece Title: Il Marchese Tulipano

Cast
Role: Il Barone Actor: Schinotti
Role: La Baronessa Actor: Sga Sestini

Dance: As17860124 throughout

Performances

Mainpiece Title: Il Marchese Tulipano

Cast
Role: Il Barone Actor: Schinotti
Role: La Baronessa Actor: Sga Sestini

Dance: End of Act I L'Amour Jardinier, as17860406; End of Opera Le Premier Navigateur, as17860404

Performances

Mainpiece Title: Il Marchese Tulipano

Cast
Role: Il Barone Actor: Schinotti
Role: La Baronessa Actor: Sga Sestini

Dance: End of Act I Les Amans Surpris, as17860606 but omitted: Rochfort; End of Opera Ninette & la Cour, as17860601 but omitted: Rochfort

Performances

Mainpiece Title: Il Marchese Tulipano

Cast
Role: Il Barone Actor: Schinotti
Role: La Baronessa Actor: Sga Sestini

Dance: End of Act I La Fete Marine, as17860427; End of Opera Ninette } la Cour, as17860701

Performances

Mainpiece Title: The Disbanded Officer; Or, The Baroness Of Bruchsal

Afterpiece Title: The Quaker

Performances

Mainpiece Title: The Disbanded Officer

Afterpiece Title: Gretna Green

Performances

Mainpiece Title: The Disbanded Officer

Afterpiece Title: The Guardian

Performances

Mainpiece Title: The Disbanded Officer

Afterpiece Title: Comus

Dance: As17860706

Performances

Mainpiece Title: The Disbanded Officer

Afterpiece Title: Here, and There, and Every Where

Dance: End of mainpiece, as17860609 In afterpiece, as17860703

Performances

Mainpiece Title: The Disbanded Officer

Afterpiece Title: Comus

Dance: As17860706