SELECT * FROM london_stages WHERE eventid IN (2617, 7410, 7719, 12165, 12243, 13371, 13441, 18342, 18346, 18349, 18353, 20703, 20857, 20892, 20990, 21004, 21123, 21161, 21257, 21316, 21347, 21451, 21517, 21612, 21618, 21624, 21627, 21630, 21644, 21652, 21660, 21668, 21669, 21675, 21688, 21749, 21756, 21832, 22178, 22184, 22190, 22349, 22356, 22358, 22359, 22373, 22377, 22379, 22386, 22391, 22424, 22468, 22475, 22481, 22490, 22523, 22529, 22535, 22562, 22568, 22571, 22679, 22709, 22803, 23022, 23155, 23199, 23202, 23203, 23454, 23613, 23695, 23728, 23744, 23747, 23812, 23826, 23842, 23854, 24006, 24009, 24011, 24025, 24027, 24034, 24042, 24056, 24062, 24066, 24069, 24090, 24093, 24100, 24104, 24110, 24137, 24180, 24205, 24240, 24625, 24629, 24632, 24635, 24641, 24644, 24647, 24654, 24679, 24682, 25736, 25744, 25780, 25788, 25793, 25795, 25797, 25799, 25809, 25811, 25815, 25861, 25913, 25924, 25938, 26021, 26210, 26212, 26218, 26222, 26353, 26382, 26387, 27235, 27237, 27247, 27255, 27270, 27277, 27284, 27287, 27290, 27341, 27343, 27351, 27354, 27407, 27412, 27595, 27699, 27701, 27705, 27709, 27711, 27715, 27721, 27725, 27731, 27738, 27766, 27768, 27771, 27778, 27818, 27820, 27823, 27825, 27871, 27993, 28086, 28100, 28104, 28105, 28107, 28112, 28171, 28175, 28181, 28188, 28194, 28196, 28273, 28274, 28280, 28285, 28354, 28365, 28389, 28490, 28511, 28514, 28548, 28553, 28561, 28564, 28568, 28665, 28686, 28697, 28717, 28718, 28729, 28750, 28765, 28776, 28789, 28829, 28848, 28911, 28940, 28947, 28974, 28992, 29023, 29033, 29037, 29062, 29468, 29481, 29527, 29537, 29571, 29852, 29854, 29858, 29860, 29862, 29865, 29869, 29871, 29875, 29878, 29882, 29884, 29887, 29889, 29891, 29893, 29900, 29904, 29906, 29908, 29913, 29915, 29935, 29942, 29953, 29957, 29959, 29963, 29970, 29982, 29984, 29992, 29995, 29998, 30001, 30004, 30010, 30022, 30025, 30029, 30042, 30053, 30073, 30106, 30126, 30133, 30144, 30148, 30152, 30314, 30316, 30318, 30320, 30397, 30570, 30614, 30658, 30800, 30803, 30985, 30987, 30989, 30991, 30993, 30995, 30998, 31001, 31003, 31005, 31007, 31012, 31015, 31017, 31019, 31021, 31023, 31026, 31028, 31031, 31033, 31035, 31037, 31040, 31043, 31049, 31052, 31061, 31069, 31088, 31090, 31094, 31097, 31100, 31102, 31109, 31116, 31124, 31134, 31136, 31155, 31179, 31182, 31189, 31214, 31220, 31221, 31223, 31225, 31274, 31542, 31835, 32013, 32208, 32213, 32233, 32774, 32776, 32778, 32781, 32785, 32794, 32798, 32800, 32803, 32867, 32869, 32871, 32873, 32877, 32881, 32883, 32889, 32891, 32897, 32899, 32902, 32907, 32909, 32918, 32921, 32923, 32927, 32931, 32936, 32940, 32948, 32959, 32961, 32963, 33155, 33190, 33214, 33215, 33217, 33880, 33883, 33885, 33888, 33890, 33892, 33894, 33897, 33899, 33911, 33916, 33918, 33925, 33965, 33973, 33977, 34023, 34037, 34070, 34083, 34116, 34620, 34622, 34635, 34637, 34648, 34700, 34956, 35020, 35056, 35114, 35203, 35231, 35282, 35298, 35304, 35317, 35326, 35349, 35358, 35515, 35731, 35802, 35911, 35922, 35949, 36085, 36234, 36241, 36251, 36255, 36257, 36264, 36273, 36282, 36296, 36322, 36336, 36355, 36381, 36418, 36477, 36492, 36498, 36513, 36555, 36585, 36657, 36745, 36775, 37016, 37066, 37119, 37122, 37165, 37172, 37286, 37288, 37290, 37299, 37305, 37312, 37326, 37335, 37343, 37354, 37548, 37572, 37594, 37626, 38308, 38311, 38705, 38717, 38858, 38869, 39165, 39916, 41635, 41637, 41639, 41641, 41643, 41647, 42076, 42168, 42171, 42175, 42183, 42186, 42191, 42195, 42199, 42205, 42211, 42214, 42217, 42221, 42225, 42229, 42238, 46408, 46590, 46683, 46701, 46731, 47041, 47043, 47047, 47051, 47057, 47063, 47068, 47073, 47079, 47308, 47860, 48091, 48303, 48325, 48370, 48404, 48447, 49338, 49340, 49343, 49345, 49348, 49350, 49352, 49354, 49357, 49359, 49362, 49371, 49373, 49376, 49378, 49385, 49387, 49390, 49392, 49399, 49401, 49425, 49432, 49439, 49452, 49465, 49646, 51309, 51329, 51336, 51359, 51365, 51451) 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 Earl Of Essex

Afterpiece Title: Lethe

Dance: JJovial Coopers, as17571107

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: Lethe

Dance: JJovial Coopers, as17571107

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: Lethe

Dance: II: The Market, as17571126

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Lethe

Dance: FFingalian Dance, by Desire, as17571013

Performances

Mainpiece Title: The Rival Queens

Afterpiece Title: Lethe

Dance: As17571214

Performances

Mainpiece Title: The Earl Of Essex

Afterpiece Title: Lethe

Dance: As17571217

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: Lethe

Dance: FFingalian Dance, as17571013

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Lethe

Dance: SSicilian Peasants, as17571217

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: The Sheep Shearing; or, Florizel and Perdita

Dance: As17571217

Ballet: TThe Judgment of Paris. As17571217

Performances

Mainpiece Title: Douglas

Afterpiece Title: Lethe

Dance: SSicilian Peasants, as17571217

Performances

Mainpiece Title: Othello

Afterpiece Title: Lethe

Dance: SSicilian Peasants, as17571217; Fingalian Dance, as17571013

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: Lethe

Dance: II: By Desire, a new dance-Gallini, Mrs Granier, Miss Viviez; III: Sicilian Peasants, as17571217, but Mlle Capdeville, Miss _Hilliard; IV: +She Wou'd and She Wou'd Not-Gallini, Sga Forti; V: A Minuet-Gallini, a Gentlewoman

Ballet: I: Judgment of Paris. As17580407

Performances

Mainpiece Title: Love Makes A Man

Afterpiece Title: Lethe

Dance: The Provincial Sailors, as17580408

Performances

Mainpiece Title: The Squire Of Alsatia

Afterpiece Title: Britannia

Dance: IV: A Minuet, Louvre-Noverre, Mrs Addison

Performances

Mainpiece Title: The Earl Of Essex

Afterpiece Title: Lethe

Song: III, V: Legg

Dance: IV: Comic Ballet, as17580502

Performances

Mainpiece Title: The Fair Quaker Of Deal

Cast
Role: a song in character Actor: Vernon.

Afterpiece Title: The Oracle

Dance: IV: Hornpipe-Walker

Performances

Mainpiece Title: The Wonder

Afterpiece Title: The Upholsterer

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: The Englishman in Paris

Song: II: A Bacchanalian Song-Beard; V: The new Dialogue of Jenny and Kate-Beard, Miss Young

Performances

Mainpiece Title: The Provok'd Wife

Afterpiece Title: The Englishman in Paris

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: Queen Mab

Ballet: II: The Prussian Camp. As17581214

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: The Englishman in Paris

Song: I: Beard

Dance: II: Hornpipe-Walker; IV: A Comic Dance-Giorgi, Sga Lucchi;

Performances

Mainpiece Title: The Merry Wives Of Indsor

Afterpiece Title: The Fair

Cast
Role: Song in Character Actor: Beard

Performances

Mainpiece Title: As You Like It

Cast
Role: other characters Actor:

Afterpiece Title: The Fair

Cast
Role: Song in Character Actor: Beard

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: The Fair

Cast
Role: Song in Character Actor: Beard

Performances

Mainpiece Title: A Bold Stroke For A Wife

Afterpiece Title: The Fair

Cast
Role: Song in Character Actor: Beard