SELECT * FROM london_stages WHERE eventid IN (14466, 14469, 14492, 14496, 14499, 14785, 14796, 14826, 17721, 17724, 17728, 17731, 17735, 17739, 17742, 17746, 17754, 17761, 17765, 17776, 17782, 17791, 17795, 17940, 18123, 30706, 30707, 30709, 30710, 30714, 30716, 30718, 30720, 30723, 30726, 30729, 30733, 30741, 30745, 30746, 30748, 30752, 30755, 30757, 30761, 36001, 36019, 36033, 36047, 36049, 36051, 36053, 36055, 36059, 36070, 36078, 36093, 36095, 36104, 36120, 36184, 36201, 36210, 36246, 36248, 36262, 36271, 36277, 36293, 36301, 36317, 36338, 36372, 36391, 36421, 36429, 36434, 36437, 36440, 36445, 36452, 36460, 36473, 36482, 36488, 36490, 36494, 36508, 36511, 36516, 36521, 36526, 36534, 36535, 36539, 36545, 36555, 36563, 36565, 36570, 36573, 36581, 36583, 36584, 36585, 36586, 36594, 36602, 36603, 36608, 36623, 36626, 36631, 36651, 36659, 36663, 36667, 36669, 36671, 36673, 36680, 36682, 36686, 36702, 36708, 36719, 36726, 36738, 36745, 36752, 36754, 36759, 36768, 36773, 36784, 36806, 36811, 36855, 36858, 36873, 36875, 36892, 36904, 36906, 36911, 36925, 36939, 36974, 37025, 37028, 37031, 37033, 37049, 37052, 37068, 37071, 37073, 37080, 37085, 37087, 37093, 37096, 37098, 37101, 37103, 37104, 37109, 37124, 37125, 37131, 37133, 37135, 37149, 37157, 37160, 37162, 37163, 37165, 37167, 37168, 37170, 37172, 37173, 37175, 37177, 37178, 37179, 37180, 37183, 37186, 37188, 37189, 37190, 37193, 37199, 37201, 37203, 37204, 37685, 37688, 37692, 37693, 37697, 37699, 37702, 37707, 37708, 37710, 37719, 37722, 37729, 37736, 37750, 37753, 37763, 37771, 37777, 37780, 38212, 38218, 38229, 38235, 38241, 38246, 38250, 38254, 38257, 38260, 38268, 38274, 38278, 38280, 38283, 38285, 38288, 38296, 38299, 38303, 38305, 38307, 38309, 38352, 38354, 38358, 38384, 38386, 38405, 38408, 38423, 38426, 38428, 38435, 38446, 38449, 38451, 38491, 38495, 38499, 38501, 38510, 38512, 38546, 38569, 38574, 38576, 38589, 38594, 38625, 38628, 38640, 38643, 38654, 38676, 38690, 38699, 38704, 38717, 38725, 38730, 38754, 38762, 38764, 38765, 38767, 38770, 38780, 38784, 38807, 38812, 38817, 38821, 38829, 38830, 38843, 38846, 38851, 38852, 38861, 38868, 38871, 38880, 38884, 38886, 38892, 38896, 38913, 38919, 38921, 38925, 38929, 38943, 38947, 38957, 38966, 38971, 38973, 38977, 38985, 38991, 38994, 39004, 39012, 39014, 39016, 39018, 39021, 39027, 39035, 39037, 39084, 39089, 39091, 39096, 39099, 39108, 39133, 39136, 39138, 39147, 39152, 39157, 39161, 39166, 39172, 39178, 39185, 39191, 39200, 39203, 39206, 39209, 39211, 39217, 39220, 39223, 39226, 39231, 39235, 39243, 39251, 39254, 39261, 39263, 39266, 39274, 39281, 39289, 39292, 39294, 39297, 39304, 39307, 39309, 39316, 39318, 39321, 39323, 39327, 39446, 39448, 39458, 39461, 39464, 39466, 39471, 39473, 39475, 39487, 39492, 39496, 39500, 39505, 39507, 39512, 39519, 39554, 39570, 39577, 39579, 39584, 39587, 39589, 39596, 39598, 39606, 39614, 39616, 39652, 39654, 39656, 39676, 39681, 39683, 39696, 39722, 39741, 39744, 39746, 39751, 39776, 39831, 39836, 39841, 39844, 39848, 39850, 39860, 39864, 39872, 39884, 39887, 39895, 40026, 40030, 40040, 40042, 40048, 40051, 40063, 40083, 40105, 40128, 40137, 40144, 40151, 40176, 40185, 40212, 40248, 40265, 40297, 40326, 40335, 40338, 40340, 40345, 40353, 40355, 40360, 40369, 40372, 40387, 40389, 40396, 40398, 40406, 40408, 40411, 40413, 40420, 40431, 40444, 40446, 40448, 40566, 40570, 40613, 40626, 40640, 40642, 40646, 40651, 40669, 40693, 40708, 40711, 40726, 40738, 40779, 40819, 40821, 40870, 40894, 40900, 40920, 40936, 40948, 40962, 40965, 40970, 40974, 40985, 40987, 40997, 41132, 41139, 41143, 41174, 41181, 41190, 41203, 41215, 41229, 41236, 41243, 41257, 41281, 41309, 41311, 41332, 41376, 41379, 41390, 41399, 41421, 41425, 41458, 41542, 41547, 41573, 41699, 41718, 41723, 41731, 41745, 41759, 41770, 41772, 41809, 41843, 41875, 41882, 41898, 42050, 42056, 42061, 42124, 42147, 42160, 42163, 44961) 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 Beggar's Opera

Cast
Role: Lucy Actor: Miss Catley
Role: Polly Actor: Miss Brown.

Afterpiece Title: Don Quixote in England

Performances

Mainpiece Title: The Maid Of The Mill

Cast
Role: Fanny Actor: Miss Brown

Afterpiece Title: Cross Purposes

Cast
Role: Polly Actor: Miss Catley
Role: Emily Actor: Miss Ambrose

Dance: As17770515

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Rose Actor: Miss Leeson

Afterpiece Title: The Lyar

Cast
Role: Miss Godfrey Actor: Miss Ambrose

Dance: As17761123

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Melinda Actor: Miss Ambrose
Role: Rose Actor: Miss Dayes

Afterpiece Title: The Padlock

Cast
Role: Leonora Actor: Miss Brown.

Performances

Mainpiece Title: Sir Thomas Overbury

Cast
Role: Cleora Actor: Miss Leeson

Afterpiece Title: The Commissary

Cast
Role: Mrs Mechlin Actor: Miss Ambrose.

Dance: End: The Shepherd's Wedding-Harris, Miss Matthews

Performances

Mainpiece Title: King Lear

Cast
Role: Regan Actor: Miss Ambrose
Role: Arante Actor: Miss Green

Afterpiece Title: The Royal Chace

Cast
Role: Colombine Actor: Miss Matthews.

Dance: As17771001

Performances

Mainpiece Title: The Conscious Lovers

Cast
Role: Lucinda Actor: Miss Ambrose

Afterpiece Title: The Royal Chace

Cast
Role: Colombine Actor: Miss Matthews.

Dance: End III: The Humours of Leixlip-Aldridge, Master Jackson, Miss Besford

Song: II: song [I have lost my Anna]-Leoni

Performances

Afterpiece Title: The Padlock

Cast
Role: Leonora Actor: Miss Brown.

Dance: End: The Humours of Leixlip, as17771008

Performances

Mainpiece Title: King Lear

Cast
Role: Regan Actor: Miss Ambrose
Role: Arante Actor: Miss Green

Afterpiece Title: The Apprentice

Cast
Role: Charlotte Actor: Miss Dayes.

Dance: As17771001

Performances

Mainpiece Title: The Merchant Of Venice

Cast
Role: Jessica Actor: Miss Dayes

Afterpiece Title: Love a-la-Mode

Cast
Role: Charlotte Actor: Miss Ambrose.

Dance: End III: The Shepherd's Wedding, as17770924; End IV: As17771008

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Polly Actor: Miss Brown

Afterpiece Title: The Commissary

Cast
Role: Mrs Mechlin Actor: Miss Ambrose.

Dance: End: As17771008; III: a Hornpipe-Miss Besford

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Polly Actor: Miss Brown

Afterpiece Title: Cross Purposes

Cast
Role: Emily Actor: Miss Ambrose

Dance: Hornpipe, as17771017; End: As17771001

Performances

Mainpiece Title: The Merchant Of Venice

Cast
Role: Jessica Actor: Miss Dayes

Afterpiece Title: Love a-la-Mode

Cast
Role: Charlotte Actor: Miss Ambrose.

Dance: End III: The Shepherd's Wedding, as17770924; End IV: As17771008

Performances

Mainpiece Title: Know Your Own Mind

Cast
Role: Lady Jane Actor: Miss Dayes
Role: La Rouge Actor: Miss Ambrose

Afterpiece Title: Comus

Song: Afterpiece: Sweet Echo-Leoni, Mrs Farrell. [This was sung, as here assigned, in all subsequent performances.

Performances

Mainpiece Title: Othello

Afterpiece Title: Comus

Performances

Mainpiece Title: The Conscious Lovers

Cast
Role: Lucinda Actor: Miss Ambrose

Afterpiece Title: Love a-la-Mode

Cast
Role: Charlotte Actor: Miss Ambrose.

Dance: End: The Enchantress-Aldridge, Harris, Miss Valois

Song: As17771008

Performances

Mainpiece Title: The Orphan Of China

Afterpiece Title: Cross Purposes

Cast
Role: Emily Actor: Miss Ambrose

Dance: As17771104

Performances

Mainpiece Title: King Richard The Third

Cast
Role: Prince Edward Actor: Miss Morris

Afterpiece Title: Comus

Performances

Mainpiece Title: King Lear

Cast
Role: Regan Actor: Miss Ambrose
Role: Arante Actor: Miss Green

Afterpiece Title: Comus

Performances

Mainpiece Title: The Grecian Daughter

Cast
Role: Erixene Actor: Miss Ambrose

Afterpiece Title: Love a-la-Mode

Cast
Role: Charlotte Actor: Miss Ambrose.

Dance: As17771111

Performances

Mainpiece Title: The Grecian Daughter

Cast
Role: Erixene Actor: Miss Ambrose

Afterpiece Title: The Norwood Gypsies

Dance: As17771125

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Melinda Actor: Miss Ambrose
Role: Rose Actor: Miss Dayes

Afterpiece Title: The Norwood Gypsies

Dance: As17771125

Performances

Mainpiece Title: Percy

Afterpiece Title: Comus

Performances

Mainpiece Title: Percy

Afterpiece Title: Comus

Performances

Mainpiece Title: Percy

Afterpiece Title: Comus