SELECT * FROM london_stages WHERE eventid IN (20121, 20266, 20269, 20278, 20281, 20285, 20303, 20306, 20313, 20316, 20322, 20325, 20328, 20331, 20334, 20338, 20341, 20345, 20349, 20352, 20355, 20358, 20361, 20364, 20368, 20371, 20374, 20377, 20380, 20383, 20387, 20391, 20394, 20397, 20400, 20403, 20407, 20411, 20414, 20417, 20423, 20427, 20431, 20434, 20440, 20443, 20447, 20450, 20459, 20470, 20481, 20488, 20495, 20499, 20502, 20518, 20530, 20534, 20544, 20548, 20551, 20556, 20560, 20566, 20569, 20572, 20612, 20639, 20703, 20738, 20752, 20756, 20759, 20762, 20765, 20768, 20773, 20776, 20779, 20782, 20784, 20788, 20791, 20794, 20801, 20804, 20807, 20811, 20819, 20866, 20874, 20916, 20926, 20930, 20933, 20943, 20950, 20953, 20962, 20966, 20972, 20979, 21035, 21039, 21043, 21058, 21101, 21128, 21189, 21193, 21200, 21207, 21211, 21214, 21219, 21222, 21236, 21244, 21256, 21264, 21268, 21274, 21277, 21280, 21292, 21297, 21306, 21309, 21313, 21366, 21370, 21382, 21390, 21405, 21445, 21489, 21492, 21506, 21534, 21551, 21564, 21573, 21593, 21602, 21605, 21626, 21635, 21690, 21728, 21771, 21795, 21801, 21803, 21805, 21807, 21819, 21823, 21825, 21827, 21830, 21831, 21832, 21834, 21836, 22290, 22291, 22292, 22733, 22856, 22862, 22923, 22929, 22935, 23007, 23026, 23029, 23032, 23035, 23037, 23040, 23044, 23046, 23052, 23067, 23097, 23113, 23118, 23156, 23235, 23242, 23247, 23258, 23261, 23268, 23274, 23277, 23283, 23295, 23300, 23302, 23315, 23317, 23322, 23326, 23383, 23393, 23396, 23409, 23428, 23460, 23480, 23590, 23624, 23647, 23655, 23724, 23727, 23743, 23771, 23783, 23839, 23865, 23896, 23915, 23920, 23922, 23945, 23962, 23993, 23994, 23996, 24003, 24014, 24049, 24115, 24118, 24150, 24161, 24165, 24177, 24194, 24204, 24207, 24210, 24340, 24351, 24365, 24370, 24398, 24400, 24403, 24406, 24407, 24409, 24411, 24414, 24427, 24430, 24433, 24436, 24438, 24441, 24444, 24447, 24448, 24451, 24454, 24457, 24460, 24463, 24466, 24468, 24477, 24503, 24505, 24524, 24528, 24536, 24542, 24552, 24564, 24566, 24570, 24580, 24584, 24621, 24625, 24635, 24641, 24688, 24692, 24712, 24761, 24787, 24790, 24797, 24802, 24805, 24824, 24827, 24828, 24829, 24830, 24831, 24832, 24833, 24834, 24835, 24836, 24837, 24838, 24839, 24840, 24841, 24842, 24843, 24844, 24845, 24846, 24847, 24848, 24849, 24881, 24888, 24898, 24920, 24923, 24944, 24966, 24968, 25033, 25035, 25038, 25057, 25059, 25063, 25092, 25098, 25128, 25197, 25213, 25259, 25288, 25305, 25330, 25333, 25335, 25338, 25340, 25342, 25344, 25346, 25348, 25350, 25352, 25354, 25356, 25358, 25360, 25362, 25368, 25379, 25393, 25395, 25397, 25409, 25411, 25413, 25418, 25422, 25431, 25433, 25439, 25441, 25447, 25449, 25457, 25461, 25469, 25479, 25481, 25500, 25520, 25541, 25552, 25576, 25582, 25625, 25647, 25650, 25665, 25667, 25673, 25678, 25682, 25690, 25692, 25694, 25698, 25700, 25710, 25728, 25734, 25741, 25743, 25744, 25749, 25750, 25755, 25757, 25761, 25770, 25780, 25802, 25812, 25822, 25842, 25896, 25935, 25939, 25952, 25969, 25984, 26024, 26049, 26067, 26072, 26083, 26085, 26104, 26158, 26187, 26189, 26193, 26205, 26209, 26217, 26227, 26229, 26237, 26239, 26263, 26265, 26267, 26272, 26277, 26296, 26298, 26305, 26308, 26314, 26332, 26335, 26398, 26401, 26475, 26521, 26537, 26558, 26561, 26580, 26589, 26601, 26606, 26610, 26620, 26641, 26661, 26683, 26699, 26705, 26719, 26735, 26744, 26758, 26766, 26805, 26831, 26846, 26919, 26931, 26937, 26978, 26988, 27008, 27015, 27032, 27045, 27063, 27071, 27081, 27095, 27108, 27111, 27144, 27181, 27191, 27228, 27436, 27523, 27567, 27625, 27674, 27690, 27692, 27722, 27728, 27737, 27763, 27772, 27870, 27874, 27876, 27879, 27882, 27884, 27887, 27889, 27896, 27899, 27920, 27938, 27975, 28006, 28027, 28041, 28045, 28057, 28062, 28096, 28102, 28111, 28138, 28142, 28193, 28195, 28203, 28219, 28263, 28391, 28521, 28536, 28567, 28628, 28633, 28667, 28691, 28694, 28742, 28962, 29061, 29070, 29163, 29237, 29499, 29587, 29593, 29729, 29776, 29828, 30084, 30098, 30125, 30297, 30353, 30379, 30383, 30413, 30549, 30599, 30684, 30701, 30706, 30707, 30709, 30710, 30714, 30716, 30718, 30720, 30723, 30726, 30729, 30733, 30741, 30745, 30746, 30748, 30752, 30755, 30757, 30761, 30791, 30793, 30840, 30922, 31028, 31231, 31259, 31333, 31352, 31401, 31405, 31407, 31413, 31415, 31422, 31437, 31439, 31441, 31443, 31445, 31448, 31451, 31453, 31455, 31457, 31459, 31462, 31465, 31467, 31470, 31472, 31474, 31477, 31480, 31484, 31491, 31494, 31496, 31500, 31502, 31504, 31506, 31510, 31515, 31519, 31523, 31526, 31535, 31556, 31569, 31605, 31617, 31626, 31642, 31657, 31667, 31673, 31684, 31689, 31700, 31718, 31731, 31740, 31771, 31777, 31827, 31833, 31843, 31845, 31851, 31855, 31859, 31861, 31863, 31867, 31871, 31873, 31875, 31877, 31879, 31881, 31883, 31915, 31917, 31925, 31935, 31937, 31939, 31941, 31944, 31949, 31951, 31953, 31977, 31991, 31993, 32003, 32007, 32057, 32078, 32081, 32143, 32215, 32252, 32323, 32341, 32342, 32362, 32407, 32447, 32575, 32666, 32713, 32834, 32886, 32888, 32890, 32894, 32898, 32903, 32906, 32908, 32910, 32913, 32915, 32917, 32920, 32922, 32924, 32930, 32981, 33003, 33131, 33161, 33174, 33260, 33334, 33383, 33388, 33657, 33715, 33794, 33835, 33839, 33882, 34008, 34100, 34158, 34170, 34261, 34336, 34387, 34600, 34751, 34889, 34947, 34951, 35308, 35508, 39032, 39034, 39036, 39038, 39041, 39043, 39047, 39049, 39051, 39054, 39056, 39058, 39060, 39065, 39067, 39072, 39074, 39076, 39086, 39098, 39114, 39137, 39163, 39199, 39242, 39262, 39270) 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: Love Makes A Man

Cast
Role: Don Manuel Actor: Marr
Role: Sancho Actor: Marr

Afterpiece Title: The Lying Valet

Cast
Role: Beau Trippet Actor: Marr.

Song: II: Beard; III: Lowe

Music: IV: Concerto-Burk Thumoth

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: The Lying Valet

Cast
Role: Beau Trippet Actor: Marr.

Dance: I: La Florana, as17430408 III: Sicilian Peasants, as17430310

Performances

Mainpiece Title: Oroonoko

Cast
Role: Hotman Actor: Marr

Afterpiece Title: The Lying Valet

Cast
Role: Beau Trippet Actor: Marr.

Song: As17430120

Dance: II: La Florana, as17430408 New Ballet-Desse, Mrs Walter

Music: V: a Concerto-Burk Thomuth

Performances

Mainpiece Title: Richard Iii

Cast
Role: Catesby Actor: Marr

Song: As17430413

Dance: III: La Florana, as17430408

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: The Lying Valet

Cast
Role: Beau Trippet Actor: Marr.

Dance: I: A French Peasant-Froment, Mlle Gondeau; III: A New Serious Dance-Desse, Mrs Walter; V: La Florana, as17430408

Song: II: Stella and Flavia-Beard; IV: Bumper Squire Jones-Beard, Lowe

Performances

Mainpiece Title: The Beggars Opera

Afterpiece Title: The Lying Valet

Cast
Role: Beau Trippet Actor: Marr.

Dance: I: Peasant Dance, as17420921

Performances

Mainpiece Title: The Provoked Wife

Afterpiece Title: The Lying Valet

Cast
Role: Beau Trippet Actor: Marr.

Song: II: Lowe

Dance: III: Serious Ballet, as17430425 IV: La Florana, as17430408

Performances

Mainpiece Title: The Relapse

Afterpiece Title: The Lying Valet

Cast
Role: Beau Trippet Actor: Marr.

Song: II: Lowe

Dance: III: a Scotch Dance-Froment; IV: Serious Ballet, as17430425 V: Les Amants Volages-Desse, Froment, Mrs Walter

Performances

Mainpiece Title: Loves Last Shift

Afterpiece Title: The Lying Valet

Cast
Role: Beau Trippet Actor: Marr.

Song: I: a New song by Mr Boyce-Beard; III: Bumper Squire Jones-Beard, Lowe; V: A Cantata by Stanley-Lowe

Dance: II: Peasant Dance, as17420921; IV: The Hussar's Dance- , as17421211, but Checo, Chiaretta, Boromeo, Mlle Bonneval, Sga Costanza

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Lying Valet

Cast
Role: Beau Trippet Actor: Marr.

Song: III: Song-Lowe

Dance: II: Tyrolean Dance, as17421129; IV: Sicilian Peasant, as17430310

Performances

Mainpiece Title: The Beggars Opera

Afterpiece Title: The Lying Valet

Cast
Role: Beau Trippet Actor: Marr.

Dance: I: La Florana, as17430408 II: Sicilian Peasant, as17430310

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: The Lying Valet

Cast
Role: Beau Trippet Actor: Marr.

Dance: III: Serious Ballet, as17430425 IV: Tyrolean Dance, as17421129

Performances

Mainpiece Title: As You Like It

Cast
Role: Jaques Actor: Marr.

Afterpiece Title: The King and Miller of Mansfield

Dance: I: New Ballet, as17430502; IV: A New Hussar Dance, as17430425

Music: II: New Concerto on German Flute-Burk Thumoth; V: Concerto on Violin-Piantanida

Song: III: The Noontide Air-Sullivan

Performances

Mainpiece Title: The Twin Rivals

Cast
Role: Poet Actor: Marr.

Afterpiece Title: The King and Miller of Mansfield

Song: II: Lowe

Music: IV: Concerto on German Flute-Burk Thumoth

Performances

Mainpiece Title: Hamlet Prince Of Denmark

Cast
Role: Laertes Actor: Marr

Performances

Mainpiece Title: Hamlet

Cast
Role: Laertes Actor: Marr

Performances

Mainpiece Title: Hamlet

Cast
Role: Laertes Actor: Marr

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: The Quacks or Loves the Physician

Cast
Role: Novice Actor: Marr

Dance: IV: Dance-Muilment

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: Tragedy of Tragedies or The Life and Death of Tom Thumb the Great

Cast
Role: Noodle Actor: Marr

Dance: III: Grand Dance-Muilment

Performances

Mainpiece Title: The Double Gallant Or The Sick Ladys Cure

Afterpiece Title: The Tragedy of Tragedies

Cast
Role: Noodle Actor: Marr

Dance: V: as17451012

Performances

Mainpiece Title: The Inconstant Or The Way To Win Him

Afterpiece Title: The Lying Valet

Cast
Role: Beau Trippit Actor: Marr

Song: II: Lowe; IV: Stand by my brave boys-Lowe

Dance: III: Mlle Mechel

Performances

Mainpiece Title: The Spanish Fryar Or The Double Discovery

Afterpiece Title: The Lying Valet

Cast
Role: Beau Trippit Actor: Marr

Song: II: Lowe; V: Chorus Song, as17451114, but Lowe

Dance: III: Mechel

Performances

Mainpiece Title: Henry Viii

Cast
Role: Guildford Actor: Marr

Performances

Mainpiece Title: Henry Viii With Coronation

Cast
Role: Guildford Actor: Marr

Afterpiece Title: The Old Debauchees

Dance: V: Mechel

Performances

Mainpiece Title: Henry Viii

Cast
Role: Guildford Actor: Marr

Afterpiece Title: The Stage Coach

Dance: V: Mechel, Mlle Mechel