SELECT * FROM london_stages WHERE eventid IN (38080, 38095, 38104, 38125, 38130, 38140, 38155, 38169, 38185, 38199, 38238, 38252, 38264, 38504, 38518, 38532, 38631, 38641, 38646, 38660, 38665, 38708, 38797, 38927, 38941, 38955, 38969, 38978, 38992, 38997, 39040, 39053, 39064, 39085, 39097, 39112, 39125, 39134, 39139, 39153, 39168, 39186, 39204, 39221, 39227, 39238, 39256, 39272, 39279, 39290, 39295, 39311, 39319, 39332, 39344, 39352, 39356, 39358, 39367, 39373, 40110, 40124, 40138, 40152, 40166, 40177, 40191, 40206, 40220, 40246, 40404, 40414, 40429, 40434, 40439, 40442, 40456, 40464, 40470, 40477, 40485, 41220, 41225, 41267, 41307, 41362, 41377, 41391, 41395, 41400, 41405, 41409, 41418, 41426, 41431, 41443, 41448, 41456, 41463, 41472, 41482, 41521, 41530, 41540, 41545, 41550, 41560, 41565, 41574, 41578, 41581, 41587, 41591, 41593, 41596, 41599, 41602, 41605, 42054, 42180, 42188, 42340, 42343, 42345, 42348, 42350, 42352, 42354, 42357, 42359, 42362, 42364, 42367, 42369, 42374, 42379, 42381, 42383, 42412, 42420, 42425, 42435, 42442, 42452, 42463, 42472, 42481, 42486, 42501, 42506, 42510, 42530, 42541, 42549, 42551, 42554, 42561, 42607, 42620, 42668, 42689, 42712, 42801, 42804, 42807, 42813, 42838, 42840, 42842, 42844, 42846, 42847, 42848, 42850, 42852, 42853, 42870, 42880, 42889, 42898, 42906, 42920, 42928, 42942, 42952, 42968, 43003, 43069, 43095, 43124, 43167, 43277, 43322, 43330, 43333, 43337, 43347, 43350, 43352, 43355, 43395, 43399, 43400, 43405, 43929, 43938, 43942, 43944, 43948, 43951, 43967, 43970, 43975, 43977, 43979, 43981, 43985, 43986, 43988, 43991, 43992, 44007, 44009, 44013, 44015, 44021, 44219, 44228, 44231, 44240, 44245, 44254, 44307, 44312, 44316, 44320, 44329, 44333, 44338, 44351, 44375, 44385, 44390, 44400, 44415, 44430, 44440, 44455, 44460, 44472, 44476, 44478, 44480, 44481, 44482, 44483, 44491, 44500, 44503, 44504, 44508, 44511, 44517, 44521, 44526, 44527, 44532, 44533, 44535, 44539, 44547, 44556, 44557, 44558, 44559, 44560, 44561, 44563, 44564, 44565, 44567, 44573, 44576, 44579, 44580, 44581, 44582, 44585, 44586, 44744, 44753, 44758, 44767, 44772, 44781, 44792, 44820, 44825, 44837, 44858, 44864, 44937, 44942, 44947, 44953, 44962, 44967, 44976, 44981, 44987, 44993, 44999, 45005, 45014, 45033, 45042, 45046, 45052, 45058, 45059, 45061, 45066, 45067, 45070, 45072, 45075, 45079, 45080, 45081, 45082, 45092, 45094, 45095, 45097, 45099, 45102, 45116, 45125, 45126, 45132, 45253, 45258, 45267, 45272, 45281, 45298, 45303, 45308, 45317, 45357, 45362, 45366, 45370, 45382, 45391, 45395, 45400, 45404, 45408, 45413, 45417, 45421, 45426, 45430, 45434, 45447, 45452, 45467, 45507, 45527, 46008, 46021, 46071, 46076, 46086, 46091, 46096, 46101, 46119, 46131, 46434, 46439, 46444, 46453, 46458, 46467, 46472, 46479, 46484, 46493, 46498, 46507, 46512, 46520, 46525, 46567, 46689, 46703, 47205, 47215, 47221, 47245, 47262, 47271, 47274, 47280, 47286, 47292, 47298, 47305, 47308, 47310, 47317, 47324, 47332, 47336, 47343, 47347, 47354, 47358, 47364) 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: Turk, And No Turk

Afterpiece Title: A Mogul Tale

Cast
Role: Arionelli Actor: Sga Sestini

Dance: As17860802

Performances

Mainpiece Title: The Siege Of Curzola

Cast
Role: Baba Actor: Sga Sestini

Afterpiece Title: The Romp

Performances

Mainpiece Title: The Spanish Barber

Afterpiece Title: The Son-in-Law

Cast
Role: Arionelli Actor: Sga Sestini

Dance: As17860706

Performances

Mainpiece Title: The Siege Of Curzola

Cast
Role: Baba Actor: Sga Sestini

Afterpiece Title: The Widow's Vow

Performances

Mainpiece Title: The Siege Of Curzola

Cast
Role: Baba Actor: Sga Sestini

Afterpiece Title: Peeping Tom

Performances

Mainpiece Title: The Siege Of Curzola

Cast
Role: Baba Actor: Sga Sestini

Afterpiece Title: A Beggar on Horseback

Performances

Mainpiece Title: The Siege Of Curzola

Cast
Role: Baba Actor: Sga Sestini

Afterpiece Title: Peeping Tom

Performances

Mainpiece Title: Tit For Tat

Afterpiece Title: The Son-in-Law

Cast
Role: Arionelli Actor: Sga Sestini

Dance: End of mainpiece, as17860802; End of Act I of afterpiece, as17860706

Performances

Mainpiece Title: Nature Will Prevail

Cast
Role: Baba Actor: Sga Sestini

Afterpiece Title: Tit for Tat

Afterpiece Title: Harlequin Teague

Dance: As17860904

Performances

Mainpiece Title: Seeing Is Believing

Afterpiece Title: The Spanish Barber

Cast
Role: Phoebe Actor: Sga Sestini

Afterpiece Title: The Minor

Performances

Mainpiece Title: The Disbanded Officer

Afterpiece Title: The Son-in-Law

Cast
Role: Arionelli Actor: Sga Sestini

Dance: As17860622

Performances

Mainpiece Title: Tit For Tat

Cast
Role: Baba Actor: Sga Sestini

Afterpiece Title: The Dead Alive

Performances

Mainpiece Title: The Jealous Wife

Cast
Role: Lord Trinket Actor: Sga Sestini

Afterpiece Title: Harlequin Teague

Dance: As17860904

Performances

Mainpiece Title: Manager In Distress

Afterpiece Title: The Spanish Barber

Cast
Role: Phoebe Actor: Sga Sestini

Afterpiece Title: The Son-in-Law

Cast
Role: Arionelli Actor: Sga Sestini

Dance: As17860708

Performances

Mainpiece Title: Giannina E Bernardone

Cast
Role: Donna Aurora Actor: Sga Sestini
Role: Lauretta Actor: Sga Schinotti
Role: Giannina Actor: Sga Benini.

Dance: As17870106

Performances

Mainpiece Title: Giannina E Bernardone

Cast
Role: Donna Aurora Actor: Sga Sestini
Role: Lauretta Actor: Sga Schinotti
Role: Giannina Actor: Sga Benini.

Dance: As17870106

Performances

Mainpiece Title: Giannina E Bernardone

Cast
Role: Donna Aurora Actor: Sga Sestini
Role: Lauretta Actor: Sga Schinotti
Role: Giannina Actor: Sga Benini.

Dance: End I: Divertissement, as17861223, but _Gricourt, Goyon, Mme _Bithmer; End Opera: +Le Berger Inconstant, as17870106

Performances

Mainpiece Title: Giannina E Bernardone

Cast
Role: Donna Aurora Actor: Sga Sestini
Role: Lauretta Actor: Sga Schinotti
Role: Giannina Actor: Sga Benini.

Dance: End I: Divertissement, as17870116; End Opera: an allegorical Ballet, composed by Hus, divided into 3 Quadrilles, L'Heureux Evenement-Goyon, Laborie, Mlle Mozon, Henry, Gricourt, Sala, Mme Delfevre, Mme Bithmer, Giorgi, Mme Gervais Perignon

Performances

Mainpiece Title: Giannina E Bernardone

Cast
Role: Donna Aurora Actor: Sga Sestini
Role: Lauretta Actor: Sga Schinotti
Role: Giannina Actor: Sga Benini.

Dance: As17870120

Performances

Mainpiece Title: Iannina E Bernardone

Cast
Role: Donna Aurora Actor: Sga Sestini
Role: Lauretta Actor: Sga Schinotti
Role: Giannina Actor: Sga Benini.

Dance: As17870120

Performances

Mainpiece Title: Giannina E Bernardone

Cast
Role: Donna Aurora Actor: Sga Sestini
Role: Lauretta Actor: Sga Schinotti
Role: Giannina Actor: Sga Benini.

Dance: As17870120

Performances

Mainpiece Title: Il Tutor Burlato

Cast
Role: Lindora Actor: Sga Sestini
Role: Rosina Actor: Sga Benini.

Dance: As17870213

Ballet: Zemira and Azor. As17870213

Performances

Mainpiece Title: Il Tutor Burlato

Cast
Role: Lindora Actor: Sga Sestini
Role: Rosina Actor: Sga Benini.

Dance: As17870213

Ballet: Zemira and Azor. As17870213

Performances

Mainpiece Title: Giannina E Bernardone

Cast
Role: Donna Aurora Actor: Sga Sestini
Role: Lauretta Actor: Sga Schinotti
Role: Giannina Actor: Sga Benini.

Dance: As17870213

Ballet: Zemira and Azor. As17870213

Performances

Mainpiece Title: Il Tutor Burlato

Cast
Role: Lindora Actor: Sga Sestini
Role: Rosina Actor: Sga Benini.

Dance: End I: Divertissement, as17870213; End Opera: La Fete Provencale, as17870308