SELECT * FROM london_stages WHERE eventid IN (13769, 13773, 13777, 13781, 13785, 13789, 13804, 13808, 13811, 13815, 13818, 13822, 13826, 13830, 13833, 13837, 13841, 13845, 13851, 13855, 13859, 13863, 13869, 13873, 13877, 13880, 13884, 13888, 13893, 13897, 13901, 13905, 13927, 13934, 13938, 13941, 13944, 13948, 13952, 13957, 13960, 13986, 13989, 13997, 14001, 14004, 14043, 14051, 14057, 14063, 14108, 14123, 14135, 14161, 14181, 14187, 14229, 14300, 14301, 14313, 14316, 15001, 15005, 15011, 15014, 15505, 15566, 15570, 15584, 15604, 16163, 16221, 16485, 16504, 16510, 16531, 16534, 16548, 17372, 17375, 17376, 17380, 17385, 17386, 17392, 17412, 17414, 17495, 17686, 17689, 17693, 17697, 17700, 17702, 17706, 17710, 17713, 17718, 17720, 17723, 17730, 17734, 17738, 17741, 17745, 17753, 17757, 17764, 17768, 17771, 17775, 17781, 17784, 17787, 17790, 17794, 17798, 17800, 17807, 17811, 17814, 18054, 18058, 18323, 18326, 18387, 18390, 18397, 18401, 18407, 18411, 18445, 18452, 18469, 18620, 18803, 19050, 19052, 19055, 19057, 19244, 19247, 19249, 19282, 19284, 19286, 19287, 19289, 19290, 19292, 19294, 19297, 19299, 19301, 19303, 19305, 19307, 19309, 19311, 19313, 19315, 19318, 19320, 19322, 19324, 19326, 19328, 19332, 19356, 19358, 19368, 19374, 19376, 19377, 19379, 19383, 19411, 19415, 19418, 19420, 19455, 19534, 19536, 19538, 19543, 19545, 19547, 19549, 19556, 19562, 19568, 19576, 19590, 19595, 19611, 19620, 19673, 19675, 19679, 19689, 19697, 19751, 19757, 19763, 19766, 19768, 19770, 19772, 19789, 19800, 19805, 19815, 19818, 19820, 19827, 19832, 19834, 19836, 19839, 19842, 19845, 19847, 19855, 19858, 19861, 19878, 19881, 19883, 19978, 20002, 20012, 20053, 20067, 20090, 20102, 20292, 20295, 20311, 20326, 20347, 20359, 20398, 20415, 20421, 20438, 20461, 20679, 20697, 20706, 20805, 20814, 20817, 20832, 20835, 20838, 20841, 20845, 20875, 20895, 20898, 20902, 20905, 20908, 20911, 20914, 20917, 20928, 20937, 20948, 20951, 20955, 20960, 20967, 20980, 20990, 21000, 21013, 21020, 21041, 21059, 21066, 21086, 21092, 21096, 21099, 21103, 21112, 21116, 21119, 21126, 21172, 21184, 21195, 21198, 21230, 21260, 21326, 21332, 21347, 21354, 21359, 21360, 21366, 21370, 21378, 21382, 21390, 21398, 21405, 21418, 21451, 21482, 21506, 21517, 21534, 21551, 21573, 21635, 21761, 21771, 21805, 21821, 21884, 21887, 21908, 21943, 21948, 21950, 21986, 22024, 22027, 22032, 22034, 22038, 22043, 22132, 22138, 22166, 22182, 22188, 22213, 22253, 22275, 22333, 22366, 22442, 22483, 22524, 22545, 22620, 22687, 22836, 22923, 22981, 23011, 23055, 23090, 23106, 23127, 23156, 23247, 23315, 23351, 23369, 23380, 23383, 23389, 23393, 23409, 23433, 23501, 23600, 23603, 23606, 23861, 23875, 23910, 24427, 24433, 24436, 24438, 24441, 24444, 24447, 24448, 24451, 24454, 24457, 24460, 24463, 24466, 24477, 24503, 24536, 24580, 24641, 24692, 25288, 25295, 26305, 26308, 26314, 27690, 27692, 27722, 27728, 27737, 27763, 28059, 28219, 28633, 28667, 29237, 29593, 29776, 30297, 30383, 30684, 43657, 44031, 44078, 46407, 46409, 46411, 46413, 46415, 46417, 46419, 46421, 46423, 46425, 46427, 46429, 46431, 46433, 46436, 46438, 46441, 46443, 46446, 46448, 46452, 46455, 46457, 46460, 46462, 46464, 46466, 46469, 46471, 46476, 46478, 46481, 46486, 46492, 46495, 46509, 46511, 46515, 46522, 46529, 46536, 46566, 46593, 46700, 46711, 46729, 47083, 47086, 47088, 47091, 47093, 47096, 47098, 47101, 47104, 47108, 47114, 47117, 47119, 47124, 47128, 47131, 47133, 47139, 47144, 47148, 47150, 47156, 47161, 47165, 47186, 47204, 47214, 47270, 47320, 47454, 47458, 47462, 47470, 47474, 47475, 47478, 47482, 47489, 47503, 47517, 47523, 47535, 47559, 47562, 47564, 47572, 47580, 47582, 47584, 47586, 47589, 47591, 47593, 47595, 47597, 47600, 47603, 47605, 47607, 47609, 47611, 47614, 47616, 47619, 47621, 47623, 47625, 47628, 47631, 47633, 47635, 47637, 47639, 47641, 47649, 47651, 47665, 47674, 47688, 47690, 47709, 47714, 47724, 47729, 47754, 47759, 47769, 47779, 47787, 47815, 47825, 47830, 47850, 47869, 47885, 48015, 48023, 48029, 48032, 48038, 48043, 48049, 48080, 48090, 48091, 48109, 48133, 48135, 48137, 48139, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48168, 48170, 48172, 48174, 48176, 48178, 48180, 48182, 48250, 48252, 48257, 48261, 48264, 48266, 48271, 48275, 48280, 48303, 48306, 48308, 48311, 48313, 48315, 48317, 48320, 48322, 48325, 48329, 48331, 48336, 48347, 48358, 48361, 48363, 48366, 48368, 48370, 48375, 48377, 48380, 48382, 48384, 48394, 48404, 48409, 48411, 48430, 48432, 48437, 48447, 48539, 48541, 48551, 48553, 48567, 48615, 48645, 48659, 48665, 48685, 48697, 48704, 48707, 48714, 48719, 48727, 48837, 48860, 48947, 49028, 49053, 49072, 49081, 49083, 49100, 49208, 49211, 49256, 49266, 49338, 49340, 49343, 49345, 49348, 49350, 49352, 49354, 49357, 49359, 49362, 49371, 49373, 49376, 49378, 49385, 49387, 49390, 49392, 49399, 49401, 49408, 49411, 49413, 49416, 49418, 49420, 49422, 49425, 49427, 49430, 49432, 49434, 49439, 49452, 49465, 49493, 49517, 49543, 49553, 49565, 49568, 49585, 49604, 49614, 49657, 49799, 49803, 49817, 49900, 49902, 49905, 49907, 49910, 49912, 49915, 49917, 49919, 49921, 49924, 49926, 49929, 49931, 49933, 49935, 49938, 49940, 49943, 49945, 49947, 49949, 49952, 49954, 49957, 49959, 49961, 49966, 49968, 49971, 49978, 49980, 49983, 49985, 49987, 49989, 49992, 49994, 49998, 50001, 50004, 50006, 50010, 50013, 50016, 50019, 50023, 50026, 50029, 50031, 50035, 50038, 50041, 50044, 50048, 50052, 50070, 50079, 50089, 50092, 50099, 50104, 50113, 50116, 50128, 50134, 50138, 50143, 50148, 50163, 50166, 50193, 50195, 50200, 50203, 50330, 50340, 50352, 50361, 50364, 50368, 50374, 50376, 50380, 50385, 50387, 50389, 50418, 50420, 50422, 50424, 50428, 50433, 50435, 50438, 50440, 50444, 50447, 50452, 50454, 50456, 50461, 50463, 50468, 50472, 50475, 50477, 50480, 50482, 50484, 50487, 50489, 50492, 50494, 50496, 50498, 50501, 50503, 50506, 50508, 50510, 50512, 50515, 50520, 50522, 50524, 50526, 50529, 50531, 50534, 50536, 50538, 50540, 50543, 50546, 50549, 50551, 50554, 50556, 50559, 50562, 50564, 50566, 50568, 50571, 50573, 50576, 50578, 50581, 50583, 50588, 50591, 50593, 50595, 50597, 50600, 50602, 50605, 50607, 50609, 50611, 50616, 50620, 50626, 50628, 50632, 50635, 50638, 50640, 50684, 50688, 50690, 50695, 50702, 50704, 50707, 50709, 50712, 50714, 50717, 50722, 50724, 50726, 50728, 50736, 50742, 50744, 50754, 50757, 50759, 50762, 50764, 50772, 50777, 50784, 50790, 50795, 50800, 50802, 50805, 50812, 50919, 50925, 50937, 50940, 50942, 50944, 50948, 50950, 50953, 50957, 50959, 50961, 50963, 50965, 50969, 50971, 50977, 51003, 51005, 51007, 51009, 51012, 51014, 51016, 51018, 51021, 51024, 51027, 51029, 51031, 51033, 51036, 51038, 51041, 51043, 51045, 51047, 51050, 51059, 51064, 51067, 51069, 51071, 51073, 51076, 51078, 51081, 51083, 51085, 51087, 51090, 51092, 51095, 51097, 51099, 51101, 51104, 51107, 51110, 51112, 51114, 51116, 51119, 51121, 51124, 51126, 51128, 51130, 51133, 51140, 51154, 51159, 51161, 51164, 51166, 51168, 51170, 51173, 51179, 51182, 51185, 51187, 51191, 51194, 51197, 51199, 51206, 51209, 51211, 51215, 51218, 51221, 51223, 51227, 51231, 51234, 51237, 51241, 51244, 51247, 51249, 51254, 51256, 51258, 51261, 51263, 51266, 51268, 51273, 51285, 51290, 51298, 51302, 51304, 51309, 51312, 51317, 51319, 51322, 51329, 51336, 51338, 51341, 51343, 51345, 51349, 51351, 51354, 51356, 51358, 51363, 51365, 51368, 51376, 51481, 51488, 51501, 51505, 51509, 51513, 51517, 51521, 51525, 51527, 51529, 51535, 51537, 51539, 51541, 51543, 51545, 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, 51694, 51697, 51699, 51701, 51704, 51706, 51710, 51713, 51716, 51718, 51722, 51725, 51728, 51730, 51734, 51737, 51740, 51743, 51747, 51750, 51753, 51755, 51762, 51765, 51767, 51771, 51774, 51777, 51779, 51782, 51784, 51786, 51789, 51792, 51794, 51797, 51799, 51801, 51806, 51811, 51813, 51815, 51817, 51820, 51825, 51828, 51833, 51836, 51841, 51843, 51845, 51849, 51856, 51864, 51869, 51871, 51885, 51887, 51890, 51900, 51907, 51914, 51933, 51936) 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 Beggar's Opera

Afterpiece Title: Harlequin Shipwrecked

Dance: I: A Sailor's Dance, as17411015; II: The Italian Peasants, as17411205; Hornpipe-Philips

Performances

Mainpiece Title: As You Like It

Afterpiece Title: Harlequin Shipwrecked

Dance: I: The French Peasants-the Mechels; III: A Dutch Dance, as17411114; IV: Les Matelotes, as17411208

Song: II: Happy Pair-Beard

Performances

Mainpiece Title: Love For Love

Afterpiece Title: Harlequin Shipwrecked

Song: I: Happy Pair-Beard; III: A Ballad-Lowe

Dance: II: A Sailor's Dance, as17411015; IV: The Swiss-the Mechels

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Harlequin Shipwrecked

Song: I: Happy Pair-Beard; III: a Ballad-Lowe

Dance: II: A Concerto, as17420105; IV: The Italian Peasants, as17411205

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Harlequin Shipwrecked

Song: I: a Ballad-Lowe; III: Happy Pair-Beard

Dance: II: The French Peasants, as17420116; IV: The Swiss, as17420119

Performances

Mainpiece Title: The Double Gallant

Cast
Role: Apothecary Actor: Gray

Song: I: a Ballad-Lowe; III: Song-Mrs Arne; IV: See from the Silent Groves-Beard

Dance: II: Le Petit Scaramouche, as17420201; V: Le Genereux Corsaire, as17420120;

Performances

Mainpiece Title: Volpone

Afterpiece Title: Harlequin Shipwrecked

Song: II: Was Ever Nymph like Rosamond-Beard; IV: a Ballad-Lowe

Dance: I: Les Matelotes, as17411208

Performances

Mainpiece Title: The Silent Woman

Afterpiece Title: Harlequin Shipwrecked

Song: I: Song-Beard

Dance: II: A Concerto, as17420105; III: A Dutch Dance, as17411114; IV: The Swiss, as17420119

Performances

Mainpiece Title: The Relapse

Afterpiece Title: Harlequin Shipwrecked

Song: I: Sylvia don't Refuse your Bloom a new song of Mr Arne's-Lowe; III: Song-Beard

Dance: II: A Concerto, as17420105; IV: The Italian Peasants, as17411205

Performances

Mainpiece Title: All's Well That Ends Well

Afterpiece Title: The Harlot's Progress

Cast
Role: Constable Actor: Gray

Song: I: Sylvia wilt thou was e thy Prime, a new song of Mr Arne's,-Lowe; III: Was ever nymph like Rosamond-Lowe

Dance: II: A Concerto, as17420105; IV: The Italian Peasants, as17411205

Performances

Mainpiece Title: The Alchemist

Afterpiece Title: Harlequin Shipwrecked

Song: I: Sylvia wilt thou was e thy Prime-Lowe; III: a Song with French Horns-Beard

Dance: II: The Italian Peasants, as17411205; IV: a New Dance call'd Les Pelerins Voyageur-the Mechels

Performances

Mainpiece Title: All's Well That Ends Well

Afterpiece Title: The Fortune Tellers

Cast
Role: Gipsies Actor: Bride, Green, Rayner, Gray
Role: Fidler Actor: Gray

Song: I: Song with French Horns-Beard; IV: Song-Beard

Dance: II: A Dutch Dance, as17411114; III: The Italian Peasants, as17411205

Performances

Mainpiece Title: All's Well That Ends Well

Afterpiece Title: Fortune Tellers

Cast
Role: Gipsies Actor: Bride, Green, Rayner, Gray
Role: Fidler Actor: Gray

Song: I, III: Song-Mrs Arne

Dance: II: Le Genereux Corsaire, as17420218

Ballet: V: Les Satires Puny. As17420106

Performances

Mainpiece Title: All's Well That Ends Well

Afterpiece Title: Harlequin Shipwrecked

Song: I: Celia has ten thousand charms-Beard; III: Song with French Horns-Beard

Dance: II: A Concerto, as17420105; IV: The Italian Peasants, as17411205

Performances

Mainpiece Title: All's Well That Ends Well

Afterpiece Title: The Fortune Tellers

Cast
Role: Gipsies Actor: Bride, Green, Rayner, Gray
Role: Fidler Actor: Gray

Song: I: See from the Silent Groves-Beard; IV: Song in Italian-Beard

Dance: II: The Swiss, as17410926; III: A Miller's Dance-Delamain

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: Harlequin Shipwrecked

Song: I: Celia has ten thousand Charms-Beard; IV: A Song with French Horns-Beard

Dance: III: The Swiss, as17410926

Performances

Mainpiece Title: All's Well That Ends Well

Afterpiece Title: Harlequin Shipwrecked

Song: I: Ballad-Lowe; IV: The Early Horn-Lowe

Dance: II: The Serious Dance, as17420322 III: Dutch Dance, as17411219

Performances

Mainpiece Title: The Double Dealer

Afterpiece Title: Tom Thumb

Cast
Role: Deadset Actor: Gray

Song: I: Song with French Horns-Beard; II: Was ever Nymph like Rosamond-Lowe; IV: Bumper Squire Jones (By Desire)-Beard

Dance: III: (At particular desire of several persons of quality) Le Boufon, Italian Peasants-Mechel, Mlle Mechel after the manner of the Fausans

Performances

Mainpiece Title: The Double Gallant

Cast
Role: Apothecary Actor: Gray

Afterpiece Title: The Lottery

Song: I: Song-Beard; III: Sweet Bird from Milton-Mrs Arne; IV: The Early Horn-Lowe

Dance: II: New Serious Dance, as17420322 V: Le Boufon, as17420325

Performances

Mainpiece Title: The Committee

Afterpiece Title: Chrononhotonthologos, Emperor of Queeramania

Cast
Role: Quack Actor: Gray

Song: I: A Ballad-Lowe; III: Bumper Squire Jones-Beard; IV: Elin@a@Roon (By Particular Desire)-Mrs Clive

Dance: II: Le Boufon, as17420325 V: The Drunken Peasant, as17411029

Performances

Mainpiece Title: Richard Iii

Cast
Role: Forest Actor: Gray

Afterpiece Title: The King and Miller of Mansfield

Song: I: Song with French Horns-Beard; IV: War he sung was Toil and Trouble-Mrs Clive

Dance: III: New Running Footman's Dance-Phillips; V: a Hornpipe-Phillips

Performances

Mainpiece Title: Richard Iii

Cast
Role: Forest Actor: Gray

Dance: The Mechels

Performances

Mainpiece Title: Scaramouch Scapin; Or, The Old Miser Caught In A Sack; With The Comical Tricks And Cheats Of Scapin's Three Companions; trim The Barber, sly And bully Bounceabout

Cast
Role: Solomon Smack Actor: Gray

Dance: FFingalian Dance-Davis, Mrs Vallois; English Maggot-M. Blondel, Mlle Modett; Grand Ballet, The Mistake, or all is right at last-

Performances

Mainpiece Title: The Miser

Cast
Role: Sattin Actor: Gray

Afterpiece Title: The King and Miller of Mansfield

Music: I: Concerto-Veracini; III: Let me wander not unseen-Lowe

Dance: II: Tyrolean Dance, as17420921; V: Peasant Dance, as17420921

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: The Intriguing Chambermaid

Cast
Role: Security Actor: Gray

Music: I: Concerto-Veracini

Song: III: Let me Wander-Lowe

Dance: II: Tyrolean Dance, as17420921; V: Peasant Dance, as17420921