SELECT * FROM london_stages WHERE eventid IN (33689, 34185, 34205, 34238, 34266, 34725, 34730, 34733, 34735, 34748, 34752, 34757, 34766, 34776, 35622, 35643, 35884, 35946, 36478, 36483, 36512, 36524, 36536, 36556, 36697, 36699, 36711, 36713, 36718, 36727, 36796, 36799, 36801, 36803, 36805, 36807, 36809, 36812, 36814, 36817, 36819, 36821, 36823, 36826, 36828, 36833, 36838, 36840, 36842, 36845, 36847, 36849, 36851, 36854, 36859, 36861, 36867, 36872, 36874, 36876, 36889, 36896, 36898, 36903, 36905, 36910, 36958, 36970, 36981, 36989, 37029, 37037, 37045, 37047, 37056, 37061, 37064, 37067, 37077, 37079, 37086, 37099, 37108, 37120, 37219, 37222, 37226, 37240, 37242, 37289, 37302, 37318, 37320, 37325, 37327, 37330, 37332, 37334, 37339, 37348, 37355, 37358, 37379, 37381, 37401, 37415, 37423, 37546, 37549, 37575, 37580, 37583, 37590, 37593, 37619, 37624, 37631, 37641, 37672, 37674, 37818, 37822, 37836, 37871, 37873, 37876, 37879, 37883, 37888, 37892, 37901, 37903, 37908, 37912, 37915, 37917, 37926, 37929, 37942, 37944, 37946, 37948, 37950, 37952, 37955, 37957, 37959, 37961, 38071, 38422, 38434, 38439, 38448, 38457, 38464, 38561, 38658, 38675, 38700, 38703, 38731, 39308, 41507, 41509, 41514, 41522, 41531, 41538, 41548, 41568, 44167, 44170, 44172, 44174, 44176, 44178, 44180, 44182, 44184, 44186, 44188, 44190, 44194, 44196, 44198, 44200, 44202, 44204, 44206, 44208, 44210, 44212, 44214, 44216, 44218, 44221, 44223, 44225, 44227, 44239, 44258, 44272, 44279, 44309, 44348, 44354, 44367, 44374, 44384, 44397, 44412, 44429, 44437, 44469, 44608, 44632, 44664, 44674, 44676, 44805, 44810, 44813, 44815, 44817, 44822, 44828, 44831, 44836, 44840, 44844, 44847, 44857, 44860, 44874, 44880, 44897, 44903, 44907, 44917, 44927, 44949, 44955, 44964, 44966, 45032, 45333, 45384, 45436, 45438, 45442, 45449, 45451, 45461, 45464, 45469, 45477, 45482, 45511, 45517, 45526, 45529, 45534, 45539, 45554, 45559, 45567, 45582, 45587, 45589, 45591, 45991, 45993, 45997, 46002, 46005, 46007, 46011, 46018, 46024, 46040, 46171, 46174, 46271, 46273, 46284, 46292, 46299, 46303, 46309, 46311, 46323, 46331, 46336, 46357, 46359, 46361, 46369, 46373, 46383, 46389, 46393, 46397, 46401, 46403, 46427, 46431, 46441, 46452, 46455, 46481, 46506, 46509, 46524, 46543, 46552, 46564, 46580, 46585, 46590, 46607, 46609, 46612, 46614, 46622, 46634, 46637, 46639, 46657, 46676, 46688, 46695, 46697, 46708, 46716, 46718, 46732, 46844, 46846, 46847, 46849, 46852, 46854, 46861, 46895, 46909, 46951, 46965, 46967, 46969, 46971, 46973, 46975, 46977, 46979, 46981, 46983, 46985, 46989, 46991, 46993, 46995, 46997, 46999, 47003, 47007, 47009, 47015, 47017, 47019, 47021, 47023, 47027, 47029, 47031, 47033, 47035, 47039, 47041, 47043, 47047, 47051, 47053, 47057, 47063, 47068, 47073, 47079, 47081, 47117, 47119, 47124, 47128, 47131, 47133, 47139, 47144, 47148, 47150, 47156, 47161, 47165, 47186, 47198, 47202, 47204, 47220, 47235, 47247, 47253, 47264, 47270, 47289, 47291, 47309, 47314, 47320, 47326, 47474, 47475, 47478, 47482, 47484, 47485, 47493, 47495, 47497, 47507, 47513, 47515, 47519, 47527, 47531, 47537, 47539, 47543, 47549, 47555, 47561, 47564, 47566, 47568, 47575, 47580, 47603, 47643, 47645, 47651, 47655, 47657, 47672, 47676, 47680, 47683, 47685, 47737, 47752, 47779, 47782, 47787, 47797, 47803, 47810, 47813, 47825, 47828, 47838, 47843, 47858, 47865, 47872, 47892, 48038, 48041, 48043, 48049, 48080, 48090, 48109, 48139, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48168, 48170, 48172, 48174, 48178, 48180, 48182, 48192, 48264, 48278, 48285, 48289, 48294, 48299, 48341, 48344, 48347, 48349, 48352, 48356, 48358, 48361, 48363, 48366, 48368, 48372, 48375, 48377, 48382, 48386, 48389, 48391, 48396, 48398, 48402, 48407, 48413, 48416, 48418, 48421, 48427, 48437, 48443, 48551, 48553, 48611, 48631, 48643, 48645, 48667, 48724, 48735, 48747, 48749, 48752, 48754, 48755, 48757, 48759, 48761, 48766, 48767, 48769, 48771, 48774, 48775, 48777, 48779, 48781, 48783, 48785, 48787, 48789, 48791, 48793, 48796, 48798, 48801, 48803, 48805, 48810, 48812, 48815, 48817, 48819, 48821, 48824, 48826, 48828, 48830, 48835, 48851, 48856, 48865, 48870, 48877, 48902, 48916, 48923, 48930, 48945, 48952, 48959, 48961, 48980, 48988, 48990, 48993, 48995, 49000, 49004, 49009, 49014, 49021, 49023, 49033, 49038, 49041, 49051, 49053, 49056, 49061, 49066, 49069, 49077, 49081, 49083, 49086, 49090, 49100, 49193, 49199, 49206, 49214, 49216, 49222, 49226, 49244, 49270, 49343, 49408, 49411, 49413, 49416, 49418, 49420, 49422, 49425, 49427, 49430, 49432, 49434, 49472, 49478, 49485, 49490, 49495, 49500, 49504, 49507, 49509, 49513, 49522, 49525, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49543, 49545, 49548, 49550, 49563, 49599, 49620, 49646, 49657, 49664, 49766, 49775, 49779, 49780, 49783, 49791, 49794, 49799, 49801, 49803, 49805, 49809, 49813, 49815, 49817, 49821, 49823, 49825, 49827, 49829, 49831, 49833, 49835, 49837, 49839, 49841, 49843, 49845, 49847, 49849, 49851, 49855, 49859, 49863, 49867, 49869, 49871, 49875, 49877, 49879, 49881, 49883, 49886, 49891, 49893, 49897, 49919, 49926, 49935, 49938, 49940, 49943, 49945, 49947, 49949, 49952, 49954, 49957, 49959, 49963, 49966, 49968, 49971, 49973, 49975, 49978, 49983, 49985, 49987, 49989, 49992, 49994, 49998, 50001, 50004, 50006, 50010, 50013, 50016, 50019, 50023, 50026, 50029, 50031, 50035, 50038, 50041, 50044, 50048, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50077, 50079, 50082, 50087, 50089, 50092, 50094, 50097, 50099, 50102, 50104, 50108, 50111, 50113, 50116, 50118, 50134, 50141, 50143, 50148, 50151, 50153, 50156, 50158, 50161, 50163, 50166, 50170, 50177, 50179, 50184, 50186, 50189, 50193, 50195, 50198, 50203, 50215, 50330, 50332, 50352, 50353, 50356, 50358, 50360, 50361, 50366, 50368, 50374, 50378, 50380, 50385, 50387, 50389, 50398, 50400, 50402, 50404, 50406, 50410, 50414, 50416, 50418, 50420, 50422, 50424, 50428, 50430, 50433, 50435, 50438, 50440, 50442, 50444, 50447, 50449, 50452, 50454, 50456, 50463, 50468, 50472, 50475, 50477, 50480, 50482, 50484, 50487, 50489, 50492, 50494, 50496, 50498, 50501, 50503, 50506, 50508, 50510, 50512, 50515, 50517, 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, 50623, 50626, 50628, 50632, 50635, 50638, 50640, 50644, 50647, 50650, 50652, 50656, 50659, 50662, 50664, 50668, 50671, 50674, 50676, 50680, 50684, 50688, 50690, 50693, 50695, 50697, 50699, 50702, 50704, 50707, 50709, 50712, 50714, 50717, 50722, 50724, 50726, 50731, 50736, 50742, 50744, 50747, 50762, 50764, 50767, 50769, 50772, 50777, 50784, 50790, 50795, 50802, 50805, 50812, 50932, 50936, 50940, 50959, 50965, 50971, 50975, 50987, 50991, 51003, 51005, 51007, 51009, 51012, 51014, 51016, 51018, 51021, 51024, 51027, 51029, 51031, 51033, 51036, 51038, 51041, 51043, 51045, 51047, 51050, 51059, 51130, 51159, 51161, 51164, 51166, 51168, 51170, 51173, 51175, 51179, 51182, 51185, 51187, 51191, 51194, 51197, 51199, 51206, 51209, 51211, 51215, 51218, 51221, 51223, 51227, 51231, 51234, 51237, 51241, 51247, 51249, 51254, 51256, 51266, 51268, 51273, 51277, 51283, 51285, 51293, 51298, 51304, 51312, 51314, 51329, 51338, 51341, 51345, 51349, 51351, 51354, 51356, 51358, 51363, 51365, 51368, 51370, 51481, 51488, 51496, 51503, 51505, 51509, 51513, 51517, 51521, 51525, 51527, 51547, 51549, 51551, 51553, 51555, 51559, 51563, 51567, 51571, 51575, 51579, 51583, 51585, 51589, 51603, 51617, 51624, 51629, 51634, 51643, 51648, 51655, 51659, 51662, 51664, 51667, 51669, 51671, 51673, 51676, 51678, 51681, 51686, 51691, 51694, 51697, 51699, 51701, 51704, 51706, 51710, 51713, 51716, 51718, 51722, 51725, 51728, 51730, 51734, 51737, 51740, 51743, 51747, 51750, 51753, 51767, 51794, 51817, 51820, 51825, 51828, 51831, 51833, 51836, 51841, 51866, 51895, 51907, 51909, 51914, 51933, 51936, 52060, 52066, 52072, 52077, 52093, 52097, 52099, 52106, 52108, 52110, 52122, 52128, 52200, 52202, 52216, 52274, 52277, 52289, 52294, 52296, 52303, 52317, 52329, 52331, 52335, 52338, 52341, 52343, 52347, 52350, 52353, 52359, 52365, 52367, 52374, 52377, 52379, 52383, 52386, 52389, 52394, 52396, 52398, 52403, 52405, 52408, 52413, 52418, 52420, 52425, 52429, 52432, 52437, 52439, 52442, 52444, 52447, 52449, 52452, 52454, 52456, 52458, 52461, 52466, 52473, 52476, 52481, 52483, 52490, 52497, 52499, 52504, 52506, 52509, 52511) 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: She Stoops To Conquor

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: Love For Love

Afterpiece Title: Harlequin Sorcerer

Song: II: A New Cantata by Hook-DuBellamy; IV: [Duett] Sweet is the Breath of Morn [by Milton-Miss Brown, DuBellamy

Dance: III: The Whim, as17730426

Performances

Mainpiece Title: Lady Jane Grey

Afterpiece Title: Harlequin Sorcerer

Entertainment: End: A New Occasional Epilogue written by Mr Goldsmith will be spoken-Lewes

Performances

Mainpiece Title: The Maid Of The Mill

Afterpiece Title: Harlequin Sorcerer

Song: I: A Song-Miss Twist

Dance: I: A Minuet-Aldridge, Miss Twist; II: The Old Ground Young, as17720928; Epilogue. End Opera: The New Occasional Epilogue written by Dr Goldsmith, will be spoken-Lewes

Performances

Mainpiece Title: She Stoops To Conquor

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Harlequin Sorcerer

Entertainment: Epilogue.After the Play: Goldsmith's Epilogue-Lewes

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Daphne and Amintor

Dance: End: A Hornpipe[, in the character of a Sailor (for first time)-Miss Stede. [See17650510.

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: Daphne and Amintor

Dance: III: Minuets, Cotillons-Merrifield, Dumay, Curtat, Settree, Miss Twist, Mrs Invill, Miss Mathews, Mrs Hartle

Ballet: End: The Wapping Landlady. As17730424 but with a New Hornpipe-Fishar, Mas. Blurton, Sga Manesiere, Miss Twist

Performances

Mainpiece Title: She Stoops To Conquor

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: The Intriguing Chambermaid

Dance: The Fingalian Dance-Mas. Blurton, Miss Besford; Double Hornpipe-Mas. Blurton, Miss Besford. [See17720921.

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: The Upholsterer

Dance: II: Fingalian Dance, as17730929; Double Hornpipe, as17730929

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: Love a-la-Mode

Dance: III: Fingalian Dance, as17730929; Double Hornpipe, as17730929; IV: The Irish Lilt-Aldridge, Miss Twist. [See17721028.

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: Cross Purposes

Dance: II: The Irish Lilt, as17731005; End Opera: The Corsican Sailors [Punch House]-Fishar, Miss Twist. [See17720930.

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: Love a-la-Mode

Dance: III: The Fingalian Dance, as17730929; Double Hornpipe, as17730929; IV: A Dance-Aldridge, Miss Capon

Performances

Mainpiece Title: She Stoops To Conquer

Afterpiece Title: The Musical Lady

Dance: II: The Irish Lilt-, as17731005, but Miss _Twist, Miss Valois; End: +New Dance, as17731021

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: Comus

Dance: III: The Irish Lilt, as17731110

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: Harlequin Dr Faustus

Dance: III: Dance-Aldridge, Miss Capon. [See17731014]

Performances

Mainpiece Title: The West Indian

Afterpiece Title: The Golden Pippin

Dance: End: A Dance, as17731014

Performances

Mainpiece Title: Othello

Afterpiece Title: Harlequin Dr Faustus

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: Harlequin Dr Faustus

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: Harlequin Dr Faustus

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: The Golden Pippin

Dance: End: A Dance, as17731014

Performances

Mainpiece Title: The Miser

Afterpiece Title: The Golden Pippin

Dance: End: A Dance, as17731014

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: Harlequin Dr Faustus

Dance: III: The Fingalian Dance, as17730929; Double Hornpipe, as17730929

Performances

Mainpiece Title: She Stoops To Conquer

Afterpiece Title: Harlequin Dr Faustus