SELECT * FROM london_stages WHERE eventid IN (194, 197, 992, 1013, 1262, 1419, 1451, 1601, 1691, 2013, 2401, 2550, 2555, 2593, 4065, 4075, 4077, 4082, 4110, 4134, 4159, 4176, 4202, 4266, 4302, 4495, 4588, 4649, 4698, 4869, 5155, 5179, 5362, 5922, 5931, 6194, 6315, 6693, 6721, 7012, 7120, 7268, 7304, 7336, 7344, 7470, 7472, 7474, 7486, 7589, 7659, 7850, 7886, 7950, 8025, 8029, 8076, 8138, 8233, 8424, 8562, 8654, 8759, 8793, 9016, 9218, 9395, 9515, 9535, 9558, 9560, 9563, 9571, 9587, 9589, 9603, 9640, 9722, 9773, 9819, 9928, 9931, 9942, 10057, 10065, 10171, 10329, 10344, 10385, 10438, 10469, 10615, 10661, 10763, 10906, 10939, 10976, 10984, 11116, 11275, 11279, 11319, 11338, 11339, 11398, 11576, 11763, 11846, 11984, 12000, 12404, 12407, 12410, 12415, 12443, 12474, 12479, 12578, 12858, 12879, 13041, 13346, 13396, 13407, 13442, 13600, 13700, 13703, 13707, 13711, 13768, 14069, 14388, 14488, 14692, 14698, 14718, 14726, 14765, 14781, 14841, 14865, 15050, 15561, 15565, 15651, 15659, 15724, 15730, 15926, 16089, 16092, 16476, 16486, 16568, 16570, 16576, 16612, 16739, 16744, 16747, 16752, 16753, 16756, 16757, 16761, 16765, 16769, 16836, 16974, 17033, 17050, 17275, 17293, 17347, 17423, 17610, 17620, 17850, 18020, 18035, 18058, 18073, 18234, 18237, 18242, 18246, 18254, 18319, 18533, 18560, 18831, 18863, 18882, 18954, 19226, 19306, 19308, 19324, 19349, 19355, 19393, 19423, 19425, 19527, 19588, 19589, 19600, 19650, 19693, 19751, 19798, 19834, 19848, 19911, 19947, 20024, 20097, 20121, 20138, 20146, 20163, 20185, 20209, 20233, 20255, 20643, 20775, 20832, 20835, 20838, 20841, 20905, 20911, 21107, 21143, 21270, 21311, 21332, 21375, 21427, 21432, 21433, 21436, 21442, 21448, 21457, 21465, 21484, 21526, 21540, 21559, 21581, 21611, 21614, 21633, 21677, 21784, 21809, 21854, 21859, 21878, 21888, 21899, 21938, 21961, 22060, 22087, 22109, 22130, 22164, 22169, 22233, 22238, 22324, 22332, 22342, 22517, 22577, 22584, 22734, 22790, 22842, 22860, 22905, 22949, 22953, 22977, 23016, 23292, 23318, 23350, 23379, 23381, 23423, 23534, 23543, 23615, 23740, 23804, 23836, 23896, 23915, 23962, 23984, 24049, 24104, 24118, 24191, 24194, 24325, 24349, 24364, 24396, 24471, 24481, 24496, 24517, 24525, 24567, 24587, 24685, 24705, 24881, 24923, 24951, 24968, 25029, 25057, 25105, 25197, 25214, 25259, 25335, 25447, 25452, 25497, 25575, 25667, 25710, 25734, 25780, 26085, 26217, 26263, 26335, 26589, 26661, 26666, 26674, 27282, 27302, 27370, 27375, 27377, 27387, 27389, 27401, 27405, 27409, 27437, 27483, 27509, 27542, 27582, 27602, 27613, 27615, 27622, 27683, 27717, 27723, 27736, 27749, 27780, 27785, 27811, 27888, 27935, 27966, 28025, 28046, 28163, 28220, 28286, 28390, 28399, 28423, 28450, 28525, 28622, 28645, 28680, 28840, 28911, 29015, 29033, 29063, 29206, 29328, 29422, 29528, 30034, 30319, 30323, 31240, 31743, 31772, 31842, 31914, 31918, 31924, 31931, 31938, 31961, 31975, 32122, 32165, 32316, 32318, 32391, 32440, 32496, 32640, 32672, 32824, 32936, 33089, 33135, 33303, 33407, 33452, 33577, 33605, 33732, 33745, 33794, 33882, 34008, 34100, 34158, 34203, 34261, 34336, 34387, 34537, 34600, 34628, 34651, 34708, 34751, 34860, 34876, 34889, 34947, 35290, 35303, 35306, 35308, 35355, 35359, 35508, 35994, 36176, 36260, 36287, 36341, 36512, 36544, 37462, 37635, 37793, 37895, 37914, 38348, 38349, 38400, 38425, 38443, 38515, 38597, 38716, 38785, 38897, 38904, 38976, 39032, 39093, 39104, 39285, 39370, 39371, 39379, 39381, 39386, 39393, 39406, 39414, 39416, 39433, 39440, 39453, 39457, 39480, 39497, 39564, 39605, 39759, 40019, 40043, 40150, 40204, 40217, 40226, 40236, 40243, 40253, 40254, 40259, 40279, 40450, 40563, 40604, 40605, 40688, 40734, 40980, 41088, 41114, 41157, 41260, 41325, 41366, 41447, 41564, 41696, 41748, 41897, 42284, 42419, 42531, 42622, 42867, 42869, 42872, 42873, 42883, 42905, 42935, 42951, 43011, 43030, 43056, 43154, 43252, 43440, 43487, 43511, 43614, 43936, 43963, 44031, 44102, 44171, 44176, 44198, 44221, 44279, 44426, 44447, 44590, 44641, 44647, 44672, 44684, 44698, 44747, 45035, 45136, 45181, 45241, 45290, 45300, 45302, 45586, 45707, 45758, 45852, 45991, 46005, 46103, 46133, 46347, 46598, 46716, 46725, 46941, 46953, 47291, 47470, 47867, 48055, 48134, 48136, 48142, 48145, 48155, 48167, 48181, 48193, 48222, 48232, 48251, 48334, 48348, 48362, 48430, 48435, 48438, 48561, 48594, 48665, 48712, 48732, 48764, 48785, 48803, 48835, 49033, 49272, 49495, 49525, 49791, 49801, 49813, 49917, 49924, 49929, 50121, 50141, 50291, 50324, 50512, 50782, 50919, 51022, 51249, 51481, 51488, 51715) 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 Comedy Of Errors

Cast
Role: Luciana Actor: Mrs Mountain

Afterpiece Title: Three Weeks after Marriage

Afterpiece Title: Comus

Dance: As17920410

Song: End II 1st piece: a new Comic Song, The Ups and Downs of Life-Munden; in 3rd piece: Give me Wine rosy Wine, Nor on beds of fading flowers-Incledon

Performances

Mainpiece Title: Hamlet

Cast
Role: Lucianus Actor: Cubitt

Afterpiece Title: Hartford Bridge

Performances

Mainpiece Title: At King's Jane Shore

Afterpiece Title: The Cheats of Scapin

Cast
Role: Lucia Actor: Miss Heard

Performances

Mainpiece Title: At King's The Pirates

Afterpiece Title: The Cheats of Scapin

Cast
Role: Lucia Actor: Miss Heard

Performances

Mainpiece Title: Hamlet

Cast
Role: Lucianus Actor: Cubitt

Afterpiece Title: Harlequin's Museum

Dance: As17921226

Performances

Mainpiece Title: At King's The Pirates

Afterpiece Title: The Cheats of Scapin

Cast
Role: Lucia Actor: Miss Heard

Performances

Mainpiece Title: At King's Douglas

Afterpiece Title: The Cheats of Scapin

Cast
Role: Lucia Actor: Miss Heard

Performances

Mainpiece Title: At King's Know Your Own Mind

Afterpiece Title: The Cheats of Scapin

Cast
Role: Lucia Actor: Miss Heard

Performances

Mainpiece Title: At King's The Pirates

Afterpiece Title: The Cheats of Scapin

Cast
Role: Lucia Actor: Miss Heard

Performances

Mainpiece Title: At Hay Jane Shore

Afterpiece Title: The Cheats of Scapin

Cast
Role: Lucia Actor: Miss Heard

Performances

Mainpiece Title: At King's The Pirates

Afterpiece Title: The Cheats of Scapin

Cast
Role: Lucia Actor: Miss Heard

Performances

Mainpiece Title: At Hay King Lear

Afterpiece Title: The Cheats of Scapin

Cast
Role: Lucia Actor: Miss Heard

Performances

Mainpiece Title: At Hay Venice Preserv'd

Afterpiece Title: The Cheats of Scapin

Cast
Role: Lucia Actor: Miss Heard

Performances

Mainpiece Title: The Comedy Of Errors

Cast
Role: Luciana Actor: Mrs Esten

Afterpiece Title: The Relief of Williamstadt

Afterpiece Title: The Lying Valet

Dance: End: The Bouquet-Byrn, Mme Rossi

Song: III: a song in character-Mrs Clendining

Performances

Mainpiece Title: At Hay The Fair Penitent

Afterpiece Title: The Cheats of Scapin

Cast
Role: Lucia Actor: Miss Heard

Performances

Mainpiece Title: At Hay The Country Girl

Afterpiece Title: The Cheats of Scapin

Cast
Role: Lucia Actor: Miss Heard

Performances

Mainpiece Title: The Comedy Of Errors

Cast
Role: Luciana Actor: Mrs Esten

Afterpiece Title: The Sailor's Festival

Afterpiece Title: Hartford Bridge

Dance: In 3rd piece: The Lucky Escape, as17921116

Song: End II: Black Eyed Susan, as17930510; III: a song in character-Miss Barnett

Performances

Mainpiece Title: The Comedy Of Errors

Cast
Role: Luciana Actor: Mrs Esten

Afterpiece Title: Tom Thumb

Dance: As17930525

Song: III: song, as17930603

Performances

Mainpiece Title: At King's The Beaux Stratagem

Afterpiece Title: The Cheats of Scapin

Cast
Role: Lucia Actor: Miss Heard

Dance: End IV: Le Pas Russe, as17930531; End: a New Comic Dance composed by D'Egville-the young D'Egvilles, Miss Phillips

Performances

Mainpiece Title: The Comedy Of Errors

Cast
Role: Luciana Actor: Mrs Esten

Afterpiece Title: The School for Arrogance

Song: In III: a song (in character)-Mrs Clendining

Entertainment: As17931004

Performances

Mainpiece Title: The Comedy Of Errors

Cast
Role: Luciana Actor: Mrs Esten

Afterpiece Title: THE WARD OF THE CASTLE

Dance: As17931022

Song: In Act III of mainpiece, as17931008; In afterpiece, as17931024

Performances

Mainpiece Title: The School For Arroganc E

Cast
Role: Luciana Actor: Mrs Esten

Afterpiece Title: MODERN ANTIQUES

Afterpiece Title: MOTHER SHIPTON TRIUMPHANT

Dance: As17931119

Song: As17931119

Performances

Mainpiece Title: Hamlet

Cast
Role: Luciana Actor: Cubitt

Afterpiece Title: Harlequin's Chaplet

Performances

Mainpiece Title: Hamlet

Cast
Role: Luciana Actor: Cubitt

Afterpiece Title: A Divertisement

Dance: As17931123

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Luciana Actor: Mrs Esten

Afterpiece Title: The Picture of Paris