SELECT * FROM london_stages WHERE eventid IN (12078, 12083, 12089, 12095, 12108, 12118, 12123, 12134, 12138, 12148, 12172, 15027, 16661, 16665, 16668, 16673, 16678, 16697, 16725, 16799, 16804, 16808, 16812, 16815, 16818, 16822, 16826, 16829, 16836, 16840, 16844, 16849, 16853, 16857, 16861, 16865, 16869, 16893, 16972, 16980, 16984, 17053, 17059, 17071, 17080, 17093, 17101, 17155, 17160, 17164, 17168, 17176, 17184, 17193, 17202, 17219, 17223, 17227, 17239, 17247, 17251, 17278, 17284, 17287, 17292, 17304, 17314, 17317, 17320, 17332, 17341, 17543, 17548, 17551, 17554, 17560, 17564, 17570, 17574, 17581, 17584, 17590, 17594, 17611, 17616, 17640, 17643, 17651, 17658, 17668, 17671, 17674, 17677, 17683, 17694, 17721, 17724, 17728, 17731, 17735, 17739, 17742, 17746, 17754, 17761, 17765, 17776, 17782, 17791, 17795, 17851, 17856, 17861, 17940, 17954, 18123, 18261, 18266, 18299, 18306, 18309, 18317, 18324, 18327, 18335, 18338, 18345, 18348, 18379, 18382, 18388, 18391, 18398, 18408, 18415, 18424, 18427, 18436, 18440, 18449, 18504, 18516, 18664, 18674, 19036, 19041, 19043, 19046, 19048, 19051, 19056, 19058, 19065, 19068, 19075, 19116, 19123, 19149, 19281, 19283, 19285, 19291, 19293, 19295, 19302, 19310, 19314, 19316, 19319, 19321, 19323, 19325, 19327, 19329, 19331, 19333, 19335, 19337, 19339, 19341, 19343, 19349, 19378, 19380, 19382, 19384, 19387, 19389, 19395, 19408, 19410, 19412, 19421, 19426, 19428, 19430, 19433, 19435, 19437, 19439, 19441, 19443, 19445, 19447, 19449, 19452, 19454, 19456, 19458, 19465, 19468, 19474, 19476, 19479, 19481, 19483, 19485, 19487, 19489, 19492, 19494, 19496, 19498, 19500, 19502, 19535, 19537, 19544, 19548, 19554, 19612, 19622, 19626, 19749, 19753, 19763, 19766, 19768, 19770, 19772, 19789, 19805, 19810, 19815, 19832, 19839, 19842, 19855, 19858, 19860, 19861, 19863, 19865, 19867, 19868, 19871, 19888, 19890, 19895, 19897, 19899, 19902, 19903, 19906, 19908, 19911, 19913, 19916, 19918, 19921, 20024, 20048, 20062, 20416, 20419, 20422, 20426, 20430, 20442, 20446, 20449, 20458, 20462, 20466, 20483, 20487, 20498, 20506, 20511, 20517, 20521, 20555, 20571, 20577, 20584, 20638, 20764, 20767, 20770, 20772, 20775, 20800, 20806, 20818, 20868, 20873, 20876, 20879, 20887, 20893, 20896, 20899, 20903, 20906, 20912, 20918, 20935, 20945, 20949, 20952, 20965, 20968, 20981, 21612, 21618, 21624, 21627, 21630, 21652, 21660, 21668, 21675, 21688, 21756, 21762, 21775, 21833, 21835, 21840, 21972, 21975, 21977, 21979, 21984, 21987, 21989, 21991, 21993, 22003, 22004, 22009, 22018, 22051, 22059, 22061, 22066, 22069, 22079, 22109, 22139, 22152, 22169, 22177, 22222, 22227, 22261, 22273, 22349, 22356, 22358, 22359, 22373, 22377, 22379, 22386, 22391, 22446, 22459, 22468, 22475, 22478, 22481, 22484, 22490, 22494, 22497, 22529, 22535, 22538, 22543, 22546, 22549, 22559, 22562, 22568, 22571, 22575, 22578, 22581, 22584, 22590, 22592, 22596, 22599, 22602, 22606, 22613, 22621, 22666, 22673, 22679, 22691, 22709, 22722, 22734, 22761, 22764, 22779, 22787, 22795, 22877, 22880, 22886, 22891, 22894, 22900, 22914, 22933, 23001, 23027, 23030, 23033, 23050, 23053, 23056, 23063, 23068, 23077, 23111, 23114, 23187, 23229, 23236, 23243, 23269, 23532, 23537, 23543, 23546, 23591, 23714, 23728, 23744, 23747, 23812, 23826, 23842, 24006, 24009, 24011, 24025, 24027, 24034, 24042, 24056, 24062, 24066, 24069, 24090, 24100, 24104, 24110, 24119, 24122, 24125, 24131, 24134, 24140, 24143, 24146, 24151, 24157, 24162, 24170, 24178, 24180, 24198, 24201, 24211, 24367, 24371, 24380, 24384, 24401, 24404, 24408, 24437, 24489, 24494, 24497, 24516, 24537, 24562, 24565, 24719, 24917, 24919, 24924, 24936, 24938, 24951, 24971, 24974, 24977, 24979, 24982, 24985, 24988, 24991, 24997, 24999, 25002, 25004, 25007, 25009, 25011, 25013, 25016, 25018, 25021, 25023, 25025, 25027, 25030, 25032, 25034, 25036, 25039, 25041, 25043, 25045, 25048, 25050, 25052, 25054, 25056, 25058, 25060, 25062, 25064, 25066, 25069, 25071, 25073, 25075, 25077, 25080, 25082, 25085, 25087, 25089, 25091, 25093, 25095, 25097, 25099, 25103, 25105, 25107, 25109, 25111, 25113, 25115, 25118, 25120, 25122, 25124, 25126, 25129, 25132, 25135, 25137, 25139, 25141, 25144, 25147, 25149, 25152, 25155, 25158, 25160, 25163, 25166, 25169, 25173, 25176, 25179, 25184, 25188, 25193, 25198, 25211, 25214, 25241, 25250, 25256, 25263, 25296, 25392, 25394, 25396, 25402, 25408, 25412, 25423, 25426, 25430, 25432, 25436, 25438, 25446, 25470, 25474, 25482, 25486, 25491, 25493, 25495, 25497, 25499, 25501, 25503, 25509, 25511, 25513, 25515, 25517, 25519, 25527, 25531, 25538, 25540, 25542, 25544, 25549, 25555, 25557, 25565, 25567, 25569, 25575, 25577, 25581, 25588, 25590, 25598, 25602, 25605, 25610, 25615, 25619, 25623, 25634, 25672, 25683, 25708, 25714, 25748, 25751, 25754, 25756, 25760, 25767, 25769, 25773, 25779, 25783, 25787, 25793, 25795, 25797, 25799, 25801, 25809, 25811, 25815, 25817, 25821, 25823, 25826, 25832, 25834, 25837, 25839, 25841, 25843, 25845, 25847, 25849, 25851, 25853, 25855, 25874, 25887, 25894, 25897, 25903, 25908, 25910, 25913, 25915, 25917, 25924, 25926, 25933, 25938, 25942, 25949, 25953, 26068, 26105, 26197, 26199, 26210, 26212, 26218, 26222, 26236, 26238, 26240, 26242, 26244, 26246, 26285, 26288, 26290, 26293, 26295, 26297, 26303, 26312, 26318, 26321, 26324, 26327, 26351, 26353, 26356, 26382, 26387, 26578, 26595, 26607, 26801, 26815, 26820, 26824, 26844, 26849, 26853, 26858, 26867, 26899, 26904, 26920, 26929, 26950, 26960, 26975, 27027, 27062, 27235, 27237, 27247, 27255, 27270, 27277, 27284, 27287, 27290, 27341, 27343, 27351, 27354, 27407, 27412, 27576, 27595, 27699, 27701, 27705, 27709, 27711, 27715, 27721, 27725, 27731, 27738, 27766, 27768, 27771, 27778, 27818, 27820, 27823, 27825, 27871, 27993, 28058, 28065, 28100, 28105, 28171, 28175, 28181, 28188, 28194, 28196, 28510, 28522, 28649, 28654, 28674, 28678, 28706, 28713, 28724, 28732, 28835, 28984, 29006, 29010, 29017, 29173, 29180, 29190, 29196, 29415, 29519, 29787, 29852, 29854, 29858, 29860, 29862, 29865, 29869, 29871, 29875, 29878, 29882, 29884, 29887, 29889, 29891, 29893, 29900, 29904, 29906, 29908, 29913, 29915, 29918, 29935, 29942, 29953, 29957, 29959, 29963, 29970, 29982, 29984, 29992, 29995, 29998, 30001, 30004, 30010, 30022, 30025, 30029, 30053, 30056, 30064, 30089, 30099, 30101, 30107, 30112, 30117, 30126, 30131, 30144, 30146, 30148, 30150, 30152, 30154, 30314, 30316, 30318, 30320, 30322, 30326, 30328, 30330, 30375, 30384, 30841, 30844, 30846, 30848, 30850, 30853, 30855, 30857, 30859, 30863, 30866, 30868, 30871, 30873, 30875, 30877, 30879, 30881, 30883, 30885, 30887, 30889, 30892, 31048, 31050, 31053, 31058, 31060, 31064, 31075, 31083, 31088, 31090, 31098, 31103, 31110, 31113, 31117, 31124, 31127, 31188, 31217, 31252, 31260, 31398, 31402, 31404, 31406, 31408, 31410, 31412, 31416, 31425, 31429, 31436, 31438, 31452, 31456, 31460, 31463, 31501, 31503, 34524, 34526, 34528, 34530, 34532, 34534, 34537, 34539, 34542, 34544, 34548, 34551, 34553, 34556, 34558, 34560, 34576, 34584, 34586, 34588, 34590, 34620, 34622, 34635, 34637, 34648, 34670, 34697, 34721, 34750, 34768, 34778, 34792, 34813, 34818, 35159, 35828, 35859) 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 Stratagem

Afterpiece Title: Merlin's Cave

Cast
Role: Pierrot Actor: LaLauze.

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Merlin's Cave

Cast
Role: Pierrot Actor: LaLauze.

Performances

Mainpiece Title: Lady Jane Gray

Afterpiece Title: The Fair

Performances

Mainpiece Title: The Refusal; Or, The Lady's Philosophy

Afterpiece Title: The Fair

Performances

Mainpiece Title: Tamerlane

Afterpiece Title: The Fair

Performances

Mainpiece Title: Tamerlane

Afterpiece Title: The Fair

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: The Fair

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Fair

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Fair

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Fair

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Fair

Dance: LLes Charboniers, as17521028

Performances

Mainpiece Title: Othello

Afterpiece Title: The Fair

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The Fair

Dance: Maranesi, Sga Bugiani

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Fair

Dance: Maranesi, Sga Bugiani

Performances

Mainpiece Title: The Miser

Afterpiece Title: The Necromancer; or, Harlequin Dr Faustus

Cast
Role: Miller Actor: LaLauze
Role: Punch Actor: LaLauze.

Dance: New Grand Ballet Les Chasseurs Allemandes-Cooke, Miss Hilliard. Being her first appearance on the stage this season

Performances

Mainpiece Title: The Pilgrim

Afterpiece Title: Harlequin Dr Faustus

Cast
Role: Miller Actor: LaLauze
Role: Punch Actor: LaLauze.

Performances

Mainpiece Title: The Fair Quaker Of Deal; Or, The Humours Of The Navy

Afterpiece Title: Harlequin Dr Faustus

Cast
Role: Miller Actor: LaLauze
Role: Punch Actor: LaLauze.

Dance: As17521207

Performances

Mainpiece Title: The Old Batchelor

Afterpiece Title: Harlequin Dr Faustus

Cast
Role: Miller Actor: LaLauze
Role: Punch Actor: LaLauze.

Dance: As17521028

Performances

Mainpiece Title: The Siege Of Damascus

Afterpiece Title: Harlequin Dr Faustus

Cast
Role: Miller Actor: LaLauze
Role: Punch Actor: LaLauze.

Dance: As17521207

Performances

Mainpiece Title: The Provok'd Wife

Afterpiece Title: Harlequin Dr Faustus

Cast
Role: Miller Actor: LaLauze
Role: Punch Actor: LaLauze.

Dance: GGrand Scots Ballet-Cooke, Miss Hillyard

Performances

Mainpiece Title: The Unhappy Favourite; Or, The Earl Of Essex

Afterpiece Title: Harlequin Dr Faustus

Cast
Role: Miller Actor: LaLauze
Role: Punch Actor: LaLauze.

Performances

Mainpiece Title: The Fair Quaker Of Deal

Afterpiece Title: Merlin's Cave; or, Harlequin Skeleton

Cast
Role: Pierrot Actor: LaLauze.

Dance: As17521219

Performances

Mainpiece Title: The Committee

Afterpiece Title: Harlequin Dr Faustus

Cast
Role: Miller Actor: LaLauze
Role: Punch Actor: LaLauze.

Dance: As17521216

Performances

Mainpiece Title: Theodosius

Afterpiece Title: Harlequin Skeleton

Cast
Role: Pierrot Actor: LaLauze.

Dance: GGrand Scots Ballet, as17521216

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: Harlequin Skeleton

Cast
Role: Pierrot Actor: LaLauze.