SELECT * FROM london_stages WHERE eventid IN (39310, 39334, 39338, 39342, 39348, 39351, 39355, 39368, 39374, 39376, 39377, 39385, 39387, 39392, 39393, 39395, 39396, 39401, 39410, 39412, 39414, 39416, 39418, 39420, 39422, 39427, 39428, 39429, 39431, 39432, 39434, 39437, 39441, 39927, 39928, 39932, 39934, 39943, 39945, 39950, 39952, 39955, 39956, 39960, 39961, 39962, 39963, 39964, 39965, 39966, 39967, 39968, 39969, 39970, 39972, 39976, 39978, 39981, 39983, 39985, 39990, 39992, 39994, 39996, 39998, 39999, 40001, 40002, 40003, 40004, 40007, 40009, 40010, 40011, 40013, 40014, 40018, 40022, 40028, 40035, 40036, 40041, 40043, 40045, 40047, 40049, 40050, 40053, 40054, 40056, 40058, 40060, 40062, 40067, 40068, 40097, 40153, 40162, 40207, 40242, 40247, 40251, 40278, 40291, 40296, 40307, 40315, 40319, 40361, 40383, 40386, 40395, 40400, 40407, 40417, 40424, 40430, 40449, 40457, 40458, 40465, 40472, 40473, 40476, 40478, 40479, 40481, 40484, 40487, 40489, 40491, 40494, 40502, 40505, 40507, 40515, 40520, 40526, 40530, 40535, 40536, 40538, 40540, 40543, 40546, 40547, 40548, 40549, 40550, 40551, 40552, 40554, 40555, 40556, 40558, 40559, 40560, 40561, 40562, 40573, 40583, 40588, 40607, 40614, 40617, 40621, 40623, 40635, 40637, 40643, 40657, 40659, 40662, 40664, 40722, 40731, 40735, 40737, 40740, 40742, 40764, 40766, 40774, 40780, 40791, 40800, 40820, 40824, 40827, 40841, 40847, 40861, 40879, 40881, 40888, 40893, 40901, 40909, 40914, 40916, 40924, 40932, 40937, 40971, 40979, 40982, 40984, 40988, 40996, 41001, 41003, 41006, 41008, 41015, 41019, 41020, 41023, 41026, 41027, 41031, 41033, 41035, 41036, 41039, 41049, 41053, 41058, 41062, 41065, 41069, 41073, 41074, 41075, 41076, 41078, 41079, 41080, 41081, 41084, 41086, 41089, 41090, 41091, 41092, 41093, 41094, 41095, 41096, 41097, 41104, 41106, 41108, 41110, 41112, 41113, 41116, 41118, 41129, 41142, 41149, 41151, 41161, 41164, 41168, 41173, 41178, 41193, 41202, 41204, 41208, 41212, 41214, 41216, 41232, 41237, 41240, 41242, 41254, 41263, 41265, 41280, 41282, 41284, 41286, 41289, 41296, 41303, 41308, 41310, 41312, 41314, 41317, 41319, 41324, 41328, 41334, 41343, 41346, 41351, 41353, 41363, 41368, 41378, 41384, 41387, 41389, 41393, 41396, 41398, 41403, 41411, 41440, 41446, 41457, 41464, 41465, 41470, 41475, 41490, 41497, 41502, 41504, 41507, 41509, 41514, 41517, 41519, 41522, 41526, 41528, 41531, 41533, 41536, 41538, 41544, 41548, 41553, 41563, 41568, 41579, 41580, 41585, 41586, 41589, 41592, 41594, 41597, 41600, 41603, 41606, 41609, 41610, 41612, 41615, 41616, 41618, 41620, 41621, 41623, 41626, 41630, 41631, 41634, 41635, 41636, 41637, 41638, 41640, 41641, 41642, 41643, 41648, 41649, 41651, 41664, 41667, 41673, 41675, 41676, 41677, 41679, 41683, 41702, 41706, 41710, 41713, 41722, 41724, 41728, 41730, 41732, 41734, 41736, 41738, 41740, 41744, 41754, 41756, 41758, 41760, 41762, 41764, 41767, 41771, 41773, 41775, 41778, 41780, 41794, 41796, 41799, 41801, 41803, 41806, 41808, 41813, 41815, 41817, 41820, 41822, 41825, 41832, 41835, 41837, 41840, 41842, 41845, 41847, 41850, 41857, 41862, 41867, 41871, 41886, 41892, 41902, 41905, 41915, 41917, 41922, 41925, 41928, 41930, 41933, 41940, 41944, 41953, 41957, 41960, 41962, 41970, 41973, 41975, 41979, 41983, 41986, 41989, 41993, 41997, 42000, 42002, 42013, 42016, 42020, 42036, 42049, 42060, 42062, 42065, 42067, 42075, 42077, 42082, 42085, 42087, 42095, 42097, 42102, 42105, 42113, 42116, 42118, 42121, 42123, 42128, 42133, 42143, 42149, 42164, 42165, 42166, 42275, 42277, 42279, 42281, 42284, 42286, 42290, 42295, 42298, 42305, 42309, 42311, 42313, 42315, 42319, 42321, 42323, 42331, 42339, 42349, 42353, 42358, 42361, 42363, 42366, 42388, 42391, 42402, 42407, 42411, 42414, 42416, 42424, 42426, 42429, 42436, 42449, 42451, 42454, 42457, 42460, 42464, 42471, 42474, 42478, 42488, 42490, 42493, 42500, 42503, 42507, 42512, 42514, 42516, 42517, 42529, 42555, 42560, 42575, 42580, 42615, 42624, 42632, 42641, 42648, 42673, 42676, 42681, 42683, 42686, 42696, 42701, 42706, 42711, 42716, 42718, 42720, 42727, 42730, 42734, 42742, 42744, 42746, 42854, 42859, 42875, 42892, 42897, 42905, 42915, 42923, 42931, 42943, 42945, 42955, 42957, 42964, 42967, 42978, 42996, 43000, 43009, 43028, 43033, 43035, 43039, 43047, 43049, 43053, 43061, 43073, 43076, 43085, 43094, 43103, 43105, 43109, 43112, 43114, 43119, 43121, 43126, 43133, 43140, 43147, 43162, 43166, 43169, 43171, 43179, 43185, 43197, 43199, 43216, 43231, 43236, 43241, 43267, 43282, 43287, 43292, 43294, 43307, 43309, 43314, 43319, 43326, 43327, 43329, 43330, 43332, 43333, 43337, 43339, 43340, 43346, 43350, 43352, 43355, 43371, 43372, 43381, 43407, 43423, 43425, 43427, 43430, 43433, 43435, 43438, 43443, 43447, 43459, 43467, 43477, 43481, 43483, 43493, 43499, 43501, 43505, 43516, 43524, 43526, 43530, 43532, 43538, 43544, 43552, 43556, 43560, 43567, 43569, 43579, 43581, 43586, 43589, 43591, 43593, 43595, 43598, 43603, 43609, 43632, 43637, 43646, 43650, 43652, 43655, 43658, 43667, 43673, 43685, 43692, 43714, 43735, 43742, 43745, 43769, 43778, 43783, 43785, 43794, 43800, 43811, 43817, 43823, 43828, 43846, 43853, 43855, 43862, 43865, 43867, 43875, 43882, 43885, 43895, 43904, 43912, 43913, 43914, 43919, 43927, 43945, 43946, 43956, 43957, 43968, 43977, 43981, 43982, 43987, 44008, 44011, 44013, 44023, 44028, 44034, 44040, 44065, 44069, 44073, 44079, 44118, 44122, 44124, 44128, 44130, 44132, 44136, 44148, 44152, 44156, 44158, 44160, 44162, 44169, 44173, 44183, 44185, 44189, 44191, 44193, 44195, 44199, 44201, 44203, 44205, 44209, 44211, 44213, 44215, 44217, 44220, 44222, 44224, 44226, 44229, 44234, 44236, 44241, 44243, 44250, 44257, 44262, 44274, 44278, 44280, 44285, 44292, 44310, 44314, 44327, 44340, 44357, 44371, 44376, 44381, 44386, 44388, 44403, 44406, 44411, 44416, 44420, 44431, 44433, 44436, 44441, 44448, 44451, 44453, 44461, 44466, 44471, 44475, 44481, 44484, 44486, 44492, 44495, 44508, 44510, 44525, 44527, 44536, 44539, 44541, 44544, 44545, 44546, 44550, 44552, 44553, 44562, 44568, 44571, 44572, 44574, 44576, 44581, 44584, 44585, 44587, 44588, 44596, 44598, 44600, 44606, 44611, 44614, 44617, 44626, 44627, 44629, 44631, 44633, 44637, 44640, 44642, 44651, 44653, 44661, 44665, 44669, 44675, 44681, 44683, 44685, 44687, 44689, 44693, 44697, 44699, 44705, 44707, 44708, 44709, 44710, 44711, 44730, 44732, 44736, 44739, 44745, 44754, 44759, 44761, 44763, 44765, 44773, 44775, 44788, 44795, 44802, 44809, 44812, 44816, 44821, 44823, 44833, 44843, 44846, 44848, 44856, 44859, 44862, 44870, 44873, 44879, 44883, 44896, 44906, 44910, 44912, 44924, 44933, 44951, 44954, 44960, 44963, 44965, 44970, 44977, 44982, 44988, 44994, 45000, 45003, 45006, 45010, 45026, 45029, 45034, 45040, 45045, 45050, 45051, 45056, 45057, 45063, 45065, 45067, 45070, 45074, 45075, 45076, 45078, 45079, 45081, 45082, 45102, 45108, 45109, 45111, 45112, 45113, 45114, 45138, 45148, 45160, 45161, 45163, 45168, 45173, 45187, 45195, 45197, 45203, 45205, 45207, 45209, 45211, 45215, 45217, 45221, 45225, 45229, 45235, 45239, 45243, 45247, 45249, 45277, 45286, 45294, 45299, 45304, 45309, 45313, 45337, 45346, 45358, 45371, 45422, 45441, 45443, 45453, 45455, 45468, 45479, 45484, 45494, 45499, 45501, 45508, 45514, 45516, 45525, 45528, 45530, 45536, 45541, 45551, 45556, 45558, 45566, 45576, 45583, 45592, 45594, 45602, 45608, 45611, 45622, 45636, 45649, 45650, 45651, 45654, 45659, 45661, 45662, 45663, 45665, 45667, 45669, 45671, 45672, 45676, 45683, 45691, 45701, 45703, 45705, 45713, 45718, 45720, 45730, 45746, 45747, 45751, 45755, 45760, 45766, 45770, 45778, 45780, 45786, 45802, 45804, 45810, 45814, 45816, 45822, 45828, 45839, 45849, 45863, 45870, 45891, 45898, 45908, 45938, 45943, 45950, 45983, 46010, 46030, 46035, 46037, 46044, 46049, 46054, 46067, 46089, 46097, 46099, 46102, 46105, 46114, 46120, 46126, 46272, 46276, 46278, 46282, 46283, 46285, 46290, 46291, 46293, 46296, 46298, 46302, 46308, 46312, 46314, 46316, 46322, 46326, 46328, 46330, 46335, 46337, 46342, 46344, 46348, 46352, 46364, 46366, 46374, 46386, 46390, 46402, 46404, 46406, 46410, 46412, 46418, 46422, 46430, 46435, 46440, 46445, 46454, 46463, 46468, 46473, 46480, 46485, 46489, 46496, 46502, 46504, 46508, 46510, 46521, 46523, 46528, 46537, 46556, 46611, 46613, 46623, 46631, 46633, 46646, 46651, 46660, 46665, 46667, 46670, 46671, 46675, 46680, 46682, 46685, 46687, 46690, 46694, 46696, 46701, 46705, 46710, 46717, 46835, 46851, 46853, 46859, 46860, 46864, 46880, 46882, 46886, 46888, 46892, 46896, 46898, 46904, 46906, 46910, 46916, 46920, 46928, 46934, 46940, 46946, 46952, 46958, 46960, 46964, 46970, 46978, 46988, 47010, 47028, 47032, 47036, 47048, 47056, 47062, 47072, 47075, 47078, 47085, 47092, 47100, 47107, 47116, 47118, 47155, 47172, 47185, 47191, 47203, 47208, 47211, 47219, 47225, 47230, 47237, 47241, 47243, 47246, 47252, 47254, 47263, 47269, 47272, 47288, 47294, 47448, 47452, 47455, 47457, 47461, 47463, 47465, 47473, 47480, 47483, 47494, 47498, 47504, 47508, 47516, 47520, 47522, 47524, 47532, 47534, 47538, 47542, 47546, 47550, 47554, 47556, 47565, 47567, 47569, 47571, 47574, 47576, 47579, 47581, 47583, 47585, 47588, 47590, 47592, 47620, 47632, 47642, 47644, 47679, 47728, 47738, 47758, 47768, 47781, 47783, 47786, 47788, 47791, 47804, 47807, 47812, 47822, 47829, 47832, 47837, 47842, 47844, 47847, 47849, 47852, 47854, 47857, 47862, 47864, 47866, 47871, 47878, 47893, 47899, 47902, 47907, 47992, 47998, 48001, 48007, 48021, 48022, 48025, 48030, 48031, 48034, 48037, 48040, 48044, 48046, 48048, 48050, 48058, 48067, 48073, 48075, 48079, 48085, 48094, 48104, 48106, 48108, 48130, 48141, 48151, 48165, 48167, 48171, 48175, 48177, 48179, 48201, 48228, 48235, 48284, 48310, 48312, 48314, 48326, 48328, 48333, 48338, 48346, 48351, 48353, 48355, 48365, 48367, 48381, 48383, 48388, 48406, 48422, 48431, 48607, 48617, 48627, 48649, 48671, 48691, 48711, 48751, 48994, 49008, 49013, 49015, 49017, 49022, 49027, 49032, 49037, 49040, 49047, 49052, 49055, 49062, 49068, 49073, 49080, 49082, 49089, 49091, 49096, 49103, 49109, 49111, 49114, 49117, 49119, 49247, 49251, 49259, 49271, 49273, 49275, 49283, 49285, 49287, 49295, 49297, 49299, 49309, 49311, 49323, 49325, 49327, 49349, 49358, 49363, 49367, 49377, 49379, 49381, 49386, 49391, 49393, 49395, 49400, 49403, 49407, 49412, 49415, 49424, 49426, 49431, 49433, 49435, 49438, 49440, 49453, 49461, 49464, 49471, 49477, 49484, 49492, 49499, 49506, 49512, 49516, 49519, 49524, 49526, 49528, 49533, 49542, 49549, 49555, 49557, 49564, 49572, 49579, 49588, 49593, 49596, 49598, 49603, 49615, 49619, 49626, 49629, 49641, 49643, 49648, 49758, 49763, 49767, 49771, 49773, 49781, 49784, 49786, 49789, 49792, 49795, 49798, 49804, 49808, 49810, 49818, 49826, 49834, 49840, 49846, 49850, 49858, 49864, 49870, 49876, 49882, 49896, 49906, 49916, 49923, 49930, 49934, 49944, 49948, 49953, 49956, 49962, 49967, 49970, 49972, 49977, 49979, 49984, 49988, 49991, 49993, 49997, 50005, 50009, 50012, 50018, 50022, 50028, 50043, 50051, 50066, 50074, 50076, 50081, 50083, 50088, 50091, 50110, 50127, 50142, 50145, 50147, 50162, 50178, 50183, 50185, 50197, 50204, 50207, 50212, 50225, 50341, 50344, 50349, 50354, 50355, 50357, 50362, 50363, 50365, 50381, 50386, 50390, 50397, 50403, 50407, 50413, 50415, 50421, 50425, 50439, 50443, 50448, 50453, 50457, 50465, 50467, 50469, 50471, 50476, 50481, 50493, 50497, 50502, 50507, 50516, 50521, 50525, 50530, 50533, 50535, 50545, 50548, 50553, 50561, 50563, 50567, 50572, 50575, 50577, 50580, 50590, 50596, 50604, 50606, 50610, 50615, 50622, 50637, 50643, 50646, 50651, 50655, 50667, 50670, 50673, 50675, 50679, 50683, 50746, 50791) 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 Spanish Barber; Or, The Fruitless Precaution

Cast
Role: Rosina Actor: Miss Farren
Role: Epilogue Actor: Miss Farren.

Afterpiece Title: Thomasand Sally

Dance: End: Dance-. [This was included in all subsequent performances.

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss Farren

Afterpiece Title: The Recruiting Serjeant

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss Farren

Afterpiece Title: Lilliput

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss Farren

Afterpiece Title: Midas

Cast
Role: Nysa Actor: Miss Twist.

Performances

Mainpiece Title: King Henry Viii

Cast
Role: Patience Actor: Miss Twist

Afterpiece Title: The Fairy Tale

Cast
Role: Oberon Actor: Miss Morris
Role: Fairies Actor: Master Harrison, Miss Twist
Role: Titania Actor: Miss P. Farren

Dance: End: Dance-

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss Farren

Afterpiece Title: Midas

Cast
Role: Nysa Actor: Miss Twist.

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss Farren

Afterpiece Title: Midas

Cast
Role: Nysa Actor: Miss Twist.

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss Farren

Afterpiece Title: The Waterman

Performances

Mainpiece Title: The Spanish Barber; Or, The Fruitless Precaution

Cast
Role: Rosina Actor: Miss Farren
Role: Epilogue Actor: Miss Farren.

Afterpiece Title: The Waterman; or, The First of August

Dance: End I: The Merry Lasses, as17780518; End: Provencalle Dance, as17780518

Song: Mainpiece: some additional songs-

Music: Mainpiece: With a new Fandango Overture-

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss Farren

Afterpiece Title: Midas

Cast
Role: Nysa Actor: Miss Twist.

Dance: End II: The Merry Lasses, as17780518; End afterpiece: Provencalle Dance, as17780518

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss Farren

Afterpiece Title: Midas

Cast
Role: Nysa Actor: Miss Twist.

Dance: End II: Provencalle Dance, as17780518; End afterpiece: The Merry Lasses, as17780529

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss Farren

Afterpiece Title: Midas

Cast
Role: Nysa Actor: Miss Twist.

Dance: As17780616

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss Farren

Afterpiece Title: Midas

Cast
Role: Nysa Actor: Miss Twist.

Dance: End: The Gardeners, as17780618

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss Farren

Afterpiece Title: The Waterman

Cast
Role: Wilhelmina Actor: Miss Harper

Dance: End: Tambourine Dance-Master and Miss Byrn

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss Farren

Afterpiece Title: The Waterman

Cast
Role: Wilhelmina Actor: Miss Harper

Dance: As17780624

Performances

Mainpiece Title: She Stoops To Conquer

Afterpiece Title: Buxom Joan

Cast
Role: Buxom Joan Actor: Miss Twist.

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss Farren

Afterpiece Title: The Waterman

Cast
Role: Wilhelmina Actor: Miss Harper

Dance: As17780623

Performances

Mainpiece Title: She Stoops To Conquer

Afterpiece Title: Buxom Joan

Cast
Role: Buxom Joan Actor: Miss Twist.

Performances

Mainpiece Title: The Suicide

Cast
Role: Peggy Actor: Miss Hale
Role: Nancy Actor: Miss Farren
Role: Epilogue Actor: Miss Farren.

Afterpiece Title: Miss in her Teens

Performances

Mainpiece Title: The Suicide

Cast
Role: Peggy Actor: Miss Hale
Role: Nancy Actor: Miss Farren

Afterpiece Title: Polly Honeycombe

Cast
Role: Mrs Honeycombe Actor: Miss Platt

Performances

Mainpiece Title: The Suicide

Cast
Role: Peggy Actor: Miss Hale
Role: Nancy Actor: Miss Farren

Afterpiece Title: The Waterman

Cast
Role: Wilhelmina Actor: Miss Harper

Dance: As17780624

Performances

Mainpiece Title: The Suicide

Cast
Role: Peggy Actor: Miss Hale
Role: Nancy Actor: Miss Farren

Afterpiece Title: Midas

Cast
Role: Nysa Actor: Miss Twist.

Dance: As17780624

Performances

Mainpiece Title: The Suicide

Cast
Role: Peggy Actor: Miss Hale
Role: Nancy Actor: Miss Farren

Afterpiece Title: Midas

Cast
Role: Nysa Actor: Miss Twist.

Dance: As17780624

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss Farren

Afterpiece Title: Buxom Joan

Cast
Role: Buxom Joan Actor: Miss Twist.

Dance: As17780623

Performances

Mainpiece Title: The Suicide

Cast
Role: Peggy Actor: Miss Hale
Role: Nancy Actor: Miss Farren

Afterpiece Title: The Portrait

Cast
Role: Isabel Actor: Miss Twist.

Dance: As17780624