SELECT * FROM london_stages WHERE eventid IN (1136, 1326, 24529, 33840, 33885, 33906, 34068, 34098, 34138, 34176, 34188, 34210, 34215, 34233, 34250, 34255, 34259, 34262, 34358, 34519, 34584, 34620, 34733, 34737, 34776, 34792, 35025, 35041, 35103, 35241, 35270, 35284, 35290, 35306, 35320, 35355, 35499, 35552, 35563, 35567, 35571, 35580, 35584, 35593, 35608, 35622, 35660, 35673, 35675, 35682, 35684, 35687, 35689, 35692, 35694, 35697, 35700, 35703, 35705, 35762, 35866, 35902, 35928, 35935, 35950, 35955, 35990, 36119, 36128, 36132, 36136, 36142, 36198, 36207, 36226, 36247, 36256, 36290, 36318, 36368, 36371, 36377, 36559, 36956, 36958, 36964, 36981, 36997, 37006, 37015, 37032, 37045, 37047, 37061, 37079, 37102, 37120, 37222, 37267, 37269, 37271, 37273, 37275, 37277, 37336, 37383, 37452, 37551, 37612, 37657, 37660, 37802, 37820, 37896, 37898, 37906, 37910, 37920, 37924, 37936, 38033, 38134, 38157, 38515, 38722, 38732, 38945, 38947, 38952, 38959, 38963, 38966, 38968, 39009, 39012, 39025, 39029, 39031, 39046, 39055, 39115, 39316, 39430, 39790, 39855, 40367, 40398, 40411, 40413, 40425, 40431, 40433, 40448, 40570, 40572, 40589, 40591, 40593, 40596, 40600, 40602, 40604, 40606, 40608, 40611, 40613, 40615, 40617, 40619, 40624, 40630, 40634, 40653, 40658, 40660, 40663, 40665, 40667, 40669, 40672, 40674, 40677, 40679, 40681, 40683, 40686, 40688, 40691, 40693, 40695, 40700, 40703, 40706, 40708, 40711, 40714, 40717, 40719, 40721, 40723, 40726, 40729, 40732, 40734, 40741, 40743, 40746, 40755, 40761, 40765, 40767, 40770, 40775, 40777, 40781, 40787, 40789, 40795, 40797, 40801, 40804, 40807, 40809, 40816, 40821, 40825, 40828, 40831, 40833, 40839, 40845, 40848, 40852, 40856, 40859, 40866, 40870, 40873, 40876, 40882, 40884, 40886, 40889, 40891, 40898, 40902, 40910, 40912, 40915, 40917, 40922, 40928, 40938, 40941, 40943, 40946, 40951, 40953, 40956, 40958, 40960, 40962, 40965, 40967, 40970, 40972, 40974, 40978, 40980, 40983, 40985, 40987, 40989, 40992, 40997, 41002, 41005, 41115, 41117, 41119, 41122, 41125, 41127, 41130, 41137, 41139, 41141, 41145, 41150, 41152, 41154, 41156, 41158, 41160, 41162, 41166, 41171, 41176, 41184, 41187, 41194, 41196, 41205, 41211, 41224, 41231, 41233, 41241, 41247, 41250, 41259, 41261, 41264, 41269, 41273, 41275, 41278, 41283, 41295, 41301, 41318, 41323, 41327, 41338, 41342, 41344, 41361, 41394, 41408, 41417, 41425, 41430, 41461, 41474, 41476, 41485, 41503, 41513, 41515, 41529, 41532, 41537, 41542, 41544, 41547, 41552, 41557, 41562, 41564, 41569, 41571, 41691, 41693, 41695, 41697, 41699, 41701, 41707, 41709, 41716, 41727, 41729, 41731, 41733, 41737, 41739, 41741, 41745, 41749, 41751, 41753, 41757, 41761, 41763, 41765, 41768, 41770, 41774, 41776, 41779, 41781, 41784, 41786, 41788, 41790, 41793, 41795, 41800, 41802, 41804, 41807, 41814, 41816, 41823, 41828, 41833, 41836, 41841, 41846, 41851, 41853, 41856, 41858, 41861, 41863, 41866, 41868, 41870, 41872, 41875, 41877, 41880, 41882, 41885, 41887, 41890, 41893, 41896, 41898, 41901, 41903, 41906, 41909, 41912, 41914, 41916, 41918, 41921, 41923, 41926, 41929, 41931, 41934, 41936, 41939, 41941, 41945, 41976, 41980, 41984, 41987, 41994, 41998, 42001, 42003, 42011, 42017, 42021, 42026, 42040, 42042, 42045, 42047, 42056, 42058, 42061, 42063, 42066, 42073, 42081, 42086, 42091, 42098, 42101, 42111, 42122, 42124, 42127, 42129, 42132, 42134, 42137, 42142, 42144, 42147, 42152, 42154, 42157, 42163, 42270, 42271, 42272, 42293, 42294, 42299, 42302, 42306, 42310, 42312, 42314, 42318, 42324, 42328, 42330, 42338, 42354, 42357, 42372, 42392, 42398, 42420, 42422, 42430, 42432, 42461, 42467, 42486, 42496, 42549, 42559, 42561, 42566, 42569, 42625, 42633, 42649, 42659, 42670, 42672, 42677, 42678, 42692, 42697, 42699, 42721, 42726, 42728, 42731, 42741, 42747, 42787, 42788, 42791, 42795, 42798, 42799, 42800, 42805, 42807, 42817, 42818, 42829, 42841, 42843, 42868, 42874, 42879, 42882, 42884, 42886, 42894, 42899, 42911, 42912, 42914, 42916, 42918, 42922, 42924, 42930, 42934, 42938, 42940, 42946, 42954, 42958, 42965, 42999, 43008, 43010, 43012, 43015, 43017, 43024, 43029, 43031, 43038, 43043, 43067, 43077, 43079, 43081, 43084, 43093, 43098, 43101, 43104, 43115, 43127, 43143, 43186, 43191, 43195, 43200, 43219, 43222, 43229, 43232, 43237, 43247, 43249, 43255, 43260, 43263, 43265, 43285, 43293, 43303, 43310, 43313, 43318, 43321, 43325, 43336, 43342, 43347, 43395, 43400, 43407, 43432, 43439, 43444, 43446, 43448, 43449, 43451, 43453, 43455, 43460, 43463, 43470, 43472, 43484, 43494, 43498, 43506, 43510, 43529, 43535, 43539, 43557, 43559, 43564, 43566, 43568, 43570, 43572, 43575, 43577, 43580, 43585, 43594, 43596, 43599, 43601, 43604, 43608, 43610, 43613, 43615, 43618, 43620, 43622, 43624, 43627, 43629, 43633, 43638, 43644, 43653, 43659, 43662, 43664, 43668, 43674, 43689, 43702, 43707, 43712, 43718, 43726, 43732, 43736, 43743, 43752, 43756, 43767, 43770, 43772, 43776, 43779, 43781, 43784, 43786, 43792, 43795, 43801, 43803, 43809, 43812, 43815, 43818, 43824, 43826, 43832, 43836, 43838, 43841, 43844, 43847, 43849, 43852, 43854, 43856, 43858, 43861, 43863, 43866, 43873, 43876, 43883, 43886, 43891, 43893, 43896, 43900, 43920, 43923, 43936, 43944, 43951, 43963, 43967, 43974, 43986, 43987, 44000, 44013, 44015, 44019, 44029, 44031, 44033, 44035, 44037, 44039, 44041, 44046, 44050, 44054, 44056, 44061, 44063, 44066, 44068, 44070, 44072, 44076, 44085, 44089, 44091, 44093, 44095, 44099, 44101, 44105, 44107, 44113, 44115, 44125, 44131, 44133, 44137, 44139, 44143, 44149, 44155, 44159, 44165, 44167, 44172, 44176, 44178, 44182, 44184, 44190, 44196, 44198, 44202, 44208, 44212, 44214, 44221, 44225, 44227, 44233, 44239, 44244, 44247, 44249, 44251, 44253, 44275, 44277, 44279, 44286, 44293, 44303, 44319, 44341, 44345, 44369, 44382, 44394, 44409, 44414, 44417, 44419, 44427, 44432, 44434, 44439, 44444, 44447, 44449, 44452, 44454, 44457, 44459, 44464, 44466, 44467, 44481, 44490, 44492, 44493, 44495, 44498, 44499, 44503, 44504, 44508, 44515, 44517, 44523, 44526, 44527, 44532, 44553, 44556, 44557, 44559, 44560, 44562, 44563, 44564, 44566, 44570, 44575, 44576, 44580, 44581, 44585, 44586, 44591, 44599, 44605, 44618, 44628, 44634, 44645, 44648, 44668, 44692, 44708, 44712, 44719, 44726, 44733, 44735, 44737, 44748, 44762, 44771, 44774, 44780, 44791, 44819, 44859, 44862, 44870, 44873, 44879, 44883, 44903, 44912, 44914, 44915, 44920, 44951, 44957, 44960, 44997, 45012, 45017, 45019, 45153, 45160, 45175, 45177, 45185, 45187, 45189, 45195, 45282, 45284, 45286, 45288, 45290, 45294, 45296, 45299, 45304, 45306, 45309, 45311, 45313, 45318, 45320, 45323, 45325, 45327, 45329, 45332, 45334, 45339, 45341, 45343, 45348, 45351, 45355, 45360, 45368, 45371, 45373, 45377, 45380, 45383, 45385, 45389, 45393, 45406, 45409, 45419, 45435, 45437, 45439, 45445, 45448, 45450, 45455, 45479, 45486, 45489, 45505, 45518, 45520, 45538, 45543, 45546, 45548, 45551, 45553, 45556, 45563, 45578, 45590, 45603, 50737) 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: Annette And Lubin

Cast
Role: Mrs Tempest Actor: Mrs Bates

Afterpiece Title: Artaxerxes

Afterpiece Title: The Intriguing Chambermaid

Performances

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

Cast
Role: Soto Actor: Bates

Afterpiece Title: The Sons of Anacreon

Afterpiece Title: The Deserter

Cast
Role: Simkin Actor: Bates

Performances

Mainpiece Title: As You Like It

Cast
Role: Le Beau Actor: Bates

Afterpiece Title: The First Floor

Dance: As17870126

Song: In: the Cuckoo Song-Caelia; V: a song-Mrs Forster

Performances

Mainpiece Title: The West Indian

Cast
Role: Sailor Actor: Bates

Afterpiece Title: Who's the Dupe

Dance: End I: a Hornpipe-Bourk; End III: Minuet de la Cour-Brigg, Miss J. Stageldoir; End: Highland Reel-Bourk, the Miss Stageldoirs

Performances

Mainpiece Title: The Plain Dealer

Cast
Role: Oakam Actor: Bates

Afterpiece Title: The Deserter

Dance: End III: The Capricious Lovers-the two young D'Egvilles, Miss Blanchet (1st appearance), Miss DeCamp; End: The Scheming Jockey and Fortune@Teller-the young D'Egvilles, Miss Blanchet, Miss DeCamp

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: The Englishman in Paris

Cast
Role: Kitteau Actor: Bates

Dance: In afterpiece: The Minuet de la Cour-Hamoir, Miss Stageldoir

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Trip Actor: Bates

Afterpiece Title: The Virgin Unmask'd

Song: III: song-Dignum [In all subsequent performances this was sung by Williames]

Performances

Mainpiece Title: Artaxerxes

Afterpiece Title: The Englishman in Paris

Cast
Role: Kitteau Actor: Bates

Dance: As17871006

Performances

Mainpiece Title: The Pilgrim

Cast
Role: Drunken Servant Actor: Bates

Afterpiece Title: All the World's a Stage

Dance: End I: a New Dance-Hamoir, Ferrere, the Miss Stageldoirs; End III: The Capricious Lovers, as17870920; End IV: another New Dance-Hamoir, Ferrere, the Miss Stageldoirs

Performances

Mainpiece Title: The Pilgrim

Cast
Role: Drunken Servant Actor: Bates

Afterpiece Title: Comus

Dance: End I: As17870920 End IV: New Dance, as17871026

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Trip Actor: Bates

Afterpiece Title: The Sultan; or, A Peep into the Seraglio

Dance: In afterpiece: Hamoir, the Miss Stageldoirs

Song: III: a song-Williames. [This was sung, as here assigned, in all subsequent performances.

Performances

Mainpiece Title: The Pilgrim

Cast
Role: Drunken Servant Actor: Bates

Afterpiece Title: Comus

Dance: End IV: a New Dance, as17871026

Performances

Mainpiece Title: As You Like It

Cast
Role: Le Beu Actor: Bates

Afterpiece Title: Bon Ton; or, High Life above Stairs

Dance: End I: a New Dance, as17871026

Song: V: song-Mrs Forster

Performances

Mainpiece Title: Henry The Second; Or, The Fall Of Rosamond

Afterpiece Title: Harlequin Junior; or, The Magic Cestus

Cast
Role: Harlequin Actor: Bates

Performances

Mainpiece Title: George Barnwell

Afterpiece Title: Harlequin Junior

Cast
Role: Harlequin Actor: Bates

Song: As17870925

Performances

Mainpiece Title: A Trip To Scarborough

Afterpiece Title: Harlequin Junior

Cast
Role: Harlequin Actor: Bates

Performances

Mainpiece Title: Julia

Afterpiece Title: Harlequin Junior

Cast
Role: Harlequin Actor: Bates

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Harlequin Junior

Cast
Role: Harlequin Actor: Bates

Performances

Mainpiece Title: The School For Scandal

Afterpiece Title: Harlequin Junior

Cast
Role: Harlequin Actor: Bates

Song: III: song-Williames

Performances

Mainpiece Title: Percy

Afterpiece Title: Harlequin Junior

Cast
Role: Harlequin Actor: Bates

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: Harlequin Junior

Cast
Role: Harlequin Actor: Bates

Dance: As17870920

Performances

Mainpiece Title: The Wonder

Afterpiece Title: Harlequin Junior

Cast
Role: Harlequin Actor: Bates

Performances

Mainpiece Title: Douglas

Afterpiece Title: Harlequin Junior

Cast
Role: Harlequin Actor: Bates

Performances

Mainpiece Title: The Way To Keep Him

Afterpiece Title: Harlequin Junior

Cast
Role: Harlequin Actor: Bates