SELECT * FROM london_stages WHERE eventid IN (1136, 1402, 2026, 2565, 3922, 4232, 4840, 5222, 5259, 5306, 5328, 5408, 8533, 10955, 10957, 10959, 11008, 11080, 11358, 11947, 12201, 12352, 12453, 12559, 12633, 12731, 13030, 13134, 13137, 13141, 13144, 13148, 13152, 13156, 13160, 13164, 13266, 13526, 13651, 13780, 13918, 14178, 14282, 15399, 15584, 15601, 15604, 16327, 16383, 16514, 16608, 16736, 16853, 16873, 16877, 16881, 16885, 16889, 16901, 16913, 16917, 16921, 16925, 16948, 16959, 16984, 17014, 17018, 17172, 17188, 17206, 17345, 17346, 17405, 17406, 17408, 17438, 17550, 17553, 17566, 17569, 17624, 17633, 17650, 17663, 17670, 17980, 18010, 18120, 18217, 18227, 18243, 18268, 18276, 18459, 18560, 18662, 18728, 18863, 18864, 18878, 18885, 18899, 18940, 19087, 19154, 19190, 19200, 19224, 19388, 19429, 19436, 19501, 19508, 19525, 19570, 19597, 19599, 19603, 19614, 19661, 19664, 19681, 19731, 19892, 19938, 19941, 19960, 19987, 19993, 20069, 20141, 20149, 20211, 20220, 20239, 20256, 20263, 20266, 20269, 20272, 20275, 20278, 20291, 20294, 20297, 20316, 20481, 20507, 20512, 20548, 20556, 20588, 20595, 20619, 20667, 20699, 20711, 20720, 20725, 20825, 20891, 20894, 20919, 20957, 20970, 21015, 21032, 21056, 21088, 21118, 21134, 21150, 21165, 21228, 21262, 21306, 21308, 21317, 21339, 21342, 21347, 21386, 21451, 21464, 21469, 21517, 21564, 21580, 21645, 21680, 21684, 21693, 21719, 21754, 21766, 21772, 21774, 21776, 21781, 21799, 21816, 21862, 21864, 21866, 21874, 21914, 21918, 21971, 22001, 22006, 22015, 22043, 22159, 22167, 22210, 22230, 22246, 22247, 22250, 22252, 22285, 22311, 22345, 22361, 22393, 22398, 22601, 22680, 22682, 22687, 22738, 22749, 22779, 22793, 22797, 22798, 22816, 22981, 22984, 22986, 23000, 23010, 23052, 23097, 23124, 23139, 23175, 23301, 23346, 23360, 23553, 23559, 23600, 23746, 23859, 23873, 24035, 24068, 24070, 24073, 24075, 24078, 24116, 24150, 24218, 24229, 24240, 24252, 24341, 24346, 24359, 24417, 24418, 24422, 24441, 24463, 24471, 24503, 24554, 24561, 24564, 24584, 24618, 24621, 24632, 24643, 24648, 24652, 24655, 24665, 24690, 24725, 24790, 24797, 24867, 24885, 24905, 24913, 24923, 24933, 24960, 24981, 25006, 25207, 25210, 25236, 25239, 25312, 25415, 25445, 25520, 25533, 25535, 25536, 25540, 25541, 25553, 25626, 25642, 25673, 25683, 25690, 25694, 25698, 25707, 25728, 25734, 25812, 25814, 25816, 25824, 25836, 25891, 25896, 26031, 26126, 26160, 26198, 26243, 26273, 26426, 26457, 26533, 26553, 26557, 26566, 26580, 26583, 26641, 26713, 26719, 26771, 26836, 27003, 27007, 27057, 27095, 27144, 27223, 27225, 27229, 27236, 27241, 27245, 27268, 27415, 27475, 27571, 27592, 27597, 27617, 27740, 27751, 27782, 27849, 27868, 27911, 27973, 28021, 28096, 28139, 28205, 28207, 28227, 28275, 28318, 28399, 28404, 28410, 28455, 28499, 28557, 28651, 28709, 28918, 28992, 29061, 29154, 29197, 29287, 29354, 29372, 29412, 29448, 29604, 29739, 29990, 30063, 30223, 30339, 30357, 30367, 30371, 30397, 30422, 30489, 30531, 30545, 30578, 30660, 31105, 31129, 31146, 31161, 31215, 31281, 31645, 31650, 31675, 31733, 31777, 31915, 31991, 32163, 32399, 32405, 32608, 32609, 32634, 32648, 32706, 32741, 32844, 32846, 32852, 32926, 32928, 32951, 33040, 33053, 33087, 33255, 33289, 33334, 33335, 33347, 33350, 33376, 33384, 33387, 33391, 33395, 33410, 33415, 33417, 33418, 33424, 33456, 33466, 33470, 33588, 33648, 33649, 33678, 33789, 33827, 33850, 33854, 33860, 33906, 33939, 34080, 34097, 34120, 34213, 34294, 34300, 34380, 34480, 34483, 34485, 34490, 34494, 34499, 34504, 34508, 34511, 34517, 34539, 34560, 34593, 34609, 34617, 34642, 34657, 34660, 34672, 34675, 34693, 34721, 34747, 34778, 34795, 34797, 34803, 34813, 34820, 34972, 35080, 35099, 35121, 35160, 35190, 35217, 35253, 35283, 35336, 35397, 35416, 35421, 35426, 35438, 35471, 35488, 35490, 35493, 35541, 35553, 35566, 35573, 35577, 35581, 35587, 35588, 35592, 35595, 35596, 35603, 35619, 35621, 35629, 35635, 35642, 35673, 35675, 35677, 35679, 35682, 35683, 35684, 35687, 35689, 35692, 35693, 35694, 35697, 35700, 35703, 35705, 35708, 35710, 35713, 35715, 35717, 35719, 35722, 35724, 35727, 35729, 35732, 35734, 35737, 35739, 35742, 35743, 35745, 35748, 35749, 35750, 35752, 35755, 35756, 35757, 35760, 35762, 35763, 35764, 35767, 35770, 35772, 35775, 35776, 35779, 35782, 35784, 35789, 35805, 35806, 35810, 35818, 35823, 35826, 35827, 35850, 35857, 35865, 35870, 35882, 35890, 35910, 35916, 35917, 35929, 35930, 35933, 35945, 35955, 35968, 35993, 35995, 35999, 36024, 36164, 36179, 36181, 36402, 36410, 36416, 36528, 36585, 36651, 36813, 36912, 36924, 36926, 36931, 36937, 36940, 36942, 36948, 36953, 37036, 37058, 37068, 37096, 37103, 37146, 37159, 37173, 37262, 37334, 37387, 37468, 37477, 37493, 37501, 37506, 37512, 37515, 37524, 37525, 37529, 37573, 37579, 37609, 37617, 37647, 37675, 37788, 37876, 38033, 38038, 38081, 38184, 38202, 38223, 38229, 38247, 38359, 38386, 38477, 38479, 38481, 38483, 38485, 38488, 38490, 38492, 38494, 38496, 38498, 38500, 38502, 38505, 38507, 38509, 38511, 38514, 38516, 38519, 38521, 38523, 38530, 38536, 38540, 38561, 38570, 38593, 38608, 38613, 38623, 38645, 38651, 38661, 38666, 38668, 38669, 38673, 38674, 38675, 38681, 38683, 38693, 38694, 38695, 38700, 38712, 38720, 38727, 38740, 38742, 38755, 38756, 38764, 38772, 38775, 38779, 38784, 38791, 38801, 38821, 38860, 38864, 38867, 38870, 38873, 38876, 38883, 38885, 38888, 38906, 38918, 38920, 38962, 39181, 39245, 39282, 39288, 39360, 39446, 39570, 39703, 40355, 40372, 40381, 40576, 41148, 41292, 41428, 41462, 41863, 42250, 42256, 42287, 42358, 42395, 42400, 42409, 42444, 42451, 42456, 42466, 42485, 42498, 42538, 42554, 42563, 42578, 42591, 42608, 42619, 42645, 42648, 42656, 42688, 42690, 42701, 42705, 42732, 42751, 42763, 42786, 42895, 43026, 43040, 43053, 43061, 43129, 43171, 43513, 43585, 43587, 43590, 43592, 43594, 43596, 43599, 43601, 43604, 43606, 43608, 43610, 43613, 43615, 43618, 43620, 43624, 43627, 43629, 43631, 43633, 43636, 43638, 43641, 43644, 43647, 43649, 43651, 43653, 43656, 43666, 43678, 43696, 43715, 43765, 43776, 43798, 43828, 43847, 43980, 44217, 44220, 44226, 44230, 44233, 44236, 44241, 44242, 44250, 44257, 44260, 44274, 44280, 44285, 44289, 44298, 44318, 44334, 44347, 44357, 44376, 44386, 44403, 44416, 44431, 44591, 44614, 44621, 44649, 44664, 44671, 44695, 44721, 44727, 44734, 44870, 44901, 44938, 44951, 44970, 45000, 45024, 45056, 45149, 45160, 45219, 45532, 45540, 45550, 45553, 45555, 45565, 45575, 45593, 45606, 45609, 45615, 45645, 45656, 45661, 45669, 45760, 45764, 46004, 46029, 46043, 46056, 46061, 46064, 46066, 46081, 46107, 46122, 46125, 46280, 46282, 46374, 46395, 46568, 46582, 46667, 46696, 46701, 46722, 46741, 46748, 46756, 46764, 46777, 46780, 46784, 46792, 46793, 46794, 46798, 46799, 46802, 46807, 46809, 46813, 46815, 46998, 47142, 47190, 47242, 47618, 47630, 47638, 47644, 47654, 47656, 47664, 47689, 47727, 47762, 47783, 47812, 47827, 47881, 47916, 47931, 47938, 47941, 47962, 47967, 48053, 48096, 48126, 48205, 48260, 48348, 48434, 48580, 48865, 48870, 48979, 48981, 48983, 48985, 49254, 49268, 49338, 49361, 49466, 49500, 49504, 49507, 49509, 49513, 49522, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49545, 49548, 49550, 49739, 49821, 50147, 50160, 50188, 50199, 50311, 50347, 50384, 50423, 50976, 50978, 50980, 50982, 50984, 50986, 50988, 50990, 50992, 50994, 50996, 50998, 51010, 51011, 51019, 51025, 51042, 51051, 51060, 51063, 51066, 51080, 51172, 51196, 51243, 51246, 51287, 51292, 51316, 51323, 51330, 51332, 51357, 51364, 51367, 51369, 51373, 51377, 51380, 51668, 51835, 51853, 51919, 51922, 51923, 51977, 52061, 52134, 52159, 52173, 52177, 52181, 52185, 52191, 52293, 52349, 52414) 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 Smuglers

Afterpiece Title: The Patron or Statesmans Opera

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Calista Actor: Mrs Oldfield

Performances

Mainpiece Title: The Temple Beau

Performances

Mainpiece Title: The Temple Beau

Performances

Mainpiece Title: The Temple Beau

Performances

Mainpiece Title: The Temple Beau

Performances

Mainpiece Title: The Temple Beau

Performances

Mainpiece Title: The Temple Beau

Performances

Mainpiece Title: The Temple Beau

Performances

Mainpiece Title: The Temple Beau

Performances

Mainpiece Title: The Temple Beau

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Calista Actor: Mrs Oldfield

Dance: Mrs Booth

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Calista Actor: Mrs Mullart

Afterpiece Title: Jack the Giant Killer

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Calista Actor: Mrs Giffard

Afterpiece Title: Flora

Song:

Dance:

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Calista Actor: Mrs Mullart

Afterpiece Title: Tom Thumb

Afterpiece Title: The Battle of the Poets

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Calista Actor: Mrs Giffard

Afterpiece Title: Damon and Phillida

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Calista Actor: Mrs Giffard

Afterpiece Title: Damon and Phillida

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Calista Actor: Mrs Wilson

Performances

Mainpiece Title: The Miser

Cast
Role: List Actor: Oates

Performances

Mainpiece Title: The Miser

Cast
Role: List Actor: Oates

Afterpiece Title: The Harlots Progress

Performances

Mainpiece Title: The Miser

Cast
Role: List Actor: Oates

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

Dance: Essex, Miss Robinson

Performances

Mainpiece Title: The Miser

Cast
Role: List Actor: Oates

Afterpiece Title: The Harlots Progress

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Calista Actor: Mrs Heron

Afterpiece Title: The Country House

Music: A Comic Medley Overture composed by Charke

Dance: I: A new Maggot by Le Brun. In II: Polonese, as17340325 V: Pierrots by Poitier and Nivelon. End I of Afterpiece: English Maggot by Lally and Mrs Walter. End Afterpiece: Grand Dance in Momus, as17340316

Song: III: Was ever Nymph like Rosamond by Miss Arne. IV: Bella Sorge L'Esperanza (from Ariadne) by Miss Arne

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Calista Actor: Mrs Heron

Afterpiece Title: Cupid and Psyche

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Calista Actor: Roberts

Afterpiece Title: The Lottery

Dance: V: Pierrot by Davenport. End of Afterpiece: Minuet and Saraband by Miss Brett

Song: In Mainpiece: By Miss Jones