SELECT * FROM london_stages WHERE eventid IN (37828, 37832, 37838, 37844, 37848, 37853, 37857, 37859, 37861, 37869, 37871, 37873, 37876, 37879, 37883, 37888, 37892, 37894, 37896, 37898, 37901, 37903, 37906, 37908, 37910, 37912, 37915, 37917, 37920, 37924, 37926, 37929, 37936, 37938, 37942, 37944, 37946, 37948, 37950, 37952, 37955, 37957, 37959, 37961, 37983, 37986, 38006, 38009, 38014, 38019, 38024, 38027, 38029, 38031, 38033, 38036, 38041, 38046, 38051, 38057, 38066, 38106, 38129, 38134, 38137, 38144, 38157, 38163, 38178, 38184, 38187, 38191, 38193, 38196, 38198, 38206, 38208, 38211, 38217, 38220, 38231, 38237, 38243, 38245, 38251, 38310, 38314, 38316, 38322, 38326, 38328, 38331, 38335, 38338, 38344, 38346, 38350, 38352, 38354, 38356, 38358, 38362, 38365, 38368, 38370, 38372, 38377, 38379, 38382, 38386, 38388, 38395, 38408, 38413, 38426, 38428, 38432, 38435, 38442, 38444, 38454, 38460, 38465, 38468, 38472, 38474, 38478, 38480, 38482, 38484, 38486, 38489, 38497, 38510, 38512, 38517, 38520, 38522, 38524, 38526, 38529, 38531, 38535, 38537, 38539, 38541, 38544, 38546, 38548, 38550, 38552, 38555, 38557, 38560, 38562, 38564, 38566, 38569, 38574, 38579, 38584, 38589, 38597, 38599, 38609, 38612, 38614, 38625, 38657, 38669, 38674, 38679, 38685, 38688, 38701, 38704, 38707, 38710, 38715, 38717, 38720, 38722, 38732, 38735, 38744, 38746, 38749, 38751, 38754, 38759, 38762, 38767, 38865, 38868, 38871, 38874, 38877, 38886, 38896, 38898, 38907, 38911, 38913, 38915, 38922, 38931, 38940, 38947, 38954, 38957, 38961, 38966, 38975, 38977, 38991, 38994, 39004, 39009, 39014, 39016, 39018, 39021, 39023, 39025, 39027, 39029, 39031, 39033, 39035, 39037, 39039, 39042, 39048, 39050, 39052, 39057, 39059, 39061, 39070, 39073, 39075, 39077, 39082, 39084, 39089, 39091, 39096, 39099, 39108, 39119, 39133, 39136, 39138, 39147, 39152, 39157, 39161, 39166, 39172, 39182, 39185, 39191, 39197, 39200, 39203, 39206, 39209, 39211, 39217, 39220, 39223, 39226, 39231, 39235, 39237, 39240, 39243, 39248, 39251, 39254, 39258, 39261, 39263, 39266, 39269, 39271, 39274, 39277, 39281, 39283, 39289, 39292, 39294, 39297, 39299, 39302, 39304, 39307, 39309, 39313, 39316, 39318, 39321, 39323, 39325, 39327, 39330, 39336, 39446, 39454, 39464, 39471, 39475, 39487, 39492, 39496, 39498, 39500, 39503, 39505, 39509, 39514, 39519, 39521, 39526, 39528, 39533, 39535, 39542, 39545, 39547, 39549, 39551, 39554, 39556, 39559, 39561, 39563, 39565, 39568, 39570, 39573, 39582, 39591, 39593, 39596, 39598, 39601, 39604, 39606, 39608, 39610, 39612, 39614, 39616, 39619, 39622, 39624, 39626, 39628, 39630, 39633, 39635, 39638, 39640, 39642, 39644, 39649, 39656, 39661, 39664, 39667, 39671, 39674, 39676, 39683, 39688, 39694, 39700, 39708, 39717, 39719, 39722, 39724, 39727, 39730, 39732, 39736, 39741, 39744, 39746, 39751, 39758, 39760, 39765, 39770, 39776, 39782, 39792, 39806, 39813, 39822, 39824, 39827, 39829, 39831, 39833, 39838, 39841, 39844, 39853, 39855, 39858, 39860, 39862, 39864, 39869, 39874, 39899, 40017, 40020, 40022, 40024, 40028, 40030, 40032, 40034, 40036, 40038, 40040, 40042, 40044, 40051, 40057, 40067, 40069, 40075, 40077, 40079, 40081, 40083, 40085, 40087, 40095, 40097, 40101, 40103, 40105, 40109, 40112, 40114, 40116, 40118, 40126, 40130, 40132, 40137, 40142, 40144, 40146, 40151, 40154, 40158, 40160, 40163, 40165, 40168, 40170, 40176, 40188, 40190, 40193, 40195, 40197, 40199, 40202, 40205, 40208, 40210, 40212, 40214, 40217, 40219, 40222, 40224, 40226, 40228, 40233, 40236, 40238, 40240, 40243, 40245, 40248, 40250, 40252, 40254, 40257, 40259, 40263, 40279, 40282, 40285, 40289, 40292, 40295, 40297, 40302, 40305, 40308, 40311, 40316, 40323, 40326, 40331, 40335, 40340, 40345, 40353, 40355, 40358, 40360, 40362, 40367, 40372, 40379, 40382, 40387, 40396, 40398, 40403, 40408, 40411, 40413, 40418, 40420, 40422, 40425, 40431, 40433, 40438, 40444, 40448, 40450, 40454, 40564, 40566, 40570, 40572, 40574, 40578, 40580, 40582, 40587, 40589, 40590, 40624, 40626, 40634, 40642, 40644, 40646, 40655, 40658, 40667, 40669, 40679, 40697, 40700, 40703, 40708, 40736, 40738, 40750, 40752, 40758, 40779, 40781, 40784, 40787, 40789, 40795, 40797, 40801, 40804, 40807, 40809, 40821, 40825, 40828, 40831, 40833, 40839, 40842, 40845, 40848, 40852, 40856, 40859, 40866, 40876, 40882, 40884, 40889, 40891, 40894, 40898, 40900, 40902, 40912, 40915, 40917, 40920, 40925, 40928, 40931, 40936, 40938, 40941, 40946, 40948, 40951, 40953, 40956, 40960, 40962, 40965, 40967, 40970, 40974, 40978, 40983, 40985, 40987, 40992, 40997, 41002, 41005, 41115, 41119, 41127, 41141, 41169, 41174, 41179, 41181, 41184, 41187, 41190, 41192, 41194, 41196, 41201, 41203, 41205, 41207, 41209, 41211, 41213, 41215, 41217, 41227, 41229, 41231, 41236, 41238, 41243, 41247, 41255, 41257, 41261, 41271, 41275, 41281, 41283, 41301, 41313, 41323, 41327, 41340, 41344, 41361, 41376, 41379, 41390, 41394, 41399, 41408, 41417, 41421, 41430, 41455, 41458, 41461, 41476, 41485, 41498, 41500, 41513, 41515, 41523, 41537, 41539, 41552, 41557, 41567, 41571, 41573, 41691, 41697, 41705, 41711, 41714, 41721, 41725, 41733, 41735, 41737, 41743, 41747, 41749, 41755, 41759, 41768, 41772, 41776, 41809, 41812, 41814, 41818, 41823, 41826, 41831, 41846, 41856, 41872, 41885, 41893, 41901, 41914, 41941, 41945, 41990, 42011, 42017, 42021, 42026, 42045, 42047, 42050, 42056, 42058, 42063, 42068, 42071, 42073, 42076, 42078, 42081, 42083, 42086, 42088, 42096, 42103, 42106, 42111, 42114, 42119, 42122, 42124, 42129, 42137, 42142, 42152, 42154, 42160, 42283, 42293, 42294, 42299, 42303, 42308, 42310, 42314, 42316, 42322, 42326, 42328, 42332, 42334, 42340, 42348, 42362, 42364, 42367, 42369, 42372, 42377, 42396, 42403, 42410, 42417, 42420, 42422, 42432, 42440, 42465, 42475, 42477, 42486, 42491, 42494, 42499, 42504, 42508, 42515, 42534, 42536, 42544, 42546, 42561, 42564, 42625, 43076, 43079, 43105, 43109, 43112, 43114, 43119, 43121, 43126, 43133, 43140, 43147, 43162, 43166, 43169, 43241, 46598, 46683, 46713, 46729, 46771, 47102) 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: Philaster

Afterpiece Title: No One's Enemy but His Own

Dance: II: The Provencale, as17740928; III: The Merry Sailors-Aldridge [See17731007]; End: The Vintage Festival, as17741007

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: No One's Enemy but His Own

Dance: II: The Reel-Aldridge, Miss Valois, Miss Besford. [See17711030.

Performances

Mainpiece Title: The Jovial Crew

Afterpiece Title: No One's Enemy but His Own

Dance: II: The Provencale, as17740928; End: The Reel, as17741028

Performances

Mainpiece Title: The Jovial Crew

Afterpiece Title: Cross Purposes

Cast
Role: Chapeau Actor: Lee Lewes

Dance: End Opera: The Merry Sailors, as17741026

Performances

Mainpiece Title: King Richard Iii

Cast
Role: Richard Actor: Lee

Afterpiece Title: No One's Enemy but His Own

Dance: End: The Merry Sailors, as17741026

Performances

Mainpiece Title: She Stoops To Conquer

Afterpiece Title: No One's Enemy but His Own

Dance: I: The Lamplighters-Aldridge, Miss Valois [see17731207]; End Comedy: The Vintage Festival, as17741007

Performances

Mainpiece Title: Elfrida

Afterpiece Title: No One's Enemy but His Own

Dance: End Poem: The Vintage Festival, as17741007

Performances

Mainpiece Title: The Provok'd Husband

Cast
Role: Basset Actor: Lee Lewes

Afterpiece Title: Comus

Performances

Mainpiece Title: King Henry Viii

Afterpiece Title: Cross Purposes

Cast
Role: Chapeau Actor: Lee Lewes

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Cross Purposes

Cast
Role: Chapeau Actor: Lee Lewes

Dance: II: The Reel, as17741028

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: The Country Madcap

Cast
Role: Bawble Actor: Lee Lewes

Dance: End: A New Comic Dance, call'd The Portraits A@la@Mode-Dagueville, Helme, Sga Vidini

Performances

Mainpiece Title: Artaxerxes

Afterpiece Title: The Romance of An Hour

Cast
Role: Bussora Actor: Lee Lewes
Role: Kelly Actor: Lee

Dance: I: The Vintage Festival, as17741007; End Opera: The Irish Lilt-Aldridge, Miss Valois. [See17731005]

Performances

Mainpiece Title: Zara

Cast
Role: Osman Actor: Lee, first time

Afterpiece Title: The Romance of an Hour

Cast
Role: Bussora Actor: Lee Lewes
Role: Kelly Actor: Lee

Dance: End Tragedy: The Vintage Festival, as17741007

Performances

Mainpiece Title: The Maid Of The Mill

Afterpiece Title: The Romance of an Hour

Cast
Role: Bussora Actor: Lee Lewes
Role: Kelly Actor: Lee

Dance: End Opera: A Comic Dance-Aldridge, Mrs Stephens. [See17711009.

Performances

Mainpiece Title: Lady Jane Grey

Afterpiece Title: The Romance of an Hour

Cast
Role: Bussora Actor: Lee Lewes
Role: Kelly Actor: Lee

Dance: End Tragedy: A Comic Dance, call'd Rural Merriment-Aldridge, Mrs Stephens