SELECT * FROM london_stages WHERE eventid IN (596, 1037, 1053, 1159, 1622, 1794, 2243, 4026, 4919, 5193, 5266, 5359, 5413, 5430, 5521, 6087, 6139, 7412, 7938, 8689, 8777, 9213, 9272, 9620, 9634, 9956, 9976, 10048, 10282, 10456, 10604, 10669, 10837, 11272, 11417, 11755, 12652, 12736, 14852, 15717, 15718, 15939, 15991, 16013, 16452, 17622, 17626, 17635, 17637, 17641, 17644, 17648, 17652, 17656, 17659, 17662, 17665, 17669, 17672, 17675, 17678, 17681, 17684, 17688, 17691, 17695, 17699, 17701, 17704, 17708, 17711, 17715, 17719, 17722, 17725, 17729, 17732, 17736, 17783, 17786, 17880, 17885, 17927, 17999, 18190, 18193, 18196, 18377, 18380, 18383, 19146, 19336, 19340, 19342, 19344, 19364, 19585, 19840, 19858, 19860, 19861, 19863, 19865, 19867, 19868, 19871, 19885, 19890, 19897, 19899, 19902, 19903, 19906, 19908, 19911, 19913, 19916, 19918, 19921, 19951, 19954, 20048, 20062, 20292, 20295, 20311, 20326, 20329, 20347, 20398, 20415, 20421, 20438, 20461, 20488, 20495, 20499, 20502, 20832, 20835, 20838, 20841, 20845, 20875, 20935, 20938, 20945, 20952, 20967, 20980, 21025, 21080, 21112, 21116, 21126, 21137, 21285, 21477, 21812, 22484, 23114, 23293, 24205, 25307, 26145, 26312, 31083, 31088, 31090, 31124, 31737, 35647, 35650, 35653, 35656, 35662, 35665, 35669, 35672, 35674, 35678, 35681, 35686, 35688, 35696, 35702, 35707, 35718, 35788, 35802, 35813, 35865, 36710, 36714, 36756, 37044, 37595, 37600, 37603, 37612, 37614, 37617, 37619, 37636, 37644, 37647, 37652, 37666, 37676, 40931, 40951, 40956, 40960, 40970, 41179, 41724, 41728, 41732, 41736, 41758, 41762, 41773, 41822, 41862, 41922, 42707, 43231, 43524, 43526, 43530, 43538, 43544, 43552, 43556, 43560, 43567, 43569, 43586, 43598, 43609, 43658, 43800, 43853, 43875, 43882, 44065, 44069, 44079, 44185, 44189, 44292, 44371, 44453, 44606, 44626, 44627, 44629, 44631, 44633, 44635, 44637, 44642, 44644, 44646, 44651, 44663, 44665, 44669, 44675, 44687, 44689, 44693, 44699, 44704, 44720, 44730, 44736, 44745, 44749, 44761, 44765, 44779, 44795, 44802, 44809, 44812, 44823, 44835, 44843, 44862, 44873, 44886, 45177, 45185, 45189, 45199, 45215, 45223, 45233, 45235, 45441, 45450, 45458, 45468, 45489, 45518, 45543, 45592, 45594, 45603, 45718, 45730, 45804, 45898, 45938, 46144, 46149, 46155, 46161, 46167, 46172, 46177, 46182, 46183, 46184, 46196, 46206, 46208, 46209, 46211, 46214, 46217, 46219, 46221, 46228, 46229, 46230, 46231, 46232, 46233, 46234, 46236, 46238, 46239, 46240, 46241, 46248, 46249, 46250, 46254, 46256, 46258, 46314, 46326, 46646, 46682, 47208, 47516, 47528, 47534, 47538, 47542, 47546, 47550, 47554, 47556, 47569, 47574, 47579, 47583, 47585, 47592, 47728, 47758, 47781, 47791, 47804, 47829, 48021, 48054, 48065, 48108, 48114, 48128, 48175, 48215, 48256, 49575, 49578, 49580, 49589, 49592, 49594, 49602, 49612, 49622, 49627, 49635, 49662, 49785, 49794, 49805, 49865, 49900, 49902, 49905, 49907, 49910, 49912, 49915, 49917, 49919, 49921, 49924, 49926, 49929, 49931, 49933, 49935, 49938, 49940, 49943, 49945, 49947, 49949, 49952, 49954, 49957, 49959, 49961, 49966, 49968, 49971, 49978, 49992, 50099, 50113, 50116, 50163, 50170, 50193, 50195, 50203, 50367, 50369, 50375, 50379, 50381, 50390, 50397, 50407, 50421, 50448, 50525, 50530, 50555, 50663, 50694, 50703, 50983, 50985, 51280, 51327, 51378, 51381, 51392, 51402, 51407, 51408, 51421, 51430, 51453, 51992, 51997, 51999, 52000, 52001, 52002, 52005, 52007, 52008, 52012, 52017, 52022, 52023, 52028, 52030, 52044, 52046, 52049, 52050, 52051, 52053, 52419, 52422, 52426, 52427, 52428, 52431, 52433, 52436, 52441, 52516, 52537, 52542, 52550, 52551, 52569, 52574, 52575, 52594, 52600, 52603, 52607, 52608, 52613) 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: De Montfort

Cast
Role: Grimbald Actor: Caulfield

Afterpiece Title: Of Age To-morrow

Song: As18000503

Performances

Mainpiece Title: De Montfort

Cast
Role: Grimbald Actor: Caulfield

Afterpiece Title: Of Age To-morrow

Song: As18000503

Performances

Mainpiece Title: Blue Devils

Cast
Role: Megrim Actor: Fawcett

Afterpiece Title: The Jew

Afterpiece Title: The Castle of Sorrento

Song: 3rd piece: Chorus-Kenrick, Little, Willoughby, Dibble, Aylmer

Performances

Mainpiece Title: The Jew

Cast
Role: Megrim Actor: Fawcett

Afterpiece Title: The Agreeable Surprise

Performances

Mainpiece Title: Blue Devils

Cast
Role: Megrim Actor: Fawcett

Afterpiece Title: The Jew and the Doctor

Afterpiece Title: Obi; or, Three-Finger'd Jack

Performances

Mainpiece Title: The Jew

Cast
Role: Megrim Actor: Fawcett

Afterpiece Title: Obi

Performances

Mainpiece Title: The Agreeable Surprise

Cast
Role: Megrim Actor: Fawcett

Afterpiece Title: Fortune's Frolick

Afterpiece Title: Obi

Performances

Mainpiece Title: Blue Devils

Cast
Role: Megrim Actor: Fawcett

Afterpiece Title: The Point of Honour

Afterpiece Title: The Village Lawyer

Performances

Mainpiece Title: The Jew

Cast
Role: Megrim Actor: Fawcett

Afterpiece Title: Obi

Performances

Mainpiece Title: The Agreeable Surprise

Cast
Role: Megrim Actor: Fawcett

Afterpiece Title: Fortune's Frolick

Afterpiece Title: Obi

Performances

Mainpiece Title: Blue Devils

Cast
Role: Megrim Actor: Fawcett

Afterpiece Title: The Point of Honour

Afterpiece Title: The Castle of Sorrento

Song: As18000614

Performances

Mainpiece Title: The Point Of Honour

Cast
Role: Megrim Actor: Fawcett

Afterpiece Title: Obi

Performances

Mainpiece Title: The Point Of Honour

Cast
Role: Megrim Actor: Fawcett

Afterpiece Title: The Review; or, The Wags of Windsor

Performances

Mainpiece Title: The Point Of Honour

Cast
Role: Megrim Actor: Fawcett

Afterpiece Title: The Review

Performances

Mainpiece Title: The Jew

Cast
Role: Megrim Actor: Fawcett

Afterpiece Title: The Review

Performances

Mainpiece Title: Fortune's Frolick

Cast
Role: Megrim Actor: Fawcett

Afterpiece Title: The Review

Afterpiece Title: Obi