SELECT * FROM london_stages WHERE eventid IN (1567, 9979, 9981, 13371, 15479, 18397, 18401, 18407, 18411, 18445, 18452, 18469, 18620, 18803, 18950, 18954, 18956, 18959, 18961, 18963, 18965, 18968, 18970, 18973, 19019, 19024, 19027, 19031, 19045, 19322, 20114, 20434, 20450, 20719, 20799, 20886, 20960, 20966, 21000, 21033, 21277, 21295, 21712, 21736, 21792, 21819, 21831, 22267, 22759, 22833, 22834, 22956, 22958, 22961, 23002, 23011, 23020, 23055, 23090, 23106, 23127, 23156, 23247, 23351, 23369, 23389, 23433, 23501, 23551, 23555, 23595, 23606, 23626, 23667, 23670, 23861, 23875, 23894, 23925, 23928, 23932, 23935, 23944, 23987, 23988, 23990, 24001, 24002, 24017, 24059, 24064, 24159, 24182, 24185, 24201, 24214, 24235, 24292, 24298, 24301, 24302, 24303, 24304, 24305, 24306, 24308, 24309, 24310, 24311, 24312, 24313, 24315, 24316, 24326, 24351, 24355, 24410, 24428, 24500, 24527, 24568, 24570, 24630, 24680, 24712, 24750, 24771, 24775, 24779, 24789, 24794, 24796, 24799, 24802, 24812, 24813, 24873, 24912, 24956, 24990, 25044, 25126, 25144, 25158, 25188, 25263, 25288, 25295, 25319, 25372, 25490, 25524, 25548, 25550, 25554, 25655, 25675, 25688, 25702, 25705, 25721, 25745, 25747, 25748, 25751, 25754, 25756, 25767, 25769, 25773, 25787, 25793, 25797, 25801, 25815, 25841, 25858, 25900, 25938, 25975, 26088, 26134, 26154, 26203, 26331, 26334, 26337, 26340, 26343, 26346, 26349, 26354, 26357, 26360, 26375, 26380, 26385, 26390, 26395, 26400, 26405, 26410, 26415, 26420, 26425, 26428, 26433, 26438, 26443, 26448, 26453, 26458, 26463, 26468, 26471, 26474, 26477, 26480, 26483, 26486, 26489, 26492, 26498, 26503, 26506, 26510, 26636, 26639, 26819, 26907, 27100, 27145, 27196, 27198, 27206, 27247, 27290, 27342, 27365, 27398, 27453, 27528, 27530, 27539, 27547, 27640, 27647, 27665, 28078, 28119, 28133, 28194, 28274, 28294, 28476, 28481, 28534, 28536, 28545, 28547, 28552, 28557, 28559, 28567, 28592, 28598, 28601, 28606, 28607, 28608, 28612, 28632, 28637, 28640, 28650, 28652, 28685, 28688, 28690, 28693, 28698, 28704, 28795, 28844, 29052, 29085, 29188, 29368, 29370, 29380, 29389, 29458, 29542, 29598, 29743, 29746, 29748, 29750, 29751, 29753, 29755, 29757, 29759, 29761, 29763, 29765, 29767, 29769, 29771, 29773, 29775, 29777, 29779, 29781, 29783, 29785, 29789, 29791, 29793, 29795, 29798, 29800, 29802, 29805, 29807, 29809, 29811, 29814, 29816, 29818, 29820, 29829, 29839, 29897, 29902, 29910, 29920, 29937, 29948, 29961, 29968, 29988, 30043, 30062, 30089, 30099, 30101, 30107, 30112, 30117, 30126, 30128, 30148, 30152, 30275, 30277, 30278, 30280, 30281, 30284, 30285, 30286, 30288, 30291, 30295, 30299, 30307, 30309, 30311, 30315, 30321, 30323, 30329, 30337, 30374, 30408, 30410, 30420, 30450, 30561, 30566, 30575, 30670, 30686, 30690, 30695, 30699, 30779, 30783, 30787, 30793, 30800, 30801, 30803, 30808, 30809, 30814, 30839, 30852, 30875, 30878, 30900, 30916, 30928, 30947, 30983, 30987, 31050, 31117, 31187, 31198, 31203, 31215, 31247, 31252, 31279, 31333, 31335, 31344, 31349, 31372, 31394, 31432, 31491, 31523, 31526, 31535, 31569, 31605, 31617, 31626, 31642, 31657, 31673, 31677, 31689, 31695, 31700, 31705, 31725, 31729, 31731, 31740, 31749, 31758, 31767, 31771, 31825, 31839, 31847, 31877, 31881, 31885, 31887, 31891, 31920, 31933, 31954, 31990, 32088, 32153, 32201, 32235, 32247, 32258, 32264, 32312, 32327, 32342, 32346, 32347, 32348, 32366, 32375, 32495, 32563, 32636, 32666, 32671, 32676, 32679, 32685, 32688, 32696, 32699, 32715, 32719, 32723, 32724, 32742, 32748, 32785, 32786, 32789, 32800, 32801, 32802, 32803, 32804, 32805, 32813, 32815, 32817, 32822, 32838, 32845, 32879, 32996, 33104, 33106, 33120, 33134, 33159, 33178, 33201, 33262, 33269, 33283, 33295, 33421, 33495, 33520, 33598, 33623, 33648, 33653, 33665, 33670, 33679, 33689, 33691, 33694, 33699, 33701, 33703, 33708, 33711, 33713, 33714, 33716, 33830, 33834, 33836, 33838, 33848, 33850, 33880, 33899, 33941, 33954, 33956, 33968, 33973, 33983, 33987, 34006, 34013, 34020, 34068, 34073, 34079, 34185, 34190, 34200, 34205, 34208, 34215, 34220, 34228, 34230, 34235, 34238, 34250, 34266, 34351, 34370, 34382, 34417, 34434, 34490, 34499, 34519, 34553, 34718, 34725, 34730, 34733, 34735, 34737, 34748, 34752, 34757, 34764, 34766, 34773, 34776, 34790, 34801, 34896, 34916, 34917, 34942, 34956, 34973, 34983, 34990, 35020, 35056, 35061, 35083, 35090, 35114, 35203, 35282, 35284, 35290, 35294, 35297, 35317, 35331, 35333, 35349, 35358, 35363, 35514, 35515, 35643, 35663, 35697, 35757, 35772, 35793, 35826, 35855, 35861, 35884, 35887, 35892, 35900, 35906, 35928, 35941, 35944, 35946, 35950, 35964, 35984, 35990, 36085, 36109, 36154, 36230, 36235, 36261, 36267, 36294, 36346, 36533, 36639, 36640, 36641, 36645, 36658, 36662, 36687, 36720, 36728, 36733, 36847, 36883, 36910, 36956, 36963, 37036, 37037, 37045, 37050, 37052, 37056, 37058, 37068, 37073, 37096, 37108, 37124, 37175, 37177, 37178, 37179, 37180, 37183, 37186, 37190, 37193, 37199, 37201, 37204, 37207, 37209, 37219, 37222, 37226, 37240, 37242, 37258, 37265, 37273, 37281, 37289, 37302, 37308, 37320, 37332, 37334, 37339, 37355, 37374, 37381, 37399, 37401, 37415, 37423, 37449, 37546, 37549, 37568, 37575, 37580, 37589, 37593, 37595, 37600, 37603, 37607, 37612, 37614, 37617, 37619, 37636, 37644, 37647, 37649, 37652, 37663, 37666, 37674, 37676, 37677, 37678, 37763, 37796, 37804, 37832, 37869, 37974, 38068, 38159, 38161, 38214, 38311, 38365, 38406, 38656, 38732, 38734, 38762, 38858, 39850, 39867, 39876, 39878, 39887, 40593, 40596, 40600, 40602, 40604, 40606, 40608, 40611, 40619, 41520, 41552, 41557, 41559, 46484, 46493, 46498, 46507, 46512, 46520, 47885, 48384, 48409, 48411, 48430, 49597, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50079, 50082, 50087, 50089, 50097, 50111, 50141, 50143, 50151, 50153, 50156, 50161, 50170, 50177, 50184, 50186, 50189, 50203, 50215, 50374, 50380, 50382, 50384, 50385, 50386, 50387, 50397, 50405, 50407, 50411, 50415, 50423, 50427, 50432, 50437, 50439, 50451, 50453, 50460, 50465, 50474, 50479, 50481, 50505, 50507, 50509, 50514, 50519, 50528, 50533, 50535, 50542, 50548, 50550, 50553, 50561, 50563, 50565, 50570, 50585, 50590, 50592, 50594, 50599, 50619, 50643, 50649, 50655, 50661, 50667, 50673, 50687, 50692, 50696, 50701, 50706, 50711, 50721, 50723, 50725, 50741, 50771, 50778, 50789, 50799, 50804, 50811, 50816, 51550, 51554, 51556, 51558, 51560, 51564, 51568, 51586, 51590, 51604, 51614, 51616, 51879) 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 London Merchant

Afterpiece Title: Cape St

Ballet: The Scotch Ghost. As17961221

Cast
Role: Hornpipe Actor: Sga Bossi DelCaro

Performances

Mainpiece Title: The Will

Afterpiece Title: The Purse

Ballet: The Scotch Ghost. As17961221

Cast
Role: Hornpipe Actor: Sga Bossi DelCaro

Performances

Mainpiece Title: The Will

Afterpiece Title: The Humourist

Ballet: The Scotch Ghost. As17961221

Cast
Role: Hornpipe Actor: Sga Bossi DelCaro

Performances

Mainpiece Title: The Will

Afterpiece Title: Katharine and Petruchio

Ballet: The Scotch Ghost. As17961221

Cast
Role: Hornpipe Actor: Sga Bossi DelCaro

Performances

Mainpiece Title: The Will

Afterpiece Title: The Apprentice

Ballet: The Scotch Ghost. As17961221

Cast
Role: Hornpipe Actor: Sga Bossi DelCaro

Performances

Mainpiece Title: The Queen Of Carthage

Afterpiece Title: The Spoil'd Child

Afterpiece Title: My Nightgown and Slippers

Ballet: The Scotch Ghost. As17970105

Cast
Role: Hornpipe Actor: Sga Bossi DelCaro

Performances

Mainpiece Title: Hamlet

Afterpiece Title: My Grandmother

Ballet: The Scotch Ghost. As17961221

Cast
Role: Hornpipe Actor: Sga Bossi DelCaro

Performances

Mainpiece Title: The Will

Afterpiece Title: No Song No Supper

Ballet: The Scotch Ghost. As17961221

Cast
Role: Hornpipe Actor: Sga Bossi DelCaro

Performances

Mainpiece Title: The Will

Afterpiece Title: The Humourist

Ballet: The Scotch Ghost. As17961221

Cast
Role: Hornpipe Actor: Sga Bossi DelCaro

Performances

Mainpiece Title: As You Like It

Afterpiece Title: The Critic; or, A Tragedy Rehearsed

Song: V: song-Mrs Bland

Ballet: The Scotch Ghost. As17961221

Cast
Role: Hornpipe Actor: Sga Bossi DelCaro

Performances

Mainpiece Title: The Last Of The Family

Afterpiece Title: The Prisoner

Ballet: The Scotch Ghost. As17961221

Cast
Role: Hornpipe Actor: Sga Bossi DelCaro

Performances

Mainpiece Title: The Wheel Of Fortune

Afterpiece Title: The Spoil'd Child

Ballet: The Scotch Ghost. As17961221

Cast
Role: Hornpipe Actor: Sga Bossi DelCaro

Performances

Mainpiece Title: The Siege Of Belgrade

Afterpiece Title: The Wandering Jew

Ballet: End: The Scotch Ghost. As17961221, but Glaude-Roffey

Cast
Role: Hornpipe Actor: Sga Bossi DelCaro

Performances

Mainpiece Title: The School For Scandal

Afterpiece Title: The Critic

Ballet: The Scotch Ghost. As17961221

Cast
Role: Hornpipe Actor: Sga Bossi DelCaro

Entertainment: Imitations. End: a Variety of Imitations-Caulfield

Performances

Mainpiece Title: Love Makes A Man

Afterpiece Title: The Spoil'd Child

Song: End I: When on board our trim Vessel-Cooke (composed by Carter); End IV: Chelsea Quarters (composed by Schroeder)-Cooke

Entertainment: Imitations. End: a Variety of Imitations-Caulfield

Ballet: Following Imitations: The Scotch Ghost. As17961221

Cast
Role: Hornpipe Actor: Sga Bossi DelCaro

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The Sultan

Ballet: End afterpiece: The Scotch Ghost. As17961221

Cast
Role: Hornpipe Actor: Sga Bossi DelCaro

Performances

Mainpiece Title: The Heiress

Afterpiece Title: High Life below Stairs

Dance: II afterpiece: Mock Minuet, as17960920

Ballet: End: The Scotch Ghost. As17970605

Cast
Role: Hornpipe Actor: Sga Bossi DelCaro

Performances

Mainpiece Title: A Bold Stroke For A Wife

Afterpiece Title: The Captive of Spilburg

Dance: In afterpiece: a Dance-Roffey, Whitmell, Wells, Male, Garman, W. Banks, Goodman, Gauron, Ms Brooker, Ms Daniels, Ms Brigg, Ms Byrne, Ms Vining, Ms Luciet, Ms Drake, Ms Riches; New Hornpipe-Sga Bossi DelCaro

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: The Captive of Spilburg

Dance: As17981114

Performances

Mainpiece Title: The Castle-spectre

Afterpiece Title: The Captive of Spilburg

Dance: As17981114

Performances

Mainpiece Title: King Richard The Third

Afterpiece Title: The Captive of Spilburg

Dance: As17981114

Performances

Mainpiece Title: The Wheel Of Fortune

Afterpiece Title: The Captive of Spilburg

Dance: As17981114

Performances

Mainpiece Title: The Young Quaker

Afterpiece Title: The Captive of Spilburg

Dance: As17981114

Performances

Mainpiece Title: The Castle-spectre

Afterpiece Title: The Captive of Spilburg

Dance: As17981114, but New Hornpipe-_

Performances

Mainpiece Title: A Word For Nature

Afterpiece Title: The Captive of Spilburg

Dance: a Dance, as17981114, but _Male, W. _Banks, Johnston; +New Hornpipe, as17981114