SELECT * FROM london_stages WHERE eventid IN (34872, 34874, 34875, 34877, 34880, 34882, 34884, 35076, 35145, 35147, 35152, 35157, 35162, 35169, 35177, 35218, 35277, 35392, 35395, 35399, 35402, 35408, 35410, 35413, 35415, 35417, 35420, 35423, 35439, 35633, 35943, 35980, 36000, 36003, 36007, 36009, 36013, 36015, 36020, 36023, 36028, 36030, 36032, 36034, 36036, 36038, 36040, 36042, 36044, 36046, 36048, 36050, 36052, 36054, 36061, 36063, 36065, 36067, 36069, 36071, 36076, 36079, 36082, 36086, 36089, 36092, 36094, 36098, 36101, 36611, 36614, 36617, 36625, 36629, 36633, 36645, 36647, 36667, 36700, 36706, 36719, 36733, 36747, 36778, 36963, 37021, 37041, 37055, 37066, 37076, 37091, 37584, 37637, 37761, 37763, 37768, 37777, 38250, 38253, 38254, 38256, 38259, 38263, 38267, 38269, 38271, 38276, 38279, 38281, 38284, 38290, 38294, 38297, 38299, 38301, 38307, 38387, 38390, 38394, 38812, 39202, 39361, 39362, 39365, 39368, 39374, 39377, 39385, 39392, 39395, 40742, 40757, 40766, 40771, 40778, 40788, 40800, 40803, 40808, 40824, 40830, 40838, 40844, 40865, 40872, 40904, 40909, 40919, 40930, 40950, 40971, 40977, 40984, 41003, 41023, 41027, 41030, 41033, 41035, 41041, 41044, 41049, 41050, 41053, 41056, 41058, 41059, 41062, 41064, 41065, 41069, 41073, 41080, 41084, 41085, 41089, 41091, 41092, 41094, 41095, 41096, 41097, 41100, 41104, 41507, 41509, 41514, 41522, 41531, 41538, 41548, 41568, 41590, 41592, 41597, 41600, 41606, 41616, 41623, 41630, 41634, 41636, 41648, 41651, 41664, 42458, 42461, 42467, 42470, 42477, 42489, 42491, 42494, 42556, 42571, 42605, 42614, 42627, 42631, 42640, 42644, 42646, 42649, 42651, 42653, 42657, 42682, 42699, 42721, 42723, 42726, 42728, 42743, 42750, 42755, 42760, 42762, 42765, 42766, 42768, 42769, 42773, 42775, 42777, 42780, 42781, 42783, 42784, 42785, 42788, 42789, 42792, 42793, 42794, 42796, 42797, 42802, 42803, 42806, 42808, 42810, 42811, 42812, 42813, 42814, 42815, 42816, 42819, 42820, 42821, 42822, 42823, 42824, 42825, 42826, 42827, 42828, 42829, 42830, 42831, 42832, 42834, 42835, 42836, 42837, 42838, 42840, 42841, 42842, 42844, 42845, 42846, 42847, 42848, 42849, 42850, 42851, 42852, 42853, 42862, 42868, 42870, 42877, 42880, 42884, 42886, 42891, 42896, 42898, 42899, 42901, 42904, 42906, 42911, 42916, 42918, 42920, 42922, 42924, 42928, 42930, 42932, 42934, 42936, 42940, 42942, 42944, 42946, 42948, 42952, 42954, 42956, 42958, 42960, 42963, 42965, 42968, 42970, 42977, 42979, 42982, 42986, 42988, 42997, 42999, 43001, 43006, 43069, 43072, 43074, 43077, 43089, 43095, 43101, 43106, 43110, 43118, 43120, 43138, 43141, 43148, 43158, 43167, 43172, 43176, 43180, 43183, 43186, 43191, 43195, 43200, 43204, 43208, 43217, 43222, 43229, 43232, 43234, 43237, 43244, 43247, 43249, 43253, 43255, 43257, 43260, 43263, 43265, 43268, 43274, 43277, 43280, 43283, 43288, 43290, 43295, 43298, 43303, 43305, 43308, 43310, 43315, 43317, 43318, 43321, 43322, 43323, 43325, 43327, 43329, 43330, 43333, 43335, 43336, 43337, 43344, 43346, 43347, 43350, 43352, 43353, 43355, 43357, 43358, 43360, 43363, 43364, 43366, 43368, 43371, 43373, 43375, 43377, 43379, 43382, 43383, 43384, 43386, 43387, 43388, 43390, 43391, 43392, 43394, 43396, 43397, 43398, 43399, 43400, 43401, 43403, 43404, 43405, 43406, 43409, 43412, 43414, 43417, 43419, 43421, 43424, 43425, 43426, 43427, 43428, 43429, 43430, 43431, 43432, 43434, 43439, 43441, 43457, 43462, 43465, 43468, 43470, 43473, 43478, 43482, 43490, 43492, 43500, 43502, 43506, 43510, 43512, 43514, 43517, 43519, 43521, 43523, 43525, 43527, 43529, 43531, 43533, 43535, 43539, 43541, 43543, 43545, 43547, 43551, 43553, 43555, 43557, 43559, 43561, 43566, 43568, 43572, 43577, 43582, 43585, 43587, 43590, 43592, 43594, 43596, 43599, 43601, 43604, 43606, 43608, 43610, 43613, 43615, 43618, 43620, 43622, 43624, 43627, 43629, 43631, 43633, 43636, 43638, 43641, 43644, 43647, 43649, 43651, 43653, 43656, 43662, 43664, 43666, 43678, 43689, 43696, 43702, 43707, 43712, 43715, 43722, 43729, 43732, 43740, 43765, 43776, 43781, 43798, 43803, 43806, 43809, 43815, 43818, 43824, 43829, 43832, 43836, 43841, 43844, 43854, 43858, 43863, 43866, 43868, 43873, 43876, 43878, 43881, 43883, 43886, 43888, 43891, 43893, 43896, 43900, 43902, 43905, 43906, 43908, 43909, 43910, 43912, 43914, 43916, 43919, 43920, 43923, 43925, 43929, 43932, 43934, 43935, 43936, 43938, 43940, 43942, 43945, 43946, 43948, 43951, 43953, 43954, 43956, 43957, 43959, 43960, 43963, 43964, 43965, 43968, 43969, 43970, 43971, 43972, 43974, 43975, 43977, 43979, 43981, 43983, 43984, 43985, 43986, 43988, 43991, 43992, 43993, 43997, 43999, 44004, 44005, 44006, 44007, 44008, 44009, 44013, 44014, 44016, 44021, 44027, 44029, 44031, 44037, 44041, 44046, 44048, 44050, 44051, 44058, 44059, 44076, 44078, 44080, 44081, 44083, 44085, 44087, 44089, 44091, 44093, 44095, 44097, 44099, 44101, 44103, 44105, 44111, 44115, 44117, 44119, 44121, 44123, 44127, 44129, 44131, 44145, 44153, 44194, 44206, 44239, 44247, 44263, 44265, 44270, 44275, 44277, 44284, 44290, 44293, 44296, 44303, 44332, 44341, 44345, 44358, 44374, 44377, 44379, 44389, 44392, 44394, 44402, 44407, 44409, 44414, 44417, 44427, 44432, 44434, 44437, 44442, 44444, 44447, 44449, 44452, 44454, 44457, 44462, 44464, 44467, 44476, 44478, 44480, 44481, 44483, 44484, 44486, 44487, 44496, 44498, 44501, 44503, 44504, 44506, 44510, 44512, 44514, 44515, 44517, 44519, 44521, 44523, 44525, 44526, 44527, 44529, 44530, 44532, 44533, 44535, 44536, 44538, 44539, 44544, 44546, 44547, 44548, 44549, 44550, 44555, 44556, 44557, 44558, 44559, 44560, 44561, 44562, 44563, 44564, 44565, 44566, 44567, 44568, 44570, 44573, 44574, 44575, 44576, 44578, 44579, 44580, 44581, 44582, 44583, 44584, 44586, 44587, 44661, 44681, 44683, 44689, 44693, 44697, 44843, 44846, 44848, 44984, 44990, 44996, 45002, 45008, 45040, 45044, 45045, 45048, 45050, 45051, 45053, 45055, 45057, 45059, 45062, 45063, 45064, 45065, 45068, 45071, 45074, 45077, 45078, 45079, 45080, 45081, 45082, 45083, 45084, 45085, 45086, 45088, 45089, 45090, 45092, 45093, 45094, 45095, 45096, 45097, 45098, 45099, 45101, 45104, 45105, 45106, 45107, 45108, 45109, 45110, 45111, 45112, 45113, 45114, 45115, 45116, 45117, 45120, 45121, 45122, 45123, 45124, 45125, 45126, 45127, 45128, 45129, 45130, 45131, 45132, 45133, 45134, 45597, 45600, 45602, 45604, 45605, 45607, 45608, 45610, 45611, 45613, 45614, 45616, 45617, 45618, 45619, 45621, 45622, 45624, 45625, 45627, 45629, 45630, 45631, 45632, 45634, 45641, 45643, 45644, 45649, 45664, 45665, 45666, 45667, 45668, 45670, 45671, 45672, 45676, 45677, 45685, 45689, 46104, 46110, 46116, 46122, 46128, 46134, 46138, 46144, 46149, 46155, 46161, 46167, 46172, 46177, 46179, 46180, 46181, 46182, 46183, 46184, 46185, 46187, 46188, 46190, 46191, 46193, 46196, 46197, 46199, 46200, 46201, 46202, 46204, 46205, 46206, 46207, 46208, 46209, 46210, 46211, 46212, 46214, 46215, 46216, 46217, 46218, 46219, 46220, 46221, 46222, 46223, 46225, 46226, 46227, 46228, 46229, 46230, 46231, 46232, 46233, 46234, 46235, 46236, 46237, 46238, 46239, 46240, 46241, 46242, 46244, 46245, 46246, 46247, 46248, 46249, 46250, 46251, 46252, 46253, 46254, 46255, 46256, 46257, 46258, 46259, 46736, 46739, 46740, 46744, 46747, 46750, 46752, 46753, 46754, 46755, 46756, 46757, 46759, 46762, 46763, 46764, 46765, 46767, 46768, 46769, 46770, 46772, 46773, 46775, 46776, 46778, 46782, 46785, 46786, 46787, 46788, 46791, 46792, 46796, 46798, 46800, 46801, 46802, 46804, 46805, 46807, 46810, 46811, 46812, 46813, 46814, 46816, 46817, 46819, 46820, 46821, 46822, 46823, 46824, 46856, 47001, 47005, 47013, 47025, 47037, 47049, 47061, 47076, 47229, 47259, 47307, 47313, 47316, 47321, 47323, 47329, 47331, 47335, 47338, 47339, 47341, 47346, 47350, 47352, 47353, 47356, 47360, 47361, 47362, 47363, 47366, 47368, 47370, 47374, 47376, 47378, 47380, 47382, 47383, 47384, 47385, 47386, 47387, 47388, 47389, 47390, 47392, 47393, 47394, 47395, 47396, 47397, 47398, 47399, 47405, 47407, 47409, 47411, 47413, 47414, 47415, 47419, 47423, 47424, 47912, 47914, 47915, 47917, 47918, 47922, 47927, 47929, 47932, 47934, 47937, 47938, 47939, 47940, 47942, 47943, 47944, 47945, 47950, 47951, 47952, 47953, 47955, 47957, 47960, 47961, 47962, 47963, 47965, 47967, 47968, 47969, 47970, 47972, 47974, 47976, 47977, 47979, 47980, 47982, 47985, 47986, 47987, 47988, 47991, 48591, 48622, 52137, 52139) 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: La Serva Padrona

Song: As17710713

Performances

Mainpiece Title: The Magnet

Song: Reinhold, Miss Esser, Mrs Thompson; Musical Imitations-Bannister

Performances

Mainpiece Title: La Serva Padrona

Song: Miss Thomas, Miss Harper, Miss Catley, first time

Performances

Mainpiece Title: La Serva Padrona

Song: As17710730

Performances

Mainpiece Title: The Coquet

Entertainment: Singing-Miss Catley; Musical Imitations-Bannister; With Horns and with Hounds-Mrs Thompson

Performances

Mainpiece Title: The Coquet

Entertainment: As17710808

Performances

Mainpiece Title: The Magnet

Song: Miss Harper, Miss Esser, Miss Catley

Performances

Mainpiece Title: The Magnet

Entertainment: Between parts of Entertainment: In love should there meet a fond Pair, (for that night only) Water parted from the Sea, after the manner of the original, also The Soldier Tired of War's Alarms, also The Wanton God who Pierces Hearts from Comus-Miss Catley; Singing-Reinhold, Miss Harper

Performances

Mainpiece Title: The Magnet

Entertainment: Singing-Miss Harper, Miss Esser, Miss Catley

Performances

Mainpiece Title: The Coquet

Entertainment: Medley Cantata-Reinhold; Musical Imitations-Bannister; Singing With Horns and With Hounds, The Soldier Tir'd the favourite song in Comus,-Miss Catley; Sweet Echo-Miss Catley the echo by, a young Gentleman

Performances

Mainpiece Title: The Magnet

Entertainment: Singing-Miss Harper, Miss Esser, Miss Catley

Performances

Mainpiece Title: The Magnet

Entertainment: The Favourite Scots Air of last season in Love in a Village-; Soldier Tir'd of War's Alarms, The Wanton God who Pierces Hearts, Sweet Echo from Comus,-Miss Catley; Musical Imitations-Bannister

Performances

Mainpiece Title: The Magnet

Entertainment: Favourite Scots Air from Love in a Village, The Soldier Tir'd with War's Alarms, The Wanton God Who Pierces Hearts-Miss Catley; Musical Imitations-Bannister

Performances

Mainpiece Title: The Magnet

Entertainment: As17710829

Performances

Mainpiece Title: La Serva Padrona

Entertainment: Vocal parts-Miss Harper, Miss Catley, Miss Esser; who will accompany her songs and play a Solo on the violin-Miss Esser; Musical Imitations-Bannister; Solo on Violin (Giardini)-a Pupil of Mr Reeves, only ten years old, his first appearance in public

Performances

Mainpiece Title: The Magnet

Entertainment: Singing-Miss Harper, Miss Esser; With Horn and Hounds, The Soldier Tir'd-Miss Catley; Musical Imitations-Bannister; Concerto on Organ-Hook; Solo on Violin-Reeves

Performances

Mainpiece Title: The Magnet

Entertainment: As17710905

Performances

Mainpiece Title: The Magnet

Entertainment: Musical Imitations-Bannister; Concerto on Organ-Hook; Solo on Violin-Reeves

Performances

Mainpiece Title: The Magnet

Entertainment: Singing, Soldier Tir'd, the Wanton God-Miss Catley; With Horns and with Hounds-Miss Thompson; Concerto on Organ-Hook; Solo on Violin-Reeves

Performances

Mainpiece Title: La Serva Padrona

Song: Several favourite songs-Mrs Forbes; Musical Imitations-Bannister; Vocal parts-Culver, Mrs Cartwright

Performances

Mainpiece Title: La Serva Padrona

Song: Several songs-Mrs Forbes; Musical Imitations-Bannister; An Odecomposed by Arnold will be sung in the manner of an Oratorio-Reinhold, Bannister, Mrs Forbes, Mrs Cartwright, Mrs Thompson, with a number of the best Chorus Singers

Performances

Mainpiece Title: Il Dilettante

Music: Between the Acts: Concerto on Piano Forte-Hook (by Particular Desire); The Ode-Hook for the opening of the New Exhibition Room of the Royal Incorporated Artists of Great Britain. Chorusses will be supported by a number of Capital singers and young gentlemen of St Paul's Choir; The principal vocal parts-Reinhold, Bannister, Mrs Cartwright, Mrs Thompson

Performances

Mainpiece Title: The Magnet

Entertainment: Odeby Arnold for Prince's Birthday,-Bannister, Culver, Mrs Forbes, Mrs Cartwright, Mrs Thompson

Performances

Mainpiece Title: The Magnet

Performances

Mainpiece Title: The Magnet