SELECT * FROM london_stages WHERE eventid IN (331, 332, 1988, 2118, 3112, 3772, 4195, 4608, 5176, 5305, 5407, 5632, 5853, 5950, 6992, 7177, 7356, 7544, 7759, 7901, 8038, 8230, 8767, 9550, 9624, 9651, 10267, 11402, 11485, 12191, 12194, 12511, 12915, 12957, 13064, 13206, 13439, 13522, 13623, 13794, 14146, 14239, 14274, 14289, 14537, 14555, 14558, 14561, 14612, 14651, 14787, 14861, 14878, 14934, 15051, 15057, 15091, 15166, 15745, 15769, 15770, 15787, 15836, 15883, 15973, 16131, 16159, 16547, 16581, 16644, 16647, 16678, 16844, 16859, 16877, 16972, 17003, 17023, 17481, 19565, 19701, 19836, 19857, 20114, 20121, 20132, 20144, 20148, 20185, 20221, 20231, 20255, 20333, 20340, 20399, 20472, 20473, 20550, 20937, 20955, 21260, 21326, 21366, 21370, 21382, 21390, 21405, 21506, 21534, 21551, 21573, 21635, 21771, 21805, 21870, 21889, 21966, 21997, 22056, 22089, 22179, 22233, 22245, 22277, 22293, 22325, 22354, 22369, 22467, 22525, 22534, 22616, 22672, 22777, 22907, 22910, 22988, 23044, 23046, 23258, 23274, 23320, 23374, 23397, 23453, 23459, 23462, 23526, 23544, 23554, 23611, 23654, 23673, 23748, 24009, 24113, 24330, 24485, 24644, 24704, 25409, 25582, 25692, 25837, 25894, 26113, 26147, 26176, 26187, 26277, 26374, 26398, 26470, 26472, 26473, 26475, 26476, 26479, 26482, 26485, 26488, 26491, 26494, 26497, 26500, 26505, 26512, 26518, 26558, 26606, 26619, 26623, 26630, 26655, 26805, 26846, 27016, 27063, 27246, 27252, 27257, 27262, 27267, 27273, 27281, 27286, 27572, 28131, 28172, 28259, 28261, 28264, 28266, 28272, 28276, 28284, 28298, 28303, 28343, 28354, 28381, 28419, 28510, 28534, 28545, 28609, 28677, 28708, 28940, 29037, 29072, 29178, 29421, 29493, 29554, 29758, 29946, 30106, 30147, 30157, 30841, 30844, 30846, 30848, 30850, 30853, 30855, 30857, 30859, 30863, 30866, 30868, 30871, 30873, 30875, 30877, 30879, 30881, 30883, 30885, 30887, 30889, 30892, 30989, 31368, 31380, 31437, 31488, 31498, 31529, 31698, 31857, 31935, 32231, 32356, 32471, 32707, 33593, 33798, 33855, 33976, 34175, 35473, 35499, 35523, 35545, 35547, 35552, 35560, 35562, 35568, 35570, 35575, 35579, 35582, 35585, 35592, 35619, 35621, 35682, 35693, 35749, 35763, 35810, 35870, 35910, 35929, 35935, 35945, 36123, 36136, 36141, 36143, 36145, 36185, 36523, 36529, 36558, 36564, 36634, 37041, 37067, 37781, 37789, 37833, 38175, 38210, 38323, 38378, 38450, 38597, 38599, 38614, 38679, 38710, 38720, 38746, 38778, 38794, 38796, 38878, 38891, 38938, 38988, 39021, 39200, 39206, 39217, 39220, 39226, 39231, 39235, 39243, 39251, 39263, 39281, 39304, 39307, 39316, 39408, 39409, 39411, 39448, 39460, 39465, 39507, 39542, 39777, 39861, 39902, 39949, 40032, 40058, 40106, 40198, 40324, 40353, 40355, 40372, 40413, 40443, 40569, 40593, 40596, 40600, 40602, 40604, 40606, 40608, 40611, 40619, 40660, 40663, 40665, 40667, 40669, 40672, 40674, 40677, 40679, 40681, 40683, 40686, 40688, 40691, 40693, 40711, 40714, 40717, 40719, 40721, 40723, 40726, 40729, 40732, 40734, 40741, 40743, 40746, 40755, 40767, 40770, 40775, 40781, 40816, 40845, 40859, 40873, 40876, 40886, 40889, 40904, 40910, 40938, 40941, 40943, 40953, 40958, 40962, 40965, 40967, 40970, 40972, 40973, 40978, 40980, 40983, 40989, 40992, 41005, 41045, 41130, 41137, 41155, 41213, 41227, 41271, 41278, 41281, 41373, 41420, 41458, 41556, 41573, 41690, 41851, 41853, 41856, 41858, 41861, 41863, 41866, 41868, 41870, 41872, 41875, 41877, 41880, 41882, 41885, 41887, 41890, 41893, 41896, 41898, 41901, 41903, 41906, 41909, 41912, 41914, 41916, 41918, 41921, 41923, 41926, 41929, 41931, 41934, 41936, 41939, 41941, 41980, 41984, 41987, 41994, 41998, 42001, 42003, 42040, 42058, 42066, 42071, 42081, 42134, 42142, 42157, 42243, 42244, 42245, 42246, 42247, 42249, 42250, 42253, 42255, 42256, 42258, 42259, 42260, 42261, 42262, 42263, 42264, 42265, 42266, 42267, 42268, 42270, 42271, 42272, 42302, 42306, 42308, 42312, 42318, 42324, 42326, 42330, 42334, 42338, 42344, 42347, 42349, 42353, 42354, 42357, 42358, 42362, 42366, 42371, 42373, 42378, 42380, 42388, 42396, 42416, 42430, 42436, 42462, 42526, 42563, 42573, 42598, 42693, 42725, 42884, 42914, 42920, 42992, 43015, 43025, 43030, 43078, 43194, 43236, 43257, 43264, 43406, 43408, 43410, 43411, 43413, 43416, 43417, 43418, 43426, 43460, 43462, 43473, 43509, 43553, 43618, 43627, 43695, 43820, 43835, 43897, 43909, 43916, 43946, 43953, 43980, 43984, 43999, 44016, 44027, 44029, 44049, 44097, 44103, 44110, 44133, 44315, 44402, 44417, 44454, 44493, 44591, 45537, 45547, 45659, 45661, 45663, 45665, 45667, 45671, 45918, 45991, 45993, 45997, 46001, 46002, 46005, 46006, 46007, 46011, 46014, 46018, 46019, 46024, 46027, 46040, 46041, 46051, 46057, 46084, 46171, 46188, 46191, 46197, 46237, 46271, 46273, 46284, 46292, 46299, 46311, 46323, 46336, 46357, 46361, 46369, 46373, 46383, 46389, 46393, 46397, 46401, 46403, 46431, 46506, 46524, 46543, 46552, 46564, 46580, 46585, 46590, 46607, 46612, 46614, 46622, 46634, 46637, 46639, 46657, 46667, 46676, 46688, 46695, 46697, 46708, 46716, 46718, 46721, 46723, 46725, 46728, 46732, 46734, 46861, 46891, 46893, 46897, 46907, 46981, 46991, 47003, 47021, 47033, 47081, 47183, 47235, 47249, 47253, 47289, 47306, 47309, 47312, 47315, 47320, 47410, 47454, 47478, 47489, 47589, 47738, 47798, 47879, 48002, 48023, 48139, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48168, 48170, 48172, 48174, 48178, 48180, 48182, 48219, 48327, 48339, 48370, 48394, 48571, 48620, 48628, 48654, 48659, 48665, 48677, 48685, 48697, 48704, 48714, 48734, 48744, 48769, 48774, 48858, 48860, 48984, 49016, 49028, 49030, 49045, 49053, 49058, 49060, 49217, 49231, 49267, 49281, 49493, 49517, 49553, 49565, 49568, 49573, 49583, 49585, 49604, 49609, 49614, 49625, 49630, 49637, 49644, 49650, 49655, 49657, 49662, 49664, 49667, 49772, 49788, 49828, 49833, 49855, 49865, 49932, 49973, 50210, 50394, 50468, 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, 50577, 50578, 50580, 50581, 50582, 50583, 50585, 50587, 50588, 50590, 50591, 50593, 50594, 50595, 50599, 50602, 50608, 50609, 50620, 50626, 50628, 50635, 50640, 50688, 50690, 50695, 50702, 50707, 50736, 50739, 50742, 50744, 50772, 50786, 50790, 50802, 50805, 50812, 50925, 51154, 51295, 51302, 51343, 51472, 51853, 51864, 52064, 52093, 52097, 52102, 52104, 52106, 52116, 52122, 52200, 52386, 52389, 52405, 52454, 52481, 52483, 52499) 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: Lieutenant Actor: Ray

Afterpiece Title: The King and Miller of Mansfield

Song: I: Song with French Horns-Beard; IV: War he sung was Toil and Trouble-Mrs Clive

Dance: III: New Running Footman's Dance-Phillips; V: a Hornpipe-Phillips

Performances

Mainpiece Title: Richard Iii

Cast
Role: Lieutenant Actor: Ray

Dance: The Mechels

Performances

Mainpiece Title: Richard Iii

Cast
Role: Lieutenant Actor: Ray

Song: II: Song-Beard

Music: IV: Concerto-Veracini

Dance: V: Grand Serious Ballet, as17421005

Performances

Mainpiece Title: Richard Iii

Cast
Role: Lieutenant Actor: Ray

Song: II: Beard

Music: IV: Concerto-Veracini

Dance: V: Grand Serious Ballet, as17421005

Performances

Mainpiece Title: Richard Iii

Cast
Role: Lieutenant Actor: Ray

Song: II: Song-Beard

Music: IV: Concerto-Veracini

Dance: V: Grand Serious Ballet, as17421005

Performances

Mainpiece Title: Richard Iii

Cast
Role: Lieutenant Actor: Ray

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

Performances

Mainpiece Title: Richard Iii

Cast
Role: Lieutenant Actor: Ray

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

Song: III: Song-Beard

Performances

Mainpiece Title: Richard Iii

Cast
Role: Lieutenant Actor: Ray

Song: As17421204

Music: III: Concerto-Piantanida

Performances

Mainpiece Title: Richard Iii

Cast
Role: Lieutenant Actor: Ray

Song: II: Beard; IV: Lowe

Music: Concerto on Violincello-Cervetti

Performances

Mainpiece Title: Richard Iii

Cast
Role: Lieutenant Actor: Ray

Dance: II: Grand Serious Ballet, as17421005

Song: III: Song-Lowe

Music: IV: Concerto-Piantanida

Performances

Mainpiece Title: Richard Iii

Cast
Role: Lieutenant Actor: Ray

Song: II, IV: Lowe

Music: III: Concerto on German Flute-Burk Thumoth

Performances

Mainpiece Title: Richard Iii

Cast
Role: Lieutenant Actor: Ray

Dance: II: Grand Serious Ballet, as17421005

Song: III: Song-Lowe

Music: IV: Concerto-Piantanida

Performances

Mainpiece Title: Richard Iii

Cast
Role: Lieutenant Actor: Ray

Song: As17430413

Music: III: Concerto on German Flute-Burk Thumoth

Performances

Mainpiece Title: Richard Iii

Cast
Role: Lieutenant Actor: Ray

Song: As17430413

Dance: III: La Florana, as17430408

Performances

Mainpiece Title: The Unhappy Favorite Or The Earl Of Essex

Cast
Role: Lieutenant Actor: Ray

Afterpiece Title: The School Boy

Performances

Mainpiece Title: The Unhappy Favorite

Cast
Role: Lieutenant Actor: Ray

Afterpiece Title: The Lying Valet

Song: As17431028

Dance: As17431015

Performances

Mainpiece Title: Richard Iii

Cast
Role: Lieutenant Actor: Ray.

Performances

Mainpiece Title: Richard Iii

Cast
Role: Lieutenant Actor: Ray.

Performances

Mainpiece Title: The Unhappy Favorite

Cast
Role: Lieutenant Actor: Ray

Afterpiece Title: The Amorous Goddess or Harlequin Married

Performances

Mainpiece Title: Richard Iii

Cast
Role: Lieutenant Actor: Ray.

Afterpiece Title: The Amorous Goddess

Performances

Mainpiece Title: Richard Iii

Cast
Role: Lieutenant Actor: Ray.

Afterpiece Title: The Amorous Goddess

Performances

Mainpiece Title: The Royal Heroe Or Lover Of His Country Intermixd With Several Comical And Diverting Scenes Calld the Blundering Brothers With The Merry Adventures Of Timothy Addlepot And Davy Dunce

Cast
Role: Lieutenant Actor: Symonds

Afterpiece Title: Harlequin Sclavonian orMonsieur in the Suds

Song: Blogg

Performances

Mainpiece Title: Richard Iii

Cast
Role: Lieutenant Actor: Ray.

Afterpiece Title: The Amorous Goddess

Performances

Mainpiece Title: Richard Iii

Cast
Role: Lieutenant Actor: Ray.

Afterpiece Title: The Amorous Goddess

Performances

Mainpiece Title: The Humorous Lieutenant

Cast
Role: Lieutenant Actor: Macklin.

Afterpiece Title: The Enthusiast or The Spiritual Mountebank