Sample institutional offices

Sample institutional offices; optional start_year / end_year (defaults 1349–1596).

Custom SQL query returning 50 rows (hide) 

SELECT n.surname, n.forename, n.occupation, n.raw_segment, c.year
FROM names n
JOIN cases c ON c.id = n.case_id
WHERE n.surname IN ('(not given)', '(illegible)')
  AND n.occupation IS NOT NULL
  AND (
    lower(n.occupation) LIKE '%abbot%'
    OR lower(n.occupation) LIKE '%prior%'
    OR lower(n.occupation) LIKE '%dean%'
  )
  AND c.year IS NOT NULL
  AND c.year >= CAST(COALESCE(NULLIF(:start_year, ''), '1349') AS INTEGER)
  AND c.year <= CAST(COALESCE(NULLIF(:end_year, ''), '1596') AS INTEGER)
LIMIT 50

Query parameters

Edit SQL

This data as json, CSV

surnameforenameoccupationraw_segmentyear
(illegible) James abbot of the monastery of St Mary, in _, James, abbot of the monastery of St Mary, in 1424
(illegible) (illegible) Yorks, reverend abbot of St Mary's ---, ---, Yorks, reverend abbot of St Mary's 1450
(illegible) (illegible) Yorks, reverend abbot of St Mary's ---, ---, Yorks, reverend abbot of St Mary's 1450
(illegible) (illegible) Yorks, reverend abbot of St Mary's ---, ---, Yorks, reverend abbot of St Mary's 1450
(illegible) (illegible) Yorks, reverend abbot of St Mary's ---, ---, Yorks, reverend abbot of St Mary's 1450
(illegible) (illegible) Yorks, reverend abbot of St Mary's ---, ---, Yorks, reverend abbot of St Mary's 1450
(illegible) (illegible) Yorks, reverend abbot of St Mary's ---, ---, Yorks, reverend abbot of St Mary's 1450
(illegible) (illegible) Yorks, reverend abbot of St Mary's ---, ---, Yorks, reverend abbot of St Mary's 1450
(illegible) John prior _, John, prior 1460
(illegible)   abbot of St Mary & St John _, abbot of St Mary & St John 1473
(illegible) John abbot of a monstery ----, John, abbot of a monstery 1484
(illegible) John abbot of St Augustines monastery _, John, abbot of St Augustines monastery 1484
(illegible) Thomas prior of the house & church, in _, Thomas, prior of the house & church, in 1485
(illegible) Richard prior _, Richard, prior 1485
(illegible) John prior of the church, in ---, John, prior of the church, in 1483
(illegible) William prior ---, William, prior 1483
(not given)   abbot of Athelney Abbey Athelney Abbey, abbot of 1492
(not given) William prior of Avecote Priory Avecote Priory, William, prior of 1492
(not given) Richard prior of Axholm Priory Axholm Priory, Richard, prior of 1492
(not given) John prior of Axholme Priory Axholme Priory, John, prior of 1492
(not given) John prior of Axholme Priory Axholme Priory, John, prior of 1492
(not given) Humphrey abbot of Beaulieu Abbey Beaulieu Abbey, Humphrey, abbot of 1492
(not given) Robert prior of Berlyche Priory Berlyche Priory, Robert, prior of 1492
(not given) Robert prior of Berlyche Priory Berlyche Priory, Robert, prior of 1492
(not given) William prior of Bodmine Priory Bodmine Priory, William, prior of 1492
(not given) Margaret prioress of Arden Priory Arden Priory, Margaret, prioress of 1492
(not given) Anne prioress of Bromehale Priory Bromehale Priory, Anne, prioress of 1492
(not given)   prior of Bromholme Priory Bromholme Priory, prior of 1492
(not given) Roger prior of Old Malton Priory Old Malton Priory, Roger, prior of 1492
(not given) Roger prior of Old Malton Priory Old Malton Priory, Roger, prior of 1492
(not given) Thomas abbot of Chertesey Abbey Chertesey Abbey, Thomas, abbot of 1492
(not given) Henry abbot of Cleeve Abbey Cleeve Abbey, Henry, abbot of 1492
(not given) Thomas prior of Cumberwell Priory Cumberwell Priory, Thomas, prior of 1492
(not given) Roger prior of Ely Cathedral Priory Ely Cathedral Priory, Roger, prior of 1492
(not given) Roger prior of Ely Cathedral Priory Ely Cathedral Priory, Roger, prior of 1492
(not given)   dean and chapter of Exeter Cathedral Exeter Cathedral, dean and chapter of 1492
(not given)   dean and chapter of Exeter Cathedral Exeter Cathedral, dean and chapter of 1492
(not given) William abbot of Forde Abbey Forde Abbey, William, abbot of 1492
(not given) William abbot of Forde Abbey Forde Abbey, William, abbot of 1492
(not given) Robert prior of Holy Trinity Priory, York Holy Trinity Priory, York, Robert, prior of 1492
(not given) Robert prior of Holy Trinity Priory, York Holy Trinity Priory, York, Robert, prior of 1492
(not given) John prior of Gysburn Priory Gysburn Priory, John, prior of 1492
(not given) John prior of Clatercote Priory Clatercote Priory, John, prior of 1492
(not given) William prior of Hanten Prise Priory Hanten Prise Priory, William, prior of 1492
(not given) Thomas abbot of Hayles Abbey Hayles Abbey, Thomas, abbot of 1492
(not given)   dean of Hereford Cathedral Hereford Cathedral, dean of 1492
(not given)   dean of Hereford Cathedral Hereford Cathedral, dean of 1492
(not given) William prior of Shire Shire, William, of Parva Dene, yeoman, servant of prior of Lanthon Priory 1492
(not given) Elizabeth prioress of Hyndewode Priory Hyndewode Priory, Elizabeth, prioress of 1492
(not given) Henry abbot of Jervaulx Abbey Jervaulx Abbey, Henry, abbot of 1492