names

109 rows where place_id = 601376

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3645086 1908871 1908871 defendant Chapman Alice widow 601376 601376 Chapman, Alice, of Lenton, widow 1
3645087 1908871 1908871 defendant Gelham Margery widow 601376 601376 Gelham, Margery, of Lenton, widow 2
3645539 1909003 1909003 defendant Hode Ralph miller 601376 601376 Hode, Ralph, of Lenton, miller 0
3653102 1911301 1911301 defendant Dale William laborer 601376 601376 Dale, William, of Lenton, laborer 0
3653103 1911301 1911301 defendant Rouse Richard laborer 601376 601376 Rouse, Richard, of Lenton, laborer 1
3653104 1911301 1911301 defendant Asshore Roger laborer 601376 601376 Asshore, Roger, of Lenton, laborer 2
3655653 1912031 1912031 defendant Guyllam or Gillame Thomas   601376 601376 Guyllam or Gillame, Thomas, of Lenton Abbey, prior 0
3655656 1912032 1912032 defendant Guyllam or Gillame Thomas   601376 601376 Guyllam or Gillame, Thomas, of Lenton Abbey, prior 0
3679950 1919794 1919794 defendant Berdesley Philip carpenter 601376 601376 Berdesley, Philip, of Lenton, carpenter 0
3680545 1919996 1919996 defendant Gylham William gent 601376 601376 Gylham, William, of Lenton, gent 0
3680546 1919996 1919996 defendant Dale William yeoman 601376 601376 Dale, William, of Lenton, yeoman 1
3710245 1929520 1929520 defendant Wales Thomas smith 601376 601376 Wales, Thomas, of Lenton, smith 2
3711187 1929804 1929804 defendant Delaper John   601376 601376 Delaper, John, of Lenton, physician 0
3756693 1944067 1944067 defendant Aman John   601376 601376 Aman, John, of Lenton, physician 6
3777480 1950707 1950707 defendant Wodward John carpenter 601376 601376 Wodward, John, of Lenton, carpenter 1
3789861 1954656 1954656 defendant Guyllam William yeoman 601376 601376 Guyllam, William, of Lenton, yeoman 1
3789862 1954656 1954656 defendant mason William yeoman 601376 601376 mason, William, of Lenton, yeoman 2
3813033 1961983 1961983 plaintiff Delapyre John   601376 601376 Delapyre, John, of Lenton 0
3853779 1974816 1974816 defendant Helwyke Thomas yeoman 601376 601376 Helwyke, Thomas, of Lenton, yeoman 2
3902574 1991094 1991094 defendant Mathewe Richard clerk 601376 601376 Mathewe, Richard, of Lenton, clerk 1
3909894 1993616 1993616 defendant Feld Richard husbandman 601376 601376 Feld, Richard, of Lenton, husbandman 0
3925804 1998947 1998947 defendant Wrygston John   601376 601376 Wrygston, John, of Lenton, parish clerk 1
3925805 1998947 1998947 defendant Keyr Melchior laborer 601376 601376 Keyr, Melchior, of Lenton, laborer 2
3936567 2002554 2002554 defendant Weston Anthony yeoman 601376 601376 Weston, Anthony, of Lenton, yeoman 0
4059260 2045705 2045705 defendant Saunte Elias tailor 601376 601376 Saunte, Elias, of Lenton, tailor 0
4212169 2099803 2099803 defendant Hopkinson Richard husbandman 601376 601376 Hopkinson, Richard, of Lenton, husbandman 0
4212170 2099803 2099803 defendant Wasler William husbandman 601376 601376 Wasler, William, of Lenton, husbandman 1
4219830 2102440 2102440 defendant Belper Robert yeoman 601376 601376 Belper, Robert, of Lenton, yeoman 2
4222217 2103262 2103262 defendant Bushill William gent 601376 601376 Bushill, William, of Lenton, gent 0
4222218 2103262 2103262 defendant Meryall Ralph husbandman 601376 601376 Meryall, Ralph, of Lenton, husbandman 1
4228789 2105553 2105553 defendant Belper Robert yeoman 601376 601376 Belper, Robert, of Lenton, yeoman 2
4230610 2106202 2106202 defendant Bushill William gent 601376 601376 Bushill, William, of Lenton, gent 0
4230611 2106202 2106202 defendant Meryall Ralph husbandman 601376 601376 Meryall, Ralph, of Lenton, husbandman 1
4248100 2112351 2112351 defendant Leicester James gent 601376 601376 Leicester, James, of Lenton, gent 0
4346988 2146199 2146199 defendant Leycester John gent 601376 601376 Leycester, John, of Lenton, gent 0
4347894 2146516 2146516 defendant Hill William husbandman 601376 601376 Hill, William, of Lenton, husbandman 0
4367947 2153585 2153585 defendant Leicester James gent 601376 601376 Leicester, James, of Lenton, gent 0
4406328 2166682 2166682 defendant Lovelace William gent 601376 601376 Lovelace, William, of Lenton, gent 2
4410586 2168130 2168130 defendant Dolphin William (legal representative) 601376 601376 Dolphin, William, of Lenton, yeoman, administratrix of 1
4424961 2172645 2172645 defendant del Roche Robert   601376 601376 del Roche, Robert, of Lenton 0
4445563 2183565 2183565 defendant Granby William de   601376 601376 Granby, William de, of Lenton 2
4480209 2194469 2194469 defendant Potter Walter   601376 601376 Potter, Walter, of Lenton 0
4480211 2194469 2194469 defendant Squyer William   601376 601376 Squyer, William, of Lenton 2
4502001 2201220 2201220 defendant Breuster Robert   601376 601376 Breuster, Robert, of Lenton 6
4542758 2213623 2213623 defendant Tillyng Nicholas   601376 601376 Tillyng, Nicholas, of Lenton 1
4542759 2213623 2213623 defendant Taillour Robert   601376 601376 Taillour, Robert, of Lenton 2
4542760 2213623 2213623 defendant Shakesper John   601376 601376 Shakesper, John, of Lenton 3
4602763 2232079 2232079 defendant Serle Simon   601376 601376 Serle, Simon, of Lenton 4
4607310 2233396 2233396 defendant Day William   601376 601376 Day, William, of Lenton 5
4611340 2234606 2234606 defendant Cooke Thomas   601376 601376 Cooke, Thomas, of Lenton 2
4619180 2236996 2236996 defendant Serle Simon   601376 601376 Serle, Simon, of Lenton 1
4622921 2238148 2238148 defendant Greyve Robert   601376 601376 Greyve, Robert, of Lenton 1
4622934 2238151 2238151 defendant Greve Robert   601376 601376 Greve, Robert, of Lenton 2
4640257 2243267 2243267 defendant Greyve Robert   601376 601376 Greyve, Robert, of Lenton 0
4643043 2244074 2244074 defendant Greyve Robert   601376 601376 Greyve, Robert, of Lenton 0
4643858 2244302 2244302 defendant Cotes John de   601376 601376 Cotes, John de, of Lenton 0
4643859 2244302 2244302 defendant Lorymer Richard   601376 601376 Lorymer, Richard, of Lenton 1
4646820 2245134 2245134 defendant Serton Thomas   601376 601376 Serton, Thomas, of Lenton 0
4646821 2245134 2245134 defendant Walker Richard   601376 601376 Walker, Richard, of Lenton 1
4693301 2263407 2263407 plaintiff Barkere William   601376 601376 Barkere, William, of Lenton 0
4696744 2264460 2264460 defendant Palfreman Thomas   601376 601376 Palfreman, Thomas, of Lenton, servant 0
4700111 2265456 2265456 defendant Baillok John husbandman 601376 601376 Baillok, John, of Lenton, husbandman 0
4724534 2272970 2272970 defendant (not given) Thomas prior of Elmham 601376 601376 Elmham, Thomas, of Lenton, prior of Holy Trinity 0
4744429 2278891 2278891 plaintiff (not given) Thomas prior of Elmham 601376 601376 Elmham, Thomas, of Lenton, prior of the church of the Holy Trinity 0
4744431 2278892 2278892 plaintiff (not given) Thomas prior of Elmham 601376 601376 Elmham, Thomas, of Lenton, prior of the church of the Holy Trinity 0
4753268 2281405 2281405 defendant Hokham John   601376 601376 Hokham, John, of Lenton, parson 0
4762010 2284101 2284101 defendant Elmham Thomas   601376 601376 Elmham, Thomas, of Lenton, prior 0
4772961 2287514 2287514 defendant Rysshalle Joan widow 601376 601376 Rysshalle, Joan, of Lenton, widow 2
4782992 2290701 2290701 defendant Coke William   601376 601376 Coke, William, of Lenton, cook 1
4786825 2291938 2291938 defendant Squyer Thomas glasier 601376 601376 Squyer, Thomas, of Lenton, glasier 0
4804254 2297516 2297516 defendant badyley John   601376 601376 badyley, John, of Lenton, mason 0
4816436 2301232 2301232 defendant Norwich Robert husbandman 601376 601376 Norwich, Robert, of Lenton, husbandman 0
4816437 2301232 2301232 defendant Ingram John husbandman 601376 601376 Ingram, John, of Lenton, husbandman 1
4816438 2301232 2301232 defendant Clay Roger husbandman 601376 601376 Clay, Roger, of Lenton, husbandman 2
4827501 2304649 2304649 defendant Botre John milner 601376 601376 Botre, John, of Lenton, milner 2
4837224 2307588 2307588 defendant Coke Robert shoemaker 601376 601376 Coke, Robert, of Lenton, shoemaker 3
4853272 2312439 2312439 defendant Hulbroke William yeoman 601376 601376 Hulbroke, William, of Lenton, yeoman 4
4853278 2312440 2312440 defendant Lees Ralph de husbandman 601376 601376 Lees, Ralph de, of Lenton, husbandman 4
4861849 2315083 2315083 defendant Glasyer John glasier 601376 601376 Glasyer, John, of Lenton, glasier 1
4876999 2319778 2319778 defendant Wryghte alas Clerk Adam husbandman 601376 601376 Wryghte alas Clerk, Adam, of Lenton, husbandman 0
4877000 2319778 2319778 defendant Wryghte alas Clerk Ralph husbandman 601376 601376 Wryghte alas Clerk, Ralph, of Lenton, husbandman 1
4889871 2323620 2323620 defendant Drake John yeoman 601376 601376 Drake, John, of Lenton, yeoman 3
4939918 2338870 2338870 defendant Houbroke Henry husbandman 601376 601376 Houbroke, Henry, of Lenton, husbandman 0
4957886 2344331 2344331 defendant Dyker alias Saunderson William husbandman 601376 601376 Dyker alias Saunderson, William, of Lenton, husbandman 0
5034627 2366987 2366987 defendant Hobbroke Henry husbandman 601376 601376 Hobbroke, Henry, of Lenton, husbandman 1
5064176 2375825 2375825 defendant Ryddynges William husbandman 601376 601376 Ryddynges, William, of Lenton, husbandman 3
5105346 2388008 2388008 defendant Hyde Peter carpenter 601376 601376 Hyde, Peter, of Lenton, carpenter 0
5105347 2388008 2388008 defendant Glasyer William glasier 601376 601376 Glasyer, William, of Lenton, glasier 1
5105348 2388008 2388008 defendant Glasyer Hugh glasier 601376 601376 Glasyer, Hugh, of Lenton, glasier 2
5120873 2392537 2392537 defendant Hyde Peter carpenter 601376 601376 Hyde, Peter, of Lenton, carpenter 0
5211935 2419228 2419228 defendant Glover William glover 601376 601376 Glover, William, of Lenton, glover 0
5263675 2434388 2434388 defendant Mason Nicholas   601376 601376 Mason, Nicholas, of Lenton, mason 0
5304892 2446467 2446467 defendant Hygyn Thomas butcher 601376 601376 Hygyn, Thomas, of Lenton, butcher 0
5331832 2454600 2454600 defendant Rysley Henry husbandman 601376 601376 Rysley, Henry, of Lenton, husbandman 0
5331833 2454600 2454600 defendant Smyth Adam laborer 601376 601376 Smyth, Adam, of Lenton, laborer 1
5350103 2460158 2460158 defendant Moreton Robert yeoman 601376 601376 Moreton, Robert, of Lenton, yeoman 0
5350104 2460158 2460158 defendant Lambard John laborer 601376 601376 Lambard, John, of Lenton, laborer 1
5350105 2460158 2460158 defendant Paliasar William yeoman 601376 601376 Paliasar, William, of Lenton, yeoman 2
5368752 2465819 2465819 plaintiff (not given) Richard prior of Dene 601376 601376 Dene, Richard, of Lenton, prior of the Monastery of the Holy Trinity 0
5454238 2491176 2491176 plaintiff (not given) Richard prior of _ 601376 601376 _, Richard, of Lenton, prior of the monastery of Holy Trinity 0

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);