SELECT * FROM london_stages WHERE eventid IN (19544, 19554, 19575, 19609, 22840, 22921, 22935, 22941, 22967, 22975, 22991, 23000, 23004, 23007, 23014, 23017, 23022, 23026, 23029, 23032, 23035, 23037, 23040, 23044, 23046, 23055, 23058, 23062, 23065, 23067, 23070, 23079, 23082, 23084, 23087, 23093, 23100, 23102, 23103, 23110, 23113, 23118, 23121, 23124, 23132, 23139, 23142, 23147, 23150, 23165, 23168, 23171, 23175, 23178, 23186, 23202, 23206, 23209, 23214, 23216, 23219, 23223, 23225, 23233, 23237, 23256, 23258, 23261, 23268, 23277, 23283, 23285, 23292, 23295, 23302, 23387, 23396, 23400, 23405, 23409, 23416, 23419, 23422, 23425, 23436, 23438, 23441, 23445, 23448, 23454, 23464, 23480, 23495, 23501, 23542, 23545, 23557, 23590, 23593, 23597, 23600, 23603, 23606, 23618, 23621, 23655, 23661, 23668, 23674, 23680, 23692, 23705, 23710, 23713, 23716, 23720, 23758, 23761, 23767, 23771, 23783, 23794, 23839, 23865, 23870, 23895, 23896, 23897, 23903, 23905, 23906, 23907, 23908, 23909, 23910, 23911, 23912, 23920, 23927, 23937, 23950, 23971, 23977, 23980, 23982, 23983, 23985, 23991, 23993, 23994, 23996, 24000, 24010, 24014, 24023, 24028, 24031, 24036, 24039, 24041, 24055, 24076, 24084, 24086, 24133, 24161, 24179, 24181, 24187, 24194, 24197, 24210, 24239, 24243, 24247, 24257, 24267, 24871, 24877, 24887, 24895, 24897, 24899, 24901, 24903, 24908, 24915, 24917, 24919, 24924, 24926, 24928, 24930, 24942, 24947, 24951, 24954, 24961, 24964, 24977, 24979, 24982, 24985, 24991, 24994, 24999, 25002, 25007, 25009, 25011, 25016, 25021, 25023, 25050, 25071, 25073, 25077, 25080, 25082, 25093, 25097, 25099, 25103, 25105, 25115, 25120, 25122, 25132, 25137, 25141, 25147, 25149, 25155, 25160, 25163, 25193, 25203, 25207, 25214, 25217, 25228, 25233, 25250, 25260, 25268, 25270, 25272, 25278, 25281, 25287, 25289, 25291, 25334, 25339, 25341, 25343, 25345, 25347, 25349, 25351, 25353, 25355, 25357, 25359, 25361, 25367, 25380, 25392, 25394, 25406, 25410, 25428, 25430, 25434, 25440, 25442, 25444, 25448, 25450, 25456, 25458, 25460, 25464, 25466, 25470, 25474, 25476, 25478, 25480, 25482, 25484, 25488, 25493, 25495, 25505, 25507, 25521, 25525, 25529, 25533, 25536, 25540, 25544, 25546, 25549, 25553, 25555, 25560, 25573, 25586, 25588, 25615, 25632, 25646, 25656, 25661, 25670, 25681, 25683, 25685, 25689, 25697, 25699, 25703, 25707, 25708, 25711, 25714, 25740, 25742, 25758, 25760, 25771, 25783, 25785, 25795, 25803, 25809, 25811, 25819, 25821, 25823, 25826, 25830, 25832, 25837, 25839, 25843, 25845, 25855, 25874, 25890, 25894, 25903, 25906, 25908, 25913, 25922, 25926, 25936, 25942, 25944, 25951, 25953, 25964, 25970, 25978, 25981, 25983, 25985, 25996, 25998, 26000, 26004, 26013, 26017, 26020, 26025, 26029, 26039, 26042, 26052, 26068, 26070, 26073, 26076, 26079, 26086, 26092, 26097, 26102, 26113, 26124, 26131, 26134, 26136, 26138, 26142, 26145, 26147, 26149, 26151, 26157, 26171, 26176, 26181, 26183, 26195, 26197, 26199, 26212, 26214, 26216, 26218, 26222, 26224, 26230, 26232, 26248, 26252, 26254, 26257, 26261, 26266, 26273, 26278, 26281, 26283, 26288, 26295, 26297, 26301, 26303, 26312, 26318, 26321, 26330, 26336, 26342, 26351, 26353, 26356, 26362, 26374, 26387, 26397, 26399, 26407, 26409, 26412, 26422, 26424, 26427, 26430, 26435, 26450, 26455, 26457, 26467, 26533, 26536, 26538, 26574, 26578, 26583, 26587, 26598, 26600, 26602, 26605, 26615, 26621, 26623, 26625, 26627, 26632, 26644, 26646, 26650, 26655, 26662, 26665, 26667, 26670, 26673, 26675, 26678, 26680, 26682, 26684, 26686, 26688, 26690, 26692, 26694, 26700, 26704, 26710, 26714, 26716, 26718, 26720, 26726, 26730, 26736, 26748, 26753, 26757, 26759, 26771, 26776, 26783, 26785, 26787, 26790, 26806, 26809, 26813, 26818, 26822, 26824, 26839, 26849, 26853, 26858, 26863, 26867, 26899, 26904, 26908, 26914, 26924, 26929, 26938, 26941, 26943, 26945, 26960, 26964, 26971, 26975, 26979, 26983, 26985, 27016, 27027, 27029, 27043, 27048, 27057, 27059, 27067, 27069, 27075, 27086, 27091, 27096, 27098, 27101, 27103, 27106, 27148, 27156, 27165, 27175, 27178, 27180, 27183, 27185, 27188, 27190, 27194, 27197, 27217, 27219, 27223, 27227, 27235, 27250, 27255, 27260, 27268, 27270, 27277, 27292, 27295, 27310, 27313, 27315, 27317, 27319, 27328, 27333, 27335, 27341, 27343, 27346, 27349, 27351, 27354, 27362, 27370, 27373, 27401, 27412, 27415, 27419, 27424, 27427, 27430, 27433, 27435, 27440, 27443, 27446, 27449, 27453, 27463, 27468, 27473, 27480, 27485, 27524, 27528, 27530, 27547, 27553, 27559, 27565, 27571, 27576, 27578, 27580, 27585, 27592, 27600, 27602, 27613, 27618, 27620, 27626, 27627, 27670, 27673, 27675, 27681, 27693, 27695, 27699, 27701, 27703, 27711, 27723, 27727, 27729, 27731, 27733, 27738, 27742, 27745, 27753, 27760, 27776, 27778, 27782, 27785, 27787, 27802, 27805, 27809, 27816, 27818, 27820, 27823, 27825, 27828, 27830, 27832, 27871, 27909, 27919, 27921, 27931, 27939, 27941, 27948, 27993, 27998, 28003, 28012, 28017, 28028, 28032, 28042, 28044, 28048, 28050, 28055, 28058, 28063, 28068, 28070, 28073, 28075, 28077, 28084, 28087, 28089, 28091, 28097, 28100, 28108, 28110, 28127, 28137, 28139, 28141, 28143, 28145, 28147, 28159, 28163, 28169, 28171, 28186, 28198, 28202, 28204, 28206, 28208, 28210, 28216, 28218, 28222, 28228, 28232, 28236, 28240, 28252, 28264, 28269, 28274, 28290, 28292, 28296, 28300, 28302, 28304, 28307, 28309, 28311, 28321, 28325, 28335, 28337, 28339, 28344, 28353, 28362, 28364, 28366, 28368, 28371, 28377, 28382, 28387, 28392, 28460, 28469, 28492, 28499, 28507, 28516, 28527, 28530, 28535, 28537, 28540, 28544, 28553, 28555, 28557, 28560, 28611, 28622, 28626, 28631, 28643, 28649, 28654, 28657, 28663, 28665, 28668, 28670, 28672, 28687, 28695, 28700, 28703, 28706, 28710, 28715, 28722, 28727, 28734, 28741, 28743, 28750, 28760, 28762, 28764, 28766, 28778, 28783, 28787, 28791, 28798, 28811, 28832, 28850, 28865, 28870, 28872, 28875, 28880, 28886, 28888, 28892, 28897, 28903, 28909, 28916, 28923, 28927, 28943, 28957, 28965, 28984, 28992, 28994, 28996, 29008, 29010, 29012, 29020, 29032, 29034, 29049, 29053, 29055, 29152, 29156, 29160, 29162, 29170, 29180, 29190, 29194, 29198, 29208, 29210, 29212, 29222, 29224, 29226, 29231, 29249, 29251, 29253, 29258, 29265, 29301, 29313, 29318, 29330, 29332, 29335, 29337, 29341, 29347, 29353, 29355, 29360, 29373, 29387, 29399, 29415, 29420, 29429, 29443, 29446, 29462, 29479, 29500, 29504, 29514, 29519, 29523, 29530, 29533, 29565, 29581, 29584, 29588, 29594, 29724, 29733, 29737, 29741, 29743, 29746, 29748, 29750, 29751, 29753, 29755, 29757, 29759, 29761, 29763, 29765, 29767, 29769, 29771, 29773, 29775, 29777, 29779, 29781, 29783, 29785, 29789, 29791, 29793, 29795, 29798, 29800, 29802, 29805, 29807, 29809, 29811, 29814, 29816, 29818, 29820, 29829, 29834, 29836, 29839, 29845, 29852, 29854, 29858, 29860, 29862, 29865, 29867, 29869, 29871, 29875, 29878, 29880, 29882, 29884, 29887, 29889, 29891, 29893, 29895, 29897, 29900, 29902, 29904, 29906, 29908, 29910, 29913, 29915, 29920, 29935, 29937, 29942, 29948, 29953, 29957, 29959, 29961, 29963, 29968, 29970, 29972, 29976, 29979, 29982, 29984, 29988, 29992, 29995, 29998, 30001, 30004, 30007, 30010, 30013, 30016, 30019, 30022, 30025, 30029, 30043, 30053, 30056, 30058, 30062, 30064, 30071, 30074, 30076, 30079, 30094, 30096, 30101, 30104, 30109, 30115, 30117, 30126, 30131, 30144, 30148, 30152, 30154, 30300, 30303, 30310, 30312, 30318, 30332, 30336, 30342, 30372, 30398, 30401, 30406, 30419, 30421, 30423, 30439, 30444, 30447, 30451, 30458, 30485, 30487, 30490, 30494, 30497, 30499, 30503, 30514, 30518, 30527, 30533, 30558, 30562, 30567, 30584, 30586, 30588, 30593, 30602, 30612, 30628, 30639, 30647, 30661, 30681, 30685, 30689, 30786, 30807, 30819, 30823, 30846, 30850, 30861, 30866, 30879, 30908, 30911, 30913, 30915, 30917, 30920, 30923, 30925, 30927, 30929, 30931, 30934, 30936, 30938, 30941, 30943, 30945, 30948, 30951, 30953, 30988, 30994, 31006, 31083, 31088, 31090, 31098, 31113, 31124, 31127, 31149, 31159, 31163, 31177, 31180, 31201, 31207, 31217, 31226, 31242, 31248, 31254, 31267, 31273, 31332, 31357, 31371, 31377, 31410, 31416, 31429, 31468, 31471, 31495, 31499, 31505, 31507, 31511, 31514, 31518, 31522, 31527, 31538, 31543, 31549, 31551, 31557, 31565, 31570, 31575, 31584, 31588, 31592, 31595, 31600, 31603, 31606, 31624, 31630, 31643, 31646, 31661, 31668, 31672, 31681, 31697, 31704, 31737, 31746, 31759, 31772, 31774, 31858, 31860, 31868, 31876, 31884, 31888, 31900, 31904, 31916, 31954, 32037, 32042, 32048, 32058, 32060, 32067, 32075, 32087, 32129, 32132, 32137, 32153, 32203, 32212, 32230, 32234, 32236, 32253, 32257, 32318, 32340, 32345, 32355, 32359, 32363, 32369, 32375, 32383, 32387, 32400, 32402, 32415, 32420, 32440, 32478, 32485, 32499, 32501, 32510, 32513, 32522, 32527, 32579, 32592, 32614, 32640, 32643, 32657, 32677, 32681, 32699, 32725, 32730, 32751, 32806, 32826, 32831, 32845, 32853, 32859, 32871, 32873, 32902, 32925, 32929, 32934, 32938, 32943, 32950, 32957, 32963, 32995, 33000, 33004, 33006, 33009, 33013, 33016, 33021, 33030, 33048, 33051, 33058, 33085, 33122, 33162, 33164, 33184, 33202, 33259, 33261, 33266, 33268, 33270, 33292, 33294, 33298, 33316, 33323, 33337, 33342, 33345, 33349, 33354, 33361, 33405, 33431, 33442, 33480, 33521, 33530, 33558, 33581, 33584, 33627, 33634, 33641, 33645, 33699, 33705, 33793, 33795, 33801, 33805, 33807, 33811, 33813, 33817, 33832, 33852, 33863, 33880, 33883, 33885, 33888, 33890, 33892, 33894, 33897, 33899, 33911, 33916, 33918, 33925, 33927, 33965, 33973, 33977, 33981, 33990, 34006, 34015, 34023, 34037, 34039, 34070, 34073, 34083, 34098, 34116, 34147, 34185, 34190, 34193, 34198, 34205, 34213, 34220, 34225, 34230, 34253, 34337, 34349, 34366, 34384, 34405, 34422, 34443, 34457, 34460, 34466, 34469, 34471, 34474, 34476, 34478, 34514, 34546, 34558, 34648, 34679, 34708, 34715, 34739, 34742, 34750, 34768, 34787, 34790, 34796, 34818, 34892, 34910, 34930, 34981, 34992, 35071, 35261, 35280, 35295, 35300, 35320, 35331, 35341, 35499, 35550, 35611, 35677, 35705, 35882, 35925, 35990, 36114, 36150, 36194, 36200, 36249, 36311, 36366, 36371, 36399, 36407, 36489, 36495, 36538, 36547, 36693, 36807, 37086, 42509) 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 Maid Of The Mill

Afterpiece Title: The Apprentice

Cast
Role: Irishman Actor: Barrington

Dance: II: The Sicilian Peasants-Sga Manesiere (Man), Miss Wilford (Woman peasant). [See17651126 note.

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Apprentice

Cast
Role: Irishman Actor: Barrington

Dance: II: Hornpipe-Miss Pitt; End: The Sicilian Peasants, as17660311

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Lady Capulet Actor: Mrs Barrington

Afterpiece Title: Midas

Dance: III: The Village Romps, as17651019

Performances

Mainpiece Title: Love Makes A Man

Afterpiece Title: The Apprentice

Cast
Role: Irishman Actor: Barrington

Dance: I: A Hornpipe-Miss Twist; III: The Venetian Gardeners, as17650925; End: The Village Romps, as17651019

Performances

Mainpiece Title: The Maid Of The Mill

Afterpiece Title: The Apprentice

Cast
Role: Irishman Actor: Barrington

Dance: II: The Sicilian Peasants, as17660311

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Lady Capulet Actor: Mrs Barrington

Afterpiece Title: Perseus and Andromeda

Performances

Mainpiece Title: King Henry V

Cast
Role: MacMorris Actor: Barrington

Afterpiece Title: Coronation

Performances

Mainpiece Title: King Henry V

Cast
Role: MacMorris Actor: Barrington

Afterpiece Title: Coronation

Performances

Mainpiece Title: King Henry V

Cast
Role: MacMorris Actor: Barrington

Afterpiece Title: Coronation

Performances

Mainpiece Title: King Henry V

Cast
Role: MacMorris Actor: Barrington

Afterpiece Title: Coronation

Performances

Mainpiece Title: King Henry V

Cast
Role: MacMorris Actor: Barrington

Afterpiece Title: Coronation

Performances

Mainpiece Title: King Henry V

Cast
Role: MacMorris Actor: Barrington

Afterpiece Title: Coronation

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: The Apprentice

Dance: II: The Village Romps, as17661008

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Lady Capulet Actor: Mrs Barrington

Afterpiece Title: The Upholsterer

Dance: III: The Village Romps, as17661008

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: The Intriguing Chambermaid

Dance: II: The Garland, as17661023

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: Catherine and Petruchio

Dance: II: The Garland, as17661023

Performances

Mainpiece Title: The Merry Wives Of Windsor

Cast
Role: Mrs Page Actor: Mrs Barrington

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: The Stratagem

Cast
Role: Foigard Actor: Barrington

Afterpiece Title: The Englishman in Paris

Dance: IV: The Garland, as17661023

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: The Citizen

Dance: II: The Garland, as17661023

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: Miss in Her Teens

Dance: II: The Village Romps, as17661008

Performances

Mainpiece Title: King Henry V

Cast
Role: MacMorris Actor: Barrington

Afterpiece Title: Coronation

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: Harlequin Dr Faustus

Dance: II: Rural Love-Fishar, Sga Manesiere, Miss Wilford, Arnauld, Dumai, Miss Twist, Miss Pitt.[See17641212.

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: Catherine and Petruchio

Dance: II: Rural Love, as17661120

Performances

Mainpiece Title: King Henry V

Cast
Role: MacMorris Actor: Barrington

Afterpiece Title: Coronation

Performances

Mainpiece Title: The Stratagem

Cast
Role: Foigard Actor: Barrington

Afterpiece Title: Harlequin Dr Faustus