SELECT * FROM london_stages WHERE eventid IN (37160, 37162, 37163, 37165, 37167, 37168, 37170, 37172, 37173, 37175, 37177, 37178, 37179, 37180, 37183, 37186, 37190, 37191, 37193, 37199, 37201, 37203, 37204, 37207, 37210, 37787, 37795, 37799, 37823, 37835, 37845, 37847, 37849, 37852, 37854, 37858, 37860, 37862, 37866, 37868, 37875, 37878, 37884, 37891, 37900, 37902, 37911, 37919, 37943, 37945, 37954, 37960, 37969, 37985, 37994, 38018, 38047, 38070, 38102, 38105, 38121, 38128, 38133, 38138, 38148, 38153, 38156, 38165, 38177, 38180, 38188, 38190, 38192, 38197, 38202, 38205, 38219, 38242, 38320, 38330, 38334, 38336, 38347, 38349, 38351, 38355, 38357, 38367, 38376, 38378, 38381, 38385, 38392, 38396, 38410, 38417, 38427, 38434, 38448, 38464, 38471, 38521, 38530, 38568, 38619, 38624, 38634, 38639, 38642, 38656, 38680, 38684, 38687, 38689, 38692, 38703, 38719, 38726, 38729, 38741, 38745, 38748, 38750, 38768, 38860, 38867, 38885, 38899, 38901, 38903, 38904, 38906, 38908, 38910, 38912, 38914, 38916, 38918, 38920, 38924, 38926, 38928, 38934, 38937, 38939, 38944, 38946, 38948, 38953, 38960, 38970, 38976, 38982, 39022, 39024, 39078, 39083, 39093, 39095, 39104, 39107, 39123, 39135, 39137, 39142, 39146, 39149, 39151, 39156, 39160, 39181, 39184, 39202, 39205, 39208, 39213, 39216, 39219, 39225, 39228, 39230, 39239, 39245, 39253, 39257, 39260, 39265, 39268, 39288, 39291, 39293, 39296, 39298, 39301, 39303, 39306, 39312, 39315, 39317, 39320, 39322, 39324, 39326, 39329, 39331, 39335, 39339, 39341, 39343, 39345, 39346, 39349, 39453, 39455, 39457, 39468, 39470, 39472, 39474, 39476, 39478, 39480, 39482, 39484, 39489, 39493, 39495, 39497, 39499, 39502, 39504, 39506, 39511, 39516, 39520, 39522, 39525, 39530, 39532, 39534, 39536, 39539, 39544, 39546, 39548, 39550, 39553, 39555, 39558, 39562, 39564, 39569, 39572, 39576, 39578, 39581, 39583, 39586, 39590, 39592, 39595, 39597, 39605, 39607, 39609, 39611, 39615, 39623, 39627, 39634, 39639, 39643, 39646, 39648, 39651, 39653, 39655, 39660, 39663, 39666, 39670, 39673, 39680, 39682, 39690, 39693, 39697, 39699, 39702, 39704, 39711, 39716, 39718, 39723, 39731, 39740, 39743, 39745, 39754, 39759, 39764, 39769, 39772, 39775, 39781, 39786, 39802, 39807, 39812, 39818, 39821, 39826, 39830, 39832, 39837, 39840, 39849, 39852, 39857, 39859, 39861, 39863, 39873, 39875, 39882, 39883, 39886, 39888, 39893, 39896, 39902, 39905, 39907, 39909, 39912, 39915, 39917, 39925, 39935, 39937, 39940, 39947, 39951, 39953, 39954, 39957, 39960, 39961, 39962, 39963, 39964, 39966, 39968, 39970, 39971, 39972, 39973, 39975, 39977, 39978, 39979, 39981, 39982, 39984, 39985, 39986, 39987, 39988, 39989, 39990, 39992, 39995, 39996, 39998, 39999, 40000, 40001, 40002, 40004, 40005, 40009, 40011, 40012, 40013, 40014, 40015, 40019, 40021, 40023, 40025, 40027, 40033, 40037, 40041, 40043, 40045, 40047, 40049, 40050, 40052, 40054, 40056, 40058, 40060, 40062, 40064, 40066, 40068, 40070, 40072, 40074, 40076, 40078, 40080, 40082, 40084, 40086, 40088, 40090, 40092, 40094, 40096, 40098, 40100, 40102, 40104, 40106, 40108, 40111, 40113, 40115, 40117, 40127, 40129, 40131, 40134, 40139, 40141, 40148, 40150, 40155, 40162, 40164, 40169, 40172, 40175, 40178, 40180, 40184, 40192, 40194, 40201, 40204, 40207, 40209, 40223, 40225, 40232, 40237, 40249, 40253, 40256, 40258, 40262, 40264, 40266, 40269, 40275, 40278, 40288, 40294, 40301, 40319, 40322, 40330, 40334, 40337, 40339, 40344, 40354, 40357, 40359, 40366, 40368, 40371, 40373, 40376, 40381, 40388, 40395, 40402, 40405, 40407, 40410, 40415, 40417, 40421, 40424, 40430, 40432, 40445, 40447, 40453, 40458, 40460, 40462, 40463, 40465, 40466, 40467, 40469, 40471, 40472, 40474, 40476, 40478, 40480, 40483, 40484, 40486, 40488, 40491, 40492, 40495, 40496, 40498, 40499, 40500, 40501, 40503, 40504, 40505, 40506, 40511, 40514, 40515, 40518, 40519, 40521, 40525, 40526, 40527, 40528, 40529, 40530, 40533, 40534, 40536, 40537, 40539, 40540, 40541, 40542, 40543, 40544, 40545, 40546, 40548, 40549, 40550, 40552, 40553, 40555, 40556, 40559, 40560, 40562, 40605, 40607, 40609, 40610, 40612, 40614, 40618, 40621, 40623, 40625, 40627, 40635, 40641, 40643, 40645, 40648, 40650, 40652, 40654, 40657, 40659, 40662, 40664, 40666, 40668, 40671, 40673, 40676, 40678, 40680, 40690, 40702, 40705, 40713, 40718, 40720, 40722, 40735, 40742, 40751, 40757, 40766, 40771, 40774, 40776, 40778, 40780, 40783, 40788, 40791, 40800, 40803, 40806, 40808, 40812, 40818, 40824, 40827, 40830, 40832, 40838, 40844, 40851, 40855, 40858, 40865, 40872, 40875, 40888, 40890, 40893, 40899, 40904, 40906, 40909, 40914, 40916, 40919, 40924, 40927, 40930, 40932, 40935, 40937, 40942, 40947, 40950, 40952, 40955, 40964, 40971, 40977, 40984, 40986, 40988, 40998, 41003, 41006, 41012, 41014, 41015, 41017, 41019, 41020, 41022, 41023, 41026, 41027, 41028, 41030, 41031, 41033, 41034, 41035, 41036, 41038, 41039, 41041, 41043, 41044, 41045, 41048, 41049, 41050, 41052, 41053, 41055, 41056, 41058, 41059, 41061, 41062, 41064, 41065, 41066, 41068, 41069, 41072, 41073, 41074, 41075, 41076, 41077, 41078, 41079, 41080, 41081, 41082, 41084, 41086, 41089, 41090, 41091, 41092, 41093, 41094, 41095, 41096, 41097, 41098, 41099, 41100, 41101, 41102, 41103, 41104, 41105, 41106, 41107, 41108, 41109, 41110, 41111, 41112, 41113, 41114, 41121, 41124, 41128, 41134, 41144, 41147, 41149, 41151, 41153, 41157, 41159, 41161, 41180, 41183, 41198, 41200, 41202, 41204, 41208, 41210, 41216, 41226, 41228, 41249, 41251, 41254, 41256, 41258, 41260, 41270, 41272, 41284, 41294, 41298, 41303, 41305, 41312, 41314, 41324, 41326, 41334, 41337, 41341, 41358, 41375, 41389, 41393, 41401, 41414, 41420, 41424, 41427, 41429, 41434, 41450, 41454, 41457, 41470, 41473, 41475, 41479, 41484, 41490, 41495, 41499, 41502, 41507, 41509, 41512, 41514, 41517, 41519, 41522, 41524, 41528, 41531, 41533, 41538, 41541, 41546, 41548, 41551, 41558, 41561, 41566, 41568, 41572, 41575, 41577, 41579, 41580, 41582, 41585, 41586, 41588, 41589, 41590, 41592, 41594, 41595, 41597, 41598, 41600, 41601, 41606, 41610, 41615, 41616, 41617, 41618, 41623, 41625, 41626, 41630, 41631, 41632, 41634, 41636, 41639, 41641, 41644, 41645, 41646, 41648, 41650, 41651, 41652, 41661, 41664, 41665, 41667, 41668, 41679, 41687, 41696, 41698, 41706, 41708, 41712, 41717, 41724, 41726, 41732, 41734, 41738, 41746, 41748, 41767, 41769, 41771, 41785, 41787, 41792, 41811, 41813, 41822, 41832, 41860, 41862, 41865, 41871, 41897, 41925, 41949, 41966, 42013, 42016, 42025, 42039, 42049, 42065, 42067, 42082, 42090, 42092, 42123, 42126, 42136, 42148, 42151, 42153, 42164, 42166, 42273, 42275, 42281, 42284, 42286, 42288, 42290, 42292, 42295, 42301, 42307, 42309, 42311, 45148, 45149, 45153, 45160, 45163, 45175, 45177, 45185, 45187, 45189, 45195, 45199, 45203, 45205, 45207, 45211, 45215, 45217, 45221, 45223, 45225, 45229, 45231, 45233, 45239, 45243, 45247, 45249, 45254, 45259, 45263, 45282, 45284, 45286, 45288, 45290, 45294, 45296, 45299, 45304, 45306, 45309, 45311, 45313, 45318, 45320, 45323, 45327, 45329, 45332, 45334, 45337, 45339, 45341, 45343, 45346, 45348, 45355, 45368, 45371, 45383, 45389, 45406, 45409, 45419, 45422, 45435, 45437, 45439, 45441, 45443, 45453, 45455, 45465, 45479, 45486, 45489, 45494, 45499, 45503, 45508, 45536, 45541, 45543, 45568, 45594, 45710, 45712, 45715, 45728, 45736, 45737, 45755, 45760, 45762, 45768, 45770, 45788, 45796, 45800, 45804, 45806, 45808, 45820, 45822, 45826, 45828, 45832, 45834, 45841, 45845, 45851, 45853, 45859, 45865, 45870, 45877, 45893, 45896, 45910, 45913, 45915, 45917, 45922, 45927, 45936, 45943, 45945, 45979, 45996, 46046, 46062, 46079, 46092, 46097, 46111, 46139, 46145, 46150, 46272, 46276, 46280, 46283, 46290, 46291, 46296, 46300, 46304, 46310, 46316, 46320, 46332, 46344, 46346, 46352, 46358, 46380, 46388, 46392, 46412, 46414, 46416, 46418, 46420, 46424, 46426, 46428, 46432, 46437, 46440, 46442, 46447, 46451, 46456, 46461, 46463, 46465, 46532, 46546, 46592, 46641, 46653) 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 Haunted Tower

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Macaroni Actor: Lamash

Dance: As17891204

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Macaroni Actor: Lamash

Song: As17891117

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Macaroni Actor: Lamash

Dance: As17891204

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Macaroni Actor: Lamash

Dance: As17891204

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Macaroni Actor: Lamash

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Macaroni Actor: Lamash

Dance: As17891204

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Macaroni Actor: Lamash

Dance: As17891204

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Macaroni Actor: Lamash

Dance: As17891204

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Macaroni Actor: Lamash

Song: As17891117

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Macaroni Actor: Lamash

Dance: As17891204

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Macaroni Actor: Lamash

Dance: As17891204

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Macaroni Actor: Lamash

Dance: As17891204

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Deaf Lover

Cast
Role: Canteen Actor: Lamash

Dance: As17891204

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Macaroni Actor: Lamash

Dance: As17891204

Performances

Mainpiece Title: Know Your Own Mind

Cast
Role: Sir Harry Lovewit Actor: Lamash

Afterpiece Title: The Island of St

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Deaf Lover

Cast
Role: Canteen Actor: Lamash

Dance: II: As17891204; End: The Irish Bird Catchers-the young D'Egvilles, Miss Blanchet, Miss DeCamp

Performances

Mainpiece Title: As You Like It

Cast
Role: Le Beu Actor: Lamash

Afterpiece Title: Polly Honeycombe

Dance: As17900210

Song: As17890922

Performances

Mainpiece Title: As You Like It

Cast
Role: Le Beu Actor: Lamash

Afterpiece Title: Polly Honeycombe

Dance: As17900210

Song: As17890922

Performances

Mainpiece Title: Easter Pastimes

Afterpiece Title: The Heiress

Cast
Role: Spirit Actor: Lamash

Afterpiece Title: The Island of St

Performances

Mainpiece Title: As You Like It

Cast
Role: Le Beu Actor: Lamash

Afterpiece Title: The Deuce is in Him

Dance: As17900210

Song: As17890922

Performances

Mainpiece Title: The College Of Physicians; Or, Doctor Last's Examination

Afterpiece Title: The Heiress

Cast
Role: Spirit Actor: Lamash

Afterpiece Title: The Doctor and the Apothecary

Song: End II 2nd piece: The Greenwich Pensioner-Dignum