SELECT * FROM london_stages WHERE eventid IN (1373, 1413, 1542, 1828, 1990, 2059, 2251, 2381, 2520, 3302, 3532, 3626, 3941, 4050, 4111, 4301, 4426, 4606, 4613, 4627, 4676, 4711, 4825, 4895, 4988, 5109, 5173, 5303, 5725, 5782, 5840, 6090, 6144, 6303, 6527, 6583, 6643, 6666, 6738, 6851, 6908, 7028, 7099, 7240, 7351, 7388, 7450, 7458, 7464, 7489, 7500, 7612, 7757, 7880, 7897, 7975, 8012, 8082, 8146, 8186, 8198, 8267, 8352, 8378, 8473, 8742, 8755, 8843, 8872, 8911, 9025, 9038, 9168, 9194, 9306, 9370, 9511, 9549, 9632, 9831, 9832, 9888, 9986, 10082, 10249, 10299, 10396, 10483, 10564, 10809, 10966, 10999, 11300, 11301, 11392, 11403, 11408, 11510, 11553, 11605, 11804, 12197, 12255, 12361, 12394, 12679, 12733, 12870, 12910, 12922, 12952, 12964, 13238, 13287, 13307, 13404, 13474, 13512, 13603, 13609, 13646, 13670, 13726, 13861, 13878, 13904, 14060, 14130, 14253, 14365, 14378, 14438, 14491, 14664, 14686, 14801, 14930, 14941, 14959, 15034, 15063, 15149, 15175, 15203, 15238, 15323, 15353, 15557, 15759, 15804, 15861, 15972, 15976, 15978, 15986, 15992, 16022, 16401, 16449, 16609, 16638, 16805, 16861, 16863, 16993, 17191, 17245, 17402, 17438, 17464, 17467, 17485, 17488, 17492, 17494, 17497, 17530, 17753, 17755, 17856, 18097, 18245, 18300, 18305, 18688, 18758, 18776, 18870, 19011, 19065, 19124, 19130, 19167, 19263, 19277, 19310, 19350, 19359, 19390, 19399, 19445, 19545, 19616, 19622, 19647, 19682, 19687, 19778, 19794, 19815, 19881, 20106, 20192, 20263, 20296, 20312, 20327, 20367, 20373, 20379, 20420, 20430, 20474, 20476, 20479, 20482, 20486, 20493, 20497, 20505, 20510, 20514, 20516, 20525, 20528, 20536, 20546, 20550, 20554, 20586, 20596, 20633, 20647, 20653, 20672, 20687, 20721, 20727, 20787, 20793, 20809, 20812, 20822, 20828, 20848, 20890, 20899, 20928, 20944, 20975, 20997, 21014, 21024, 21110, 21146, 21166, 21172, 21238, 21240, 21278, 21337, 21345, 21363, 21384, 21399, 21454, 21530, 21554, 21578, 21630, 21668, 21687, 21741, 21767, 21832, 21873, 21875, 21886, 21972, 22023, 22096, 22135, 22180, 22193, 22222, 22240, 22336, 22404, 22477, 22480, 22505, 22552, 22583, 22591, 22669, 22779, 22792, 22795, 22826, 22855, 22927, 22929, 22938, 22946, 22970, 23049, 23121, 23182, 23196, 23209, 23269, 23285, 23345, 23428, 23450, 23632, 23658, 23708, 23725, 23792, 23826, 23867, 23891, 23918, 24016, 24038, 24257, 24329, 24377, 24379, 24530, 24699, 24723, 24867, 24890, 24911, 24997, 25154, 25290, 25312, 25373, 25426, 25503, 25691, 25725, 25826, 25832, 25839, 25855, 25903, 25945, 25981, 26025, 26029, 26136, 26169, 26192, 26247, 26271, 26383, 26417, 26574, 27023, 27028, 27080, 27090, 27165, 27225, 27501, 27533, 27539, 27595, 27610, 27615, 27678, 27707, 27773, 28046, 28175, 28179, 28248, 28286, 28327, 28400, 28406, 28494, 28634, 28748, 28752, 28757, 28814, 28864, 29029, 29220, 29232, 29298, 29349, 29361, 29469, 29569, 29855, 29857, 30001, 30036, 30073, 30119, 30139, 30439, 30527, 30543, 30558, 30570, 30590, 30604, 30638, 30652, 30662, 30669, 30673, 30802, 30825, 30827, 31110, 31203, 31221, 31224, 31366, 31367, 31374, 31426, 31439, 31536, 31605, 31657, 31708, 31874, 31878, 31886, 31896, 31902, 31940, 31944, 32020, 32023, 32032, 32074, 32100, 32127, 32188, 32220, 32346, 32424, 32659, 32872, 33027, 33037, 33194, 33621, 33822, 33830, 33836, 33848, 33861, 33908, 33946, 33985, 34027, 34032, 34101, 34151, 34165, 34176, 34184, 34318, 34357, 34423, 34513, 34547, 34585, 34706, 34775, 34806, 34907, 34943, 35014, 35246, 35265, 35372, 35416, 35460, 35464, 35543, 35652, 35667, 35910, 35966, 36108, 36120, 36144, 36148, 36152, 36156, 36160, 36293, 36452, 36494, 36517, 36811, 36875, 37019, 37102, 37226, 37242, 37304, 37545, 37653, 38115, 38220, 38245, 38326, 38358, 38483, 38490, 38685, 38915, 38961, 39014, 39059, 39119, 39197, 39248, 39353, 39354, 39357, 39359, 39384, 39396, 39415, 39468, 39470, 39471, 39487, 39506, 39662, 39667, 39776, 39831, 40045, 40164, 40169, 40178, 40187, 40211, 40218, 40235, 40304, 40324, 40352, 40427, 40435, 40626, 40642, 40669, 40738, 40779, 40894, 40948, 41092, 41094, 41096, 41097, 41154, 41163, 41174, 41181, 41190, 41203, 41215, 41229, 41243, 41252, 41257, 41264, 41271, 41273, 41299, 41376, 41390, 41498, 41518, 41520, 41585, 41620, 41759, 41772, 41809, 41838, 42050, 42194, 42332, 42403, 42546, 42565, 42580, 42678, 42687, 42887, 42972, 42994, 43064, 43068, 43176, 43182, 43183, 43258, 43278, 43336, 43504, 43686, 43966, 44212, 44267, 44284, 44353, 44373, 44393, 44423, 44612, 44703, 44801, 44984, 45002, 45091, 45227, 45301, 45312, 45315, 45340, 45353, 45381, 45456, 45729, 45755, 45804, 45879, 46080, 46110, 46329, 46502, 46504, 46649, 46671, 46705, 46745, 46858, 46883, 47096, 47167, 47173, 47179, 47192, 47207, 47226, 47231, 47279, 47283, 47539, 47661, 47694, 47733, 47830, 48064, 48265, 48313, 48588, 48621, 48662, 48708, 49406, 49479, 49585, 49716, 50121, 50163, 50230, 50235, 50287, 50345, 50353, 50469, 50472, 50561, 50567, 50582, 50637, 50673, 50704, 50709, 50712, 50717, 50722, 50726, 50728, 50767, 50893, 50894, 50935, 50967, 50988, 51017, 51040, 51047, 51149, 51244, 51331, 51354, 51464, 51490, 51548, 51630, 51633, 51635, 51638, 51640, 51642, 51703, 51873, 51878, 51931, 52069, 52084, 52123, 52124, 52131, 52215, 52281, 52402, 52420, 52460, 52478, 52499) 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: Abroad And At Home

Afterpiece Title: Lovers' Quarrels

Cast
Role: Don Lorenzo Actor: Claremont

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Cast
Role: Lorenzo Actor: Trueman

Afterpiece Title: The Deserter

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Cast
Role: Lorenzo Actor: Trueman

Afterpiece Title: No Song No Supper

Performances

Mainpiece Title: The Merchant Of Venice

Cast
Role: Lorenzo Actor: Dignum

Afterpiece Title: A Friend in Need

Song: In afterpiece: As17970210 In III: a new Duett (composed by Shaw) [In vows of everlasting truth (BUC 942)]-Dignum, Mrs Bland; In afterpiece: As17970210

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Cast
Role: Lorenzo Actor: Trueman

Afterpiece Title: Lodoiska

Ballet: End: The Labyrinth. As17970306

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Cast
Role: Lorenzo Actor: Trueman

Afterpiece Title: The Smugglers

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: Italian Villagers

Cast
Role: Lorenzo Actor: Incledon

Afterpiece Title: The Farm House

Performances

Mainpiece Title: Italian Villagers

Cast
Role: Lorenzo Actor: Incledon

Afterpiece Title: Raymond and Agnes

Performances

Mainpiece Title: Italian Villagers

Cast
Role: Lorenzo Actor: Incledon

Afterpiece Title: Raymond and Agnes

Performances

Mainpiece Title: Italian Villagers

Cast
Role: Lorenzo Actor: Incledon

Afterpiece Title: Raymond and Agnes

Performances

Mainpiece Title: Italian Villagers

Cast
Role: Lorenzo Actor: Incledon

Afterpiece Title: Raymond and Agnes

Performances

Mainpiece Title: Italian Villagers

Cast
Role: Lorenzo Actor: Incledon

Afterpiece Title: Raymond and Agnes

Performances

Mainpiece Title: Fashionable Levities

Afterpiece Title: Lock and Key

Afterpiece Title: Lovers' Quarrels

Cast
Role: Don Lorenzo Actor: Claremont

Afterpiece Title: Bantry Bay

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: An Harmonic Festival

Afterpiece Title: Lovers' Quarrels

Cast
Role: Don Lorenzo Actor: Claremont

Dance: End I: The Statute Dance-

Performances

Mainpiece Title: The Merchant Of Venice

Cast
Role: Lorenzo Actor: Davies

Afterpiece Title: Peeping Tom

Performances

Mainpiece Title: The Merchant Of Venice

Cast
Role: Lorenzo Actor: Davies

Afterpiece Title: The Padlock

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Cast
Role: Lorenzo Actor: Trueman

Afterpiece Title: The Chimney Corner

Performances

Mainpiece Title: The Merchant Of Venice

Cast
Role: Lorenzo Actor: Clarke

Afterpiece Title: The Citizen

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Cast
Role: Lorenzo Actor: Trueman

Afterpiece Title: The Devil to Pay

Afterpiece Title: A Trip to the Nore

Performances

Mainpiece Title: The Merchant Of Venice

Cast
Role: Lorenzo Actor: Dignum

Afterpiece Title: The Children in the Wood

Performances

Mainpiece Title: The Merchant Of Venice

Cast
Role: Lorenzo Actor: Dignum

Afterpiece Title: The Citizen

Performances

Mainpiece Title: The Italian Villagers; Or, The Bride Groom

Cast
Role: Lorenzo Actor: Incledon

Afterpiece Title: The Round Tower

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Cast
Role: Lorenzo Actor: Trueman

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The School For Scandal

Afterpiece Title: The Raft; or, Both Sides of the Water

Afterpiece Title: Lovers' Quarrels

Cast
Role: Don Lorenzo Actor: Claremont

Song: In III 1st piece: a song-Incledon

Performances

Mainpiece Title: The Merchant Of Venice

Cast
Role: Lorenzo Actor: Townsend

Afterpiece Title: The Farmer