SELECT * FROM london_stages WHERE eventid IN (3544, 4602, 4813, 6069, 9353, 11217, 12035, 12476, 12478, 12481, 12483, 12487, 12489, 12491, 12493, 12500, 12502, 12506, 12512, 12521, 12527, 12546, 12781, 12783, 12815, 12820, 12879, 12885, 13247, 13374, 13399, 13410, 13556, 13559, 13565, 13570, 14155, 14175, 14233, 14329, 14774, 14923, 14942, 14948, 15001, 15005, 15011, 15097, 15103, 16515, 16534, 16537, 16781, 16785, 16788, 16792, 16795, 16818, 17001, 17111, 17143, 17208, 17413, 17547, 17911, 17942, 17946, 17947, 17953, 18038, 18068, 18086, 18230, 18404, 18482, 18608, 18729, 18870, 18872, 19162, 19175, 19187, 19205, 19282, 19284, 19286, 19287, 19289, 19290, 19292, 19294, 19297, 19299, 19303, 19305, 19307, 19309, 19311, 19313, 19315, 19318, 19320, 19322, 19324, 19326, 19328, 19332, 19356, 19358, 19368, 19374, 19376, 19377, 19379, 19383, 19455, 19457, 19464, 19486, 19652, 19654, 19689, 19695, 19800, 19861, 20159, 20160, 20163, 20166, 20205, 20217, 20227, 20233, 20343, 20375, 20381, 20679, 20827, 20830, 20834, 20837, 20840, 20843, 20847, 20850, 20853, 20856, 20859, 20862, 20869, 20877, 20897, 20923, 20936, 21131, 21389, 21468, 21594, 21637, 21640, 21649, 21653, 21655, 21713, 21931, 21970, 22033, 22090, 22177, 22261, 22378, 22380, 22383, 22453, 22458, 22464, 22467, 22489, 22499, 22502, 22508, 22514, 22521, 23067, 23079, 23124, 23551, 23555, 23580, 23589, 23595, 23626, 23667, 23670, 23716, 23720, 23730, 23767, 23836, 23846, 24034, 24149, 24350, 24373, 24392, 24472, 24504, 24571, 24693, 24908, 24954, 25007, 25050, 25097, 25217, 25333, 25380, 25460, 25471, 25473, 25475, 25487, 25544, 25978, 25981, 26033, 26037, 26042, 26047, 26050, 26056, 26126, 26128, 26134, 26136, 26145, 26147, 26149, 26171, 26176, 26181, 26183, 26201, 26216, 26228, 26299, 26309, 26339, 26342, 26377, 26529, 26564, 26600, 26609, 26622, 26644, 26650, 26665, 26750, 26773, 26783, 26813, 26907, 26913, 26916, 26921, 26931, 26935, 27072, 27075, 27081, 27096, 27156, 27205, 27258, 27304, 27316, 27333, 27374, 27395, 27594, 27620, 27627, 27689, 27693, 27699, 27713, 27733, 27745, 27760, 27762, 27790, 27805, 27828, 27858, 27873, 27906, 27919, 27941, 27950, 28036, 28073, 28081, 28127, 28177, 28186, 28230, 28232, 28274, 28309, 28367, 28370, 28376, 28381, 28385, 28386, 28391, 28395, 28400, 28406, 28419, 28428, 28437, 28462, 28492, 28525, 28614, 28626, 28655, 28659, 28667, 28700, 28708, 28760, 28811, 28816, 28855, 28894, 28951, 29012, 29049, 29162, 29208, 29214, 29220, 29238, 29247, 29263, 29286, 29305, 29345, 29355, 29413, 29521, 29523, 29530, 29594, 29724, 29884, 29908, 30318, 30503, 30587, 30622, 30629, 30807, 30835, 30846, 30861, 30894, 30899, 30980, 31006, 31036, 31159, 31177, 31192, 31235, 31242, 31253, 31273, 31336, 31351, 31379, 31407, 31497, 31834, 31864, 32020, 32206, 32255, 32269, 32324, 32816, 33387, 33391, 33410, 33415, 33417, 33424, 33456, 33466, 33470, 33657, 33701, 33763, 33764, 33765, 33766, 33768, 33774, 34000, 34044, 34258, 34261, 34303, 34306, 34311, 34327, 34364, 34373, 34382, 34502, 34505, 34507, 34704, 34735, 34828, 34836, 34852, 34853, 34861, 34863, 34865, 34867, 34868, 34869, 34873, 34879, 34881, 34883, 34924, 35015, 35042, 35066, 35370, 35385, 35536, 35563, 35567, 35576, 35588, 35627, 35668, 35798, 35834, 35845, 35869, 35892, 35901, 35977, 35979, 35986, 36004, 36014, 36035, 36066, 36072, 36093, 36103, 36398, 36406, 36546, 36570, 36579, 36583, 36591, 36603, 36605, 36623, 36626, 36631, 36726, 36754, 36892, 36939, 37031, 37034, 37085, 37104, 37114, 37131, 37133, 37157, 37160, 37162, 37163, 37165, 37167, 37168, 37170, 37172, 37173, 37177, 37178, 37179, 37180, 37183, 37186, 37188, 37190, 37193, 37199, 37201, 37203, 37204, 37232, 37240, 37313, 37532, 37580, 37588, 37593, 37614, 37644, 37652, 37688, 37693, 37697, 37699, 37702, 37708, 37710, 37719, 37722, 37729, 37736, 37740, 37741, 37743, 37745, 37747, 37750, 37752, 37753, 37755, 37757, 37761, 37764, 37767, 37769, 37771, 37772, 37773, 37844, 37861, 37866, 37869, 37938, 38137, 38170, 38178, 38195, 38206, 38212, 38218, 38235, 38243, 38246, 38260, 38268, 38274, 38278, 38283, 38285, 38288, 38296, 38303, 38309, 38328, 38356, 38386, 38423, 38426, 38495, 38538, 38625, 38682, 38700, 38711, 38714, 38743, 38754, 38755, 38762, 38765, 38780, 38784, 38801, 38807, 38812, 38813, 38814, 38818, 38821, 38823, 38825, 38828, 38829, 38833, 38846, 38847, 38849, 38850, 38851, 38852, 38858, 38868, 38871, 38879, 38886, 38894, 38896, 38942, 38958, 38962, 38965, 38967, 38972, 38979, 38984, 38994, 39013, 39090, 39099, 39135, 39297, 39306, 39323, 39331, 39341, 39375, 39383, 39389, 39399, 39425, 39430, 39435, 39438, 39441, 39475, 39505, 39530, 39544, 39569, 39592, 39634, 39663, 39697, 39837, 39861, 39883, 39888, 39927, 39945, 39950, 39955, 39960, 39961, 39962, 39963, 39964, 39966, 39968, 39970, 39972, 39976, 39978, 39981, 39985, 39990, 39998, 40001, 40009, 40011, 40013, 40014, 40030, 40051, 40052, 40108, 40137, 40335, 40340, 40345, 40353, 40355, 40360, 40372, 40400, 40413, 40417, 40420, 40430, 40458, 40472, 40476, 40478, 40484, 40491, 40505, 40515, 40530, 40535, 40540, 40546, 40562, 40566, 40774, 40780, 40821, 40947, 41381, 41476, 41485, 41491, 41494, 41496, 41500, 41503, 41505, 41508, 41510, 41513, 41518, 41527, 41529, 41532, 41534, 41542, 41544, 41547, 41559, 41562, 41564, 41569, 41582, 41588, 41595, 41613, 41628, 41647, 41650, 41652, 41667, 41668, 41670, 41673, 41813, 42223, 42229, 42239, 42240, 42241, 42340, 42352, 42412, 42515, 42758, 42811, 42880, 42906, 43067, 43197, 43229, 43232, 43234, 43257, 43263, 43268, 43280, 43283, 43288, 43298, 43308, 43321, 43357, 43436, 43462, 43465, 43473, 43490, 43502, 43514, 43517, 43519, 43523, 43527, 43531, 43535, 43539, 43541, 43543, 43547, 43551, 43553, 43557, 43606, 43626, 43696, 43740, 43806, 43836, 43856, 43895, 43896, 43901, 43952, 43955, 43958, 43971, 43987, 44059, 44067, 44122, 44129, 44206, 44392, 44417, 44456, 44462, 44679, 45128, 45166, 45169, 45174, 45176, 45180, 45184, 45188, 45192, 45196, 45204, 45208, 45216, 45222, 45228, 45232, 45240, 45244, 45248, 45252, 45257, 45262, 45274, 45307, 45330, 45344, 45356, 45399, 45482, 45515, 45530, 45539, 45548, 45559, 45567, 45574, 45589, 45601, 45616, 45689, 45691, 45733, 45793, 45860, 45894, 45919, 45934, 45966, 46005, 46047, 46109, 46121, 46140, 46176, 46186, 46189, 46198, 46274, 46309, 46315, 46357, 46369, 46388, 46389, 46609, 46616, 46651, 46665, 46680, 46694, 46736, 46744, 46760, 46765, 46768, 46773, 46776, 46780, 46785, 46789, 46843, 46846, 46853, 46855, 46866, 46876, 46886, 46895, 46898, 46901, 46904, 46909, 46910, 46911, 46916, 46928, 46934, 46940, 46946, 46948, 46951, 46952, 46956, 46957, 46960, 46964, 47013, 47042, 47055, 47063, 47078, 47085, 47107, 47149, 47173, 47185, 47198, 47231, 47242, 47243, 47252, 47272, 47289, 47297, 47303, 47309, 47326, 47362, 47411, 47448, 47449, 47457, 47463, 47464, 47487, 47527, 47543, 47568, 47575, 47613, 47667, 47699, 47704, 47714, 47729, 47754, 47768, 47769, 47779, 47787, 47815, 47825, 47871, 47893, 47899, 47904, 47921, 47931, 47938, 47947, 47958, 47967, 47998, 48001, 48007, 48011, 48013, 48044, 48143, 48165, 48179, 48210, 48219, 48224, 48237, 48370, 48381, 48394, 48403, 48447, 48464, 48490, 48494, 48500, 48521, 48539, 48584, 48640, 48645, 48657, 48679, 48684, 48690, 48692, 48694, 48699, 48707, 48724, 48727, 48811, 48824, 48833, 48874, 48879, 48882, 48884, 48887, 48888, 48890, 48892, 48896, 48899, 48902, 48909, 48913, 48918, 48923, 48927, 48945, 48946, 48947, 48961, 48986, 48989, 48993, 49001, 49002, 49007, 49014, 49015, 49040, 49043, 49053, 49055, 49072, 49076, 49077, 49081, 49082, 49083, 49086, 49100, 49116, 49117, 49119, 49120, 49122, 49123, 49130, 49134, 49137, 49140, 49141, 49143, 49144, 49148, 49149, 49152, 49153, 49156, 49157, 49162, 49168, 49172, 49177, 49179, 49180, 49181, 49183, 49194, 49196, 49197, 49208, 49212, 49215, 49220, 49223, 49266, 49271, 49295, 49309, 49400, 49419, 49426, 49493, 49500, 49504, 49507, 49509, 49513, 49517, 49522, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49544, 49545, 49548, 49550, 49553, 49564, 49565, 49568, 49585, 49593, 49596, 49598, 49603, 49604, 49614, 49615, 49619, 49636, 49645, 49648, 49649, 49657, 49732, 49758, 49769, 49781, 49789, 49798, 49799, 49800, 49803, 49810, 49814, 49821, 49829, 49846, 49856, 49857, 49858, 49869, 49870, 49880, 49882, 49883, 49896, 49900, 49902, 49905, 49906, 49907, 49910, 49912, 49915, 49916, 49917, 49919, 49921, 49924, 49926, 49929, 49931, 49933, 49934, 49935, 49938, 49940, 49943, 49944, 49945, 49947, 49949, 49952, 49954, 49957, 49959, 49961, 49966, 49968, 49971, 49972, 49978, 49992, 49997, 50018, 50040, 50054, 50072, 50083, 50091, 50099, 50113, 50116, 50143, 50147, 50163, 50165, 50183, 50189, 50193, 50195, 50203, 50207, 50208, 50210, 50217, 50234, 50256, 50259, 50268, 50284, 50298, 50341, 50348, 50349, 50372, 50393, 50395, 50411, 50415, 50441, 50461, 50535, 50548, 50567, 50606, 50607, 50625, 50627, 50707, 50714, 50723, 50764, 50785, 50790, 50791, 50797, 50801, 50802, 50805, 50806, 50812, 50817, 50849, 50899, 50920, 50949, 51023, 51070, 51139, 51202, 51261, 51271, 51313, 51322, 51343, 51360, 51368, 51372, 51387, 51420, 51424, 51435, 51446, 51448, 51461, 51471, 51495, 51501, 51529, 51535, 51537, 51539, 51541, 51543, 51544, 51545, 51557, 51561, 51565, 51569, 51576, 51577, 51580, 51581, 51591, 51597, 51606, 51624, 51628, 51629, 51634, 51643, 51648, 51653, 51654, 51655, 51664, 51667, 51676, 51701, 51759, 51794, 51796, 51797, 51811, 51815, 51833, 51836, 51841, 51843, 51871, 51886, 51887, 51900, 51902, 51904, 51907, 51909, 51955, 51957, 51959, 51963, 51964, 51971, 51973, 51976, 51978, 51982, 51983, 51984, 51986, 51989, 51993, 51994, 51996, 51997, 51999, 52000, 52001, 52002, 52005, 52007, 52008, 52009, 52010, 52012, 52015, 52017, 52018, 52022, 52023, 52025, 52028, 52029, 52030, 52042, 52044, 52046, 52047, 52049, 52050, 52051, 52053, 52054, 52060, 52066, 52083, 52091, 52098, 52101, 52128, 52129, 52130, 52167, 52203, 52263, 52412, 52458, 52477, 52489, 52491, 52506, 52529, 52534, 52540, 52551, 52552, 52553, 52555, 52558, 52559, 52563, 52569, 52572, 52575, 52582, 52591, 52594, 52601, 52611, 52612, 52613, 52614, 52615) 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 Agreeable Surprise

Afterpiece Title: Fortune's Frolick

Cast
Role: Robin Rough@head Actor: Fawcett

Afterpiece Title: Obi

Performances

Mainpiece Title: The Iron Chest

Afterpiece Title: The Village Lawyer

Cast
Role: Robin Rough@head Actor: Fawcett

Performances

Mainpiece Title: What A Blunder

Afterpiece Title: Fortune's Frolick

Cast
Role: Robin Rough@head Actor: Fawcett

Performances

Mainpiece Title: Blue Devils

Afterpiece Title: The Point of Honour

Cast
Role: Robin Rough@head Actor: Fawcett

Afterpiece Title: The Castle of Sorrento

Song: As18000614

Performances

Mainpiece Title: Cambro-britons

Afterpiece Title: The Agreeable Surprise

Cast
Role: Robin Rough@head Actor: Fawcett

Song: End: Paddy's Description of Pizarro; or, Mr Paddy O'Doody and his Cousin Shaun Shaugnessy's Treat to the One Shilling Gallery-Johnstone

Performances

Mainpiece Title: The Review

Afterpiece Title: A Mogul Tale

Afterpiece Title: Obi

Cast
Role: Robin Rough@head Actor: Fawcett

Song: End 1st piece: Half and Half (never before sung)-Fawcett; End of 2nd piece: Paddy's Description of Pizarro, as18000829

Performances

Mainpiece Title: The Review

Afterpiece Title: The Deaf Lover

Afterpiece Title: Obi

Cast
Role: Robin Rough@head Actor: Fawcett

Performances

Mainpiece Title: Fortune's Frolick

Afterpiece Title: The Review

Cast
Role: Robin Rough@head Actor: Fawcett

Afterpiece Title: Obi

Cast
Role: Robin Rough@head Actor: Fawcett

Performances

Mainpiece Title: The Village Lawyer

Afterpiece Title: The Review

Cast
Role: Robin Rough@head Actor: Fawcett

Afterpiece Title: Obi

Cast
Role: Robin Rough@head Actor: Fawcett

Performances

Mainpiece Title: Obi

Afterpiece Title: The Point of Honour

Cast
Role: Robin Rough@head Actor: Fawcett