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: The Provok'd Husband

Cast
Role: Myrtilla Actor: Miss Collett

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Performances

Mainpiece Title: The Foundling

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Performances

Mainpiece Title: Twelfth Night

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: Too Civil by Half

Cast
Role: Bridget Actor: Miss Collett

Dance: As17831122 I782

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Dance: End of Act II of mainpiece, as17820917

Performances

Mainpiece Title: The School For Scandal

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Performances

Mainpiece Title: The Way To Keep Him

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Performances

Mainpiece Title: The Wonder

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Performances

Mainpiece Title: The Clandestine Marriage

Cast
Role: Chambermaid Actor: Miss Collett

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: The Englishman in Paris

Cast
Role: Luanda Actor: Miss Collett

Dance: As17821206

Performances

Mainpiece Title: The West Indian

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Dance: As17830103

Performances

Mainpiece Title: The Maid Of The Mill

Cast
Role: Theodosia Actor: Miss Collett

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Dance: End of Act I of mainpiece, as17820917

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: The Englishman in Paris

Cast
Role: Luanda Actor: Miss Collett

Dance: As17821206

Performances

Mainpiece Title: The Provok'd Husband

Cast
Role: Myrtilla Actor: Miss Collett

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Performances

Mainpiece Title: The School For Scandal

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Performances

Mainpiece Title: A Bold Stroke For A Wife

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Dance: As17821205

Performances

Mainpiece Title: The School For Vanity

Afterpiece Title: The Gentle Shepherd

Cast
Role: Patie Actor: Miss Collett

Performances

Mainpiece Title: Love In A Village

Cast
Role: Lucinda Actor: Miss Collett

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Dance: In Act I of mainpiece, as17821003; End of Act II, as17820917

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: The Englishman in Paris

Cast
Role: Luanda Actor: Miss Collett

Dance: Probably as17821206

Performances

Mainpiece Title: The Clandestine Marriage

Cast
Role: Chambermaid Actor: Miss Collett

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: Too Civil by Half

Cast
Role: Bridget Actor: Miss Collett

Performances

Mainpiece Title: The West Indian

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett