SELECT * FROM london_stages WHERE eventid IN (679, 1136, 2026, 2578, 17275, 17686, 17689, 17693, 17697, 17700, 17702, 17706, 17710, 17713, 17718, 17720, 17723, 17730, 17734, 17738, 17741, 17745, 17753, 17757, 17764, 17768, 17771, 17775, 17781, 17784, 17787, 17790, 17794, 17798, 17800, 17807, 17811, 17814, 18054, 18058, 18204, 18209, 18211, 18213, 18232, 18234, 18238, 18252, 18255, 18260, 18389, 18392, 18399, 18403, 18405, 18409, 18761, 19933, 20622, 20628, 20631, 20920, 21533, 22611, 23043, 31120, 31123, 31126, 31131, 31133, 31139, 31194, 31208, 31214, 31229, 31255, 32900, 32905, 32912, 34111, 34640, 34923, 34925, 34927, 34929, 34931, 34933, 34935, 34937, 34939, 34941, 34943, 34945, 34947, 34949, 34951, 34953, 34955, 34957, 34959, 34961, 34966, 34968, 34970, 34972, 34975, 34980, 34984, 34986, 34989, 34991, 34996, 34998, 35000, 35003, 35005, 35010, 35012, 35014, 35019, 35024, 35026, 35031, 35033, 35038, 35040, 35042, 35045, 35048, 35053, 35057, 35060, 35062, 35064, 35066, 35070, 35074, 35076, 35078, 35088, 35092, 35094, 35104, 35108, 35111, 35118, 35125, 35127, 35129, 35135, 35143, 35149, 35160, 35164, 35169, 35174, 35177, 35179, 35182, 35184, 35187, 35207, 35210, 35218, 35223, 35264, 35277, 35289, 35305, 35365, 35372, 35382, 35572, 36023, 36028, 36030, 36032, 36034, 36036, 36038, 36040, 36044, 36050, 36065, 36067, 36069, 36076, 36079, 36082, 36086, 36092, 36094, 36098, 36101, 36348, 36351, 36353, 36356, 36358, 36360, 36368, 36371, 36373, 36375, 36377, 36380, 36382, 36389, 36399, 36407, 36410, 36415, 36422, 36430, 36446, 36469, 36483, 36491, 36505, 36507, 36509, 36519, 36527, 36562, 36664, 36672, 36676, 36681, 36693, 36746, 36748, 36755, 36928, 36994, 37000, 37035, 37062, 37318, 37325, 37327, 37330, 37339, 37348, 37355, 37358, 37379, 37381, 37583, 37590, 37619, 37631, 37641, 37672, 37674, 37749, 37754, 37760, 37766, 38232, 38248, 38262, 38606, 38617, 38622, 38632, 38637, 38647, 38651, 38661, 38666, 38899, 38901, 38903, 38904, 38906, 38908, 38910, 38912, 38914, 38916, 38920, 38924, 38926, 38928, 38934, 38939, 38944, 38948, 38953, 38960, 38970, 38982, 39022, 39024, 39078, 39083, 39095, 39104, 39142, 39149, 39181, 39202, 39225, 39268, 41150, 41152, 41154, 41156, 41158, 41160, 41162, 41166, 41176, 41184, 41187, 41241, 41273, 41278, 41529, 41579, 41580, 41585, 41586, 41590, 41594, 41598, 41609, 41612, 41617, 41620, 41624, 41632, 41638, 41640, 41644, 41645, 42187, 42194, 42198, 42222, 42226, 42227, 42386, 42389, 42392, 42394, 42398, 42401, 42406, 42408, 42415, 42417, 42422, 42430, 42437, 42442, 42445, 42448, 42450, 42452, 42455, 42463, 42472, 42496, 42499, 42501, 42504, 42506, 42508, 42510, 42513, 42530, 42534, 42569, 42597, 42668, 42743, 42764, 42766, 42767, 42770, 42772, 42780, 42831, 42833, 42834, 42835, 42837, 42847, 42849, 43380, 43390, 43398, 43402, 43407, 43420, 43423, 44001, 44025, 44715, 44717, 44719, 44721, 44723, 44726, 44728, 44731, 44733, 44735, 44737, 44740, 44743, 44746, 44748, 44750, 44752, 44755, 44757, 44760, 44762, 44764, 44766, 44769, 44771, 44774, 44776, 44783, 44794, 44805, 44808, 44817, 44834, 44847, 44853, 44863, 44907, 44957, 46377, 46517, 46527, 46531, 46541, 46545, 46555, 46559, 46569, 46573, 46583, 46588, 47448, 47450, 47452, 47453, 47455, 47457, 47460, 47461, 47463, 47465, 47468, 47476, 47477, 47481, 47486, 47506, 47510, 47514, 47528, 47530, 47536, 47538, 47546, 47552, 47556, 47558, 47563, 47576, 47579, 47583, 47640, 47682, 47718, 47751, 47758, 47781, 47791, 47796, 47834, 47849, 47873, 47889, 47893, 47901, 47902, 47905, 47910, 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, 48851, 48856, 48865, 48870, 48877, 48902, 48916, 48921, 48923, 48930, 48940, 48945, 48952, 48954, 48959, 48961, 48964, 48966, 48968, 48970, 48980, 48988, 48990, 48993, 49009, 49014, 49021, 49023, 49033, 49038, 49041, 49053, 49056, 49066, 49077, 49081, 49083, 49086, 49090, 49100, 49193, 49199, 49206, 49214, 49620, 49657, 49664, 49825, 49827, 49831, 52200, 52202, 52204, 52206, 52208, 52210, 52212, 52214, 52216, 52218, 52221, 52223, 52225, 52227, 52229, 52231, 52234, 52236, 52239, 52248, 52250, 52253, 52255, 52257, 52259, 52262, 52264, 52269, 52271) 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: He Wou'd Be A Soldier

Afterpiece Title: The Enchanted Castle

Cast
Role: Ballad Singer Actor: Gaudry

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Enchanted Castle

Cast
Role: Ballad Singer Actor: Gaudry

Dance: As17861023

Song: As17861211, but Vocal Parts-_Pemberton

Performances

Mainpiece Title: The Roman Father

Afterpiece Title: The Enchanted Castle

Cast
Role: Ballad Singer Actor: Gaudry

Song: As17861021

Performances

Mainpiece Title: Such Things Are

Afterpiece Title: The Enchanted Castle

Cast
Role: Ballad Singer Actor: Gaudry

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: The Enchanted Castle

Cast
Role: Ballad Singer Actor: Gaudry

Performances

Mainpiece Title: Such Things Are

Afterpiece Title: The Enchanted Castle

Cast
Role: Ballad Singer Actor: Gaudry

Performances

Mainpiece Title: Artaxerxes

Afterpiece Title: The Enchanted Castle

Cast
Role: Ballad Singer Actor: Gaudry

Performances

Mainpiece Title: Such Things Are

Afterpiece Title: The Enchanted Castle

Cast
Role: Ballad Singer Actor: Gaudry

Performances

Mainpiece Title: The Man Of The World

Afterpiece Title: The Enchanted Castle

Cast
Role: Ballad Singer Actor: Gaudry

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: The Enchanted Castle

Cast
Role: Ballad Singer Actor: Gaudry

Performances

Mainpiece Title: Such Things Are

Afterpiece Title: The Enchanted Castle

Cast
Role: Ballad Singer Actor: Gaudry

Performances

Mainpiece Title: Annette And Lubin

Afterpiece Title: Artaxerxes

Cast
Role: Ballad Singer Actor: Gaudry

Afterpiece Title: The Intriguing Chambermaid

Performances

Mainpiece Title: The Dramatist

Afterpiece Title: The Touchstone

Cast
Role: Street@singer Actor: Blanchard

Performances

Mainpiece Title: The Messiah, Preceded By god Save The King(coronation Anthems)

Music: End II: a concerto on the violin-Mme Gautherot (from Paris)

Performances

Mainpiece Title: A Grand Selection [of Sacred Music 0; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End II: concerto on the Piano Forte-Clementi

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17900224

Performances

Mainpiece Title: Judas Maccabaeus; Grand Selection 0; Messiah

Music: As17900224

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17900219

Performances

Mainpiece Title: The Messiah

Music: End II: As17900224; End I: concerto by Geminiani for the violin-G. Ashley

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End II: As17900219; End I: Miserere Mei Deus-, composed by Sg Gregorio Allegri, in the Year 1650, from an authentic Copy brought from Italy by Greatorex. A Translation of this Work (the 51st Psalm in English) will be printed in the Books of the Night

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End II: As17900224; End Part I: Miserere Mei Deus, as17900317

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17900219

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3 Entirely selected from The Messiah

Music: As17900219

Performances

Mainpiece Title: Poor Old Drury

Cast
Role: Italian Singer Actor: Bland

Afterpiece Title: The School for Scandal

Afterpiece Title: No Song No Supper

Song: III 2nd piece: a song-Sedgwick