SELECT * FROM london_stages WHERE eventid IN (13769, 13773, 13777, 13781, 13785, 13789, 13804, 13808, 13811, 13815, 13818, 13822, 13826, 13830, 13833, 13837, 13841, 13845, 13851, 13855, 13859, 13863, 13869, 13873, 13877, 13880, 13884, 13888, 13893, 13897, 13901, 13905, 13927, 13934, 13938, 13941, 13944, 13948, 13952, 13957, 13960, 13986, 13989, 13997, 14001, 14004, 14043, 14051, 14057, 14063, 14108, 14123, 14135, 14161, 14181, 14187, 14229, 14300, 14301, 14313, 14316, 15001, 15005, 15011, 15014, 15505, 15566, 15570, 15584, 15604, 16163, 16221, 16485, 16504, 16510, 16531, 16534, 16548, 17372, 17375, 17376, 17380, 17385, 17386, 17392, 17412, 17414, 17495, 17686, 17689, 17693, 17697, 17700, 17702, 17706, 17710, 17713, 17718, 17720, 17723, 17730, 17734, 17738, 17741, 17745, 17753, 17757, 17764, 17768, 17771, 17775, 17781, 17784, 17787, 17790, 17794, 17798, 17800, 17807, 17811, 17814, 18054, 18058, 18323, 18326, 18387, 18390, 18397, 18401, 18407, 18411, 18445, 18452, 18469, 18620, 18803, 19050, 19052, 19055, 19057, 19244, 19247, 19249, 19282, 19284, 19286, 19287, 19289, 19290, 19292, 19294, 19297, 19299, 19301, 19303, 19305, 19307, 19309, 19311, 19313, 19315, 19318, 19320, 19322, 19324, 19326, 19328, 19332, 19356, 19358, 19368, 19374, 19376, 19377, 19379, 19383, 19411, 19415, 19418, 19420, 19455, 19534, 19536, 19538, 19543, 19545, 19547, 19549, 19556, 19562, 19568, 19576, 19590, 19595, 19611, 19620, 19673, 19675, 19679, 19689, 19697, 19751, 19757, 19763, 19766, 19768, 19770, 19772, 19789, 19800, 19805, 19815, 19818, 19820, 19827, 19832, 19834, 19836, 19839, 19842, 19845, 19847, 19855, 19858, 19861, 19878, 19881, 19883, 19978, 20002, 20012, 20053, 20067, 20090, 20102, 20292, 20295, 20311, 20326, 20347, 20359, 20398, 20415, 20421, 20438, 20461, 20679, 20697, 20706, 20805, 20814, 20817, 20832, 20835, 20838, 20841, 20845, 20875, 20895, 20898, 20902, 20905, 20908, 20911, 20914, 20917, 20928, 20937, 20948, 20951, 20955, 20960, 20967, 20980, 20990, 21000, 21013, 21020, 21041, 21059, 21066, 21086, 21092, 21096, 21099, 21103, 21112, 21116, 21119, 21126, 21172, 21184, 21195, 21198, 21230, 21260, 21326, 21332, 21347, 21354, 21359, 21360, 21366, 21370, 21378, 21382, 21390, 21398, 21405, 21418, 21451, 21482, 21506, 21517, 21534, 21551, 21573, 21635, 21761, 21771, 21805, 21821, 21884, 21887, 21908, 21943, 21948, 21950, 21986, 22024, 22027, 22032, 22034, 22038, 22043, 22132, 22138, 22166, 22182, 22188, 22213, 22253, 22275, 22333, 22366, 22442, 22483, 22524, 22545, 22620, 22687, 22836, 22923, 22981, 23011, 23055, 23090, 23106, 23127, 23156, 23247, 23315, 23351, 23369, 23380, 23383, 23389, 23393, 23409, 23433, 23501, 23600, 23603, 23606, 23861, 23875, 23910, 24427, 24433, 24436, 24438, 24441, 24444, 24447, 24448, 24451, 24454, 24457, 24460, 24463, 24466, 24477, 24503, 24536, 24580, 24641, 24692, 25288, 25295, 26305, 26308, 26314, 27690, 27692, 27722, 27728, 27737, 27763, 28059, 28219, 28633, 28667, 29237, 29593, 29776, 30297, 30383, 30684, 43657, 44031, 44078, 46407, 46409, 46411, 46413, 46415, 46417, 46419, 46421, 46423, 46425, 46427, 46429, 46431, 46433, 46436, 46438, 46441, 46443, 46446, 46448, 46452, 46455, 46457, 46460, 46462, 46464, 46466, 46469, 46471, 46476, 46478, 46481, 46486, 46492, 46495, 46509, 46511, 46515, 46522, 46529, 46536, 46566, 46593, 46700, 46711, 46729, 47083, 47086, 47088, 47091, 47093, 47096, 47098, 47101, 47104, 47108, 47114, 47117, 47119, 47124, 47128, 47131, 47133, 47139, 47144, 47148, 47150, 47156, 47161, 47165, 47186, 47204, 47214, 47270, 47320, 47454, 47458, 47462, 47470, 47474, 47475, 47478, 47482, 47489, 47503, 47517, 47523, 47535, 47559, 47562, 47564, 47572, 47580, 47582, 47584, 47586, 47589, 47591, 47593, 47595, 47597, 47600, 47603, 47605, 47607, 47609, 47611, 47614, 47616, 47619, 47621, 47623, 47625, 47628, 47631, 47633, 47635, 47637, 47639, 47641, 47649, 47651, 47665, 47674, 47688, 47690, 47709, 47714, 47724, 47729, 47754, 47759, 47769, 47779, 47787, 47815, 47825, 47830, 47850, 47869, 47885, 48015, 48023, 48029, 48032, 48038, 48043, 48049, 48080, 48090, 48091, 48109, 48133, 48135, 48137, 48139, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48168, 48170, 48172, 48174, 48176, 48178, 48180, 48182, 48250, 48252, 48257, 48261, 48264, 48266, 48271, 48275, 48280, 48303, 48306, 48308, 48311, 48313, 48315, 48317, 48320, 48322, 48325, 48329, 48331, 48336, 48347, 48358, 48361, 48363, 48366, 48368, 48370, 48375, 48377, 48380, 48382, 48384, 48394, 48404, 48409, 48411, 48430, 48432, 48437, 48447, 48539, 48541, 48551, 48553, 48567, 48615, 48645, 48659, 48665, 48685, 48697, 48704, 48707, 48714, 48719, 48727, 48837, 48860, 48947, 49028, 49053, 49072, 49081, 49083, 49100, 49208, 49211, 49256, 49266, 49338, 49340, 49343, 49345, 49348, 49350, 49352, 49354, 49357, 49359, 49362, 49371, 49373, 49376, 49378, 49385, 49387, 49390, 49392, 49399, 49401, 49408, 49411, 49413, 49416, 49418, 49420, 49422, 49425, 49427, 49430, 49432, 49434, 49439, 49452, 49465, 49493, 49517, 49543, 49553, 49565, 49568, 49585, 49604, 49614, 49657, 49799, 49803, 49817, 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, 49980, 49983, 49985, 49987, 49989, 49992, 49994, 49998, 50001, 50004, 50006, 50010, 50013, 50016, 50019, 50023, 50026, 50029, 50031, 50035, 50038, 50041, 50044, 50048, 50052, 50070, 50079, 50089, 50092, 50099, 50104, 50113, 50116, 50128, 50134, 50138, 50143, 50148, 50163, 50166, 50193, 50195, 50200, 50203, 50330, 50340, 50352, 50361, 50364, 50368, 50374, 50376, 50380, 50385, 50387, 50389, 50418, 50420, 50422, 50424, 50428, 50433, 50435, 50438, 50440, 50444, 50447, 50452, 50454, 50456, 50461, 50463, 50468, 50472, 50475, 50477, 50480, 50482, 50484, 50487, 50489, 50492, 50494, 50496, 50498, 50501, 50503, 50506, 50508, 50510, 50512, 50515, 50520, 50522, 50524, 50526, 50529, 50531, 50534, 50536, 50538, 50540, 50543, 50546, 50549, 50551, 50554, 50556, 50559, 50562, 50564, 50566, 50568, 50571, 50573, 50576, 50578, 50581, 50583, 50588, 50591, 50593, 50595, 50597, 50600, 50602, 50605, 50607, 50609, 50611, 50616, 50620, 50626, 50628, 50632, 50635, 50638, 50640, 50684, 50688, 50690, 50695, 50702, 50704, 50707, 50709, 50712, 50714, 50717, 50722, 50724, 50726, 50728, 50736, 50742, 50744, 50754, 50757, 50759, 50762, 50764, 50772, 50777, 50784, 50790, 50795, 50800, 50802, 50805, 50812, 50919, 50925, 50937, 50940, 50942, 50944, 50948, 50950, 50953, 50957, 50959, 50961, 50963, 50965, 50969, 50971, 50977, 51003, 51005, 51007, 51009, 51012, 51014, 51016, 51018, 51021, 51024, 51027, 51029, 51031, 51033, 51036, 51038, 51041, 51043, 51045, 51047, 51050, 51059, 51064, 51067, 51069, 51071, 51073, 51076, 51078, 51081, 51083, 51085, 51087, 51090, 51092, 51095, 51097, 51099, 51101, 51104, 51107, 51110, 51112, 51114, 51116, 51119, 51121, 51124, 51126, 51128, 51130, 51133, 51140, 51154, 51159, 51161, 51164, 51166, 51168, 51170, 51173, 51179, 51182, 51185, 51187, 51191, 51194, 51197, 51199, 51206, 51209, 51211, 51215, 51218, 51221, 51223, 51227, 51231, 51234, 51237, 51241, 51244, 51247, 51249, 51254, 51256, 51258, 51261, 51263, 51266, 51268, 51273, 51285, 51290, 51298, 51302, 51304, 51309, 51312, 51317, 51319, 51322, 51329, 51336, 51338, 51341, 51343, 51345, 51349, 51351, 51354, 51356, 51358, 51363, 51365, 51368, 51376, 51481, 51488, 51501, 51505, 51509, 51513, 51517, 51521, 51525, 51527, 51529, 51535, 51537, 51539, 51541, 51543, 51545, 51547, 51549, 51551, 51553, 51555, 51559, 51563, 51567, 51571, 51575, 51579, 51583, 51585, 51589, 51598, 51601, 51603, 51605, 51607, 51610, 51613, 51615, 51617, 51619, 51621, 51624, 51627, 51629, 51631, 51634, 51636, 51639, 51641, 51643, 51648, 51655, 51662, 51664, 51676, 51694, 51697, 51699, 51701, 51704, 51706, 51710, 51713, 51716, 51718, 51722, 51725, 51728, 51730, 51734, 51737, 51740, 51743, 51747, 51750, 51753, 51755, 51762, 51765, 51767, 51771, 51774, 51777, 51779, 51782, 51784, 51786, 51789, 51792, 51794, 51797, 51799, 51801, 51806, 51811, 51813, 51815, 51817, 51820, 51825, 51828, 51833, 51836, 51841, 51843, 51845, 51849, 51856, 51864, 51869, 51871, 51885, 51887, 51890, 51900, 51907, 51914, 51933, 51936) 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: Zara

Afterpiece Title: Harlequin Restor'd

Cast
Role: Park Keeper Actor: Gray

Performances

Mainpiece Title: The Old Batchelor

Afterpiece Title: Harlequin Restor'd

Cast
Role: Park Keeper Actor: Gray

Performances

Mainpiece Title: The Double Dealer

Afterpiece Title: Harlequin Restor'd

Cast
Role: Park Keeper Actor: Gray

Music: Select Pieces

Dance: I: Tambourine by Mlle Roland. II: Russian Sailor by Denoyer, &c

Performances

Mainpiece Title: The Miser

Afterpiece Title: Harlequin Restor'd

Cast
Role: Park Keeper Actor: Gray

Performances

Mainpiece Title: The Twin Rivals

Afterpiece Title: Harlequin Restor'd

Cast
Role: Park Keeper Actor: Gray

Dance: I: By Mlle Anne Roland. II: English Maggot by Villeneuve and Mrs Walter. III: Revellers by Essex, Mrs Walter, &c. IV: Russian Sailor by Denoyer, &c. V: French Peasants by Poitier, Mlle Roland, &c

Performances

Mainpiece Title: The Spanish Fryar

Afterpiece Title: Harlequin Restor'd

Cast
Role: Park Keeper Actor: Gray

Dance: II: English Maggot by Villeneuve and Mrs Walter. III: Revellers by Essex, Mrs Walter, &c. IV: French Peasants by Poitier, Mlle Roland, &c

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: Harlequin Restor'd

Cast
Role: Park Keeper Actor: Gray

Dance: III: Russian Sailor by Denoyer, &c. In IV: Tambourine by Mlle Roland

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Harlequin Restor'd

Cast
Role: Park Keeper Actor: Gray

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Harlequin Restor'd

Cast
Role: Park Keeper Actor: Gray

Music: In II: Solo on Violin by Charke

Dance: III: Le Badinage by Poitier, Mlle Roland, &c. IV: Le Ballet d'Amour (new) by Denoyer, Mlle Anne Roland, &c

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Harlequin Restor'd

Cast
Role: Park Keeper Actor: Gray

Music: In II: Solo on Violin by Charke

Dance: III: Tambourine by Mlle Roland. IV: Le Ballet d'Amour by Denoyer, Mlle Anne Roland, &c

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Harlequin Restor'd

Cast
Role: Park Keeper Actor: Gray

Music: In II: Solo on Violin by Charke

Dance: II: New Serious Dance by Denoyer, Mlle Anne Roland, &c. III: Revellers by Essex, Mrs Walter, &c. IV: French Peasants by Poitier, Mlle Roland, &c

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Harlequin Restor'd

Cast
Role: Park Keeper Actor: Gray

Music: As17360211

Dance: II: Rover by Essex, Mrs Walter, Miss Mann, &c. III: Le Badinage de Provence by Poitier, Mlle Roland, &c

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Harlequin Restor'd

Cast
Role: Park Keeper Actor: Gray

Music: As17360211

Dance: II: Rover by Essex, Mrs Walter, Miss Mann, &c. III: Russian Sailor by Denoyer, &c

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Harlequin Restor'd

Cast
Role: Park Keeper Actor: Gray

Music: In II: Violin Solo by Charke

Dance: I: English Maggot by Villeneuve, Mrs Walter, &c. II: The Rover by Essex, Mrs Walter, Miss Mann, &c. III: New Serious Dance by Denoyer, Mlle Anne Roland, &c. IV: Revellers by Essex, Mrs Walter, &c

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Harlequin Restor'd

Cast
Role: Park Keeper Actor: Gray

Music: As17360214

Dance: As17360214, but Revellers omitted

Performances

Mainpiece Title: Love For Love

Afterpiece Title: Harlequin Restor'd

Cast
Role: Park Keeper Actor: Gray

Dance: II: English Maggot by Villeneuve and Mrs Walter. III: Rover, as17360214

Performances

Mainpiece Title: Love Makes A Man

Afterpiece Title: Harlequin Restor'd

Cast
Role: Park Keeper Actor: Gray

Dance: I: By Mlle Anne Roland. II: English Maggot by Villeneuve and Mrs Walter. III: Rover, as17360214

Performances

Mainpiece Title: The Miser

Afterpiece Title: Harlequin Restor'd

Cast
Role: Park Keeper Actor: Gray

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: Harlequin Restor'd

Cast
Role: Park Keeper Actor: Gray

Dance: I: English Maggot by Villeneuve and Mrs Walter. III: Grand Serious Ballet by Denoyer, Mlle Anne Roland, Denoyer's Apprentice, &c

Performances

Mainpiece Title: The Mother-in-law

Afterpiece Title: Harlequin Restor'd

Cast
Role: Park Keeper Actor: Gray

Dance: As17360221

Performances

Mainpiece Title: The Double Gallant

Afterpiece Title: Harlequin Restor'd

Cast
Role: Park Keeper Actor: Gray

Dance: IV: English Maggot by Villeneuve and Mrs Walter

Performances

Mainpiece Title: Amphitryon

Afterpiece Title: Harlequin Restor'd

Cast
Role: Park Keeper Actor: Gray

Dance: I: Black Joak by Phillips and Miss Mann. II: Rover by Essex, Mrs Walter, Miss Mann, &c. III: Damon and Phillida, as17360430 IV: Shepherd's Mount by Essex, Mrs Walter, Mrs Anderson, &c. V: By Mlle Anne Roland

Performances

Mainpiece Title: Cato

Afterpiece Title: Harlequin Restor'd

Cast
Role: Park Keeper Actor: Gray

Dance: Miller and his Wife by Poitier and Mlle Roland. Le Badinage de Provence by Poitier, Mlle Roland, &c

Performances

Mainpiece Title: King Henry The Fourth, Part Ii

Afterpiece Title: Poor Pierot Married; or, Harlequin Happy

Cast
Role: Fryar Actor: Gray

Performances

Mainpiece Title: The Old Batchelor

Afterpiece Title: Poor Pierot Married

Cast
Role: Fryar Actor: Gray