SELECT * FROM london_stages WHERE eventid IN (823, 869, 898, 1174, 1278, 1328, 1344, 1356, 1408, 1539, 1794, 2005, 2146, 2228, 2290, 2367, 3001, 3430, 3485, 3515, 3525, 3556, 3559, 3581, 3603, 3650, 3851, 3877, 3944, 3982, 4007, 4063, 4089, 4143, 4240, 4634, 4805, 4976, 5301, 5484, 5511, 5748, 6971, 7069, 7370, 7526, 7709, 7804, 7875, 7891, 7898, 8077, 8159, 8326, 8343, 8393, 8395, 8397, 8399, 8581, 8609, 8890, 8899, 8924, 8973, 9093, 9192, 9232, 9725, 9778, 9919, 9964, 9965, 10334, 10917, 11106, 11302, 12635, 12714, 13278, 13285, 13293, 13300, 13303, 13323, 13336, 13340, 13348, 13496, 13499, 13500, 13502, 13523, 13555, 13636, 13643, 13720, 13829, 13858, 13868, 13872, 14209, 14233, 14399, 14403, 14502, 14640, 14644, 14813, 14846, 14970, 15045, 15047, 15071, 15367, 15537, 15754, 15785, 15870, 15932, 15994, 16046, 16091, 16097, 16098, 16374, 16428, 16468, 16492, 16578, 16599, 16625, 16706, 16849, 16922, 17237, 17254, 17408, 17533, 17622, 17626, 17635, 17637, 17641, 17644, 17648, 17652, 17656, 17659, 17662, 17665, 17669, 17672, 17675, 17678, 17681, 17684, 17688, 17691, 17695, 17699, 17701, 17704, 17708, 17711, 17715, 17719, 17722, 17725, 17729, 17732, 17736, 17783, 17786, 17805, 17809, 17813, 17816, 17820, 17823, 17826, 17829, 17832, 17835, 17840, 17880, 17885, 17927, 17999, 18190, 18193, 18196, 18224, 18229, 18233, 18237, 18242, 18246, 18251, 18254, 18257, 18262, 18267, 18271, 18275, 18278, 18281, 18283, 18286, 18289, 18292, 18295, 18300, 18303, 18307, 18310, 18314, 18318, 18377, 18380, 18383, 18432, 18437, 18444, 18447, 18450, 18687, 18872, 18975, 18990, 19036, 19078, 19106, 19107, 19109, 19111, 19115, 19126, 19131, 19134, 19136, 19145, 19227, 19313, 19341, 19368, 19506, 19584, 19757, 20040, 20157, 20278, 20429, 20433, 20488, 20495, 20499, 20502, 20583, 20751, 21230, 21250, 21385, 21487, 21579, 21625, 21626, 21628, 21669, 21691, 21956, 22269, 22329, 22535, 22765, 22797, 23053, 23295, 23391, 23394, 23403, 23424, 23496, 23499, 23502, 23513, 23515, 23564, 23593, 23597, 23600, 23603, 23772, 24160, 24208, 24215, 24352, 24445, 24531, 24633, 24675, 24722, 24764, 24771, 24775, 24779, 24789, 24796, 24799, 24812, 24813, 24921, 25058, 25060, 25069, 25142, 25153, 25185, 25205, 25251, 25276, 25417, 25419, 25421, 25423, 25519, 25569, 25590, 25619, 25654, 25992, 26050, 26524, 26588, 26946, 27510, 27544, 27549, 27597, 27686, 27725, 27771, 27837, 27996, 28059, 28082, 28149, 28230, 28340, 28343, 28345, 28346, 28348, 28350, 28357, 28363, 28398, 28502, 28504, 28509, 28526, 28639, 28720, 28821, 28980, 29060, 29170, 29192, 29263, 29335, 29372, 29379, 29386, 29388, 29390, 29405, 29419, 29484, 29530, 29831, 29900, 29963, 30060, 30098, 30138, 30306, 30370, 30398, 30449, 30576, 30792, 31223, 31232, 31336, 31337, 31346, 31710, 31832, 31897, 31909, 32046, 32322, 32344, 32743, 32907, 32974, 33237, 33238, 33251, 34321, 34322, 34324, 34325, 34326, 34937, 35067, 35085, 35179, 35647, 35650, 35653, 35656, 35662, 35665, 35669, 35672, 35674, 35678, 35681, 35686, 35688, 35696, 35702, 35707, 35718, 35788, 35802, 35813, 35856, 35863, 35865, 36471, 36710, 36714, 36756, 37044, 37308, 37534, 37578, 37624, 37638, 38102, 38121, 38138, 38148, 38177, 38190, 38197, 38217, 38242, 38744, 38856, 38885, 38918, 38937, 38946, 38976, 39093, 39107, 39123, 39213, 39245, 39257, 39265, 39291, 39398, 39400, 39403, 39405, 39410, 39413, 39416, 39419, 39439, 39472, 39476, 39477, 39479, 39481, 39485, 39493, 39494, 39502, 39511, 39525, 39532, 39546, 39572, 39607, 39648, 39651, 39693, 39699, 39739, 39749, 39769, 39773, 39818, 39852, 39875, 39902, 40021, 40066, 40172, 40174, 40225, 40231, 40267, 40329, 40393, 40445, 40598, 40649, 40699, 40703, 40749, 40803, 40993, 40996, 41001, 41008, 41102, 41103, 41105, 41106, 41107, 41108, 41109, 41110, 41111, 41112, 41113, 41129, 41130, 41150, 41152, 41154, 41156, 41158, 41160, 41162, 41166, 41176, 41184, 41187, 41241, 41273, 41278, 41474, 41503, 41529, 41564, 41569, 41579, 41580, 41585, 41586, 41590, 41594, 41598, 41609, 41612, 41617, 41620, 41624, 41632, 41638, 41640, 41644, 41645, 41724, 41728, 41732, 41736, 41758, 41762, 41773, 41822, 41823, 41862, 41922, 41923, 42101, 42155, 42187, 42194, 42198, 42222, 42226, 42227, 42398, 42467, 42745, 42764, 42766, 42767, 42770, 42772, 42780, 42825, 42827, 42830, 42831, 42833, 42834, 42835, 42837, 42847, 42849, 42891, 42938, 43043, 43310, 43380, 43390, 43398, 43402, 43407, 43408, 43413, 43416, 43418, 43420, 43423, 43449, 43484, 43524, 43526, 43530, 43538, 43544, 43552, 43556, 43560, 43567, 43569, 43586, 43598, 43609, 43658, 43800, 43817, 43853, 43875, 43882, 44001, 44025, 44033, 44061, 44065, 44069, 44079, 44185, 44189, 44201, 44203, 44205, 44209, 44211, 44213, 44215, 44217, 44220, 44222, 44224, 44226, 44234, 44236, 44243, 44250, 44257, 44262, 44274, 44280, 44285, 44292, 44310, 44327, 44340, 44357, 44371, 44376, 44388, 44403, 44420, 44436, 44453, 44475, 44520, 44533, 44562, 44598, 44606, 44617, 44653, 44656, 44669, 44700, 44711, 44739, 44775, 44823, 44910, 44924, 44970, 45026, 45168, 45194, 45197, 45239, 45291, 45358, 45463, 45476, 45479, 45481, 45491, 45496, 45501, 45530, 45533, 45536, 45571, 45674, 45717, 45718, 45730, 45736, 45751, 45802, 45804, 45869, 45895, 45898, 45900, 45907, 45921, 45935, 45938, 45949, 46016, 46037, 46082, 46095, 46097, 46114, 46169, 46276, 46285, 46314, 46321, 46326, 46334, 46337, 46355, 46391, 46410, 46502, 46504, 46522, 46646, 46647, 46649, 46663, 46671, 46682, 46696, 46705, 46835, 46898, 46985, 47078, 47083, 47086, 47088, 47091, 47093, 47096, 47098, 47101, 47104, 47108, 47114, 47117, 47119, 47124, 47126, 47128, 47131, 47133, 47139, 47144, 47148, 47150, 47154, 47156, 47161, 47165, 47171, 47186, 47196, 47204, 47208, 47243, 47270, 47276, 47320, 47334, 47349, 47371, 47376, 47380, 47383, 47386, 47387, 47388, 47498, 47500, 47531, 47534, 47548, 47569, 47581, 47594, 47702, 47712, 47742, 47756, 47757, 47771, 47776, 47777, 47878, 47913, 47956, 48025, 48116, 48179, 48230, 48272, 48350, 48352, 48359, 48364, 48366, 48368, 48373, 48378, 48387, 48392, 48396, 48399, 48405, 48414, 48419, 48446, 48452, 48455, 48460, 48463, 48468, 49110, 49192, 49237, 49412, 49431, 49433, 49438, 49440, 49444, 49448, 49451, 49453, 49457, 49461, 49464, 49466, 49471, 49474, 49477, 49479, 49484, 49489, 49492, 49494, 49499, 49503, 49506, 49508, 49512, 49516, 49519, 49521, 49524, 49526, 49528, 49530, 49533, 49538, 49555, 49611, 49641, 49877, 49886, 49891, 49938, 49952, 50077, 50111, 50127, 50156, 50297, 50370, 50386, 50501, 50606, 50816, 50912, 50938, 50963, 51001, 51003, 51004, 51005, 51007, 51009, 51014, 51016, 51018, 51021, 51027, 51029, 51033, 51036, 51041, 51045, 51078, 51087, 51145, 51150, 51241, 51271, 51509, 51513, 51517, 51914, 52044, 52050, 52051, 52053, 52208, 52443, 52448, 52467, 52472, 52480, 52503) 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: Half An Hour After Supper

Afterpiece Title: Next Door Neighbours

Cast
Role: Sir Richard Vernon Actor: Davies

Afterpiece Title: The Minor

Performances

Mainpiece Title: The Heiress

Cast
Role: Chignon Actor: Baddeley

Afterpiece Title: Don Juan; or, The Libertine Destroyed

Song: II: a song-Mrs Crouch. [This was sung, as here assigned, in all subsequent performances.

Performances

Mainpiece Title: The First Part Of King Henry The Fourth

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: The First Part of King Henry the Fourth

Cast
Role: Sir Richard Vernon Actor: Farren

Afterpiece Title: Oscar and Malvina

Music: As17911122

Performances

Mainpiece Title: The Heiress

Cast
Role: Chignon Actor: Baddeley

Afterpiece Title: Richard Coeur de Lion

Performances

Mainpiece Title: The First Part Of King Henry The Fourth

Cast
Role: Sir Richard Vernon Actor: Barrymore

Afterpiece Title: The Doctor and the Apothecary

Performances

Mainpiece Title: The Heiress

Cast
Role: Chignon Actor: Baddeley

Afterpiece Title: Richard Coeur de Lion

Performances

Mainpiece Title: The Heiress

Cast
Role: Chignon Actor: Baddeley

Afterpiece Title: The Sultan

Dance: As17911210

Performances

Mainpiece Title: The Heiress

Cast
Role: Chignon Actor: Baddeley

Afterpiece Title: The Devil to Pay

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

Performances

Mainpiece Title: The Coronation Anthem

Afterpiece Title: The Messiah; L'Allegro ed il Pensieroso 0

Performances

Mainpiece Title: L'allegro Ed Il Pensieroso 0

Afterpiece Title: L'Allegro ed il Pensieroso 1

Afterpiece Title: L'Allegro ed il Pensieroso 2

Afterpiece Title: Grand Miscellaneous Act

Performances

Mainpiece Title: A Grand Selection 0 Principally From The Works Of handel; Redemption 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

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

Afterpiece Title: L'Allegro ed il Pensieroso 1

Afterpiece Title: L'Allegro ed il Pensieroso 2

Afterpiece Title: Grand Miscellaneous Act

Performances

Mainpiece Title: A Grand Selection 0principally From The Works Of handel; Redemption 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Cast
Role: Non piu andrai Actor: Morelli

Performances

Mainpiece Title: A Grand Selection 0principally From The Works Of handel; Redemption 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Cast
Role: Non vi par Actor: Morelli, Kelly, Mrs Crouch

Song: End II: Mad Bess-Mrs Crouch (Purcell)

Performances

Mainpiece Title: L'allegro Ed Il Pensieroso

Afterpiece Title: L'Allegro ed il Pensieroso 1

Afterpiece Title: L'Allegro ed il Pensieroso 2

Afterpiece Title: Grand Miscellaneous Act

Performances

Mainpiece Title: The Heiress

Cast
Role: Chignon Actor: Baddeley

Afterpiece Title: The Spoil'd Child

Dance: End: a Dance-

Performances

Mainpiece Title: The Heiress

Cast
Role: Chignon Actor: Baddeley

Afterpiece Title: The First Floor

Performances

Mainpiece Title: Half An Hour After Supper

Afterpiece Title: King Henry the Fourth [Part I]

Cast
Role: Sir Richard Vernon Actor: Bland

Performances

Mainpiece Title: At King's The Heiress

Cast
Role: Chignon Actor: Baddeley

Afterpiece Title: The Cave of Trophonius

Song: II: a song-Mrs Crouch

Performances

Mainpiece Title: At King's The Heiress

Cast
Role: Chignon Actor: Baddeley

Afterpiece Title: The Prisoner

Song: As17921016

Performances

Mainpiece Title: At King's The Heiress

Cast
Role: Chignon Actor: Baddeley

Afterpiece Title: No Song No Supper

Song: As17921016

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Cast
Role: Non piu andrai Actor: Morelli

Performances

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

Afterpiece Title: Acis and Galatea

Afterpiece Title: A New Grand Selection

Cast
Role: Non piu andrai Actor: Morelli.