SELECT * FROM london_stages WHERE eventid IN (359, 1099, 20716, 20718, 21327, 22452, 23494, 23500, 23552, 24820, 24827, 24828, 24829, 24830, 24831, 24832, 24833, 24834, 24835, 24836, 24837, 24838, 24839, 24840, 24841, 24842, 24843, 24844, 24845, 24846, 24847, 24848, 24849, 26312, 26440, 26445, 26460, 26502, 26533, 26564, 26581, 26615, 26617, 26655, 26673, 26678, 26680, 26682, 26684, 26686, 26692, 26698, 26700, 26704, 26708, 26712, 26716, 26720, 26734, 26759, 26776, 26787, 26801, 26806, 26839, 26844, 26956, 26964, 26971, 26979, 26983, 27013, 27016, 27027, 27035, 27040, 27059, 27103, 27106, 27156, 27175, 27183, 27199, 27201, 27203, 27205, 27207, 27209, 27211, 27213, 27215, 27217, 27219, 27231, 27233, 27255, 27258, 27260, 27265, 27268, 27274, 27300, 27310, 27313, 27315, 27319, 27328, 27335, 27341, 27343, 27346, 27349, 27351, 27354, 27357, 27375, 27377, 27387, 27401, 27407, 27409, 27412, 27415, 27446, 27459, 27463, 27468, 27473, 27480, 27489, 27492, 27495, 27497, 27502, 27506, 27512, 27524, 27530, 27544, 27547, 27553, 27562, 27565, 27571, 27585, 27590, 27600, 27605, 27607, 27609, 27618, 27668, 27675, 27695, 27707, 27709, 27711, 27721, 27723, 27736, 27742, 27745, 27749, 27753, 27776, 27778, 27782, 27785, 27787, 27790, 27792, 27802, 27814, 27818, 27820, 27823, 27825, 27830, 27858, 27862, 27865, 27868, 27873, 27877, 27880, 27883, 27885, 27890, 27897, 27903, 27906, 27909, 27911, 27914, 27917, 27919, 27921, 27923, 27928, 27933, 27935, 27939, 27941, 27943, 27946, 27948, 27950, 27953, 27955, 27959, 27963, 27966, 27968, 27973, 27976, 27979, 27982, 27987, 27993, 27996, 28007, 28010, 28012, 28017, 28022, 28025, 28028, 28032, 28036, 28044, 28048, 28053, 28060, 28063, 28065, 28068, 28070, 28077, 28082, 28084, 28087, 28091, 28095, 28097, 28108, 28133, 28139, 28145, 28147, 28153, 28155, 28161, 28163, 28167, 28169, 28177, 28183, 28188, 28192, 28196, 28198, 28200, 28206, 28214, 28220, 28224, 28226, 28228, 28234, 28242, 28246, 28254, 28256, 28259, 28261, 28264, 28266, 28269, 28272, 28276, 28279, 28284, 28290, 28292, 28296, 28298, 28300, 28302, 28318, 28325, 28341, 28344, 28351, 28353, 28355, 28358, 28362, 28364, 28366, 28368, 28371, 28374, 28379, 28382, 28385, 28390, 28394, 28396, 28401, 28407, 28410, 28412, 28417, 28420, 28423, 28425, 28429, 28448, 28450, 28460, 28463, 28465, 28469, 28477, 28481, 28487, 28490, 28507, 28510, 28514, 28522, 28525, 28527, 28532, 28537, 28544, 28555, 28557, 28560, 28562, 28564, 28622, 28631, 28645, 28646, 28652, 28656, 28657, 28661, 28663, 28665, 28668, 28670, 28672, 28676, 28680, 28687, 28692, 28695, 28708, 28710, 28718, 28724, 28727, 28734, 28736, 28741, 28743, 28750, 28755, 28757, 28760, 28766, 28769, 28774, 28778, 28780, 28783, 28785, 28789, 28798, 28808, 28816, 28819, 28824, 28832, 28840, 28842, 28850, 28853, 28855, 28858, 28862, 28865, 28867, 28870, 28872, 28875, 28877, 28880, 28883, 28886, 28888, 28892, 28894, 28897, 28899, 28903, 28906, 28909, 28911, 28916, 28920, 28923, 28927, 28940, 28943, 28951, 28957, 28959, 28965, 28968, 28972, 28974, 28982, 28984, 28994, 28996, 29001, 29006, 29008, 29010, 29012, 29015, 29020, 29023, 29032, 29034, 29037, 29051, 29053, 29055, 29063, 29368, 29370, 29380, 29382, 29389, 29396, 29406, 29458, 29482, 29489, 29504, 29525, 29741, 29757, 29781, 29798, 29816, 29918, 29937, 29948, 29961, 29968, 29972, 29976, 29979, 29982, 29984, 29988, 30004, 30007, 30010, 30013, 30016, 30019, 30022, 30025, 30032, 30043, 30053, 30056, 30062, 30064, 30074, 30094, 30096, 30112, 30126, 30129, 30131, 30142, 30146, 30148, 30150, 30152, 30154, 30287, 30290, 30308, 30322, 30324, 30326, 30328, 30330, 30338, 30375, 30384, 30389, 30394, 30409, 30411, 30414, 30421, 30428, 30430, 30433, 30435, 30442, 30449, 30456, 30464, 30466, 30468, 30471, 30503, 30508, 30521, 30536, 30543, 30554, 30565, 30574, 30576, 30598, 30600, 30609, 30623, 30645, 30649, 30659, 30677, 30681, 30683, 30685, 30689, 30794, 30807, 30815, 30817, 30823, 30827, 30831, 30844, 31075, 31269, 31332, 31336, 31338, 31341, 31343, 31347, 31349, 31353, 31355, 31357, 31371, 31375, 31383, 31390, 31394, 31402, 31406, 31418, 31423, 31427, 31433, 31440, 31442, 31449, 31454, 31456, 31463, 31466, 31468, 31471, 31473, 31475, 31478, 31481, 31483, 31485, 31487, 31489, 31492, 31501, 31509, 31516, 31520, 31554, 31561, 31568, 31578, 31586, 31624, 31627, 31655, 31665, 31670, 31683, 31692, 31695, 31699, 31704, 31719, 31724, 31729, 31737, 31743, 31748, 31750, 31757, 31759, 31770, 31772, 31828, 31832, 31834, 31838, 31842, 31858, 31866, 31872, 31874, 31878, 31886, 31890, 31892, 31896, 31902, 31908, 31912, 31914, 31918, 31920, 31924, 31928, 31931, 31936, 31938, 31940, 31942, 31947, 31956, 31961, 31964, 31968, 31975, 31992, 32001, 32004, 32013, 32015, 32020, 32027, 32046, 32055, 32062, 32064, 32067, 32069, 32087, 32096, 32098, 32122, 32127, 32137, 32156, 32165, 32174, 32185, 32196, 32201, 32207, 32209, 32214, 32218, 32220, 32225, 32230, 32234, 32236, 32241, 32248, 32257, 32260, 32261, 32316, 32318, 32320, 32322, 32326, 32333, 32335, 32337, 32340, 32343, 32345, 32347, 32373, 32377, 32381, 32391, 32396, 32402, 32404, 32415, 32417, 32429, 32431, 32436, 32440, 32445, 32467, 32474, 32480, 32485, 32494, 32496, 32515, 32517, 32522, 32529, 32534, 32540, 32579, 32592, 32624, 32632, 32636, 32640, 32645, 32675, 32686, 32689, 32694, 32696, 32707, 32709, 32719, 32721, 32723, 32730, 32735, 32738, 32749, 32751, 32808, 32810, 32812, 32823, 32824, 32826, 32847, 32849, 32851, 32853, 32855, 32861, 32877, 32899, 32992, 33040, 33171, 33294, 33316, 33323, 33345, 33349, 33361, 33375, 33405, 33480, 33521, 33584, 33627, 33705, 33801, 33852, 33892, 33918, 33922, 33927, 33981, 34006, 34073, 34147, 34190, 34225, 34230, 34253, 34285, 34295, 34303, 34306, 34310, 34311, 34312, 34318, 34327, 34332, 34333, 34371, 34596, 34598, 34612, 34622, 34654, 34814, 34821, 34824, 34826, 34828, 34836, 34852, 34853, 34860, 34861, 34871, 34872, 34873, 34876, 34940, 34956, 35052, 35126, 35128, 35130, 35133, 35136, 35139, 35141, 35144, 35146, 35148, 35150, 35153, 35155, 35158, 35161, 35163, 35165, 35168, 35170, 35173, 35175, 35178, 35188, 35193, 35231, 35311, 35344, 35359, 35361, 35369, 35400, 35403, 35434, 35440, 35443, 35446, 35448, 35452, 35454, 35462, 35468, 35477, 35486, 35501, 35715, 35717, 35719, 35722, 35724, 35884, 35906, 35928, 35941, 35944, 35946, 35964, 35975, 35990, 35996, 36001, 36010, 36022, 36024, 36027, 36029, 36031, 36033, 36035, 36037, 36039, 36041, 36043, 36045, 36049, 36051, 36053, 36055, 36062, 36066, 36072, 36075, 36078, 36081, 36088, 36091, 36095, 36097, 36100, 36103, 36493, 36528, 36534, 36539, 36545, 36557, 36584, 36585, 36586, 36591, 36593, 36594, 36595, 36598, 36599, 36600, 36601, 36606, 36607, 36608, 36612, 36613, 36615, 36616, 36621, 36624, 36628, 36630, 36632, 36634, 36635, 36676, 36683, 36685, 36691, 36695, 36699, 36725, 36789, 36809, 37392, 37394, 37397, 37399, 37403, 37406, 37408, 37413, 37417, 37420, 37423, 37425, 37427, 37429, 37431, 37437, 37583, 37590, 37619, 37631, 37641, 37672, 37674, 37782, 37784, 37788, 37794, 37798, 37800, 37802, 37806, 37810, 37812, 37816, 37818, 37820, 37826, 37828, 37834, 37836, 37838, 37840, 37844, 37846, 37848, 37850, 37855, 37859, 37861, 37863, 37865, 37867, 37869, 37871, 37873, 37876, 37879, 37881, 37883, 37885, 37888, 37892, 37894, 37901, 37903, 37908, 37912, 37915, 37917, 37920, 37922, 37926, 37929, 37931, 37934, 37938, 37942, 37944, 37946, 37948, 37950, 37952, 37955, 37957, 37959, 37961, 37995, 37997, 38012, 38027, 38029, 38033, 38038, 38043, 38046, 38063, 38071, 38074, 38077, 38079, 38084, 38089, 38094, 38098, 38113, 38119, 38122, 38124, 38129, 38137, 38144, 38152, 38154, 38159, 38161, 38163, 38166, 38178, 38184, 38189, 38206, 38208, 38212, 38217, 38218, 38225, 38228, 38229, 38231, 38235, 38237, 38241, 38243, 38246, 38247, 38250, 38251, 38254, 38256, 38257, 38260, 38263, 38265, 38269, 38271, 38277, 38279, 38280, 38283, 38285, 38286, 38287, 38289, 38290, 38294, 38295, 38297, 38298, 38300, 38302, 38303, 38304, 38305, 38306, 38307, 38308, 38309, 38311, 38365, 38470, 38493, 38571, 38581, 38635, 38654, 38699, 38709, 38722, 38732, 38762, 38770, 38784, 38786, 38789, 38803, 38805, 38809, 38810, 38813, 38814, 38818, 38820, 38821, 38822, 38823, 38824, 38825, 38827, 38828, 38830, 38832, 38833, 38834, 38836, 38838, 38841, 38846, 38848, 38849, 38852, 38853, 38854, 38861, 38865, 38868, 38871, 38874, 38877, 38880, 38884, 38886, 38889, 38892, 38896, 38898, 38902, 38907, 38909, 38911, 38913, 38917, 38919, 38921, 38922, 38929, 38931, 38933, 38935, 38938, 38940, 38945, 38952, 38957, 38959, 38963, 38966, 38968, 38973, 38975, 38977, 38983, 38985, 38987, 38989, 38991, 38994, 38996, 38999, 39001, 39004, 39007, 39016, 39018, 39021, 39023, 39025, 39027, 39029, 39031, 39033, 39035, 39037, 39039, 39042, 39044, 39046, 39048, 39050, 39052, 39057, 39061, 39063, 39066, 39068, 39070, 39073, 39075, 39077, 39079, 39082, 39084, 39087, 39089, 39091, 39094, 39096, 39099, 39101, 39103, 39105, 39108, 39110, 39115, 39122, 39129, 39133, 39136, 39138, 39143, 39147, 39150, 39152, 39157, 39161, 39164, 39166, 39172, 39178, 39182, 39185, 39191, 39200, 39203, 39206, 39209, 39211, 39214, 39217, 39220, 39223, 39226, 39231, 39235, 39237, 39240, 39243, 39251, 39254, 39258, 39261, 39263, 39266, 39269, 39271, 39274, 39281, 39286, 39289, 39294, 39297, 39299, 39302, 39304, 39307, 39316, 39318, 39321, 39323, 39325, 39327, 39336, 39446, 39454, 39475, 39479, 39483, 39485, 39494, 39498, 39517, 39531, 39540, 39551, 39561, 39568, 39570, 39582, 39604, 39642, 39658, 39717, 39719, 39722, 39724, 39727, 39730, 39732, 39736, 39741, 39746, 39751, 39760, 39782, 39806, 39822, 39841, 39848, 39850, 39869, 39874, 39876, 39881, 39889, 40040, 40042, 40044, 40046, 40048, 40051, 40059, 40071, 40077, 40093, 40099, 40121, 40123, 40135, 40140, 40146, 40149, 40163, 40168, 40173, 40179, 40181, 40203, 40272, 40382, 40387, 40401, 40591, 40630, 40761, 40772, 40797, 40821, 40825, 40828, 40831, 40833, 40839, 40845, 40848, 40852, 40856, 40859, 40866, 40876, 40882, 40884, 40891, 40898, 40902, 40912, 40917, 40928, 40938, 40941, 40943, 40946, 40953, 40958, 40967, 40972, 40978, 40992, 41005, 41259, 41421, 41425, 42022, 42410, 42417, 42440, 43079, 43081, 43084, 43093, 43098, 43104, 43115, 43127, 43143, 43155, 43156, 43229, 43232, 43263, 43321, 43439, 43446, 43448, 43453, 43460, 43494, 44054, 44920, 44946, 45785, 45823, 45840, 45842, 45844, 45846, 45848, 45850, 45852, 45854, 45856, 45858, 45860, 45862, 45864, 45866, 45869, 45874, 45878, 45883, 45890, 45894, 45899, 45902, 45904, 45911, 45914, 45916, 45925, 45930, 45951, 46007, 46031, 46036, 46038, 46040, 46042, 46050, 46052, 46055, 46058, 46068, 46080, 46093, 46100, 46103, 46121, 46133, 46148, 46166, 46174, 46407, 46409, 46411, 46413, 46415, 46417, 46419, 46421, 46423, 46425, 46427, 46429, 46431, 46433, 46436, 46438, 46441, 46443, 46446, 46448, 46452, 46455, 46457, 46460, 46462, 46464, 46466, 46469, 46471, 46476, 46478, 46481, 46486, 46492, 46495, 46509, 46511, 46515, 46522, 46529, 46536, 46561, 46566, 46593, 46595, 46673, 46700, 46711, 46729, 48024, 49268, 49270, 49272, 49274, 49276, 49278, 49280, 49282, 49284, 49286, 49288, 49290, 49292, 49294, 49296, 49298, 49300, 49305, 49307, 49310, 49312, 49314, 49316, 49319, 49321, 49324, 49328, 49330, 49333, 49335, 49364, 49366, 49368, 49380, 49382, 49394, 49396, 49616, 49622, 49627, 52241, 52243, 52245, 52248, 52250, 52255, 52257, 52259, 52262, 52264, 52269, 52271, 52280, 52284) 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: A Word To The Wise

Afterpiece Title: The Deuce is in Him

Cast
Role: Major Belford Actor: Whitefield

Song: End I: a new cantata, Diana-Mrs Farrell

Music: End Epilogue: concerto on the violin-Fisher

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Worthy Actor: Whitefield

Afterpiece Title: The Padlock

Performances

Mainpiece Title: The Miser

Cast
Role: Harriet Actor: Mrs Whitefield

Afterpiece Title: The Royal Chace or Harlequin Skeleton

Dance: End: The Humours of New@Market with the Poney Races-Dagueville, Harris, Master Holland, Master Dagueville, Miss Ross, Sga Tinte

Performances

Mainpiece Title: The Beggars Opera

Cast
Role: Diana Trapes Actor: Mrs White.

Afterpiece Title: Cross Purposes

Dance: Hornpipe, as17771017; End: As17771001

Performances

Mainpiece Title: The Beggars Opera

Cast
Role: Diana Trapes Actor: Mrs White.

Afterpiece Title: The Reprisal

Dance: Hornpipe, as17771017; End II: As17771021

Song: As17771021

Performances

Mainpiece Title: The Beggars Opera

Cast
Role: Diana Trapes Actor: Mrs White.

Afterpiece Title: The Apprentice

Dance: Hornpipe, as17771017; End II: As17771008

Performances

Mainpiece Title: The Beggars Opera

Cast
Role: Diana Trapes Actor: Mrs White.

Afterpiece Title: The Reprisal

Dance: Hornpipe, as17771017; End II: As17771021

Performances

Mainpiece Title: The Beggars Opera

Cast
Role: Diana Trapes Actor: Mrs White.

Afterpiece Title: The Reprisal

Dance: Hornpipe, as17771017

Performances

Mainpiece Title: The Beggars Opera

Cast
Role: Diana Trapes Actor: Mrs White.

Afterpiece Title: St

Dance: Hornpipe, as17771017; End II: La Soiree a@la@Mode-Dagueville, Harris, Master Holland, Sga Tinte

Performances

Mainpiece Title: The Beggars Opera

Cast
Role: Diana Trapes Actor: Mrs White.

Afterpiece Title: Three Weeks after Marriage

Dance: Hornpipe, as17771017; End: As17771111

Performances

Mainpiece Title: Love Finds The Way

Afterpiece Title: Catherine and Petruchio

Cast
Role: Curtis Actor: Mrs White

Dance: End II: As17771111; End: The Humours of Leixlip, as17771008

Performances

Mainpiece Title: Love Finds The Way

Afterpiece Title: Catherine and Petruchio

Cast
Role: Curtis Actor: Mrs White

Dance: As17771111

Performances

Mainpiece Title: The Beggars Opera

Cast
Role: Diana Trapes Actor: Mrs White.

Afterpiece Title: The Norwood Gypsies

Dance: In: Hornpipe, as17771017; In afterpiece: Dancing, as17771125

Performances

Mainpiece Title: The Beggars Opera

Cast
Role: Diana Trapes Actor: Mrs White.

Afterpiece Title: The Norwood Gypsies

Dance: In: Hornpipe, as17771017; Afterpiece: Dancing, as17771125

Performances

Mainpiece Title: The Beggars Opera

Cast
Role: Diana Trapes Actor: Mrs White.

Afterpiece Title: The Norwood Gypsies

Dance: As17771125

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Worthy Actor: Whitefield

Afterpiece Title: The Norwood Gypsies

Dance: As17771125

Performances

Mainpiece Title: The Beggars Opera

Cast
Role: Diana Trapes Actor: Mrs White.

Afterpiece Title: The Norwood Gypsies

Dance: As17771125

Performances

Mainpiece Title: The Beggars Opera

Cast
Role: Diana Trapes Actor: Mrs White.

Afterpiece Title: The Norwood Gypsies

Dance: In: Hornpipe, as17771017; Afterpiece: Dancing, as17771125

Performances

Mainpiece Title: The Beggars Opera

Cast
Role: Diana Trapes Actor: Mrs White.

Afterpiece Title: The Mayor of Garratt

Dance: End: As17771104; Hornpipe, as17771017

Performances

Mainpiece Title: The Beggars Opera

Cast
Role: Diana Trapes Actor: Mrs White.

Afterpiece Title: The Minor

Dance: End: As17780121; Hornpipe, as17771017

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Mother Shipton

Dance: In: As17770929; In afterpiece: Langrish, Miss Besford [who danced in all subsequent performances]

Song: End IV: Solemn Dirge, as17770929, but _Reinhold, Battishill

Performances

Mainpiece Title: As You Like It

Afterpiece Title: Mother Shipton

Dance: End I: As17771222; In V: a Dance of Foresters-Dagueville

Performances

Mainpiece Title: Love Makes A Man Or The Fops Fortune

Afterpiece Title: Mother Shipton

Performances

Mainpiece Title: The Maid Of The Mill

Afterpiece Title: Mother Shipton

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: Mother Shipton