SELECT * FROM london_stages WHERE eventid IN (12339, 12397, 12399, 12401, 12402, 12405, 12408, 12411, 12413, 12416, 12418, 12419, 12421, 12424, 12426, 12429, 12430, 12432, 12433, 12435, 12436, 12439, 12441, 12446, 12448, 12449, 12451, 12453, 12455, 12457, 12459, 12464, 12466, 12468, 12470, 12477, 12480, 12485, 12486, 12509, 12550, 12562, 12564, 12642, 12657, 12691, 12715, 12721, 12744, 12759, 12762, 12764, 12774, 12778, 12781, 12783, 12787, 12793, 12807, 12811, 12813, 12815, 12820, 12842, 12879, 12883, 12885, 12942, 12994, 13000, 13074, 13081, 13085, 13089, 13092, 13096, 13099, 13103, 13176, 13275, 13316, 13328, 13333, 13341, 13345, 13374, 13381, 13399, 13410, 13414, 13424, 13434, 13455, 13577, 13653, 13656, 13659, 13662, 13666, 13669, 13673, 13676, 13679, 13682, 13686, 13690, 13694, 13701, 13705, 13740, 13754, 13758, 13762, 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, 13964, 13986, 13989, 13997, 14001, 14004, 14043, 14051, 14057, 14063, 14082, 14108, 14123, 14135, 14140, 14161, 14164, 14181, 14187, 14206, 14216, 14229, 14231, 14252, 14267, 14274, 14289, 14290, 14293, 14297, 14300, 14301, 14302, 14306, 14313, 14316, 14319, 14322, 14325, 14352, 14355, 14358, 14361, 14364, 14370, 14373, 14377, 14380, 14384, 14387, 14391, 14392, 14395, 14398, 14401, 14404, 14407, 14410, 14413, 14416, 14423, 14426, 14432, 14436, 14443, 14452, 14459, 14463, 14478, 14486, 14489, 14503, 14518, 14522, 14525, 14528, 14531, 14535, 14544, 14550, 14556, 14559, 14642, 14669, 14674, 14677, 14716, 14720, 14724, 14736, 14745, 14750, 14756, 14760, 14765, 14776, 14780, 14791, 14800, 14805, 14811, 14817, 14833, 14836, 14851, 14855, 14859, 14871, 14876, 14881, 14887, 14898, 14906, 14910, 14913, 14917, 14919, 14923, 14927, 14935, 14946, 14963, 14966, 14970, 14974, 14977, 14986, 14989, 14991, 14992, 14993, 15000, 15001, 15002, 15005, 15006, 15008, 15011, 15012, 15013, 15023, 15032, 15034, 15036, 15038, 15041, 15043, 15046, 15050, 15058, 15062, 15067, 15071, 15075, 15079, 15088, 15097, 15103, 15107, 15111, 15114, 15118, 15121, 15124, 15131, 15140, 15144, 15191, 15208, 15210, 15213, 15216, 15220, 15236, 15240, 15245, 15254, 15259, 15280, 15284, 15288, 15291, 15300, 15303, 15307, 15310, 15330, 15333, 15339, 15342, 15348, 15355, 15361, 15364, 15374, 15383, 15387, 15390, 15394, 15399, 15437, 15451, 15455, 15465, 15484, 15498, 15505, 15517, 15518, 15526, 15546, 15551, 15563, 15566, 15570, 15573, 15577, 15584, 15586, 15599, 15601, 15604, 15607, 15610, 15618, 15634, 15643, 15649, 15751, 15755, 15759, 15764, 15876, 15880, 15891, 15910, 15953, 15974, 15981, 16008, 16091, 16097, 16118, 16365, 16369, 16374, 16383, 16387, 16398, 16487, 16578, 16599, 16686, 16690, 16693, 16697, 16701, 16772, 16849, 16917, 16929, 16936, 16940, 17037, 17043, 17050, 17206, 17287, 17292, 17297, 17304, 17314, 17317, 17320, 17327, 17332, 17345, 17346, 17349, 17405, 17406, 17408, 17412, 17414, 17438, 17451, 17454, 17457, 17460, 17463, 17466, 17468, 17471, 17472, 17475, 17477, 17481, 17486, 17490, 17493, 17495, 17498, 17501, 17514, 17517, 17522, 17531, 17533, 17536, 17539, 17545, 17547, 17550, 17553, 17556, 17559, 17566, 17569, 17573, 17576, 17583, 17593, 17607, 17610, 17624, 17633, 17650, 17663, 17670, 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, 17821, 17911, 17968, 17975, 17980, 18010, 18016, 18054, 18058, 18086, 18088, 18096, 18120, 18166, 18168, 18173, 18174, 18175, 18176, 18178, 18187, 18207, 18217, 18227, 18243, 18268, 18276, 18287, 18294, 18298, 18387, 18390, 18397, 18401, 18404, 18407, 18411, 18445, 18452, 18459, 18463, 18469, 18482, 18560, 18620, 18728, 18803, 18863, 18864, 18878, 18885, 18899, 18905, 18906, 18908, 18910, 18912, 18915, 18917, 18920, 18922, 18928, 18930, 18932, 18940, 18968, 18975, 18989, 18993, 18996, 19001, 19003, 19019, 19022, 19040, 19047, 19050, 19052, 19055, 19057, 19082, 19084, 19087, 19094, 19150, 19162, 19180, 19187, 19190, 19200, 19224, 19236, 19238, 19240, 19242, 19254, 19270, 19272, 19276, 19277, 19290, 19292, 19294, 19303, 19309, 19311, 19322, 19326, 19332, 19336, 19340, 19342, 19344, 19350, 19352, 19354, 19360, 19362, 19364, 19366, 19368, 19370, 19381, 19386, 19388, 19390, 19392, 19396, 19398, 19403, 19405, 19409, 19415, 19418, 19423, 19425, 19427, 19429, 19436, 19440, 19444, 19451, 19453, 19459, 19491, 19501, 19506, 19508, 19512, 19514, 19518, 19525, 19531, 19540, 19543, 19545, 19547, 19549, 19562, 19568, 19570, 19572, 19585, 19588, 19597, 19599, 19603, 19605, 19607, 19611, 19613, 19617, 19619, 19620, 19623, 19625, 19641, 19642, 19644, 19651, 19661, 19664, 19666, 19671, 19673, 19675, 19679, 19681, 19685, 19695, 19697, 19707, 19709, 19721, 19725, 19739, 19741, 19751, 19753, 19757, 19795, 19800, 19803, 19810, 19818, 19820, 19827, 19834, 19839, 19840, 19848, 19850, 19852, 19855, 19857, 19878, 19883, 19890, 19892, 19906, 19908, 19918, 19921, 19938, 19941, 19947, 19951, 19954, 19960, 19968, 19983, 19987, 19993, 20005, 20009, 20012, 20015, 20017, 20020, 20032, 20038, 20051, 20055, 20060, 20065, 20069, 20074, 20079, 20087, 20090, 20092, 20095, 20110, 20129, 20130, 20132, 20133, 20135, 20137, 20139, 20141, 20143, 20147, 20149, 20153, 20155, 20157, 20160, 20175, 20181, 20187, 20202, 20211, 20214, 20220, 20223, 20227, 20230, 20236, 20239, 20264, 20279, 20289, 20304, 20314, 20329, 20332, 20401, 20465, 20500, 20542, 20564, 20567, 20573, 20583, 20593, 20603, 20607, 20617, 20621, 20627, 20630, 20637, 20646, 20650, 20656, 20662, 20668, 20671, 20675, 20693, 20695, 20711, 20712, 20714, 20720, 20722, 20725, 20729, 20732, 20735, 20739, 20742, 20745, 20751, 20753, 20774, 20780, 20786, 20799, 20805, 20814, 20817, 20825, 20845, 20857, 20860, 20864, 20867, 20872, 20875, 20886, 20892, 20895, 20898, 20924, 20937, 20948, 20951, 20955, 20960, 20970, 20990, 21000, 21004, 21033, 21037, 21048, 21056, 21059, 21069, 21072, 21076, 21096, 21099, 21123, 21136, 21139, 21150, 21153, 21157, 21161, 21165, 21168, 21191, 21195, 21212, 21217, 21234, 21237, 21242, 21246, 21250, 21254, 21257, 21260, 21262, 21284, 21287, 21295, 21308, 21310, 21316, 21321, 21322, 21326, 21338, 21339, 21341, 21342, 21347, 21352, 21354, 21359, 21360, 21366, 21370, 21376, 21378, 21382, 21386, 21390, 21392, 21394, 21398, 21405, 21418, 21420, 21451, 21462, 21473, 21476, 21495, 21498, 21506, 21517, 21524, 21531, 21534, 21546, 21551, 21561, 21564, 21567, 21573, 21584, 21593, 21598, 21609, 21623, 21626, 21635, 21638, 21667, 21680, 21690, 21693, 21712, 21719, 21733, 21736, 21754, 21771, 21776, 21779, 21781, 21783, 21785, 21792, 21799, 21801, 21805, 21811, 21816, 21819, 21823, 21831, 22833, 22834, 22941, 22944, 22956, 22958, 22961, 22967, 22975, 23000, 23002, 23011, 23052, 23055, 23087, 23090, 23106, 23124, 23127, 23150, 23156, 23165, 23175, 23223, 23235, 23247, 23301, 23349, 23351, 23360, 23369, 23373, 23382, 23387, 23389, 23433, 23445, 23501, 23509, 23553, 23593, 23600, 23606, 23609, 23724, 23727, 23746, 23771, 23783, 23836, 23839, 23859, 23861, 23875, 23894, 23988, 23990, 23993, 23994, 23996, 24001, 24014, 24023, 24024, 24073, 24159, 24235, 24351, 24370, 24427, 24433, 24436, 24438, 24441, 24444, 24447, 24448, 24451, 24454, 24457, 24460, 24463, 24466, 24477, 24503, 24536, 24564, 24570, 24580, 24582, 24621, 24641, 24692, 24712, 24797, 24802, 24873, 24990, 25044, 25059, 25136, 25295, 25319, 25338, 25340, 25342, 25344, 25346, 25348, 25350, 25352, 25354, 25356, 25358, 25360, 25362, 25372, 25393, 25395, 25411, 25433, 25441, 25479, 25490, 25500, 25520, 25524, 25541, 25548, 25550, 25552, 25576, 25628, 25655, 25721, 25728, 25896, 26203, 26305, 26308, 26314, 26335, 26589, 26639, 26641, 26687, 26819, 26862, 26907, 27095, 27100, 27144, 27196, 27198, 27200, 27206, 27342, 27665, 27690, 27692, 27722, 27763, 28078, 28096, 28219, 28476, 28547, 28607, 28633, 28667, 28844, 29052, 29061, 29085, 29237, 29542, 29593, 29776, 30297, 30383, 30684, 30791, 31413, 31777, 31915, 31991, 32666, 32901, 32903, 32908, 32915, 32920, 32930, 32935, 32969, 32985, 33005, 33042, 33181) 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: Richard Iii

Cast
Role: Blunt Actor: Raftor.

Song: II: Song-Beard

Music: IV: Concerto-Veracini

Dance: V: Grand Serious Ballet, as17421005

Performances

Mainpiece Title: King Lear And His Three Daughters

Afterpiece Title: The Virgin Unmaskd

Cast
Role: Thomas Actor: Raftor

Song: II: Song-Beard; IV: Song-Lowe

Music: III: Concerto-Piantinada

Performances

Mainpiece Title: Richard Iii

Cast
Role: Blunt Actor: Raftor.

Dance: I: Les Matelotes, as17421009; III: Grand Serious Ballet, as17421005; V: Turkish Seraglio, as17421027

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Scale Actor: Raftor

Afterpiece Title: Miss Lucy in Town

Dance: II: Grand Serious Ballet, as17421005; Turkish Seraglio, as17421027

Song: III: Happy Pair-Beard

Performances

Mainpiece Title: The Beggars Opera

Cast
Role: Filch Actor: Raftor.

Afterpiece Title: Miss Lucy in Town

Performances

Mainpiece Title: The Rehearsal

Cast
Role: Vocal Parts Actor: Beard, Lowe, Raftor, Ray

Afterpiece Title: Miss Lucy in Town

Dance: I: Grand Serious Ballet, as17421005

Music: IV: Concerto-Veracini

Performances

Mainpiece Title: Richard Iii

Cast
Role: Blunt Actor: Raftor.

Dance: II: Grand Serious Ballet, as17421005; V: La Mascarada, as17421009

Song: III: Song-Beard

Performances

Mainpiece Title: King Richard Iii

Cast
Role: Vocal Parts Actor: Beard, Lowe, Raftor, Ray

Dance: As17421108

Song: Beard, Lowe

Performances

Mainpiece Title: The Provoked Wife

Cast
Role: Taylor Actor: Raftor

Afterpiece Title: Miss Lucy in Town

Dance: II: La Mascarada-Brunoro, Mlle Bonneval; IV: Turkish Seraglio-Brunoro,Signora Costanza

Music: III: Concerto-Piantinada

Performances

Mainpiece Title: The Miser

Cast
Role: Furnish Actor: Raftor

Song: I: Beard; III: Lowe

Dance: II: Turkish Seraglio, as17421112; IV: Les Moisoneurs de la Styrie-Torinese, Signora Aquilanti, Boromeo, Mlle Bonneval

Performances

Mainpiece Title: The Provoked Wife

Cast
Role: Taylor Actor: Raftor

Afterpiece Title: Miss Lucy in Town

Dance: II: Grand Comic Dance, as17421130; V: Les Moisoneurs de la Styrie-Checo, Signora Chiaretti

Performances

Mainpiece Title: The Beggars Opera

Cast
Role: Filch Actor: Raftor.

Dance: I: Grand Comic Dance, as17421117; II: Les Moisoneurs de la Styrie, as17421201

Performances

Mainpiece Title: The Rehearsal

Cast
Role: Vocal Parts Actor: Beard, Lowe, Raftor, Ray

Dance: I: Peasant Dance, as17420921; III: Tyrolean Dance, as17421129

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Scale Actor: Raftor

Afterpiece Title: The Devil to Pay

Cast
Role: Butler Actor: Raftor

Song: I: Beard; IV: Lowe

Performances

Mainpiece Title: The Rehearsal

Cast
Role: Vocal Parts Actor: Beard, Lowe, Raftor, Ray

Dance: I: Les Moisoneurs de la Styrie, as17421201; III: La Recrue des Houssars, as17421211

Performances

Mainpiece Title: Richard Iii

Cast
Role: Blunt Actor: Raftor.

Song: As17421204

Music: III: Concerto-Piantanida

Performances

Mainpiece Title: The Miser

Cast
Role: Furnish Actor: Raftor

Dance: II: Les Moisoneurs de la Styrie, as17421126; IV: La Recrue des Houssars, as17421221

Performances

Mainpiece Title: The Tender Husband

Afterpiece Title: The Devil to Pay

Cast
Role: Butler Actor: Raftor

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

Performances

Mainpiece Title: Love For Love

Afterpiece Title: The Devil to Pay

Cast
Role: Butler Actor: Raftor

Song: I: Beard; IV: Lowe

Music: III: A Concerto on Violincello-Cervetti; V: A Concerto-Piantinida

Performances

Mainpiece Title: Richard Iii

Cast
Role: Blunt Actor: Raftor.

Song: II: Beard; IV: Lowe

Music: Concerto on Violincello-Cervetti

Performances

Mainpiece Title: The Rehearsal

Cast
Role: Vocal Parts Actor: Beard, Lowe, Raftor, Ray

Song: I: Beard; III: Lowe

Music: II: Concerto on German Flute-Burk Thumoth

Performances

Mainpiece Title: Richard Iii

Cast
Role: Blunt Actor: Raftor.

Dance: II: Grand Serious Ballet, as17421005

Song: III: Song-Lowe

Music: IV: Concerto-Piantanida

Performances

Mainpiece Title: The Beggars Opera

Cast
Role: Filch Actor: Raftor.

Dance: I: Neopolitan Punch-Chico, Sga Chiaretta, Mlle Bonneval; II: Italian Gardeners, as17421231

Performances

Mainpiece Title: King Lear

Afterpiece Title: The Virgin Unmaskd

Cast
Role: Thomas Actor: Raftor

Song: II: Beard; III: Lowe

Music: IV: Concerto on German Flute-Burk Thumoth

Performances

Mainpiece Title: The Rehearsal

Cast
Role: Vocal Parts Actor: Beard, Lowe, Raftor, Ray

Afterpiece Title: The Devil to Pay

Cast
Role: Butler Actor: Raftor

Music: I: Concerto on German Flute-Burk Thumoth; IV: Concerto-Piantanida

Song: II: Baard