SELECT * FROM london_stages WHERE eventid IN (604, 1376, 1691, 1772, 2194, 2285, 3994, 4038, 4065, 4176, 4460, 4461, 4472, 4823, 4939, 5183, 5469, 5922, 6188, 6933, 7950, 8025, 8138, 8362, 8363, 8369, 8421, 8587, 8649, 8652, 8679, 8756, 8830, 8860, 8992, 9224, 9462, 9535, 9587, 9601, 9603, 9640, 9819, 9839, 9853, 9903, 9942, 10065, 10329, 10344, 10438, 10440, 10615, 10763, 10939, 10984, 11279, 11798, 11867, 12000, 12244, 12974, 13407, 13825, 14215, 14219, 14222, 14228, 14238, 14242, 14247, 14248, 14250, 14256, 14259, 14264, 14266, 14269, 14782, 14798, 14934, 15542, 15545, 15729, 15730, 15798, 15840, 16101, 16351, 16366, 16433, 16448, 16644, 16647, 16783, 16877, 16972, 17293, 17347, 17481, 18185, 18187, 18189, 18192, 18195, 18232, 18340, 18378, 18682, 18769, 18880, 18899, 19035, 19077, 19186, 19191, 19242, 19589, 19600, 19701, 19798, 19834, 19857, 19911, 20024, 20097, 20132, 20470, 20472, 20758, 20761, 20773, 20776, 20779, 20782, 20788, 20791, 20794, 20811, 20866, 20874, 20906, 20926, 20937, 20950, 20955, 21236, 21260, 21274, 21297, 21313, 21326, 21366, 21367, 21369, 21370, 21382, 21390, 21405, 21474, 21506, 21519, 21534, 21536, 21542, 21548, 21551, 21573, 21597, 21635, 21681, 21771, 21805, 21860, 21909, 21953, 21966, 21997, 22089, 22109, 22152, 22175, 22179, 22238, 22245, 22277, 22332, 22354, 22369, 22467, 22525, 22534, 22616, 22672, 22777, 22951, 23044, 23046, 23170, 23258, 23274, 23320, 23374, 23397, 23526, 23543, 23544, 23554, 23654, 23933, 24009, 24061, 24113, 24231, 24330, 24485, 24496, 24644, 24704, 24879, 24960, 25029, 25054, 25063, 25146, 25231, 25388, 25409, 25582, 25692, 25743, 25744, 25749, 25755, 25837, 25842, 25894, 25935, 25969, 26072, 26113, 26147, 26176, 26187, 26277, 26374, 26398, 26475, 26558, 26606, 26623, 26655, 26661, 26705, 26766, 26805, 26846, 27016, 27063, 27156, 27181, 27214, 27219, 27255, 27345, 27346, 27562, 27581, 27700, 27784, 27942, 28131, 28172, 28303, 28351, 28355, 28358, 28374, 28379, 28419, 28534, 28609, 28677, 28708, 28940, 29033, 29178, 29421, 29554, 29758, 30106, 30147, 30157, 30304, 30309, 30337, 30341, 30579, 30624, 30654, 30683, 30694, 30812, 30856, 30986, 30995, 31002, 31008, 31013, 31020, 31024, 31029, 31038, 31067, 31095, 31121, 31140, 31236, 31246, 31262, 31350, 31359, 31444, 31488, 31498, 31529, 31914, 31918, 31924, 31931, 31938, 31961, 31975, 31986, 32096, 32122, 32241, 32333, 32389, 32482, 32496, 32709, 32818, 32842, 32889, 32936, 32967, 33083, 33089, 33149, 33263, 33296, 33303, 33305, 33310, 33340, 33406, 33407, 33409, 33411, 33416, 33420, 33423, 33425, 33429, 33433, 33437, 33452, 33469, 33498, 33534, 33577, 33630, 33676, 33714, 33798, 33880, 33891, 33925, 33979, 34174, 34175, 34262, 34343, 34355, 34361, 34392, 34424, 34431, 34557, 34697, 34798, 34805, 34864, 34878, 34885, 34906, 34948, 35065, 35121, 35236, 35280, 35336, 35499, 35527, 35552, 35682, 35935, 36132, 36153, 36207, 36247, 36337, 36514, 36558, 36564, 36634, 36644, 36655, 36668, 36803, 37022, 37095, 37224, 37346, 37367, 37389, 37440, 37560, 37608, 37644, 37781, 37789, 37822, 37833, 37834, 37848, 37901, 37952, 38103, 38122, 38144, 38154, 38165, 38171, 38175, 38181, 38210, 38237, 38251, 38323, 38378, 38392, 38393, 38450, 38465, 38489, 38556, 38730, 38778, 38794, 38796, 38891, 38938, 38988, 39408, 39409, 39411, 39460, 39465, 39507, 39861, 39876, 39902, 39949, 40032, 40054, 40058, 40106, 40198, 40353, 40443, 40521, 40522, 40523, 40528, 40534, 40537, 40557, 40569, 40608, 40672, 40741, 40846, 40904, 40973, 41045, 41137, 41155, 41199, 41278, 41420, 41556, 41601, 41603, 41604, 41607, 41610, 41615, 41618, 41621, 41626, 41631, 41633, 41642, 41646, 41649, 41690, 41875, 41877, 41988, 42206, 42211, 42214, 42217, 42221, 42225, 42229, 42238, 42248, 42306, 42430, 42596, 42815, 42821, 42825, 42827, 42830, 42831, 42837, 42861, 42884, 42893, 42897, 42902, 42907, 42914, 42919, 42925, 42962, 42990, 42992, 43015, 43016, 43042, 43409, 43437, 43460, 43491, 43495, 43497, 43503, 43618, 43627, 43997, 44005, 44029, 44036, 44084, 44133, 44582, 44591, 45089, 45254, 45268, 45323, 45383, 45486, 45559, 45567, 45574, 45589, 45659, 45661, 45663, 45665, 45667, 45671, 45672, 45723, 45762, 45843, 45868, 45934, 46005, 46188, 46191, 46197, 46237, 46260, 46340, 46357, 46360, 46362, 46364, 46368, 46372, 46376, 46378, 46380, 46384, 46388, 46389, 46390, 46392, 46396, 46398, 46400, 46404, 46408, 46416, 46420, 46424, 46426, 46428, 46432, 46437, 46442, 46447, 46451, 46456, 46461, 46465, 46470, 46475, 46477, 46480, 46482, 46487, 46491, 46496, 46501, 46505, 46510, 46518, 46528, 46542, 46556, 46563, 46570, 46584, 46599, 46608, 46613, 46621, 46628, 46638, 46643, 46658, 46672, 46827, 46842, 46845, 46850, 46859, 46861, 46862, 46872, 46878, 46882, 46890, 46894, 46902, 46914, 46926, 46938, 46950, 46956, 46962, 46968, 46972, 46986, 47095, 47103, 47138, 47166, 47182, 47213, 47230, 47254, 47269, 47296, 47389, 47390, 47392, 47393, 47395, 47396, 47397, 47399, 47405, 47407, 47409, 47411, 47413, 47414, 47419, 47424, 47443, 47445, 47460, 47471, 47478, 47481, 47483, 47492, 47494, 47567, 47571, 47594, 47622, 47646, 47677, 47682, 47692, 47703, 47704, 47714, 47718, 47729, 47743, 47754, 47763, 47769, 47773, 47778, 47786, 47798, 47810, 47815, 47817, 47833, 47853, 47859, 47863, 47885, 47890, 47919, 47920, 47921, 47924, 47930, 47936, 47948, 47953, 47954, 47958, 47994, 47995, 47996, 48008, 48009, 48014, 48019, 48023, 48056, 48139, 48199, 48202, 48204, 48206, 48211, 48214, 48216, 48218, 48220, 48229, 48233, 48238, 48242, 48243, 48247, 48250, 48252, 48257, 48261, 48266, 48271, 48275, 48278, 48285, 48289, 48292, 48294, 48299, 48306, 48311, 48317, 48322, 48329, 48331, 48336, 48361, 48382, 48416, 48424, 48432, 48444, 48453, 48461, 48505, 48507, 48508, 48511, 48513, 48516, 48522, 48543, 48549, 48571, 48573, 48615, 48623, 48657, 48675, 48677, 48679, 48684, 48685, 48687, 48689, 48692, 48694, 48695, 48697, 48699, 48704, 48705, 48707, 48709, 48714, 48729, 48732, 48734, 48738, 48744, 48750, 48754, 48768, 48772, 48777, 48780, 48788, 48791, 48792, 48797, 48799, 48802, 48804, 48805, 48806, 48811, 48816, 48817, 48818, 48820, 48822, 48829, 48831, 48833, 48836, 48838, 48843, 48847, 48850, 48852, 48855, 48857, 48858, 48859, 48861, 48866, 48869, 48871, 48873, 48875, 48880, 48883, 48887, 48888, 48891, 48893, 48900, 48903, 48910, 48917, 48919, 48924, 48927, 48928, 48931, 48934, 48946, 48953, 48956, 48957, 48960, 48962, 48988, 48995, 49000, 49004, 49007, 49021, 49033, 49046, 49051, 49061, 49069, 49097, 49129, 49132, 49136, 49138, 49140, 49141, 49142, 49143, 49144, 49145, 49148, 49149, 49150, 49155, 49157, 49162, 49163, 49165, 49166, 49168, 49170, 49174, 49175, 49177, 49178, 49179, 49180, 49181, 49182, 49183, 49187, 49209, 49217, 49221, 49224, 49246, 49266, 49411, 49520, 49522, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49543, 49545, 49548, 49550, 49556, 49560, 49570, 49575, 49578, 49580, 49589, 49592, 49597, 49602, 49604, 49607, 49612, 49620, 49632, 49635, 49640, 49650, 49655, 49657, 49660, 49662, 49663, 49664, 49667, 49670, 49677, 49680, 49682, 49686, 49688, 49695, 49696, 49698, 49700, 49701, 49702, 49704, 49705, 49709, 49712, 49715, 49719, 49721, 49722, 49724, 49725, 49726, 49729, 49730, 49731, 49733, 49734, 49735, 49736, 49740, 49745, 49746, 49748, 49750, 49752, 49753, 49764, 49788, 49821, 49829, 49844, 49878, 49881, 49883, 50051, 50063, 50066, 50069, 50084, 50101, 50112, 50113, 50116, 50140, 50160, 50186, 50193, 50198, 50224, 50229, 50231, 50250, 50262, 50264, 50272, 50275, 50279, 50280, 50286, 50290, 50299, 50300, 50301, 50303, 50304, 50306, 50308, 50310, 50351, 50354, 50371, 50372, 50377, 50394, 50419, 50433, 50579, 50673, 50733, 50736, 50739, 50742, 50744, 50752, 50757, 50759, 50761, 50766, 50786, 50795, 50802, 50814, 50820, 50826, 50829, 50832, 50834, 50842, 50846, 50850, 50865, 50866, 50867, 50871, 50881, 50888, 50896, 50900, 50925, 50943, 50945, 50949, 50952, 50956, 50960, 50961, 50962, 50966, 50970, 51026, 51035, 51044, 51220, 51263, 51302, 51322, 51338, 51368, 51375, 51382, 51386, 51421, 51423, 51427, 51428, 51430, 51437, 51441, 51442, 51446, 51447, 51453, 51463, 51467, 51475, 51478, 51508, 51584, 51620, 51666, 51755, 51765, 51767, 51771, 51838, 51845, 51864, 51890, 51902, 51950, 51978, 51983, 52002, 52010, 52035, 52037, 52039, 52064, 52087, 52090, 52134, 52136, 52138, 52140, 52142, 52144, 52146, 52148, 52150, 52152, 52154, 52156, 52158, 52160, 52166, 52170, 52172, 52180, 52184, 52186, 52190, 52194, 52218, 52227, 52229, 52236, 52253, 52280, 52291, 52355, 52447, 52451, 52452, 52456, 52458, 52466, 52468, 52470, 52471, 52492, 52494, 52509, 52515, 52526, 52535, 52582, 52592, 52601) 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 Squire Of Alsatia

Cast
Role: Sir Edward Actor: Quin

Afterpiece Title: The Devil to Pay

Dance: II: Double Jealousy, as17360907; V: Peasants-Poitier, Mlle Roland

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Sir Edward Actor: Quin

Afterpiece Title: The Harlot's Progress

Dance: I: Drunken Peasant-Philips; IV: Black Joak-Philips, Miss Mann

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Sir Edward Actor: Quin

Afterpiece Title: The Mock Doctor

Dance: I: Tambourine-Mlle Roland; IV: Double Jealousy, as17360907; V: Drunken Peasant-Philips

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Sir Edward Actor: Quin

Afterpiece Title: The Devil to Pay

Dance: I: Black Joak-Phillips, Miss Mann; IV: Drunken Peasant-Philips

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Sir Edward Actor: Quin

Afterpiece Title: The Intriguing Chambermaid

Dance: I: Wooden Shoe-Livier, Villeneuve; IV: Drunken Peasant-Philips; V: Rover-Essex, Mrs Walter, Pelling, Mrs Pelling, Rector, Miss Mann

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Sir Edward Actor: Quin

Afterpiece Title: Harlequin Restor'd

Dance: I: Polonese-Essex, Mrs Walter; IV: Last new Grand Ballet-Denoyer, Mlle Roland,

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Sir Edward Actor: Quin

Afterpiece Title: The Fall of Phaeton

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Sir Edward Actor: Quin

Afterpiece Title: Harlequin Restor'd

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Sir Edward Actor: Quin

Afterpiece Title: The King and the Miller of Mansfield

Music: Comic Medley Overture by Arne-

Dance: I: English Maggot-Villeneuve, Mrs Walter; III: Drunken Peasant-Phillips; V: Turkish Dance-Muilment, Villeneuve, Livier

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Sir Edward Actor: Quin

Afterpiece Title: The Virgin Unmask'd

Dance: I: Wooden Shoe Dance-Livier, Villeneuve; IV: English Maggot-Villeneuve, Mrs Walter

Performances

Mainpiece Title: King Richard The Third

Cast
Role: Prince Edward Actor: Green

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Sir Edward Actor: Quin

Afterpiece Title: The Virgin Unmask'd

Dance: As17371018

Performances

Mainpiece Title: King Richard The Third

Cast
Role: Prince Edward Actor: Green

Afterpiece Title: Harlequin Grand Volgi

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Sir Edward Actor: Quin

Afterpiece Title: Damon and Phillida

Dance: LLa Folie Amoureuse (Comic Ballet)-Denoyer, Mrs Walter, Mrs Thompson, Livier, Pelling; III: Grand Ballet-Denoyer, Haughton, Mrs Thompson; IV: Flanderkins-Master Ferg, Miss Wright; V: Minuet in Modern Habits-Denoyer, Mrs Walter

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Sir Edward Actor: Quin

Afterpiece Title: The Rival Queans: With the odd Humours of little Alexander the Great

Dance: I: Punch-Master Ferg; II: A new Sailor's Dance-Phillips; III: Dance of Turks-Muilment; End I Afterpiece: Pierrots-Pelling, Vallois; II: Drunken Peasant (for the Entertainment of Alexander)-Phillips; III: Flanderkins-Master Ferg, Miss Wright

Song: IV: See from the Silent Groves-Beard

Music: H$Handel's Water Musick-; with Preamble on the Kettle Drums-Woodbridge, his first appearance here

Performances

Mainpiece Title: King Richard The Third

Cast
Role: Prince Edward Actor: Green

Afterpiece Title: The Devil to Pay

Dance: I: Flanderkins-Master Ferg, Miss Wright; II: Two Pierrots-Vallois, Pelling; III: Punch-Master Ferg; IV: Comic Dance-younger Miss Scott

Performances

Mainpiece Title: King Richard The Third

Cast
Role: Prince Edward Actor: Green

Afterpiece Title: The Harlot's Progress

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Sir Edward Actor: Bridgwater

Afterpiece Title: The Country House

Dance: JJe ne scai quoy-Villeneuve, Richardson, Miss Oates; Comic Dance-Villeneuve, Miss Oates; Grecian Sailors-Glover

Song: Roberts

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Sir Edward Actor: Bridgwater

Afterpiece Title: The Necromancer; With The Skeleton Scene

Performances

Mainpiece Title: King Richard The Third

Cast
Role: Prince Edward Actor: Green

Afterpiece Title: Robin Goodfellow

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Sir Edward Actor: Quin

Afterpiece Title: Harlequin Shipwreck'd

Dance: II: Pierots-Lalauze, Pelling; III: Tambourine-Mlle Chateauneuf; IV: Grand Ballet-Denoyer, Mlle Chateauneuf

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Sir Edward Actor: Quin

Afterpiece Title: The Harlot's Progress

Dance: II: Peasant Dance-Master Matthews, Miss Wright; IV: Ballet-Muilment

Performances

Mainpiece Title: King Richard The Third

Cast
Role: Prince Edward Actor: Green

Afterpiece Title: The King and the Miller of Mansfield

Dance: I: Scots Dance-Master Matthews, Miss Wright; II: Ballet-Muilment; III: Le Tambourine-Mlle Chateauneuf; IV: Drunken Peasant-Master Ferg

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Sir Edward Actor: Quin

Afterpiece Title: The Fortune Tellers

Dance: II: Le Gout de Anglois-Master Matthews, Miss Wright; III: Le Tambourine-Mlle Chateauneuf

Ballet: A Voyage to the Land of Cytherea. As17400115

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Sir Edward Actor: Quin

Afterpiece Title: Colombine Courtezan

Song: I: English Captain (as17400325-Beard

Dance: II: Highlander and Mistress-Lalauze, Mlle Chateauneuf; III: Muilment; IV: A new Comic Pantomime Dance-Lalauze, Mlle Chateauneuf; V: Hungarian Dance-Desnoyer, Mlle Chateauneuf