SELECT * FROM london_stages WHERE eventid IN (41851, 41853, 41856, 41858, 41861, 41863, 41866, 41868, 41870, 41872, 41875, 41877, 41880, 41882, 41885, 41887, 41890, 41893, 41896, 41898, 41901, 41903, 41906, 41909, 41912, 41914, 41916, 41918, 41921, 41923, 41926, 41929, 41931, 41934, 41936, 41939, 41941, 41963, 41980, 41984, 41987, 41994, 41998, 42001, 42003, 42007, 42011, 42014, 42021, 42026, 42040, 42045, 42047, 42052, 42058, 42063, 42066, 42073, 42078, 42081, 42098, 42101, 42111, 42134, 42142, 42157, 42187, 42194, 42198, 42222, 42226, 42227, 42243, 42244, 42245, 42246, 42247, 42249, 42250, 42253, 42255, 42256, 42258, 42259, 42260, 42261, 42262, 42263, 42264, 42265, 42266, 42267, 42268, 42270, 42271, 42272, 42302, 42303, 42306, 42312, 42318, 42320, 42324, 42330, 42338, 42354, 42357, 42386, 42389, 42392, 42394, 42398, 42401, 42406, 42408, 42415, 42417, 42422, 42430, 42437, 42442, 42445, 42448, 42450, 42452, 42455, 42463, 42472, 42496, 42499, 42501, 42504, 42506, 42508, 42510, 42513, 42530, 42534, 42569, 42597, 42668, 42670, 42682, 42694, 42714, 42735, 42743, 42886, 43079, 43081, 43084, 43093, 43095, 43098, 43104, 43115, 43127, 43143, 43155, 43167, 43195, 43200, 43204, 43229, 43232, 43234, 43237, 43242, 43247, 43253, 43257, 43260, 43263, 43268, 43280, 43283, 43288, 43295, 43298, 43308, 43313, 43321, 43436, 43439, 43446, 43453, 43460, 43462, 43465, 43468, 43473, 43490, 43494, 43498, 43502, 43508, 43512, 43514, 43517, 43519, 43523, 43525, 43527, 43531, 43535, 43537, 43539, 43541, 43543, 43547, 43549, 43551, 43553, 43557, 43561, 43566, 43585, 43587, 43590, 43592, 43594, 43596, 43599, 43601, 43604, 43606, 43608, 43610, 43613, 43615, 43618, 43620, 43624, 43627, 43629, 43631, 43633, 43636, 43638, 43641, 43644, 43647, 43649, 43651, 43653, 43656, 43666, 43678, 43696, 43715, 43718, 43729, 43740, 43756, 43765, 43770, 43776, 43781, 43784, 43789, 43798, 43803, 43806, 43809, 43815, 43824, 43829, 43832, 43836, 43841, 43868, 43873, 43876, 43881, 43883, 43888, 43893, 43896, 44031, 44037, 44039, 44051, 44059, 44078, 44081, 44109, 44121, 44123, 44129, 44133, 44135, 44141, 44167, 44170, 44172, 44174, 44176, 44178, 44180, 44182, 44184, 44186, 44188, 44190, 44194, 44196, 44198, 44200, 44202, 44204, 44206, 44208, 44210, 44212, 44214, 44216, 44218, 44221, 44223, 44225, 44227, 44237, 44239, 44244, 44258, 44272, 44279, 44286, 44309, 44319, 44322, 44324, 44328, 44335, 44337, 44348, 44354, 44367, 44372, 44374, 44377, 44384, 44392, 44394, 44397, 44409, 44412, 44414, 44424, 44427, 44429, 44432, 44437, 44439, 44442, 44457, 44459, 44462, 44469, 44608, 44616, 44618, 44620, 44621, 44623, 44625, 44628, 44630, 44632, 44634, 44636, 44648, 44650, 44652, 44656, 44658, 44660, 44664, 44670, 44674, 44676, 44678, 44680, 44698, 44710, 44712, 44715, 44717, 44719, 44721, 44723, 44726, 44728, 44731, 44733, 44735, 44737, 44740, 44743, 44746, 44748, 44750, 44752, 44755, 44757, 44760, 44762, 44764, 44766, 44769, 44771, 44774, 44776, 44783, 44787, 44794, 44803, 44805, 44808, 44817, 44819, 44824, 44834, 44847, 44849, 44853, 44860, 44863, 44867, 44874, 44876, 44884, 44897, 44903, 44907, 44909, 44913, 44915, 44917, 44925, 44929, 44934, 44936, 44946, 44952, 44957, 44969, 44971, 44975, 44980, 44986, 44995, 45004, 45007, 45011, 45013, 45016, 45020, 45022, 45025, 45030, 45037, 45039, 45041, 45047, 45137, 45139, 45141, 45143, 45147, 45150, 45152, 45154, 45166, 45169, 45174, 45176, 45180, 45184, 45186, 45188, 45190, 45192, 45196, 45198, 45200, 45204, 45208, 45210, 45212, 45214, 45216, 45220, 45222, 45228, 45232, 45236, 45238, 45240, 45244, 45246, 45248, 45250, 45252, 45255, 45257, 45260, 45262, 45264, 45269, 45274, 45276, 45307, 45330, 45333, 45342, 45344, 45347, 45349, 45352, 45354, 45356, 45361, 45365, 45386, 45390, 45394, 45399, 45403, 45410, 45412, 45416, 45423, 45429, 45436, 45438, 45442, 45446, 45449, 45451, 45461, 45464, 45469, 45472, 45475, 45477, 45480, 45482, 45487, 45492, 45502, 45511, 45515, 45517, 45519, 45521, 45524, 45526, 45529, 45534, 45539, 45542, 45544, 45547, 45549, 45554, 45557, 45559, 45562, 45564, 45567, 45569, 45572, 45574, 45577, 45582, 45584, 45587, 45589, 45591, 45696, 45702, 45706, 45711, 45714, 45717, 45726, 45727, 45731, 45733, 45735, 45738, 45740, 45742, 45748, 45750, 45756, 45767, 45771, 45775, 45787, 45791, 45793, 45797, 45805, 45807, 45809, 45811, 45813, 45815, 45817, 45819, 45827, 45829, 45831, 45833, 45840, 45842, 45850, 45854, 45858, 45860, 45876, 45880, 45883, 45885, 45894, 45897, 45904, 45906, 45909, 45920, 45923, 45934, 45937, 45939, 45942, 45944, 45948, 45954, 45958, 45962, 45965, 45967, 45971, 45975, 45978, 45980, 45984, 45988, 45991, 45993, 45997, 46002, 46005, 46007, 46011, 46018, 46024, 46038, 46040, 46047, 46055, 46060, 46063, 46068, 46075, 46078, 46088, 46093, 46095, 46100, 46103, 46106, 46118, 46127, 46130, 46133, 46137, 46143, 46151, 46154, 46157, 46160, 46163, 46171, 46176, 46178, 46195, 46203, 46262, 46266, 46269, 46271, 46273, 46279, 46284, 46292, 46294, 46297, 46299, 46301, 46305, 46307, 46309, 46311, 46317, 46321, 46323, 46325, 46336, 46345, 46357, 46359, 46361, 46363, 46369, 46373, 46383, 46389, 46393, 46397, 46399, 46401, 46403, 46405, 46407, 46409, 46411, 46413, 46415, 46417, 46419, 46421, 46423, 46425, 46427, 46429, 46431, 46433, 46436, 46438, 46441, 46443, 46446, 46448, 46452, 46455, 46457, 46460, 46462, 46464, 46466, 46469, 46471, 46474, 46476, 46478, 46481, 46483, 46486, 46492, 46495, 46497, 46500, 46506, 46509, 46511, 46515, 46519, 46522, 46524, 46529, 46536, 46538, 46543, 46550, 46552, 46557, 46561, 46564, 46566, 46578, 46580, 46585, 46590, 46593, 46600, 46602, 46604, 46607, 46609, 46612, 46614, 46619, 46622, 46627, 46632, 46634, 46637, 46639, 46642, 46644, 46654, 46657, 46659, 46661, 46663, 46666, 46671, 46676, 46681, 46686, 46688, 46691, 46695, 46697, 46700, 46705, 46708, 46711, 46713, 46716, 46718, 46721, 46723, 46725, 46726, 46728, 46729, 46731, 46732, 46734, 47431, 47437, 47440, 47441, 47444, 47446, 47449, 47451, 47454, 47456, 47458, 47459, 47462, 47464, 47466, 47467, 47470, 47474, 47475, 47478, 47482, 47487, 47489, 47491, 47493, 47501, 47503, 47505, 47511, 47517, 47521, 47523, 47525, 47527, 47529, 47533, 47535, 47537, 47541, 47543, 47545, 47549, 47551, 47555, 47557, 47559, 47561, 47564, 47568, 47570, 47572, 47575, 47577, 47582, 47584, 47586, 47589, 47591, 47593, 47595, 47597, 47600, 47603, 47605, 47607, 47609, 47611, 47614, 47616, 47619, 47621, 47623, 47625, 47628, 47631, 47633, 47635, 47637, 47639, 47641, 47649, 47651, 47665, 47674, 47678, 47688, 47690, 47693, 47700, 47704, 47707, 47709, 47714, 47722, 47724, 47729, 47754, 47769, 47779, 47787, 47794, 47803, 47808, 47815, 47818, 47825, 47830, 47848, 47853, 47855, 47860, 47863, 47865, 47869, 47874, 47877, 47879, 47885, 47890, 47896, 47997, 47999, 48000, 48004, 48006, 48012, 48015, 48029, 48032, 48038, 48043, 48047, 48049, 48062, 48080, 48090, 48103, 48109, 48127, 48129, 48133, 48135, 48139, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48168, 48170, 48172, 48174, 48178, 48180, 48182, 48199, 48264, 48303, 48306, 48308, 48311, 48322, 48325, 48327, 48329, 48331, 48336, 48339, 48347, 48352, 48354, 48358, 48361, 48363, 48366, 48368, 48370, 48375, 48377, 48380, 48382, 48384, 48386, 48389, 48391, 48394, 48396, 48398, 48402, 48404, 48407, 48409, 48411, 48413, 48418, 48425, 48430, 48432, 48435, 48437, 48447) 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 Maid Of The Mill

Cast
Role: Fairfield Actor: Darley

Afterpiece Title: The Midnight Hour

Performances

Mainpiece Title: Werter

Afterpiece Title: Harlequin's Chaplet

Dance: In afterpiece: Byrne, the two Miss Simonets

Song: In III: Epithalamium. Vocal Parts-Darley, Cubitt, Mrs Mountain, Mrs Martyr

Performances

Mainpiece Title: Inkle And Yarico

Cast
Role: Mate Actor: Darley

Afterpiece Title: Harlequin's Chaplet

Dance: In afterpiece: As17891221; End II: Negro Dance, as17891013

Performances

Mainpiece Title: The Dramatist

Afterpiece Title: Harlequin's Chaplet

Dance: As17891221

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: Harlequin's Chaplet

Dance: As17891221

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Harlequin's Chaplet

Dance: As17891221

Song: As17891109

Performances

Mainpiece Title: Fontainbleau

Afterpiece Title: Harlequin's Chaplet

Dance: As17891221

Performances

Mainpiece Title: All In The Wrong

Afterpiece Title: Harlequin's Chaplet

Dance: As17891221

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: Harlequin's Chaplet

Dance: In afterpiece: Byrne, Miss Simonet

Performances

Mainpiece Title: The Dramatist

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: King Lear

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: The Maid Of The Mill

Cast
Role: Fairfield Actor: Darley

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: The Farmer

Afterpiece Title: The Follies of a Day

Cast
Role: Priest Actor: Darley

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: The Clandestine Marriage

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: The Dramatist

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: King Lear

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: The Highland Reel

Afterpiece Title: The Midnight Hour

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Song: In III: song-Duffey

Performances

Mainpiece Title: The Dramatist

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: Harlequin's Chaplet

Dance: In afterpiece: As17891231.; End II: Divertissement, as17891002

Performances

Mainpiece Title: King Lear

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Song: As17900113