SELECT * FROM london_stages WHERE eventid IN (964, 1099, 2371, 3921, 4055, 4120, 4259, 4290, 4362, 4432, 4503, 4626, 4892, 4963, 5099, 5171, 5331, 5471, 5735, 5824, 6086, 6212, 6520, 6605, 6783, 6790, 6961, 7022, 7074, 7153, 7230, 7372, 7414, 7456, 7884, 8018, 8160, 8425, 8476, 9270, 9522, 10542, 10839, 11336, 11337, 12951, 12954, 13002, 13091, 13233, 13312, 14540, 14543, 14549, 14679, 14683, 14828, 14873, 15675, 16680, 17052, 17065, 17213, 17398, 17406, 17478, 17550, 17583, 17633, 17634, 17821, 17896, 18016, 18076, 18088, 18552, 18558, 18564, 18572, 18583, 18630, 18651, 18738, 18867, 19016, 19061, 19110, 19112, 19180, 19251, 19306, 19335, 19382, 19456, 19509, 19530, 19566, 19610, 19678, 19804, 19882, 20006, 20085, 20148, 20498, 20614, 20740, 20896, 21046, 21267, 21450, 21810, 22323, 22625, 22636, 22639, 22644, 22647, 22650, 22654, 22657, 22747, 22917, 23045, 23128, 23203, 23275, 23364, 23472, 23594, 23648, 23824, 24319, 24758, 25508, 25512, 25556, 25559, 25561, 25564, 25566, 25568, 25570, 25572, 25574, 27753, 28097, 28668, 28670, 28672, 28697, 28743, 28832, 28835, 29023, 29332, 29543, 30129, 30637, 30887, 31235, 31391, 31524, 31530, 31541, 31547, 31609, 31652, 31712, 31769, 31836, 31866, 31882, 31947, 32069, 32077, 32158, 32178, 32244, 32324, 32335, 32463, 32517, 32540, 32719, 32723, 32816, 32918, 32940, 33076, 33080, 33155, 33164, 33276, 33373, 33477, 33602, 33701, 34506, 34528, 34744, 34794, 36070, 36093, 38372, 38388, 38395, 38482, 39694, 39708, 41143, 41908, 41913, 42868, 43031, 43276, 44202, 44334, 44347, 44371, 44391, 44398, 44609, 44725, 44749, 44814, 44839, 44886, 44943, 44997, 45474, 45734, 45847, 45887, 45957, 45990, 46064, 46147, 46360, 46362, 46364, 46368, 46372, 46376, 46378, 46380, 46384, 46388, 46390, 46392, 46396, 46398, 46400, 46404, 46408, 46416, 46420, 46424, 46428, 46432, 46437, 46442, 46447, 46451, 46456, 46461, 46465, 46470, 46475, 46477, 46480, 46482, 46487, 46491, 46496, 46501, 46505, 46510, 46518, 46528, 46542, 46556, 46563, 46570, 46584, 46599, 46608, 46613, 46621, 46628, 46638, 46643, 46644, 46658, 46668, 46672, 46691, 46746, 46827, 46842, 46845, 46850, 46859, 46862, 46870, 46872, 46878, 46882, 46890, 46891, 46894, 46902, 46914, 46922, 46926, 46938, 46950, 46956, 46962, 46968, 46972, 46974, 46986, 47090, 47095, 47103, 47138, 47166, 47182, 47213, 47228, 47230, 47254, 47269, 47289, 47296, 47326, 47385, 47443, 47445, 47460, 47471, 47481, 47483, 47490, 47492, 47494, 47567, 47571, 47585, 47594, 47622, 47646, 47677, 47682, 47692, 47703, 47713, 47718, 47736, 47743, 47763, 47778, 47817, 47819, 47859, 47886, 47995, 47996, 48009, 48011, 48013, 48014, 48018, 48027, 48030, 48031, 48034, 48035, 48037, 48042, 48046, 48048, 48050, 48056, 48058, 48060, 48067, 48075, 48106, 48110, 48116, 48120, 48130, 48132, 48138, 48177, 48224, 48235, 48242, 48263, 48270, 48291, 48310, 48374, 48424, 48620, 48723, 48738, 48750, 48768, 48772, 48780, 48788, 48792, 48797, 48804, 48818, 48820, 48831, 48836, 48843, 48850, 48959, 48984, 49081, 49136, 49155, 49221, 49489, 49621, 49665, 49675, 49679, 49683, 49688, 49691, 49698, 49699, 49706, 49707, 49712, 49720, 49724, 49725, 49726, 49734, 49736, 49738, 49740, 49741, 49746, 49748, 49750, 49752, 49753, 49822, 49892, 49894, 50015, 50040, 50072, 50190, 50221, 50344, 50349, 50357, 50386, 50434, 50761, 50771, 50804, 50806, 50825, 50830, 50835, 50845, 50848, 50849, 50853, 50858, 50864, 50867, 50869, 50870, 50877, 50879, 50885, 50890, 50893, 50895, 50896, 50901, 50902, 50903, 50910, 50922, 50943, 50970, 50983, 50985, 51026, 51355, 51382, 51614, 51623, 51675, 51830, 51865, 51967, 52033, 52109, 52149, 52165, 52220, 52417, 52453, 52470, 52491, 52494, 52515, 52540, 52553) 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: Peeping Tom

Afterpiece Title: The Honest Thieves

Afterpiece Title: The Agreeable Surprise

Cast
Role: Count Lewis Actor: Lyons.

Performances

Mainpiece Title: Love Makes A Man; Or, The Fop's Fortune

Cast
Role: Don Lewis Actor: Munden

Afterpiece Title: Peeping Tom

Cast
Role: Count Lewis Actor: Lyons.

Performances

Mainpiece Title: The Chapter Of Accidents

Afterpiece Title: The Agreeable Surprise

Cast
Role: Count Lewis Actor: Lyons.

Performances

Mainpiece Title: Cross Purposes

Afterpiece Title: The London Hermit

Cast
Role: Count Lewis Actor: Lyons.

Afterpiece Title: Lock and Key

Performances

Mainpiece Title: The Purse

Afterpiece Title: The Heir at Law

Afterpiece Title: Cross Purposes

Cast
Role: Count Lewis Actor: Lyons.

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: The Heir at Law

Afterpiece Title: Cross Purposes

Cast
Role: Count Lewis Actor: Lyons.

Performances

Mainpiece Title: The Heir At Law

Afterpiece Title: Peeping Tom

Cast
Role: Count Lewis Actor: Lyons.

Performances

Mainpiece Title: The Purse

Afterpiece Title: The Heir at Law

Cast
Role: Count Lewis Actor: Lyons.

Afterpiece Title: Cross Purposes

Cast
Role: Count Lewis Actor: Lyons.

Performances

Mainpiece Title: The Heir At Law

Afterpiece Title: The Mock Doctor

Cast
Role: Count Lewis Actor: Lyons.

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: The Surrender of Calais

Afterpiece Title: The Purse

Cast
Role: Count Lewis Actor: Lyons.

Song: As17970705

Performances

Mainpiece Title: Half An Hour After Supper

Afterpiece Title: The Mountaineers

Afterpiece Title: Cross Purposes

Cast
Role: Count Lewis Actor: Lyons.

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: The Heir at Law

Cast
Role: Count Lewis Actor: Lyons.

Afterpiece Title: The Mock Doctor

Cast
Role: Count Lewis Actor: Lyons.

Performances

Mainpiece Title: The Italian Monk

Afterpiece Title: The Agreeable Surprise

Cast
Role: Count Lewis Actor: Lyons.

Song: As17970816

Performances

Mainpiece Title: The Surrender Of Calais

Afterpiece Title: The Irish Tar; or, Which is the Girl

Afterpiece Title: The Agreeable Surprise

Cast
Role: Count Lewis Actor: Lyons.

Song: 1st piece: Vocal Parts, as17970623 but _Caulfield Jun., _Walker, _Willoughby, Mrs _Butler, Mrs _Masters, Mrs _Norton, Miss _Menage, Mrs _Wall, Mrs _Benson, Miss _Leserve

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: Peeping Tom

Cast
Role: Count Lewis Actor: Lyons.

Performances

Mainpiece Title: The Italian Monk

Afterpiece Title: A Mogul Tale

Cast
Role: Count Lewis Actor: Palmer Jun.

Song: As17970816

Performances

Mainpiece Title: The Iron Chest

Afterpiece Title: The Agreeable Surprise

Cast
Role: Count Lewis Actor: Lyons.

Song: Mainpiece: General Chorus, as17970814, but added: Lyons, Miss +Andrews, _Walker, _Dibble, _Caulfield Jun., Ms _Edward, Ms _Gaudry, Ms _Hale

Performances

Mainpiece Title: The Italian Monk

Afterpiece Title: Sylvester Daggerwood

Afterpiece Title: Peeping Tom

Cast
Role: Count Lewis Actor: Lyons.

Song: 1st piece: General Chorus, as17970816

Performances

Mainpiece Title: The Purse

Afterpiece Title: The London Hermit

Cast
Role: Count Lewis Actor: Lyons.

Afterpiece Title: The Children in the Wood

Performances

Mainpiece Title: The Jew

Afterpiece Title: The Agreeable Surprise

Cast
Role: Count Lewis Actor: Lyons.

Performances

Mainpiece Title: The Heir At Law

Afterpiece Title: Sylvester Daggerwood

Afterpiece Title: Peeping Tom

Cast
Role: Count Lewis Actor: Lyons.

Song: End II: The Nightingale-Mrs Atkins; End: The Flowing can-Mrs Harlowe; End 2nd piece: Sweet Echo, as17970904

Performances

Mainpiece Title: She Wou'd And She Wou'd Not

Cast
Role: Don Lewis Actor: Caulfield

Afterpiece Title: The Humourist

Performances

Mainpiece Title: The Haunted Tower

Cast
Role: Lewis Actor: Suett

Afterpiece Title: The Wandering Jew; or, Love's Masquerade

Entertainment: Entertainment.End afterpiece: As17971016

Performances

Mainpiece Title: The Haunted Tower

Cast
Role: Lewis Actor: Suett

Afterpiece Title: The Humourist

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: An Escape into Prison

Cast
Role: Don Lewis Actor: Powel

Song: As17971102