SELECT * FROM london_stages WHERE eventid IN (662, 718, 1282, 1302, 1457, 1533, 2435, 2840, 3075, 3557, 3599, 3830, 3884, 3886, 3952, 4033, 4057, 4099, 4100, 4102, 4103, 4114, 4148, 4289, 4385, 4604, 4669, 4697, 4753, 4924, 5192, 5239, 5333, 5406, 5472, 5666, 6022, 6363, 6544, 6620, 6743, 7077, 7514, 7920, 7939, 8435, 8870, 9037, 9326, 9570, 9626, 10155, 10831, 11189, 11191, 11263, 11581, 11583, 11586, 11589, 11591, 11593, 11756, 11958, 12984, 13964, 14231, 14297, 14302, 14345, 14456, 14892, 15957, 15961, 15965, 15967, 15971, 15975, 16017, 16111, 16312, 16375, 16426, 16643, 17076, 17512, 18559, 20069, 20336, 20339, 20342, 20343, 20347, 20350, 20353, 20356, 20359, 20362, 20366, 20369, 20375, 20378, 20381, 20385, 20389, 20392, 20395, 20435, 20438, 20457, 20532, 20607, 20610, 20641, 20676, 20690, 20763, 20764, 20766, 20767, 20769, 20770, 20771, 20772, 20796, 20797, 20829, 20878, 20893, 20941, 20991, 21013, 21031, 21093, 21133, 21153, 21154, 21157, 21210, 21217, 21241, 21310, 21338, 21368, 21388, 21460, 21509, 21544, 21834, 22003, 22004, 22009, 22011, 22018, 22035, 22076, 22104, 22154, 22182, 22213, 22253, 22271, 22314, 22367, 22395, 22478, 22581, 22783, 22844, 22967, 23022, 23077, 23532, 23561, 23728, 23822, 23926, 23966, 24126, 24265, 24394, 25459, 25486, 25504, 25511, 26117, 26280, 26320, 26347, 26513, 26573, 26643, 26698, 26749, 27103, 27175, 27458, 27614, 27657, 27739, 28095, 28226, 28522, 28646, 28723, 28842, 29054, 29151, 29247, 29381, 29972, 29976, 29979, 29982, 29984, 30004, 30007, 30010, 30013, 30016, 30019, 30022, 30025, 30053, 30056, 30064, 30074, 30094, 30096, 30118, 30131, 30154, 30282, 30296, 30301, 30316, 30330, 30334, 30375, 30384, 30409, 30411, 30428, 30442, 30456, 30464, 30471, 30521, 30562, 30565, 30609, 30630, 30645, 30794, 30814, 30817, 30848, 30873, 31041, 31060, 31166, 31190, 31260, 31341, 31381, 31402, 31438, 31534, 31535, 31681, 31721, 31754, 31848, 31912, 31978, 32027, 32174, 32205, 32250, 32361, 32661, 32702, 32893, 33130, 33186, 33254, 33497, 33560, 33660, 33849, 33857, 33884, 34155, 34178, 34381, 34781, 34921, 35319, 35324, 35325, 35363, 35520, 35549, 35553, 35583, 35597, 35603, 35648, 35684, 35747, 35751, 35789, 35792, 35827, 35856, 35869, 35943, 35970, 35983, 35994, 36118, 36145, 36248, 36460, 36568, 36719, 37021, 37274, 37540, 37592, 37604, 37656, 37671, 37775, 37790, 37815, 37838, 37840, 37844, 37916, 37931, 37946, 37997, 38012, 38048, 38112, 38124, 38136, 38178, 38208, 38224, 38315, 38334, 38341, 38547, 38549, 38551, 38554, 38555, 38645, 38682, 38737, 38743, 38885, 38909, 38918, 38937, 38940, 38946, 38976, 39052, 39093, 39107, 39123, 39213, 39245, 39257, 39265, 39291, 39293, 39296, 39298, 39301, 39303, 39306, 39312, 39315, 39317, 39320, 39322, 39324, 39326, 39329, 39331, 39335, 39339, 39343, 39346, 39349, 39478, 39482, 39484, 39489, 39495, 39504, 39516, 39522, 39530, 39534, 39536, 39544, 39548, 39553, 39558, 39562, 39569, 39576, 39586, 39597, 39623, 39627, 39634, 39639, 39646, 39666, 39697, 39702, 39711, 39716, 39719, 39723, 39731, 39740, 39745, 39754, 39764, 39772, 39781, 39786, 39802, 39826, 39827, 39830, 39840, 39859, 39862, 39873, 39886, 39907, 40025, 40033, 40037, 40052, 40057, 40064, 40076, 40088, 40100, 40108, 40127, 40141, 40155, 40180, 40194, 40201, 40209, 40223, 40237, 40249, 40262, 40275, 40288, 40301, 40330, 40359, 40373, 40388, 40402, 40405, 40432, 40447, 40453, 40466, 40565, 40568, 40586, 40595, 40616, 40650, 40695, 40705, 40751, 40776, 40778, 40806, 40832, 40851, 40875, 40880, 40893, 40899, 40927, 40950, 40952, 40964, 40977, 40986, 41134, 41144, 41151, 41153, 41183, 41228, 41256, 41261, 41272, 41298, 41326, 41358, 41371, 41375, 41399, 41401, 41414, 41457, 41470, 41473, 41474, 41484, 41498, 41514, 41523, 41537, 41552, 41567, 41575, 41698, 41708, 41726, 41745, 41746, 41769, 41779, 41786, 41792, 41811, 41833, 41860, 41909, 41925, 41950, 41966, 41974, 42016, 42025, 42057, 42067, 42090, 42092, 42136, 42166, 42286, 42288, 42311, 42319, 42323, 42344, 42366, 42416, 42471, 42503, 42641, 42676, 42711, 42718, 42723, 42791, 42795, 42798, 42888, 42964, 42985, 43228, 43259, 43436, 43467, 43477, 43499, 43560, 43617, 43655, 43657, 43685, 43742, 43769, 43843, 43846, 43857, 43880, 43904, 44013, 44028, 44130, 44156, 44195, 44244, 44266, 44278, 44381, 44406, 44473, 44588, 44614, 44650, 44651, 44652, 44654, 44658, 44662, 44666, 44670, 44674, 44678, 44682, 44686, 44690, 44694, 44732, 44743, 44750, 44757, 44763, 44764, 44776, 44787, 44796, 44833, 44889, 44906, 44909, 44914, 44929, 44954, 44977, 45007, 45012, 45054, 45143, 45160, 45187, 45195, 45236, 45243, 45294, 45346, 45371, 45453, 45499, 45524, 45559, 45567, 45574, 45589, 45594, 45672, 45710, 45715, 45768, 45826, 45896, 45913, 45915, 45917, 45922, 45927, 45928, 45934, 45945, 45979, 46005, 46036, 46146, 46150, 46168, 46272, 46355, 46357, 46373, 46389, 46532, 46546, 46641, 46713, 46865, 46874, 46895, 46896, 46905, 46910, 46934, 46937, 46958, 46970, 46978, 46995, 47011, 47039, 47045, 47048, 47062, 47092, 47100, 47123, 47155, 47172, 47211, 47261, 47284, 47442, 47447, 47448, 47449, 47453, 47457, 47458, 47463, 47568, 47575, 47704, 47714, 47729, 47754, 47768, 47769, 47783, 47815, 47871, 47893, 47899, 47992, 48017, 48044, 48067, 48106, 48177, 48235, 48263, 48369, 48383, 48423, 48431, 48550, 48552, 48554, 48556, 48558, 48562, 48564, 48568, 48574, 48578, 48582, 48587, 48589, 48593, 48595, 48599, 48610, 48614, 48626, 48636, 48644, 48652, 48657, 48666, 48668, 48670, 48676, 48678, 48679, 48684, 48686, 48688, 48690, 48692, 48694, 48698, 48699, 48700, 48706, 48710, 48718, 48720, 48726, 48728, 48736, 48746, 48748, 48750, 48756, 48776, 48778, 48780, 48786, 48788, 48790, 48792, 48794, 48797, 48799, 48802, 48804, 48806, 48808, 48811, 48813, 48816, 48818, 48822, 48825, 48827, 48829, 48831, 48833, 48836, 48838, 48841, 48843, 48845, 48847, 48850, 48852, 48855, 48857, 48859, 48861, 48864, 48866, 48869, 48871, 48873, 48875, 48880, 48883, 48885, 48888, 48891, 48893, 48896, 48899, 48900, 48903, 48909, 48910, 48917, 48919, 48924, 48928, 48931, 48932, 48934, 48939, 48946, 48953, 48957, 48960, 48962, 48987, 48994, 48999, 49011, 49025, 49031, 49047, 49062, 49085, 49099, 49102, 49111, 49134, 49165, 49170, 49175, 49178, 49182, 49235, 49259, 49271, 49295, 49389, 49391, 49403, 49416, 49421, 49426, 49440, 49540, 49558, 49654, 49658, 49668, 49685, 49687, 49695, 49700, 49702, 49711, 49713, 49717, 49718, 49729, 49730, 49734, 49736, 49740, 49741, 49744, 49745, 49746, 49747, 49749, 49750, 49751, 49752, 49753, 49767, 49784, 49786, 49804, 49818, 49830, 49854, 49920, 49925, 49956, 50081, 50207, 50251, 50256, 50260, 50271, 50279, 50284, 50286, 50287, 50291, 50296, 50297, 50302, 50303, 50307, 50314, 50317, 50318, 50341, 50390, 50439, 50465, 50507, 50535, 50577, 50592, 50596, 50601, 50610, 50615, 50619, 50623, 50626, 50627, 50628, 50631, 50632, 50634, 50635, 50637, 50638, 50639, 50640, 50643, 50646, 50649, 50651, 50655, 50658, 50661, 50683, 50687, 50689, 50690, 50692, 50695, 50706, 50713, 50730, 50731, 50735, 50741, 50743, 50746, 50748, 50751, 50761, 50769, 50773, 50776, 50781, 50783, 50785, 50789, 50791, 50794, 50796, 50799, 50887, 50891, 50892, 50898, 50900, 50902, 50914, 50924, 50930, 50938, 50941, 50962, 50969, 50989, 51001, 51003, 51005, 51007, 51009, 51014, 51016, 51017, 51018, 51021, 51027, 51029, 51033, 51036, 51041, 51045, 51078, 51086, 51087, 51125, 51127, 51129, 51134, 51137, 51146, 51150, 51153, 51226, 51241, 51244, 51247, 51249, 51252, 51254, 51256, 51258, 51261, 51271, 51285, 51288, 51289, 51298, 51330, 51336, 51360, 51403, 51410, 51416, 51425, 51440, 51447, 51455, 51456, 51467, 51474, 51478, 51493, 51530, 51548, 51606, 51630, 51649, 51652, 51663, 51709, 51721, 51733, 51746, 51798, 51810, 51819, 51842, 51886, 51950, 51953, 51988, 52004, 52013, 52021, 52026, 52035, 52037, 52041, 52045, 52052, 52067, 52071, 52086, 52107, 52135, 52145, 52177, 52288, 52293, 52316, 52393, 52455, 52477, 52481, 52505, 52586, 52605, 52610) 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: As You Like It

Cast
Role: Oliver Actor: Caulfield

Afterpiece Title: No Song No Supper

Song: End I: Sweet Lillies of the Valley-Dignum; End IV: My Friend is the Man I'd copy through Life (written by Miles Peter Andrews, Esq., composed by Hook)-Dignum; V: a song, as17990214

Performances

Mainpiece Title: The Dead Alive

Afterpiece Title: Family Distress

Afterpiece Title: The Children in the Wood

Cast
Role: Oliver Actor:

Performances

Mainpiece Title: The Purse

Afterpiece Title: Family Distress

Cast
Role: Oliver Actor:

Afterpiece Title: The Prisoner at Large

Performances

Mainpiece Title: The Heir At Law

Afterpiece Title: The Prisoner at Large

Cast
Role: Oliver Actor:

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: The Heir at Law

Cast
Role: Oliver Actor:

Afterpiece Title: The Purse

Cast
Role: Oliver Actor:

Performances

Mainpiece Title: Seeing Is Believing

Afterpiece Title: Sighs; or, The Daughter

Afterpiece Title: The Purse

Cast
Role: Oliver Actor:

Song: not listed in playbill; see17990824: In II 2nd piece: 'Twas in the solemn mid@night hour-Mrs Bland

Performances

Mainpiece Title: The Shipwreck

Afterpiece Title: Sighs

Cast
Role: Oliver Actor:

Performances

Mainpiece Title: The Castle Of Sorrento

Afterpiece Title: The Heir at Law

Cast
Role: Oliver Actor:

Performances

Mainpiece Title: The Iron Chest

Afterpiece Title: The Shipwreck

Cast
Role: Oliver Actor:

Song: End: Jack and his Charming Fanny (composed by Suett)-Trueman

Performances

Mainpiece Title: The Surrender Of Calais

Afterpiece Title: The Children in the Wood

Cast
Role: Oliver Actor:

Song: End II: Crazy Jane-Mrs Bland; In the character of Josephine in afterpiece 'Twas in the solemn mid@night hour-Mrs Bland the Ballad in Sighs; End I afterpiece: Little Taffline ; or, The Silken Sash-Mrs Bland

Performances

Mainpiece Title: The Shipwreck

Afterpiece Title: The Heir at Law

Cast
Role: Oliver Actor:

Performances

Mainpiece Title: Seeing Is Believing

Afterpiece Title: The Heir at Law

Cast
Role: Oliver Actor:

Afterpiece Title: The Purse

Cast
Role: Oliver Actor:

Performances

Mainpiece Title: A Mogul Tale

Afterpiece Title: The Heir at Law

Cast
Role: Oliver Actor:

Performances

Mainpiece Title: The Castle-spectre

Afterpiece Title: The Children in the Wood

Cast
Role: Oliver Actor: Maddocks

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Clarke

Afterpiece Title: High Life below Stairs

Dance: II afterpiece: Mock Minuet-Palmer, Miss Pope

Song: In V: song-Mrs Bland

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Caulfield

Afterpiece Title: Blue-Beard

Song: As17991001

Performances

Mainpiece Title: The Castle-spectre

Afterpiece Title: The Children in the Wood

Cast
Role: Oliver Actor: Maddocks

Performances

Mainpiece Title: The Castle-spectre

Afterpiece Title: The Children in the Wood

Cast
Role: Oliver Actor: Maddocks

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Caulfield.

Afterpiece Title: The Deserter

Song: As17991001

Performances

Mainpiece Title: The East Indian

Afterpiece Title: The Children in the Wood

Cast
Role: Oliver Actor: Maddocks

Performances

Mainpiece Title: Isabella

Afterpiece Title: The Children in the Wood

Cast
Role: Oliver Actor: Maddocks

Song: As17991122

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Sir Oliver Surface Actor: Aickin

Afterpiece Title: The Virgin Unmask'd

Song: III: a song-Sedgwick

Ballet: End: The Scotch Ghost. As17991217

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Caulfield

Afterpiece Title: Of Age To-morrow

Song: As17991001

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Caulfield

Afterpiece Title: Of Age To-morrow

Song: V: song-Miss Leak

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Sir Oliver Surface Actor: Archer

Afterpiece Title: Lodoiska

Song: In III: song-Dignum