SELECT * FROM london_stages WHERE eventid IN (12887, 12892, 12895, 12898, 12901, 12904, 12907, 12910, 12913, 12919, 12923, 12927, 12931, 12934, 12937, 12940, 12944, 12947, 12951, 12954, 12961, 12964, 12967, 12972, 12976, 12980, 12983, 12986, 12992, 12998, 13002, 13005, 13008, 13012, 13016, 13018, 13022, 13025, 13029, 13032, 13035, 13040, 13043, 13047, 13052, 13056, 13060, 13063, 13066, 13070, 13073, 13079, 13083, 13087, 13091, 13094, 13098, 13105, 13109, 13113, 13116, 13119, 13123, 13127, 13134, 13137, 13141, 13144, 13148, 13152, 13156, 13160, 13164, 13167, 13171, 13175, 13181, 13185, 13189, 13192, 13198, 13202, 13225, 13233, 13238, 13242, 13245, 13256, 13260, 13263, 13268, 13272, 13277, 13281, 13286, 13289, 13292, 13296, 13301, 13304, 13309, 13312, 13315, 13318, 13322, 13326, 13330, 13339, 13343, 13351, 13355, 13360, 13363, 13367, 13372, 13377, 13412, 13416, 13421, 13426, 13431, 13443, 13446, 13460, 13462, 13466, 13468, 13474, 13476, 13480, 13482, 13484, 13486, 13489, 13492, 13493, 13495, 13498, 13501, 13503, 13507, 13509, 13514, 13515, 13517, 13519, 13522, 13524, 13528, 13529, 13530, 13532, 13533, 13537, 13544, 13550, 13553, 13554, 13556, 13559, 13562, 13566, 13568, 13579, 13582, 13586, 13589, 13592, 13596, 13599, 13603, 13606, 13608, 13610, 13625, 13627, 13632, 13635, 13638, 13642, 13645, 13647, 13651, 13655, 13658, 13661, 13664, 13668, 13681, 13684, 13692, 13696, 13715, 13719, 13723, 13726, 13734, 13745, 13748, 13752, 13756, 13760, 13768, 13771, 13779, 13783, 13787, 13791, 13794, 13798, 13802, 13806, 13810, 13813, 13817, 13820, 13824, 13828, 13832, 13835, 13839, 13843, 13847, 13853, 13857, 13861, 13864, 13871, 13875, 13879, 13882, 13895, 13907, 13911, 13915, 13921, 13925, 13929, 13959, 13962, 13966, 13969, 13973, 13977, 13999, 14003, 14006, 14010, 14013, 14017, 14028, 14032, 14035, 14039, 14045, 14053, 14059, 14065, 14069, 14084, 14088, 14103, 14110, 14114, 14121, 14131, 14137, 14142, 14146, 14154, 14158, 14170, 14189, 14201, 14208, 14210, 14214, 14218, 14221, 14223, 14235, 14255, 14258, 14263, 14270, 14304, 14305, 14307, 14308, 14309, 14312, 14314, 14315, 14317, 14318, 14320, 14321, 14323, 14324, 14363, 14366, 14369, 14375, 14379, 14383, 14386, 14394, 14399, 14403, 14415, 14418, 14422, 14428, 14431, 14441, 14445, 14451, 14454, 14458, 14485, 14498, 14505, 14524, 14530, 14533, 14549, 14552, 14615, 14618, 14625, 14628, 14634, 14637, 14640, 14644, 14654, 14668, 14679, 14683, 14718, 14726, 14738, 14773, 14813, 14828, 14835, 14841, 14857, 14873, 14883, 14889, 14894, 14921, 14934, 14942, 14957, 15045, 15047, 15053, 15059, 15072, 15085, 15087, 15089, 15094, 15104, 15106, 15123, 15126, 15133, 15137, 15158, 15163, 15189, 15197, 15200, 15235, 15242, 15247, 15267, 15312, 15315, 15332, 15335, 15344, 15347, 15350, 15353, 15357, 15360, 15366, 15373, 15392, 15396, 15401, 15415, 15421, 15424, 15448, 15457, 15497, 15516, 15548, 15553, 15565, 15588, 15603, 15616, 15620, 15636, 15735, 15737, 15740, 15743, 15754, 15758, 15760, 15772, 15784, 15799, 15811, 15816, 15869, 15968, 16006, 24067, 33441, 33443, 33446, 33448, 33451, 33453, 33455, 33457, 33460, 33462, 33465, 33467, 33471, 33474, 33476, 33479, 33489, 33491, 33494, 33496, 33501, 33510, 33517, 33524, 33529, 33572, 33626, 33630, 33652, 33676, 33794, 33796, 33798, 33804, 33806, 33814, 33819, 33821, 33823, 33825, 33829, 33831, 33833, 33839, 33841, 33843, 33849, 33875, 33882, 33889, 33896, 33903, 33905, 33907, 33917, 33919, 33921, 33924, 33929, 33933, 34000, 34069, 34072, 34146, 34175, 34182, 34199, 34224, 34237, 34317, 34350, 34355, 34376, 34395, 34404, 34431, 34433, 34435, 34437, 34440, 34442, 34445, 34449, 34452, 34456, 34459, 34461, 34463, 34465, 34470, 34475, 34557, 34714, 34905, 34975, 34998, 35042, 35066, 35068, 35106, 35113, 35120, 35132, 35138, 35240, 35250, 35281, 35286, 35302, 35332, 35340, 35354, 35375, 35535, 35602, 35617, 35626, 35818, 35860, 35966, 35969, 35975, 35979, 35986, 35988, 35993, 35996, 36001, 36006, 36008, 36012, 36014, 36019, 36022, 36024, 36027, 36029, 36031, 36033, 36035, 36037, 36039, 36041, 36043, 36045, 36047, 36049, 36051, 36053, 36055, 36059, 36062, 36066, 36068, 36072, 36075, 36078, 36081, 36088, 36091, 36093, 36097, 36099, 36100, 36102, 36103, 36104, 36107, 36108, 36131, 36359, 36429, 36440, 36671, 36710, 36714, 36750, 36756, 36795, 36798, 36800, 36802, 36804, 36806, 36808, 36811, 36813, 36816, 36818, 36820, 36822, 36825, 36827, 36830, 36832, 37044, 37071, 37216, 37253, 37531, 38873, 38883, 38891, 38899, 38901, 38903, 38904, 38906, 38908, 38910, 38912, 38914, 38916, 38920, 38924, 38926, 38928, 38934, 38939, 38944, 38948, 38951, 38953, 38956, 38960, 38970, 38974, 38982, 38986, 38988, 38990, 38993, 38995, 38998, 39000, 39006, 39011, 39017, 39020, 39022, 39024, 39026, 39028, 39030, 39032, 39034, 39036, 39038, 39041, 39043, 39047, 39049, 39051, 39054, 39056, 39058, 39060, 39062, 39065, 39067, 39069, 39072, 39074, 39076, 39078, 39081, 39083, 39086, 39088, 39095, 39098, 39100, 39102, 39104, 39109, 39114, 39118, 39121, 39123, 39132, 39137, 39142, 39149, 39156, 39163, 39177, 39181, 39190, 39196, 39199, 39202, 39208, 39210, 39219, 39225, 39228, 39230, 39234, 39242, 39250, 39262, 39268, 39270, 39273, 39296, 39308, 39322, 39333, 39335, 39343, 39445, 39455, 39480, 39486, 39511, 39513, 39518, 39520, 39539, 39546, 39560, 39564, 39567, 39574, 39578, 39581, 39583, 39586, 39590, 39595, 39597, 39600, 39605, 39609, 39611, 39621, 39623, 39643, 39646, 39648, 39653, 39655, 39660, 39666, 39670, 39675, 39678, 39680, 39682, 39687, 39690, 39699, 39704, 39707, 39718, 39721, 39726, 39735, 39740, 39743, 39750, 39754, 39781, 39805, 39807, 39812, 39818, 39828, 39832, 39840, 39843, 39849, 39863, 39866, 39871, 39877, 39894, 40015, 40021, 40023, 40025, 40027, 40035, 40037, 40039, 40047, 40056, 40070, 40072, 40078, 40098, 40115, 40125, 40131, 40150, 40153, 40157, 40167, 40180, 40182, 40187, 40196, 40198, 40201, 40204, 40207, 40211, 40213, 40216, 40218, 40223, 40225, 40227, 40230, 40232, 40239, 40275, 40284, 40319, 40322, 40330, 40334, 40339, 40349, 40354, 40366, 40368, 40371, 40388, 40407, 40410, 40415, 40427, 40430, 40460, 40463, 40563, 40565, 40567, 40571, 40573, 40575, 40577, 40579, 40588, 40592, 40594, 40595, 40597, 40599, 40601, 40603, 40605, 40607, 40609, 40610, 40612, 40614, 40618, 40621, 40623, 40625, 40627, 40629, 40631, 40633, 40635, 40637, 40639, 40641, 40643, 40645, 40648, 40650, 40652, 40654, 40657, 40659, 40662, 40664, 40666, 40668, 40671, 40673, 40676, 40678, 40680, 40687, 40692, 40694, 40699, 40702, 40705, 40710, 40716, 40718, 40722, 40725, 40728, 40731, 40733, 40735, 40737, 40740, 40745, 40747, 40749, 40751, 40754, 40760, 40762, 40764, 40769, 40776, 40780, 40783, 40786, 40794, 40796, 40806, 40812, 40815, 40818, 40820, 40827, 40830, 40832, 40838, 40841, 40847, 40851, 40858, 40861, 40869, 40875, 40879, 40881, 40883, 40885, 40890, 40899, 40901, 40906, 40940, 40957, 40959, 40964, 40966, 40969, 40973, 40982, 40993, 41008, 41114, 41116, 41118, 41121, 41124, 41128, 41129, 41131, 41136, 41138, 41140, 41142, 41144, 41146, 41147, 41155, 41159, 41161, 41165, 41168, 41175, 41178, 41189, 41195, 41208, 41214, 41218, 41223, 41230, 41232, 41237, 41242, 41244, 41246, 41256, 41260, 41263, 41274, 41280, 41282, 41286, 41296, 41300, 41303, 41308, 41322, 41331, 41337, 41346, 41349, 41351, 41353, 41355, 41358, 41360, 41363, 41365, 41368, 41370, 41373, 41375, 41378, 41380, 41382, 41396, 41398, 41401, 41403, 41407, 41411, 41414, 41416, 41427, 41429, 41440, 41446, 41450, 41454, 41460, 41465, 41473, 41479, 41484, 41488, 41495, 41497, 41499, 41524, 41526, 41533, 41541, 41543, 41546, 41551, 41556, 41561, 41563, 41568, 41570, 41575, 41577, 41687, 41692, 41694, 41700, 41702, 41704, 41710, 41712, 41713, 41715, 41717, 41720, 41722, 41724, 41726, 41728, 41730, 41732, 41734, 41736, 41738, 41740, 41742, 41758, 41762, 41764, 41773, 41780, 41785, 41789, 41799, 41803, 41808, 41820, 41822, 41843, 41850, 41852, 41860, 41862, 41865, 41879, 41917, 41922, 41930, 41938, 41940, 41949, 41960, 41962, 41973, 41986, 42000, 42002, 42006, 42013, 42034, 42039, 42041, 42055, 42057, 42060, 42070, 42072, 42080, 42085, 42087, 42092, 42102, 42105, 42107, 42110, 42126, 42128, 42131, 42133, 42141, 42148, 42153, 42162, 42164, 42273, 42275, 42277, 42288, 42292, 42296, 42309, 42315, 42327, 42331, 42333, 42335, 42344, 42347, 42349, 42353, 42358, 42366, 42368, 42371, 42373, 42376, 42378, 42380, 42382, 42388, 42393, 42395, 42397, 42407, 42409, 42416, 42424, 42436, 42441, 42444, 42447, 42449, 42451, 42454, 42457, 42460, 42462, 42464, 42471, 42474, 42478, 42483, 42485, 42488, 42493, 42495, 42498, 42500, 42503, 42507, 42512, 42517, 42519, 42521, 42524, 42526, 42529, 42531, 42533, 42540, 42543, 42548, 42560, 42563, 42565, 42568, 42570, 42573, 42575, 42580, 42583, 42589, 42596, 42598, 42602, 42609, 42615, 42619, 42622, 42628, 42635, 42637, 42645, 42669, 42671, 42693, 42708, 42713, 42725, 42732, 42740, 44827, 44928, 44935, 44938, 44970, 44972, 44979, 44988, 44997, 45000, 45019, 45024, 45144, 45151, 45155, 45157, 45163, 45168, 45173, 45185, 45189, 45221, 45239, 45243, 45247, 45254, 45259, 45263, 45268, 45270, 45273, 45279, 45292, 45311, 45318, 45332, 45334, 45337, 45346, 45348, 45355, 45358, 45360, 45364, 45368, 45373, 45380, 45385, 45389, 45396, 45398, 45402, 45406, 45409, 45415, 45419, 45424, 45439, 45443, 45448, 45453, 45471, 45499, 45508, 45518, 45536, 45543, 45556, 45581, 45592, 45594, 45600, 45616, 45626, 45628, 45631, 45635, 45636, 45638, 45639, 45640, 45647, 45648, 45653, 45654, 45655, 45656, 45657, 45658, 45660, 45661, 45662, 45664, 45666, 45668, 45670, 45671, 45672, 45673, 45674, 45675, 45676, 45677, 45678, 45681, 45682, 45685, 45686, 45687, 45718, 45723, 45730, 45736, 45760, 45774, 45776, 45804, 45822, 45845, 45859, 45870, 45898, 45927, 45938, 46087) 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: King Richard Iii

Cast
Role: Duke of York Actor: Miss Collett

Afterpiece Title: Flora; or Hob in the Well

Dance: End: The Vintage, as17661011

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Edgar and Emmeline

Cast
Role: Grotilla Actor: Miss Collett

Entertainment: End: Linco's Travels-King [, as17670406

Dance: HHearts of Oak, as17670212

Performances

Mainpiece Title: King Richard Iii

Cast
Role: Duke of York Actor: Miss Collett

Afterpiece Title: Flora

Dance: In Farce: A Double Hornpipe-Walker, Miss Egan; End: The Irish Lilt, as17670430

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Queen Mab

Cast
Role: Queen Mab Actor: Miss Collett

Performances

Mainpiece Title: The Beggar's Opera

Dance: III: A Hornpipe-Mrs King; A Country Dance-

Afterpiece Title: Queen Mab

Cast
Role: Queen Mab Actor: Miss Collett

Performances

Mainpiece Title: King Richard Iii

Cast
Role: Duke of York Actor: Miss Collett

Afterpiece Title: Fortunatus

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Queen Mab

Cast
Role: Queen Mab Actor: Miss Collett

Performances

Mainpiece Title: Merope

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The English Merchant

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The Provoked Husband

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The Jealous Wife

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The School For Lovers

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: Tancred And Sigismunda

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: As You Like It

Afterpiece Title: Harlequin's Invasion

Dance: I: Hearts of Oak-Giorgi, Mrs King

Performances

Mainpiece Title: Tamerlane

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Harlequin's Invasion