SELECT * FROM london_stages WHERE eventid IN (1136, 1337, 1533, 1778, 1863, 2323, 2461, 3884, 3886, 3968, 4057, 4144, 4146, 4147, 4148, 4154, 4180, 4189, 4219, 4379, 4393, 4427, 4446, 4546, 4604, 4697, 4720, 4768, 4954, 4968, 5181, 5199, 6022, 6069, 6363, 6544, 6743, 7514, 7697, 7907, 7920, 8435, 8458, 8870, 9326, 9626, 10155, 11626, 11631, 11802, 12676, 12729, 12739, 12844, 13050, 13179, 13302, 13310, 13317, 13325, 13342, 13394, 13470, 13597, 14095, 14193, 14231, 14245, 14349, 14378, 14711, 14715, 14734, 14775, 14794, 14822, 14834, 14876, 14924, 15027, 15040, 15136, 15399, 15584, 15601, 15604, 15790, 15905, 15959, 16094, 16448, 16459, 16463, 16485, 16914, 17111, 17143, 17172, 17208, 17267, 17293, 17318, 17349, 17865, 17933, 18021, 18062, 18083, 18204, 18323, 18408, 18448, 18449, 18662, 18870, 18872, 18898, 18977, 19003, 19229, 19598, 19759, 19975, 20027, 20061, 20066, 20159, 20182, 20206, 20252, 20336, 20339, 20342, 20343, 20347, 20350, 20353, 20356, 20359, 20362, 20366, 20369, 20375, 20378, 20381, 20385, 20389, 20392, 20395, 20432, 20435, 20438, 20457, 20532, 20607, 20610, 20641, 20676, 20690, 20810, 20915, 21100, 21118, 21125, 21128, 21131, 21137, 21174, 21239, 21435, 21468, 21709, 21712, 21729, 21764, 21808, 21810, 21866, 21868, 21870, 21881, 21883, 21884, 21887, 21908, 21925, 21944, 22156, 22166, 22172, 22208, 22326, 22408, 22512, 22758, 22829, 22830, 22836, 22889, 22908, 23192, 23210, 23243, 23774, 23836, 23926, 23966, 23993, 23994, 23996, 24014, 24126, 24184, 24265, 24348, 25259, 25920, 25928, 25945, 25948, 25950, 25952, 26042, 26079, 26131, 26282, 26429, 27199, 27201, 27211, 27233, 27274, 27349, 27562, 27565, 27609, 27707, 27731, 27776, 27802, 27917, 27955, 28077, 28204, 28218, 28456, 28469, 28567, 28579, 28580, 28581, 28588, 28589, 28590, 28591, 28592, 28593, 28594, 28595, 28596, 28597, 28598, 28601, 28606, 28608, 28612, 28632, 28637, 28640, 28650, 28695, 28703, 28734, 28741, 28899, 28933, 28980, 28994, 29039, 29224, 29283, 29296, 29328, 29373, 29375, 29420, 29519, 29538, 29568, 29763, 29775, 29805, 30559, 30592, 30672, 31271, 31664, 31710, 32926, 32928, 32933, 32939, 32942, 32944, 32949, 32953, 32962, 32976, 32991, 33017, 33026, 33095, 33106, 33141, 33148, 33259, 33261, 33266, 33268, 33270, 33292, 33306, 33309, 33312, 33317, 33322, 33325, 33330, 33332, 33339, 33348, 33354, 33369, 33430, 33431, 33439, 33641, 33657, 33764, 33768, 33771, 33776, 33880, 33883, 33885, 33888, 33890, 33892, 33894, 33897, 33899, 33911, 33916, 33918, 33925, 33965, 33973, 33977, 34023, 34037, 34041, 34044, 34046, 34049, 34051, 34053, 34056, 34059, 34061, 34064, 34070, 34083, 34094, 34098, 34103, 34108, 34113, 34116, 34118, 34123, 34128, 34131, 34145, 34159, 34180, 34181, 34195, 34302, 34305, 34422, 34457, 34573, 34580, 34583, 34587, 34595, 34606, 34614, 34616, 34625, 34689, 34828, 34836, 34946, 35134, 35145, 35147, 35152, 35157, 35162, 35169, 35177, 35218, 35277, 35462, 35477, 35486, 35539, 35576, 35739, 35750, 35765, 35843, 35856, 35943, 35982, 36004, 36012, 36068, 36075, 36100, 36361, 36464, 36473, 36479, 36484, 36497, 36502, 36532, 36591, 36675, 36678, 36680, 36682, 36684, 36690, 36692, 36698, 36708, 36712, 36714, 36719, 36728, 36756, 36770, 36822, 36825, 36850, 36858, 36877, 36888, 36895, 36909, 37021, 37046, 37055, 37098, 37469, 37550, 37628, 38002, 38577, 38773, 38792, 38799, 38806, 38811, 38815, 38872, 38894, 39250, 39271, 39308, 39397, 39427, 39428, 39429, 39431, 39434, 39437, 39441, 39456, 39625, 39637, 39641, 39707, 39765, 39793, 39838, 39854, 39867, 39881, 39889, 39927, 39928, 39932, 39934, 39943, 39945, 39950, 39955, 39965, 39967, 39969, 39976, 39983, 39994, 40003, 40007, 40010, 40031, 40111, 40182, 40329, 40398, 40406, 40408, 40431, 40444, 40446, 40448, 40465, 40473, 40479, 40481, 40487, 40489, 40494, 40502, 40507, 40509, 40510, 40512, 40513, 40516, 40517, 40519, 40520, 40524, 40526, 40527, 40531, 40538, 40543, 40545, 40551, 40564, 40639, 40727, 40794, 41036, 41039, 41074, 41080, 41098, 41106, 41197, 41499, 41526, 41579, 41580, 41585, 41586, 41590, 41594, 41598, 41603, 41609, 41612, 41613, 41617, 41620, 41621, 41624, 41632, 41638, 41640, 41644, 41645, 41683, 41694, 41766, 42142, 42187, 42194, 42198, 42222, 42226, 42227, 42251, 42257, 42263, 42755, 42764, 42766, 42767, 42768, 42770, 42772, 42773, 42780, 42783, 42802, 42808, 42810, 42811, 42812, 42814, 42815, 42817, 42818, 42820, 42822, 42823, 42826, 42828, 42829, 42831, 42832, 42833, 42834, 42835, 42837, 42839, 42842, 42844, 42846, 42847, 42848, 42849, 42850, 42853, 42870, 42880, 42898, 42909, 42916, 42918, 42922, 42924, 42930, 42932, 42934, 42936, 42940, 42944, 42946, 42948, 42956, 42958, 42960, 42965, 42970, 42977, 42979, 42982, 42986, 42988, 42997, 42999, 43001, 43006, 43007, 43008, 43010, 43012, 43015, 43017, 43020, 43022, 43024, 43026, 43029, 43031, 43034, 43036, 43038, 43040, 43043, 43072, 43077, 43099, 43101, 43120, 43141, 43158, 43172, 43180, 43191, 43204, 43217, 43255, 43277, 43317, 43325, 43335, 43343, 43344, 43349, 43350, 43352, 43353, 43355, 43356, 43357, 43358, 43360, 43361, 43363, 43364, 43366, 43368, 43371, 43373, 43375, 43377, 43378, 43379, 43380, 43382, 43383, 43384, 43386, 43387, 43390, 43391, 43393, 43398, 43399, 43402, 43403, 43407, 43412, 43414, 43419, 43420, 43422, 43423, 43428, 43431, 43507, 43514, 43517, 43519, 43523, 43527, 43531, 43535, 43539, 43541, 43543, 43547, 43551, 43553, 43606, 43696, 43836, 43870, 43896, 43902, 43910, 43916, 43929, 43934, 43935, 43938, 43954, 43969, 43991, 43993, 44004, 44021, 44108, 44114, 44120, 44124, 44126, 44130, 44134, 44146, 44164, 44181, 44183, 44187, 44207, 44213, 44238, 44243, 44255, 44262, 44271, 44278, 44295, 44305, 44310, 44323, 44340, 44349, 44366, 44383, 44388, 44406, 44413, 44420, 44428, 44433, 44446, 44480, 44504, 44529, 44536, 44539, 44541, 44544, 44545, 44546, 44548, 44550, 44552, 44553, 44561, 44569, 44571, 44581, 44595, 44597, 44600, 44601, 44609, 44616, 44617, 44622, 44657, 44697, 44751, 44754, 44756, 44759, 44763, 44768, 44770, 44773, 44775, 44777, 44780, 44782, 44784, 44786, 44793, 44800, 44816, 44827, 44833, 44848, 44855, 44856, 44866, 44875, 44896, 44912, 44916, 44928, 44930, 44935, 44989, 44991, 45012, 45019, 45021, 45036, 45044, 45055, 45056, 45060, 45064, 45076, 45077, 45083, 45090, 45094, 45097, 45103, 45120, 45134, 45136, 45144, 45159, 45165, 45211, 45265, 45273, 45275, 45277, 45325, 45377, 45388, 45411, 45414, 45460, 45465, 45474, 45476, 45494, 45546, 45563, 45568, 45590, 45599, 45619, 45628, 45631, 45640, 45655, 45656, 45657, 45658, 45660, 45662, 45674, 45677, 45691, 45707, 45721, 45737, 45747, 45790, 45911, 45914, 45916, 45918, 45925, 45930, 45934, 45937, 45943, 45944, 45958, 45965, 45972, 45973, 45999, 46009, 46013, 46024, 46026, 46028, 46037, 46042, 46045, 46054, 46058, 46070, 46083, 46098, 46108, 46127, 46154, 46159, 46220, 46243, 46260, 46280, 46283, 46291, 46293, 46300, 46306, 46310, 46320, 46332, 46346, 46358, 46376, 46414, 46526, 46531, 46540, 46549, 46551, 46554, 46558, 46560, 46573, 46574, 46579, 46589, 46594, 46603, 46618, 46623, 46656, 46672, 46673, 46677, 46715, 46738, 46754, 46767, 46798, 46805, 46811, 46821, 46839, 46848, 46856, 46857, 46868, 46870, 46922, 46932, 46968, 46974, 47048, 47090, 47171, 47228, 47307, 47323, 47339, 47350, 47352, 47353, 47370, 47376, 47380, 47382, 47383, 47385, 47386, 47387, 47388, 47400, 47423, 47424, 47455, 47479, 47488, 47506, 47540, 47565, 47582, 47583, 47584, 47586, 47589, 47591, 47593, 47595, 47597, 47600, 47602, 47603, 47605, 47607, 47609, 47611, 47614, 47616, 47619, 47621, 47623, 47625, 47628, 47631, 47633, 47634, 47635, 47637, 47639, 47641, 47649, 47665, 47673, 47688, 47690, 47732, 47734, 47771, 47824, 47868, 47869, 47874, 47885, 47898, 47901, 47912, 47913, 47918, 47927, 47944, 47952, 47957, 47965, 47969, 47976, 47980, 47990, 48003, 48009, 48015, 48023, 48024, 48032, 48042, 48052, 48069, 48087, 48102, 48139, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48168, 48170, 48172, 48174, 48178, 48180, 48182, 48217, 48263, 48277, 48282, 48293, 48298, 48302, 48307, 48312, 48316, 48326, 48328, 48335, 48343, 48355, 48357, 48360, 48365, 48367, 48369, 48371, 48374, 48383, 48385, 48393, 48395, 48397, 48410, 48412, 48415, 48416, 48418, 48426, 48436, 48443, 48445, 48454, 48462, 48467, 48469, 48470, 48472, 48473, 48474, 48476, 48477, 48478, 48480, 48482, 48484, 48487, 48488, 48489, 48492, 48494, 48495, 48496, 48497, 48515, 48519, 48526, 48530, 48532, 48533, 48540, 48542, 48546, 48550, 48552, 48554, 48556, 48558, 48560, 48562, 48564, 48568, 48574, 48576, 48578, 48582, 48587, 48589, 48593, 48595, 48599, 48610, 48614, 48626, 48636, 48644, 48646, 48652, 48660, 48666, 48668, 48670, 48675, 48676, 48677, 48678, 48679, 48680, 48685, 48686, 48687, 48688, 48689, 48690, 48692, 48695, 48696, 48697, 48698, 48699, 48700, 48704, 48705, 48706, 48707, 48709, 48710, 48714, 48716, 48718, 48720, 48726, 48728, 48729, 48732, 48734, 48736, 48744, 48746, 48748, 48750, 48754, 48756, 48776, 48777, 48778, 48780, 48786, 48788, 48790, 48791, 48792, 48794, 48797, 48799, 48802, 48804, 48805, 48806, 48808, 48811, 48813, 48816, 48817, 48818, 48822, 48825, 48827, 48829, 48831, 48833, 48836, 48838, 48841, 48843, 48845, 48847, 48850, 48852, 48855, 48857, 48858, 48859, 48861, 48864, 48866, 48869, 48871, 48873, 48875, 48880, 48883, 48885, 48888, 48891, 48893, 48900, 48903, 48910, 48914, 48917, 48919, 48924, 48928, 48931, 48934, 48939, 48946, 48953, 48957, 48960, 48962, 48987, 48994, 48999, 49006, 49011, 49022, 49025, 49035, 49047, 49050, 49051, 49062, 49069, 49071, 49085, 49116, 49117, 49119, 49120, 49122, 49139, 49143, 49144, 49148, 49149, 49157, 49194, 49205, 49209, 49215, 49220, 49246, 49540, 49556, 49560, 49565, 49570, 49572, 49575, 49578, 49579, 49580, 49585, 49588, 49589, 49592, 49593, 49602, 49603, 49604, 49607, 49612, 49619, 49632, 49634, 49635, 49640, 49643, 49650, 49655, 49662, 49667, 49732, 49737, 49765, 49767, 49770, 49784, 49797, 49801, 49811, 49818, 49819, 49822, 49830, 49834, 49836, 49840, 49842, 49854, 49862, 49872, 49874, 49878, 49887, 49896, 49901, 49904, 49911, 49920, 49924, 49925, 49926, 49929, 49930, 49931, 49932, 49933, 49935, 49938, 49940, 49943, 49945, 49946, 49947, 49949, 49951, 49952, 49953, 49954, 49956, 49957, 49958, 49959, 49960, 49961, 49962, 49965, 49966, 49967, 49968, 49970, 49971, 49972, 49974, 49977, 49978, 49979, 49980, 49982, 49983, 49984, 49985, 49986, 49987, 49988, 49989, 49991, 49992, 49993, 49994, 49997, 49998, 50000, 50001, 50003, 50004, 50005, 50006, 50009, 50010, 50012, 50013, 50015, 50016, 50018, 50019, 50022, 50023, 50025, 50026, 50028, 50029, 50030, 50031, 50035, 50038, 50041, 50044, 50048, 50051, 50052, 50054, 50060, 50063, 50066, 50069, 50070, 50079, 50081, 50086, 50089, 50094, 50096, 50097, 50099, 50101, 50102, 50104, 50105, 50107, 50113, 50115, 50116, 50117, 50120, 50122, 50123, 50126, 50128, 50130, 50131, 50134, 50138, 50141, 50146, 50148, 50150, 50153, 50161, 50163, 50166, 50189, 50193, 50195, 50205, 50234, 50242, 50263, 50289, 50290, 50306, 50308, 50310, 50324, 50353, 50356, 50358, 50360, 50361, 50378, 50399, 50403, 50409, 50417, 50432, 50443, 50458, 50614, 50623, 50625, 50627, 50638, 50741, 50753, 50829, 50833, 50835, 50838, 50840, 50842, 50850, 50854, 50856, 50857, 50858, 50861, 50872, 50876, 50877, 50883, 50884, 50897, 50900, 50906, 50916, 50926, 50930, 50954, 50972, 50992, 50994, 51037, 51077, 51153, 51184, 51230, 51247, 51249, 51254, 51256, 51285, 51298, 51314, 51356, 51359, 51367, 51387, 51395, 51399, 51405, 51411, 51413, 51416, 51418, 51424, 51431, 51441, 51446, 51451, 51453, 51468, 51509, 51513, 51517, 51537, 51541, 51564, 51572, 51650, 51657, 51659, 51681, 51721, 51733, 51746, 51774, 51777, 51782, 51794, 51797, 51798, 51799, 51800, 51811, 51817, 51819, 51820, 51825, 51828, 51833, 51835, 51836, 51841, 51842, 51843, 51871, 51879, 51883, 51886, 51897, 51901, 51903, 51906, 51907, 51908, 51911, 51914, 51916, 51918, 51921, 51923, 51926, 51928, 51930, 51932, 51935, 51937, 51939, 51941, 51942, 51943, 51946, 51949, 51952, 51954, 51956, 51958, 51961, 51963, 51966, 51968, 51970, 51972, 51991, 52071, 52086, 52145, 52179, 52183, 52187, 52191, 52195, 52197, 52199, 52205, 52209, 52217, 52222, 52228, 52235, 52242, 52247, 52256, 52263, 52268, 52276, 52283, 52289, 52290, 52294, 52296, 52297, 52303, 52304, 52311, 52316, 52317, 52318, 52322, 52325, 52328, 52329, 52353, 52359, 52365, 52373, 52385, 52393, 52399, 52404, 52405, 52409, 52414, 52418, 52425, 52429, 52432, 52439, 52442, 52447, 52452, 52456, 52457, 52461, 52462, 52466, 52476, 52504, 52511, 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: Liberal Opinions

Afterpiece Title: Paul and Virginia

Cast
Role: Choral Boys Actor: Master _Ramage.

Afterpiece Title: The Horse and the Widow

Dance: As18000501

Song: As18000501

Performances

Mainpiece Title: Liberal Opinions

Afterpiece Title: Paul and Virginia

Cast
Role: Choral Boys Actor: Master _Ramage.

Afterpiece Title: The Horse and the Widow

Dance: As18000501

Song: As18000501

Performances

Mainpiece Title: Liberal Opinions

Afterpiece Title: Paul and Virginia

Cast
Role: Choral Boys Actor: Master _Ramage.

Afterpiece Title: The Horse and the Widow

Dance: As18000501

Song: As18000501

Performances

Mainpiece Title: Pizarro

Cast
Role: Boy Actor: Master Chatterley

Afterpiece Title: The Apprentice

Song: Vocal Parts, as17991228, but Mrs Coates, Mrs _Chippendale

Performances

Mainpiece Title: Speed The Plough

Afterpiece Title: Paul and Virginia

Cast
Role: Choral Boys Actor: Master _Ramage.

Dance: As18000503

Song: As18000503

Performances

Mainpiece Title: Pizarro

Cast
Role: Boy Actor: Master Chatterley

Afterpiece Title: Of Age To-morrow

Song: As17991228

Performances

Mainpiece Title: St David's Day

Afterpiece Title: Liberal Opinions

Cast
Role: Choral Boys Actor: Master _Ramage.

Afterpiece Title: Paul and Virginia

Cast
Role: Choral Boys Actor: Master _Ramage.

Dance: In 3rd piece: As18000501

Song: In 3rd piece: As18000501

Performances

Mainpiece Title: Speed The Plough

Afterpiece Title: Paul and Virginia

Cast
Role: Choral Boys Actor: Master _Ramage.

Dance: As18000503

Song: As18000503

Performances

Mainpiece Title: Speed The Plough

Afterpiece Title: Paul and Virginia

Cast
Role: Choral Boys Actor: Master _Ramage.

Dance: As18000503

Song: As18000503

Performances

Mainpiece Title: The Lie Of The Day

Afterpiece Title: Three Weeks after Marriage

Afterpiece Title: Paul and Virginia

Cast
Role: Choral Boys Actor: Master _Ramage.

Song: In Course Evening: The Storm-Incledon

Entertainment: Monologue End II: personal address to the Audience in a Poetical Composition-O'Keeffe (written by Himself for the Occasion); End: Imitations-Rees

Performances

Mainpiece Title: The Young Quaker

Cast
Role: Young Sadboy Actor: C. Kemble
Role: Old Sadboy Actor: Abbot

Afterpiece Title: Obi