The London Stage Database team will be retiring the Legacy Search on May 1, 2025. Please take a moment before that date to reproduce any pre-2021 searches and export any resulting datasets you may wish to preserve for future use. We are making this change in order to free up computational resources for new features and data, currently in development with support from the National Endowment for the Humanities. Watch this space for more updates and, coming soon, new ways to keep up with the latest project developments!
SELECT * FROM london_stages WHERE eventid IN (39174, 39192, 39382, 39733, 39747, 39761, 39783, 39794, 39809, 39825, 40110, 40119, 40124, 40133, 40138, 40147, 40152, 40161, 40171, 40186, 40200, 40215, 40229, 40241, 40255, 40260, 40268, 40273, 40280, 40286, 40293, 40298, 40306, 40312, 40317, 40321, 40327, 40336, 40346, 40351, 40356, 40365, 40370, 40375, 40380, 40385, 40394, 40399, 40409, 40423, 40434, 40439, 40442, 40451, 40456, 40464, 40470, 40477, 40485, 40490, 40689, 40704, 40709, 40715, 40724, 40744, 40768, 40773, 40782, 40785, 40793, 40798, 40805, 40810, 40817, 40822, 40829, 40835, 40843, 40849, 40857, 40863, 40871, 40903, 40918, 41046, 48195, 48212, 48221, 48226, 48234, 48239, 48253, 48262, 48267, 48276, 48281, 48290, 48295, 48304, 48318, 48323, 48332, 48337, 48345, 48350, 48359, 48364, 48373, 48378, 48387, 48392, 48399, 48405, 48414, 48419, 48428, 48433, 48441, 48446, 48452, 48455, 48460, 48463, 48468, 48795, 48800, 48809, 48814, 48823, 48834, 48839, 48848, 48853, 48862, 48867, 48876, 48881, 48889, 48894, 48901, 48906, 48915, 48920, 48929, 48935, 48944, 48949, 48958, 48963, 48972, 48991, 49005, 49010, 49019, 49024, 49029, 49034, 49039, 49049, 49054, 49059, 49064, 49070, 49075, 49078, 49084, 49093, 49098, 49104, 49106, 49108, 49113, 49115, 49118, 49121, 49124, 49303, 49308, 49317, 49322, 49331, 49336, 49341, 49346, 49355, 49360, 49402, 49409, 49423, 49437, 49447, 49450, 49455, 49460, 49463, 49468, 49476, 49481, 49488, 49491, 49496, 49505, 49510, 49514, 49518, 49523, 49532, 49537, 49546, 49551, 49561, 49566, 49571, 49576, 49581, 49590, 49595, 49600, 49605, 49610, 49617, 49623, 49628, 49633, 49638, 49647, 49652, 49661, 49673, 49676, 49681, 49684, 49689, 49692, 49697, 49884, 49889, 49898, 49903, 49908, 49913, 49927, 49936, 49941, 49950, 49955, 49964, 49969, 49976, 49981, 49990, 49995, 50007, 50014, 50020, 50027, 50039, 50049, 50071, 50090, 50109, 50114, 50119, 50149, 50154, 50227, 50233, 50244, 50249, 50258, 50274, 50281, 50431, 50436, 50445, 50450, 50459, 50464, 50473, 50478, 50485, 50490, 50499, 50504, 50513, 50518, 50527, 50532, 50541, 50547, 50557, 50560, 50569, 50589, 50598, 50612, 50617, 50624, 50629, 50636, 50672, 50677, 50710, 50720, 50729, 50798, 50803, 50810, 50822, 50852, 50855, 50860, 50863, 50868, 51010, 51019, 51025, 51034, 51039, 51055, 51062, 51079, 51122, 51131, 51157, 51176, 51183, 51188, 51195, 51200, 51219, 51228, 51232, 51238, 51245, 51250, 51259, 51264, 51269, 51275, 51281, 51286, 51296, 51305, 51315, 51320, 51325, 51334, 51339, 51346, 51352, 51361, 51389, 51409, 51414, 51417, 51422, 51429, 51594, 51599, 51622, 51625, 51632, 51637, 51646, 51651, 51660, 51665, 51674, 51679, 51689, 51695, 51719, 51726, 51731, 51738, 51744, 51751, 51756, 51763, 51768, 51775, 51795, 51809, 51818, 51829, 51834, 51839, 51852, 51857, 51862, 51880, 51891, 51896, 51905, 51910, 51915, 51945, 51979, 51995, 52006, 52014, 52232, 52237, 52246, 52251, 52260, 52265, 52272, 52278, 52287, 52292, 52301, 52306, 52315, 52320, 52327, 52332, 52339, 52344, 52351, 52356, 52363, 52368, 52375, 52380, 52387, 52392, 52406, 52411, 52416, 52421, 52430, 52435, 52440, 52445, 52450, 52459, 52464, 52469, 52474, 52487, 52493, 52502, 52507, 52517, 52523, 52530, 52533, 52538, 52541, 52546, 52549, 52554, 52557, 52562, 52565, 52570, 52573, 52578) 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: L'isola Del Piacere

Cast
Role: Abadir Actor: Rovedino

Dance: As17950512

Performances

Mainpiece Title: Alceste

Cast
Role: Nume Infernale Actor: Rovedino

Dance: As17950430

Performances

Mainpiece Title: L'isola Del Piacere

Cast
Role: Abadir Actor: Rovedino

Dance: As17950512

Performances

Mainpiece Title: Alceste

Cast
Role: Nume Infernale Actor: Rovedino

Dance: End Opera: a new Heroic Pantomime Ballet, composed by Onorati, L'Odio vinto dall' Eroismo- see17950620

Performances

Mainpiece Title: Alceste

Cast
Role: Nume Infernale Actor: Rovedino

Dance: End Opera: L'Odio vinto dall' Eroismo-Gentili, Aumer, Lahante, Mme Bossi [DelCaro], Mme Hilligsberg [no other ballet listed]

Performances

Afterpiece Title: Semiramide (Act II only)

Dance: As17950522

Music: As17950616

Performances

Mainpiece Title: Alceste

Cast
Role: Nume Infernale Actor: Rovedino

Dance: As17950430

Performances

Mainpiece Title: La Scola Dei Maritati (act I Only)

Afterpiece Title: Semiramide (Act II only)

Dance: As17950526

Music: As17950616

Performances

Mainpiece Title: Alceste

Cast
Role: Nume Infernale Actor: Rovedino

Dance: As17950430

Performances

Mainpiece Title: La Scola Dei Maritati (act I Only)

Afterpiece Title: Semiramide (Act II only)

Dance: As17950526

Music: As17950616

Performances

Mainpiece Title: Alceste

Cast
Role: Nume Infernale Actor: Rovedino

Dance: As17950430

Performances

Mainpiece Title: La Bella Arsene

Cast
Role: Arturo Actor: Rovedino

Dance: WithDances by Onorati-

Performances

Mainpiece Title: La Bella Arsene

Cast
Role: Arturo Actor: Rovedino

Dance: As17951212

Performances

Mainpiece Title: La Bella Arsene

Cast
Role: Arturo Actor: Rovedino

Dance: As17951212

Performances

Mainpiece Title: La Bella Arsene

Cast
Role: Arturo Actor: Rovedino

Dance: As17951212

Performances

Mainpiece Title: La Bella Arsene

Cast
Role: Arturo Actor: Rovedino

Dance: As17951212

Performances

Mainpiece Title: La Bella Arsene

Cast
Role: Arturo Actor: Rovedino

Dance: As17951212

Performances

Mainpiece Title: Semiramide

Dance: As17960102

Performances

Mainpiece Title: Semiramide

Dance: End Opera: Paul et Virginie-Mme Hilligsberg (will as usual performed in men's clothes [i.e. as Paul])

Performances

Mainpiece Title: Semiramide

Dance: As17960109

Performances

Mainpiece Title: Semiramide

Dance: End Opera: Paul et Virginie- [see17960109]

Performances

Mainpiece Title: Alceste

Cast
Role: Nume Actor: Rovedino

Dance: End Opera: Paul et Virginie, as17960116

Performances

Mainpiece Title: Alceste

Cast
Role: Nume Actor: Rovedino

Dance: As17960116

Performances

Mainpiece Title: Alceste

Cast
Role: Nume Actor: Rovedino

Dance: As17960116

Performances

Mainpiece Title: Alceste

Cast
Role: Nume Actor: Rovedino

Dance: As17960116