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 Fair American

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Performances

Mainpiece Title: The Fair American

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Performances

Mainpiece Title: The Committee; Or, The Faithful Irishman

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Performances

Mainpiece Title: The Fair American

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Song: As17820919

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: Too Civil by Half

Cast
Role: Bridget Actor: Miss Collett

Performances

Mainpiece Title: The Merchant Of Venice

Cast
Role: Nerissa Actor: Miss Collett

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Dance: End of Act III of mainpiece, as17820917; End of Act IV, as17821005

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: The Englishman in Paris

Cast
Role: Luanda Actor: Miss Collett

Dance: As17821206

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Song: As17830218

Performances

Mainpiece Title: Isabella

Afterpiece Title: Too CIVIL BY HALF

Cast
Role: Bridget Actor: Miss Collett

Performances

Mainpiece Title: The Maid Of The Mill

Cast
Role: Theodosia Actor: Miss Collett

Afterpiece Title: The Divorce

Dance: End of Act I of mainpiece, as17821005

Performances

Mainpiece Title: The Merchant Of Venice

Cast
Role: Nerissa Actor: Miss Collett

Afterpiece Title: Bon Ton

Dance: End of Act III of mainpiece The Devonshire Minuet, as17821003; End of Act iv, as17821016

Performances

Mainpiece Title: Much Ado About Nothing

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Dance: In Act II of mainpiece a Masquerade and Dance proper to the Play

Performances

Mainpiece Title: Love In A Village

Cast
Role: Lucinda Actor: Miss Collett

Afterpiece Title: The Camp

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

Performances

Mainpiece Title: King Richard The Third

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 Clandestine Marriage

Cast
Role: Chambermaid Actor: Miss Collett

Afterpiece Title: The Camp

Performances

Mainpiece Title: Oroonoko; Or, The Royal Slave

Afterpiece Title: The Triumph of Mirth

Cast
Role: Columbine Actor: Miss Collett

Performances

Mainpiece Title: Dissipation

Afterpiece Title: The Quaker

Cast
Role: Gillian Actor: Miss Collett

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: The Quaker

Cast
Role: Gillian Actor: Miss Collett

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Adventures of a Night

Cast
Role: Lucy Actor: Miss Collett

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: The Adventures of a Night

Cast
Role: Lucy Actor: Miss Collett

Dance: As17821107

Performances

Mainpiece Title: The Maid Of The Mill

Cast
Role: Theodosia Actor: Miss Collett

Afterpiece Title: dl THE ADVENTURES OF A Night

Cast
Role: Lucy Actor: Miss Collett

Dance: dl As17830118

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: The Adventures of a Night

Cast
Role: Lucy Actor: Miss Collett

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: The Adventures of a Night

Cast
Role: Lucy Actor: Miss Collett