SELECT * FROM london_stages WHERE eventid IN (39023, 39048, 39050, 39052, 39057, 39061, 39070, 39075, 39077, 39082, 39203, 39209, 39237, 39258, 39261, 39277, 39283, 39294, 39299, 39313, 39318, 39330, 39454, 39456, 39458, 39461, 39542, 39545, 39547, 39549, 39551, 39554, 39556, 39559, 39561, 39563, 39565, 39568, 39570, 39582, 39601, 39604, 39606, 39608, 39610, 39612, 39614, 39616, 39619, 39622, 39624, 39626, 39628, 39630, 39633, 39635, 39638, 39644, 39649, 39661, 39664, 39671, 39674, 39676, 39688, 39700, 39758, 39765, 39813, 39829, 39844, 39853, 39874, 39899, 40040, 40042, 40044, 40046, 40048, 40053, 40059, 40061, 40071, 40073, 40093, 40099, 40121, 40135, 40140, 40149, 40173, 40179, 40181, 40188, 40190, 40193, 40195, 40197, 40199, 40202, 40205, 40208, 40210, 40212, 40214, 40217, 40219, 40222, 40224, 40226, 40228, 40233, 40236, 40238, 40240, 40243, 40245, 40248, 40250, 40252, 40254, 40257, 40259, 40279, 40311, 40316, 40323, 40326, 40331, 40358, 40367, 40379, 40382, 40413, 40425, 40431, 40454, 40578, 40580, 40582, 40587, 40589, 40590, 40605, 40607, 40609, 40610, 40612, 40613, 40614, 40615, 40617, 40618, 40621, 40623, 40624, 40625, 40627, 40634, 40641, 40643, 40645, 40648, 40652, 40654, 40657, 40659, 40662, 40666, 40680, 40700, 40722, 40725, 40728, 40731, 40733, 40735, 40737, 40740, 40776, 40780, 40783, 40786, 40794, 40796, 40806, 40812, 40818, 40820, 40841, 40847, 40851, 40861, 40869, 40873, 40875, 40879, 40881, 40883, 40886, 40889, 40900, 40901, 40910, 40952, 40959, 40962, 40964, 40965, 40970, 40980, 40982, 40983, 40989, 41116, 41128, 41129, 41136, 41165, 41178, 41237, 41242, 41246, 41256, 41263, 41280, 41282, 41286, 41296, 41300, 41308, 41322, 41346, 41349, 41351, 41353, 41355, 41358, 41360, 41363, 41365, 41368, 41370, 41373, 41375, 41378, 41380, 41382, 41395, 41396, 41398, 41400, 41401, 41403, 41405, 41407, 41409, 41411, 41414, 41416, 41418, 41426, 41427, 41429, 41431, 41440, 41443, 41446, 41448, 41450, 41454, 41456, 41463, 41465, 41473, 41479, 41484, 41495, 41497, 41507, 41509, 41514, 41516, 41522, 41524, 41526, 41530, 41531, 41538, 41546, 41548, 41550, 41560, 41568, 41574, 41575, 41577, 41578, 41579, 41580, 41585, 41586, 41590, 41594, 41598, 41609, 41611, 41612, 41617, 41620, 41622, 41624, 41632, 41638, 41640, 41644, 41645, 41653, 41654, 41655, 41656, 41657, 41658, 41660, 41662, 41663, 41666, 41669, 41671, 41672, 41674, 41678, 41680, 41682, 41685, 41686, 41712, 41734, 41862, 42013, 42039, 42121, 42124, 42126, 42129, 42132, 42144, 42148, 42153, 42168, 42171, 42175, 42183, 42186, 42187, 42191, 42194, 42195, 42198, 42199, 42205, 42211, 42214, 42217, 42221, 42222, 42225, 42226, 42227, 42229, 42238, 42243, 42244, 42245, 42246, 42247, 42249, 42250, 42253, 42255, 42256, 42258, 42259, 42260, 42261, 42262, 42263, 42264, 42265, 42266, 42267, 42268, 42270, 42271, 42272, 42447, 42449, 42451, 42454, 42457, 42460, 42464, 42471, 42474, 42478, 42483, 42488, 42493, 42495, 42500, 42503, 42507, 42512, 42519, 42524, 42529, 42531, 42533, 42540, 42543, 42548, 42560, 42565, 42570, 42583, 42596, 42609, 42760, 42762, 42764, 42765, 42766, 42767, 42769, 42770, 42772, 42775, 42777, 42780, 42783, 42785, 42787, 42788, 42791, 42795, 42797, 42798, 42799, 42800, 42803, 42805, 42807, 42808, 42810, 42814, 42816, 42817, 42818, 42819, 42823, 42829, 42831, 42833, 42834, 42835, 42837, 42841, 42843, 42847, 42849, 42851, 43380, 43390, 43398, 43402, 43407, 43415, 43672, 43687, 43700, 43716, 43730, 43737, 43744, 43796, 43807, 43813, 43842, 43963, 43970, 43975, 43977, 43979, 43981, 43984, 43985, 43986, 43988, 43991, 43992, 43993, 44001, 44006, 44007, 44009, 44010, 44011, 44012, 44013, 44015, 44017, 44019, 44021, 44023, 44024, 44025, 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, 45512, 45840, 45842, 45844, 45846, 45848, 45850, 45852, 45854, 45856, 45858, 45860, 45862, 45864, 45866, 45869, 45874, 45878, 45883, 45890, 45894, 45899, 45902, 45904, 45911, 45951, 45991, 45993, 45997, 46002, 46005, 46007, 46011, 46018, 46024, 46031, 46036, 46038, 46040, 46042, 46050, 46052, 46055, 46058, 46068, 46080, 46093, 46100, 46103, 46121, 46130, 46133, 46137, 46148, 46151, 46166, 46171, 46174, 46178, 46266, 46271, 46273, 46284, 46292, 46299, 46311, 46321, 46323, 46336, 46343, 46353, 46357, 46361, 46363, 46365, 46369, 46373, 46383, 46387, 46389, 46393, 46397, 46399, 46401, 46403, 46407, 46409, 46411, 46413, 46415, 46417, 46419, 46421, 46423, 46425, 46427, 46429, 46431, 46433, 46436, 46438, 46441, 46443, 46446, 46448, 46452, 46455, 46464, 46466, 46469, 46471, 46474, 46476, 46478, 46481, 46483, 46486, 46488, 46490, 46492, 46495, 46500, 46506, 46509, 46511, 46515, 46519, 46522, 46524, 46529, 46533, 46536, 46543, 46552, 46564, 46566, 46571, 46580, 46585, 46590, 46593, 46607, 46612, 46614, 46622, 46632, 46634, 46637, 46639, 46642, 46657, 46676, 46688, 46695, 46697, 46700, 46708, 46711, 46716, 46718, 46729, 46732, 46737, 46743, 46746, 46751, 46758, 48566, 48568, 48570, 48574, 48786, 48788, 48790, 48792, 48797, 48804, 48808, 48813, 48816, 48818, 48827, 48831, 48845, 48850, 48852, 48859, 48864, 48866, 48880, 48883, 48891, 48903, 48919, 48928, 48939, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50079, 50082, 50087, 50089, 50097, 50111, 50141, 50143, 50151, 50153, 50156, 50161, 50170, 50177, 50184, 50186, 50189, 50203, 50215, 50394, 50396, 50398, 50400, 50402, 50404, 50408, 50410, 50414, 50416, 50430, 50442, 50449, 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, 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, 50644, 50647, 50650, 50652, 50656, 50659, 50662, 50664, 50668, 50671, 50674, 50676, 50680, 50688, 50690, 50695, 50697, 50699, 50702, 50707, 50709, 50712, 50714, 50717, 50722, 50724, 50726, 50736, 50742, 50744, 50747, 50764, 50772, 50784, 50790, 50800, 50802, 50805, 50812, 52093, 52097, 52102, 52104, 52106, 52116, 52122, 52200, 52202, 52204, 52206, 52208, 52210, 52212, 52214, 52216, 52218, 52221, 52223, 52225, 52227, 52229, 52231, 52234, 52236, 52239, 52248, 52250, 52253, 52255, 52257, 52259, 52262, 52264, 52269, 52271, 52289, 52294, 52296, 52303, 52317, 52329, 52353, 52359, 52365, 52418, 52420, 52423, 52425, 52429, 52432, 52439, 52442, 52447, 52452, 52456, 52461, 52466, 52468, 52476, 52478, 52490, 52499, 52504, 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: The Conscious Lovers

Afterpiece Title: The Royal Chace

Cast
Role: Pierrot Actor: Delpini

Dance: End III: The Humours of Leixlip-Aldridge, Master Jackson, Miss Besford

Song: II: song [I have lost my Anna]-Leoni

Performances

Mainpiece Title: Sir Thomas Overbury

Afterpiece Title: The Norwood Gypsies

Dance: Afterpiece: Dancing-Aldridge, Dagueville, Miss Besford, Miss Valois

Performances

Mainpiece Title: Love Finds The Way

Afterpiece Title: The Norwood Gypsies

Dance: As17771125

Performances

Mainpiece Title: Douglas

Afterpiece Title: The Norwood Gypsies

Dance: As17771125

Performances

Mainpiece Title: Love Finds The Way

Afterpiece Title: The Norwood Gypsies

Dance: As17771125

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Norwood Gypsies

Dance: In: Hornpipe, as17771017; In afterpiece: Dancing, as17771125

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: The Norwood Gypsies

Dance: As17771125

Performances

Mainpiece Title: Love Finds The Way

Afterpiece Title: The Norwood Gypsies

Dance: As17771125

Performances

Mainpiece Title: Caractacus

Afterpiece Title: The Norwood Gypsies

Cast
Role: Clown Actor: Delpini

Dance: As17771125

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Norwood Gypsies

Cast
Role: Clown Actor: Delpini

Dance: In: Hornpipe, as17771017; Afterpiece: Dancing, as17771125

Performances

Mainpiece Title: She Stoops To Conquer

Afterpiece Title: The Norwood Gypsies

Cast
Role: Clown Actor: Delpini

Dance: As17771125

Performances

Mainpiece Title: Love Finds The Way

Afterpiece Title: The Norwood Gypsies

Cast
Role: Clown Actor: Delpini

Dance: As17771125

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Norwood Gypsies

Cast
Role: Clown Actor: Delpini

Dance: As17771125

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: The Norwood Gypsies

Cast
Role: Clown Actor: Delpini

Dance: As17771125

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Norwood Gypsies

Cast
Role: Clown Actor: Delpini

Dance: As17771125

Performances

Mainpiece Title: George Barnwell

Afterpiece Title: The Norwood Gypsies

Cast
Role: Clown Actor: Delpini

Dance: As17771125

Song: In I: a song-Leoni

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Norwood Gypsies

Cast
Role: Clown Actor: Delpini

Dance: In: Hornpipe, as17771017; Afterpiece: Dancing, as17771125

Performances

Mainpiece Title: King Lear

Afterpiece Title: The Norwood Gypsies

Cast
Role: Clown Actor: Delpini

Dance: Afterpiece: Dancing, as17771125, but _Aldridge, Langrish

Performances

Mainpiece Title: Percy

Afterpiece Title: The Norwood Gypsies

Cast
Role: Clown Actor: Delpini

Dance: As17771229

Performances

Mainpiece Title: The Duenna

Afterpiece Title: The Norwood Gypsies

Cast
Role: Clown Actor: Delpini

Dance: As17771229

Performances

Mainpiece Title: Percy

Afterpiece Title: The Norwood Gypsies

Cast
Role: Clown Actor: Delpini

Dance: As17771229

Performances

Mainpiece Title: Know Your Own Mind

Afterpiece Title: The Norwood Gypsies

Cast
Role: Clown Actor: Delpini

Dance: As17771229

Performances

Mainpiece Title: The Revenge

Afterpiece Title: The Norwood Gypsies

Cast
Role: Clown Actor: Delpini

Dance: As17771229

Performances

Mainpiece Title: George Barnwell

Afterpiece Title: The Norwood Gypsies

Cast
Role: Clown Actor: Delpini

Dance: As17771229

Song: As17771226

Performances

Mainpiece Title: The Duenna

Afterpiece Title: The Norwood Gypsies

Cast
Role: Clown Actor: Delpini

Dance: As17771229