SELECT * FROM london_stages WHERE eventid IN (45597, 45604, 45605, 45653, 45655, 45656, 45657, 45658, 45659, 45660, 45661, 45663, 45665, 45666, 45667, 45668, 45671, 45675, 45676, 45677, 45679, 45682, 45685, 45708, 46104, 46110, 46116, 46122, 46128, 46138, 46155, 46161, 46167, 46172, 46180, 46182, 46183, 46184, 46185, 46188, 46190, 46191, 46196, 46197, 46199, 46200, 46201, 46202, 46204, 46205, 46207, 46208, 46210, 46211, 46212, 46215, 46216, 46218, 46219, 46223, 46225, 46226, 46227, 46228, 46229, 46230, 46231, 46232, 46233, 46234, 46235, 46236, 46237, 46238, 46239, 46240, 46241, 46244, 46245, 46246, 46247, 46248, 46249, 46251, 46254, 46255, 46256, 46257, 46258, 46259, 46736, 46744, 46749, 46750, 46752, 46753, 46755, 46757, 46762, 46763, 46765, 46769, 46770, 46772, 46773, 46779, 46782, 46786, 46787, 46788, 46790, 46797, 46801, 46802, 46803, 46804, 46809, 46812, 46813, 46814, 46817, 46818, 46819, 46820, 46821, 46822, 46824, 46825, 47307, 47313, 47316, 47323, 47327, 47329, 47334, 47335, 47339, 47341, 47346, 47349, 47360, 47361, 47363, 47366, 47368, 47371, 47374, 47376, 47378, 47380, 47383, 47384, 47386, 47387, 47388, 47389, 47390, 47392, 47393, 47394, 47395, 47396, 47397, 47398, 47399, 47401, 47402, 47403, 47404, 47405, 47407, 47408, 47409, 47410, 47411, 47413, 47414, 47415, 47416, 47417, 47418, 47419, 47420, 47421, 47423, 47424, 47425, 47426, 47427, 47428, 47429, 47430, 47919, 47920, 47921, 47924, 47927, 47930, 47934, 47936, 47937, 47938, 47939, 47946, 47947, 47948, 47951, 47953, 47954, 47957, 47958, 47959, 47961, 47962, 47964, 47966, 47970, 47975, 47977, 47979, 47981, 47986, 47988, 47989, 47990, 47991, 48449, 48450, 48456, 48457, 48458, 48462, 48464, 48465, 48467, 48469, 48470, 48472, 48473, 48474, 48476, 48477, 48478, 48480, 48482, 48483, 48484, 48485, 48486, 48487, 48488, 48489, 48490, 48492, 48493, 48494, 48495, 48496, 48497, 48498, 48499, 48500, 48501, 48502, 48503, 48504, 48505, 48506, 48507, 48508, 48511, 48512, 48513, 48515, 48516, 48518, 48519, 48522, 48524, 48526, 48528, 48529, 48530, 48532, 48533, 48541, 48567, 48577, 48609, 48643, 48645, 48651, 48707, 48719, 48837, 48874, 48879, 48882, 48884, 48887, 48890, 48892, 48896, 48899, 48902, 48909, 48913, 48918, 48923, 48927, 48933, 48938, 48942, 48945, 48947, 48952, 48956, 48961, 48967, 48982, 48986, 48990, 48993, 49007, 49016, 49043, 49053, 49056, 49066, 49077, 49081, 49083, 49100, 49123, 49125, 49126, 49127, 49128, 49130, 49131, 49132, 49133, 49134, 49135, 49136, 49137, 49138, 49139, 49140, 49141, 49142, 49143, 49144, 49145, 49146, 49148, 49149, 49150, 49151, 49153, 49155, 49156, 49157, 49158, 49162, 49163, 49165, 49166, 49167, 49168, 49169, 49170, 49171, 49172, 49174, 49175, 49176, 49177, 49178, 49179, 49180, 49181, 49182, 49183, 49187, 49197, 49228, 49229, 49234, 49240, 49244, 49252, 49258, 49262, 49264, 49266, 49404, 49408, 49411, 49413, 49416, 49418, 49420, 49422, 49425, 49427, 49430, 49432, 49434, 49445, 49485, 49500, 49504, 49507, 49509, 49513, 49522, 49525, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49543, 49545, 49548, 49550, 49573, 49583, 49609, 49614, 49630, 49637, 49644, 49646, 49651, 49657, 49660, 49663, 49669, 49670, 49672, 49677, 49680, 49682, 49685, 49686, 49688, 49690, 49694, 49695, 49696, 49698, 49700, 49701, 49702, 49703, 49704, 49705, 49709, 49711, 49712, 49713, 49714, 49715, 49717, 49719, 49721, 49722, 49724, 49725, 49726, 49727, 49728, 49729, 49730, 49731, 49733, 49734, 49735, 49736, 49737, 49739, 49740, 49742, 49743, 49744, 49745, 49746, 49747, 49748, 49749, 49750, 49752, 49753, 49754, 49757, 49761, 49766, 49772, 49777, 49779, 49780, 49787, 49788, 49791, 49801, 49809, 49811, 49813, 49815, 49817, 49821, 49823, 49825, 49827, 49829, 49831, 49833, 49835, 49837, 49839, 49841, 49843, 49845, 49847, 49849, 49851, 49855, 49859, 49861, 49863, 49867, 49869, 49871, 49873, 49875, 49877, 49879, 49883, 49886, 49891, 49893, 49895, 49897, 49905, 49907, 49910, 49912, 49915, 49917, 49919, 49921, 49924, 49926, 49929, 49931, 49933, 49935, 49938, 49940, 49943, 49945, 49947, 49949, 49952, 49954, 49957, 49959, 49961, 49963, 49966, 49968, 49971, 49973, 49975, 49978, 49980, 49983, 49985, 49987, 49989, 49992, 49994, 49998, 50001, 50004, 50006, 50010, 50013, 50016, 50019, 50023, 50026, 50029, 50031, 50035, 50038, 50041, 50044, 50048, 50052, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50077, 50079, 50082, 50087, 50089, 50092, 50094, 50097, 50099, 50102, 50104, 50111, 50113, 50116, 50118, 50128, 50134, 50141, 50143, 50148, 50151, 50153, 50156, 50161, 50163, 50166, 50170, 50172, 50177, 50179, 50184, 50186, 50189, 50193, 50195, 50200, 50203, 50205, 50210, 50215, 50221, 50224, 50226, 50229, 50230, 50232, 50234, 50235, 50237, 50238, 50239, 50240, 50242, 50243, 50245, 50246, 50247, 50248, 50250, 50251, 50253, 50256, 50257, 50259, 50260, 50262, 50263, 50264, 50265, 50267, 50268, 50270, 50271, 50272, 50273, 50275, 50276, 50277, 50278, 50279, 50280, 50282, 50283, 50284, 50285, 50286, 50287, 50288, 50289, 50290, 50291, 50292, 50293, 50294, 50295, 50296, 50297, 50298, 50299, 50302, 50303, 50304, 50305, 50306, 50307, 50308, 50310, 50312, 50313, 50314, 50316, 50317, 50318, 50319, 50320, 50321, 50322, 50330, 50334, 50336, 50340, 50352, 50353, 50356, 50358, 50360, 50361, 50366, 50368, 50376, 50378, 50380, 50383, 50385, 50387, 50389, 50391, 50392, 50398, 50400, 50402, 50404, 50406, 50410, 50414, 50416, 50418, 50420, 50422, 50424, 50426, 50428, 50430, 50433, 50435, 50438, 50440, 50442, 50444, 50447, 50449, 50452, 50454, 50456, 50463, 50466, 50468, 50470, 50472, 50475, 50477, 50480, 50482, 50484, 50487, 50489, 50492, 50494, 50496, 50498, 50501, 50503, 50506, 50508, 50510, 50512, 50515, 50517, 50520, 50522, 50524, 50526, 50529, 50531, 50534, 50536, 50538, 50540, 50543, 50546, 50549, 50551, 50554, 50556, 50559, 50562, 50564, 50566, 50568, 50571, 50573, 50576, 50578, 50581, 50583, 50588, 50591, 50593, 50595, 50597, 50600, 50602, 50605, 50607, 50609, 50611, 50616, 50620, 50623, 50626, 50628, 50632, 50635, 50638, 50640, 50650, 50652, 50662, 50668, 50671, 50674, 50684, 50688, 50690, 50693, 50695, 50697, 50699, 50702, 50704, 50707, 50709, 50712, 50714, 50717, 50722, 50724, 50726, 50733, 50736, 50742, 50744, 50749, 50757, 50764, 50772, 50782, 50784, 50790, 50795, 50800, 50802, 50805, 50806, 50808, 50809, 50812, 50814, 50817, 50818, 50820, 50821, 50824, 50825, 50826, 50827, 50829, 50830, 50832, 50833, 50834, 50835, 50837, 50838, 50840, 50841, 50842, 50843, 50845, 50846, 50848, 50849, 50850, 50851, 50853, 50854, 50856, 50857, 50858, 50859, 50862, 50864, 50865, 50866, 50867, 50869, 50870, 50871, 50872, 50873, 50874, 50875, 50877, 50878, 50879, 50880, 50882, 50883, 50884, 50885, 50887, 50889, 50890, 50891, 50893, 50894, 50895, 50896, 50897, 50899, 50900, 50901, 50902, 50903, 50905, 50906, 50907, 50909, 50910, 50912, 50917, 50923, 50925, 50940, 50951, 50959, 50963, 50965, 50969, 50971, 50975, 50979, 50981, 50983, 50985, 50987, 50989, 50991, 50997, 51001, 51003, 51005, 51007, 51009, 51012, 51014, 51016, 51018, 51021, 51024, 51027, 51029, 51031, 51033, 51036, 51038, 51041, 51043, 51045, 51047, 51050, 51052, 51054, 51057, 51059, 51061, 51064, 51067, 51069, 51071, 51073, 51076, 51078, 51081, 51083, 51085, 51087, 51090, 51092, 51095, 51097, 51099, 51101, 51104, 51107, 51110, 51112, 51114, 51116, 51119, 51121, 51124, 51126, 51128, 51130, 51133, 51138, 51142, 51145, 51147, 51156, 51159, 51161, 51164, 51166, 51168, 51170, 51173, 51175, 51179, 51182, 51185, 51187, 51191, 51194, 51197, 51199, 51203, 51206, 51209, 51211, 51215, 51218, 51221, 51223, 51227, 51231, 51234, 51237, 51241, 51244, 51247, 51249, 51252, 51254, 51256, 51258, 51266, 51268, 51271, 51273, 51280, 51283, 51285, 51298, 51300, 51304, 51307, 51309, 51312, 51319, 51331, 51336, 51338, 51341, 51345, 51351, 51356, 51360, 51365, 51368, 51370, 51376, 51378, 51381, 51383, 51386, 51388, 51391, 51392, 51394, 51395, 51396, 51397, 51399, 51400, 51402, 51403, 51405, 51407, 51408, 51410, 51411, 51412, 51413, 51415, 51416, 51419, 51420, 51421, 51423, 51424, 51425, 51428, 51430, 51431, 51433, 51434, 51438, 51441, 51442, 51444, 51445, 51446, 51448, 51449, 51450, 51451, 51453, 51454, 51455, 51457, 51460, 51461, 51463, 51464, 51465, 51466, 51467, 51468, 51469, 51470, 51471, 51472, 51473, 51476, 51477, 51484, 51486, 51488, 51490, 51492, 51496, 51501, 51503, 51505, 51506, 51509, 51511, 51513, 51514, 51517, 51519, 51522, 51532, 51539, 51543, 51545, 51547, 51549, 51551, 51553, 51555, 51559, 51561, 51563, 51567, 51571, 51575, 51579, 51583, 51585, 51589, 51593, 51596, 51598, 51601, 51603, 51605, 51607, 51610, 51613, 51615, 51617, 51619, 51621, 51624, 51627, 51629, 51631, 51634, 51636, 51639, 51641, 51643, 51645, 51648, 51653, 51655, 51659, 51662, 51667, 51669, 51671, 51673, 51678, 51681, 51686, 51688, 51691, 51694, 51697, 51699, 51704, 51706, 51710, 51713, 51716, 51718, 51722, 51725, 51728, 51730, 51734, 51737, 51740, 51743, 51747, 51750, 51753, 51755, 51762, 51765, 51767, 51771, 51774, 51777, 51782, 51784, 51786, 51794, 51797, 51799, 51806, 51808, 51811, 51815, 51817, 51820, 51825, 51828, 51831, 51833, 51836, 51838, 51841, 51843, 51845, 51847, 51861, 51864, 51866, 51869, 51871, 51873, 51877, 51879, 51882, 51885, 51887, 51890, 51895, 51898, 51900, 51902, 51904, 51907, 51909, 51914, 51924, 51927, 51929, 51933, 51936, 51944, 51947, 51950, 51953, 51955, 51957, 51959, 51962, 51964, 51967, 51969, 51971, 51973, 51976, 51978, 51981, 51983, 51985, 51986, 51988, 51989, 51991, 51993, 51994, 51996, 51997, 51999, 52000, 52001, 52002, 52004, 52005, 52007, 52008, 52009, 52010, 52012, 52013, 52015, 52017, 52018, 52020, 52021, 52022, 52023, 52024, 52025, 52026, 52027, 52028, 52029, 52030, 52031, 52033, 52034, 52035, 52036, 52037, 52041, 52042, 52044, 52045, 52046, 52047, 52049, 52050, 52051, 52052, 52053, 52054, 52057, 52060, 52062, 52064, 52066, 52068, 52072, 52077, 52087, 52090, 52093, 52097, 52099, 52100, 52102, 52104, 52106, 52108, 52110, 52112, 52114, 52116, 52118, 52120, 52122, 52124, 52126, 52128, 52132, 52134, 52136, 52138, 52140, 52142, 52144, 52146, 52148, 52150, 52152, 52154, 52156, 52158, 52160, 52162, 52164, 52166, 52168, 52170, 52172, 52174, 52176, 52178, 52180, 52182, 52184, 52186, 52188, 52190, 52192, 52194, 52200, 52202, 52206, 52210, 52214, 52216, 52218, 52221, 52225, 52227, 52236, 52239, 52241, 52243, 52245, 52248, 52250, 52253, 52255, 52257, 52259, 52262, 52264, 52269, 52271, 52274, 52277, 52280, 52282, 52284, 52286, 52289, 52291, 52294, 52296, 52298, 52300, 52303, 52305, 52308, 52310, 52312, 52314, 52317, 52319, 52323, 52326, 52329, 52331, 52335, 52338, 52341, 52343, 52347, 52350, 52353, 52355, 52359, 52362, 52365, 52367, 52371, 52374, 52377, 52379, 52383, 52386, 52389, 52394, 52396, 52398, 52403, 52405, 52408, 52410, 52413, 52418, 52425, 52427, 52429, 52432, 52439, 52442, 52444, 52447, 52449, 52452, 52454, 52456, 52458, 52461, 52466, 52468, 52473, 52476, 52481, 52483, 52486, 52490, 52492, 52497, 52499, 52501, 52504, 52506, 52509, 52511, 52514, 52516, 52520, 52522, 52525, 52526, 52528, 52529, 52532, 52534, 52535, 52536, 52537, 52539, 52540, 52542, 52543, 52544, 52545, 52547, 52548, 52550, 52551, 52552, 52553, 52555, 52556, 52558, 52559, 52560, 52561, 52563, 52564, 52566, 52567, 52568, 52569, 52571, 52572, 52574, 52575, 52576, 52577, 52579, 52580, 52581, 52582, 52583, 52584, 52585, 52586, 52587, 52588, 52589, 52590, 52591, 52592, 52593, 52594, 52595, 52596, 52597, 52598, 52599, 52600, 52601, 52602, 52603, 52604, 52605, 52606, 52607, 52608, 52609, 52610, 52611, 52612, 52613, 52614, 52615) 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 Purse

Afterpiece Title: The Heir at Law

Cast
Role: Thomas Actor: Abbot
Role: Nathaniel Actor: Abbot

Afterpiece Title: Cross Purposes

Cast
Role: Poz Actor: Abbot
Role: Thomas Actor: Abbot
Role: Nathaniel Actor: Abbot
Role: Sailors and Servants Actor: Linton, Walker, Abbot, Lyons

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Irishmen Actor: Caulfield, Abbot

Afterpiece Title: The Mock Doctor

Cast
Role: Thomas Actor: Abbot
Role: Nathaniel Actor: Abbot

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: The Surrender of Calais

Afterpiece Title: The Purse

Cast
Role: Thomas Actor: Abbot
Role: Nathaniel Actor: Abbot
Role: Poz Actor: Abbot
Role: Sailors and Servants Actor: Linton, Walker, Abbot, Lyons

Song: As17970705

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Irishmen Actor: Caulfield, Abbot

Afterpiece Title: The Liar

Cast
Role: Servants Actor: Abbot, Lyons

Performances

Mainpiece Title: The Battle Of Hexham

Cast
Role: Robbers Actor: Bannister, Davies, Abbot

Afterpiece Title: The Honest Thieves

Dance: End: Hornpipe-Sga Bossi DelCaro

Music: After Dancing: a favourite concerto by Dussek upon the Grand Piano Forte-Miss Gaudry (1st appearance in public)

Song: End I afterpiece: a favourite song by Webbe-Master Sincock

Entertainment: In the course of the Evening: a Variety of Imitations-Caulfield

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Irishmen Actor: Caulfield, Abbot

Afterpiece Title: The Flitch of Bacon

Cast
Role: Ned Actor: Abbot

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Irishmen Actor: Caulfield, Abbot

Afterpiece Title: High Life below Stairs

Dance: II afterpiece: Mock Minuet-Palmer, Miss DeCamp

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Irishmen Actor: Caulfield, Abbot

Afterpiece Title: My Grandmother

Cast
Role: Poz Actor: Abbot

Performances

Mainpiece Title: Half An Hour After Supper

Afterpiece Title: The Mountaineers

Cast
Role: Ali Beg Actor: Abbot

Afterpiece Title: Cross Purposes

Cast
Role: Harry Bevil Actor: Abbot.
Role: Poz Actor: Abbot
Role: Thomas Actor: Abbot
Role: Nathaniel Actor: Abbot
Role: Sailors and Servants Actor: Linton, Walker, Abbot, Lyons

Performances

Mainpiece Title: A Bold Stroke For A Wife

Afterpiece Title: The Follies of a Day

Song: Between: Little Taffline-Mrs Bland; The Town Crier (composed by Dibdin)-Suett; End: An Old Woman of Eighty-Munden

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: The Heir at Law

Cast
Role: Thomas Actor: Abbot
Role: Nathaniel Actor: Abbot

Afterpiece Title: The Mock Doctor

Cast
Role: Thomas Actor: Abbot
Role: Nathaniel Actor: Abbot

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: Lock and Key

Performances

Mainpiece Title: The Deaf Lover

Afterpiece Title: The Italian Monk

Cast
Role: Familiar Actor: Abbot

Song: 2nd piece: General Chorus [of Assassins and Nuns (text)]-Linton, Brown, Lyons, Aylmer, Little, Willoughby, Dibble, Kenrick, Caulfield Jun., Mrs Andrews, Miss Menage, Mrs Butler, Mrs Brown, Mrs Benson, Mrs Masters, Mrs Norton, Mrs Gaudry, Miss Leserve

Performances

Mainpiece Title: The Italian Monk

Afterpiece Title: Rosina

Cast
Role: John Actor: Abbot

Song: 1st piece: General Chorus, as17970815, but _Dibble, _Kenrick, _Caulfield Jun., Mrs _Gaudry, Mrs _Brown

Performances

Mainpiece Title: The Heir At Law

Afterpiece Title: Rosina

Cast
Role: John Actor: Abbot

Performances

Mainpiece Title: The Italian Monk

Afterpiece Title: The Agreeable Surprise

Cast
Role: Poz Actor: Abbot
Role: Thomas Actor: Abbot
Role: Nathaniel Actor: Abbot

Song: As17970816

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Irishmen Actor: Caulfield, Abbot

Afterpiece Title: The Children in the Wood

Performances

Mainpiece Title: The Italian Monk

Afterpiece Title: The Padlock

Cast
Role: Scholars Actor: Abbot, Lyons

Song: As17970816

Performances

Mainpiece Title: The Surrender Of Calais

Afterpiece Title: The Irish Tar; or, Which is the Girl

Afterpiece Title: The Agreeable Surprise

Cast
Role: Poz Actor: Abbot
Role: Thomas Actor: Abbot
Role: Nathaniel Actor: Abbot

Song: 1st piece: Vocal Parts, as17970623 but _Caulfield Jun., _Walker, _Willoughby, Mrs _Butler, Mrs _Masters, Mrs _Norton, Miss _Menage, Mrs _Wall, Mrs _Benson, Miss _Leserve

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Irishmen Actor: Caulfield, Abbot

Afterpiece Title: The Children in the Wood

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: Peeping Tom

Cast
Role: Thomas Actor: Abbot
Role: Nathaniel Actor: Abbot

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: The Padlock

Cast
Role: Scholars Actor: Abbot, Lyons

Performances

Mainpiece Title: The Italian Monk

Afterpiece Title: A Mogul Tale

Cast
Role: Guard Actor: Abbot.

Song: As17970816

Performances

Mainpiece Title: The Iron Chest

Cast
Role: Walter Actor: Abbot

Afterpiece Title: The Agreeable Surprise

Cast
Role: Thomas Actor: Abbot
Role: Nathaniel Actor: Abbot

Song: Mainpiece: General Chorus, as17970814, but added: Lyons, Miss +Andrews, _Walker, _Dibble, _Caulfield Jun., Ms _Edward, Ms _Gaudry, Ms _Hale

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Irishmen Actor: Caulfield, Abbot

Afterpiece Title: Sylvester Daggerwood

Afterpiece Title: The Poor Soldier

Cast
Role: John Actor: Abbot