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: The Wife's Relief

Afterpiece Title: Comus

Cast
Role: Brothers Actor: Robson, J. Bates

Performances

Mainpiece Title: The Double Dealer

Afterpiece Title: Three Weeks after Marriage

Cast
Role: Woodley Actor: J. Bates

Dance: End of Act III of mainpiece a New Quadrille, also The Belle of the Village, as17811101; End of Act IV The Devonshire Minuet and a New Rondeau by Holloway and Miss Besford; End of mainpiece, as17811219

Performances

Mainpiece Title: Macbeth

Cast
Role: Malcolm Actor: J. Bates

Afterpiece Title: The Choice of Harlequin

Cast
Role: : Harlequin Actor: W. Bates

Song: As17811217, but added: Davies; omitted: Reinhold, Doyle

Performances

Mainpiece Title: The Beaux Stratagem

Cast
Role: Gibbet Actor: W. Bates

Afterpiece Title: Barnaby Brittle

Cast
Role: Jeremy Actor: W. Bates

Dance: As17811219

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Harlequin Teague

Cast
Role: Humane Scalper Actor: J. Bates

Dance: In Act III of mainpiece a Hornpipe [performer not listed]; In afterpiece, as17820826

Song: In afterpiece The Tobacco Box by Brett and Miss Morris

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: Harlequin Teague

Cast
Role: Humane Scalper Actor: J. Bates

Dance: As17820826

Song: As17820918

Performances

Mainpiece Title: The Agreeable Surprise

Afterpiece Title: Harlequin Teague

Cast
Role: Humane Scalper Actor: J. Bates

Dance: As17820826

Performances

Mainpiece Title: The Count Of Narbonne

Afterpiece Title: The Wishes

Cast
Role: Gardener Actor: Bates
Role: Lord Furious Actor: W. Bates

Performances

Mainpiece Title: The Walloons

Afterpiece Title: The Wishes

Cast
Role: Gardener Actor: Bates
Role: Lord Furious Actor: W. Bates

Performances

Mainpiece Title: Which Is The Man

Cast
Role: Richard Actor: W. Bates

Afterpiece Title: Tom Thumb

Dance: End of mainpiece a new Dance (composed by Harris) Pastoral Sports by Harris, Second, Mrs Ratchford, Miss Matthews

Performances

Mainpiece Title: Zara

Afterpiece Title: The Choice of Harlequin; or, The Indian Chief

Cast
Role: : Harlequin Actor: W. Bates

Performances

Mainpiece Title: King Richard The Third

Cast
Role: Oxford Actor: W. Bates

Afterpiece Title: The Choice of Harlequin

Cast
Role: : Harlequin Actor: W. Bates

Performances

Mainpiece Title: The Duenna

Afterpiece Title: The Positive Man

Cast
Role: Bowsprit Actor: W. Bates
Role: Hulk Actor: Bates

Dance: As17821009

Performances

Mainpiece Title: The Merry Wives Of Windsor

Cast
Role: Bardolph Actor: Bates
Role: Slender Actor: W. Bates

Afterpiece Title: The Choice of Harlequin

Cast
Role: : Harlequin Actor: W. Bates

Performances

Mainpiece Title: The Belle's Stratagem

Cast
Role: Silver Tongue Actor: W. Bates

Afterpiece Title: Barnaby Brittle

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: The Choice of Harlequin

Cast
Role: : Harlequin Actor: W. Bates

Performances

Mainpiece Title: The Count Of Narbonne

Afterpiece Title: The Choice of Harlequin

Cast
Role: : Harlequin Actor: W. Bates

Performances

Mainpiece Title: Which Is The Man

Afterpiece Title: The Positive Man

Cast
Role: Bowsprit Actor: W. Bates
Role: Hulk Actor: Bates

Dance: As17821009

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: The Choice of Harlequin

Cast
Role: : Harlequin Actor: W. Bates

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Choice of Harlequin

Cast
Role: : Harlequin Actor: W. Bates

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Choice of Harlequin

Cast
Role: : Harlequin Actor: W. Bates

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Choice of Harlequin

Cast
Role: : Harlequin Actor: W. Bates

Performances

Mainpiece Title: Macbeth

Afterpiece Title: The Positive Man

Cast
Role: Bowsprit Actor: W. Bates
Role: Hulk Actor: Bates

Song: Mainpiece: Vocal Parts by Reinhold, Doyle, J. Wilson, Darley; Mrs Morton, Miss Morris, Mrs Davenett, Miss Stuart, Miss Willis, Miss Adcock, &c

Performances

Mainpiece Title: The Suspicious Husband

Cast
Role: Buckle Actor: W. Bates

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: The First Part Of King Henry The Fourth

Cast
Role: Francis Actor: W. Bates

Afterpiece Title: Lord Mayor's Day

Dance: End of Act II of mainpiece, as17821009