SELECT * FROM london_stages WHERE eventid IN (166, 3718, 7942, 8177, 8240, 8636, 12971, 13015, 13448, 13504, 13526, 13538, 13539, 13543, 13545, 13547, 13549, 13552, 13555, 13559, 13563, 13569, 13691, 13695, 13699, 14113, 14118, 14124, 14136, 14141, 14145, 14169, 14197, 14200, 14402, 14405, 14704, 14715, 14746, 14781, 14792, 14830, 14865, 14964, 15052, 15056, 15060, 15069, 15077, 15090, 15100, 15108, 15110, 15112, 15119, 15145, 15149, 15153, 15165, 15237, 15241, 15246, 15250, 15252, 15255, 15260, 15266, 15268, 15270, 15274, 15277, 15281, 15285, 15289, 15292, 15295, 15298, 15301, 15304, 15354, 15499, 15503, 15506, 15571, 15585, 15597, 15665, 15668, 15746, 15791, 15796, 15801, 15808, 15813, 15818, 15825, 15828, 15842, 15846, 15850, 15864, 15872, 15887, 15903, 15911, 15920, 15928, 15935, 15954, 15975, 15985, 16000, 16005, 16009, 16026, 16030, 16041, 16050, 16075, 16111, 16229, 16233, 16239, 16245, 16252, 16282, 16323, 16328, 16333, 16344, 16366, 16388, 16395, 16406, 16411, 16417, 16421, 16428, 16437, 16440, 16447, 16462, 16468, 16485, 16496, 16503, 16509, 16510, 16512, 16514, 16515, 16522, 16525, 16534, 16539, 16540, 16544, 16547, 16550, 16578, 16584, 16586, 16591, 16599, 16602, 16606, 16612, 16616, 16618, 16621, 16623, 16626, 16630, 16632, 16635, 16636, 16642, 16644, 16661, 16665, 16668, 16673, 16678, 16683, 16686, 16690, 16693, 16694, 16697, 16701, 16720, 16725, 16772, 16777, 16781, 16785, 16788, 16792, 16795, 16799, 16818, 16836, 16840, 16844, 16849, 16850, 16853, 16854, 16857, 16858, 16861, 16862, 16865, 16866, 16869, 16870, 16873, 16874, 16877, 16878, 16881, 16885, 16886, 16889, 16890, 16893, 16901, 16910, 16913, 16917, 16921, 16922, 16925, 16926, 16929, 16932, 16933, 16936, 16937, 16940, 16941, 16945, 16948, 16949, 16956, 16959, 16960, 16968, 16976, 16985, 16989, 16993, 17001, 17014, 17018, 17037, 17043, 17050, 17060, 17065, 17075, 17081, 17134, 17227, 17236, 17261, 17284, 17311, 17328, 17342, 17347, 17349, 17352, 17361, 17368, 17371, 17372, 17375, 17376, 17379, 17385, 17386, 17387, 17392, 17397, 17406, 17408, 17412, 17414, 17434, 17438, 17440, 17495, 17498, 17511, 17512, 17515, 17518, 17525, 17526, 17528, 17533, 17537, 17540, 17547, 17550, 17553, 17566, 17569, 17580, 17586, 17589, 17624, 17633, 17650, 17651, 17657, 17658, 17663, 17667, 17668, 17670, 17671, 17673, 17674, 17677, 17679, 17686, 17689, 17693, 17697, 17700, 17702, 17706, 17710, 17713, 17718, 17720, 17721, 17723, 17724, 17727, 17728, 17730, 17731, 17735, 17739, 17742, 17745, 17746, 17749, 17754, 17761, 17765, 17776, 17782, 17785, 17788, 17790, 17791, 17794, 17795, 17798, 17800, 17804, 17807, 17811, 17814, 17827, 17831, 17833, 17841, 17842, 17845, 17850, 17855, 17860, 17873, 17883, 17890, 17891, 17895, 17932, 17934, 17940, 17942, 17947, 17959, 17975, 17980, 17983, 18010, 18049, 18054, 18058, 18068, 18073, 18086, 18096, 18120, 18123, 18134, 18140, 18166, 18168, 18169, 18173, 18174, 18175, 18176, 18178, 18185, 18187, 18189, 18192, 18195, 18198, 18201, 18203, 18204, 18206, 18207, 18209, 18210, 18211, 18213, 18214, 18215, 18217, 18218, 18219, 18221, 18226, 18227, 18228, 18230, 18231, 18232, 18234, 18238, 18239, 18241, 18243, 18244, 18247, 18248, 18250, 18252, 18253, 18255, 18259, 18260, 18263, 18268, 18272, 18273, 18276, 18277, 18280, 18287, 18288, 18294, 18298, 18308, 18319, 18323, 18326, 18328, 18330, 18334, 18340, 18355, 18360, 18361, 18364, 18365, 18367, 18368, 18371, 18374, 18376, 18378, 18384, 18385, 18387, 18390, 18397, 18401, 18404, 18407, 18411, 18412, 18426, 18430, 18439, 18445, 18446, 18448, 18452, 18459, 18460, 18463, 18467, 18468, 18469, 18471, 18475, 18479, 18482, 18488, 18492, 18493, 18495, 18503, 18515, 18519, 18526, 18530, 18533, 18538, 18541, 18551, 18560, 18602, 18608, 18614, 18620, 18625, 18635, 18646, 18647, 18657, 18663, 18673, 18674, 18682, 18686, 18723, 18728, 18729, 18741, 18761, 18765, 18769, 18784, 18794, 18798, 18803, 18807, 18816, 18819, 18826, 18828, 18830, 18839, 23211, 24399, 39842, 39882, 39890, 39900, 39912, 39917, 39935, 39951, 39997, 40002, 44470, 44474, 45471, 46839, 46865, 46869, 46875, 46889, 46895, 46905, 46913, 46919, 46929, 46937, 46941, 46947, 46953, 46961, 46981, 46989, 46991, 46995, 46999, 47003, 47011, 47019, 47021, 47029, 47033, 47039, 47045, 47053, 47059, 47066, 47081, 47093, 47101, 47454, 47458, 47466, 47470, 47474, 47475, 47479, 47484, 47485, 47489, 47499, 47501, 47503, 47509, 47513, 47517, 47521, 47525, 47527, 47529, 47531, 47533, 47537, 47541, 47543, 47547, 47549, 47551, 47553, 47557, 47561, 47566, 47568, 47570, 47575, 47582, 47589, 47593, 47595, 47600, 47605, 47607, 47614, 47616, 47621, 47623, 47625, 47631, 47633, 47637, 47645, 47647, 47649, 47655, 47657, 47672, 47676, 47683, 47685, 47759, 47779, 47794, 47823, 47825, 47845, 47863, 47879, 47882, 47896, 47975, 47994, 48000, 48002, 48008, 48010, 48015, 48017, 48019, 48020, 48028, 48032, 48036, 48039, 48055, 48059, 48082, 48090, 48091, 48095, 48101, 48103, 48105, 48111, 48113, 48115, 48117, 48119, 48123, 48125, 48127, 48129, 48131, 48142, 48148, 48150, 48154, 48158, 48160, 48162, 48166, 48170, 48174, 48178, 48182, 48184, 48186, 48188, 48190, 48194, 48197, 48199, 48202, 48204, 48206, 48209, 48211, 48214, 48216, 48218, 48220, 48223, 48225, 48229, 48233, 48236, 48238, 48243, 48247, 48250, 48252, 48257, 48261, 48266, 48271, 48275, 48278, 48280, 48285, 48289, 48292, 48294, 48299, 48306, 48308, 48311, 48317, 48320, 48322, 48329, 48331, 48334, 48336, 48339, 48344, 48347, 48349, 48356, 48358, 48361, 48363, 48368, 48372, 48375, 48377, 48380, 48382, 48386, 48389, 48391, 48398, 48402, 48407, 48409, 48413, 48416, 48418, 48421, 48423, 48425, 48430, 48432, 48435, 48437, 48443, 48444, 48537, 48549, 48551, 48555, 48557, 48559, 48561, 48563, 48567, 48577, 48579, 48581, 48585, 48590, 48592, 48594, 48598, 48609, 48623, 48625, 48630, 48635, 48637, 48640, 48642, 48645, 48647, 48651, 48654, 48656, 48662, 48664, 48665, 48667, 48669, 48672, 48674, 48675, 48677, 48679, 48685, 48687, 48689, 48692, 48695, 48697, 48699, 48704, 48705, 48707, 48709, 48712, 48714, 48715, 48722, 48725, 48727, 48729, 48732, 48734, 48735, 48737, 48739, 48742, 48744, 48745, 48752, 48754, 48755, 48764, 48769, 48774, 48775, 48777, 48783, 48785, 48787, 48791, 48798, 48801, 48803, 48805, 48807, 48810, 48817, 48819, 48824, 48830, 48832, 48835, 48837, 48840, 48842, 48844, 48846, 48851, 48854, 48858, 48860, 48863, 48877, 48879, 48892, 48904, 48913, 48971, 48980, 48988, 48998, 49002, 49016, 49028, 49038, 49053, 49058, 49063, 49066, 49069, 49074, 49086, 49092, 49268, 49270, 49272, 49274, 49276, 49278, 49280, 49282, 49284, 49286, 49288, 49290, 49292, 49294, 49296, 49298, 49300, 49305, 49307, 49310, 49312, 49314, 49316, 49319, 49321, 49324, 49328, 49330, 49333, 49335, 49364, 49366, 49368, 49380, 49382, 49394, 49396, 49568, 49616, 49622, 49627, 51547, 51549, 51551, 51553, 51555, 51559, 51563, 51567, 51571, 51575, 51579, 51583, 51585, 51589, 51598, 51601, 51603, 51605, 51607, 51610, 51613, 51615, 51617, 51619, 51621, 51624, 51627, 51629, 51631, 51634, 51636, 51639, 51641, 51643, 51648, 51655, 51662, 51664, 51676, 51701, 51730, 51737, 51747, 51836, 51861, 51869, 51871, 51885, 51907, 51936, 52099, 52108, 52277, 52341, 52347, 52473) 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: Hamlet

Cast
Role: Ophelia Actor: Mrs Esten.

Afterpiece Title: Harlequin's Chaplet

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: The Farmer

Cast
Role: Lady Bab Lardoon Actor: Mrs Esten

Dance: As17931204

Performances

Mainpiece Title: The Woodman

Afterpiece Title: MODERN ANTIQUES

Cast
Role: Roxalana Actor: Mrs Esten.

Dance: As17931015

Performances

Mainpiece Title: Love Makes A Man; Or, The Fop's Fortune

Afterpiece Title: Harlequin's Chaplet

Performances

Mainpiece Title: The Beggar's

Dance: In Act III of mainpiece Hornpipe, as17931116; End of mainpiece Dermot and Kathlane, as17931022

Opera: As17931012, but Mrs Peachum-Mrs Henley. Also THE MIDNIGHT HOUR. As17931102, but Cecily-Mrs Leicester

Cast
Role: Cecily Actor: Mrs Leicester

Performances

Mainpiece Title: The Quaker

Cast
Role: Nurse Actor: Mrs Leicester
Role: Juliet Actor: Mrs Esten.
Role: Fanny Actor: Mrs Esten

Afterpiece Title: THE SIEGE OF BERWICK

Afterpiece Title: THE HIGHLAND REEL

Performances

Mainpiece Title: The World In A Village

Afterpiece Title: CYMON

Dance: End of mainpiece Dermot and Kath/ant, as17931018, but added: Old Kathlane-Miss Watson; In afterpiece, as17931209

Performances

Mainpiece Title: Hamlet

Afterpiece Title: A Divertisement

Dance: As17931123

Performances

Mainpiece Title: Rose And Colin

Afterpiece Title: The German Hotel

Afterpiece Title: The Midnight Hour

Performances

Mainpiece Title: Love In A Village

Cast
Role: Deborah Actor: Mrs Leicester

Afterpiece Title: THE PRISONER AT LARGE

Dance: As17931102

Performances

Mainpiece Title: Hamlet

Afterpiece Title: ROSE AND COLIN

Dance: As17931022

Song: As17931030, but omitted: Gray

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: THE FOLLIES OF A DAY

Cast
Role: Marcelina Actor: Mrs Leicester

Dance: As17931022

Performances

Mainpiece Title: The Provok'd Husband

Cast
Role: Lady Townly Actor: Mrs Esten

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: The Farmer

Afterpiece Title: The Midnight Hour

Afterpiece Title: A Divertisement

Dance: As17931123

Performances

Mainpiece Title: The Dramatist

Cast
Role: Marianne Actor: Mrs Esten

Afterpiece Title: BARATARIA; or, Sancho Turned Governor

Cast
Role: Spanish Lady Actor: Mrs Leicester

Dance: As17931022

Performances

Mainpiece Title: Douglas

Cast
Role: Nelti Actor: Mrs Esten

Afterpiece Title: The Picture of Paris, Taken in the Year 1790

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: The Picture of Paris

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Nurse Actor: Mrs Leicester
Role: Juliet Actor: Mrs Esten.

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Luciana Actor: Mrs Esten

Afterpiece Title: The Picture of Paris

Performances

Mainpiece Title: The Earl Of Essex; Or, The Unhappy Favorite

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Earl Of Essex; Or, The Unhappy Favourite

Cast
Role: Rutland Actor: Mrs Esten

Afterpiece Title: The Picture of Paris

Performances

Mainpiece Title: Notoriety

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The World In A Village

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: King Lear, And His Three Daughters

Cast
Role: Cordelia Actor: Mrs Esten

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Comedy Of Errors

Cast
Role: Luciana Actor: Mrs Esten

Afterpiece Title: HARLEQUIN AND FAUSTUS

Song: As17931008