SELECT * FROM london_stages WHERE eventid IN (15729, 15730, 15845, 15871, 15876, 15880, 15884, 15891, 15899, 15906, 15910, 15945, 15949, 15953, 15956, 15964, 15981, 15997, 16004, 16008, 16012, 16016, 16021, 16049, 16054, 16058, 16070, 16091, 16097, 16101, 16107, 16114, 16118, 16129, 16135, 16147, 16151, 16156, 16160, 16164, 16168, 16172, 16176, 16186, 16190, 16194, 16200, 16204, 16210, 16214, 16218, 16222, 16228, 16232, 16238, 16244, 16260, 16327, 16335, 16347, 16365, 16369, 16374, 16383, 16387, 16394, 16398, 16435, 16451, 16455, 16461, 16485, 16487, 16492, 16499, 16500, 16503, 16504, 16509, 16510, 16514, 16515, 16517, 16522, 16525, 16531, 16534, 16537, 16539, 16540, 16541, 16542, 16547, 16578, 16586, 16591, 16599, 16602, 16608, 16618, 16621, 16630, 16632, 16635, 16636, 16642, 16644, 16650, 16661, 16686, 16690, 16693, 16697, 16701, 16716, 16720, 16725, 16736, 16739, 16744, 16747, 16752, 16756, 16761, 16772, 16799, 16840, 16849, 16853, 16865, 16869, 16917, 16929, 16936, 16940, 16980, 16984, 17005, 17037, 17043, 17050, 17075, 17097, 17117, 17188, 17231, 17243, 17260, 17264, 17271, 17275, 17284, 17301, 17327, 17349, 17361, 17368, 17372, 17375, 17376, 17379, 17386, 17392, 17397, 17406, 17408, 17412, 17414, 17419, 17444, 17451, 17454, 17457, 17460, 17463, 17466, 17468, 17471, 17472, 17475, 17477, 17481, 17486, 17490, 17493, 17495, 17498, 17501, 17511, 17514, 17517, 17522, 17525, 17528, 17531, 17533, 17536, 17539, 17542, 17545, 17547, 17550, 17556, 17559, 17569, 17573, 17576, 17580, 17583, 17593, 17607, 17610, 17615, 17633, 17663, 17667, 17670, 17673, 17679, 17686, 17689, 17693, 17697, 17700, 17702, 17706, 17710, 17713, 17718, 17720, 17723, 17727, 17730, 17734, 17738, 17741, 17745, 17749, 17753, 17757, 17764, 17768, 17771, 17775, 17781, 17784, 17787, 17790, 17794, 17798, 17800, 17803, 17807, 17811, 17814, 17818, 17821, 17827, 17831, 17833, 17841, 17845, 17850, 17855, 17860, 17873, 17883, 17890, 17942, 17968, 17976, 18016, 18038, 18054, 18058, 18075, 18088, 18096, 18104, 18134, 18166, 18168, 18173, 18174, 18175, 18176, 18178, 18180, 18183, 18187, 18198, 18207, 18221, 18269, 18272, 18274, 18279, 18282, 18284, 18287, 18294, 18298, 18354, 18357, 18375, 18387, 18390, 18397, 18401, 18407, 18411, 18423, 18426, 18430, 18439, 18445, 18452, 18463, 18469, 18471, 18475, 18479, 18482, 18488, 18492, 18495, 18503, 18515, 18519, 18526, 18530, 18533, 18538, 18541, 18551, 18560, 18563, 18567, 18577, 18602, 18607, 18614, 18620, 18625, 18635, 18646, 18657, 18663, 18682, 18708, 18723, 18728, 18765, 18784, 18794, 18803, 18807, 18812, 18816, 18819, 18826, 18839, 18859, 18860, 18863, 18864, 18868, 18872, 18878, 18880, 18882, 18885, 18891, 18896, 18899, 18901, 18905, 18906, 18908, 18910, 18912, 18915, 18917, 18920, 18922, 18928, 18930, 18932, 18934, 18936, 18938, 18940, 18942, 18954, 18956, 18973, 18975, 18989, 18993, 18996, 19001, 19003, 19005, 19010, 19015, 19017, 19019, 19022, 19024, 19033, 19035, 19040, 19047, 19050, 19052, 19055, 19057, 19077, 19082, 19084, 19087, 19089, 19094, 19117, 19122, 19129, 19150, 19168, 19170, 19178, 19186, 19190, 19191, 19194, 19196, 19200, 19224, 19226, 19227, 19236, 19238, 19240, 19242, 19244, 19247, 19249, 19254, 19262, 19265, 19267, 19268, 19270, 19272, 19276, 19277, 19279, 19280, 19287, 19290, 19292, 19294, 19299, 19301, 19303, 19307, 19309, 19311, 19313, 19315, 19322, 19324, 19326, 19328, 19332, 19336, 19338, 19340, 19342, 19344, 19346, 19348, 19350, 19352, 19354, 19360, 19362, 19364, 19366, 19368, 19370, 19372, 19376, 19377, 19379, 19381, 19386, 19388, 19390, 19392, 19396, 19398, 19400, 19403, 19405, 19407, 19409, 19411, 19415, 19418, 19420, 19423, 19425, 19427, 19429, 19432, 19436, 19438, 19440, 19444, 19448, 19451, 19453, 19455, 19457, 19459, 19464, 19486, 19491, 19499, 19501, 19504, 19506, 19508, 19512, 19514, 19516, 19518, 19520, 19522, 19525, 19527, 19529, 19531, 19536, 19538, 19540, 19543, 19545, 19547, 19549, 19553, 19562, 19564, 19566, 19568, 19570, 19572, 19574, 19576, 19579, 19581, 19585, 19588, 19590, 19597, 19599, 19601, 19603, 19605, 19607, 19609, 19611, 19613, 19614, 19617, 19620, 19625, 19641, 19644, 19646, 19650, 19653, 19656, 19661, 19663, 19664, 19666, 19667, 19669, 19671, 19673, 19675, 19677, 19679, 19681, 19685, 19691, 19693, 19695, 19697, 19699, 19701, 19711, 19713, 19719, 19721, 19723, 19725, 19727, 19729, 19731, 19733, 19735, 19737, 19739, 19741, 19743, 19747, 19749, 19751, 19753, 19757, 19759, 19761, 19763, 19766, 19768, 19770, 19772, 19789, 19793, 19795, 19798, 19800, 19803, 19805, 19808, 19810, 19813, 19815, 19818, 19820, 19823, 19827, 19830, 19832, 19834, 19836, 19837, 19839, 19840, 19842, 19847, 19848, 19855, 19857, 19858, 19861, 19863, 19867, 19877, 19878, 19883, 19890, 19892, 19895, 19897, 19902, 19903, 19911, 19916, 19938, 19941, 19947, 19951, 19954, 19957, 19960, 19968, 19974, 19978, 19981, 19993, 19999, 20005, 20017, 20022, 20024, 20030, 20040, 20051, 20055, 20062, 20065, 20069, 20074, 20076, 20079, 20081, 20084, 20087, 20090, 20092, 20097, 20106, 20129, 20130, 20132, 20133, 20135, 20137, 20139, 20141, 20143, 20145, 20147, 20149, 20153, 20155, 20157, 20159, 20160, 20163, 20175, 20181, 20187, 20190, 20193, 20196, 20199, 20202, 20211, 20214, 20217, 20220, 20223, 20233, 20236, 20239, 20251, 20254, 20257, 20260, 20264, 20273, 20276, 20286, 20289, 20295, 20304, 20314, 20320, 20329, 20332, 20336, 20339, 20342, 20343, 20347, 20350, 20353, 20356, 20359, 20362, 20366, 20369, 20375, 20378, 20381, 20385, 20389, 20392, 20395, 20398, 20401, 20405, 20409, 20412, 20415, 20418, 20421, 20425, 20429, 20432, 20435, 20438, 20445, 20453, 20457, 20461, 20465, 20472, 20476, 20479, 20482, 20486, 20493, 20497, 20500, 20505, 20510, 20514, 20516, 20520, 20525, 20528, 20532, 20536, 20546, 20554, 20564, 20567, 20570, 20573, 20576, 20583, 20586, 20593, 20596, 20603, 20607, 20610, 20621, 20624, 20630, 20633, 20637, 20641, 20643, 20650, 20653, 20662, 20668, 20671, 20676, 20679, 20681, 20684, 20687, 20690, 20691, 20692, 20693, 20695, 20699, 20703, 20711, 20712, 20714, 20720, 20722, 20725, 20729, 20732, 20735, 20739, 20742, 20745, 20749, 20751, 20753, 20763, 20766, 20769, 20771, 20774, 20777, 20780, 20783, 20789, 20796, 20799, 20805, 20814, 20817, 20825, 20829, 20832, 20835, 20838, 20841, 20845, 20852, 20860, 20864, 20867, 20872, 20875, 20878, 20882, 20886, 20895, 20898, 20902, 20905, 20911, 20924, 20931, 20937, 20941, 20951, 20955, 20960, 20967, 20970, 20977, 20980, 20984, 20986, 20993, 21000, 21007, 21013, 21017, 21027, 21030, 21033, 21041, 21048, 21051, 21056, 21059, 21066, 21069, 21076, 21089, 21099, 21103, 21106, 21109, 21112, 21116, 21119, 21126, 21129, 21132, 21136, 21139, 21143, 21150, 21153, 21157, 21165, 21168, 21181, 21184, 21191, 21195, 21198, 21205, 21217, 21226, 21230, 21234, 21237, 21242, 21246, 21250, 21260, 21262, 21270, 21275, 21284, 21287, 21290, 21293, 21295, 21308, 21310, 21324, 21326, 21337, 21338, 21339, 21341, 21342, 21345, 21347, 21352, 21354, 21357, 21359, 21360, 21362, 21366, 21368, 21376, 21378, 21379, 21381, 21386, 21388, 21392, 21394, 21398, 21401, 21403, 21410, 21413, 21418, 21425, 21427, 21432, 21434, 21436, 21442, 21445, 21448, 21451, 21457, 21460, 21465, 21470, 21473, 21479, 21482, 21484, 21486, 21489, 21492, 21495, 21500, 21509, 21517, 21524, 21526, 21531, 21537, 21540, 21544, 21554, 21559, 21561, 21564, 21567, 21570, 21576, 21581, 21584, 21587, 21593, 21596, 21602, 21605, 21611, 21614, 21623, 21626, 21638, 21642, 21651, 21654, 21659, 21664, 21677, 21680, 21687, 21690, 21693, 21709, 21712, 21719, 21728, 21736, 21740, 21743, 21747, 21754, 21761, 21776, 21779, 21781, 21783, 21785, 21788, 21792, 21797, 21799, 21803, 21809, 21814, 21816, 21819, 21821, 21824, 21830, 21831, 21834, 21836, 21838, 21896, 21898, 21910, 21913, 21915, 21917, 21921, 21922, 21924, 21931, 21935, 21943, 21946, 21948, 21952, 21955, 21957, 21962, 21964, 21966, 21974, 21978, 21980, 21983, 21988, 21990, 21992, 21995, 21997, 22000, 22005, 22008, 22010, 22013, 22015, 22019, 22022, 22024, 22027, 22032, 22034, 22038, 22043, 22046, 22048, 22050, 22053, 22060, 22062, 22068, 22075, 22081, 22089, 22095, 22118, 22121, 22126, 22129, 22132, 22134, 22142, 22153, 22155, 22159, 22161, 22166, 22176, 22179, 22182, 22185, 22192, 22195, 22198, 22202, 22204, 22207, 22210, 22213, 22226, 22229, 22231, 22237, 22240, 22243, 22245, 22247, 22253, 22256, 22258, 22264, 22267, 22269, 22272, 22277, 22302, 22309, 22312, 22318, 22321, 22324, 22327, 22330, 22336, 22344, 22348, 22353, 22355, 22357, 22360, 22363, 22369, 22372, 22376, 22383, 22385, 22388, 22390, 22392, 22397, 22405, 22411, 22423, 22429, 22439, 22445, 22449, 22461, 22467, 22470, 22474, 22477, 22480, 22486, 22489, 22493, 22496, 22505, 22514, 22517, 22521, 22528, 22534, 22558, 22561, 22564, 22570, 22574, 22577, 22583, 22589, 22595, 22605, 22612, 22616, 22618, 22635, 22638, 22643, 22646, 22649, 22653, 22656, 22659, 22664, 22672, 22695, 22701, 22733, 22757, 22766, 22776, 22786, 22789, 22792, 22815, 22836, 22841, 22847, 22853, 22860, 22862, 22866, 22885, 22888, 22896, 22926, 22929, 22932, 22935, 22941, 22944, 22950, 22953, 22956, 22958, 22961, 22964, 22973, 22978, 22981, 22984, 22986, 22991, 23002, 23007, 23014, 23029, 23084, 23300) 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: Zara

Cast
Role: Orasmin Actor: Turbutt

Afterpiece Title: Harlequin Restor'd

Performances

Mainpiece Title: Zara

Cast
Role: Orasmin Actor: Turbutt

Afterpiece Title: Harlequin Restor'd

Performances

Mainpiece Title: Zara

Cast
Role: Orasmin Actor: Turbutt

Afterpiece Title: Harlequin Restor'd

Performances

Mainpiece Title: Zara

Cast
Role: Orasmin Actor: Turbutt

Afterpiece Title: Harlequin Restor'd

Performances

Mainpiece Title: Zara

Cast
Role: Orasmin Actor: Turbutt

Afterpiece Title: Harlequin Restor'd

Performances

Mainpiece Title: Zara

Cast
Role: Orasmin Actor: Turbutt

Afterpiece Title: Harlequin Restor'd

Performances

Mainpiece Title: Zara

Cast
Role: Orasmin Actor: Turbutt

Afterpiece Title: Harlequin Restor'd

Performances

Mainpiece Title: Zara

Cast
Role: Orasmin Actor: Turbutt

Afterpiece Title: Harlequin Restor'd

Performances

Mainpiece Title: The Old Batchelor

Afterpiece Title: Harlequin Restor'd

Performances

Mainpiece Title: The Double Dealer

Afterpiece Title: Harlequin Restor'd

Music: Select Pieces

Dance: I: Tambourine by Mlle Roland. II: Russian Sailor by Denoyer, &c

Performances

Mainpiece Title: The Miser

Cast
Role: James Actor: Turbutt

Afterpiece Title: Harlequin Restor'd

Performances

Mainpiece Title: The Twin Rivals

Cast
Role: Fairbank Actor: Turbutt

Afterpiece Title: Harlequin Restor'd

Dance: I: By Mlle Anne Roland. II: English Maggot by Villeneuve and Mrs Walter. III: Revellers by Essex, Mrs Walter, &c. IV: Russian Sailor by Denoyer, &c. V: French Peasants by Poitier, Mlle Roland, &c

Performances

Mainpiece Title: The Twin Rivals

Cast
Role: Fairbank Actor: Turbutt

Afterpiece Title: Harlequin Restor'd

Performances

Mainpiece Title: The Spanish Fryar

Afterpiece Title: Harlequin Restor'd

Dance: II: English Maggot by Villeneuve and Mrs Walter. III: Revellers by Essex, Mrs Walter, &c. IV: French Peasants by Poitier, Mlle Roland, &c

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: Harlequin Restor'd

Dance: III: Russian Sailor by Denoyer, &c. In IV: Tambourine by Mlle Roland

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Harlequin Restor'd

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Harlequin Restor'd

Music: In II: Solo on Violin by Charke

Dance: III: Le Badinage by Poitier, Mlle Roland, &c. IV: Le Ballet d'Amour (new) by Denoyer, Mlle Anne Roland, &c

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Harlequin Restor'd

Music: In II: Solo on Violin by Charke

Dance: III: Tambourine by Mlle Roland. IV: Le Ballet d'Amour by Denoyer, Mlle Anne Roland, &c

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Harlequin Restor'd

Music: In II: Solo on Violin by Charke

Dance: II: New Serious Dance by Denoyer, Mlle Anne Roland, &c. III: Revellers by Essex, Mrs Walter, &c. IV: French Peasants by Poitier, Mlle Roland, &c

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Harlequin Restor'd

Music: As17360211

Dance: II: Rover by Essex, Mrs Walter, Miss Mann, &c. III: Le Badinage de Provence by Poitier, Mlle Roland, &c

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Harlequin Restor'd

Music: As17360211

Dance: II: Rover by Essex, Mrs Walter, Miss Mann, &c. III: Russian Sailor by Denoyer, &c

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Harlequin Restor'd

Music: In II: Violin Solo by Charke

Dance: I: English Maggot by Villeneuve, Mrs Walter, &c. II: The Rover by Essex, Mrs Walter, Miss Mann, &c. III: New Serious Dance by Denoyer, Mlle Anne Roland, &c. IV: Revellers by Essex, Mrs Walter, &c

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Harlequin Restor'd

Music: As17360214

Dance: As17360214, but Revellers omitted

Performances

Mainpiece Title: Love For Love

Afterpiece Title: Harlequin Restor'd

Dance: II: English Maggot by Villeneuve and Mrs Walter. III: Rover, as17360214

Performances

Mainpiece Title: Love Makes A Man

Cast
Role: Manuel Actor: Turbutt

Afterpiece Title: Harlequin Restor'd

Dance: I: By Mlle Anne Roland. II: English Maggot by Villeneuve and Mrs Walter. III: Rover, as17360214