SELECT * FROM london_stages WHERE eventid IN (660, 1023, 1053, 1079, 1155, 1159, 1207, 1266, 1282, 1283, 1287, 1304, 1315, 1322, 1328, 1329, 1442, 1463, 1473, 1531, 1537, 1567, 1575, 1582, 1601, 1670, 1683, 1691, 2196, 2395, 2428, 2435, 2459, 2468, 2520, 2560, 2583, 2653, 2658, 2672, 2727, 2853, 2876, 3170, 3429, 3791, 3799, 3804, 3809, 3843, 3872, 5865, 6018, 6028, 6033, 6038, 6074, 6086, 6091, 6096, 6097, 6117, 6199, 6235, 6243, 6269, 6366, 6488, 6506, 6508, 6543, 6577, 6634, 6741, 6790, 6894, 6900, 6901, 6903, 6906, 6909, 6929, 6948, 7034, 7037, 7046, 7048, 7052, 7058, 7072, 7074, 7120, 7128, 7214, 7230, 7328, 7344, 7402, 7456, 7470, 7496, 7500, 7535, 7603, 7664, 7686, 7742, 7859, 7875, 7877, 7880, 7884, 7887, 7893, 7916, 7919, 7930, 7932, 7936, 7938, 7948, 7989, 7994, 8006, 8012, 8018, 8029, 8031, 8033, 8035, 8037, 8039, 8041, 8047, 8053, 8066, 8075, 8077, 8088, 8097, 8099, 8101, 8108, 8110, 8138, 8141, 8181, 8183, 8206, 8252, 8263, 8335, 8349, 8352, 8364, 8366, 8368, 8370, 8372, 8375, 8381, 8390, 8403, 8405, 8407, 8417, 8419, 8422, 8425, 8431, 8433, 8456, 8459, 8462, 8472, 8476, 8479, 8494, 8505, 8509, 8512, 8515, 8518, 8548, 8560, 8563, 8603, 8606, 8615, 8625, 8646, 8686, 8689, 8694, 8710, 8735, 8743, 8745, 8755, 8777, 8791, 8848, 8851, 8861, 8884, 8886, 8888, 8935, 8949, 8972, 9106, 9109, 9118, 9136, 9238, 9243, 9263, 9289, 9300, 9371, 9378, 9382, 9419, 9428, 9444, 9512, 9521, 9631, 9638, 9754, 9779, 9800, 9882, 9889, 9895, 9902, 9924, 10034, 10069, 10157, 10260, 10276, 10281, 10289, 10301, 10307, 10310, 10392, 10403, 10437, 10480, 10487, 10542, 10545, 10575, 10620, 10676, 10679, 10720, 10750, 10800, 10803, 10809, 10817, 10828, 10839, 10884, 10885, 10893, 10899, 10908, 10927, 10983, 10985, 10988, 10990, 11019, 11021, 11040, 11044, 11047, 11066, 11068, 11070, 11072, 11075, 11077, 11082, 11103, 11121, 11160, 11171, 11188, 11208, 11235, 11238, 11244, 11254, 11262, 11276, 11278, 11312, 11364, 11379, 11399, 11414, 11429, 11434, 11436, 11443, 11446, 11492, 11513, 11519, 11566, 11609, 11626, 11631, 11698, 11711, 11716, 11719, 11731, 11740, 11743, 11747, 11769, 11774, 11802, 11812, 11814, 11820, 11835, 11886, 11955, 11957, 11960, 11962, 11965, 11967, 11969, 11971, 11973, 11975, 11978, 12065, 12068, 12071, 12073, 12084, 12104, 12110, 12142, 12199, 12213, 12231, 12233, 12238, 12252, 12255, 12319, 12329, 12372, 12383, 12393, 12486, 12505, 12509, 12543, 12550, 12623, 12657, 12691, 12695, 12721, 12727, 12729, 12739, 12744, 12759, 12764, 12774, 12778, 12781, 12783, 12787, 12793, 12807, 12811, 12813, 12820, 12844, 12867, 12872, 12905, 12908, 12942, 12959, 12962, 12969, 12973, 12978, 12994, 13020, 13050, 13081, 13085, 13089, 13092, 13096, 13099, 13103, 13128, 13176, 13179, 13306, 13328, 13353, 13361, 13374, 13378, 13381, 13388, 13406, 13434, 13441, 13584, 13597, 13607, 13611, 13631, 13709, 13717, 13736, 13740, 13964, 14067, 14071, 14129, 14149, 14152, 14161, 14164, 14176, 14184, 14203, 14206, 14212, 14225, 14231, 14339, 14341, 14348, 14352, 14355, 14358, 14361, 14370, 14380, 14395, 14413, 14423, 14432, 14446, 14478, 14483, 14499, 14525, 14556, 14669, 14677, 14745, 14756, 14771, 14791, 14805, 14811, 14839, 14864, 14876, 14881, 14887, 14892, 14898, 14902, 14910, 14913, 14919, 14923, 14927, 14935, 15032, 15034, 15036, 15038, 15041, 15043, 15058, 15062, 15075, 15092, 15097, 15103, 15111, 15114, 15121, 15124, 15127, 15131, 15140, 15144, 15156, 15161, 15169, 15173, 15176, 15180, 15184, 15191, 15230, 15240, 15245, 15284, 15288, 15300, 15303, 15321, 15330, 15336, 15348, 15355, 15361, 15364, 15371, 15394, 15399, 15451, 15455, 15495, 15518, 15526, 15532, 15563, 15577, 15584, 15599, 15601, 15604, 15610, 15618, 15631, 15643, 15649, 15657, 15727, 15730, 15756, 15761, 15766, 15770, 15775, 15777, 15780, 15790, 15792, 15795, 15800, 15806, 15817, 15820, 15836, 15843, 15856, 15859, 15863, 15889, 15894, 15905, 15913, 15922, 15930, 15937, 15941, 15959, 15963, 15969, 15973, 15987, 15993, 15996, 16011, 16015, 16024, 16032, 16040, 16057, 16094, 16100, 16113, 16117, 16121, 16150, 16159, 16163, 16167, 16179, 16185, 16189, 16193, 16254, 16276, 16306, 16332, 16368, 16378, 16387, 16406, 16425, 16432, 16436, 16464, 16480, 16487, 16559, 16573, 16581, 16587, 16597, 16608, 16609, 16618, 16621, 16626, 16630, 16632, 16636, 16642, 16650, 16654, 16661, 16665, 16678, 16682, 16686, 16690, 16693, 16697, 16701, 16716, 16725, 16736, 16768, 16772, 16781, 16785, 16788, 16792, 16795, 16804, 16812, 16815, 16818, 16840, 16844, 16853, 16857, 16861, 16869, 16893, 16913, 16917, 16932, 16936, 16940, 16951, 16959, 16964, 16968, 16976, 16980, 16984, 16988, 16992, 16996, 17001, 17014, 17023, 17043, 17065, 17075, 17087, 17097, 17109, 17122, 17172, 17188, 17227, 17235, 17247, 17264, 17267, 17271, 17301, 17310, 17325, 17336, 17341, 17403, 17404, 17406, 17411, 17412, 17413, 17414, 17418, 17419, 17422, 17429, 17438, 17439, 17444, 17447, 17454, 17457, 17460, 17463, 17466, 17468, 17471, 17472, 17475, 17477, 17486, 17490, 17498, 17517, 17528, 17536, 17539, 17542, 17547, 17550, 17556, 17559, 17563, 17566, 17569, 17573, 17576, 17583, 17586, 17589, 17593, 17596, 17607, 17615, 17618, 17624, 17633, 17654, 17734, 17738, 17741, 17753, 17768, 17771, 17775, 17781, 17784, 17787, 17790, 17794, 17798, 17800, 17803, 17807, 17811, 17818, 17821, 17833, 17837, 17845, 17865, 17878, 17895, 17900, 17911, 17933, 17939, 17942, 17946, 17953, 17964, 17968, 17976, 17980, 17986, 18002, 18007, 18016, 18024, 18038, 18042, 18045, 18049, 18054, 18065, 18068, 18075, 18079, 18083, 18086, 18088, 18104, 18110, 18120, 18166, 18168, 18169, 18173, 18174, 18176, 18178, 18180, 18183, 18185, 18187, 18189, 18192, 18195, 18204, 18209, 18211, 18213, 18215, 18217, 18221, 18223, 18225, 18230, 18232, 18236, 18240, 18245, 18247, 18255, 18258, 18260, 18263, 18268, 18274, 18276, 18279, 18282, 18290, 18296, 18305, 18308, 18316, 18323, 18326, 18328, 18330, 18334, 18337, 18351, 18357, 18360, 18364, 18367, 18374, 18381, 18448, 18456, 18459, 18467, 18475, 18485, 18488, 18492, 18526, 18541, 18567, 18614, 18629, 18641, 18650, 18691, 18736, 18747, 18757, 18761, 18765, 18776, 18790, 18794, 18803, 18807, 18810, 18816, 18819, 18821, 18826, 18828, 18839, 18858, 18864, 18866, 18868, 18870, 18874, 18876, 18878, 18887, 18891, 18893, 18895, 18898, 18903, 18908, 18915, 18920, 18922, 18930, 18938, 18940, 18942, 18948, 18956, 18961, 18963, 18965, 18968, 18970, 18979, 18982, 18989, 18991, 18993, 18996, 18998, 19003, 19005, 19010, 19013, 19015, 19022, 19027, 19029, 19033, 19037, 19040, 19045, 19047, 19055, 19060, 19087, 19117, 19122, 19124, 19148, 19152, 19156, 19166, 19174, 19178, 19180, 19183, 19189, 19193, 19194, 19195, 19196, 19197, 19198, 19224, 19225, 19232, 19234, 19236, 19244, 19247, 19249, 19253, 19254, 19264, 19268, 19270, 19272, 19277, 19279, 19280, 19287, 19289, 19297, 19301, 19303, 19307, 19309, 19311, 19318, 19326, 19328, 19330, 19332, 19334, 19338, 19348, 19350, 19354, 19356, 19360, 19362, 19374, 19376, 19379, 19381, 19386, 19388, 19390, 19392, 19394, 19396, 19398, 19407, 19409, 19411, 19415, 19418, 19420, 19434, 19440, 19444, 19446, 19451, 19455, 19457, 19459, 19486, 19491, 19499, 19504, 19510, 19512, 19520, 19522, 19529, 19531, 19534, 19536, 19538, 19540, 19545, 19564, 19566, 19568, 19570, 19572, 19576, 19581, 19583, 19595, 19597, 19599, 19601, 19603, 19605, 19607, 19611, 19613, 19614, 19617, 19619, 19623, 19625, 19641, 19642, 19653, 19656, 19677, 19679, 19683, 19685, 19687, 19689, 19697, 19699, 19703, 19705, 19707, 19709, 19713, 19715, 19717, 19719, 19723, 19727, 19729, 19737, 19743, 19749, 19753, 19759, 19763, 19770, 19793, 19795, 19800, 19803, 19808, 19810, 19813, 19815, 19818, 19820, 19832, 19837, 19839, 19847, 19855, 19860, 19861, 19863, 19867, 19868, 19871, 19881, 19883, 19885, 19890, 19892, 19895, 19899, 19902, 19903, 19978, 20051, 20548, 20612, 39952, 39956, 39958, 39959, 39971, 39973, 39975, 39977, 39978, 39979, 39980, 39982, 39984, 39987, 39988, 39989, 39991, 39993, 40000, 40005, 40012) 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: Hamlet, Prince Of Denmark

Cast
Role: Polonius Actor: Griffin

Afterpiece Title: The Fortune Tellers

Ballet: AA Voyage to the Land of Cytherea. As17400115

Performances

Mainpiece Title: The Spanish Fryar

Cast
Role: Gomez Actor: Griffin

Afterpiece Title: Harlequin Shipwreck'd

Dance: III: La Matelote-Mlle Chateauneuf; IV: Le Tambourine-Mlle Chateauneuf

Performances

Mainpiece Title: She Wou'd And She Wou'd Not

Cast
Role: Manuel Actor: Griffin

Afterpiece Title: Harlequin Shipwreck'd

Dance: II: La Matelote, as17400131; III: Le Tambourine, as17400131

Performances

Mainpiece Title: The Old Batchelor

Cast
Role: Fondlewife Actor: Griffin

Afterpiece Title: Robin Goodfellow

Dance: II: La Matelote-Mlle Chateauneuf; III: Scots Dance-Master Matthews, Miss Wright; IV: Le Tambourine-Mlle Chateauneuf

Ballet: A Voyage to Cytherea. As17400115

Performances

Mainpiece Title: Amphitryon

Cast
Role: Gripus Actor: Griffin

Afterpiece Title: The Fortune Tellers

Dance: II: Drunken Peasant-Master Ferg; IV: Scots Dance-Master Matthews, Miss Wright

Ballet: A Voyage to the Land of Cytherea. As17400115

Performances

Mainpiece Title: Love For Love

Cast
Role: Trapland Actor: Griffin

Afterpiece Title: The Virgin Unmask'd

Performances

Mainpiece Title: The Mother-in-law; Or, The Doctor's The Disease

Cast
Role: Sir Credulous Actor: Griffin

Afterpiece Title: The Fortune Tellers

Dance: II: La Matelote-Mlle Chateauneuf; IV: A Scots Dance-Master Matthews, Miss Wright

Performances

Mainpiece Title: The Double Dealer

Cast
Role: Sir Paul Actor: Griffin

Afterpiece Title: The Fortune Tellers

Dance: I: La Matelote-Mlle Chateauneuf; III: French Peasants-Lalauze, Mlle Chateauneuf; IV: Muilment

Ballet: A Voyage to the Land of Cytherea. As17400115

Performances

Mainpiece Title: The Tender Husband

Cast
Role: Tipkin Actor: Griffin

Afterpiece Title: The Fortune Tellers

Dance: II: La Provencale-Mlle Chateauneuf alone; III: Drunken Peasant-Master Ferg; IV: Scots Dance-Master Matthews, Miss Wright

Ballet: A Voyage to the Land of Cytherea. As17400115

Performances

Mainpiece Title: The Committee

Cast
Role: Day Actor: Griffin

Afterpiece Title: The Fortune Tellers

Dance: II: Le Tambourine-Mlle Chateauneuf; IV: Punches-Master Ferg, Miss Wright

Ballet: A Voyage to the Land of Cytherea. As17400115

Performances

Mainpiece Title: A Bold Stroke For A Wife

Cast
Role: Obadiah Prim Actor: Griffin

Afterpiece Title: The Mock Doctor

Dance: In I: Desnoyer; to the Overture of Flavia. I: Le Tambourine-Mlle Chateauneuf; III: La Matelote-Desnoyer, Mlle Chateauneuf; V: Hungarian Dance-Desnoyer, Mlle Chateauneuf; End Afterpiece: The Louvre, Minuet-Desnoyer, Mlle Chateauneuf

Song: II: Beard

Performances

Mainpiece Title: King Henry The Eighth

Cast
Role: Sands Actor: Griffin

Afterpiece Title: The Tragedy of Tragedies

Song: I: Mary Scot-Mrs Clive

Dance: II: Muilment; IV: Russian Sailor-Desnoyer; V: Les Characteres de la Dance-Mlle Chateauneuf; Drunken Peasant-Master Ferg

Performances

Mainpiece Title: The Miser

Afterpiece Title: The Contrivances

Song: Miss Medina, Mrs Jones

Dance: HHornpipe-Yates

Performances

Afterpiece Title: Lethe

Song: Miss Medina, Mrs Jones; the Masons' Songs-Hemskirk

Dance: DDrunken Peasant-Chettle; Hornpipe-Yates, others

Performances

Mainpiece Title: She Stoops To Conquer

Cast
Role: Hastings Actor: Griffin

Afterpiece Title: Buxom Joan

Performances

Mainpiece Title: She Stoops To Conquer

Cast
Role: Hastings Actor: Griffin

Afterpiece Title: Buxom Joan

Performances

Mainpiece Title: The Maid Of The Mill

Cast
Role: Mervin Actor: Griffin

Afterpiece Title: Nature Will Prevail

Dance: End I: The Gardeners, as17780618

Performances

Mainpiece Title: The Maid Of The Mill

Cast
Role: Mervin Actor: Griffin

Afterpiece Title: Nature Will Prevail

Dance: As17780605

Performances

Mainpiece Title: The Maid Of The Mill

Cast
Role: Mervin Actor: Griffin

Afterpiece Title: Tony Lumpkin in Town

Dance: End I: As17780624

Performances

Mainpiece Title: Bonduca

Cast
Role: Drusius Actor: Griffin

Afterpiece Title: The Portrait

Performances

Mainpiece Title: Bonduca

Cast
Role: Drusius Actor: Griffin

Afterpiece Title: Buxom Joan

Performances

Mainpiece Title: Bonduca

Cast
Role: Drusius Actor: Griffin

Afterpiece Title: The Gipsies

Cast
Role: Clarin Actor: Griffin

Performances

Mainpiece Title: The Suicide

Afterpiece Title: The Gipsies

Cast
Role: Clarin Actor: Griffin

Dance: As17780615

Performances

Mainpiece Title: Bonduca

Cast
Role: Drusius Actor: Griffin

Afterpiece Title: The Gipsies

Cast
Role: Clarin Actor: Griffin

Performances

Mainpiece Title: The Maid Of The Mill

Cast
Role: Mervin Actor: Griffin

Afterpiece Title: The Mayor of Garratt

Dance: End I: As17780624 End: The Gardeners, as17780618