SELECT * FROM london_stages WHERE eventid IN (1136, 1326, 24529, 33840, 33885, 33906, 34068, 34098, 34138, 34176, 34188, 34210, 34215, 34233, 34250, 34255, 34259, 34262, 34358, 34519, 34584, 34620, 34733, 34737, 34776, 34792, 35025, 35041, 35103, 35241, 35270, 35284, 35290, 35306, 35320, 35355, 35499, 35552, 35563, 35567, 35571, 35580, 35584, 35593, 35608, 35622, 35660, 35673, 35675, 35682, 35684, 35687, 35689, 35692, 35694, 35697, 35700, 35703, 35705, 35762, 35866, 35902, 35928, 35935, 35950, 35955, 35990, 36119, 36128, 36132, 36136, 36142, 36198, 36207, 36226, 36247, 36256, 36290, 36318, 36368, 36371, 36377, 36559, 36956, 36958, 36964, 36981, 36997, 37006, 37015, 37032, 37045, 37047, 37061, 37079, 37102, 37120, 37222, 37267, 37269, 37271, 37273, 37275, 37277, 37336, 37383, 37452, 37551, 37612, 37657, 37660, 37802, 37820, 37896, 37898, 37906, 37910, 37920, 37924, 37936, 38033, 38134, 38157, 38515, 38722, 38732, 38945, 38947, 38952, 38959, 38963, 38966, 38968, 39009, 39012, 39025, 39029, 39031, 39046, 39055, 39115, 39316, 39430, 39790, 39855, 40367, 40398, 40411, 40413, 40425, 40431, 40433, 40448, 40570, 40572, 40589, 40591, 40593, 40596, 40600, 40602, 40604, 40606, 40608, 40611, 40613, 40615, 40617, 40619, 40624, 40630, 40634, 40653, 40658, 40660, 40663, 40665, 40667, 40669, 40672, 40674, 40677, 40679, 40681, 40683, 40686, 40688, 40691, 40693, 40695, 40700, 40703, 40706, 40708, 40711, 40714, 40717, 40719, 40721, 40723, 40726, 40729, 40732, 40734, 40741, 40743, 40746, 40755, 40761, 40765, 40767, 40770, 40775, 40777, 40781, 40787, 40789, 40795, 40797, 40801, 40804, 40807, 40809, 40816, 40821, 40825, 40828, 40831, 40833, 40839, 40842, 40845, 40848, 40852, 40856, 40859, 40866, 40870, 40873, 40876, 40882, 40884, 40886, 40889, 40891, 40898, 40902, 40910, 40912, 40915, 40917, 40920, 40922, 40928, 40938, 40941, 40943, 40946, 40951, 40953, 40956, 40958, 40960, 40962, 40965, 40967, 40970, 40972, 40974, 40978, 40980, 40983, 40985, 40987, 40989, 40992, 40997, 41002, 41005, 41115, 41117, 41119, 41122, 41125, 41127, 41130, 41137, 41139, 41141, 41145, 41150, 41152, 41154, 41156, 41158, 41160, 41162, 41166, 41171, 41176, 41184, 41187, 41194, 41196, 41205, 41211, 41224, 41231, 41233, 41241, 41247, 41250, 41259, 41261, 41264, 41269, 41273, 41275, 41278, 41283, 41295, 41301, 41318, 41323, 41327, 41338, 41342, 41344, 41361, 41394, 41408, 41417, 41425, 41430, 41461, 41474, 41476, 41485, 41503, 41513, 41515, 41529, 41532, 41537, 41542, 41544, 41547, 41552, 41557, 41562, 41564, 41569, 41571, 41691, 41693, 41695, 41697, 41699, 41701, 41707, 41709, 41716, 41727, 41729, 41731, 41733, 41737, 41739, 41741, 41745, 41749, 41751, 41753, 41757, 41761, 41763, 41765, 41768, 41770, 41774, 41776, 41779, 41781, 41784, 41786, 41788, 41790, 41793, 41795, 41800, 41802, 41804, 41807, 41814, 41816, 41823, 41828, 41833, 41836, 41841, 41846, 41851, 41853, 41856, 41858, 41861, 41863, 41866, 41868, 41870, 41872, 41875, 41877, 41880, 41882, 41885, 41887, 41890, 41893, 41896, 41898, 41901, 41903, 41906, 41909, 41912, 41914, 41916, 41918, 41921, 41923, 41926, 41929, 41931, 41934, 41936, 41939, 41941, 41945, 41976, 41980, 41984, 41987, 41994, 41998, 42001, 42003, 42011, 42017, 42021, 42026, 42040, 42042, 42045, 42047, 42056, 42058, 42061, 42063, 42066, 42073, 42081, 42086, 42091, 42098, 42101, 42111, 42122, 42124, 42127, 42129, 42132, 42134, 42137, 42142, 42144, 42147, 42152, 42154, 42157, 42163, 42270, 42271, 42272, 42293, 42294, 42299, 42302, 42306, 42310, 42312, 42314, 42318, 42324, 42328, 42330, 42338, 42354, 42357, 42372, 42392, 42398, 42420, 42422, 42430, 42432, 42461, 42467, 42486, 42496, 42549, 42559, 42561, 42566, 42569, 42625, 42633, 42649, 42659, 42670, 42672, 42677, 42678, 42692, 42697, 42699, 42721, 42726, 42728, 42731, 42741, 42747, 42787, 42788, 42791, 42795, 42798, 42799, 42800, 42805, 42807, 42817, 42818, 42829, 42841, 42843, 42868, 42874, 42879, 42882, 42884, 42886, 42894, 42899, 42911, 42912, 42914, 42916, 42918, 42922, 42924, 42930, 42934, 42938, 42940, 42946, 42954, 42958, 42965, 42999, 43008, 43010, 43012, 43015, 43017, 43024, 43029, 43031, 43038, 43043, 43067, 43077, 43079, 43081, 43084, 43093, 43098, 43101, 43104, 43115, 43127, 43143, 43186, 43191, 43195, 43200, 43219, 43222, 43229, 43232, 43237, 43247, 43249, 43255, 43260, 43263, 43265, 43285, 43293, 43303, 43310, 43313, 43318, 43321, 43325, 43336, 43342, 43347, 43395, 43400, 43407, 43432, 43439, 43444, 43446, 43448, 43449, 43451, 43453, 43455, 43460, 43463, 43470, 43472, 43484, 43494, 43498, 43506, 43510, 43529, 43535, 43539, 43557, 43559, 43564, 43566, 43568, 43570, 43572, 43575, 43577, 43580, 43585, 43594, 43596, 43599, 43601, 43604, 43608, 43610, 43613, 43615, 43618, 43620, 43622, 43624, 43627, 43629, 43633, 43638, 43644, 43653, 43659, 43662, 43664, 43668, 43674, 43689, 43702, 43707, 43712, 43718, 43726, 43732, 43736, 43743, 43752, 43756, 43767, 43770, 43772, 43776, 43779, 43781, 43784, 43786, 43792, 43795, 43801, 43803, 43809, 43812, 43815, 43818, 43824, 43826, 43832, 43836, 43838, 43841, 43844, 43847, 43849, 43852, 43854, 43856, 43858, 43861, 43863, 43866, 43873, 43876, 43883, 43886, 43891, 43893, 43896, 43900, 43920, 43923, 43936, 43944, 43951, 43963, 43967, 43974, 43986, 43987, 44000, 44013, 44015, 44019, 44029, 44031, 44033, 44035, 44037, 44039, 44041, 44046, 44050, 44054, 44056, 44061, 44063, 44066, 44068, 44070, 44072, 44076, 44085, 44089, 44091, 44093, 44095, 44099, 44101, 44105, 44107, 44113, 44115, 44125, 44131, 44133, 44137, 44139, 44143, 44149, 44155, 44159, 44165, 44167, 44172, 44176, 44178, 44182, 44184, 44190, 44196, 44198, 44202, 44208, 44212, 44214, 44221, 44225, 44227, 44233, 44239, 44244, 44247, 44249, 44251, 44253, 44275, 44277, 44279, 44286, 44293, 44303, 44319, 44341, 44345, 44369, 44382, 44394, 44409, 44414, 44417, 44419, 44427, 44432, 44434, 44439, 44444, 44447, 44449, 44452, 44454, 44457, 44459, 44464, 44466, 44467, 44481, 44490, 44492, 44493, 44495, 44498, 44499, 44503, 44504, 44508, 44515, 44517, 44523, 44526, 44527, 44532, 44553, 44556, 44557, 44559, 44560, 44562, 44563, 44564, 44566, 44570, 44575, 44576, 44580, 44581, 44585, 44586, 44591, 44599, 44605, 44618, 44628, 44634, 44645, 44648, 44668, 44692, 44708, 44712, 44719, 44726, 44733, 44735, 44737, 44748, 44762, 44771, 44774, 44780, 44791, 44819, 44859, 44862, 44870, 44873, 44879, 44883, 44903, 44912, 44914, 44915, 44920, 44951, 44957, 44960, 44997, 45012, 45017, 45019, 45153, 45160, 45175, 45177, 45185, 45187, 45189, 45195, 45282, 45284, 45286, 45288, 45290, 45294, 45296, 45299, 45304, 45306, 45309, 45311, 45313, 45318, 45320, 45323, 45325, 45327, 45329, 45332, 45334, 45339, 45341, 45343, 45348, 45351, 45355, 45360, 45368, 45371, 45373, 45377, 45380, 45383, 45385, 45389, 45393, 45406, 45409, 45419, 45435, 45437, 45439, 45445, 45448, 45450, 45455, 45479, 45486, 45489, 45505, 45518, 45520, 45538, 45543, 45546, 45548, 45551, 45553, 45556, 45563, 45578, 45590, 45603, 49837, 49849, 50166, 50737) 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: Macbeth

Afterpiece Title: The Upholsterer

Cast
Role: Feeble Actor: Bates

Performances

Mainpiece Title: The Beggar's Opera

Performances

Mainpiece Title: She Stoops To Conquer

Performances

Mainpiece Title: Love In A Village

Dance: II: Aldridge, Miss Capon

Performances

Mainpiece Title: All For Love; Or, The World Well Lost

Cast
Role: Romans Actor: Davis, Bates

Afterpiece Title: The Golden Pippin

Dance: End: The Merry Sailors, as17731007

Performances

Mainpiece Title: All For Love

Cast
Role: Romans Actor: Davis, Bates

Afterpiece Title: Achilles in Petticoats

Dance: End: The Lamplighter, as17731207

Performances

Mainpiece Title: The Man Of Business

Afterpiece Title: The Upholsterer

Cast
Role: Feeble Actor: Bates

Dance: End: The Highland Reel, as17731112

Performances

Mainpiece Title: Don Sebastian, King Of Portugal

Cast
Role: Orchan Actor: Bates

Afterpiece Title: The Upholsterer

Cast
Role: Feeble Actor: Bates

Dance: End: The Old Ground Young, as17731208

Performances

Mainpiece Title: King Henry Viii

Afterpiece Title: The Upholsterer

Cast
Role: Feeble Actor: Bates

Dance: End: The Frolick, as17740416

Performances

Mainpiece Title: Don Sebastian

Cast
Role: Orchan Actor: Bates

Afterpiece Title: The Dragon of Wantly

Monologue: Interlude.End: True Blue. As 3 May

Dance: End I Farce: Minuet-Blurton, Miss Stede

Performances

Mainpiece Title: The West Indian

Afterpiece Title: The Upholsterer

Cast
Role: Feeble Actor: Bates

Dance: End: A Comic Dance-Aldridge, Mrs Stephens

Performances

Mainpiece Title: The Jealous Wife

Cast
Role: John Actor: Bates

Afterpiece Title: Comus

Dance: II: The Provencale, as17740928

Performances

Mainpiece Title: Artaxerxes

Afterpiece Title: The Romance of An Hour

Cast
Role: James Actor: Bates

Dance: I: The Vintage Festival, as17741007; End Opera: The Irish Lilt-Aldridge, Miss Valois. [See17731005]

Performances

Mainpiece Title: Zara

Afterpiece Title: The Romance of an Hour

Cast
Role: James Actor: Bates

Dance: End Tragedy: The Vintage Festival, as17741007

Performances

Mainpiece Title: The Maid Of The Mill

Afterpiece Title: The Romance of an Hour

Cast
Role: James Actor: Bates

Dance: End Opera: A Comic Dance-Aldridge, Mrs Stephens. [See17711009.

Performances

Mainpiece Title: Lady Jane Grey

Afterpiece Title: The Romance of an Hour

Cast
Role: James Actor: Bates

Dance: End Tragedy: A Comic Dance, call'd Rural Merriment-Aldridge, Mrs Stephens

Performances

Mainpiece Title: A Bold Stroke For A Wife

Afterpiece Title: The Romance of an Hour

Cast
Role: James Actor: Bates

Dance: II: The Frolick-Aldridge, Mrs Stephens, Miss Besford See17740416; End: A New Dance call'd The Generous Pirate-Dagueville, his Pupil, Mas. Blurton, Mrs Stevens, Helme, Sga Vidini

Performances

Mainpiece Title: Artaxerxes

Afterpiece Title: The Romance of an Hour

Cast
Role: James Actor: Bates

Dance: I: The Generous Pirate-Dagueville, Helme, Sga Vidini; End Opera: The Frolick, as17741214

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: The Romance of an Hour

Cast
Role: James Actor: Bates

Dance: II: The Provencale, as17740928; End Opera: The Frolick, as17741214

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: The Romance of an Hour

Cast
Role: James Actor: Bates

Dance: End: The Generous Pirate, as17741214

Performances

Mainpiece Title: King Henry Ii

Afterpiece Title: The Romance of an Hour

Cast
Role: James Actor: Bates

Entertainment: Interlude. End: True Blue; or, The Press Gang. Parts-Mattocks, Reinhold, Baker, Mrs Baker

Dance: End Interlude: The Merry Sailors, as17741026

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: The Romance of an Hour

Cast
Role: James Actor: Bates

Entertainment: Interlude.End: As17750401

Dance: End Interlude: A Hornpipe-Blurton (Public Advertiser)

Performances

Mainpiece Title: Douglas

Afterpiece Title: The Cheats of Scapin

Cast
Role: Sly Actor: Bates

Dance: End Tragedy: Mirth and Jollity, as17760102

Performances

Mainpiece Title: The Rivals

Afterpiece Title: The Man of Quality

Cast
Role: Taylor Actor: Bates

Dance: End: Mirth and Jollity, as17760102