SELECT * FROM london_stages WHERE eventid IN (20166, 20169, 20172, 20175, 20178, 20184, 20187, 20208, 20242, 20248, 20292, 20295, 20311, 20326, 20347, 20359, 20398, 20415, 20421, 20438, 20461, 20805, 20814, 20817, 20832, 20895, 20898, 20902, 20905, 20908, 20911, 20914, 20917, 20928, 20937, 20948, 20951, 20960, 20990, 21000, 21013, 21020, 21041, 21059, 21086, 21092, 21096, 21099, 21103, 21119, 21172, 21184, 21525, 21532, 21538, 21545, 21588, 21599, 21615, 21683, 21793, 22020, 22025, 22028, 22033, 22035, 22039, 22057, 22076, 22193, 22216, 22316, 22446, 22459, 22468, 22478, 22484, 22494, 22497, 22543, 22559, 22621, 22622, 22626, 22629, 22633, 22637, 22640, 22645, 22648, 22651, 22674, 22759, 22764, 22795, 22966, 22969, 24292, 24298, 24301, 24302, 24303, 24304, 24305, 24306, 24308, 24309, 24310, 24311, 24312, 24313, 24315, 24316, 24764, 24771, 24775, 24779, 24789, 24796, 24799, 25127, 25133, 25142, 25153, 25164, 25170, 25182, 25185, 25195, 29856, 31368, 31380, 31403, 31437, 31698, 31745, 31783, 31792, 31793, 31804, 31806, 31809, 31814, 31823, 31857, 31881, 31889, 31897, 31909, 31925, 31932, 31935, 31937, 31941, 31946, 31951, 31972, 31982, 32003, 32030, 32036, 32041, 32066, 32076, 32083, 32086, 32090, 32095, 32111, 32114, 32148, 32152, 32158, 32171, 32181, 32184, 32198, 32204, 32206, 32211, 32221, 32233, 32235, 32252, 32256, 32319, 32334, 32344, 32354, 32356, 32364, 32376, 32380, 32393, 32411, 32416, 32452, 32471, 32484, 32490, 32493, 32498, 32504, 32509, 32512, 32518, 32521, 32558, 32588, 32593, 32600, 32613, 32635, 32639, 32642, 32653, 32683, 32701, 32708, 32710, 32734, 32743, 32748, 34259, 34260, 34265, 34268, 34271, 34273, 34274, 34276, 34278, 34279, 34281, 34284, 34285, 34286, 34288, 34290, 34292, 34293, 34294, 34295, 34296, 34298, 34300, 34301, 34302, 34303, 34305, 34306, 34307, 34310, 34311, 34312, 34316, 34318, 34320, 34321, 34323, 34325, 34326, 34327, 34329, 34331, 34332, 34333, 34334, 34512, 35557, 38272, 38273, 38308, 38314, 38322, 38328, 38338, 38348, 38374, 38377, 38379, 38384, 38391, 38393, 38395, 38400, 38405, 38406, 38480, 38497, 38597, 38614, 38710, 38725, 38735, 38737, 38762, 38770, 38780, 38807, 38813, 38814, 38818, 38819, 38820, 38821, 38822, 38823, 38824, 38825, 38827, 38829, 38830, 38832, 38833, 38836, 38837, 38843, 38848, 38849, 38854, 38855, 38857, 38859, 38880, 38881, 38884, 38892, 38898, 38902, 38913, 38917, 38919, 38921, 38933, 38938, 38959, 38963, 38985, 39009, 39021, 39044, 39046, 39063, 39066, 39068, 39073, 39091, 39094, 39101, 39105, 39122, 39129, 39133, 39136, 39138, 39143, 39147, 39152, 39157, 39161, 39166, 39172, 39178, 39185, 39191, 39203, 39206, 39209, 39220, 39226, 39231, 39261, 39274, 39281, 39283, 39292, 39294, 39304, 39309, 39310, 39334, 39336, 39338, 39342, 39348, 39351, 39355, 39376, 39383, 39388, 39392, 39398, 39399, 39400, 39401, 39402, 39403, 39404, 39405, 39410, 39413, 39417, 39419, 39421, 39422, 39424, 39425, 39426, 39427, 39428, 39429, 39430, 39431, 39432, 39434, 39435, 39436, 39437, 39438, 39439, 39441, 39442, 39443, 39444, 39448, 39452, 39463, 39464, 39467, 39477, 39492, 39496, 39507, 39512, 39542, 39573, 39575, 39577, 39579, 39584, 39587, 39589, 39593, 39596, 39598, 39601, 39606, 39608, 39612, 39614, 39619, 39624, 39630, 39644, 39652, 39654, 39656, 39661, 39676, 39679, 39681, 39685, 39698, 39705, 39714, 39717, 39722, 39746, 39755, 39773, 39787, 39798, 39827, 39841, 39848, 39850, 39855, 39858, 39860, 39864, 39867, 39876, 39878, 39884, 39887, 39890, 39895, 39905, 39920, 39922, 39927, 39928, 39932, 39934, 39943, 39945, 39946, 39950, 39952, 39955, 39956, 39958, 39959, 39965, 39967, 39969, 39971, 39976, 39980, 39983, 39991, 39994, 39997, 40002, 40003, 40004, 40007, 40010, 40024, 40032, 40038, 40040, 40051, 40057, 40059, 40075, 40079, 40083, 40085, 40105, 40156, 40170, 40173, 40188, 40195, 40197, 40208, 40212, 40217, 40226, 40236, 40243, 40254, 40259, 40279, 40285, 40292, 40305, 40316, 40326, 40331, 40338, 40369, 40396, 40406, 40424, 40448, 40450, 40465, 40467, 40469, 40471, 40472, 40473, 40479, 40480, 40481, 40483, 40486, 40487, 40489, 40492, 40494, 40495, 40496, 40498, 40499, 40500, 40501, 40502, 40503, 40504, 40506, 40507, 40508, 40509, 40510, 40511, 40512, 40513, 40514, 40516, 40517, 40518, 40519, 40520, 40523, 40524, 40525, 40526, 40527, 40529, 40531, 40532, 40533, 40534, 40536, 40538, 40539, 40540, 40542, 40543, 40544, 40545, 40546, 40547, 40548, 40549, 40550, 40551, 40552, 40553, 40554, 40555, 40556, 40558, 40559, 40560, 40561, 40562, 40584, 40587, 40593, 40602, 40604, 40608, 40611, 40617, 40619, 40634, 40638, 40644, 40651, 40658, 40672, 40688, 40711, 40712, 40714, 40719, 40734, 40741, 40772, 40813, 40819, 40856, 40866, 40880, 40891, 40895, 40898, 40900, 40902, 40907, 40912, 40917, 40920, 40933, 40938, 40951, 40980, 40985, 40999, 41010, 41197, 41459, 41520, 41552, 41557, 41559, 41988, 42735, 43437, 43679, 44861, 45537, 45547, 45836, 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, 46492, 46511, 46536, 46566, 46593, 46700, 46711, 46729, 46844, 46846, 46847, 46849, 46852, 46854, 46861, 46895, 46909, 47063, 47198, 47289, 47309, 47320, 47326, 47582, 47584, 47586, 47587, 47589, 47591, 47593, 47595, 47597, 47600, 47603, 47605, 47607, 47609, 47611, 47614, 47616, 47619, 47621, 47623, 47625, 47628, 47631, 47633, 47635, 47637, 47639, 47641, 47649, 47665, 47688, 47690, 48015, 48023, 48032, 48278, 48285, 48289, 48294, 48299, 48349, 48416, 48418, 48443, 48747, 48749, 48754, 48755, 48757, 48759, 48761, 48766, 48767, 48769, 48771, 48774, 48775, 48777, 48779, 48781, 48783, 48785, 48787, 48789, 48791, 48793, 48796, 48798, 48801, 48803, 48805, 48810, 48812, 48815, 48817, 48819, 48821, 48826, 48828, 48830, 48835, 48851, 48856, 48865, 48870, 48877, 48902, 48916, 48923, 48930, 48945, 48952, 48959, 48961, 48980, 48988, 48990, 48993, 49009, 49014, 49021, 49023, 49033, 49038, 49041, 49051, 49053, 49056, 49066, 49069, 49077, 49081, 49083, 49086, 49090, 49100, 49445, 49449, 49454, 49462, 49642, 49797, 49801, 49811, 49819, 49837, 49849, 49937, 49951, 49953, 49956, 49958, 49960, 49962, 49965, 49967, 49970, 49972, 49974, 49977, 49979, 49980, 49982, 49983, 49984, 49985, 49986, 49987, 49988, 49989, 49991, 49993, 49994, 49997, 49998, 50000, 50001, 50003, 50004, 50005, 50006, 50009, 50010, 50012, 50013, 50015, 50016, 50018, 50019, 50022, 50023, 50025, 50026, 50028, 50029, 50030, 50031, 50035, 50038, 50041, 50044, 50048, 50052, 50070, 50079, 50089, 50092, 50101, 50104, 50105, 50107, 50115, 50117, 50120, 50122, 50128, 50130, 50134, 50137, 50148, 50166, 50205, 50208, 50367, 50369, 50375, 50379, 50381, 50390, 50397, 50399, 50403, 50409, 50417, 50511, 50592, 50596, 50601, 50610, 50615, 50619, 50627, 50631, 50634, 50637, 50639, 50643, 50646, 50649, 50651, 50655, 50658, 50661, 50687, 50689, 50692, 50706, 50713, 50730, 50735, 50743, 50746, 50748, 50751, 50761, 50773, 50781, 50783, 50785, 50789, 50794, 50796, 50799, 50960, 50964, 50974, 51004, 51015, 51035, 51044, 51051, 51089, 51103, 51106, 51109, 51111, 51113, 51115, 51120, 51123, 51125, 51127, 51129, 51132, 51134, 51137, 51141, 51146, 51149, 51151, 51153, 51155, 51160, 51163, 51165, 51167, 51169, 51174, 51178, 51181, 51186, 51190, 51193, 51198, 51202, 51205, 51210, 51217, 51220, 51222, 51233, 51236, 51240, 51248, 51251, 51253, 51260, 51262, 51267, 51270, 51272, 51279, 51284, 51287, 51294, 51297, 51299, 51301, 51311, 51321, 51323, 51326, 51328, 51335, 51337, 51344, 51348, 51353, 51362, 51364, 51369, 51371, 51375, 51377, 51380, 51387, 51499, 51502, 51504, 51507, 51509, 51513, 51516, 51517, 51520, 51526, 51534, 51542, 51546, 51550, 51552, 51554, 51556, 51558, 51560, 51562, 51564, 51566, 51568, 51570, 51572, 51582, 51586, 51590, 51595, 51602, 51604, 51614, 51616, 51623, 51626, 51633, 51638, 51640, 51642, 51647, 51649, 51749, 51750, 51752, 51754, 51764, 51766, 51770, 51773, 51776, 51778, 51781, 51783, 51787, 51791, 51807, 51817, 51819, 51820, 51821, 51824, 51825, 51828, 51830, 51832, 51833, 51836, 51837, 51841, 51844, 51848, 51850, 51855, 51863, 51868, 51872, 51876, 51878, 51913, 51914, 52084, 52086, 52088, 52091, 52092, 52095, 52103, 52105, 52111, 52115, 52117, 52125, 52127, 52143, 52149, 52153, 52163, 52171, 52175, 52201, 52203, 52334, 52340, 52519) 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: Sir Thomas Overbury

Afterpiece Title: The Jovial Crew

Performances

Mainpiece Title: Sir Thomas Overbury

Afterpiece Title: The Jovial Crew

Dance: End: The Shepherd's Wedding, as17770215

Performances

Mainpiece Title: Sir Thomas Overbury

Afterpiece Title: Comus

Cast
Role: The Lady Actor: Mrs Jackson

Song: As17770107

Performances

Mainpiece Title: Know Your Own Mind

Cast
Role: Mrs Bromley Actor: Mrs Jackson

Afterpiece Title: The Mock Doctor

Dance: As17761123

Performances

Mainpiece Title: Know Your Own Mind

Cast
Role: Mrs Bromley Actor: Mrs Jackson

Afterpiece Title: The Golden Pippin

Dance: As17761107

Performances

Mainpiece Title: Know Your Own Mind

Cast
Role: Mrs Bromley Actor: Mrs Jackson

Afterpiece Title: Comus

Cast
Role: The Lady Actor: Mrs Jackson

Dance: As17770218

Song: Sweet Echo, as17761007

Performances

Mainpiece Title: Sir Thomas Overbury

Afterpiece Title: The Jovial Crew

Dance: As17770217

Performances

Mainpiece Title: Know Your Own Mind

Cast
Role: Mrs Bromley Actor: Mrs Jackson

Afterpiece Title: The Golden Pippin

Dance: As17770218

Performances

Mainpiece Title: Know Your Own Mind

Cast
Role: Mrs Bromley Actor: Mrs Jackson

Afterpiece Title: Comus

Cast
Role: The Lady Actor: Mrs Jackson

Dance: As17770217

Song: As17770107

Performances

Mainpiece Title: Know Your Own Mind

Cast
Role: Mrs Bromley Actor: Mrs Jackson

Afterpiece Title: The Golden Pippin

Dance: As17761107

Performances

Mainpiece Title: Know Your Own Mind

Cast
Role: Mrs Bromley Actor: Mrs Jackson

Afterpiece Title: Comus

Cast
Role: The Lady Actor: Mrs Jackson

Dance: As17770218

Performances

Mainpiece Title: Know Your Own Mind

Cast
Role: Mrs Bromley Actor: Mrs Jackson

Afterpiece Title: The Golden Pippin

Dance: As17770217

Performances

Mainpiece Title: Know Your Own Mind

Cast
Role: Mrs Bromley Actor: Mrs Jackson

Afterpiece Title: The Jovial Crew

Dance: As17770218

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Comus

Cast
Role: The Lady Actor: Mrs Jackson

Performances

Mainpiece Title: Know Your Own Mind

Cast
Role: Mrs Bromley Actor: Mrs Jackson

Afterpiece Title: The Two Misers

Dance: As17770125

Performances

Mainpiece Title: Know Your Own Mind

Cast
Role: Mrs Bromley Actor: Mrs Jackson

Afterpiece Title: The Padlock

Dance: As17770125

Performances

Mainpiece Title: Know Your Own Mind

Cast
Role: Mrs Bromley Actor: Mrs Jackson

Afterpiece Title: Harlequin's Frolicks

Dance: As17761226

Performances

Mainpiece Title: Sir Thomas Overbury

Afterpiece Title: Midas

Dance: As17761120

Performances

Mainpiece Title: Know Your Own Mind

Cast
Role: Mrs Bromley Actor: Mrs Jackson

Afterpiece Title: Harlequin's Frolicks

Dance: As17761226

Performances

Mainpiece Title: Sir Thomas Overbury

Afterpiece Title: True-Blue

Afterpiece Title: Midas

Dance: As17761223

Performances

Mainpiece Title: Know Your Own Mind

Cast
Role: Mrs Bromley Actor: Mrs Jackson

Afterpiece Title: Midas

Dance: As17761120

Performances

Mainpiece Title: Know Your Own Mind

Cast
Role: Mrs Bromley Actor: Mrs Jackson

Afterpiece Title: Midas

Dance: As17770218

Performances

Mainpiece Title: Know Your Own Mind

Cast
Role: Mrs Bromley Actor: Mrs Jackson

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: Know Your Own Mind

Cast
Role: Mrs Bromley Actor: Mrs Jackson

Afterpiece Title: The Old Maid

Dance: End III: The Serenade, as17770426; End: The Humours of Leixlip, as17770425

Performances

Mainpiece Title: The School For Wives

Cast
Role: Mrs Belville Actor: Mrs Jackson

Afterpiece Title: The Clock-Case; or, Female Curiosity

Afterpiece Title: Midas

Dance: End 2nd piece: The Humours of Leixlip, as17770425