SELECT * FROM london_stages WHERE eventid IN (270, 450, 501, 619, 904, 946, 964, 975, 1159, 1235, 1237, 1430, 1475, 1507, 1728, 1777, 2177, 2606, 2607, 4526, 4582, 4619, 5223, 5425, 5657, 6509, 6511, 6515, 6964, 7045, 7568, 7665, 7853, 8196, 8442, 8444, 8446, 8449, 8451, 8488, 8542, 8676, 9565, 9648, 9841, 10376, 10378, 10379, 10854, 11337, 12477, 12480, 12485, 12562, 12762, 12883, 13132, 13135, 13139, 13142, 13146, 13150, 13154, 13158, 13162, 13165, 13169, 13173, 13754, 14258, 14267, 14431, 14486, 14649, 14889, 15519, 15527, 15915, 15919, 15923, 15927, 15931, 15938, 15990, 16012, 16025, 16129, 16461, 16550, 16635, 17005, 17081, 17495, 18163, 18503, 18515, 18519, 18673, 18686, 18723, 19364, 19370, 19372, 19827, 19830, 19842, 20079, 20276, 20684, 20704, 21846, 22622, 22626, 22629, 22633, 22637, 22640, 22645, 22648, 22651, 22674, 22759, 22875, 22878, 22881, 22883, 22886, 22887, 22889, 22966, 22969, 23100, 23103, 23110, 23113, 23142, 23302, 23599, 23605, 23608, 23660, 23707, 24005, 24008, 24010, 24177, 24299, 24301, 24302, 24303, 24304, 24305, 24306, 24308, 24309, 24310, 24311, 24312, 24313, 24315, 24316, 24819, 24827, 24828, 24829, 24830, 24831, 24832, 24833, 24834, 24835, 24836, 24837, 24838, 24839, 24840, 24841, 24842, 24843, 24844, 24845, 24846, 24847, 24848, 24849, 25053, 25055, 25061, 25063, 25088, 25131, 25275, 26592, 27913, 27932, 27945, 27981, 28120, 28122, 28123, 28588, 28589, 28590, 28591, 28592, 28593, 28594, 28595, 28596, 28662, 28664, 28669, 28675, 28683, 28688, 28693, 28696, 28698, 28702, 28704, 28707, 28712, 28717, 28726, 28731, 28754, 28782, 28794, 28796, 28799, 28802, 28841, 28885, 28956, 29014, 29195, 29244, 29315, 29431, 29496, 29934, 29936, 29938, 29941, 29943, 29945, 29947, 29949, 29952, 29954, 29962, 30381, 30410, 30484, 30566, 30660, 31109, 31179, 31395, 31411, 31673, 31725, 31907, 31953, 32704, 32925, 32929, 32934, 32938, 32943, 32995, 33000, 33004, 33009, 33013, 33020, 33100, 33129, 33166, 33193, 33617, 33664, 34197, 34688, 34696, 34772, 34779, 34840, 34841, 34843, 34844, 34846, 34848, 34851, 34855, 34857, 34858, 34913, 34989, 35062, 35274, 35357, 35595, 35607, 35610, 35612, 35617, 35619, 35624, 35629, 35633, 35638, 35683, 35889, 35989, 36219, 36257, 36419, 36434, 36546, 37076, 37566, 37941, 38045, 38047, 38050, 38053, 38056, 38060, 38062, 38065, 38070, 38073, 38083, 38088, 38091, 38143, 38197, 38219, 38371, 38408, 38411, 38413, 38418, 38421, 38423, 38426, 38427, 38428, 38432, 38435, 38437, 38440, 38442, 38446, 38449, 38451, 38454, 38456, 38460, 38463, 38468, 38469, 38470, 38474, 38491, 38493, 38494, 38495, 38499, 38501, 38503, 38506, 38508, 38512, 38517, 38522, 38526, 38529, 38531, 38537, 38541, 38544, 38548, 38552, 38557, 38562, 38566, 38570, 38571, 38574, 38575, 38576, 38578, 38580, 38583, 38584, 38585, 38586, 38588, 38594, 38596, 38598, 38603, 38604, 38609, 38611, 38613, 38620, 38624, 38625, 38628, 38630, 38635, 38639, 38644, 38650, 38659, 38664, 38668, 38674, 38681, 38683, 38684, 38693, 38694, 38695, 38707, 38712, 38727, 38742, 38756, 38760, 38772, 38775, 38779, 38786, 38791, 38866, 38873, 38883, 38888, 38891, 38935, 38943, 38949, 38951, 38954, 38956, 38957, 38966, 38971, 38974, 38991, 39004, 39008, 39015, 39018, 39025, 39027, 39029, 39031, 39038, 39039, 39041, 39048, 39049, 39054, 39055, 39057, 39065, 39070, 39074, 39077, 39078, 39084, 39088, 39095, 39096, 39108, 39115, 39123, 39124, 39149, 39177, 39210, 39211, 39223, 39229, 39234, 39237, 39262, 39277, 39280, 39291, 39313, 39316, 39330, 39337, 39426, 39432, 39445, 39490, 39503, 39514, 39520, 39523, 39527, 39600, 39610, 39621, 39622, 39629, 39635, 39638, 39647, 39664, 39674, 39688, 39700, 39712, 39732, 39744, 39760, 39782, 39813, 39829, 39837, 39875, 39876, 39891, 39899, 39937, 39947, 39953, 39957, 39986, 39995, 40041, 40044, 40055, 40065, 40070, 40087, 40092, 40093, 40099, 40115, 40132, 40151, 40176, 40214, 40238, 40250, 40276, 40289, 40374, 40420, 40421, 40433, 40439, 40442, 40454, 40456, 40464, 40470, 40477, 40485, 40541, 40566, 40572, 40578, 40596, 40606, 40610, 40622, 40624, 40627, 40628, 40632, 40635, 40636, 40653, 40677, 40681, 40708, 40718, 40723, 40735, 40827, 40858, 40873, 40907, 40914, 40935, 40960, 40979, 41117, 41121, 41125, 41152, 41166, 41176, 41207, 41245, 41251, 41283, 41294, 41402, 41489, 41491, 41527, 41528, 41652, 41659, 41661, 41697, 41709, 41729, 41738, 41763, 41767, 41774, 41816, 41828, 41841, 41871, 41931, 41949, 41976, 42042, 42046, 42098, 42105, 42132, 42300, 42310, 42334, 42339, 42340, 42343, 42345, 42348, 42350, 42352, 42354, 42357, 42359, 42362, 42364, 42367, 42369, 42374, 42379, 42381, 42383, 42408, 42412, 42420, 42425, 42435, 42442, 42452, 42455, 42463, 42470, 42472, 42481, 42486, 42501, 42510, 42516, 42541, 42551, 42556, 42561, 42607, 42620, 42668, 42689, 42712, 42727, 42739, 42743, 42810, 42811, 42812, 42814, 42817, 42818, 42820, 42822, 42823, 42826, 42828, 42832, 42839, 42842, 42844, 42846, 42848, 42850, 42853, 42893, 42896, 42897, 42902, 42906, 42907, 42920, 42924, 42926, 42928, 42934, 42940, 42942, 42946, 42952, 42954, 42962, 42965, 42968, 43003, 43016, 43024, 43062, 43069, 43089, 43095, 43110, 43343, 43349, 43356, 43361, 43366, 43378, 43387, 43393, 43422, 43431, 43457, 43492, 43501, 43518, 43612, 43628, 43648, 43652, 43677, 43764, 43770, 43781, 43789, 43818, 43829, 43830, 43837, 43878, 43888, 43969, 44027, 44053, 44083, 44090, 44114, 44153, 44167, 44170, 44172, 44174, 44176, 44178, 44180, 44182, 44184, 44186, 44188, 44190, 44194, 44196, 44198, 44200, 44202, 44204, 44206, 44208, 44210, 44212, 44214, 44216, 44218, 44221, 44223, 44225, 44227, 44239, 44258, 44272, 44279, 44298, 44299, 44309, 44348, 44354, 44367, 44374, 44384, 44397, 44399, 44412, 44429, 44437, 44469, 44529, 44569, 44608, 44632, 44664, 44674, 44676, 44677, 44684, 44716, 44742, 44871, 44887, 44931, 44941, 44978, 44980, 45024, 45025, 45055, 45060, 45077, 45083, 45090, 45094, 45103, 45109, 45218, 45280, 45302, 45316, 45324, 45335, 45369, 45407, 45413, 45417, 45421, 45434, 45436, 45438, 45442, 45447, 45449, 45451, 45452, 45464, 45469, 45482, 45485, 45507, 45511, 45517, 45526, 45534, 45539, 45542, 45554, 45557, 45559, 45567, 45582, 45589, 45591, 45628, 45640, 45660, 45709, 45744, 45788, 45794, 45796, 45798, 45800, 45802, 45806, 45808, 45812, 45820, 45832, 45841, 45853, 45864, 45865, 45873, 45889, 45893, 45910, 45917, 45931, 45950, 45983, 45988, 46019, 46020, 46062, 46099, 46145, 46163, 46195, 46203, 46243, 46273, 46293, 46298, 46299, 46302, 46312, 46319, 46322, 46335, 46348, 46349, 46406, 46418, 46425, 46440, 46454, 46457, 46468, 46486, 46499, 46508, 46521, 46534, 46539, 46547, 46548, 46553, 46562, 46575, 46576, 46581, 46591, 46597, 46604, 46611, 46631, 46633, 46712, 46851, 46854, 46857, 46872, 46873, 46878, 46880, 46890, 46894, 46900, 46908, 46918, 46920, 46924, 46932, 46970, 47004, 47054, 47061, 47065, 47066, 47071, 47076, 47080, 47083, 47097, 47104, 47113, 47127, 47132, 47167, 47178, 47197, 47206, 47223, 47225, 47226, 47258, 47279, 47288, 47290, 47296, 47320, 47339, 47398, 47400, 47443, 47445, 47451, 47460, 47467, 47471, 47481, 47483, 47491, 47492, 47494, 47498, 47504, 47532, 47544, 47565, 47567, 47571, 47576, 47577, 47588, 47591, 47594, 47622, 47646, 47677, 47682, 47692, 47703, 47713, 47718, 47743, 47763, 47766, 47778, 47788, 47799, 47817, 47844, 47859, 47865, 47877, 47912, 47927, 47933, 47952, 47957, 47965, 47969, 47970, 47972, 47976, 47977, 47980, 47982, 47985, 47986, 47988, 47990, 47991, 47997, 48020, 48059, 48120, 48129, 48131, 48151, 48164, 48224, 48270, 48274, 48279, 48284, 48321, 48333, 48351, 48370, 48376, 48390, 48394, 48408, 48411, 48432, 48440, 48454, 48543, 48615, 48635, 48637, 48639, 48660, 48673, 48675, 48705, 48755, 48760, 48771, 48782, 48793, 48860, 48999, 49025, 49088, 49203, 49220, 49224, 49238, 49242, 49246, 49248, 49250, 49254, 49260, 49306, 49362, 49392, 49408, 49489, 49552, 49574, 49606, 49646, 49659, 49732, 49737, 49764, 49820, 49894, 49899, 49918, 49946, 50022, 50112, 50158, 50184, 50214, 50290, 50307, 50327, 50371, 50401, 50443, 50456, 50511, 50604, 50611, 50615, 50646, 50727, 50753, 50756, 50777, 50792, 50797, 50806, 50823, 50824, 50825, 50827, 50830, 50835, 50845, 50848, 50849, 50853, 50858, 50862, 50864, 50867, 50869, 50870, 50876, 50877, 50879, 50885, 50890, 50893, 50895, 50896, 50901, 50902, 50903, 50910, 51032, 51060, 51159, 51161, 51164, 51166, 51168, 51170, 51181, 51185, 51187, 51191, 51194, 51197, 51199, 51206, 51209, 51211, 51215, 51218, 51237, 51241, 51257, 51266, 51268, 51273, 51304, 51308, 51312, 51316, 51338, 51341, 51345, 51351, 51356, 51364, 51380, 51388, 51423, 51438, 51465, 51470, 51557, 51561, 51564, 51565, 51569, 51572, 51577, 51581, 51591, 51624, 51629, 51634, 51643, 51648, 51653, 51655, 51664, 51667, 51676, 51701, 51759, 51794, 51797, 51811, 51833, 51836, 51841, 51843, 51860, 51871, 51882, 51900, 51907, 52034, 52133, 52157, 52370, 52371, 52446, 52513, 52583) 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 Fatal Secret

Cast
Role: Ferdinand Actor: Ryan
Role: Cardinal of Arragon Actor: Walker

Performances

Mainpiece Title: The Fatal Secret

Cast
Role: Ferdinand Actor: Ryan
Role: Cardinal of Arragon Actor: Walker

Performances

Mainpiece Title: The Tempest Or The Enchanted Island

Cast
Role: Ferdinand Actor: Marshal

Afterpiece Title: The Harlots Progress

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Marshal

Afterpiece Title: Harlots Process

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Marshal

Afterpiece Title: The Harlots Progress

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Marshal

Afterpiece Title: The Harlots Progress

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Marshal

Afterpiece Title: The Harlots Progress

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Marshal

Afterpiece Title: The Harlots Progress

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Marshal

Afterpiece Title: The Mock Doctor

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Marshal

Afterpiece Title: Cephalus and Procris

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Marshal

Afterpiece Title: The Harlots Progress

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Marshal

Afterpiece Title: The Intriguing Chambermaid

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: W. Mills

Afterpiece Title: Cephalus and Procris

Performances

Mainpiece Title: Fair Rosamond

Cast
Role: Cardinal Aquinas Actor: Winstone
Role: Cardinal Columbus Actor: Ridout

Afterpiece Title: The Impostor or The Biter Bit With the Comical Humours of Vizard the Biter Mixum the Vintner and his Drawer Balderdash

Dance: I: Two Punches by Tench and Janno. II: The Constant Lovers. End of Droll: Le Badinage Cbampetre. Tumbling by Mynheer Vanderhoff, Mons de Voltore, Mons de Broc, Mons Janno

Performances

Mainpiece Title: The Tempest Or The Inchanted Island

Cast
Role: Ferdinand Actor: W. Mills

Afterpiece Title: The Harlots Progress

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: W. Mills

Afterpiece Title: The Devil to Pay

Dance: By Nivelon, Essex, Lalauze, Le Brun, Mrs Walter, Pelling, Davenport, Mrs Pelling, Miss Mann: I: Dutchman and his Frow. III: Pierots. V: Revellers

Performances

Mainpiece Title: Abra Mule

Afterpiece Title: Macheath 1n the Shades or Bayes at Parnassus

Cast
Role: Cardinal Wolsey Actor: Houghton

Dance: Tambourine by Miss Rogers. Scot's Dance by Glover, Miss Rogers, Le Sac, Miss Baston, Delagarde, Mrs De L'Orme

Performances

Mainpiece Title: The Tempest Or The Enchanted Island

Cast
Role: Ferdinand Actor: W. Mills

Afterpiece Title: Harlequin Restord

Music: As17351018

Performances

Mainpiece Title: Fair Rosamond Representing Her Amours With King Henry And Her Being Poisoned By Queen Eleanor In Woodstock Bower

Cast
Role: Cardinal Aquinas Actor: Wallis
Role: Cardinal Columbus Actor: Bambridge

Afterpiece Title: The Modern Pimp or The Doctor Deceivd With the Comical Humours of Crack the Pimp Dr Grey Goose and Sir Nehemiah Nestle Cock

Dance: I: Two Pierrots by Livier and Mlle Delorme. II: Wooden Shoe Dance by Livier and Janno. End of Afterpiece: Grand Peasant Dance by Livier, Janno, Mlle Delorme, Mrs Woodward

Performances

Mainpiece Title: The Tempest Or The Inchanted Island

Cast
Role: Ferdinand Actor: Este

Afterpiece Title: The King and the Miller of Mansfield

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Este

Afterpiece Title: The King and the Miller of Mansfield

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Este

Afterpiece Title: The King and the Miller of Mansfield

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Este

Afterpiece Title: Harlequin Restord

Dance: In II: Dance of Winds-Muilment, Thurmond; In IV: Comic Dance of Fantastical Spirits (in Grostesque Characters)-Thurmond, Villeneuve, Levier, Pelling; In V: Waterman's Dance-Harper; with a Grand ballet of Sailors-Mlle Roland

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Este

Afterpiece Title: Harlequin Restord

Dance: As17370411

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Este

Afterpiece Title: The King and the Miller of Mansfield

Dance: As17370411