SELECT * FROM london_stages WHERE eventid IN (1205, 12476, 12478, 12481, 12483, 12487, 12489, 12491, 12493, 12500, 12502, 12506, 12512, 12521, 12527, 12546, 29162, 29835, 29838, 29840, 29844, 29848, 29851, 29853, 29881, 29886, 29888, 29890, 29892, 29894, 29899, 29901, 29903, 29907, 29909, 29912, 29914, 29927, 29929, 29960, 29969, 29978, 29981, 30006, 30009, 30028, 30055, 30057, 30081, 30114, 30120, 30145, 30151, 30321, 30343, 30346, 30348, 30351, 30355, 30357, 30360, 30362, 30365, 30376, 30383, 30393, 30400, 30403, 30405, 30408, 30436, 30455, 30467, 30502, 30504, 30507, 30509, 30513, 30517, 30520, 30526, 30532, 30535, 30537, 30546, 30553, 30557, 30569, 30580, 30585, 30592, 30597, 30606, 30622, 30627, 30633, 30636, 30641, 30646, 30653, 30658, 30665, 30678, 30684, 30695, 30697, 30791, 30876, 30886, 30891, 30893, 30898, 30905, 30912, 30916, 30919, 30924, 30930, 30933, 30935, 30937, 30940, 30942, 30944, 30947, 30950, 30954, 30956, 30958, 30961, 30966, 30973, 30991, 31003, 31007, 31009, 31015, 31017, 31023, 31066, 31069, 31072, 31074, 31076, 31079, 31082, 31085, 31087, 31089, 31091, 31100, 31102, 31106, 31116, 31120, 31123, 31126, 31131, 31133, 31139, 31151, 31158, 31162, 31182, 31194, 31208, 31214, 31216, 31223, 31229, 31255, 31279, 31337, 31340, 31342, 31346, 31354, 31358, 31360, 31362, 31368, 31370, 31376, 31378, 31380, 31401, 31403, 31405, 31413, 31415, 31419, 31422, 31424, 31430, 31437, 31439, 31441, 31443, 31445, 31448, 31451, 31453, 31455, 31457, 31459, 31462, 31465, 31467, 31470, 31472, 31474, 31477, 31480, 31482, 31484, 31486, 31491, 31494, 31496, 31500, 31502, 31504, 31506, 31508, 31510, 31515, 31519, 31521, 31523, 31526, 31533, 31535, 31540, 31544, 31546, 31548, 31550, 31553, 31556, 31558, 31560, 31562, 31564, 31567, 31569, 31571, 31574, 31577, 31580, 31583, 31585, 31587, 31589, 31591, 31594, 31597, 31599, 31602, 31605, 31608, 31611, 31614, 31617, 31620, 31623, 31626, 31629, 31632, 31639, 31642, 31648, 31651, 31657, 31673, 31684, 31689, 31694, 31700, 31703, 31705, 31708, 31711, 31718, 31720, 31723, 31728, 31731, 31733, 31736, 31740, 31742, 31745, 31747, 31753, 31763, 31767, 31771, 31825, 31827, 31833, 31839, 31843, 31845, 31847, 31851, 31855, 31859, 31861, 31863, 31867, 31871, 31873, 31875, 31877, 31879, 31883, 31889, 31891, 31917, 31932, 31935, 31937, 31939, 31941, 31944, 31949, 31951, 31953, 31977, 31985, 31993, 32007, 32009, 32026, 32047, 32057, 32059, 32081, 32088, 32111, 32143, 32148, 32152, 32171, 32184, 32191, 32195, 32198, 32204, 32208, 32215, 32221, 32226, 32238, 32243, 32247, 32256, 32258, 32312, 32323, 32327, 32341, 32342, 32344, 32360, 32362, 32368, 32374, 32407, 32411, 32416, 32447, 32481, 32495, 32509, 32512, 32518, 32521, 32549, 32554, 32563, 32565, 32575, 32588, 32593, 32600, 32605, 32613, 32623, 32631, 32635, 32642, 32656, 32660, 32664, 32666, 32669, 32680, 32683, 32685, 32688, 32698, 32701, 32722, 32743, 33327, 33336, 33341, 33355, 33383, 33388, 33406, 33409, 33411, 33416, 33420, 33423, 33425, 33433, 33437, 33441, 33443, 33446, 33448, 33451, 33453, 33455, 33457, 33460, 33462, 33465, 33467, 33469, 33471, 33474, 33476, 33479, 33489, 33491, 33494, 33496, 33498, 33501, 33510, 33517, 33524, 33529, 33534, 33572, 33604, 33613, 33626, 33657, 33667, 33681, 33685, 33693, 33698, 33700, 33702, 33707, 33710, 33713, 33717, 33721, 33806, 33814, 33819, 33821, 33823, 33841, 33847, 33849, 33853, 33857, 33873, 33875, 33884, 33889, 33891, 33901, 33915, 33924, 33926, 33935, 33938, 33940, 33943, 33945, 33948, 33960, 33962, 33967, 33974, 33976, 33978, 33980, 33982, 33984, 33986, 33989, 33991, 33994, 33998, 34000, 34003, 34005, 34012, 34022, 34024, 34045, 34067, 34069, 34072, 34085, 34130, 34146, 34155, 34166, 34168, 34170, 34178, 34182, 34204, 34207, 34234, 34237, 34258, 34261, 34349, 34358, 34366, 34388, 34395, 34398, 34404, 34408, 34411, 34417, 34434, 34441, 34457, 34466, 34469, 34471, 34474, 34476, 34478, 34521, 34546, 34565, 34579, 34601, 34609, 34617, 34668, 34684, 34713, 34714, 34730, 34739, 34757, 34762, 34773, 34780, 34787, 34794, 34816, 34888, 34890, 34902, 34904, 34910, 34912, 34914, 34916, 34918, 34920, 34922, 34924, 34928, 34932, 34936, 34940, 34942, 34944, 34952, 34962, 34992, 35013, 35029, 35032, 35034, 35037, 35039, 35043, 35049, 35058, 35063, 35071, 35075, 35077, 35079, 35081, 35084, 35086, 35089, 35091, 35093, 35098, 35109, 35119, 35133, 35144, 35148, 35155, 35158, 35180, 35183, 35185, 35196, 35198, 35203, 35208, 35211, 35214, 35219, 35224, 35228, 35251, 35287, 35290, 35295, 35300, 35349, 35355, 35366, 35369, 35499, 35514, 35519, 35523, 35525, 35542, 35546, 35552, 35559, 35563, 35567, 35569, 35571, 35580, 35582, 35584, 35593, 35608, 35613, 35622, 35627, 35632, 35646, 35651, 35660, 35666, 35673, 35675, 35682, 35684, 35687, 35689, 35692, 35694, 35697, 35700, 35703, 35705, 35713, 35727, 35729, 35732, 35734, 35737, 35739, 35742, 35762, 35767, 35775, 35784, 35835, 35845, 35866, 35890, 35895, 35902, 35925, 35928, 35930, 35935, 35938, 35950, 35955, 35968, 35990, 35995, 36110, 36112, 36119, 36123, 36126, 36128, 36130, 36132, 36134, 36136, 36138, 36142, 36146, 36150, 36162, 36167, 36169, 36171, 36177, 36180, 36182, 36185, 36187, 36189, 36191, 36194, 36196, 36198, 36200, 36202, 36204, 36207, 36209, 36211, 36213, 36215, 36218, 36220, 36222, 36224, 36226, 36228, 36233, 36238, 36240, 36242, 36244, 36249, 36254, 36256, 36283, 36285, 36288, 36290, 36292, 36297, 36299, 36302, 36304, 36306, 36309, 36311, 36314, 36316, 36318, 36320, 36325, 36327, 36330, 36339, 36344, 36363, 36366, 36373, 36377, 36404, 36407, 36408, 36435, 36466, 36474, 36495, 36527, 36538, 36553, 36559, 36637, 36642, 36646, 36658, 36679, 36693, 36697, 36701, 36703, 36705, 36709, 36713, 36718, 36723, 36727, 36732, 36785, 36788, 36791, 36796, 36799, 36801, 36803, 36805, 36807, 36809, 36812, 36814, 36817, 36819, 36821, 36823, 36826, 36828, 36833, 36838, 36840, 36842, 36845, 36847, 36849, 36861, 36863, 36872, 36887, 36896, 36903, 36921, 36973, 36975, 37003, 37026, 37067, 37072, 37081, 37086, 37095, 37097, 37111, 37215, 37217, 37224, 37234, 37236, 37238, 37244, 37248, 37256, 37258, 37261, 37267, 37269, 37271, 37273, 37275, 37277, 37279, 37281, 37285, 37297, 37306, 37311, 37318, 37325, 37327, 37330, 37339, 37346, 37348, 37350, 37353, 37355, 37358, 37360, 37362, 37364, 37367, 37369, 37372, 37374, 37379, 37381, 37383, 37385, 37389, 37392, 37394, 37397, 37399, 37403, 37406, 37408, 37413, 37417, 37420, 37423, 37425, 37427, 37429, 37431, 37434, 37437, 37446, 37449, 37452, 37454, 37456, 37466, 37471, 37473, 37478, 37480, 37486, 37489, 37491, 37501, 37504, 37525, 37529, 37534, 37556, 37573, 37575, 37583, 37585, 37590, 37607, 37617, 37619, 37627, 37631, 37633, 37641, 37644, 37647, 37654, 37668, 37672, 37674, 37676, 37678, 37782, 37802, 37806, 37818, 37820, 37828, 37838, 37840, 37842, 37844, 37871, 37873, 37876, 37879, 37883, 37888, 37892, 37901, 37903, 37908, 37912, 37915, 37917, 37926, 37929, 37931, 37942, 37944, 37946, 37948, 37950, 37952, 37955, 37957, 37959, 37961, 37988, 37992, 37995, 37997, 38001, 38009, 38012, 38014, 38017, 38019, 38024, 38043, 38048, 38074, 38089, 38124, 38129, 38144, 38152, 38161, 38173, 38178, 38189, 38191, 38201, 38208, 38214, 38222, 38240, 38312, 38314, 38322, 38324, 38331, 38333, 38344, 38372, 38374, 38382, 38391, 38393, 38395, 38400, 38402, 38405, 38408, 38411, 38413, 38416, 38418, 38421, 38423, 38426, 38428, 38432, 38435, 38437, 38440, 38442, 38446, 38449, 38451, 38454, 38456, 38460, 38463, 38468, 38470, 38474, 38491, 38493, 38495, 38499, 38501, 38503, 38506, 38508, 38512, 38517, 38522, 38526, 38529, 38531, 38537, 38541, 38544, 38548, 38552, 38557, 38562, 38566, 38571, 38574, 38576, 38581, 38584, 38586, 38594, 38604, 38609, 38620, 38625, 38628, 38630, 38635, 38650, 38654, 38659, 38664, 38674, 38676, 38681, 38683, 38690, 38693, 38695, 38699, 38707, 38712, 38715, 38725, 38727, 38735, 38737, 38742, 38744, 38751, 38756, 38759, 38767, 38772, 38779, 38786, 38791, 38868, 38871, 38886, 38889, 38896, 38909, 38922, 38935, 38943, 38949, 38954, 38957, 38968, 38971, 38977, 38980, 38983, 38987, 38991, 38994, 39004, 39016, 39018, 39027, 39037, 39039, 39048, 39052, 39057, 39070, 39077, 39084, 39091, 39096, 39099, 39108, 39124, 39182, 39185, 39200, 39206, 39211, 39220, 39223, 39226, 39229, 39231, 39237, 39251, 39269, 39277, 39281, 39297, 39313, 39323, 39330, 39448, 39452, 39454, 39473, 39490, 39503, 39514, 39523, 39531, 39540, 39610, 39622, 39633, 39635, 39638, 39647, 39649, 39664, 39669, 39674, 39685, 39688, 39691, 39694, 39696, 39698, 39700, 39703, 39705, 39708, 39710, 39712, 39714, 39717, 39727, 39732, 39736, 39744, 39755, 39760, 39770, 39773, 39782, 39798, 39808, 39813, 39819, 39824, 39829, 39833, 39850, 39855, 39860, 39867, 39872, 39878, 39881, 39884, 39899, 40350, 40355, 40372, 40377, 40384, 40408, 40444, 40598, 40695, 41459, 44741, 44861, 44950, 45054, 46274, 46276, 46304, 46342, 46344, 46346, 46348, 46354, 46356, 46358, 46366, 46382, 46386, 46402, 46406, 46412, 46414, 46416, 46418, 46420, 46422, 46424, 46426, 46428, 46430, 46432, 46435, 46437, 46440, 46442, 46445, 46447, 46449, 46451, 46454, 46459, 46461, 46463, 46468, 46473, 46477, 46482, 46487, 46489, 46494, 46503, 46521, 46535, 46592, 46616, 46633, 46653, 46851, 46874, 46920, 46942, 46954, 46956, 46960, 46964, 46966, 46968, 46970, 46972, 46982, 46984, 46986, 46988, 46992, 46994, 46996, 46998, 47000, 47002, 47004, 47006, 47010, 47012, 47016, 47018, 47022, 47024, 47028, 47030, 47034, 47040, 47042, 47044, 47046, 47123, 47127, 47143, 47160, 47178, 47197, 47201, 47211, 47217, 47219, 47225, 47234, 47265, 47282, 47284, 47288, 47300, 48713, 48733, 48753) 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 New Way To Pay Old Debts

Cast
Role: Watchall Actor: Fox.

Afterpiece Title: The Male Coquette

Song: II: Ode to Echo (Dr Hayes)-Miss Young

Dance: III: Hornpipe-Harrison; IV: A Minuet-two of Harrison's Scholars

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: Henry Viii

Afterpiece Title: Harlequin's Invasion

Dance: II: The Cow Keepers, as17600313

Performances

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The Minor

Cast
Role: unassigned Actor: Fox.

Afterpiece Title: [The Devil to Pay

Dance: [I: The Mad Doctor, as17601014; II: The Prussian Camp, as17601117

Performances

Mainpiece Title: The Minor

Cast
Role: unassigned Actor: Fox.

Afterpiece Title: A Duke and no Duke

Dance: I: The Colliers, as17601024; II: The Mad Doctor, as17601014

Performances

Mainpiece Title: The Minor

Cast
Role: unassigned Actor: Fox.

Afterpiece Title: The Intriguing Chambermaid

Dance: I: The Colliers, as17601024; II: The Mad Doctor, as17601014

Music:

Song: The Tears and Triumphs of Parnassus, as17601117

Performances

Mainpiece Title: The Minor

Cast
Role: unassigned Actor: Fox.

Afterpiece Title: The Devil to Pay

Dance: I: The Colliers, as17601024; II: The Prussian Camp, as17601117

Performances

Mainpiece Title: The Minor

Cast
Role: unassigned Actor: Fox.

Afterpiece Title: The Double Disappointment

Dance: I: The Cow Keepers, as17601008; II: The Prussian Camp, as17601117

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: Harlequin Ranger

Cast
Role: The Others Actor: Fox, _Atkins

Performances

Mainpiece Title: The Minor

Cast
Role: unassigned Actor: Fox.

Afterpiece Title: Harlequin Ranger

Cast
Role: The Others Actor: Fox, _Atkins

Dance: I: The Mad Doctor, as17601014

Song: A Cantata-Miss Young

Performances

Mainpiece Title: The Provoked Wife

Afterpiece Title: Harlequin Ranger

Cast
Role: The Others Actor: Fox, _Atkins

Performances

Mainpiece Title: The Minor

Cast
Role: unassigned Actor: Fox.

Afterpiece Title: Harlequin Ranger

Cast
Role: The Others Actor: Fox, _Atkins

Dance: I: The Italian Gardiners-Grimaldi, Miss Baker; II: The Colliers, as17601024

Performances

Mainpiece Title: The Minor

Cast
Role: unassigned Actor: Fox.

Afterpiece Title: Polly Honeycomb

Dance: I: The Colliers, as17601008; II: The Italian Gardiners, as17601203

Performances

Mainpiece Title: The Rehearsal

Cast
Role: Others Actor:

Afterpiece Title: Polly Honeycombe

Dance: II: The Mad Doctor, as17601014; End: The Itahian Gardiners, as17601203

Performances

Mainpiece Title: King John

Cast
Role: Essex Actor: Fox

Afterpiece Title: Polly Honeycomb

Performances

Mainpiece Title: King John

Cast
Role: Essex Actor: Fox

Afterpiece Title: Polly Honeycomb

Performances

Mainpiece Title: The Minor

Cast
Role: unassigned Actor: Fox.

Afterpiece Title: The Guardian

Dance: II: The Cow Keepers, as17601008

Performances

Mainpiece Title: King John

Cast
Role: Essex Actor: Fox

Performances

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The Minor

Cast
Role: unassigned Actor: Fox.

Afterpiece Title: Polly Honeycombe

Dance: I: The Mad Doctor, as17601014; II: The Cow Keepers, as17601008

Performances

Mainpiece Title: The Minor

Cast
Role: unassigned Actor: Fox.

Afterpiece Title: Polly Honeycombe

Song: I: Miss Young

Dance: II: The Italian Gardiners, as17601203

Performances

Mainpiece Title: The Minor

Cast
Role: unassigned Actor: Fox.

Afterpiece Title: Lethe

Song: I: Miss Young

Dance: I: A New Pantomime Dance call'd The Enchanted Peasant-Sg Tioli, Miss Baker

Performances

Mainpiece Title: The Jealous Wife

Cast
Role: Servant Actor: Fox

Dance: New Pantomime Dance call'd%The Cuckow-Grimaldi, Miss Baker

Performances

Mainpiece Title: The Jealous Wife

Cast
Role: Servant Actor: Fox

Dance: TThe Cuckow, as17610212