SELECT * FROM london_stages WHERE eventid IN (1030, 1886, 2178, 2298, 2641, 2983, 3024, 4545, 4690, 7621, 8442, 8444, 8446, 8449, 8451, 8488, 8542, 8676, 11141, 11144, 11146, 12703, 14226, 15086, 15399, 15584, 15601, 15604, 15727, 15730, 15815, 15821, 15824, 15827, 15884, 15892, 15922, 15930, 15941, 16070, 16368, 16464, 16496, 16497, 16541, 16608, 16728, 16736, 16750, 16853, 16892, 16984, 17188, 17444, 17528, 17615, 17741, 17800, 18038, 18230, 18308, 18360, 18592, 18712, 18819, 18868, 18917, 19003, 19033, 19117, 19120, 19178, 19287, 19301, 19376, 19457, 19499, 19568, 19617, 19653, 19729, 19793, 19837, 20022, 20527, 20580, 20612, 20659, 20720, 20734, 20825, 20918, 20925, 20953, 20970, 21030, 21056, 21099, 21104, 21109, 21112, 21116, 21119, 21126, 21129, 21132, 21184, 21262, 21306, 21308, 21319, 21347, 21411, 21449, 21451, 21452, 21471, 21517, 21538, 21603, 21607, 21613, 21652, 21683, 21735, 21756, 21766, 21822, 21866, 21914, 21947, 21991, 22020, 22039, 22043, 22059, 22172, 22199, 22209, 22247, 22252, 22254, 22364, 22424, 22468, 22571, 22680, 22750, 22803, 22945, 23000, 23052, 23124, 23175, 23217, 23237, 23301, 23366, 23466, 23525, 23553, 23614, 23724, 23727, 23746, 23859, 24073, 24423, 24431, 24506, 24526, 24564, 24621, 24797, 24916, 24919, 25003, 25063, 25080, 25151, 25164, 25170, 25182, 25195, 25334, 25394, 25456, 25520, 25541, 25703, 25728, 25760, 25896, 26017, 26076, 26124, 26199, 26303, 26388, 26422, 26466, 26538, 26641, 26646, 26650, 26688, 26757, 26813, 26899, 27095, 27096, 27144, 27194, 27292, 27333, 27424, 27467, 27476, 27541, 27559, 27673, 27809, 27871, 28075, 28096, 28137, 28221, 28274, 28295, 28315, 28334, 28411, 28556, 28557, 28624, 28681, 28732, 28780, 29028, 29047, 29061, 29164, 29176, 29184, 29249, 29266, 29301, 29341, 29357, 29367, 29437, 29721, 29841, 29992, 30146, 30223, 30322, 30473, 30671, 30788, 30955, 31031, 31169, 31361, 31412, 31777, 31842, 31844, 31915, 31991, 32035, 32141, 32248, 32379, 32516, 33199, 33440, 33484, 33539, 33674, 34351, 34526, 34544, 34807, 34902, 35063, 35153, 35161, 35175, 35333, 35668, 35710, 35719, 35752, 35953, 36126, 36146, 36158, 36179, 36182, 36263, 36356, 36503, 36556, 36602, 36637, 36672, 36796, 37334, 37387, 37468, 37788, 37876, 38102, 38158, 38247, 38401, 38505, 38750, 38857, 38901, 39046, 39454, 39518, 39736, 39876, 39946, 40049, 40579, 40601, 40733, 41001, 41131, 41141, 41144, 41323, 41872, 41941, 42422, 42515, 42518, 42520, 42522, 42525, 42527, 42532, 42586, 42594, 42599, 42612, 42709, 42749, 42893, 42897, 42902, 42907, 42913, 42917, 42921, 42927, 42962, 43016, 43088, 43683, 44060, 44077, 44635, 44949, 44964, 45333, 45384, 45461, 45559, 45567, 45574, 45589, 45763, 45765, 45769, 45777, 45787, 45833, 45906, 45932, 45934, 45962, 46005, 46098, 46112, 46118, 46122, 46287, 46295, 46305, 46313, 46325, 46331, 46338, 46349, 46351, 46357, 46363, 46377, 46387, 46389, 46399, 46411, 46423, 46436, 46443, 46448, 46462, 46469, 46471, 46483, 46492, 46500, 46506, 46511, 46519, 46524, 46533, 46543, 46552, 46557, 46564, 46580, 46602, 46614, 46632, 46659, 46688, 46885, 46897, 46921, 46923, 46925, 46927, 46929, 46931, 46933, 46937, 46945, 46947, 46953, 46955, 46963, 47001, 47005, 47013, 47025, 47037, 47047, 47049, 47061, 47066, 47071, 47076, 47083, 47088, 47091, 47104, 47167, 47207, 47235, 47253, 47277, 47279, 47289, 47309, 47312, 47315, 47320, 47326, 47431, 47545, 47553, 47678, 47680, 47704, 47714, 47729, 47754, 47769, 47815, 48057, 48093, 48579, 48657, 48679, 48684, 48692, 48694, 48699, 48707, 48745, 49058, 49266, 49313, 49344, 49347, 49372, 49394, 49457, 49474, 49494, 49525, 49544, 49649, 49757, 49821, 49829, 49839, 49880, 49883, 49900, 49902, 49905, 49907, 49910, 49912, 49915, 49917, 49919, 49921, 49924, 49926, 49929, 49931, 49933, 49935, 49938, 49940, 49943, 49945, 49947, 49949, 49952, 49954, 49957, 49959, 49961, 49966, 49968, 49971, 49978, 49992, 50099, 50113, 50116, 50163, 50172, 50193, 50195, 50203, 50338, 50393, 50412, 50519, 50663, 50724, 50915, 50990, 50997, 51193, 51322, 51368, 51486, 51488, 51523, 51668, 51807, 51870, 52090, 52110, 52159, 52218, 52227, 52236, 52253, 52447, 52452, 52456, 52466, 52471) 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: All's Well That Ends Well

Cast
Role: Mariana Actor: Mrs Marshall

Afterpiece Title: The Fortune Tellers

Song: I: Song with French Horns-Beard; IV: Song-Beard

Dance: II: A Dutch Dance, as17411114; III: The Italian Peasants, as17411205

Performances

Mainpiece Title: All's Well That Ends Well

Cast
Role: Mariana Actor: Mrs Marshall

Afterpiece Title: Fortune Tellers

Song: I, III: Song-Mrs Arne

Dance: II: Le Genereux Corsaire, as17420218

Ballet: V: Les Satires Puny. As17420106

Performances

Mainpiece Title: All's Well That Ends Well

Cast
Role: Mariana Actor: Mrs Marshall

Afterpiece Title: Harlequin Shipwrecked

Song: I: Celia has ten thousand charms-Beard; III: Song with French Horns-Beard

Dance: II: A Concerto, as17420105; IV: The Italian Peasants, as17411205

Performances

Mainpiece Title: All's Well That Ends Well

Cast
Role: Mariana Actor: Mrs Marshall

Afterpiece Title: The Fortune Tellers

Song: I: See from the Silent Groves-Beard; IV: Song in Italian-Beard

Dance: II: The Swiss, as17410926; III: A Miller's Dance-Delamain

Performances

Mainpiece Title: All's Well That Ends Well

Cast
Role: Mariana Actor: Mrs Marshall

Song: I: Song with French Horns-Beard; III: A Ballad-Lowe

Dance: II: Les Egyptiens, as17420224; V: New Grand Ballet, as17420224

Performances

Mainpiece Title: All's Well That Ends Well

Cast
Role: Mariana Actor: Mrs Marshall

Song: I: Happy Pair-Beard; III: Bright Author of my Present Flame-Lowe

Dance: II: Le Boufon, as17411030; V: Les Matelotes, as17411110

Performances

Mainpiece Title: All's Well That Ends Well

Cast
Role: Mariana Actor: Mrs Marshall

Afterpiece Title: Harlequin Shipwrecked

Song: I: Ballad-Lowe; IV: The Early Horn-Lowe

Dance: II: The Serious Dance, as17420322 III: Dutch Dance, as17411219

Performances

Mainpiece Title: The Miser

Cast
Role: Mariana Actor: Mrs Mills

Afterpiece Title: The King and Miller of Mansfield

Song: I: The Noontide Air-Beard; V: Ellen@a@Roon (by Particular Desire)-Mrs Clive

Dance: II: Running Footman's Dance, as17420428 IV: a Dutch Dance-Phillips

Performances

Mainpiece Title: The Miser

Cast
Role: Mariana Actor: Mrs E. Giffard.

Afterpiece Title: The Lying Valet

Dance: two Mwo Masters Granier, Miss Granier

Performances

Mainpiece Title: The Miser

Cast
Role: Mariana Actor: Mrs Mills

Afterpiece Title: Miss Lucy in Town

Performances

Mainpiece Title: The Miser

Cast
Role: Mariana Actor: Mrs Horton

Dance: SScots Dance-Sga Barbarina; Les Savoyardes, as17420501; La Provencale, as17420212

Ballet: RRural Assembly. As17420508

Performances

Mainpiece Title: The Miser

Cast
Role: Mariana Actor: Mrs Mills

Afterpiece Title: The King and Miller of Mansfield

Music: I: Concerto-Veracini; III: Let me wander not unseen-Lowe

Dance: II: Tyrolean Dance, as17420921; V: Peasant Dance, as17420921

Performances

Mainpiece Title: The Miser

Cast
Role: Mariana Actor: Mrs Horton

Dance: DDutch Skipper, as17421025; Characters of Dancing, as17421025; Grand Ballet-Cook, Anne Auretti

Performances

Mainpiece Title: Measure For Measure

Cast
Role: Mariana Actor: Mrs Hale

Dance: LLes Bourgeoise-Dumont, Mlle Auguste, Mrs Delagarde; Grand Ballet, as17421108; Characters of Dancing, as17421025

Performances

Mainpiece Title: The Miser

Cast
Role: Mariana Actor: Mrs Mills

Song: I: Beard; III: Lowe

Dance: II: Turkish Seraglio, as17421112; IV: Les Moisoneurs de la Styrie-Torinese, Signora Aquilanti, Boromeo, Mlle Bonneval

Performances

Mainpiece Title: Measure For Measure

Cast
Role: Mariana Actor: Mrs Hale

Dance: CCharacters of Dancing, as17421025; La Villageoise, as17421006; Grand Ballet, as17421108

Performances

Mainpiece Title: Measure For Measure

Cast
Role: Mariana Actor: Mrs Hale

Dance: LLes Boufons du Cour, as17421120; Characters of Dancing, as17421025; Les Jardiniers Suedois, as17421120

Performances

Mainpiece Title: The Miser

Cast
Role: Mariana Actor: Mrs Mills

Dance: II: Les Moisoneurs de la Styrie, as17421126; IV: La Recrue des Houssars, as17421221

Performances

Mainpiece Title: Measure For Measure

Cast
Role: Mariana Actor: Mrs Hale

Afterpiece Title: Rape of Proserpine

Performances

Mainpiece Title: Measure For Measure

Cast
Role: Mariana Actor: Mrs Hale

Afterpiece Title: Perseus and Andromeda

Performances

Mainpiece Title: All's Well That Ends Well

Cast
Role: Mariana Actor: Mrs Dunstall

Afterpiece Title: Bickerstaff's Unburied Dead

Performances

Mainpiece Title: All's Well That Ends Well

Cast
Role: Mariana Actor: Mrs Dunstall

Afterpiece Title: Bickerstaff's Unburied Dead

Performances

Mainpiece Title: Measure For Measure

Cast
Role: Mariana Actor: Mrs Hale

Afterpiece Title: The Royal Chace

Dance: Cooke, the two Aurettis

Performances

Mainpiece Title: Measure For Measure

Cast
Role: Mariana Actor: Mrs Hale

Afterpiece Title: The Rape of Proserpine

Performances

Mainpiece Title: The Miser

Cast
Role: Mariana Actor: Mrs Giffard

Afterpiece Title: The Lying Valet