SELECT * FROM london_stages WHERE eventid IN (46229, 46772, 47389, 47390, 47392, 47393, 47395, 47396, 47397, 47399, 47405, 47407, 47409, 47411, 47413, 47414, 47416, 47419, 47424, 47709, 47724, 47779, 47787, 47803, 47825, 47865, 47869, 47919, 48029, 48133, 48135, 48137, 48139, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48168, 48170, 48172, 48174, 48178, 48180, 48182, 48250, 48252, 48257, 48261, 48266, 48271, 48275, 48280, 48303, 48306, 48308, 48311, 48313, 48315, 48317, 48322, 48325, 48329, 48331, 48336, 48347, 48352, 48354, 48358, 48361, 48363, 48366, 48368, 48375, 48377, 48380, 48382, 48384, 48396, 48404, 48409, 48411, 48430, 48437, 48505, 48507, 48508, 48511, 48513, 48516, 48522, 48523, 48541, 48551, 48553, 48567, 48659, 48665, 48685, 48687, 48697, 48704, 48714, 48719, 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, 48837, 48851, 48856, 48860, 48865, 48870, 48874, 48877, 48879, 48882, 48884, 48887, 48890, 48892, 48896, 48898, 48899, 48902, 48908, 48909, 48912, 48913, 48916, 48918, 48922, 48923, 48926, 48927, 48930, 48937, 48941, 48945, 48951, 48952, 48959, 48961, 48980, 48986, 48988, 48990, 48993, 49007, 49009, 49014, 49021, 49023, 49028, 49033, 49038, 49041, 49043, 49053, 49056, 49066, 49077, 49081, 49083, 49086, 49090, 49100, 49133, 49135, 49137, 49167, 49172, 49193, 49197, 49199, 49206, 49208, 49211, 49214, 49216, 49222, 49226, 49238, 49242, 49244, 49246, 49248, 49250, 49252, 49254, 49256, 49260, 49338, 49340, 49343, 49345, 49348, 49350, 49352, 49354, 49357, 49359, 49362, 49371, 49373, 49376, 49378, 49385, 49387, 49390, 49392, 49399, 49401, 49408, 49411, 49413, 49416, 49418, 49420, 49422, 49425, 49427, 49430, 49432, 49434, 49439, 49452, 49465, 49469, 49472, 49473, 49478, 49485, 49520, 49522, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49543, 49545, 49548, 49550, 49556, 49558, 49560, 49565, 49570, 49575, 49578, 49580, 49585, 49589, 49592, 49597, 49599, 49602, 49604, 49607, 49612, 49620, 49635, 49640, 49646, 49650, 49655, 49657, 49659, 49662, 49664, 49667, 49672, 49677, 49680, 49682, 49686, 49690, 49694, 49696, 49705, 49714, 49727, 49728, 49783, 49787, 49791, 49794, 49799, 49801, 49803, 49805, 49813, 49815, 49817, 49835, 49869, 49886, 49891, 49897, 49900, 49902, 49924, 49980, 49983, 49985, 49987, 49989, 49994, 49998, 50001, 50004, 50006, 50010, 50013, 50016, 50019, 50023, 50026, 50029, 50031, 50035, 50038, 50041, 50044, 50048, 50052, 50055, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50077, 50079, 50082, 50087, 50089, 50092, 50094, 50097, 50099, 50102, 50104, 50108, 50111, 50118, 50136, 50141, 50143, 50151, 50153, 50156, 50161, 50163, 50170, 50177, 50184, 50186, 50189, 50195, 50203, 50215, 50306, 50308, 50310, 50352, 50353, 50356, 50358, 50360, 50361, 50364, 50374, 50376, 50378, 50380, 50385, 50387, 50418, 50420, 50422, 50424, 50428, 50433, 50435, 50438, 50440, 50444, 50447, 50452, 50456, 50463, 50468, 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, 50564, 50566, 50568, 50571, 50573, 50576, 50578, 50581, 50583, 50588, 50591, 50593, 50595, 50597, 50600, 50602, 50605, 50607, 50609, 50611, 50616, 50620, 50626, 50628, 50632, 50635, 50638, 50640, 50684, 50688, 50690, 50695, 50702, 50704, 50707, 50709, 50712, 50714, 50717, 50722, 50724, 50726, 50728, 50736, 50739, 50742, 50744, 50754, 50757, 50759, 50764, 50772, 50790, 50795, 50802, 50805, 50812, 50837, 50843, 50849, 50853, 50858, 50859, 50867, 50870, 50877, 50880, 50940, 50942, 50951, 50959, 50961, 50965, 50971, 50983, 50985, 50997, 51003, 51005, 51007, 51009, 51012, 51014, 51016, 51018, 51021, 51024, 51027, 51029, 51031, 51033, 51036, 51038, 51041, 51043, 51045, 51047, 51050, 51059, 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, 51140, 51159, 51161, 51164, 51166, 51168, 51170, 51173, 51182, 51185, 51187, 51191, 51194, 51197, 51199, 51206, 51209, 51211, 51215, 51218, 51221, 51223, 51227, 51231, 51234, 51237, 51241, 51244, 51247, 51249, 51254, 51256, 51258, 51266, 51268, 51273, 51277, 51285, 51298, 51304, 51309, 51312, 51329, 51336, 51338, 51341, 51345, 51349, 51351, 51354, 51356, 51358, 51363, 51365, 51368, 51405, 51415, 51420, 51428, 51430, 51453, 51481, 51488, 51490, 51505, 51509, 51513, 51517, 51521, 51525, 51527, 51529, 51535, 51537, 51539, 51541, 51543, 51545, 51547, 51549, 51551, 51553, 51555, 51559, 51563, 51567, 51571, 51575, 51579, 51583, 51585, 51589, 51598, 51601, 51603, 51605, 51607, 51610, 51613, 51615, 51617, 51619, 51621, 51624, 51627, 51629, 51631, 51634, 51636, 51639, 51641, 51643, 51648, 51655, 51662, 51676, 51694, 51697, 51699, 51704, 51706, 51710, 51713, 51716, 51718, 51722, 51725, 51728, 51730, 51734, 51737, 51740, 51743, 51747, 51750, 51759, 51777, 51779, 51782, 51784, 51786, 51789, 51792, 51794, 51799, 51801, 51803, 51806, 51808, 51811, 51813, 51815, 51817, 51820, 51822, 51825, 51828, 51833, 51836, 51838, 51841, 51843, 51849, 51856, 51859, 51861, 51864, 51869, 51871, 51877, 51879, 51885, 51887, 51890, 51900, 51902, 51907, 51909, 51914, 51919, 51922, 51927, 51929, 51931, 51933, 51936, 51955, 51967, 51989, 51994, 51996, 51997, 51999, 52000, 52001, 52002, 52004, 52005, 52007, 52008, 52012, 52017, 52022, 52023, 52028, 52030, 52034, 52044, 52046, 52049, 52050, 52051, 52053, 52060, 52072, 52077, 52079, 52081, 52082, 52085, 52093, 52097, 52099, 52102, 52104, 52106, 52108, 52116, 52122, 52126, 52128, 52134, 52136, 52138, 52140, 52142, 52144, 52146, 52148, 52150, 52152, 52154, 52156, 52158, 52160, 52166, 52170, 52172, 52178, 52180, 52182, 52184, 52186, 52188, 52190, 52194, 52200, 52202, 52204, 52206, 52208, 52210, 52212, 52214, 52216, 52218, 52221, 52223, 52225, 52227, 52229, 52231, 52234, 52236, 52239, 52241, 52243, 52248, 52250, 52253, 52255, 52257, 52259, 52262, 52264, 52269, 52271, 52274, 52277, 52280, 52282, 52289, 52291, 52294, 52296, 52303, 52317, 52329, 52341, 52347, 52353, 52355, 52359, 52362, 52365, 52367, 52374, 52377, 52379, 52383, 52386, 52389, 52391, 52394, 52396, 52398, 52400, 52403, 52405, 52408, 52410, 52415, 52418, 52427, 52434, 52437, 52444, 52449, 52454, 52458, 52468, 52471, 52473, 52481, 52483, 52490, 52497, 52499, 52506, 52509, 52516, 52520, 52529, 52542, 52543, 52544, 52545, 52547, 52548, 52550, 52563, 52571, 52574, 52575, 52576, 52577, 52579, 52581, 52583, 52584, 52585, 52586, 52587, 52595, 52597, 52600, 52602, 52604, 52605, 52606, 52610, 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: Love's Frailties

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Bclial Actor: Linton

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Bclial Actor: Linton

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: THE SCHOOL FOR ARROGANCE

Cast
Role: Skaiters Actor: Gray, Linton

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Bclial Actor: Linton

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Bclial Actor: Linton

Performances

Mainpiece Title: The Travellers In Switzerland

Cast
Role: Landlord Actor: Linton

Afterpiece Title: THE DEAF LOVER

Performances

Mainpiece Title: The Tender Husband; Or, The Accomplished Fools

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Bclial Actor: Linton

Performances

Mainpiece Title: The Travellers In Switzerland

Cast
Role: Landlord Actor: Linton

Afterpiece Title: THE FOLLIES OF A DAY

Dance: Mainpiece: To conclude with The Savoyard by Byrn, Mlle St. Amand and Mme Rossi

Performances

Mainpiece Title: The Travellers In Switzerland

Cast
Role: Landlord Actor: Linton

Afterpiece Title: CATHERINE AND PETRUCHIO

Dance: As17940225

Performances

Mainpiece Title: The Travellers In Switzerland

Cast
Role: Landlord Actor: Linton

Afterpiece Title: LOVERS' QUARRELS

Dance: As17940225

Performances

Mainpiece Title: The Travellers In S Witzerland

Cast
Role: Landlord Actor: Linton

Afterpiece Title: THE IRISHMAN IN LONDON

Dance: As17940225

Performances

Mainpiece Title: The Travellers In Switzerland

Cast
Role: Landlord Actor: Linton

Afterpiece Title: THE MIDNIGHT HOUR

Dance: As17940225

Performances

Mainpiece Title: The Travellers In Switzerland

Cast
Role: Landlord Actor: Linton

Afterpiece Title: MODERN ANTIQUES

Dance: As17940225

Performances

Mainpiece Title: The Travellers In Switzerland

Cast
Role: Landlord Actor: Linton

Afterpiece Title: HE WOU'D BE A SOLDIER

Dance: As17940225

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Performances

Mainpiece Title: The Travellers In Switzerland

Cast
Role: Landlord Actor: Linton

Afterpiece Title: HE WOU'D BE A SOLDIER

Dance: As17940225

Performances

Mainpiece Title: The Travellers In Switzerland

Cast
Role: Landlord Actor: Linton

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Bclial Actor: Linton

Dance: As17940225

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Performances

Mainpiece Title: The Travellers In Switzerland

Cast
Role: Landlord Actor: Linton

Afterpiece Title: HE WOU'D BE A SOLDIER

Dance: As17940225

Performances

Mainpiece Title: Alexander's Feast

Music: End of Part I Giardini's Sixth Concerto on the Violin by G. Ashley

Performances

Mainpiece Title: The Travellers In Switzerland

Cast
Role: Landlord Actor: Linton

Afterpiece Title: THREE WEEKS AFTER MARRIAGE

Dance: As17940225

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Bclial Actor: Linton

Performances

Mainpiece Title: The Travellers In Switzerland

Cast
Role: Landlord Actor: Linton

Afterpiece Title: ANIMAL MAGNETISM

Dance: As17940225

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Music: End of Part II concerto on the organ by C. Wesley (1st appearance in public)

Performances

Mainpiece Title: The Travellers In Switzerland

Cast
Role: Landlord Actor: Linton

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Bclial Actor: Linton

Dance: As17940225