SELECT * FROM london_stages WHERE eventid IN (46836, 46838, 46841, 46846, 46854, 46858, 46863, 46873, 46877, 46883, 46903, 46915, 46919, 46921, 46923, 46925, 46927, 46929, 46931, 46933, 46937, 46947, 46953, 46955, 46961, 46963, 46965, 46967, 46969, 46971, 46973, 46975, 46977, 46979, 46981, 46983, 46985, 46989, 46991, 46993, 46995, 46997, 46999, 47001, 47003, 47005, 47007, 47009, 47013, 47015, 47017, 47019, 47021, 47023, 47025, 47027, 47029, 47031, 47033, 47035, 47037, 47039, 47041, 47049, 47053, 47055, 47057, 47061, 47066, 47068, 47071, 47076, 47081, 47083, 47086, 47088, 47091, 47093, 47096, 47098, 47101, 47104, 47108, 47112, 47114, 47117, 47119, 47122, 47124, 47126, 47128, 47131, 47133, 47137, 47139, 47142, 47144, 47148, 47150, 47154, 47156, 47159, 47161, 47165, 47167, 47171, 47177, 47179, 47186, 47190, 47196, 47202, 47204, 47207, 47212, 47214, 47220, 47226, 47229, 47235, 47238, 47253, 47259, 47264, 47270, 47273, 47277, 47279, 47283, 47291, 47301, 47304, 47312, 47320, 47326, 47440, 47441, 47442, 47444, 47446, 47451, 47454, 47458, 47462, 47467, 47470, 47472, 47489, 47491, 47503, 47509, 47515, 47517, 47521, 47523, 47529, 47533, 47535, 47537, 47539, 47541, 47543, 47547, 47549, 47551, 47555, 47557, 47559, 47561, 47564, 47568, 47570, 47572, 47575, 47577, 47591, 47595, 47600, 47603, 47607, 47611, 47616, 47619, 47623, 47635, 47637, 47639, 47643, 47647, 47649, 47651, 47657, 47659, 47661, 47663, 47668, 47674, 47678, 47680, 47688, 47696, 47701, 47704, 47709, 47711, 47714, 47716, 47722, 47724, 47726, 47729, 47731, 47741, 47746, 47749, 47754, 47756, 47761, 47769, 47771, 47776, 47794, 47800, 47803, 47805, 47810, 47815, 47820, 47823, 47830, 47835, 47838, 47840, 47848, 47850, 47853, 47860, 47863, 47865, 47869, 47877, 47882, 47885, 47887, 47890, 47997, 48002, 48010, 48026, 48029, 48041, 48045, 48051, 48053, 48055, 48057, 48061, 48062, 48064, 48066, 48068, 48070, 48072, 48074, 48076, 48078, 48080, 48082, 48084, 48086, 48093, 48095, 48097, 48099, 48105, 48111, 48113, 48115, 48117, 48119, 48123, 48129, 48133, 48135, 48139, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48168, 48170, 48172, 48174, 48176, 48178, 48180, 48182, 48192, 48202, 48204, 48216, 48231, 48241, 48245, 48250, 48252, 48255, 48257, 48261, 48266, 48269, 48271, 48273, 48275, 48280, 48283, 48287, 48297, 48301, 48303, 48306, 48308, 48311, 48313, 48315, 48317, 48320, 48322, 48325, 48327, 48329, 48331, 48336, 48339, 48341, 48344, 48347, 48352, 48354, 48356, 48358, 48361, 48363, 48366, 48368, 48372, 48375, 48377, 48380, 48382, 48384, 48386, 48389, 48391, 48394, 48396, 48398, 48402, 48404, 48407, 48409, 48411, 48413, 48418, 48427, 48430, 48432, 48437, 48439, 48444, 48535, 48537, 48541, 48543, 48547, 48549, 48551, 48553, 48555, 48557, 48559, 48561, 48565, 48567, 48569, 48571, 48573, 48581, 48585, 48588, 48590, 48592, 48594, 48596, 48598, 48605, 48609, 48611, 48613, 48618, 48620, 48621, 48623, 48625, 48628, 48631, 48635, 48637, 48647, 48651, 48654, 48657, 48664, 48667, 48669, 48674, 48677, 48679, 48684, 48687, 48689, 48692, 48694, 48695, 48699, 48708, 48715, 48717, 48719, 48727, 48729, 48734, 48735, 48744, 48752, 48754, 48755, 48757, 48759, 48761, 48766, 48767, 48769, 48771, 48774, 48775, 48777, 48779, 48781, 48783, 48785, 48787, 48789, 48791, 48793, 48796, 48798, 48801, 48803, 48805, 48810, 48812, 48815, 48817, 48819, 48821, 48824, 48826, 48828, 48830, 48832, 48835, 48837, 48840, 48851, 48856, 48858, 48860, 48865, 48870, 48872, 48877, 48884, 48898, 48902, 48904, 48908, 48912, 48916, 48922, 48923, 48926, 48930, 48933, 48937, 48938, 48941, 48942, 48945, 48947, 48951, 48952, 48959, 48961, 48971, 48980, 48984, 48988, 48990, 48993, 48995, 49000, 49002, 49004, 49009, 49012, 49014, 49016, 49018, 49021, 49023, 49026, 49028, 49033, 49038, 49041, 49043, 49046, 49048, 49051, 49053, 49056, 49058, 49061, 49066, 49069, 49072, 49074, 49077, 49081, 49083, 49086, 49088, 49090, 49100, 49184, 49188, 49191, 49195, 49197, 49201, 49203, 49209, 49224, 49228, 49232, 49234, 49236, 49238, 49240, 49242, 49246, 49248, 49250, 49252, 49254, 49256, 49258, 49260, 49264, 49266, 49268, 49270, 49272, 49274, 49276, 49278, 49280, 49282, 49284, 49286, 49288, 49290, 49292, 49294, 49296, 49298, 49300, 49302, 49305, 49307, 49310, 49312, 49314, 49316, 49319, 49321, 49324, 49326, 49328, 49330, 49333, 49335, 49362, 49364, 49366, 49368, 49380, 49382, 49392, 49394, 49396, 49404, 49406, 49408, 49411, 49413, 49416, 49418, 49420, 49422, 49425, 49427, 49430, 49432, 49434, 49436, 49439, 49467, 49475, 49480, 49493, 49500, 49504, 49509, 49517, 49520, 49522, 49525, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49543, 49545, 49548, 49550, 49553, 49556, 49558, 49560, 49565, 49568, 49570, 49573, 49575, 49578, 49580, 49583, 49585, 49587, 49589, 49592, 49597, 49599, 49602, 49604, 49607, 49609, 49612, 49614, 49616, 49620, 49622, 49625, 49627, 49630, 49635, 49637, 49640, 49644, 49646, 49649, 49650, 49653, 49655, 49657, 49659, 49662, 49664, 49667, 49757, 49759, 49761, 49764, 49768, 49772, 49775, 49777, 49779, 49780, 49785, 49787, 49796, 49799, 49803, 49809, 49817, 49819, 49821, 49823, 49829, 49833, 49835, 49839, 49843, 49845, 49855, 49857, 49861, 49865, 49869, 49877, 49881, 49883, 49893, 49900, 49902, 49905, 49907, 49910, 49912, 49915, 49917, 49919, 49921, 49924, 49926, 49929, 49931, 49933, 49935, 49938, 49940, 49943, 49945, 49947, 49949, 49952, 49954, 49957, 49959, 49961, 49963, 49966, 49968, 49971, 49973, 49975, 49978, 49980, 49983, 49985, 49987, 49989, 49992, 49994, 49998, 50001, 50004, 50006, 50010, 50013, 50016, 50019, 50023, 50026, 50029, 50031, 50035, 50038, 50041, 50044, 50048, 50052, 50055, 50070, 50073, 50077, 50079, 50084, 50089, 50092, 50094, 50097, 50099, 50102, 50104, 50106, 50113, 50116, 50121, 50123, 50128, 50134, 50136, 50138, 50143, 50148, 50151, 50158, 50163, 50166, 50170, 50172, 50175, 50179, 50181, 50184, 50186, 50191, 50193, 50195, 50198, 50200, 50203, 50208, 50210, 50327, 50330, 50332, 50334, 50336, 50338, 50345, 50350, 50352, 50353, 50356, 50358, 50360, 50361, 50364, 50368, 50370, 50371, 50376, 50378, 50389, 50391, 50394, 50396, 50398, 50400, 50412, 50418, 50420, 50422, 50424, 50426, 50428, 50433, 50435, 50438, 50440, 50444, 50447, 50452, 50454, 50456, 50458, 50463, 50468, 50470, 50472, 50475, 50477, 50480, 50482, 50484, 50489, 50492, 50494, 50496, 50498, 50501, 50503, 50508, 50510, 50515, 50517, 50524, 50529, 50536, 50549, 50562, 50602, 50623, 50628, 50640, 50704, 50709, 50712, 50714, 50717, 50719, 50722, 50724, 50726, 50728, 50733, 50736, 50739, 50742, 50744, 50747, 50749, 50752, 50754, 50757, 50759, 50762, 50764, 50767, 50769, 50774, 50777, 50782, 50784, 50790, 50791, 50792, 50795, 50797, 50802, 50805, 50808, 50915, 50919, 50921, 50923, 50925, 50927, 50929, 50934, 50937, 50942, 50944, 50948, 50950, 50951, 50953, 50957, 50959, 50961, 50963, 50969, 50977, 50979, 50983, 50985, 50987, 50989, 50991, 50997, 51024, 51047, 51050, 51052, 51057, 51138, 51145, 51150, 51152, 51154, 51159, 51161, 51164, 51166, 51168, 51170, 51179, 51180, 51185, 51187, 51189, 51191, 51192, 51194, 51197, 51199, 51204, 51206, 51209, 51211, 51213, 51215, 51216, 51218, 51225, 51229, 51237, 51239, 51241, 51242, 51258, 51261, 51263, 51266, 51268, 51273, 51277, 51280, 51283, 51290, 51295, 51302, 51304, 51307, 51309, 51312, 51314, 51317, 51319, 51322, 51324, 51327, 51329, 51333, 51336, 51338, 51341, 51343, 51345, 51349, 51351, 51354, 51356, 51358, 51360, 51363, 51365, 51368, 51370, 51498, 51505, 51521, 51525, 51527, 51529, 51531, 51535, 51537, 51539, 51541, 51543, 51545, 51547, 51549, 51551, 51553, 51555, 51557, 51559, 51561, 51563, 51565, 51567, 51569, 51571, 51575, 51577, 51579, 51581, 51583, 51585, 51589, 51591, 51598, 51601, 51603, 51605, 51607, 51610, 51613, 51615, 51617, 51619, 51621, 51624, 51627, 51629, 51631, 51634, 51636, 51639, 51641, 51643, 51645, 51648, 51650, 51655, 51657, 51659, 51662, 51664, 51667, 51669, 51673, 51676, 51678, 51681, 51688, 51701, 51711, 51720, 51723, 51730, 51732, 51737, 51747, 51748, 51755, 51757, 51765, 51767, 51769, 51771, 51772, 51774, 51777, 51779, 51782, 51784, 51786, 51789, 51792, 51794, 51797, 51799, 51801, 51803, 51806, 51808, 51811, 51813, 51815, 51817, 51820, 51822, 51825, 51828, 51831, 51833, 51836, 51841, 51843, 51845, 51847, 51849, 51851, 51854, 51856, 51859, 51861, 51864, 51866, 51869, 51871, 51873, 51877, 51879, 51882, 51885, 51887, 51890, 51895, 51898, 51900, 51902, 51907, 51909, 51914, 51917, 51919, 51922, 51924, 51927, 51929, 51933, 51936, 52057, 52060, 52062, 52066, 52068, 52070, 52072, 52077, 52079, 52081, 52082, 52085, 52093, 52097, 52102, 52104, 52106, 52116, 52122, 52134, 52136, 52138, 52140, 52142, 52144, 52146, 52148, 52150, 52152, 52154, 52156, 52158, 52160, 52164, 52166, 52168, 52170, 52172, 52174, 52176, 52178, 52180, 52182, 52184, 52186, 52190, 52194, 52196, 52231, 52241, 52243, 52245, 52248, 52250, 52255, 52257, 52259, 52262, 52264, 52269, 52271, 52277, 52280, 52284, 52286, 52291, 52300, 52308, 52310, 52312, 52314, 52319, 52324, 52326, 52333, 52341, 52347, 52348, 52353, 52355, 52357, 52360, 52362, 52367, 52374, 52377, 52379, 52381, 52383, 52384, 52386, 52389, 52391, 52394, 52396, 52398, 52400, 52403, 52405, 52408, 52410, 52415, 52420, 52425, 52427, 52429, 52432, 52434, 52437, 52439, 52442, 52444, 52447, 52449, 52452, 52454, 52456, 52458, 52461, 52463, 52466, 52468, 52473, 52476, 52481, 52483, 52490, 52497, 52499, 52504, 52506, 52509, 52511) 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 Messiah; Grand Selection 0

Music: End Part II: concerto on the Grand Piano Forte-Dussek

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End Part II: a trio for violin viola and violoncello-G. and R. and C. Ashley

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Cast
Role: Actor: Incledon
Role: Quartetto Actor: Mrs Crouch, Incledon, Kelly, Bartleman
Role: Gentle Airs Actor: Incledon
Role: Total eclipse Actor: Incledon

Afterpiece Title: Grand Selection 3

Cast
Role: The Captive King Actor: Incledon
Role: Adieu my partner Actor: Incledon

Music: End Part I: Sixth concerto of Geminiani on the violin-G. Ashley

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: The Relief of Williamstadt; or, The Return from Victory

Afterpiece Title: Hartford Bridge

Cast
Role: Captain Fieldair Actor: Incledon

Dance: In 2nd piece: Byrn, Holland, Mrs Watts, Mme Rossi

Entertainment: Monologue. A new Occasional Address in the character of Goldfinch ,-Lewis

Performances

Mainpiece Title: The Governor

Afterpiece Title: Hartford Bridge

Cast
Role: Captain Fieldair Actor: Incledon

Afterpiece Title: Harlequin's Museum

Performances

Mainpiece Title: Columbus

Afterpiece Title: Harlequin's Museum

Performances

Mainpiece Title: Every One Has His Fault

Afterpiece Title: Harlequin's Museum

Performances

Mainpiece Title: The Armourer

Cast
Role: Earl Fitzallan Actor: Incledon

Afterpiece Title: Lovers' Quarrels

Performances

Mainpiece Title: The Armourer

Cast
Role: Earl Fitzallan Actor: Incledon

Afterpiece Title: The Follies of a Day

Performances

Mainpiece Title: The Armourer

Cast
Role: Earl Fitzallan Actor: Incledon

Afterpiece Title: The Irishman in London

Performances

Mainpiece Title: Fashionable Levities

Afterpiece Title: Rosina

Cast
Role: Captain Belville Actor: Incledon

Afterpiece Title: The Invasion; or, All Alarm'd at Brighthelmstone

Entertainment: Monologue. Preceding 1st piece: An Eulogium on Money-Quick

Performances

Mainpiece Title: Every One Has His Fault

Afterpiece Title: The Invasion

Cast
Role: Captain Belville Actor: Incledon

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: The Midnight Wanderers

Cast
Role: Julian Actor: Incledon

Entertainment: Monologue. End: a new Occasional Address, as17930323

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: True Blue

Cast
Role: Lieutenant Actor: Incledon

Afterpiece Title: Comus

Cast
Role: Principal Bacchanal Actor: Incledon

Dance: In 2nd piece: a Hornpipe-Blurton

Song: In 3rd piece: Sweet Echo-Miss Broadhurst; accompanied on the hautboy-W. Parke; Nor on beds of fading flowers-Incledon

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: The Irishman in London

Performances

Mainpiece Title: Every One Has His Fault

Afterpiece Title: Hartford Bridge

Cast
Role: Captain Fieldair Actor: Incledon

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: True Blue

Cast
Role: Lieutenant Actor: Incledon
Role: Principal Bacchanal Actor: Incledon

Afterpiece Title: The Sultan

Dance: In 3rd piece: As17921003; In 2nd piece: Hornpipe, as17930411

Entertainment: Monologue End 2nd piece: Collins's Ode on the Passions-Mrs Esten

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: The Poor Soldier

Cast
Role: Dermot Actor: Incledon

Dance: End: The Bouquet, as17930415

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: Hartford Bridge

Cast
Role: Captain Fieldair Actor: Incledon

Dance: As17930418

Performances

Mainpiece Title: Such Things Are

Afterpiece Title: The Soldier's Festival; or, The Night before the Battle

Afterpiece Title: The Reprisal; or, The Tars of Old England

Song: In the course of 3rd piece: The Mid Watch, Rule Britannia-Incledon; and to conclude with God save the King in Full Chorus-

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: Money at a Pinch; or, The Irishman's Frolicks

Dance: End: The Merry Sailors-

Song: In afterpiece: the following songs (incidental to the Piece) The Row, The Land of Potatoes, My sweetest Honoria (to a favorite air of Carolan's)-Johnstone

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: Hartford Bridge

Cast
Role: Captain Fieldair Actor: Incledon

Dance: As17921116