SELECT * FROM london_stages WHERE eventid IN (34801, 38223, 38229, 38235, 38250, 38253, 38254, 38260, 38261, 38267, 38270, 38276, 38278, 38284, 38292, 38293, 38301, 38304, 38819, 38820, 38822, 38824, 38826, 38827, 38832, 38840, 39310, 39334, 39338, 39342, 39348, 39353, 39354, 39357, 39359, 39361, 39362, 39365, 39368, 39370, 39371, 39374, 39377, 39379, 39381, 39383, 39384, 39385, 39386, 39387, 39388, 39389, 39390, 39392, 39393, 39395, 39396, 39398, 39399, 39400, 39403, 39404, 39405, 39406, 39407, 39408, 39409, 39410, 39411, 39412, 39413, 39414, 39415, 39416, 39419, 39420, 39422, 39424, 39426, 39427, 39428, 39429, 39431, 39432, 39433, 39434, 39435, 39436, 39437, 39438, 39439, 39912, 39917, 39927, 39928, 39932, 39934, 39935, 39937, 39943, 39945, 39947, 39950, 39951, 39953, 39954, 39955, 39957, 39960, 39961, 39962, 39963, 39964, 39965, 39966, 39967, 39968, 39969, 39970, 39971, 39972, 39973, 39975, 39976, 39977, 39978, 39979, 39981, 39982, 39983, 39984, 39985, 39986, 39987, 39988, 39989, 39990, 39994, 39995, 39997, 39998, 40000, 40001, 40002, 40003, 40004, 40005, 40006, 40007, 40008, 40009, 40010, 40011, 40012, 40013, 40014, 40051, 40075, 40077, 40079, 40081, 40083, 40085, 40087, 40095, 40097, 40101, 40103, 40105, 40109, 40112, 40114, 40116, 40118, 40130, 40132, 40154, 40158, 40160, 40165, 40170, 40183, 40202, 40217, 40226, 40236, 40243, 40254, 40259, 40263, 40279, 40391, 40393, 40396, 40406, 40408, 40413, 40446, 40450, 40462, 40465, 40467, 40472, 40473, 40474, 40476, 40478, 40479, 40480, 40481, 40483, 40486, 40487, 40488, 40489, 40492, 40494, 40499, 40500, 40502, 40504, 40506, 40507, 40508, 40509, 40510, 40512, 40513, 40516, 40517, 40518, 40519, 40520, 40521, 40522, 40523, 40524, 40525, 40526, 40527, 40528, 40529, 40531, 40532, 40533, 40534, 40535, 40536, 40537, 40538, 40541, 40543, 40545, 40547, 40551, 40553, 40554, 40557, 40558, 40561, 40564, 40580, 40615, 40634, 40646, 40658, 40703, 40755, 40770, 40931, 40938, 40941, 40943, 40951, 40953, 40956, 40958, 40960, 40967, 40970, 40972, 40974, 40978, 40992, 40997, 41005, 41006, 41011, 41012, 41014, 41015, 41017, 41019, 41020, 41022, 41025, 41026, 41028, 41030, 41031, 41034, 41035, 41036, 41039, 41041, 41045, 41050, 41054, 41055, 41056, 41059, 41060, 41061, 41063, 41065, 41066, 41067, 41068, 41070, 41071, 41073, 41074, 41075, 41077, 41080, 41081, 41083, 41085, 41087, 41088, 41092, 41094, 41096, 41099, 41102, 41103, 41105, 41106, 41107, 41108, 41109, 41110, 41111, 41112, 41113, 41115, 41130, 41150, 41152, 41154, 41156, 41158, 41160, 41162, 41166, 41169, 41176, 41184, 41187, 41201, 41213, 41227, 41241, 41271, 41273, 41278, 41281, 41399, 41421, 41425, 41458, 41474, 41503, 41518, 41529, 41552, 41564, 41569, 41573, 41579, 41580, 41585, 41586, 41590, 41594, 41598, 41601, 41603, 41607, 41609, 41612, 41617, 41620, 41621, 41624, 41627, 41632, 41635, 41637, 41638, 41639, 41640, 41641, 41642, 41643, 41644, 41645, 41646, 41647, 41649, 41652, 41661, 41665, 41667, 41671, 41673, 41675, 41676, 41683, 41759, 41772, 41790, 41793, 41795, 41800, 41802, 41804, 41809, 41812, 41814, 41818, 41823, 41826, 41831, 41838, 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, 42011, 42021, 42026, 42040, 42045, 42047, 42050, 42058, 42063, 42066, 42073, 42081, 42101, 42106, 42134, 42142, 42157, 42163, 42170, 42173, 42176, 42178, 42179, 42181, 42182, 42184, 42187, 42190, 42191, 42192, 42198, 42199, 42200, 42205, 42207, 42208, 42210, 42212, 42215, 42216, 42218, 42220, 42221, 42223, 42224, 42226, 42228, 42229, 42231, 42232, 42234, 42237, 42243, 42244, 42245, 42246, 42247, 42249, 42250, 42251, 42252, 42253, 42255, 42256, 42257, 42258, 42259, 42260, 42261, 42262, 42263, 42264, 42265, 42266, 42267, 42268, 42270, 42271, 42272, 42302, 42306, 42310, 42312, 42318, 42324, 42328, 42330, 42338, 42354, 42357, 42372, 42415, 42420, 42458, 42461, 42467, 42470, 42477, 42486, 42489, 42491, 42494, 42496, 42549, 42561, 42566, 42633, 42678, 42728, 42731, 42750, 42753, 42754, 42755, 42760, 42762, 42764, 42765, 42766, 42767, 42768, 42769, 42770, 42772, 42773, 42774, 42775, 42777, 42778, 42780, 42782, 42783, 42785, 42787, 42788, 42789, 42790, 42791, 42795, 42797, 42798, 42799, 42800, 42801, 42802, 42803, 42804, 42805, 42806, 42807, 42808, 42810, 42814, 42815, 42816, 42817, 42818, 42819, 42822, 42823, 42825, 42827, 42829, 42830, 42831, 42833, 42834, 42835, 42836, 42837, 42838, 42839, 42840, 42841, 42842, 42843, 42844, 42845, 42846, 42847, 42848, 42849, 42850, 42851, 42852, 42853, 43317, 43319, 43322, 43323, 43326, 43327, 43330, 43333, 43335, 43337, 43339, 43343, 43344, 43347, 43350, 43352, 43355, 43356, 43364, 43366, 43368, 43372, 43374, 43375, 43376, 43377, 43379, 43380, 43383, 43388, 43389, 43390, 43391, 43395, 43396, 43398, 43400, 43402, 43403, 43405, 43406, 43407, 43412, 43415, 43417, 43419, 43420, 43422, 43423, 43425, 43428, 43432, 43433, 43441, 43442, 43460, 43462, 43463, 43472, 43473, 43482, 43494, 43506, 43512, 43514, 43517, 43519, 43523, 43525, 43527, 43531, 43533, 43535, 43539, 43541, 43543, 43547, 43549, 43551, 43553, 43555, 43568, 43577, 43590, 43606, 43618, 43627, 43636, 43641, 43647, 43649, 43651, 43659, 43696, 43836, 43896, 46275, 46277, 46284, 46292, 46301, 46307, 46321, 46329, 46336, 46343, 46347, 46385, 46395, 46417, 46419, 46421, 46423, 46425, 46427, 46429, 46431, 46433, 46436, 46438, 46441, 46443, 46446, 46448, 46452, 46455, 46457, 46460, 46462, 46464, 46478, 46492, 46495, 46511, 46522, 46536, 46550, 46557, 46561, 46566, 46578, 46593, 46595, 46602, 46612, 46634, 46644, 46647, 46649, 46652, 46673, 46688, 46700, 46708, 46711, 46716, 46725, 46729, 46732, 46738, 46751, 46758, 46774) 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 Young Quaker

Afterpiece Title: The Critic; or, A Tragedy Rehears'd

Cast
Role: Beef Actor: Eater-Egan
Role: Eater Actor: Egan

Dance: As17830603

Song: End of afterpiece Stand to your Guns, as17830801

Performances

Mainpiece Title: The Good-natured Man

Cast
Role: Butler Actor: Egan

Afterpiece Title: Gretna Green

Cast
Role: Captain Tipperary Actor: Egan

Performances

Mainpiece Title: Seeing Is Believing

Cast
Role: Irishman in the Pit Actor: Egan

Afterpiece Title: THE AGREEABLE SURPRISE

Cast
Role: John Actor: Egan

Afterpiece Title: Harlequin Teague

Cast
Role: Harlequin Teague Actor: Egan

Performances

Mainpiece Title: The Young Quaker

Afterpiece Title: Gretna Green

Cast
Role: Captain Tipperary Actor: Egan

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: Harlequin Teague

Cast
Role: Harlequin Teague Actor: Egan

Dance: As17830703

Performances

Mainpiece Title: The Young Quaker

Afterpiece Title: Gretna Green

Cast
Role: Captain Tipperary Actor: Egan

Performances

Mainpiece Title: Seeing Is Believing

Cast
Role: Irishman in the Pit Actor: Egan

Afterpiece Title: The Suicide

Cast
Role: John Actor: Egan

Afterpiece Title: The Agreeable Surprise

Cast
Role: John Actor: Egan

Performances

Mainpiece Title: The Young Quaker

Afterpiece Title: Gretna Green

Cast
Role: Captain Tipperary Actor: Egan

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Alguazile Actor: Egan

Afterpiece Title: Seeing is Believing

Afterpiece Title: Gretna Green

Cast
Role: Captain Tipperary Actor: Egan

Performances

Mainpiece Title: The Young Quaker

Afterpiece Title: Gretna Green

Cast
Role: Captain Tipperary Actor: Egan

Song: End of Act III of mainpiece Water parted from the Sea by Sga Sestini; End of Act I of afterpiece Edwin's favourite song in The Castle of Andalusia, A Master I have and I am his Man, by Master Sestini

Performances

Mainpiece Title: The Separate Maintenance

Afterpiece Title: Seeing is Believing

Afterpiece Title: The Agreeable Surprise

Cast
Role: John Actor: Egan

Song: In Act I of mainpiece song by Miss Morris

Performances

Mainpiece Title: The Young Quaker

Afterpiece Title: Gretna Green

Cast
Role: Captain Tipperary Actor: Egan

Performances

Mainpiece Title: The Fox

Afterpiece Title: The Son-in-Law

Cast
Role: John Actor: Egan

Dance: As17830702

Performances

Mainpiece Title: The Fox

Afterpiece Title: Gretna Green

Cast
Role: Captain Tipperary Actor: Egan

Dance: As17830702

Performances

Mainpiece Title: The Young Quaker

Afterpiece Title: Gretna Green

Cast
Role: Captain Tipperary Actor: Egan

Performances

Mainpiece Title: The Spanish Barber; Or, The Fruitless Precaution

Cast
Role: Alguazile Actor: Egan

Afterpiece Title: The Agreeable Surprise

Cast
Role: John Actor: Egan

Dance: End of mainpicce a new dance, The Medley, by Master Giorgi, Miss Byrne and others (their 1st appearance)

Performances

Mainpiece Title: The Separate Maintenance

Afterpiece Title: The Son-in-Law

Cast
Role: Idle Actor: Egan

Dance: As17840528

Song: In Act I of mainpiece song by Miss Hooke

Performances

Mainpiece Title: The Fox

Afterpiece Title: Gretna Green

Cast
Role: Tipperary Actor: Egan

Music: [Prologue by George Colman, the elder.]

Dance: End of Act III of mainpiece, as17840528

Performances

Mainpiece Title: The Suicide

Cast
Role: Waiters Actor: Egan, Stevens, Barrett

Afterpiece Title: The Agreeable Surprise

Cast
Role: John Actor: Egan

Dance: End of Act I of mainpiece, as17840528

Performances

Mainpiece Title: The Election Of The Managers

Cast
Role: Irishman Actor: Egan

Afterpiece Title: The English Merchant

Performances

Mainpiece Title: The Election Of The Managers

Cast
Role: Irishman Actor: Egan

Afterpiece Title: The Spanish Barber

Cast
Role: John Actor: Egan

Performances

Mainpiece Title: The Tobacconist

Afterpiece Title: The Election of the Managers

Afterpiece Title: Gretna Green

Cast
Role: Tipperary Actor: Egan

Performances

Mainpiece Title: The Agreeable Surprise

Afterpiece Title: The Tobacconist

Cast
Role: Tipperary Actor: Egan

Afterpiece Title: The Election of the Managers

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Alguazile Actor: Egan

Afterpiece Title: The Agreeable Surprise

Dance: As17840528

Performances

Mainpiece Title: Seeing Is Believing: A Dramatic Proverb

Afterpiece Title: Gretna Green

Cast
Role: Tipperary Actor: Egan

Afterpiece Title: The Election of the Managers