SELECT * FROM london_stages WHERE eventid IN (33335, 33345, 33347, 33349, 33356, 33359, 33361, 33363, 33365, 33368, 33370, 33373, 33375, 33377, 33379, 33384, 33387, 33391, 33398, 33405, 33410, 33415, 33417, 33424, 33456, 33466, 33470, 33484, 33490, 33527, 33541, 33544, 33546, 33549, 33560, 33586, 33608, 33634, 33641, 33645, 33660, 33665, 33694, 33699, 33708, 33711, 33716, 33731, 33793, 33795, 33797, 33809, 33813, 33817, 33820, 33824, 33826, 33832, 33836, 33840, 33842, 33844, 33846, 33848, 33850, 33852, 33854, 33858, 33861, 33865, 33867, 33874, 33876, 33880, 33883, 33885, 33888, 33890, 33892, 33894, 33897, 33899, 33902, 33904, 33906, 33908, 33911, 33913, 33916, 33918, 33920, 33925, 33927, 33932, 33934, 33939, 33946, 33951, 33965, 33968, 33970, 33973, 33977, 33983, 33985, 33990, 33992, 34023, 34029, 34037, 34041, 34049, 34051, 34064, 34066, 34070, 34076, 34083, 34103, 34116, 34142, 34169, 34179, 34185, 34193, 34198, 34205, 34208, 34210, 34213, 34218, 34223, 34230, 34235, 34238, 34243, 34245, 34250, 34253, 34259, 34266, 34337, 34340, 34341, 34345, 34349, 34351, 34354, 34356, 34366, 34368, 34375, 34377, 34380, 34382, 34384, 34388, 34390, 34394, 34398, 34403, 34405, 34409, 34411, 34415, 34417, 34419, 34422, 34427, 34432, 34434, 34436, 34441, 34443, 34448, 34453, 34457, 34460, 34466, 34469, 34471, 34474, 34476, 34478, 34480, 34483, 34485, 34488, 34490, 34499, 34506, 34514, 34519, 34521, 34524, 34526, 34528, 34530, 34532, 34534, 34537, 34539, 34542, 34544, 34546, 34548, 34551, 34553, 34556, 34558, 34560, 34562, 34565, 34567, 34570, 34572, 34574, 34576, 34579, 34581, 34584, 34586, 34588, 34590, 34596, 34598, 34601, 34612, 34622, 34637, 34654, 34668, 34670, 34679, 34684, 34694, 34708, 34713, 34718, 34723, 34725, 34728, 34730, 34733, 34735, 34737, 34739, 34742, 34744, 34750, 34754, 34757, 34759, 34762, 34764, 34771, 34773, 34778, 34782, 34785, 34787, 34794, 34796, 34797, 34802, 34803, 34805, 34808, 34816, 34821, 34824, 34826, 34840, 34841, 34843, 34844, 34846, 34848, 34851, 34853, 34854, 34855, 34856, 34857, 34858, 34860, 34861, 34863, 34864, 34865, 34867, 34868, 34869, 34871, 34872, 34873, 34874, 34876, 34877, 34878, 34879, 34880, 34881, 34882, 34883, 34884, 34892, 34894, 34896, 34898, 34904, 34908, 34910, 34912, 34914, 34916, 34922, 34928, 34930, 34934, 34938, 34942, 34944, 34946, 34950, 34952, 34954, 34956, 34962, 34967, 34969, 34976, 34992, 34999, 35006, 35018, 35020, 35049, 35056, 35071, 35075, 35079, 35091, 35095, 35098, 35105, 35109, 35112, 35114, 35117, 35119, 35121, 35123, 35126, 35128, 35130, 35133, 35136, 35139, 35141, 35144, 35146, 35148, 35150, 35153, 35155, 35158, 35161, 35163, 35165, 35168, 35170, 35173, 35175, 35178, 35180, 35183, 35185, 35188, 35193, 35196, 35198, 35203, 35208, 35211, 35214, 35219, 35224, 35228, 35231, 35244, 35251, 35261, 35270, 35273, 35280, 35282, 35287, 35300, 35306, 35309, 35311, 35314, 35317, 35325, 35328, 35331, 35341, 35344, 35346, 35347, 35349, 35353, 35358, 35359, 35361, 35363, 35364, 35369, 35376, 35383, 35385, 35389, 35396, 35403, 35418, 35424, 35429, 35432, 35436, 35438, 35440, 35443, 35446, 35448, 35450, 35452, 35454, 35456, 35462, 35466, 35468, 35470, 35473, 35477, 35479, 35480, 35482, 35486, 35487, 35492, 35497, 35502, 35504, 35509, 35512, 35514, 35517, 35519, 35534, 35536, 35542, 35544, 35546, 35548, 35550, 35552, 35554, 35556, 35561, 35563, 35565, 35567, 35569, 35571, 35574, 35576, 35578, 35580, 35586, 35588, 35590, 35601, 35611, 35613, 35627, 35630, 35643, 35648, 35651, 35660, 35668, 35673, 35675, 35677, 35679, 35682, 35684, 35687, 35689, 35692, 35694, 35697, 35700, 35703, 35705, 35708, 35710, 35713, 35715, 35717, 35719, 35722, 35724, 35727, 35729, 35732, 35734, 35737, 35739, 35742, 35745, 35748, 35750, 35752, 35755, 35757, 35760, 35762, 35764, 35767, 35770, 35772, 35775, 35779, 35782, 35784, 35789, 35793, 35798, 35803, 35808, 35827, 35830, 35835, 35840, 35843, 35845, 35850, 35855, 35857, 35861, 35866, 35869, 35871, 35875, 35877, 35880, 35882, 35884, 35887, 35890, 35893, 35895, 35898, 35900, 35908, 35911, 35914, 35917, 35923, 35925, 35928, 35930, 35933, 35935, 35941, 35944, 35946, 35948, 35955, 35968, 35977, 35982, 35984, 35987, 35995, 36132, 36136, 36138, 36140, 36142, 36150, 36158, 36164, 36167, 36169, 36171, 36173, 36175, 36177, 36180, 36182, 36185, 36187, 36189, 36191, 36194, 36196, 36198, 36200, 36202, 36204, 36207, 36209, 36211, 36213, 36215, 36218, 36220, 36222, 36224, 36226, 36228, 36233, 36247, 36249, 36256, 36258, 36261, 36265, 36278, 36283, 36285, 36288, 36290, 36292, 36294, 36297, 36299, 36304, 36306, 36309, 36311, 36314, 36316, 36318, 36325, 36327, 36332, 36337, 36342, 36346, 36348, 36351, 36353, 36356, 36358, 36360, 36363, 36366, 36375, 36407, 36450, 36469, 36476, 36478, 36480, 36495, 36498, 36500, 36503, 36507, 36514, 36522, 36524, 36530, 36536, 36538, 36541, 36550, 36553, 36556, 36637, 36640, 36652, 36666, 36668, 36670, 36679, 36683, 36685, 36689, 36691, 36693, 36695, 36697, 36701, 36703, 36705, 36709, 36713, 36715, 36718, 36720, 36723, 36725, 36727, 36737, 36753, 36785, 36788, 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, 36863, 36867, 36872, 36874, 36876, 36879, 36882, 36884, 36887, 36889, 36896, 36898, 36901, 36903, 36905, 36910, 36921, 36956, 36958, 36964, 36970, 36973, 36975, 36981, 36986, 36989, 36991, 36997, 37003, 37006, 37009, 37012, 37015, 37026, 37029, 37032, 37037, 37045, 37047, 37050, 37061, 37064, 37067, 37072, 37074, 37077, 37079, 37086, 37087, 37089, 37093, 37099, 37103, 37109, 37111, 37114, 37116, 37120, 37128, 37137, 37141, 37143, 37146, 37150, 37151, 37152, 37154, 37155, 37159, 37167, 37168, 37173, 37175, 37177, 37178, 37179, 37180, 37183, 37186, 37190, 37193, 37199, 37201, 37204, 37207, 37213, 37217, 37228, 37230, 37232, 37236, 37246, 37250, 37252, 37256, 37258, 37263, 37271, 37275, 37279, 37283, 37287, 37289, 37291, 37293, 37302, 37306, 37308, 37316, 37320, 37327, 37332, 37334, 37336, 37341, 37344, 37346, 37348, 37353, 37360, 37362, 37367, 37372, 37374, 37379, 37383, 37385, 37387, 37389, 37401, 37411, 37425, 37446, 37449, 37461, 37463, 37466, 37471, 37473, 37476, 37546, 37549, 37568, 37575, 37578, 37580, 37593, 37595, 37605, 37612, 37614, 37619, 37624, 37629, 37636, 37638, 37649, 37654, 37657, 37663, 37666, 37668, 37686, 37698, 37709, 37711, 37715, 37718, 37720, 37725, 37728, 37730, 37732, 37734, 37737, 37739, 37742, 37744, 37746, 37748, 37749, 37754, 37758, 37760, 37762, 37765, 37766, 37770, 37776, 37779, 37782, 37784, 37786, 37798, 37802, 37806, 37810, 37814, 37816, 37820, 37826, 37830, 37834, 37838, 37840, 37842, 37844, 37846, 37850, 37853, 37855, 37859, 37863, 37865, 37867, 37871, 37873, 37876, 37879, 37881, 37883, 37885, 37888, 37890, 37892, 37896, 37901, 37903, 37906, 37908, 37912, 37915, 37917, 37922, 37924, 37926, 37929, 37931, 37934, 37942, 37944, 37946, 37948, 37950, 37952, 37955, 37957, 37959, 37961, 37963, 37976, 37983, 38006, 38027, 38029, 38036, 38046, 38048, 38063, 38079, 38084, 38094, 38103, 38108, 38113, 38119, 38129, 38139, 38144, 38160, 38168, 38189, 38201, 38203, 38206, 38218, 38225, 38231, 38243, 38245, 38247, 38310, 38311, 38314, 38316, 38319, 38331, 38335, 38338, 38342, 38344, 38346, 38350, 38352, 38354, 38356, 38360, 38362, 38365, 38368, 38370, 38374, 38377, 38379, 38382, 38388, 38397, 38402, 38408, 38411, 38413, 38416, 38418, 38421, 38423, 38426, 38428, 38430, 38432, 38435, 38437, 38440, 38442, 38444, 38446, 38449, 38451, 38454, 38456, 38458, 38460, 38463, 38465, 38468, 38470, 38472, 38474, 38478, 38480, 38482, 38484, 38486, 38489, 38491, 38493, 38495, 38497, 38499, 38501, 38503, 38506, 38508, 38510, 38512, 38517, 38520, 38522, 38524, 38526, 38529, 38531, 38535, 38537, 38539, 38541, 38544, 38546, 38548, 38550, 38552, 38555, 38557, 38560, 38562, 38566, 38569, 38571, 38574, 38576, 38579, 38581, 38584, 38586, 38589, 38594, 38604, 38609, 38612, 38620, 38625, 38628, 38630, 38635, 38640, 38643, 38650, 38657, 38659, 38664, 38674, 38681, 38683, 38688, 38690, 38693, 38695, 38701, 38704, 38707, 38710, 38712, 38727, 38737, 38742, 38756, 38762, 38769, 38772, 38779, 38786, 38791, 39351, 39355, 39361, 39362, 39365, 39368, 39371, 39374, 39376, 39377, 39385, 39392, 39395, 39400, 39401, 39412, 39418, 39420, 39422, 39423, 39424, 39427, 39430, 41214, 41548) 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: Edward And Eleonora

Afterpiece Title: The Padlock

Cast
Role: Leander Actor: DuBellamy

Dance: End Epilogue: The Vintage Festival, as17741007

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: The Golden Pippin, with Additional Songs

Cast
Role: Mercury Actor: DuBellamy

Song: End Piece: The Soldier Tir'd of War's Alarms, from the Opera Artaxerxes-Miss Catley

Dance: End Opera: Rural Merriment, as17741209

Performances

Mainpiece Title: Cleonice

Afterpiece Title: The Golden Pippin

Cast
Role: Mercury Actor: DuBellamy

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: Comus

Cast
Role: 2nd Bacchanal Actor: DuBellamy

Dance: End Opera: The Frolick, as17741214

Performances

Mainpiece Title: She Stoops To Conquer

Cast
Role: Hastings Actor: DuBellamy

Afterpiece Title: The Jubilee at Stratford upon avon

Dance: End I Afterpiece: The Vintage Festival, as17741007

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Worthy Actor: DuBellamy

Afterpiece Title: The Irish Widow

Dance: II: The Grand Garland Dance, as17750406 End I Afterpiece: The Irish Fair, as17740917

Performances

Mainpiece Title: Artaxerxes

Cast
Role: Rimenes Actor: DuBellamy

Afterpiece Title: The Upholsterer

Dance: End Opera: The Merry Sailors, as17741026

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: The Apprentice

Dance: I: A Hornpipe-Miss Cranfield; II: The Pilgrim, as17750503

Performances

Mainpiece Title: She Stoops To Conquer

Afterpiece Title: The Two Misers

Dance: End: The Enchantress, as17750201

Song: II: By Particular Desire, the favorite song Kate of Aberdeen-DuBellamy

Performances

Mainpiece Title: The Conscious Lovers

Cast
Role: a Song Actor: DuBellamy.

Afterpiece Title: The Druids

Dance: III: Double Hornpipe-Blurton, Miss Mathews; IV: The Humours of Blackwall, as17750429

Performances

Mainpiece Title: The Maid Of The Mill

Cast
Role: Mervin Actor: DuBellamy

Afterpiece Title: Cross Purposes

Dance: A New Comic Dance call'dThe Country Macaroni Assembly-Daguville, Daguville's Scholar; in which (by Desire) Minuet-Helme, Sga Vidini; End Opera: A New Dance call'd The British Bacchanalian , or The Hop-Pickers, an Interlude of Singing and Dancing,-Helme, Sga Vidini; in which The Wooden Shoe Dance- introduced by Daguville

Ballet: II: A New Grand Historical Dance of Warriors, call'd Boadicea Queen of Britain. Queen-Mrs Daguville; her Two Daughters-Miss Ross, Miss Armstrong (Scholars to Daguville); Helme, Daguville

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Author

Cast
Role: Sprightly Actor: DuBellamy

Dance: As17750515

Performances

Mainpiece Title: Cymbeline

Cast
Role: Guiderius Actor: DuBellamy

Afterpiece Title: The Upholsterer

Dance: III: The Enchantress, as17750201

Performances

Mainpiece Title: She Stoops To Conquer

Afterpiece Title: The Country Madcap

Song: II: (By Desire) Kate of Aberdeen-DuBellamy

Dance: End: The Pilgrim, as17750503

Performances

Mainpiece Title: The Maid Of The Mill

Cast
Role: Aimworth Actor: DuBellamy

Afterpiece Title: Cross Purposes

Dance: End: The Pilgrim, as17750503

Performances

Mainpiece Title: The Merchant Of Venice

Cast
Role: Lorenzo Actor: DuBellamy.

Afterpiece Title: Love a-la-Mode

Dance: III: A New Comic Dance -Langrish, as17750429 End: The Enchantress, as17750201

Performances

Mainpiece Title: The Miser

Afterpiece Title: The Padlock

Cast
Role: Leander Actor: DuBellamy

Dance: III: The Humours of Blackwall, as17750429

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The Padlock

Cast
Role: Leander Actor: DuBellamy

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: DuBellamy

Afterpiece Title: The Tobacconist

Monologue: Interlude: Scene from The Register Office. Gulwell-Lloyd; Little Girl-Miss Frances; New Character-Mrs Gardner

Entertainment: Imitations Vocal and Rhetorical-Bannister

Performances

Afterpiece Title: St Patrick's Day; or, The Scheming Lieutenant

Performances

Mainpiece Title: The Maid Of The Mill

Cast
Role: Mervin Actor: DuBellamy

Afterpiece Title: The Deuce Is in Him

Cast
Role: Belford Actor: DuBellamy

Dance: End Opera: The Pilgrim-Harris, Miss Matthews. [See17750503.

Performances

Mainpiece Title: Much Ado About Nothing

Cast
Role: Balthazar Actor: DuBellamy

Afterpiece Title: The Padlock

Cast
Role: Leander Actor: DuBellamy

Performances

Mainpiece Title: She Stoops To Conquer

Cast
Role: Hastings Actor: DuBellamy

Afterpiece Title: St Patrick's Day

Dance: II: A New Grand Ballet, The Italian Gardeners-; End Comedy: [A New Dance call'd The Gamesters-Sg and Sga Zuchelli[, being their first appearance in England. [For Italian Gardeners see17740919.