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, 40845, 40848, 40852, 40856, 40859, 40866, 40870, 40873, 40876, 40882, 40884, 40886, 40889, 40891, 40898, 40902, 40910, 40912, 40915, 40917, 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, 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: The Belle's Stratagem

Cast
Role: Silver Tongue Actor: W. Bates

Afterpiece Title: Harlequin Free-Mason

Performances

Mainpiece Title: The Belle's Stratagem

Cast
Role: Silver Tongue Actor: W. Bates

Afterpiece Title: Harlequin Free-Mason

Performances

Mainpiece Title: The Belle's Stratagem

Cast
Role: Silver Tongue Actor: W. Bates

Afterpiece Title: Tom Thumb

Dance: As17801107

Performances

Mainpiece Title: The Belle's Stratagem

Cast
Role: Silver Tongue Actor: W. Bates

Afterpiece Title: Harlequin Free-Mason

Performances

Mainpiece Title: The Belle's Stratagem

Cast
Role: Silver Tongue Actor: W. Bates

Afterpiece Title: Harlequin Free-Mason

Performances

Mainpiece Title: The Chances

Cast
Role: Peter Actor: W. Bates

Afterpiece Title: Thelyphthora

Performances

Mainpiece Title: The Belle's Stratagem

Cast
Role: Silver Tongue Actor: W. Bates

Afterpiece Title: The Deaf Lover

Cast
Role: Servants Actor: W. Bates, Jones
Role: Sternhold Actor: Bates

Dance: As17810208

Performances

Mainpiece Title: The Belle's Stratagem

Cast
Role: Silver Tongue Actor: W. Bates

Afterpiece Title: Harlequin Free-Mason

Performances

Mainpiece Title: King Charles The First

Afterpiece Title: True Blue

Cast
Role: Sir Walter Blunt Actor: W. Bates
Role: Harlequin Actor: W. Bates

Afterpiece Title: Midas

Dance: 2nd piece: a Dance of Sailors Sailor's Dance-Aldridge

Performances

Mainpiece Title: The Belle's Stratagem

Cast
Role: Silver Tongue Actor: W. Bates

Afterpiece Title: A Fete

Afterpiece Title: Tom Thumb

Performances

Mainpiece Title: The Belle's Stratagem

Cast
Role: Silver Tongue Actor: W. Bates

Afterpiece Title: A Fete

Afterpiece Title: Tom Thumb

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: A Fete

Afterpiece Title: Midas

Cast
Role: Sir Walter Blunt Actor: W. Bates
Role: Harlequin Actor: W. Bates

Performances

Mainpiece Title: The Belle's Stratagem

Cast
Role: Silver Tongue Actor: W. Bates

Afterpiece Title: A Fete

Afterpiece Title: Poor Vulcan

Song: As17810425

Performances

Mainpiece Title: Seventeen Hundred And Eighty One; Or, The Cartel At Philadelphia

Cast
Role: Turpentine Actor: Bates

Afterpiece Title: Sir Courtly Nice; or, It Cannot Be

Cast
Role: Waytwell Actor: W. Bates

Afterpiece Title: Who'd have Thought It

Performances

Mainpiece Title: The Farmer's Return From London

Afterpiece Title: The Chances

Cast
Role: Marrowbone Actor: Bates
Role: Proteus Actor: W. Bates

Afterpiece Title: A Fete

Afterpiece Title: The Padlock

Performances

Mainpiece Title: The Farmer's Return From London

Afterpiece Title: All for Love

Afterpiece Title: Phusimimesis; or, Resemblances of Nature

Afterpiece Title: The Royal Chace; or, Harlequin Skeleton

Cast
Role: Jupiter Actor: W. Bates

Song: End II 2nd piece: The Huntsman's Sweet Halloo, as17810226; 4th piece: The Early Horn-Cubitt; Scene I: When Phoebus the tops of the hills, as17810425

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Chit Chat

Afterpiece Title: Who'd have Thought It

Cast
Role: Waytwell Actor: W. Bates

Dance: End 2nd piece: The Sports of the Green, as17810501

Song: As17810115

Performances

Mainpiece Title: The Double Gallant

Cast
Role: Supple Actor: W. Bates

Afterpiece Title: A Fete

Afterpiece Title: Tom Thumb

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: A Fete

Afterpiece Title: The Touchstone

Cast
Role: Harlequin Actor: W. Bates

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: Phusimimesis

Cast
Role: Jupiter Actor: W. Bates

Afterpiece Title: Harlequin Skeleton [i

Cast
Role: Jupiter Actor: W. Bates

Performances

Mainpiece Title: A New Way To Pay Old Debts

Afterpiece Title: The Farmer's Return from London

Afterpiece Title: The Touchstone

Ballet: End III 1st piece: St. David's Day. As17810501

Performances

Mainpiece Title: The Belle's Stratagem

Cast
Role: Silver Tongue Actor: W. Bates

Afterpiece Title: The Flitch of Bacon

Dance: IV: Minuet de la Cour en Quatre-Holloway, Holland, Miss Francis, Miss Matthews; a Minuet-Harris, Miss Younge; End IV: a new Pastoral Dance-Harris, Miss Matthews

Ballet: End: St. David's Day. As17810501

Monologue: End II: The Humours of New-Market; with the Poney Races. Jockeys-Harris, Holland, Ratchford, Holloway; Ladies-Miss Besford, Miss Francis, Miss Matthews

Performances

Mainpiece Title: The Man Of The World

Afterpiece Title: Harlequin Skeleton [i

Cast
Role: Jupiter Actor: W. Bates

Performances

Mainpiece Title: The Comedy Of Errors

Afterpiece Title: True Blue

Cast
Role: Sir Walter Blunt Actor: W. Bates
Role: Harlequin Actor: W. Bates

Afterpiece Title: Barnaby Brittle

Dance: As17810402

Performances

Mainpiece Title: A New Way To Pay Old Debts

Afterpiece Title: Midas

Cast
Role: Sir Walter Blunt Actor: W. Bates
Role: Harlequin Actor: W. Bates