SELECT * FROM london_stages WHERE eventid IN (21246, 21258, 21284, 21512, 21515, 21521, 21529, 21557, 21590, 21605, 21611, 21617, 21619, 21665, 21670, 21671, 21674, 21678, 21682, 21696, 21707, 21709, 21743, 21747, 21750, 21758, 21761, 21776, 21781, 21785, 21797, 21803, 21809, 21814, 21824, 21828, 21837, 22005, 22008, 22010, 22013, 22019, 22022, 22027, 22032, 22034, 22046, 22053, 22118, 22132, 22142, 22155, 22161, 22162, 22185, 22192, 22195, 22204, 22237, 22240, 22396, 22399, 22417, 22420, 22433, 22508, 22586, 22598, 22772, 22821, 22833, 22834, 22956, 22958, 22961, 23002, 23011, 23055, 23090, 23106, 23127, 23156, 23202, 23247, 23252, 23496, 23499, 23502, 23513, 23515, 23761, 23804, 23974, 24012, 24018, 24021, 24022, 24026, 24028, 24029, 24031, 24032, 24039, 24044, 24045, 24058, 24065, 24068, 24070, 24071, 24075, 24078, 24081, 24083, 24084, 24113, 24124, 24136, 24150, 24179, 24187, 24200, 24203, 24204, 24218, 24243, 24275, 24354, 24356, 24357, 24379, 24530, 24559, 24653, 24685, 24696, 24702, 24723, 24739, 24774, 24778, 24915, 24917, 24942, 24970, 24994, 25077, 25120, 25210, 25230, 25238, 25253, 25267, 25270, 25273, 25278, 25280, 25331, 25332, 25337, 25338, 25339, 25340, 25341, 25342, 25343, 25344, 25345, 25346, 25347, 25348, 25349, 25350, 25351, 25352, 25353, 25354, 25355, 25356, 25357, 25358, 25359, 25360, 25361, 25362, 25375, 25387, 25398, 25400, 25407, 25429, 25433, 25441, 25464, 25472, 25476, 25478, 25479, 25480, 25484, 25487, 25488, 25521, 25529, 25533, 25536, 25540, 25546, 25548, 25550, 25551, 25552, 25553, 25560, 25573, 25576, 25579, 25582, 25583, 25586, 25593, 25596, 25602, 25605, 25608, 25620, 25626, 25631, 25632, 25638, 25640, 25655, 25656, 25660, 25666, 25672, 25680, 25681, 25688, 25699, 25702, 25707, 25711, 25714, 25977, 25980, 26033, 26062, 26094, 26125, 26135, 26662, 26665, 26677, 26694, 26698, 26739, 26741, 26743, 26745, 26747, 26781, 26785, 26809, 26810, 26815, 26820, 26866, 26874, 26880, 26883, 26888, 26891, 26892, 26896, 26901, 26903, 26905, 26908, 26914, 26923, 26950, 26974, 26978, 26983, 26984, 26985, 26992, 26994, 26998, 27004, 27009, 27012, 27016, 27020, 27023, 27028, 27030, 27031, 27037, 27043, 27045, 27056, 27064, 27068, 27072, 27075, 27078, 27085, 27086, 27097, 27101, 27103, 28124, 28153, 28155, 28161, 28167, 28170, 28174, 28176, 28180, 28183, 28185, 28188, 28192, 28197, 28199, 28201, 28205, 28207, 28211, 28213, 28214, 28217, 28223, 28225, 28227, 28231, 28235, 28237, 28239, 28242, 28243, 28247, 28249, 28251, 28253, 28268, 28269, 28275, 28291, 28299, 28308, 28312, 28315, 28324, 28331, 28336, 28339, 28343, 28345, 28351, 28352, 28354, 28355, 28358, 28361, 28365, 28370, 28373, 28374, 28376, 28379, 28381, 28393, 28395, 28399, 28400, 28404, 28406, 28410, 28412, 28424, 28441, 28444, 28450, 28455, 28462, 28464, 28465, 28472, 28481, 28482, 28484, 28485, 28487, 28489, 28490, 28496, 28497, 28499, 28501, 28504, 28505, 28506, 28511, 28515, 28516, 28518, 28521, 28522, 28524, 28531, 28541, 28542, 28544, 28545, 28548, 28550, 28552, 28564, 28565, 28645, 28680, 28708, 28737, 28761, 28766, 28819, 28824, 28847, 28851, 28857, 28861, 28864, 28866, 28874, 28927, 28931, 28939, 28946, 28947, 28962, 28967, 28973, 28978, 28987, 28995, 28997, 29001, 29005, 29006, 29009, 29011, 29016, 29022, 29023, 29032, 29038, 29061, 29072, 29191, 29198, 29207, 29220, 29221, 29241, 29246, 29254, 29259, 29268, 29271, 29273, 29276, 29278, 29282, 29287, 29289, 29295, 29299, 29303, 29321, 29327, 29339, 29345, 29353, 29362, 29385, 29415, 29443, 29455, 29458, 29461, 29462, 29465, 29466, 29469, 29470, 29471, 29478, 29479, 29485, 29489, 29492, 29493, 29497, 29499, 29503, 29506, 29508, 29511, 29514, 29520, 29523, 29530, 29533, 29536, 29540, 29543, 29553, 29560, 29565, 29568, 29569, 29575, 29580, 29581, 29591, 29600, 29604, 29732, 29735, 29739, 29743, 29746, 29748, 29750, 29751, 29753, 29755, 29757, 29759, 29761, 29763, 29765, 29767, 29769, 29771, 29772, 29773, 29774, 29775, 29777, 29778, 29779, 29781, 29783, 29784, 29785, 29786, 29789, 29791, 29792, 29793, 29795, 29798, 29800, 29802, 29805, 29807, 29809, 29810, 29811, 29814, 29816, 29818, 29819, 29820, 29822, 29823, 29826, 29829, 29835, 29838, 29839, 29840, 29842, 29844, 29848, 29851, 29853, 29856, 29859, 29868, 29870, 29872, 29873, 29879, 29881, 29886, 29888, 29889, 29890, 29892, 29894, 29897, 29899, 29901, 29902, 29903, 29907, 29909, 29910, 29912, 29914, 29919, 29920, 29921, 29927, 29929, 29937, 29946, 29948, 29960, 29961, 29968, 29981, 29988, 30006, 30009, 30012, 30015, 30028, 30031, 30032, 30037, 30043, 30052, 30055, 30057, 30061, 30062, 30063, 30065, 30066, 30068, 30070, 30076, 30081, 30082, 30086, 30090, 30095, 30100, 30101, 30103, 30104, 30106, 30107, 30111, 30112, 30114, 30116, 30119, 30120, 30126, 30130, 30133, 30137, 30141, 30145, 30148, 30150, 30151, 30152, 30153, 30155, 30292, 30298, 30301, 30318, 30326, 30335, 30340, 30372, 30381, 30385, 30388, 30390, 30393, 30395, 30400, 30404, 30405, 30410, 30413, 30415, 30429, 30432, 30439, 30444, 30452, 30475, 30479, 30484, 30503, 30510, 30514, 30518, 30523, 30527, 30536, 30543, 30550, 30554, 30558, 30564, 30566, 30567, 30570, 30571, 30579, 30584, 30585, 30590, 30592, 30593, 30598, 30599, 30600, 30601, 30603, 30604, 30606, 30608, 30618, 30622, 30623, 30625, 30627, 30629, 30633, 30636, 30638, 30644, 30648, 30649, 30651, 30654, 30656, 30657, 30660, 30661, 30662, 30663, 30666, 30669, 30672, 30673, 30677, 30682, 30683, 30684, 30692, 31332, 31333, 31335, 31343, 31344, 31358, 31364, 31368, 31370, 31372, 31376, 31378, 31380, 31387, 31406, 31407, 31416, 31424, 31425, 31426, 31428, 31432, 31435, 31436, 31437, 31439, 31452, 31455, 31462, 31480, 31482, 31484, 31491, 31503, 31513, 31521, 31540, 31542, 31548, 31563, 31568, 31581, 31586, 31595, 31603, 31605, 31624, 31640, 31642, 31645, 31648, 31652, 31657, 31664, 31665, 31669, 31675, 31676, 31677, 31680, 31682, 31684, 31692, 31696, 31698, 31704, 31705, 31706, 31712, 31714, 31723, 31732, 31733, 31734, 31742, 31747, 31748, 31756, 31757, 31761, 31767, 31769, 31770, 31773, 32323, 32327, 32329, 32337, 32355, 32358, 32365, 32368, 32388, 32399, 32405, 32407, 32412, 32414, 32416, 32417, 32426, 32429, 32436, 32439, 32444, 32447, 32450, 32452, 32457, 32459, 32468, 32475, 32477, 32484, 32485, 32486, 32490, 32498, 32499, 32500, 32501, 32504, 32508, 32513, 32515, 32519, 32526, 32534, 32544, 32560, 32568, 32580, 32588, 32592, 32609, 32614, 32629, 32630, 32631, 32640, 32642, 32644, 32648, 32653, 32657, 32660, 32663, 32664, 32669, 32671, 32674, 32675, 32676, 32677, 32678, 32681, 32683, 32685, 32691, 32693, 32694, 32696, 32699, 32701, 32706, 32707, 32708, 32710, 32713, 32714, 32715, 32718, 32720, 32721, 32722, 32727, 32728, 32729, 32730, 32732, 32733, 32737, 32739, 32741, 32746, 32747, 32748, 32752, 33258, 33260, 33262, 33263, 33267, 33271, 33272, 33273, 33274, 33277, 33278, 33281, 33282, 33284, 33287, 33294, 33297, 33301, 33304, 33306, 33309, 33312, 33315, 33316, 33317, 33322, 33323, 33325, 33330, 33332, 33335, 33339, 33344, 33347, 33348, 33351, 33359, 33360, 33368, 33369, 33378, 33381, 33383, 33384, 33388, 33396, 33400, 33402, 33404, 33406, 33409, 33411, 33420, 33423, 33428, 33430, 33433, 33434, 33439, 33442, 33447, 33469, 33477, 33481, 33486, 33515, 33522, 33531, 33558, 33559, 33573, 33576, 33581, 33583, 33592, 33593, 33595, 33596, 33597, 33601, 33602, 33605, 33609, 33618, 33621, 33630, 33636, 33639, 33640, 33642, 33644, 33648, 33652, 33653, 33657, 33660, 33662, 33664, 33665, 33667, 33671, 33673, 33676, 33686, 33690, 33693, 33694, 33695, 33698, 33701, 33704, 33707, 33708, 33710, 33711, 33715, 33717, 33719, 33801, 33802, 33808, 33809, 33813, 33816, 33817, 33819, 33823, 33825, 33826, 33827, 33829, 33832, 33833, 33837, 33840, 33842, 33843, 33846, 33847, 33849, 33850, 33851, 33852, 33853, 33854, 33855, 33856, 33857, 33860, 33864, 33867, 33873, 33874, 33875, 33876, 33877, 33878, 33879, 33880, 33883, 33884, 33885, 33888, 33891, 33892, 33897, 33898, 33899, 33902, 33903, 33904, 33906, 33907, 33910, 33916, 33918, 33920, 33921, 33922, 33924, 33925, 33927, 33930, 33932, 33933, 33934, 33936, 33939, 33941, 33963, 33964, 33970, 33972, 33974, 33976, 33978, 33979, 33980, 33981, 33982, 33985, 33990, 33992, 33996, 33997, 34006, 34008, 34011, 34015, 34017, 34018, 34020, 34023, 34026, 34029, 34036, 34037, 34039, 34040, 34053, 34069, 34070, 34072, 34073, 34076, 34082, 34086, 34098, 34100, 34102, 34141, 34146, 34147, 34155, 34156, 34161, 34162, 34164, 34168, 34169, 34173, 34175, 34178, 34182, 34185, 34187, 34189, 34190, 34194, 34197, 34198, 34200, 34202, 34203, 34204, 34205, 34207, 34209, 34212, 34213, 34218, 34219, 34220, 34222, 34223, 34225, 34227, 34228, 34229, 34230, 34232, 34234, 34237, 34238, 34242, 34244, 34245, 34252, 34253, 34254, 34255, 34256, 34259, 34264, 34266, 34345, 34353, 34359, 34364, 34369, 34373, 34377, 34382, 34383, 34421, 34423, 34426, 34429, 34435, 34440, 34445, 34450, 34459, 34461, 34465, 34475, 34482, 34487, 34493, 34502, 34506, 34513, 34525, 34528, 34529, 34532, 34547, 34556, 34557, 34569, 34576, 34583, 34585, 34620, 34622, 34635, 34637, 34648, 34688, 34696, 34703, 34706, 34708, 34709, 34712, 34715, 34718, 34723, 34725, 34737, 34742, 34743, 34744, 34748, 34752, 34753, 34758, 34759, 34762, 34765, 34766, 34767, 34772, 34773, 34775, 34779, 34785, 34786, 34789, 34794, 34795, 34798, 34799, 34802, 34806, 34815, 36109, 36111, 36112, 36114, 36119, 36120, 36124, 36125, 36129, 36132, 36133, 36139, 36141, 36142, 36143, 36147, 36155, 36159, 36161, 36163, 36166, 36168, 36174, 36190, 36195, 36201, 36206, 36207, 36210, 36214, 36217, 36227, 36229, 36230, 36234, 36235, 36241, 36247, 36251, 36255, 36256, 36261, 36264, 36265, 36267, 36269, 36273, 36277, 36279, 36280, 36282, 36289, 36290, 36292, 36293, 36294, 36296, 36305, 36317, 36324, 36326, 36327, 36334, 36336, 36337, 36345, 36346, 36348, 36351, 36355, 36359, 36363, 36365, 36367, 36374, 36381, 36382, 36388, 36393, 36422, 36424, 36425, 36430, 36434, 36437, 36438, 36440, 36441, 36445, 36446, 36449, 36460, 36465, 36468, 36470, 36471, 36473, 36476, 36477, 36478, 36479, 36480, 36482, 36483, 36485, 36489, 36492, 36494, 36497, 36500, 36502, 36503, 36504, 36506, 36508, 36512, 36514, 36516, 36519, 36522, 36523, 36526, 36532, 36533, 36535, 36537, 36538, 36541, 36543, 36544, 36549, 36553, 36555, 36561, 36565, 36573, 36589, 36592, 36604, 36627, 36634) 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 Recruiting Officer

Afterpiece Title: The Cooper Outwitted; or, Harlequin Happy

Song: I: Bumper Squire Jones-Beard; III: The Early Horn-Lowe

Dance: II: Le Boufon, as17420325 IV: The Drunken Peasant-Phillips

Performances

Afterpiece Title: Orpheus and Eurydice

Dance: LLouvre, Minuet-Dupre, a scholar of his

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Miss Lucy in Town

Performances

Mainpiece Title: The Stratagem

Cast
Role: Archer Actor: Garrick, 1st time

Song: II: Lowe; IV: Lowe

Music: III: Concerto on Violincello-Cervetti

Performances

Mainpiece Title: The Stratagem

Cast
Role: Archer Actor: Garrick, 1st time

Dance: II: Les Moisoneurs de la Styrie, as17421126; IV: La Recrue des Houssars, as17421221

Performances

Mainpiece Title: The Stratagem

Cast
Role: Archer Actor: Garrick, 1st time

Song: As17421204

Music: III: Concerto on Violincello-Cervetti

Performances

Mainpiece Title: The Stratagem

Cast
Role: Archer Actor: Garrick, 1st time

Dance: II: a New Comic Dance call'd Neopolitan Punch-Checo Torinese, Sga Chiaretta Aquilanti, Boromeo, Mlle Bonneval; IV: A New Comic Dance call'd Italian Gardeners-Checo, Chiaretta

Performances

Mainpiece Title: The Stratagem

Cast
Role: Archer Actor: Garrick, 1st time

Dance: II: Neopolitan Punch, as17421231; IV: Italian Gardeners, as17421231

Music: III: Concerto-Piantanida

Performances

Mainpiece Title: The Stratagem

Cast
Role: Archer Actor: Garrick, 1st time

Dance: As17430120

Performances

Mainpiece Title: The Rival Queens

Afterpiece Title: The Dragon of Wantley

Performances

Mainpiece Title: Cato

Afterpiece Title: The Dragon of Wantley

Performances

Mainpiece Title: The Stratagem

Cast
Role: Archer Actor: Garrick, 1st time

Song: As17430120

Dance: As17430120

Performances

Mainpiece Title: The Stratagem

Cast
Role: Archer Actor: Garrick, 1st time

Afterpiece Title: The Dragon of Wantley

Music: IV: Concerto-Piantanida

Performances

Mainpiece Title: The Distrest Mother

Afterpiece Title: Perseus and Andromeda

Cast
Role: Petit@Maitre Actor: D'Estrade, 1st time

Performances

Mainpiece Title: The Stratagem

Cast
Role: Archer Actor: Garrick, 1st time

Afterpiece Title: The Mock Doctor

Dance: As17430120

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Perseus and Andromeda

Cast
Role: Petit@Maitre Actor: D'Estrade, 1st time

Performances

Mainpiece Title: Jane Shore

Cast
Role: Hastings Actor: Garrick, 1st time

Afterpiece Title: The Lying Valet

Song: IV: Beard

Performances

Mainpiece Title: The Country Wife

Afterpiece Title: Perseus and Andromeda

Cast
Role: Petit@Maitre Actor: D'Estrade, 1st time

Dance: LLa Provencale, as17421105; Les Boufons du Cour-Delemain, Mlle Auguste

Performances

Mainpiece Title: Comus

Cast
Role: Sabrina Actor: Miss Edwards, 1st time.

Afterpiece Title: The Lying Valet

Dance: Boromeo, Desse, Mlle Bonneval

Performances

Mainpiece Title: Jane Shore

Cast
Role: Hastings Actor: Garrick, 1st time

Afterpiece Title: The Lying Valet

Song: II: Beard; IV: The Early Horn-Lowe

Dance: III: Tyrolean Dance, as17421129

Performances

Mainpiece Title: The Orphan

Afterpiece Title: Perseus and Andromeda

Cast
Role: Petit@Maitre Actor: D'Estrade, 1st time

Performances

Mainpiece Title: The Alchemist

Cast
Role: Abel Drugger Actor: Garrick, 1st time

Afterpiece Title: The School Boy

Dance: II: Sicilian Peasant, as17430310 IV: Italian Gardeners, as17421231

Song: III: Beard

Performances

Mainpiece Title: The Country Wife

Afterpiece Title: The Dragon of Wantley

Song: II: Stella and Flavia-Beard; IV: (By Particular Desire) Bumper Squire Jones-Beard

Music: IV: a Concerto-Piantanida

Dance: III: A Comic Dance-Boromeo, Mlle Bonneval

Performances

Mainpiece Title: The Alchemist

Cast
Role: Abel Drugger Actor: Garrick, 1st time

Dance: II: Sicilian Peasant, as17430310 IV: A Comic Dance call'd La Florana-Checo, Chiaretta

Song: III: Was ever Nymph like Rosamond-Beard

Performances

Mainpiece Title: Jane Shore

Cast
Role: Hastings Actor: Garrick, 1st time

Afterpiece Title: The Lying Valet

Music: II: Concerto on German Flute-Burk Thumoth

Song: IV: Stella and Flavia-Beard