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 Squire Of Alsatia

Cast
Role: Lucia Actor: Miss Lindar.

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Lucia Actor: Miss Lindar.

Dance: As17230103

Performances

Mainpiece Title: Cutter Of Coleman Street

Cast
Role: Lucia Actor: Miss Purden

Afterpiece Title: The Magician

Performances

Mainpiece Title: Cato

Cast
Role: Lucia Actor: Mrs Porter.

Dance: As17221030

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Lucia Actor: Mrs Brett.

Dance: Shaw, Mrs Booth, Mrs Younger

Performances

Mainpiece Title: Cato

Cast
Role: Lucia Actor: Mrs Porter.

Performances

Mainpiece Title: Cutter Of Coleman Street

Cast
Role: Lucia Actor: Mrs Purden

Dance: As17231029

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Lucia Actor: Miss Lindar.

Dance: As17231028

Performances

Mainpiece Title: Cato

Cast
Role: Lucia Actor: Mrs Porter.

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Lucia Actor: Miss Lindar.

Dance: As17231028

Performances

Mainpiece Title: Cato

Cast
Role: Lucia Actor: Mrs Porter.

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Lucia Actor: Miss Lindar.

Afterpiece Title: Acis and Galatea

Dance: Shaw, Thurmond, Boval, Topham, Mrs Younger, Mrs Bullock, Miss Tenoe; particularly Foresters-

Song: Miss Lindar

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Lucia Actor: Mrs Rogier

Music: Three Pieces-; End I: particularly a Piece with French Horns-

Dance: End II: Louvre-Mrs Wall; III: French Peasant-Lanyon, Mrs Ogden; IV: Saraband-Glover, Mrs Wall; V: Dutch Boor-Newhouse, Mrs Ogden

Performances

Mainpiece Title: The Prodigal Son; Or, The Libertine Reclaimed; Wherein Is Represented His Vicious Life, And The Devil Appearing To Him To Go On In His Wickedness; And The Miserable State He Was Brought To Be His Extravagance, Being Reduced To That Extremity, That He Was Forced To Eat Husks With The Swine, To Satisfy His Hunger; Also An Angel Descending, Exhorting Him To Repent, And Return To His Father, Who Receives Him With Great Joy

Cast
Role: Lucia Actor: Mrs Spiller.

Afterpiece Title: The Loves of Harlequin and Colombine

Entertainment: Drunken Man-Harper

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Lucia Actor: Mrs Legar

Afterpiece Title: Amadis

Performances

Mainpiece Title: The Cheats Of Scapin

Cast
Role: Lucia Actor: Mrs Brett

Afterpiece Title: The Cobler of Preston

Dance: Dupre, Nivelon, Glover, Lally, Pelling, Mrs Legar, Mrs Wall, Mrs Ogden; Myrtillo-; Peasants-Nivelon, Mrs Legar; Passacaille-Lally, Mrs Wall

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Lucia Actor: Miss Tynte.

Song: As17241008

Dance: As17241230

Performances

Mainpiece Title: Cato

Cast
Role: Lucia Actor: Mrs Porter.

Dance: Miss Robinson, Young Rainton; particularly a new Dance, The Muzette-

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Lucia Actor: Mrs Legar

Dance: SScotch Dance-Mrs Bullock; Irish Dance-Newhouse, Mrs Ogden; Wooden Shoe Dance-Nivelon

Song: TTipling Philosophers-Leveridge

Performances

Mainpiece Title: Cato

Cast
Role: Lucia Actor: Mrs Porter.

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Lucia Actor: Miss Tynte.

Dance: Young Rainton, Miss Robinson; Drunken Peasant-Nivelon

Performances

Mainpiece Title: The Cheats Of Scapin

Cast
Role: Lucia Actor: Mrs Moffat.

Afterpiece Title: The Country House

Dance: PPolonese-Lally, Mrs Wall; Shepherd and Shepherdess-Young LeSac, Miss LaTour; Scots Dance-Mrs Bullock

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Lucia Actor: Mrs Legar.

Afterpiece Title: St

Dance: Dupre, Salle, Lally, Mrs Bullock, Mrs Wall, Mrs Anderson

Performances

Mainpiece Title: Cato

Cast
Role: Lucia Actor: Mrs Porter.

Performances

Mainpiece Title: The Old Batchelor

Cast
Role: Lucia Actor: Mrs Egleton.

Dance: TTwo Pierrots-Nivelon, Salle; French Peasant-Nivelon, Mrs Legare

Song: SSee From the Silent Groves by Dr Pepusch-Mrs Chambers; The Play of Love made and sung-Leveridge