SELECT * FROM london_stages WHERE eventid IN (22116, 24427, 24433, 24436, 24438, 24441, 24444, 24447, 24448, 24451, 24454, 24457, 24460, 24463, 24466, 24477, 24503, 24536, 24580, 24641, 24692, 27112, 27114, 27608, 27677, 27680, 27732, 27913, 27932, 27945, 27981, 28016, 28035, 28150, 28152, 28154, 28160, 28162, 28168, 28178, 28215, 28229, 28233, 28241, 28255, 28278, 28329, 28338, 28403, 28430, 28440, 28443, 28453, 28486, 28511, 28531, 28616, 28635, 28638, 28733, 28779, 28898, 28901, 28902, 28905, 28908, 28910, 28914, 28915, 28918, 28919, 28922, 28926, 28930, 28942, 28964, 28970, 29033, 29036, 29046, 29085, 29165, 29167, 29172, 29179, 29203, 29205, 29213, 29217, 29280, 29312, 29329, 29334, 29340, 29346, 29359, 29442, 29488, 29503, 29538, 29542, 29549, 29574, 29598, 29628, 29677, 29722, 29747, 29766, 29823, 29826, 29835, 29838, 29840, 29844, 29848, 29851, 29853, 29877, 29881, 29886, 29888, 29890, 29892, 29894, 29899, 29901, 29903, 29907, 29909, 29912, 29914, 29923, 29927, 29929, 29960, 29981, 30006, 30009, 30028, 30055, 30057, 30081, 30114, 30137, 30145, 30151, 30307, 30309, 30311, 30315, 30321, 30323, 30329, 30333, 30335, 30337, 30339, 30385, 30388, 30390, 30395, 30408, 30410, 30413, 30415, 30420, 30429, 30432, 30450, 30452, 30475, 30479, 30559, 30566, 30575, 30592, 30603, 30606, 30608, 30622, 30627, 30641, 30648, 30653, 30684, 30686, 30690, 30692, 30695, 30699, 30785, 30787, 30793, 30801, 30808, 30814, 30852, 30865, 30867, 30870, 30874, 30876, 30878, 30886, 30888, 30893, 30898, 30900, 30916, 30983, 31009, 31040, 31057, 31074, 31076, 31104, 31112, 31114, 31120, 31123, 31126, 31131, 31133, 31139, 31194, 31197, 31206, 31208, 31214, 31229, 31253, 31255, 31292, 31339, 31340, 31342, 31354, 31358, 31376, 31389, 31424, 31437, 31439, 31441, 31443, 31459, 31482, 31486, 31510, 31540, 31602, 31626, 31648, 31651, 31677, 31684, 31694, 31703, 31708, 31713, 31723, 31728, 31736, 31742, 31749, 31758, 31763, 31877, 31881, 31885, 31887, 31925, 31932, 31985, 32104, 32109, 32111, 32116, 32117, 32119, 32124, 32128, 32134, 32140, 32146, 32168, 32177, 32208, 32213, 32235, 32252, 32258, 32264, 32319, 32321, 32325, 32329, 32339, 32342, 32346, 32348, 32366, 32372, 32378, 32386, 32392, 32397, 32401, 32409, 32416, 32523, 32526, 32546, 32574, 32593, 32666, 32671, 32676, 32683, 32698, 32722, 32724, 32748, 32807, 32813, 32815, 32817, 32822, 32838, 32866, 32951, 32956, 33029, 33047, 33106, 33110, 33136, 33169, 33172, 33267, 33271, 33362, 33364, 33369, 33372, 33374, 33381, 33386, 33390, 33441, 33443, 33446, 33448, 33451, 33453, 33455, 33457, 33460, 33462, 33465, 33467, 33471, 33474, 33476, 33479, 33485, 33489, 33491, 33494, 33496, 33498, 33501, 33510, 33517, 33524, 33526, 33529, 33531, 33538, 33563, 33572, 33589, 33592, 33626, 33664, 33681, 33683, 33700, 33804, 33806, 33841, 33889, 33947, 33969, 34010, 34050, 34054, 34058, 34063, 34069, 34072, 34078, 34146, 34173, 34182, 34197, 34202, 34207, 34237, 34251, 34258, 34342, 34350, 34580, 34746, 34770, 34899, 34901, 34903, 34905, 34909, 34919, 34923, 34925, 34927, 34929, 34931, 34933, 34935, 34937, 34939, 34941, 34943, 34945, 34947, 34949, 34951, 34953, 34955, 34957, 34959, 34961, 34963, 34966, 34968, 34970, 34972, 34975, 34980, 34984, 34986, 34989, 34991, 34996, 34998, 35000, 35003, 35005, 35010, 35012, 35014, 35017, 35019, 35024, 35026, 35031, 35033, 35038, 35040, 35042, 35045, 35048, 35053, 35057, 35060, 35062, 35064, 35066, 35070, 35074, 35076, 35078, 35088, 35092, 35094, 35099, 35104, 35108, 35111, 35113, 35118, 35125, 35127, 35129, 35135, 35138, 35143, 35149, 35160, 35164, 35169, 35174, 35177, 35179, 35182, 35184, 35187, 35207, 35210, 35218, 35223, 35227, 35240, 35250, 35264, 35277, 35286, 35289, 35302, 35305, 35315, 35332, 35354, 35365, 35372, 35382, 35500, 35508, 35511, 35513, 35516, 35518, 35520, 35522, 35524, 35526, 35543, 35549, 35551, 35555, 35558, 35566, 35573, 35577, 35581, 35585, 35587, 35595, 35600, 35603, 35629, 35635, 35642, 35647, 35650, 35653, 35656, 35662, 35665, 35669, 35672, 35674, 35678, 35681, 35683, 35686, 35688, 35696, 35702, 35707, 35718, 35756, 35788, 35802, 35813, 35818, 35823, 35826, 35834, 35865, 35874, 35885, 35907, 35949, 35983, 36127, 36434, 36445, 36479, 36488, 36511, 36521, 36573, 36645, 36647, 36649, 36655, 36667, 36669, 36673, 36682, 36700, 36706, 36708, 36710, 36714, 36719, 36733, 36747, 36756, 36773, 36778, 36802, 36858, 36906, 36914, 36963, 37021, 37025, 37041, 37044, 37055, 37066, 37071, 37076, 37091, 37101, 37113, 37233, 37235, 37237, 37239, 37243, 37245, 37247, 37260, 37262, 37272, 37288, 37299, 37333, 37378, 37380, 37382, 37384, 37388, 37393, 37398, 37402, 37407, 37414, 37419, 37424, 37439, 37457, 37460, 37467, 37472, 37479, 37484, 37494, 37499, 37509, 37513, 37517, 37523, 37527, 37539, 37544, 37545, 37554, 37559, 37565, 37577, 37589, 37621, 37646, 37662, 38592, 38602, 38607, 38623, 38633, 38648, 38672, 39116, 39126, 40300, 40314, 40333, 40343, 40348, 46517, 46527, 46541, 46555, 46569, 46583, 47702, 47732) 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 Beggar's Opera

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: Theodosius

Afterpiece Title: The Conjuror

Dance: V: The Mountaineers, as17730930

Performances

Mainpiece Title: A Christmas Tale

Cast
Role: Nigromant Actor: Champness

Afterpiece Title: The Note of Hand

Performances

Mainpiece Title: The Jealous Wife

Afterpiece Title: Harlequin's Invasion

Dance: III: A Hornpipe-Mrs Marklew

Performances

Mainpiece Title: Judas Maccabaeus

Music: First Violin-Lamotte; after I: Concerto on German Flute-Florio; Part II: Violin Concerto-Lamotte

Performances

Mainpiece Title: Omnipotence; Judas Maccabaeus

Music: End Part First: A New Concerto on 3 Chromatic French Horns-(being their first performance); After Part Second: a Concerto on the Violin-Lamotte

Performances

Mainpiece Title: The Messiah; Judas Maccabaeus

Music: First Violin, as17760223; End Part I: Concerto on 3 Chromatic French Horns, as17760223; End Part II: Violin Concerto-Lamotte

Performances

Mainpiece Title: Samson; Judas Maccabaeus

Music: End I: Concerto on 3 Chromatic French Horns, as17760228; End II: Concerto on Violin-Lamotte

Performances

Mainpiece Title: The Messiah

Music: Between parts Oratorio: a Concerto on German Flute, as17760223; Violin Concerto, as17760223

Performances

Mainpiece Title: The Ascension; Judas Maccabaeus

Music: Between the parts of the Oratorio: A Concerto on the Pedal Harp-Jones; concerto on the Violin-Lamotte[, as17760315

Performances

Mainpiece Title: Alexander's Feast

Afterpiece Title: The Coronation Anthems

Music: End Part I: concerto on the organ-Stanley; End Part II: concerto on the violin-Linley Jun

Performances

Mainpiece Title: The Messiah; Alexander's Feast

Music: As17770214

Performances

Mainpiece Title: The Messiah

Song: End Part I: an Italian duet see17790310by Vinci Tu vuoi ch'io vivi o cara-Mrs Barthelemon, Miss Cecilia Barthelemon

Music: End Part II: concerto on the violin-Barthelemon

Performances

Mainpiece Title: The Messiah

Song: End Part I: duet by Vinci, Tu vuoi ch'io vivi o cara, as17790303

Performances

Mainpiece Title: Acis And Galatea; Messiah

Afterpiece Title: Victory

Music: End I Oratorio: concerto on the trumpet-Serjeant; End Oratorio: concerto on the violin, as17790303

Performances

Mainpiece Title: Omnipotence; Messiah

Music: End Part I: concerto on the hautboy-Sharp; End Part II: concerto on the violin, as17790303

Performances

Mainpiece Title: The Messiah

Music: End of Part I: concerto on the trumpet, as17790319End of Part II: concerto on the violin, as17790303

Performances

Mainpiece Title: The Messiah, Preceded By god Save The King(coronation Anthems)

Music: End II: a concerto on the violin-Mme Gautherot (from Paris)

Performances

Mainpiece Title: A Grand Selection [of Sacred Music 0; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End II: concerto on the Piano Forte-Clementi

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17900224

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17900219

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End II: As17900219; End I: Miserere Mei Deus-, composed by Sg Gregorio Allegri, in the Year 1650, from an authentic Copy brought from Italy by Greatorex. A Translation of this Work (the 51st Psalm in English) will be printed in the Books of the Night

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17900219

Performances

Mainpiece Title: L'allegro Ed Il Pensieroso 0

Afterpiece Title: L'Alegro ed il Pensieroso 1

Afterpiece Title: L'Allegro ed il Pensieroso

Afterpiece Title: Grand Miscellaneous Act