SELECT * FROM london_stages WHERE eventid IN (1338, 1691, 1981, 2019, 2820, 3024, 3212, 3815, 4011, 4211, 4214, 4225, 4259, 4260, 4262, 4281, 4346, 4493, 4589, 4823, 4879, 4939, 5183, 5469, 5877, 5915, 5922, 5978, 7039, 7864, 7950, 8025, 8138, 8813, 8830, 9839, 10810, 10984, 11003, 11005, 11007, 11279, 11281, 11292, 11744, 11772, 11781, 11798, 11867, 12000, 12002, 12125, 12174, 12196, 12203, 12233, 12246, 12264, 12298, 12744, 12759, 12764, 12831, 12974, 13000, 13077, 13175, 13181, 13192, 13256, 13260, 13286, 13377, 13482, 13536, 13544, 13561, 13566, 13568, 13574, 13653, 13656, 13659, 13662, 13666, 13669, 13673, 13676, 13679, 13682, 13686, 13690, 13694, 13701, 13705, 13909, 14119, 14155, 14212, 14582, 15016, 15373, 15469, 15479, 15480, 15482, 15487, 15499, 15506, 16033, 16347, 16351, 16366, 16433, 16939, 16942, 16946, 16950, 16953, 16957, 16961, 16966, 16970, 16974, 16978, 16982, 16986, 16990, 16994, 16998, 17003, 17007, 17012, 17016, 17020, 17025, 17031, 17035, 17039, 17045, 17053, 17056, 17059, 17061, 17071, 17080, 17093, 17101, 17155, 17160, 17164, 17168, 17176, 17193, 17219, 17227, 17239, 17251, 17278, 17287, 17292, 17304, 17314, 17317, 17320, 17332, 17341, 17347, 17368, 17371, 17372, 17373, 17374, 17375, 17376, 17377, 17379, 17385, 17387, 17392, 17663, 17667, 17670, 17673, 17679, 17686, 17689, 17693, 17697, 17700, 17702, 17706, 17710, 17713, 17718, 17720, 17723, 17730, 17734, 17738, 17741, 17745, 17749, 17753, 17757, 17764, 17768, 17771, 17775, 17781, 17784, 17787, 17790, 17794, 17798, 17800, 17807, 17811, 17814, 17849, 17942, 18054, 18058, 18096, 18185, 18187, 18189, 18192, 18195, 18232, 18272, 18329, 18332, 18336, 18339, 18340, 18342, 18346, 18349, 18353, 18378, 18389, 18392, 18399, 18403, 18405, 18409, 18663, 18665, 18675, 18682, 18684, 18748, 18753, 18763, 18767, 18769, 18774, 18781, 18784, 18805, 18899, 19077, 19124, 19144, 19186, 19212, 19223, 19282, 19284, 19286, 19287, 19289, 19290, 19292, 19294, 19297, 19299, 19303, 19305, 19307, 19309, 19311, 19313, 19315, 19318, 19320, 19322, 19324, 19326, 19328, 19332, 19356, 19358, 19368, 19374, 19376, 19377, 19379, 19383, 19589, 19600, 19633, 19798, 19834, 19904, 19907, 19909, 19911, 19912, 19914, 19917, 19919, 19922, 19926, 19929, 19931, 19935, 19939, 19942, 19945, 19948, 19952, 19961, 19966, 19969, 19979, 19994, 20000, 20003, 20008, 20010, 20013, 20018, 20023, 20024, 20028, 20033, 20039, 20044, 20054, 20058, 20063, 20068, 20072, 20082, 20088, 20097, 20098, 20103, 20107, 20111, 20113, 20116, 20123, 20144, 20148, 20185, 20221, 20231, 20255, 20333, 20340, 20343, 20375, 20381, 20399, 20473, 20550, 20618, 20701, 20787, 20790, 20797, 20823, 20826, 20842, 20846, 20849, 20855, 20858, 20861, 20938, 20956, 20961, 20974, 21005, 21025, 21042, 21052, 21070, 21080, 21087, 21104, 21110, 21127, 21151, 21169, 21178, 21185, 21243, 21251, 21258, 21294, 21624, 21710, 21782, 21818, 21849, 21856, 21925, 22054, 22082, 22087, 22090, 22093, 22096, 22099, 22104, 22107, 22109, 22114, 22130, 22132, 22142, 22143, 22154, 22155, 22161, 22186, 22195, 22214, 22238, 22308, 22332, 22363, 22378, 22380, 22383, 22392, 22453, 22458, 22464, 22467, 22489, 22491, 22495, 22499, 22502, 22506, 22508, 22509, 22514, 22515, 22518, 22521, 22522, 22532, 22553, 22556, 22565, 22609, 22617, 22619, 22660, 22661, 22667, 22670, 22701, 22702, 22750, 22766, 22770, 22773, 22824, 22831, 22836, 22841, 22892, 22903, 22926, 22939, 22942, 22945, 22948, 22957, 22959, 22971, 22974, 22979, 22991, 23003, 23005, 23015, 23036, 23041, 23050, 23051, 23066, 23087, 23098, 23101, 23104, 23128, 23140, 23151, 23179, 23207, 23210, 23215, 23226, 23240, 23267, 23297, 23298, 23317, 23339, 23443, 23447, 23450, 23453, 23459, 23462, 23543, 23565, 23568, 23576, 23581, 23584, 23587, 23616, 23629, 23636, 23689, 23702, 23704, 23755, 23791, 23825, 23850, 24040, 24100, 24180, 24294, 24295, 24380, 24408, 24464, 24496, 24518, 24730, 24852, 24877, 24892, 24949, 24982, 25029, 25040, 25073, 25094, 25134, 25203, 25207, 25251, 25252, 25291, 25310, 25313, 25316, 25322, 25326, 25390, 25406, 25432, 25499, 25507, 25542, 25586, 25610, 25674, 25682, 25810, 25818, 25847, 25849, 25851, 25853, 25924, 25971, 26083, 26089, 26094, 26117, 26123, 26127, 26130, 26139, 26141, 26204, 26228, 26332, 26350, 26402, 26447, 26493, 26562, 26595, 26640, 26695, 26728, 26778, 26866, 27054, 27097, 27601, 28025, 28170, 28212, 28279, 28394, 28472, 28482, 28485, 28564, 29033, 29196, 29255, 29364, 29391, 29456, 29457, 29485, 29511, 29522, 29545, 29565, 29730, 29855, 29857, 29861, 29868, 29872, 29874, 29879, 29919, 29921, 29932, 29956, 29958, 29967, 29971, 29983, 30032, 30045, 30065, 30078, 30139, 30143, 30149, 30153, 30155, 30180, 30325, 30356, 30358, 30361, 30363, 30366, 30368, 30370, 30372, 30377, 30380, 30398, 30406, 30419, 30423, 30425, 30439, 30447, 30451, 30453, 30458, 30473, 30485, 30487, 30490, 30494, 30497, 30499, 30505, 30510, 30514, 30518, 30523, 30527, 30533, 30538, 30558, 30562, 30574, 30584, 30588, 30590, 30595, 30598, 30602, 30612, 30620, 30630, 30631, 30637, 30651, 30676, 30792, 30819, 30829, 30955, 31016, 31022, 31041, 31207, 31345, 31361, 31363, 31396, 31414, 31431, 31446, 31677, 31683, 31690, 31699, 31712, 31725, 31749, 31758, 31844, 31850, 31856, 31880, 31914, 31918, 31924, 31931, 31938, 31942, 31950, 31961, 31968, 31975, 32010, 32121, 32122, 32126, 32131, 32168, 32173, 32182, 32203, 32208, 32213, 32217, 32220, 32240, 32264, 32332, 32336, 32363, 32365, 32371, 32394, 32395, 32412, 32442, 32494, 32496, 32519, 32551, 32619, 32630, 32654, 32659, 32663, 32678, 32685, 32699, 32714, 32752, 32831, 32850, 32887, 32936, 32942, 33023, 33089, 33096, 33132, 33136, 33144, 33146, 33151, 33243, 33245, 33252, 33303, 33351, 33407, 33452, 33468, 33513, 33515, 33577, 33605, 33631, 33634, 33667, 33670, 33695, 33699, 33757, 33759, 33800, 33821, 33930, 33983, 33986, 33995, 33997, 33999, 34001, 34004, 34006, 34009, 34011, 34013, 34015, 34018, 34025, 34029, 34034, 34064, 34068, 34089, 34122, 34168, 34170, 34181, 34185, 34198, 34205, 34214, 34219, 34230, 34238, 34253, 34259, 34266, 34267, 34288, 34298, 34307, 34309, 34341, 34351, 34371, 34374, 34382, 34391, 34395, 34397, 34417, 34434, 34454, 34487, 34489, 34490, 34493, 34498, 34499, 34503, 34519, 34523, 34525, 34527, 34529, 34541, 34559, 34597, 34611, 34636, 34718, 34724, 34737, 34763, 34764, 34790, 34808, 34856, 34896, 34916, 34942, 34955, 34956, 35020, 35045, 35056, 35102, 35114, 35184, 35203, 35282, 35316, 35317, 35319, 35349, 35353, 35358, 35365, 35438, 35514, 35533, 35564, 35643, 35728, 35793, 35861, 35887, 35940, 35944, 35984, 36107, 36149, 36217, 36227, 36248, 36260, 36370, 36408, 36468, 36640, 36742, 36784, 36956, 37181, 37258, 37308, 37359, 37374, 37449, 37685, 37717, 37731, 37776, 37777, 37789, 37856, 38006, 38085, 38182, 38282, 38301, 38335, 38338, 38346, 38350, 38352, 38354, 38362, 38365, 38368, 38370, 38377, 38379, 38416, 38430, 38444, 38458, 38465, 38820, 38915, 38925, 38926, 38931, 38938, 38961, 38975, 39013, 39014, 39059, 39119, 39190, 39197, 39213, 39248, 39333, 39353, 39354, 39365, 39406, 39419, 39427, 39433, 39444, 39471, 39487, 39500, 39519, 39596, 39776, 39831, 39882, 39896, 39909, 39921, 39992, 39996, 39999, 40018, 40028, 40067, 40256, 40258, 40264, 40266, 40269, 40271, 40278, 40281, 40284, 40386, 40471, 40495, 40521, 40614, 40626, 40642, 40738, 40762, 40779, 40889, 40894, 40910, 40916, 40948, 40974, 41028, 41034, 41079, 41161, 41174, 41181, 41190, 41203, 41215, 41229, 41243, 41246, 41252, 41257, 41376, 41390, 41459, 41471, 41500, 41513, 41518, 41520, 41527, 41529, 41542, 41544, 41549, 41552, 41557, 41559, 41714, 41721, 41725, 41743, 41747, 41755, 41759, 41765, 41768, 41772, 41809, 41856, 41901, 41917, 41930, 41940, 41962, 41988, 42000, 42050, 42111, 42142, 42164, 42275, 42332, 42353, 42403, 42424, 42454, 42500, 42546, 42584, 42687, 42747, 42915, 42919, 42947, 42972, 42994, 43085, 43109, 43272, 43293, 43316, 43399, 43402, 43407, 43415, 43423, 43438, 43483, 43504, 43547, 43570, 43609, 43686, 43878, 43885, 44080, 44111, 44133, 44135, 44136, 44194, 44237, 44239, 44247, 44267, 44377, 44427, 44432, 44444, 44454, 44459, 44466, 44530, 44535, 44537, 44555, 44578, 44612, 44656, 44672, 44703, 44710, 44778, 44799, 44801, 44808, 44810, 44895, 44936, 44961, 44986, 45015, 45047, 45143, 45247, 45312, 45314, 45337, 45340, 45381, 45425, 45454, 45456, 45477, 45487, 45506, 45509, 45529, 45531, 45572, 45582, 45704, 45717, 45729, 45730, 45838, 46105, 46109, 46121, 46127, 46142, 46143, 46157, 46268, 46269, 46281, 46369, 46397, 46417, 46497, 46506, 46515, 46580, 46612, 46629, 46639, 46670, 46685, 46696, 46701, 46710, 46717, 46762, 46768, 46785, 46812, 46858, 46883, 46919, 46921, 46923, 46925, 46927, 46929, 46931, 46933, 46937, 46947, 46953, 46955, 46961, 46963, 46972, 46974, 46976, 46978, 46980, 46984, 46986, 46989, 46990, 46999, 47001, 47005, 47008, 47012, 47013, 47014, 47018, 47019, 47020, 47024, 47025, 47026, 47029, 47032, 47037, 47044, 47049, 47052, 47061, 47066, 47070, 47071, 47075, 47076, 47083, 47087, 47088, 47091, 47104, 47116, 47130, 47167, 47182, 47207, 47220, 47226, 47253, 47277, 47279, 47301, 47304, 47309, 47312, 47320, 47326, 47397, 47434, 47440, 47446, 47484, 47521, 47535, 47537, 47541, 47542, 47543, 47549, 47554, 47555, 47557, 47561, 47568, 47572, 47575, 47593, 47643, 47722, 47803, 47865, 47869, 47931, 47938, 47967, 48000, 48010, 48113, 48139, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48168, 48170, 48172, 48174, 48178, 48180, 48182, 48439, 48464, 48494, 48501, 48521, 48540, 48573, 48585, 48659, 48665, 48674, 48685, 48690, 48697, 48704, 48714, 48720, 48726, 48736, 48742, 48750, 48763, 48765, 48773, 48781, 48799, 48802, 48806, 48811, 48816, 48822, 48829, 48833, 48838, 48843, 48847, 48852, 48855, 48857, 48859, 48860, 48861, 48866, 48869, 48871, 48873, 48875, 48878, 48880, 48883, 48885, 48888, 48891, 48893, 48897, 48900, 48903, 48905, 48910, 48914, 48917, 48919, 48924, 48928, 48931, 48934, 48939, 48946, 48953, 48957, 48960, 48962, 48992, 48997, 49028, 49045, 49053, 49087, 49092, 49123, 49129, 49130, 49134, 49137, 49143, 49145, 49149, 49158, 49162, 49164, 49166, 49169, 49172, 49175, 49177, 49180, 49198, 49216, 49219, 49242, 49393, 49406, 49436, 49441, 49445, 49449, 49454, 49458, 49462, 49467, 49475, 49480, 49490, 49495, 49507, 49513, 49525, 49563, 49594, 49599, 49612, 49635, 49640, 49650, 49655, 49662, 49667, 49677, 49682, 49702, 49731, 49787, 49799, 49803, 49864, 49895, 49923, 50012, 50084, 50094, 50101, 50105, 50107, 50115, 50117, 50120, 50122, 50130, 50151, 50166, 50191, 50234, 50268, 50280, 50298, 50421, 50481, 50548, 50600, 50730, 50735, 50738, 50743, 50771, 50784, 50786, 50800, 50825, 50830, 50835, 50857, 51154, 51317, 51343, 51492, 51563, 51866, 51909, 51999, 52447, 52452, 52456) 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: Squire Oldsapp; Or, The Night-adventurers

Cast
Role: Squire Oldsapp Actor: Nokes

Performances

Mainpiece Title: The Squire Of Alsatia

Performances

Mainpiece Title: She Ventures And He Wins

Cast
Role: Squire Wouldbe Actor: Doget

Performances

Mainpiece Title: Love's A Jest

Cast
Role: The Epilogue Actor: Underhil, Bowen
Role: Squire Illbred Actor: Trefusis

Performances

Mainpiece Title: Concert

Afterpiece Title: Squire Trelooby

Cast
Role: Squire Trelooby Actor: Dogget

Dance: l'Abbe, duRuel, Cherrier, Mrs Elford, Mrs Champion, Mrs Mayers, others

Performances

Mainpiece Title: Farewell Folly; Or, The Younger The Wiser

Cast
Role: Squire Lubbard Actor: Bullock

Performances

Mainpiece Title: Hampstead Heath

Cast
Role: Squire Calf of Essex Actor: Bullock

Performances

Song:

Dance: Leguard, Miss Norris

Performances

Mainpiece Title: The Maid's The Mistress

Cast
Role: Squire Empty Actor: Bullock

Performances

Mainpiece Title: The Modern Prophets; Or, New Wit For A Husband

Cast
Role: Squire Whimsey Actor: Norris
Role: Father Marrogn Actor: Boen

Performances

Mainpiece Title: The Modern Prophets

Cast
Role: Squire Whimsey Actor: Norris
Role: Father Marrogn Actor: Boen

Song: With a New Song by the Author, on the ensuing Campaign, for the Entertainment of his Friends-

Performances

Mainpiece Title: The Stage Coach

Cast
Role: Squire Somebody Actor: Pack

Afterpiece Title: Love Makes a Man

Performances

Mainpiece Title: Love Makes A Man; Or, The Fop's Fortune

Afterpiece Title: The Stage Coach

Cast
Role: Squire Somebody Actor: Dogget.

Performances

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

Afterpiece Title: The Stage Coach

Cast
Role: Squire Somebody Actor: Dogget.

Performances

Mainpiece Title: The Fatal Marriage; Or, The Innocent Adultery

Afterpiece Title: The Stage Coach

Cast
Role: Squire Somebody Actor: Dogget.

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: The Stage Coach

Cast
Role: Squire Somebody Actor: Dogget.

Performances

Mainpiece Title: The Unhappy Favourite

Afterpiece Title: The Stage Coach

Cast
Role: Squire Somebody Actor: Dogget.

Entertainment: Higgins

Performances

Mainpiece Title: The Pilgrim

Afterpiece Title: The Stage Coach

Cast
Role: Squire Somebody Actor: Dogget.

Afterpiece Title: Roger's Wedding

Performances

Mainpiece Title: The Constant Couple

Afterpiece Title: The Stage Coach

Cast
Role: Squire Somebody Actor: Dogget.

Song: Dogget, Leveridge

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Squire Actor: Bullock

Dance: Mrs Bicknell

Performances

Mainpiece Title: Love's A Jest

Cast
Role: Squire Illbred Actor: Bullock

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Squire Actor: Bullock

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Squire Actor: Bullock

Performances

Mainpiece Title: The Squire Of Alsatia

Cast
Role: Squire Actor: Bullock

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: The What D'ye Call It

Cast
Role: Squire Thomas Actor: Johnson