SELECT * FROM london_stages WHERE eventid IN (2530, 3041, 5082, 5097, 5740, 5746, 13287, 13381, 13410, 26290, 26348, 26514, 26536, 26552, 26585, 26587, 26872, 26875, 26877, 26879, 26886, 26889, 26893, 26897, 27145, 27247, 27290, 27349, 27351, 27354, 27365, 27398, 27446, 27473, 27521, 27553, 27571, 27573, 27609, 27615, 27703, 32315, 32325, 32339, 32370, 32403, 32454, 32490, 32498, 32502, 32504, 32514, 32528, 32530, 32533, 32536, 32539, 32542, 32544, 32568, 32570, 32642, 32669, 32674, 32676, 32713, 32720, 32748, 35342, 35347, 35364, 35380, 35387, 35440, 35443, 35446, 35454, 35484, 35515, 36004, 36012, 36068, 36075, 36100, 36106, 36179, 36219, 36223, 36232, 36234, 36237, 36239, 36241, 36243, 36251, 36253, 36255, 36257, 36262, 36264, 36266, 36269, 36273, 36275, 36279, 36282, 36284, 36289, 36291, 36296, 36301, 36305, 36308, 36310, 36313, 36315, 36317, 36319, 36321, 36324, 36326, 36329, 36331, 36336, 36338, 36343, 36345, 36350, 36352, 36355, 36357, 36362, 36367, 36370, 36372, 36381, 36409, 36414, 36470, 36473, 36482, 36488, 36513, 36540, 36543, 36546, 36572, 36584, 36598, 36605, 36613, 36618, 36627, 36634, 36645, 36647, 36663, 36667, 36671, 36675, 36678, 36680, 36682, 36684, 36688, 36690, 36692, 36698, 36700, 36706, 36708, 36712, 36714, 36719, 36722, 36728, 36731, 36733, 36747, 36750, 36756, 36759, 36761, 36770, 36778, 36782, 36787, 36793, 36795, 36798, 36800, 36802, 36804, 36806, 36808, 36811, 36813, 36816, 36818, 36820, 36822, 36825, 36827, 36830, 36832, 36844, 36858, 36871, 36886, 36888, 36895, 36909, 36963, 36985, 36996, 37002, 37008, 37018, 37021, 37028, 37033, 37039, 37041, 37046, 37049, 37055, 37060, 37066, 37068, 37076, 37085, 37091, 37094, 37096, 37098, 37101, 37107, 37113, 37119, 37216, 37235, 37253, 37260, 37262, 37286, 37288, 37290, 37299, 37305, 37312, 37319, 37326, 37329, 37335, 37343, 37349, 37354, 37366, 37371, 37373, 37378, 37380, 37382, 37384, 37388, 37393, 37398, 37402, 37407, 37414, 37416, 37419, 37424, 37426, 37439, 37457, 37460, 37462, 37467, 37472, 37477, 37479, 37510, 37517, 37524, 37545, 37548, 37550, 37560, 37566, 37570, 37572, 37577, 37579, 37582, 37589, 37592, 37594, 37597, 37599, 37602, 37604, 37608, 37611, 37626, 37635, 37637, 37646, 37656, 37662, 37665, 37673, 37675, 37750, 37778, 37787, 37793, 37795, 37797, 37803, 37821, 37825, 37827, 37829, 37831, 37833, 37835, 37852, 37860, 37870, 37874, 37887, 37893, 37902, 37905, 37923, 37941, 37943, 37949, 37954, 37962, 37985, 37989, 38016, 38018, 38042, 38050, 38070, 38091, 38105, 38112, 38118, 38123, 38128, 38133, 38136, 38153, 38156, 38158, 38165, 38167, 38172, 38183, 38188, 38192, 38212, 38218, 38223, 38227, 38229, 38235, 38246, 38250, 38253, 38254, 38256, 38259, 38260, 38261, 38263, 38265, 38267, 38269, 38270, 38271, 38277, 38278, 38279, 38280, 38283, 38286, 38288, 38289, 38290, 38292, 38297, 38299, 38300, 38302, 38303, 38304, 38306, 38307, 38308, 38309, 38311, 38315, 38323, 38327, 38330, 38334, 38336, 38378, 38383, 38387, 38390, 38394, 38396, 38399, 38420, 38429, 38450, 38500, 38538, 38543, 38578, 38596, 38627, 38634, 38642, 38663, 38678, 38709, 38731, 38739, 38745, 38753, 38771, 38778, 38784, 38789, 38790, 38794, 38796, 38805, 38810, 38813, 38814, 38818, 38819, 38820, 38821, 38822, 38823, 38824, 38825, 38827, 38828, 38830, 38832, 38833, 38836, 38848, 38849, 38854, 38858, 38948, 38951, 38958, 39171, 39202, 39236, 39296, 39308, 39322, 39338, 39343, 39361, 39362, 39365, 39368, 39374, 39377, 39385, 39392, 39395, 39422, 39424, 39578, 39583, 40196, 40198, 40201, 40204, 40207, 40211, 40213, 40216, 40218, 40223, 40225, 40227, 40230, 40232, 40275, 40284, 40701, 41146, 41155, 41195, 41218, 41235, 41274, 41280, 41282, 41284, 41286, 41289, 41303, 41305, 41308, 41310, 41314, 41317, 41319, 41324, 41328, 41351, 41363, 41368, 41378, 41384, 41387, 41389, 41393, 41396, 41398, 41403, 41440, 41446, 41465, 41470, 41488, 41497, 41502, 41517, 41690, 41696, 41708, 41728, 41794, 41827, 42080, 42140, 42141, 42143, 42146, 42148, 42151, 42153, 44470, 46517, 46527, 46555, 46569, 46583, 47112, 47122, 47126, 47137, 47142, 47154, 47159, 47171, 47177, 47190, 47196, 50684, 51392, 51395, 51399, 51402, 51405, 51407, 51411, 51413, 51418, 51420, 51424, 51431, 51435, 51441, 51442, 51444, 51446, 51448, 51449, 51450, 51451, 51452, 51453, 51454, 51457, 51459, 51461, 51462, 51464, 51465, 51468, 51472, 51478, 51950, 51971, 51982, 51983, 51985, 51992, 51994, 51996, 51997, 51999, 52000, 52001, 52002, 52005, 52007, 52008, 52012, 52016, 52017, 52021, 52022, 52023, 52025, 52026, 52028, 52030, 52032, 52034, 52040, 52041, 52043, 52044, 52046, 52048, 52049, 52050, 52051, 52053, 52200, 52202, 52229, 52231, 52234, 52236, 52239, 52248, 52250, 52253) 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 Fair Circassian

Afterpiece Title: The Apprentice

Music: In Act III of mainpiece an Epitbalamium [not listed in playbill, but see17811129]

Performances

Mainpiece Title: The Carnival Of Venice

Afterpiece Title: The Apprentice

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Apprentice

Dance: In Act III of mainpiece a Hornpipe, as17820314athi

Performances

Mainpiece Title: The Fair American

Afterpiece Title: The Apprentice

Performances

Mainpiece Title: The Fair American

Afterpiece Title: Robinson Crusoe

Performances

Mainpiece Title: The Fair American

Afterpiece Title: The Divorce

Cast
Role: Sambo Actor: Griffiths

Dance: As17820302athi

Performances

Mainpiece Title: The Fair American

Afterpiece Title: The Lyar

Performances

Mainpiece Title: Fair American

Afterpiece Title: The Critic

Performances

Mainpiece Title: The Fair American

Afterpiece Title: Catherine and Petruchio

Cast
Role: Pedro Actor: Griffiths

Dance: As17820302athi

Performances

Mainpiece Title: The Fair American

Afterpiece Title: The Critic

Performances

Mainpiece Title: She Stoops To Conquer; Or, The Mistakes Of A Night

Cast
Role: Sir Charles Marlow Actor: Griffith

Afterpiece Title: The Lying Valet

Cast
Role: Justice Guttle Actor: Griffith

Song: End of Act I of mainpiece Nobody by Villars; End of mainpiece Freedom and his native Land by Price

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

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: A Grand Selection 0 Of Sacred Music, From The Works Of Handel

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Cast
Role: Honour and Arms Actor: Griffith

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The Messiah; Grandselection 0

Performances

Mainpiece Title: L'allegro Ed Il Penseroso; Grand Selection 0

Afterpiece Title: L'Allegro ed il Penseroso 1

Cast
Role: repeated] Actor: Griffith

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: PART III

Performances

Mainpiece Title: A Second Grand Selection 0 Of Sacred Music, From The Works Of Handel

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Alexander's Feast; Grand Selection 0

Afterpiece Title: Alexander's Feast 1

Afterpiece Title: Alexander's Feast 2

Afterpiece Title: PART III

Performances

Mainpiece Title: L'allegro Ed Il Penseroso 0; Grand Selection 0

Afterpiece Title: Allegro ed il Penseroso 1 PART I

Cast
Role: repeated] Actor: Griffith

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: A Grand Miscellaneous Act

Cast
Role: repeated] Actor: Griffith

Music: End II: concerto on the violin-Weichsel

Performances

Mainpiece Title: A Grand Selection 0of Sacred Music From The Works Of Handel

Afterpiece Title: Grand Selection 1

Cast
Role: Honour and Arms Actor: Griffith

Afterpiece Title: Grand Selection 2

Cast
Role: Honour and Arms Actor: Griffith

Afterpiece Title: Grand Selection 3

Cast
Role: Honour and Arms Actor: Griffith

Music: As17910330

Performances

Mainpiece Title: L'allegro Ed Il Penseroso 0; Grand Selection 0

Afterpiece Title: L'Allegro ed il Penseroso 1

Cast
Role: repeated] Actor: Griffith

Afterpiece Title: L'Allegro ed il Penseroso 2

Cast
Role: repeated] Actor: Griffith

Afterpiece Title: A Grand Miscellaneous Act

Music: As17910330

Performances

Mainpiece Title: The Messiah; Grand Selection 0