SELECT * FROM london_stages WHERE eventid IN (34885, 38728, 39777, 39952, 39953, 39954, 39956, 39957, 39971, 39973, 39975, 39977, 39979, 39982, 39984, 39986, 39987, 39988, 39989, 39992, 39997, 39998, 40000, 40005, 40012, 40040, 40042, 40044, 40046, 40048, 40059, 40071, 40093, 40099, 40121, 40135, 40140, 40149, 40173, 40179, 40181, 40382, 40391, 40480, 40483, 40486, 40492, 40495, 40496, 40498, 40499, 40500, 40501, 40503, 40504, 40506, 40511, 40514, 40518, 40525, 40529, 40532, 40539, 40541, 40542, 40553, 40570, 40572, 40736, 40748, 40750, 40752, 40765, 40772, 40777, 40787, 40789, 40795, 40797, 40801, 40804, 40807, 40809, 40825, 40828, 40833, 40839, 40846, 40870, 40882, 40905, 40915, 40922, 40925, 40928, 40933, 40946, 40951, 40956, 40960, 40965, 40974, 40985, 40987, 40997, 41002, 41019, 41020, 41025, 41038, 41044, 41060, 41088, 41093, 41109, 41412, 41435, 41447, 41508, 41513, 41515, 41518, 41520, 41527, 41529, 41532, 41542, 41544, 41547, 41557, 41562, 41567, 41601, 41603, 41604, 41607, 41610, 41615, 41618, 41621, 41626, 41631, 41633, 41642, 41646, 41649, 41652, 41653, 41654, 41655, 41656, 41657, 41658, 41660, 41661, 41662, 41663, 41665, 41666, 41667, 41668, 41669, 41671, 41672, 41674, 41676, 41677, 41678, 41679, 41680, 41681, 41682, 41683, 41684, 41685, 41686, 41689, 41714, 41718, 41719, 41723, 41755, 41776, 41779, 41781, 41784, 41786, 41788, 41790, 41793, 41795, 41800, 41802, 41804, 41807, 41831, 41833, 41838, 41846, 41853, 41866, 41887, 41896, 41903, 41918, 41929, 42037, 42111, 42127, 42137, 42168, 42170, 42171, 42173, 42175, 42176, 42183, 42184, 42186, 42191, 42192, 42195, 42199, 42200, 42205, 42206, 42207, 42208, 42210, 42211, 42212, 42214, 42217, 42220, 42221, 42224, 42225, 42228, 42229, 42231, 42234, 42238, 42239, 42241, 42242, 42243, 42244, 42245, 42246, 42247, 42248, 42249, 42250, 42253, 42254, 42255, 42256, 42258, 42259, 42260, 42261, 42262, 42263, 42264, 42265, 42266, 42267, 42268, 42270, 42271, 42272, 42306, 42322, 42403, 42427, 42430, 42432, 42456, 42546, 42571, 42646, 42682, 42687, 42723, 42750, 42753, 42755, 42758, 42760, 42762, 42764, 42765, 42767, 42768, 42769, 42770, 42773, 42774, 42775, 42777, 42778, 42780, 42782, 42783, 42785, 42787, 42788, 42789, 42790, 42791, 42794, 42795, 42797, 42798, 42799, 42800, 42802, 42803, 42805, 42806, 42807, 42808, 42810, 42811, 42812, 42814, 42815, 42816, 42817, 42818, 42819, 42820, 42821, 42822, 42823, 42825, 42826, 42827, 42828, 42829, 42830, 42831, 42832, 42835, 42836, 42837, 42839, 42840, 42841, 42842, 42843, 42844, 42845, 42846, 42848, 42849, 42850, 42851, 42853, 42868, 42884, 42886, 42911, 42914, 43015, 43079, 43081, 43084, 43093, 43098, 43104, 43115, 43127, 43143, 43152, 43163, 43170, 43229, 43232, 43239, 43244, 43260, 43263, 43290, 43303, 43313, 43315, 43321, 43322, 43330, 43333, 43337, 43347, 43350, 43352, 43355, 43395, 43399, 43400, 43402, 43407, 43412, 43415, 43423, 43437, 43439, 43446, 43453, 43460, 43494, 43784, 43858, 43905, 43908, 43912, 43914, 43919, 43920, 43923, 43926, 43927, 43929, 43931, 43932, 43934, 43935, 43936, 43938, 43940, 43942, 43944, 43945, 43951, 43956, 43957, 43963, 43964, 43965, 43968, 43969, 43970, 43975, 43977, 43979, 43981, 43983, 43984, 43985, 43986, 43988, 43991, 43992, 44001, 44004, 44006, 44007, 44008, 44009, 44010, 44011, 44012, 44013, 44014, 44015, 44017, 44019, 44021, 44023, 44024, 44025, 44033, 44037, 44039, 44068, 44080, 44093, 44129, 44147, 44170, 44235, 44286, 44311, 44328, 44337, 44382, 44419, 44447, 44480, 44483, 44486, 44498, 44508, 44512, 44519, 44528, 44545, 44549, 44556, 44558, 44559, 44561, 44562, 44563, 44564, 44565, 44566, 44567, 44570, 44573, 44577, 44579, 44580, 44582, 44583, 44585, 44586, 44785, 44840, 45037, 45048, 45064, 45087, 45097, 45098, 45099, 45101, 45104, 45105, 45107, 45110, 45115, 45117, 45119, 45121, 45122, 45123, 45124, 45128, 45129, 45130, 45131, 45132, 45133, 45134, 45220, 45407, 45420, 45425, 45537, 45547, 45597, 45607, 45610, 45613, 45616, 45617, 45618, 45622, 45624, 45625, 45626, 45627, 45628, 45629, 45631, 45632, 45633, 45634, 45635, 45637, 45638, 45639, 45640, 45641, 45642, 45643, 45644, 45646, 45647, 45648, 45649, 45651, 45652, 45653, 45655, 45656, 45657, 45658, 45659, 45660, 45661, 45663, 45664, 45665, 45666, 45667, 45668, 45670, 45671, 45673, 45674, 45676, 45677, 45678, 45679, 45680, 45682, 45683, 45684, 45685, 45686, 45687, 45688, 45689, 45690, 45745, 45892, 45918, 45997, 46033, 46042, 46045, 46050, 46065, 46073, 46109, 46148, 46169, 46181, 46183, 46184, 46188, 46196, 46200, 46204, 46205, 46207, 46211, 46212, 46214, 46215, 46218, 46221, 46222, 46223, 46224, 46226, 46228, 46229, 46230, 46231, 46236, 46238, 46240, 46242, 46244, 46246, 46248, 46249, 46251, 46252, 46253, 46254, 46255, 46257, 46258, 46259, 46309, 46338, 46341, 46365, 46488, 46536, 46566, 46571, 46593, 46609, 46700, 46711, 46713, 46729, 46736, 46742, 46744, 46749, 46752, 46753, 46755, 46757, 46759, 46762, 46763, 46764, 46765, 46768, 46770, 46773, 46775, 46777, 46778, 46779, 46782, 46783, 46785, 46786, 46787, 46788, 46789, 46792, 46794, 46795, 46797, 46799, 46801, 46802, 46805, 46807, 46810, 46812, 46813, 46814, 46816, 46818, 46819, 46820, 46822, 46824, 46826) 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 Spanish Barber

Afterpiece Title: A Beggar on Horseback

Cast
Role: Billy Actor: Painter

Dance: End of mainpiece The Merry Lasses by Master Giorgi, Miss Byrne, &c

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Peeping Tom

Cast
Role: Stump Actor: Painter

Performances

Mainpiece Title: Lionel And Clarissa

Afterpiece Title: A Beggar on Horseback

Cast
Role: Billy Actor: Painter

Dance: End of mainpiece The Merry Lasses by Giorgi's Scholars

Performances

Mainpiece Title: Lord Russel

Afterpiece Title: Peeping Tom

Cast
Role: Stump Actor: Painter

Dance: End of mainpiece The Lover in Disguise by Byrne and the two Miss Simonets

Performances

Mainpiece Title: The Maid Of The Mill

Afterpiece Title: A Beggar on Horseback

Cast
Role: Billy Actor: Painter

Dance: As17850623

Performances

Mainpiece Title: The Jealous Wife

Afterpiece Title: A Beggar on Horseback

Cast
Role: Billy Actor: Painter

Performances

Mainpiece Title: The Two Connoisseurs

Afterpiece Title: The Agreeable Surprise

Cast
Role: Stump Actor: Painter

Performances

Mainpiece Title: The Jealous Wife

Afterpiece Title: The Agreeable Surprise

Cast
Role: Stump Actor: Painter

Performances

Mainpiece Title: The Two Connoisseurs

Afterpiece Title: The Agreeable Surprise

Cast
Role: Stump Actor: Painter

Dance: As17850706

Performances

Mainpiece Title: The English Merchant

Afterpiece Title: Peeping Tom

Cast
Role: Stump Actor: Painter

Dance: As17850706

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Harlequin Teague; or, The Giant's Causeway

Cast
Role: Fainting Butcher Actor: Painter

Dance: Afterpiece: To conclude with a Grand Ballet by Byrne and the two Miss Simonets, &c. [This was danced, as here assigned, in all subsequent performances.]

Performances

Mainpiece Title: Turk, And No Turk

Afterpiece Title: A Beggar on Horseback

Cast
Role: Billy Actor: Painter

Performances

Mainpiece Title: Turk, And No Turk

Afterpiece Title: Peeping Tom

Cast
Role: Stump Actor: Painter

Performances

Mainpiece Title: The English Merchant

Afterpiece Title: The Agreeable Surprise

Cast
Role: Stump Actor: Painter

Dance: As17850706

Performances

Mainpiece Title: The Young Quaker

Cast
Role: Goliah Actor: Miss Painter

Afterpiece Title: The Flitch of Bacon

Dance: As17850617

Song: End of Act III of mainpiece The Tobacco Box by Mr and Miss Brett

Performances

Mainpiece Title: The Manager In Distress

Afterpiece Title: Gretna Green

Afterpiece Title: Harlequin Teague

Cast
Role: Fainting Butcher Actor: Painter

Music:

Performances

Mainpiece Title: Turk, And No Turk

Afterpiece Title: Harlequin Teague

Performances

Mainpiece Title: All's Well That Ends Well

Afterpiece Title: The Green Room; or, Cut and Come Again

Afterpiece Title: Gretna Green

Performances

Mainpiece Title: Turk, And No Turk

Afterpiece Title: Harlequin Teague

Performances

Mainpiece Title: All's Well That Ends Well

Afterpiece Title: Harlequin Teague

Dance: End of mainpiece Horn sweet's the Love that meets Return by Byrne, Mrs Goodwin, the two Miss Simonets

Performances

Mainpiece Title: The Suicide

Afterpiece Title: The Agreeable Surprise

Cast
Role: Stump Actor: Painter

Dance: End of Act I of mainpiece The Merry Lasses, as17850705 End of Act III, as17850728

Performances

Mainpiece Title: The Manager In Distress

Afterpiece Title: Lord Russel

Afterpiece Title: Harlequin Teague

Cast
Role: Fainting Butcher Actor: Painter

Performances

Mainpiece Title: Nature Will Prevail

Afterpiece Title: Rosina

Afterpiece Title: Gretna Green

Song: End of 1st piece The Soldier tir'd of War's Alarms; End of Act I of 2nd piece Colin cur'd of roving, both by Miss George. duologue. End of 2nd piece A New Lecture on Heads by the two Miss Vernells (their 1st appearance on any stage)

Performances

Mainpiece Title: The Jealous Wife

Afterpiece Title: Gretna Green

Dance: As17850625

Performances

Mainpiece Title: Seeing Is Believing

Afterpiece Title: Gretna Green

Afterpiece Title: Rosina

Dance: End of 2nd piece, as17850627