SELECT * FROM london_stages WHERE eventid IN (16728, 16750, 16806, 16834, 16892, 16900, 16908, 17430, 17440, 17448, 17452, 17455, 17464, 17467, 17469, 17473, 17478, 17491, 17496, 17499, 17502, 17505, 17509, 17512, 17515, 17518, 17526, 17537, 17540, 17604, 17634, 17647, 17651, 17655, 17658, 17668, 17671, 17674, 17677, 17721, 17724, 17728, 17731, 17735, 17739, 17742, 17746, 17754, 17761, 17765, 17776, 17782, 17791, 17795, 17851, 17856, 17861, 17940, 18123, 18184, 18186, 18188, 18194, 18203, 18206, 18210, 18214, 18226, 18228, 18231, 18239, 18241, 18244, 18248, 18250, 18253, 18259, 18273, 18277, 18280, 18288, 18299, 18306, 18309, 18317, 18324, 18335, 18338, 18348, 18355, 18361, 18365, 18368, 18376, 18379, 18382, 18385, 18388, 18391, 18398, 18412, 18424, 18427, 18440, 18446, 18460, 18468, 18493, 18504, 18516, 18886, 18892, 18897, 18904, 19036, 19041, 19043, 19065, 19075, 19101, 19123, 19149, 19245, 19251, 19255, 19261, 19263, 19271, 19281, 19283, 19285, 19291, 19293, 19295, 19300, 19302, 19310, 19314, 19316, 19319, 19321, 19323, 19325, 19327, 19329, 19331, 19333, 19335, 19337, 19339, 19341, 19343, 19349, 19351, 19378, 19380, 19382, 19384, 19387, 19389, 19391, 19395, 19408, 19410, 19412, 19421, 19465, 19474, 19479, 19481, 19483, 19485, 19487, 19489, 19492, 19494, 19537, 19591, 19596, 19612, 19616, 19621, 19622, 19662, 19665, 19668, 19672, 19678, 19680, 19682, 19684, 19686, 19688, 19746, 19754, 19787, 19790, 19794, 19799, 19801, 19821, 19833, 19835, 19851, 19856, 19866, 19869, 19872, 19875, 19879, 19882, 19889, 19900, 19904, 19907, 19909, 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, 20028, 20033, 20039, 20044, 20054, 20058, 20063, 20068, 20072, 20082, 20088, 20098, 20103, 20107, 20111, 20113, 20116, 20160, 20163, 20166, 20190, 20193, 20196, 20199, 20202, 20205, 20217, 20227, 20233, 20245, 20248, 20254, 20257, 20264, 20267, 20273, 20292, 20295, 20311, 20317, 20320, 20323, 20326, 20329, 20343, 20347, 20359, 20378, 20392, 20398, 20415, 20421, 20432, 20438, 20448, 20461, 20755, 20757, 20760, 20802, 20832, 20835, 20838, 20841, 20845, 20854, 20875, 20895, 20898, 20902, 20905, 20908, 20911, 20914, 20917, 20928, 20937, 20948, 20951, 20960, 20964, 20967, 20973, 20980, 20984, 20986, 20990, 20993, 20997, 21000, 21007, 21010, 21013, 21017, 21020, 21027, 21037, 21041, 21045, 21059, 21072, 21079, 21083, 21086, 21092, 21096, 21103, 21109, 21112, 21116, 21119, 21126, 21136, 21161, 21172, 21184, 21202, 21298, 21611, 21619, 21629, 21632, 21682, 21743, 21764, 21785, 21797, 21809, 21824, 22056, 22060, 22062, 22065, 22068, 22071, 22075, 22078, 22081, 22341, 22344, 22345, 22348, 22352, 22994, 22997, 23062, 23100, 23103, 23110, 23113, 23139, 23142, 23168, 23171, 23175, 23178, 23186, 23206, 23214, 23216, 23219, 23225, 23266, 23532, 23537, 23543, 23546, 23591, 23714, 24006, 24009, 24011, 24025, 24027, 24034, 24042, 24056, 24062, 24066, 24069, 24090, 24100, 24104, 24110, 24119, 24122, 24125, 24131, 24134, 24137, 24140, 24143, 24146, 24151, 24157, 24162, 24170, 24178, 24180, 24198, 24211, 24367, 24371, 24380, 24384, 24401, 24437, 24497, 24565, 24977, 24979, 24982, 24985, 24988, 24991, 24997, 24999, 25002, 25004, 25007, 25009, 25011, 25013, 25016, 25018, 25021, 25023, 25025, 25027, 25030, 25032, 25034, 25036, 25039, 25041, 25043, 25045, 25048, 25050, 25052, 25054, 25056, 25058, 25060, 25062, 25064, 25066, 25069, 25071, 25073, 25075, 25077, 25080, 25082, 25085, 25087, 25089, 25091, 25093, 25095, 25097, 25099, 25103, 25105, 25107, 25109, 25111, 25113, 25115, 25118, 25120, 25193, 25198, 25211, 25214, 25241, 25250, 25256, 25263, 25296, 25392, 25486, 25491, 25493, 25495, 25497, 25499, 25509, 25511, 25513, 25515, 25517, 25519, 25527, 25531, 25538, 25540, 25544, 25567, 25569, 25575, 25577, 25581, 25588, 25590, 25598, 25602, 25605, 25610, 25615, 25619, 25623, 25634, 25672, 25748, 25793, 25795, 25797, 25799, 25809, 25811, 25815, 25817, 25821, 25823, 25826, 25832, 25834, 25837, 25839, 25841, 25843, 25845, 25847, 25849, 25851, 25853, 25855, 25887, 25897, 25903, 25910, 25913, 25915, 25926, 25933, 25938, 25942, 25949, 25953, 26197, 26199, 26303, 26312, 26318, 26321, 26324, 26327, 26351, 26356, 28766, 28865, 28870, 28872, 28875, 28880, 28886, 28892, 28897, 28903, 28909, 28916, 28923, 28927, 28965, 29020, 29032, 29238, 29240, 29245, 29247, 29249, 29263, 29279, 29283, 29288, 29307, 29313, 29323, 29328, 29347, 29458, 29509, 29852, 29854, 29858, 29860, 29862, 29865, 29869, 29871, 29875, 29878, 29882, 29884, 29887, 29889, 29891, 29893, 29900, 29904, 29906, 29908, 29913, 29915, 29918, 29922, 29925, 29928, 29930, 29933, 29935, 29939, 29942, 29944, 29950, 29953, 29955, 29957, 29959, 29963, 29966, 29970, 29982, 29984, 29992, 29995, 29998, 30001, 30004, 30010, 30022, 30025, 30029, 30049, 30053, 30056, 30064, 30069, 30076, 30126, 30131, 30144, 30146, 30148, 30150, 30152, 30154, 30322, 30326, 30328, 30330, 30375, 30384, 30394, 30409, 30411, 30414, 30421, 30428, 30433, 30442, 30449, 30456, 30464, 30466, 30471, 30550, 30586, 30590, 30681, 30683, 30689, 30794, 30802, 30807, 30815, 30817, 30823, 30827, 30831) 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: All's Well That Ends Well

Afterpiece Title: The Fortune Tellers

Cast
Role: Adonis Actor: Desse

Song: I: Song with French Horns-Beard; IV: Song-Beard

Dance: II: A Dutch Dance, as17411114; III: The Italian Peasants, as17411205

Performances

Mainpiece Title: All's Well That Ends Well

Afterpiece Title: Fortune Tellers

Cast
Role: Adonis Actor: Desse

Song: I, III: Song-Mrs Arne

Dance: II: Le Genereux Corsaire, as17420218

Ballet: V: Les Satires Puny. As17420106

Performances

Mainpiece Title: All's Well That Ends Well

Afterpiece Title: Harlequin Shipwrecked

Song: I: Celia has ten thousand charms-Beard; III: Song with French Horns-Beard

Dance: II: A Concerto, as17420105; IV: The Italian Peasants, as17411205

Performances

Mainpiece Title: All's Well That Ends Well

Afterpiece Title: The Fortune Tellers

Cast
Role: Adonis Actor: Desse

Song: I: See from the Silent Groves-Beard; IV: Song in Italian-Beard

Dance: II: The Swiss, as17410926; III: A Miller's Dance-Delamain

Performances

Mainpiece Title: The Recruiting Officer

Song: I: See from the Silent Groves-Beard; III: The Early Horn-Lowe; IV: Duet-Beard, Lowe

Dance: II: Les Egyptiens, as17420224

Ballet: V: Les Satires Puny. As17420106

Performances

Mainpiece Title: The Provoked Wife

Song: I: a Ballad-Lowe; III: Song-Mrs Arne; IV: Bright Author of my Present Flame-Lowe

Dance: II: Les Egyptiens, as17420224

Ballet: V: a Grand Comic Ballet The Peasant. Peasants-The Fausans; Shepherds-LaCroix, Desse, Constantini; Shepherdesses-Mrs Walter, Mrs Thompson, Miss Story

Cast
Role: Shepherds Actor: LaCroix, Desse, Constantini

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: Harlequin Shipwrecked

Song: I: Celia has ten thousand Charms-Beard; IV: A Song with French Horns-Beard

Dance: III: The Swiss, as17410926

Performances

Mainpiece Title: All's Well That Ends Well

Afterpiece Title: Harlequin Shipwrecked

Song: I: Ballad-Lowe; IV: The Early Horn-Lowe

Dance: II: The Serious Dance, as17420322 III: Dutch Dance, as17411219

Performances

Afterpiece Title: The Mock Doctor

Performances

Afterpiece Title: The Mock Doctor

Dance: I: Running Footman's Dance-Phillips; III: The Drunken Peasant-Phillips

Entertainment: AA Lesson on the Welch Harp-Mr Jones

Performances

Mainpiece Title: Cato

Performances

Mainpiece Title: The Stratagem

Music: IV: Concerto-Piantanida

Performances

Afterpiece Title: The Lying Valet

Dance: Boromeo, Desse, Mlle Bonneval

Performances

Mainpiece Title: The Country Wife

Song: II: Stella and Flavia-Beard; IV: (By Particular Desire) Bumper Squire Jones-Beard

Music: IV: a Concerto-Piantanida

Dance: III: A Comic Dance-Boromeo, Mlle Bonneval

Performances

Afterpiece Title: The School Boy

Performances

Mainpiece Title: The Recruiting Officer

Dance: II: Neopolitan Punch, as17430324 IV: La Florana, as17430408

Performances

Mainpiece Title: The Country Wife

Song: As17430120

Dance: II: Sicilian Peasant, as17430310 IV: Italian Gardeners, as17421231

Performances

Mainpiece Title: Cato

Dance: II: La Florana, as17430408

Song: III: Bumper Squire Jones-Beard, Lowe

Music: IV: New Violincello Concerto-Cervetto

Performances

Mainpiece Title: Venice Preserved

Song: As17430413

Dance: III: Tyrolean Dance, as17421129

Performances

Mainpiece Title: The Unhappy Favorite

Afterpiece Title: The Amorous Goddess; or, Harlequin Married

Performances

Mainpiece Title: Cato

Afterpiece Title: The Amorous Goddess

Cast
Role: Shepherds Actor: Muilment, Desse, Liviez, Baudouin

Performances

Mainpiece Title: The Alchemist

Afterpiece Title: The Amorous Goddess

Cast
Role: Shepherds Actor: Muilment, Desse, Liviez, Baudouin

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: The Amorous Goddess

Cast
Role: Shepherds Actor: Muilment, Desse, Liviez, Baudouin