SELECT * FROM london_stages WHERE eventid IN (1772, 6488, 11744, 11772, 11781, 16174, 16178, 16184, 16188, 16192, 16413, 16718, 16722, 16727, 16731, 16734, 16741, 16745, 16749, 16754, 16758, 16797, 16852, 17253, 17269, 17273, 17513, 17516, 17521, 17524, 18851, 21065, 21068, 21071, 21074, 21078, 21081, 21085, 21091, 21094, 21098, 21105, 21114, 21121, 21256, 21280, 21475, 21571, 21574, 21585, 22334, 22935, 22987, 22998, 23007, 23008, 23026, 23261, 23268, 23277, 23284, 23413, 23417, 23528, 23588, 23961, 23963, 24077, 27608, 28289, 28554, 28644, 29059, 30476, 30480, 30482, 30485, 30487, 30490, 30494, 30497, 30499, 33050, 33054, 33057, 33059, 33064, 33067, 33070, 33072, 33075, 33079, 33082, 33084, 33088, 33112, 33126, 33154, 33170, 33183, 33195, 34001, 34004, 34346, 34379, 34498, 34531, 34571, 34736, 34795, 35335, 35506, 35522, 35581, 35620, 35633, 35642, 35670, 35687, 35721, 35722, 35844, 35924, 35974, 36493, 36717, 36778, 36832, 36878, 37078, 38735, 38781, 38783, 38793, 38795, 38800, 38804, 38835, 38879, 38900, 38912, 38944, 38984, 39225, 39379, 39381, 39384, 39386, 39403, 39409, 39428, 39440, 39446, 39449, 39498, 39503, 39509, 39514, 39567, 39570, 39573, 39656, 39713, 39847, 39858, 39871, 39921, 40041, 40042, 40043, 40045, 40047, 40049, 40050, 40054, 40056, 40058, 40060, 40062, 40064, 40066, 40068, 40070, 40072, 40074, 40076, 40078, 40080, 40082, 40084, 40086, 40088, 40090, 40092, 40094, 40096, 40098, 40102, 40104, 40106, 40111, 40113, 40115, 40117, 40127, 40129, 40134, 40139, 40141, 40148, 40157, 40160, 40164, 40169, 40175, 40178, 40244, 40258, 40262, 40263, 40264, 40266, 40269, 40288, 40294, 40322, 40366, 40371, 40410, 40419, 40567, 40616, 40629, 40633, 40687, 40694, 40760, 40815, 40827, 40832, 40874, 40889, 40890, 40910, 40925, 40938, 40941, 40943, 40946, 40953, 40958, 40959, 40967, 40969, 40972, 40978, 40991, 40992, 41005, 41138, 41146, 41155, 41195, 41197, 41213, 41218, 41227, 41271, 41274, 41280, 41281, 41282, 41284, 41286, 41289, 41303, 41308, 41310, 41314, 41317, 41319, 41322, 41324, 41328, 41351, 41360, 41363, 41368, 41378, 41396, 41436, 41458, 41470, 41471, 41488, 41493, 41502, 41504, 41513, 41515, 41517, 41518, 41527, 41529, 41539, 41541, 41542, 41544, 41549, 41554, 41561, 41562, 41573, 41576, 41627, 41628, 41629, 41692, 41696, 41705, 41706, 41708, 41710, 41711, 41735, 41750, 41765, 41768, 41826, 41895, 41905, 41914, 41933, 41957, 41990, 42011, 42045, 42049, 42051, 42058, 42065, 42073, 42097, 42100, 42118, 42129, 42133, 42165, 42166, 42232, 42235, 42237, 42238, 42240, 42248, 42308, 42316, 42326, 42334, 42362, 42377, 42386, 42389, 42392, 42394, 42396, 42398, 42401, 42406, 42408, 42415, 42417, 42422, 42430, 42437, 42442, 42445, 42448, 42450, 42452, 42455, 42463, 42472, 42477, 42496, 42499, 42501, 42504, 42506, 42508, 42510, 42513, 42530, 42534, 42569, 42589, 42597, 42602, 42668, 42671, 42743, 42761, 42827, 42831, 42837, 42858, 42920, 42939, 42943, 42983, 43079, 43106, 43138, 43158, 43256, 43257, 43271, 43300, 43399, 43402, 43407, 43415, 43423, 43450, 43456, 43462, 43473, 43482, 43505, 43553, 43555, 43640, 43707, 43721, 43773, 43794, 43848, 43858, 43860, 43958, 43997, 44027, 44064, 44116, 44133, 44135, 44179, 44237, 44253, 44303, 44315, 44341, 44416, 44459, 44463, 44549, 44606, 44646, 44656, 44696, 44710, 44789, 44853, 44876, 44961, 45043, 45143, 45155, 45292, 45328, 45332, 45349, 45354, 45360, 45380, 45386, 45403, 45410, 45419, 45442, 45458, 45464, 45477, 45499, 45509, 45529, 45556, 45582, 45655, 45656, 45657, 45658, 45660, 45662, 45670, 45671, 45676, 45677, 45681, 45698, 45717, 45749, 45758, 45759, 45761, 45763, 45765, 45769, 45771, 45773, 45777, 45781, 45782, 45785, 45789, 45791, 45799, 45800, 45803, 45818, 45856, 45857, 45924, 45932, 45992, 46014, 46074, 46127, 46139, 46142, 46143, 46156, 46157, 46269, 46277, 46286, 46295, 46296, 46313, 46316, 46333, 46351, 46367, 46375, 46395, 46397, 46407, 46409, 46411, 46413, 46415, 46417, 46419, 46421, 46423, 46425, 46427, 46429, 46431, 46433, 46436, 46438, 46441, 46443, 46446, 46448, 46452, 46455, 46457, 46460, 46462, 46464, 46466, 46469, 46471, 46476, 46478, 46481, 46486, 46492, 46495, 46497, 46509, 46511, 46515, 46522, 46529, 46536, 46566, 46593, 46654, 46660, 46661, 46681, 46700, 46708, 46711, 46721, 46723, 46725, 46728, 46729, 46734, 46838, 46846, 46849, 46867, 46868, 46879, 46900, 46905, 46917, 46930, 46941, 46949, 46973, 47206, 47258, 47263, 47315, 47389, 47390, 47392, 47393, 47395, 47396, 47397, 47399, 47405, 47407, 47409, 47411, 47413, 47414, 47418, 47419, 47424, 47480, 47501, 47502, 47544, 47693, 47723, 47753, 47766, 47773, 47786, 47793, 47794, 47799, 47919, 47920, 47921, 47924, 47930, 47936, 47948, 47954, 47958, 48005, 48012, 48070, 48071, 48074, 48103, 48274, 48327, 48370, 48390, 48394, 48426, 48453, 48461, 48565, 48567, 48650, 48672, 48693, 48712, 48722, 48727, 48737, 48757, 48759, 48761, 48766, 48767, 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, 48837, 48851, 48856, 48865, 48870, 48874, 48877, 48879, 48882, 48884, 48887, 48890, 48892, 48896, 48899, 48902, 48909, 48913, 48916, 48918, 48923, 48927, 48930, 48945, 48947, 48952, 48959, 48961, 48979, 48980, 48981, 48983, 48985, 48986, 48987, 48988, 48990, 48992, 48993, 48994, 48997, 48999, 49001, 49003, 49006, 49007, 49008, 49009, 49011, 49014, 49020, 49021, 49023, 49025, 49033, 49037, 49038, 49041, 49043, 49048, 49052, 49053, 49056, 49066, 49072, 49077, 49080, 49081, 49083, 49085, 49086, 49087, 49090, 49099, 49100, 49102, 49111, 49207, 49257, 49258, 49301, 49306, 49408, 49411, 49413, 49416, 49418, 49420, 49422, 49425, 49427, 49430, 49432, 49434, 49436, 49439, 49467, 49475, 49480, 49493, 49504, 49517, 49521, 49543, 49553, 49559, 49565, 49568, 49585, 49594, 49604, 49612, 49614, 49635, 49640, 49650, 49655, 49657, 49660, 49662, 49667, 49670, 49677, 49680, 49682, 49686, 49688, 49695, 49696, 49698, 49700, 49701, 49702, 49704, 49705, 49706, 49709, 49712, 49715, 49719, 49721, 49722, 49724, 49725, 49726, 49730, 49731, 49733, 49734, 49735, 49736, 49740, 49745, 49746, 49748, 49750, 49752, 49753, 49769, 49796, 49808, 49820, 49824, 49878, 49904, 49918, 49946, 50025, 50030, 50077, 50086, 50096, 50146, 50160, 50181, 50264, 50272, 50276, 50286, 50299, 50304, 50334, 50337, 50362, 50561, 50749, 50772, 50826, 50832, 50837, 50918, 50926, 50933, 50963, 51015, 51068, 51086, 51100, 51280, 51319, 51354, 51385, 51421, 51487, 51498, 51512, 51531, 51584, 51666, 51842, 51846, 51850, 51866, 51877, 51882, 51884, 51898, 51909, 51927, 51929, 51978, 52037, 52062, 52063, 52065, 52096, 52113, 52145, 52161, 52185, 52193, 52279, 52309, 52402, 52405, 52408, 52444, 52449, 52458, 52465, 52496, 52520, 52522, 52525, 52526, 52529, 52532, 52534, 52535, 52540, 52551, 52552, 52553, 52555, 52558, 52559, 52563, 52569, 52572, 52575, 52582, 52591, 52594, 52601, 52603, 52604, 52606, 52607, 52608, 52610, 52611, 52612, 52613, 52614, 52615) 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: Blue Devils

Afterpiece Title: The Point of Honour

Cast
Role: Serjeant Actor: Abbot

Afterpiece Title: The Castle of Sorrento

Song: As18000614

Performances

Mainpiece Title: Cambro-britons

Afterpiece Title: The Agreeable Surprise

Cast
Role: Serjeant Actor: Abbot

Song: End: Paddy's Description of Pizarro; or, Mr Paddy O'Doody and his Cousin Shaun Shaugnessy's Treat to the One Shilling Gallery-Johnstone

Performances

Mainpiece Title: The Point Of Honour

Afterpiece Title: The Review; or, The Wags of Windsor

Cast
Role: Serjeant Actor: Atkins

Performances

Mainpiece Title: Sighs

Afterpiece Title: The Review

Cast
Role: Serjeant Actor: Atkins

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: The Review

Cast
Role: Serjeant Actor: Atkins

Performances

Mainpiece Title: The Point Of Honour

Afterpiece Title: The Review

Cast
Role: Serjeant Actor: Atkins

Performances

Mainpiece Title: The Jew

Afterpiece Title: The Review

Cast
Role: Serjeant Actor: Atkins

Performances

Mainpiece Title: Blue Devils

Afterpiece Title: The Birth Day

Afterpiece Title: The Review

Cast
Role: Serjeant Actor: Atkins

Performances

Mainpiece Title: The Review

Afterpiece Title: A Mogul Tale

Afterpiece Title: Obi

Cast
Role: Serjeant Actor: Abbot

Song: End 1st piece: Half and Half (never before sung)-Fawcett; End of 2nd piece: Paddy's Description of Pizarro, as18000829

Performances

Mainpiece Title: The Review

Afterpiece Title: The Deaf Lover

Afterpiece Title: Obi

Cast
Role: Serjeant Actor: Abbot

Performances

Mainpiece Title: Fortune's Frolick

Afterpiece Title: The Review

Cast
Role: Serjeant Actor: Abbot

Afterpiece Title: Obi

Cast
Role: Serjeant Actor: Abbot

Performances

Mainpiece Title: The Village Lawyer

Afterpiece Title: The Review

Cast
Role: Serjeant Actor: Abbot

Afterpiece Title: Obi

Cast
Role: Serjeant Actor: Abbot

Performances

Mainpiece Title: Obi

Afterpiece Title: The Point of Honour

Cast
Role: Serjeant Actor: Abbot