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: A Bold Stroke For A Wife

Cast
Role: Perriwinkle Actor: Collet

Afterpiece Title: The Cobler of Preston

Song: Mrs Mountfort

Performances

Mainpiece Title: Jane Shore

Cast
Role: Bellmore Actor: Collet

Afterpiece Title: The Cobler of Preston

Song: Mrs Mountfort

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Smugler Actor: Collet

Afterpiece Title: Flora

Cast
Role: Dick Actor: Collet

Song: The Song of New Mad Tom-a Gentleman

Performances

Mainpiece Title: The Gamester

Cast
Role: Hector Actor: Collet

Afterpiece Title: The Stage Coach (Opera)

Song: Some Songs-Excell

Dance: TThe Medley of Jokes-Eaton, Miss Sandham

Performances

Mainpiece Title: The Man's Bewitch'd

Cast
Role: Clinch Actor: Collet

Afterpiece Title: Flora

Cast
Role: Dick Actor: Collet

Performances

Mainpiece Title: The Fashionable Lady

Cast
Role: Trifle Actor: Collett

Performances

Mainpiece Title: Hamlet, Prince Of Denmark

Cast
Role: Polonius Actor: Collet

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Smugler Actor: Collet

Performances

Mainpiece Title: Mad Tom Of Bedlam; Or, The Distress'd Lovers: With The Comical Humours Of squire Numscul

Cast
Role: Justice Gripeall Actor: Collett.

Song: Mr Corse, age 12

Dance: DDutch Skipper-Sandham; Drunken Man-Wilcox; (On 8 Aug. and there after:) Mad Dance, Pierrot-Le Sieur Labisle, from France

Performances

Mainpiece Title: The Rum Duke And The Queer Duke

Cast
Role: Justice Gripeall Actor: Collett.

Afterpiece Title: The Miller's Holiday; or, Love in a Furz-Bush

Dance: St.Luce, others

Performances

Mainpiece Title: Wat Tyler And Jack Straw: Being The Representation Of That Celebrated And Heroick Action Of Sir William Walworth A lord Mayor Of London, Perform'd In The Reign Of king Richard The Second; Shewing How He Stab'd The Insolent Rebel, wat Tyler, At The Head Of His Rout, In smithfield, For Which Reason The Dagger, Which He So Loyally Employ'd, Was Added To The City's Arms, And Loyalty

Cast
Role: Jack Straw Actor: Collet

Performances

Mainpiece Title: Wat Tyler And Jack Straw

Cast
Role: Jack Straw Actor: Collet

Song:

Dance:

Performances

Mainpiece Title: Wat Tyler And Jack Straw

Cast
Role: Jack Straw Actor: Collet

Afterpiece Title: Flora

Song:

Dance:

Performances

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

Cast
Role: Charino Actor: Collet

Song:

Dance:

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Recruits Actor: Collet, R. Williams

Dance: HHarlequin's Dance-Sandham, Sandham's Daughter

Performances

Mainpiece Title: The Stratagem

Cast
Role: Scrub Actor: Collett

Song:

Dance:

Performances

Mainpiece Title: The Provok'd Husband; Or, A Journey To London

Cast
Role: Moody Actor: Collett

Dance:

Performances

Mainpiece Title: Hamlet, Prince Of Denmark

Cast
Role: Polonius Actor: Collett

Song:

Dance:

Performances

Mainpiece Title: Love For Love

Cast
Role: Jeremy Actor: Collet

Dance: SShepherd and Shepherdess-Miss Sandham, Pollett

Performances

Mainpiece Title: The Constant Couple; Or, A Trip To The Jubilee

Cast
Role: Smuggler Actor: Collet

Song:

Dance: SScaramouch-Pollett

Performances

Mainpiece Title: The Spanish Fryar; Or, The Double Discovery

Cast
Role: Gomez Actor: Collett.

Song:

Dance:

Performances

Mainpiece Title: The Devil Of A Wife; Or, The Comical Transformation

Cast
Role: Butler Actor: Collet

Dance: RRunning Footman-Pollett

Song:

Performances

Mainpiece Title: The Devil Of A Wife

Cast
Role: Butler Actor: Collet

Song: As17301005

Dance: As17301005

Performances

Mainpiece Title: The Devil Of A Wife

Cast
Role: Butler Actor: Collet

Afterpiece Title: The Opera of Flora; or, Hob in the Well

Song: As17301005

Dance: As17301005

Performances

Mainpiece Title: The Devil Of A Wife

Cast
Role: Butler Actor: Collet

Afterpiece Title: Phebe

Dance: As17301005