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 Grecian Daughter

Afterpiece Title: Who's the Dupe

Ballet: End: The Scotch Ghost; or, Little Fanny's Love. The Lady of Dunblain-Mlle Parisot (By permission of the Proprietor of the king's Theatre); Jamie-Gentili; Glaude-Dubois; Saundy-Master Menage; Donald-Whitmell; Elpsa-Mrs Brooker; Fanny (with a Hornpipe)-Sga Bossi delCaro; Hornpipe-Sga Bossi delCaro; Villagers-Banks, Butler, Garman, Nicolini, Roffey, Thompson, Wells, Ms Barrett, Ms Bourk, Ms Brigg, Ms Byrne, Ms Daniels, Ms Thompson, Ms Haskey

Cast
Role: Hornpipe Actor: Sga Bossi delCaro

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Virgin Unmask'd

Ballet: The Scotch Ghost. As17961029

Cast
Role: Hornpipe Actor: Sga Bossi delCaro

Performances

Mainpiece Title: Fortune's Fool

Afterpiece Title: Harlequin's Treasure

Music: Afterpiece: Harp to be played-Weippert

Performances

Mainpiece Title: The Heiress

Afterpiece Title: The Prisoner

Ballet: End: The Scotch Ghost. As17961029, but Villagers-Mrs _Thompson

Cast
Role: Hornpipe Actor: Sga Bossi delCaro

Performances

Mainpiece Title: Fortune's Fool

Afterpiece Title: Harlequin's Treasure

Music: As17961031

Performances

Mainpiece Title: The Rivals

Afterpiece Title: Richard Coeur de Lion

Dance: III afterpiece: Dance, as17961019

Ballet: End: The Scotch Ghost. As17961029, but The Lady of Dunblain-_; Villagers-_

Cast
Role: Hornpipe Actor: Sga Bossi delCaro

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: My Grandmother

Ballet: End: The Scotch Ghost. As17961108, but Glaude-Grimaldi

Cast
Role: Hornpipe Actor: Sga Bossi delCaro

Performances

Mainpiece Title: Love For Love

Afterpiece Title: Richard Coeur de Lion

Dance: In III afterpiece: Dance, as17961019

Ballet: End: The Scotch Ghost. As17961112

Cast
Role: Hornpipe Actor: Sga Bossi delCaro

Performances

Mainpiece Title: The Belle's Stratagem

Afterpiece Title: No Song No Supper

Ballet: End: The Scotch Ghost. As17961029, but Glaude-Grimaldi; The Lady of Dunblain-_; Villagers-Ms _Byrne, Ms _Thompson

Cast
Role: Hornpipe Actor: Sga Bossi delCaro

Performances

Mainpiece Title: First Love

Afterpiece Title: The Apprentice

Ballet: The Scotch Ghost. As17961116

Cast
Role: Hornpipe Actor: Sga Bossi delCaro

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: The Devil to Pay

Ballet: The Scotch Ghost. As17961112

Cast
Role: Hornpipe Actor: Sga Bossi delCaro

Performances

Mainpiece Title: The Siege Of Belgrade

Afterpiece Title: The Apprentice

Ballet: The Scotch Ghost. As17961116

Cast
Role: Hornpipe Actor: Sga Bossi delCaro

Performances

Mainpiece Title: The London Merchant; Or, George Barnwell

Afterpiece Title: The Adopted Child

Ballet: The Scotch Ghost. As17961112

Cast
Role: Hornpipe Actor: Sga Bossi delCaro

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: The Devil to Pay

Ballet: The Scotch Ghost. As17961112

Cast
Role: Hornpipe Actor: Sga Bossi delCaro

Performances

Mainpiece Title: Richard Coeur De Lion

Afterpiece Title: The Child of Nature

Afterpiece Title: The Apprentice

Dance: III 1st piece: Dance, as17961019

Ballet: End 2nd piece: The Scotch Ghost. As17961112

Cast
Role: Hornpipe Actor: Sga Bossi delCaro

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: The Humourist

Ballet: The Scotch Ghost. As17961116

Cast
Role: Hornpipe Actor: Sga Bossi delCaro

Performances

Mainpiece Title: The Wheel Of Fortune

Afterpiece Title: The Devil to Pay

Ballet: The Scotch Ghost. As17961112

Cast
Role: Hornpipe Actor: Sga Bossi delCaro

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: The Shipwreck

Ballet: The Scotch Ghost. As17961112

Cast
Role: Hornpipe Actor: Sga Bossi delCaro

Performances

Mainpiece Title: The School For Scandal

Afterpiece Title: The Shipwreck

Ballet: End: The Scotch Ghost. Jamie-Gentili; Glaude-Grimaldi; Fanny-Sga Bossi DelCaro; Hornpipe-Sga Bossi DelCaro [no other performers listed (see17961116)]

Cast
Role: Hornpipe Actor: Sga Bossi DelCaro

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: The Shipwreck

Ballet: End: The Scotch Ghost. As17961112, but Hornpipe-_

Cast
Role: Hornpipe Actor: Sga Bossi delCaro

Performances

Mainpiece Title: The Distress'd Mother

Afterpiece Title: The Shipwreck

Ballet: End: The Scotch Ghost. As17961214, but Hornpipe-_

Cast
Role: Hornpipe Actor: Sga Bossi DelCaro

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: The Shipwreck

Ballet: The Scotch Ghost. As17961221

Cast
Role: Hornpipe Actor: Sga Bossi DelCaro

Performances

Mainpiece Title: The Siege Of Belgrade

Afterpiece Title: Robinson Crusoe

Ballet: End I: The Scotch Ghost. As17961221

Cast
Role: Hornpipe Actor: Sga Bossi DelCaro

Performances

Mainpiece Title: Richard Coeur De Lion

Afterpiece Title: Who's the Dupe

Afterpiece Title: Robinson Crusoe

Ballet: End: The Scotch Ghost. As17961221

Cast
Role: Hornpipe Actor: Sga Bossi DelCaro

Performances

Mainpiece Title: Douglas

Afterpiece Title: Robinson Crusoe

Ballet: The Scotch Ghost. As17961221

Cast
Role: Hornpipe Actor: Sga Bossi DelCaro