SELECT * FROM london_stages WHERE eventid IN (1065, 1262, 1337, 1444, 1542, 1778, 1863, 1984, 2007, 2029, 2105, 4023, 4033, 4045, 4048, 4188, 4581, 4839, 4853, 4855, 4858, 4865, 4907, 4913, 4973, 5161, 5289, 6071, 6074, 6091, 7004, 9225, 9319, 10469, 10593, 10596, 10599, 10810, 10905, 10976, 10977, 11246, 11398, 12619, 12621, 12629, 12647, 12744, 12759, 12764, 12994, 13304, 13328, 13434, 13668, 13727, 13735, 14114, 14164, 14274, 14412, 14415, 14418, 14422, 14425, 14428, 14431, 14438, 14441, 14445, 14448, 14451, 14454, 14458, 14468, 14477, 14485, 14488, 14498, 14501, 14527, 14533, 14552, 14555, 14558, 14584, 14587, 14594, 14601, 14612, 14621, 14692, 14698, 14722, 14773, 14831, 14861, 14889, 14898, 14904, 14921, 15335, 15338, 15341, 15363, 15394, 15526, 15594, 15618, 15780, 15807, 15823, 15841, 16116, 16143, 16256, 16451, 16636, 16815, 17349, 17454, 17654, 17759, 17833, 18007, 18258, 18647, 18860, 18978, 19043, 19093, 19148, 19169, 19231, 19270, 19306, 19308, 19329, 19354, 19355, 19393, 19452, 19557, 19614, 19647, 19699, 19794, 19867, 19906, 19908, 19921, 19957, 20009, 20138, 20146, 20209, 20680, 20747, 20753, 20849, 20930, 21070, 21258, 21401, 21862, 22168, 22174, 23196, 23261, 23268, 23277, 23542, 23557, 23705, 24085, 25087, 25089, 25091, 25107, 25225, 25272, 25384, 25565, 25676, 25809, 25926, 25996, 26039, 26244, 26394, 26661, 26666, 26674, 27370, 27375, 27377, 27387, 27389, 27401, 27405, 27409, 27509, 27542, 27582, 27602, 27613, 27615, 27622, 27683, 27717, 27723, 27749, 27780, 27785, 27811, 27888, 27935, 28046, 28128, 28134, 28136, 28163, 28220, 28286, 28399, 28423, 28622, 30570, 30673, 30827, 31367, 31743, 31772, 31842, 31874, 31878, 31886, 31896, 31902, 31940, 32020, 32127, 32220, 32318, 32320, 32419, 32421, 32423, 32425, 32428, 32430, 32431, 32433, 32435, 32437, 32440, 32474, 32640, 32824, 32847, 32851, 32855, 32861, 33375, 33662, 33671, 33732, 33745, 34295, 34940, 34956, 35052, 35290, 35306, 35923, 36184, 36246, 36333, 36479, 36497, 36502, 36532, 36676, 36683, 36685, 36691, 36695, 36699, 36725, 36745, 36750, 36768, 36809, 37255, 37880, 38032, 38093, 38216, 38330, 38408, 38411, 38413, 38418, 38421, 38423, 38426, 38428, 38432, 38435, 38436, 38437, 38440, 38442, 38446, 38449, 38451, 38454, 38456, 38460, 38463, 38467, 38468, 38470, 38474, 38491, 38493, 38495, 38499, 38501, 38503, 38506, 38508, 38512, 38515, 38517, 38522, 38526, 38529, 38531, 38537, 38541, 38544, 38548, 38552, 38557, 38562, 38566, 38571, 38573, 38574, 38576, 38584, 38586, 38594, 38604, 38609, 38620, 38625, 38628, 38630, 38635, 38650, 38659, 38664, 38674, 38681, 38683, 38693, 38695, 38707, 38712, 38726, 38727, 38742, 38756, 38772, 38779, 38786, 38791, 38935, 38943, 38949, 38954, 38957, 38971, 38991, 39004, 39018, 39027, 39039, 39048, 39057, 39070, 39077, 39084, 39096, 39108, 39124, 39211, 39223, 39229, 39237, 39277, 39313, 39330, 39389, 39390, 39407, 39490, 39503, 39514, 39523, 39610, 39622, 39635, 39638, 39647, 39664, 39674, 39688, 39700, 39712, 39732, 39744, 39760, 39782, 39813, 39829, 39899, 40055, 40065, 40087, 40093, 40098, 40099, 40132, 40151, 40176, 40214, 40238, 40250, 40276, 40289, 40334, 40374, 40420, 40454, 40566, 40572, 40575, 40578, 40596, 40606, 40622, 40636, 40653, 40677, 40681, 40708, 40723, 40772, 40873, 40907, 40957, 40960, 41008, 41117, 41125, 41152, 41159, 41176, 41197, 41207, 41223, 41245, 41283, 41380, 41402, 41491, 41527, 41659, 41697, 41709, 41714, 41721, 41725, 41729, 41742, 41743, 41747, 41755, 41763, 41774, 41816, 41828, 41841, 41856, 41931, 41976, 42042, 42085, 42098, 42102, 42132, 42295, 42300, 42310, 42334, 42408, 42556, 42743, 42896, 42955, 43049, 43062, 43089, 43110, 43152, 43163, 43170, 43239, 43457, 43480, 43492, 43530, 43682, 43693, 43776, 43779, 43781, 43792, 43809, 43818, 43821, 43832, 43841, 43861, 43866, 43878, 43886, 44027, 44068, 44083, 44147, 44153, 44235, 44299, 44309, 44319, 44322, 44324, 44328, 44335, 44337, 44354, 44399, 44412, 44429, 44469, 44608, 44632, 44641, 44647, 44661, 44672, 44681, 44683, 44684, 44689, 44693, 44697, 44698, 44745, 44785, 44788, 44821, 44843, 44846, 44848, 44871, 44931, 44941, 44980, 45025, 45035, 45220, 45280, 45302, 45316, 45324, 45335, 45369, 45407, 45466, 45472, 45477, 45485, 45525, 45582, 45709, 45744, 45745, 45755, 45758, 45804, 45864, 45892, 45988, 45997, 46103, 46133, 46163, 46195, 46203, 46319, 46341, 46349, 46365, 46425, 46457, 46488, 46547, 46604, 46617, 46854, 46873, 47061, 47066, 47071, 47076, 47083, 47104, 47167, 47320, 47475, 47491, 47577, 47591, 47779, 47845, 47863, 47865, 47997, 48012, 48020, 48027, 48030, 48031, 48034, 48035, 48037, 48042, 48046, 48048, 48050, 48053, 48055, 48057, 48058, 48059, 48060, 48061, 48062, 48066, 48067, 48070, 48072, 48074, 48075, 48078, 48082, 48084, 48093, 48095, 48097, 48099, 48106, 48110, 48111, 48113, 48115, 48116, 48117, 48119, 48120, 48123, 48129, 48130, 48131, 48132, 48134, 48136, 48137, 48138, 48145, 48146, 48155, 48167, 48176, 48177, 48181, 48193, 48202, 48204, 48216, 48222, 48232, 48235, 48251, 48263, 48291, 48303, 48306, 48308, 48310, 48311, 48320, 48322, 48325, 48329, 48331, 48336, 48339, 48344, 48347, 48348, 48356, 48358, 48361, 48362, 48363, 48366, 48370, 48372, 48375, 48377, 48380, 48382, 48394, 48404, 48406, 48409, 48430, 48437, 48438, 48440, 48444, 48535, 48536, 48585, 48588, 48613, 48615, 48618, 48620, 48621, 48628, 48635, 48654, 48675, 48677, 48689, 48705, 48708, 48734, 48744, 48771, 48840, 48858, 48884, 48942, 49041, 49046, 49051, 49056, 49058, 49066, 49069, 49077, 49081, 49083, 49100, 49201, 49224, 49228, 49229, 49234, 49236, 49238, 49240, 49242, 49244, 49246, 49248, 49250, 49252, 49254, 49258, 49260, 49262, 49264, 49266, 49280, 49282, 49284, 49286, 49288, 49292, 49294, 49296, 49298, 49300, 49312, 49314, 49316, 49319, 49321, 49324, 49330, 49335, 49378, 49382, 49390, 49392, 49404, 49408, 49427, 49445, 49485, 49520, 49572, 49579, 49593, 49603, 49606, 49619, 49634, 49643, 49659, 49765, 49777, 49779, 49809, 49815, 49822, 49834, 49861, 49878, 49904, 49925, 49930, 49946, 50073, 50151, 50170, 50181, 50184, 50186, 50203, 50327, 50338, 50344, 50349, 50357, 50386, 50412, 50432, 50434, 50443, 50456, 50561, 50567, 50611, 50637, 50673, 50724, 50728, 50753, 50771, 50777, 50784, 50797, 50800, 50823, 50824, 50827, 50862, 50934, 50935, 50942, 50944, 50948, 50950, 50953, 50957, 50961, 50963, 50969, 50972, 50977, 50979, 50988, 51135, 51145, 51149, 51152, 51218, 51254, 51261, 51266, 51273, 51298, 51302, 51317, 51354, 51355, 51388, 51423, 51438, 51449, 51465, 51470, 51510, 51512, 51518, 51523, 51524, 51528, 51557, 51561, 51565, 51569, 51577, 51581, 51591, 51624, 51629, 51634, 51643, 51648, 51653, 51655, 51664, 51667, 51676, 51701, 51703, 51759, 51794, 51797, 51800, 51811, 51833, 51835, 51836, 51841, 51843, 51853, 51865, 51871, 51878, 51879, 51882, 51897, 51900, 51907, 51924, 51942, 51954, 52069, 52084, 52131, 52162, 52164, 52166, 52168, 52170, 52172, 52173, 52174, 52177, 52178, 52181, 52182, 52185, 52186, 52192, 52206, 52214, 52215, 52239, 52281, 52347, 52371, 52423, 52463, 52490, 52513) 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: Don John

Cast
Role: Clara Actor: Mrs Bennet

Afterpiece Title: The Fortune Tellers

Song: As17400214

Dance: As17400213; Also End I: Scots Dance-Master Matthews, Miss Wright

Ballet: A Voyage to the Land of Cytherea. As17400115

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Cast
Role: Clara Actor: Mrs Wright

Afterpiece Title: Rosamond

Dance: III: Les Characters-Mlle Chateauneuf

Performances

Mainpiece Title: Don John

Cast
Role: Clara Actor: Mrs Bennet

Afterpiece Title: Rosamond

Dance: I: Drunken Peasant-Master Ferg; In IV: Shepherds and Shepherdesses-Muilment, Rector, Master Cook, Mrs Walter, Mrs Thompson; In V: Furies-Leviez, Baudouin, Rector, Davenport

Performances

Mainpiece Title: The Committee; Or, The Faithful Irishman

Afterpiece Title: The Cheats of Scapin

Cast
Role: Clara Actor: Mrs Vincent

Dance: MMiller and Wife, The Swiss-French Boy and Girl

Performances

Mainpiece Title: The Royal Merchant; Or, The Beggar's Bush

Afterpiece Title: The Cheats of Scapin

Cast
Role: Clara Actor: Mrs Vincent

Dance: TThe Swiss, Peasants-Mechel, Mlle Mechel; Comic Ballet-Villeneuve, Miss Oates

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: The Cheats of Scapin

Cast
Role: Clara Actor: Mrs Vincent

Dance: TThe Swiss-Mechell, Mlle Mechell; Comic Ballet-Villeneuve, Miss Oates; Italian Peasants-Desnoyer, Signora Barberini

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Cast
Role: Clara Actor: Miss Horsington

Afterpiece Title: Damon and Phillida

Dance: II: Drunken Peasant-Master Ferg; III: Muzette-Miss Morrison; IV: Matelotes-Mechell, Mlle Mechell

Music: V: Preamble on the Kettle Drums-Master Ferg

Song: End Afterpiece: Arra my Judy (by Desire)-Stoppelaer

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Cast
Role: Clara Actor: Miss Hillyard

Afterpiece Title: The Necromancer

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Cast
Role: Clara Actor: Miss Horsington.

Afterpiece Title: The Devil to Pay

Dance: II: As17410926

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Cast
Role: Clara Actor: Miss Hillyard

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Cast
Role: Clara Actor: Mrs Yates

Afterpiece Title: The Imprisonment

Performances

Mainpiece Title: Rule A Wife

Cast
Role: Clara Actor: Miss Hillyard

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: Rule A Wife

Cast
Role: Clara Actor: Miss Hillyard

Afterpiece Title: Orpheus and Eurydice

Dance: LLouvre, Minuet-Dupre, a scholar of his

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Cast
Role: Clara Actor: Mrs Horsington.

Afterpiece Title: Miss Lucy in Town

Dance: II: Les Matelotes, as17421009; V: Turkish Seraglio, as17421027

Music: III: Concerto-Veracini

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Cast
Role: Clara Actor: Miss Hillyard

Afterpiece Title: Old Man Taught Wisdom; or, The Virgin Unmask'd

Dance: Villeneuve, Mrs Delagarde

Performances

Mainpiece Title: The Astrologer; Or, The Pretended Transformation

Cast
Role: Clara Actor: Mrs Giffard

Performances

Mainpiece Title: The Astrologer

Cast
Role: Clara Actor: Mrs Giffard

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Cast
Role: Clara Actor: Mrs Rowley

Afterpiece Title: Phebe

Dance: PPeasant-Cooke; Les Allemandes, as17451109

Performances

Mainpiece Title: The Humours Of The Army; Or, The Female Officer

Cast
Role: Clara Actor: Miss Cole

Afterpiece Title: Will and no Will; or, A Bone for Lawyers

Performances

Mainpiece Title: The Humours Of The Army

Cast
Role: Clara Actor: Miss Cole

Afterpiece Title: The Anatomist

Performances

Mainpiece Title: The Humours Of The Army

Cast
Role: Clara Actor: Miss Cole

Afterpiece Title: The Lying Valet

Song: Between the acts: Bibby, Mrs Sibella

Dance: The Mechels

Performances

Mainpiece Title: The Humours Of The Army; Or, The Female Officer

Cast
Role: Clara Actor: Miss Cole.

Afterpiece Title: The Lottery

Song: II: Lowe

Dance: V: As17461216

Performances

Mainpiece Title: The Humours Of The Army

Cast
Role: Clara Actor: Miss Cole.

Dance: TThe Turkish Pirate, as17461229; Laundress's Visiting Day, as17461229

Performances

Mainpiece Title: The Humours Of The Army

Cast
Role: Clara Actor: Miss Cole.

Afterpiece Title: Flora

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Cast
Role: Clara Actor: Miss Copen

Afterpiece Title: The Royal Chace