SELECT * FROM london_stages WHERE eventid IN (147, 234, 270, 450, 975, 1136, 1235, 1236, 1237, 1239, 1259, 1262, 1263, 1284, 1291, 1292, 1296, 1302, 1318, 1319, 1337, 1356, 1373, 1401, 1419, 1447, 1451, 1522, 1523, 1777, 1779, 1780, 1786, 1794, 1814, 1825, 4616, 6014, 10012, 13026, 13044, 13048, 13057, 13120, 13124, 13153, 15815, 15821, 15824, 15827, 15871, 15876, 15880, 15884, 15891, 15910, 15953, 16008, 16016, 16070, 16091, 16097, 16135, 16147, 16327, 16368, 16387, 16497, 16530, 16550, 16703, 16707, 16710, 16714, 16718, 16722, 16727, 16731, 16734, 16741, 16745, 16749, 16754, 16758, 16793, 16797, 16813, 16816, 16820, 16824, 16838, 16842, 16846, 16851, 16867, 16907, 16911, 16939, 16942, 16946, 16950, 16953, 16957, 16961, 16966, 16970, 16974, 16978, 16982, 16986, 16990, 16994, 16998, 17003, 17007, 17012, 17016, 17020, 17025, 17031, 17035, 17039, 17045, 17056, 17061, 17099, 17124, 17253, 17269, 17273, 17393, 17413, 17446, 17449, 17456, 17485, 17488, 17492, 17494, 17497, 17506, 17510, 17512, 17515, 17518, 17526, 17530, 17532, 17535, 17537, 17538, 17540, 17541, 17546, 17552, 17555, 17561, 17565, 17568, 17571, 17575, 17578, 17582, 17587, 17595, 17597, 17601, 17609, 17612, 17617, 17622, 17626, 17635, 17637, 17641, 17644, 17648, 17651, 17652, 17656, 17659, 17662, 17665, 17669, 17672, 17675, 17678, 17681, 17684, 17688, 17691, 17695, 17699, 17701, 17704, 17708, 17709, 17711, 17712, 17715, 17719, 17721, 17722, 17724, 17725, 17728, 17729, 17731, 17732, 17735, 17736, 17739, 17742, 17746, 17748, 17754, 17759, 17761, 17765, 17770, 17776, 17782, 17783, 17786, 17791, 17795, 17796, 17851, 17856, 17861, 17862, 17867, 17875, 17880, 17885, 17892, 17897, 17922, 17927, 17940, 17948, 17955, 17966, 17970, 17999, 18009, 18012, 18026, 18030, 18051, 18123, 18171, 18190, 18193, 18196, 18199, 18202, 18203, 18206, 18210, 18214, 18216, 18226, 18228, 18231, 18233, 18239, 18241, 18244, 18248, 18250, 18251, 18253, 18257, 18259, 18273, 18275, 18277, 18278, 18280, 18281, 18283, 18286, 18288, 18289, 18292, 18295, 18299, 18303, 18306, 18309, 18317, 18320, 18324, 18329, 18332, 18335, 18336, 18338, 18339, 18342, 18346, 18348, 18349, 18353, 18355, 18356, 18358, 18361, 18362, 18365, 18366, 18368, 18369, 18373, 18376, 18377, 18380, 18382, 18383, 18385, 18386, 18388, 18389, 18391, 18392, 18398, 18399, 18403, 18405, 18409, 18412, 18444, 18446, 18460, 18468, 18477, 18481, 18484, 18490, 18493, 18494, 18497, 18504, 18505, 18516, 18517, 18521, 18525, 18535, 18540, 18543, 18547, 18559, 18590, 18594, 18604, 18609, 18616, 18622, 18631, 18648, 18652, 18659, 18679, 18688, 18701, 18705, 18725, 18763, 18774, 18800, 18842, 19036, 19041, 19043, 19065, 19075, 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, 19426, 19465, 19474, 19479, 19481, 19483, 19485, 19487, 19500, 19537, 19591, 19596, 19612, 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, 20154, 20156, 20158, 20161, 20164, 20167, 20170, 20173, 20176, 20179, 20197, 20198, 20200, 20207, 20212, 20215, 20234, 20240, 20259, 20290, 20299, 20302, 20330, 20344, 20348, 20351, 20360, 20370, 20373, 20382, 20402, 20416, 20419, 20420, 20422, 20426, 20430, 20442, 20446, 20449, 20458, 20462, 20466, 20469, 20483, 20487, 20498, 20501, 20506, 20511, 20517, 20521, 20543, 20555, 20559, 20568, 20571, 20577, 20581, 20608, 20611, 20651, 20706, 20733, 20740, 20743, 20747, 20754, 20758, 20761, 20770, 20772, 20775, 20778, 20787, 20790, 20797, 20800, 20803, 20806, 20815, 20818, 20823, 20826, 20842, 20846, 20849, 20855, 20858, 20861, 20865, 20868, 20873, 20876, 20879, 20887, 20893, 20896, 20899, 20903, 20906, 20912, 20918, 20935, 20938, 20942, 20945, 20949, 20952, 20956, 20961, 20965, 20968, 20971, 20974, 20991, 20994, 21001, 21005, 21008, 21011, 21021, 21025, 21028, 21031, 21034, 21038, 21042, 21052, 21060, 21070, 21073, 21077, 21080, 21084, 21087, 21093, 21104, 21110, 21113, 21117, 21127, 21133, 21140, 21144, 21151, 21154, 21158, 21162, 21169, 21178, 21185, 21206, 21210, 21213, 21221, 21243, 21251, 21258, 21282, 21294, 21299, 21311, 21312, 21319, 21329, 21373, 21393, 21522, 21525, 21532, 21538, 21545, 21549, 21552, 21555, 21558, 21560, 21562, 21565, 21571, 21577, 21582, 21588, 21599, 21603, 21612, 21615, 21618, 21620, 21624, 21627, 21630, 21633, 21639, 21648, 21652, 21660, 21665, 21668, 21671, 21675, 21678, 21683, 21688, 21707, 21756, 21793, 21800, 21828, 21840, 22316, 22319, 22322, 24294, 24299, 24301, 24302, 24303, 24304, 24305, 24306, 24308, 24309, 24310, 24311, 24312, 24313, 24315, 24316, 28683, 36789, 38309, 40277, 40287, 40290, 40299, 40303, 40313, 40318, 40328, 40332, 40342, 40347, 40811, 40814, 40823, 40826, 40836, 40840, 40850, 40854, 40864, 40867, 41410, 41419, 41423, 41432, 41438, 41449, 41452, 41464, 41468, 41478, 41483, 42387, 42627, 43680, 43691, 43694, 43704, 43710, 43724, 43738, 43749, 43754, 45960, 46343, 46381, 46389, 47479, 48278, 48285, 48637, 48669, 48687, 48695, 48699, 48715, 48717, 48727, 48729, 48739, 48747, 48749, 48754, 48755, 48757, 48759, 48761, 48766, 48767, 48769, 48771, 48774, 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, 48860, 48865, 48868, 48870, 48874, 48877, 48879, 48882, 48884, 48887, 48890, 48892, 48896, 48899, 48902, 48909, 48913, 48916, 48918, 48923, 48927, 48930, 48945, 48947, 48952, 48959, 48961, 48971, 48980, 48986, 48988, 48990, 48993, 49002, 49007, 49009, 49014, 49018, 49021, 49023, 49033, 49038, 49041, 49043, 49053, 49056, 49058, 49061, 49066, 49072, 49074, 49077, 49081, 49083, 49086, 49088, 49090, 49092, 49095, 49100, 49193, 49197, 49199, 49201, 49206, 49208, 49211, 49214, 49217, 49219, 49222, 49224, 49226, 49228, 49229, 49232, 49236, 49250, 49252, 49256, 49258, 49260, 49262, 49338, 49340, 49343, 49345, 49348, 49350, 49352, 49354, 49357, 49359, 49362, 49371, 49373, 49376, 49378, 49385, 49387, 49390, 49392, 49399, 49401, 49425, 49430, 49432, 49434, 49439, 49449, 49452, 49454, 49458, 49462, 49465, 49478, 49504, 49517, 49556, 49558, 49583, 49597, 49599, 49607, 49609, 49614, 49620, 49625, 49632, 49637, 49644, 49649, 49653, 49657, 49659, 49664, 49754, 49761, 49766, 49768, 49777, 49783, 49785, 49788, 49791, 49796, 49799, 49801, 49803, 49813, 49817, 49819, 49835, 49843, 49845, 49849, 49853, 49857, 49869, 49873, 49877, 49886, 49891, 49893, 49895, 49900, 49902, 49910, 49917, 49924, 49926, 49929, 49931, 49933, 49935, 49938, 49940, 49943, 49945, 49947, 49949, 49952, 49954, 49957, 49959, 49961, 49966, 49968, 49971, 49978, 49992, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50077, 50079, 50082, 50087, 50089, 50092, 50094, 50097, 50099, 50102, 50111, 50113, 50116, 50121, 50123, 50126, 50141, 50143, 50151, 50153, 50156, 50161, 50163, 50170, 50172, 50175, 50177, 50184, 50186, 50189, 50193, 50195, 50203, 50205, 50215, 51235) 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: Samson; Judas Maccabaeus

Cast
Role: 1st Violin Actor: Richards.

Music: End Part I: concerto on the hautboy, as17790224

Performances

Mainpiece Title: Judas Maccabaeus

Cast
Role: 1st Violin Actor: Richards.

Music: As17790303

Performances

Mainpiece Title: Alexander's Feast; Judas Maccabaeus

Cast
Role: 1st Violin Actor: Richards.

Afterpiece Title: A Miscellaneous Act

Music: End Part I: concerto on the violin, as17790219

Performances

Mainpiece Title: Judas Maccabaeus

Cast
Role: 1st Violin Actor: Richards.

Music: As17790305

Performances

Mainpiece Title: Alexander's Feast; Judas Maccabaeus

Cast
Role: 1st Violin Actor: Richards.

Afterpiece Title: A Miscellaneous Act

Music: End Part I Oratorio: concerto on the violoncello-Crosdill

Performances

Mainpiece Title: The Messiah; Judas Maccabaeus

Cast
Role: 1st Violin Actor: Richards.

Music: As17790303

Performances

Mainpiece Title: The Messiah; Judas Maccabaeus

Cast
Role: 1st Violin Actor: Richards.

Music: As17790303

Performances

Mainpiece Title: Judas Maccabaeus; Alexander's Feast

Cast
Role: 1st Violin Actor: Richards.

Music: End I: concerto on the organ, as17800211; End II: concerto on the hautboy-Parke

Performances

Mainpiece Title: Acis And Galatea; Alexander's Feast

Afterpiece Title: The Music In Bonduca; Alexander's Feast

Cast
Role: 1st Violin Actor: Richards.

Music: As17800211

Performances

Mainpiece Title: Samson; Alexander's Feast

Cast
Role: 1st Violin Actor: Richards.

Music: As17800216

Performances

Mainpiece Title: L'allegro, Penseroso Ed Il Moderato; Alexander's Feast

Music: End of Part I: concerto on the violin, as17800211; End of Part II: concerto on the hautboy, as17800216

Performances

Mainpiece Title: Joseph; Alexander's Feast

Music: As17800216

Performances

Mainpiece Title: Acis And Galatea; Alexander's Feast

Afterpiece Title: The Music In Bonduca; Alexander's Feast

Music: End of Part I: concerto on the violin, as17800211; End of Part II: concerto on the organ, as17800211

Performances

Mainpiece Title: Judas Maccabaeus; Alexander's Feast

Music: As17800216

Performances

Mainpiece Title: L'allegro, Penseroso; Alexander's Feast

Afterpiece Title: Dryden's Ode On St

Music: As17800211

Performances

Mainpiece Title: The Messiah

Music: End of Part I: concerto on the organ, as17800211

Performances

Mainpiece Title: The Messiah

Music: As17800211

Performances

Mainpiece Title: Alexander's Feast

Cast
Role: 1st Violin Actor: Richards.

Afterpiece Title: Dryden's Ode for St

Music: End Part I oratorio: concerto on the organ-Stanley; End Part II: concerto on the violin-Cramer

Performances

Mainpiece Title: Judas Maccabaeus; Alexander's Feast

Cast
Role: 1st Violin Actor: Richards.

Music: End Part I: concerto on the organ, as17810302End Part II: concerto on the hautboy-Parke

Performances

Mainpiece Title: Deborah; Alexander's Feast

Cast
Role: 1st Violin Actor: Richards.

Music: As17810302

Performances

Mainpiece Title: Acis And Galatea; Alexander's Feast

Cast
Role: 1st Violin Actor: Richards.

Afterpiece Title: The Music from Bonduca; Dryden's Ode for St

Music: As17810307

Performances

Mainpiece Title: Acis And Galatea; Alexander's Feast

Cast
Role: 1st Violin Actor: Richards.

Afterpiece Title: The Music from Bonduca; Dryden's Ode for St

Music: As17810302

Performances

Mainpiece Title: L'allegro, Il Penseroso, Il Moderato; Alexander's Feast

Cast
Role: 1st Violin Actor: Richards.

Music: As17810307

Performances

Mainpiece Title: L'allegro, Il Penseroso, Il Moderato; Alexander's Feast

Cast
Role: 1st Violin Actor: Richards.

Music: As17810302

Performances

Mainpiece Title: Alexander's Feast

Cast
Role: 1st Violin Actor: Richards.

Afterpiece Title: The Monody to the Memory of Mr Garrick; Dryden's Ode for St

Music: As17810307

Song: In Oratorio: Verdi Prati-a Young Gentleman (1st appearance in public [unidentified])