names

65 rows where place_id = 589154

✎ 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
3596706 1866605 1866605 defendant Brandesby William yeoman 589154 589154 Brandesby, William, of Nafferton, yeoman 0
3601806 1868223 1868223 defendant Brandesby William yeoman 589154 589154 Brandesby, William, of Nafferton, yeoman 0
3623364 1874837 1874837 defendant Asbrigge Thomas butcher 589154 589154 Asbrigge, Thomas, of Nafferton, butcher 1
3709057 1929132 1929132 defendant Weddell Gilbert gent 589154 589154 Weddell, Gilbert, of Nafferton, gent 0
3868842 1979819 1979819 defendant Woddalle Gilbert gent 589154 589154 Woddalle, Gilbert, of Nafferton, gent 3
3965460 2012534 2012534 defendant Dickson Roger husbandman 589154 589154 Dickson, Roger, of Nafferton, husbandman 0
3965474 2012536 2012536 defendant Dickson Roger husbandman 589154 589154 Dickson, Roger, of Nafferton, husbandman 8
4055036 2044198 2044198 defendant Laborne Richard yeoman 589154 589154 Laborne, Richard, of Nafferton, yeoman 1
4055039 2044199 2044199 defendant Labourne Richard yeoman 589154 589154 Labourne, Richard, of Nafferton, yeoman 1
4077163 2052117 2052117 defendant Snell or Suell Henry yeoman 589154 589154 Snell or Suell, Henry, of Nafferton, yeoman 1
4083360 2054332 2054332 defendant Laborne Richard husbandman 589154 589154 Laborne, Richard, of Nafferton, husbandman 0
4101392 2060802 2060802 defendant Watson George husbandman 589154 589154 Watson, George, of Nafferton, husbandman 0
4101645 2060895 2060895 defendant Hayre George husbandman 589154 589154 Hayre, George, of Nafferton, husbandman 1
4151330 2078587 2078587 defendant Lasborne Robert husbandman 589154 589154 Lasborne, Robert, of Nafferton, husbandman 1
4229034 2105638 2105638 defendant Gerratt Richard husbandman 589154 589154 Gerratt, Richard, of Nafferton, husbandman 0
4229035 2105638 2105638 defendant Gerratt Thomas husbandman 589154 589154 Gerratt, Thomas, of Nafferton, husbandman 1
4256643 2115192 2115192 defendant Laburne Robert husbandman 589154 589154 Laburne, Robert, of Nafferton, husbandman 0
4340521 2143951 2143951 defendant Colson Martin yeoman 589154 589154 Colson, Martin, of Nafferton, yeoman 0
4370863 2154634 2154634 defendant Tathwell Elizabeth widow 589154 589154 Tathwell, Elizabeth, of Nafferton, widow 0
4458679 2187758 2187758 defendant Wandesford John de   589154 589154 Wandesford, John de, of Nafferton 1
4461066 2188536 2188536 defendant Lyndeseye John de   589154 589154 Lyndeseye, John de, of Nafferton, son of Thomas 2
4464276 2189490 2189490 plaintiff Wandesford John de   589154 589154 Wandesford, John de, of Nafferton, on his own account 0
4475041 2192864 2192864 defendant Serjaunt Robert   589154 589154 Serjaunt, Robert, of Nafferton 2
4709899 2268455 2268455 defendant Waryner Robert husbandman 589154 589154 Waryner, Robert, of Nafferton, husbandman 2
4719361 2271397 2271397 defendant Fykas Thomas husbandman 589154 589154 Fykas, Thomas, of Nafferton, husbandman 0
4731159 2274945 2274945 defendant Richardson Walter yeoman 589154 589154 Richardson, Walter, of Nafferton, yeoman 0
4736575 2276570 2276570 defendant Smyth Thomas husbandman 589154 589154 Smyth, Thomas, of Nafferton, husbandman 0
4736576 2276570 2276570 defendant Smyth Robert husbandman 589154 589154 Smyth, Robert, of Nafferton, husbandman 1
4736577 2276570 2276570 defendant Bele John   589154 589154 Bele, John, of Nafferton 2
4736578 2276570 2276570 defendant Tidlotson Clement husbandman 589154 589154 Tidlotson, Clement, of Nafferton, husbandman 3
4738886 2277253 2277253 defendant Mulde Thomas   589154 589154 Mulde, Thomas, of Nafferton 0
4774852 2288129 2288129 defendant Wetewang Thomas yeoman 589154 589154 Wetewang, Thomas, of Nafferton, yeoman 0
4799241 2295940 2295940 defendant Browet John husbandman 589154 589154 Browet, John, of Nafferton, husbandman 3
4833525 2306492 2306492 defendant Serff Robert yeoman 589154 589154 Serff, Robert, of Nafferton, yeoman 1
4843706 2309555 2309555 defendant Storme John chaplain 589154 589154 Storme, John, of Nafferton, chaplain 1
4843711 2309556 2309556 defendant Storme John chaplain 589154 589154 Storme, John, of Nafferton, chaplain 1
4843754 2309568 2309568 defendant Warner William yeoman 589154 589154 Warner, William, of Nafferton, yeoman 0
4927574 2335059 2335059 defendant Johnson Robert husbandman 589154 589154 Johnson, Robert, of Nafferton, husbandman 0
4986936 2353035 2353035 defendant Coke Margaret widow 589154 589154 Coke, Margaret, of Nafferton, widow 0
4986937 2353035 2353035 defendant Birtele William yeoman 589154 589154 Birtele, William, of Nafferton, yeoman 1
5018331 2362247 2362247 defendant Wod Robert miller 589154 589154 Wod, Robert, of Nafferton, miller 0
5018333 2362248 2362248 defendant Wod Robert miller 589154 589154 Wod, Robert, of Nafferton, miller 0
5027813 2365014 2365014 defendant Moderson Robert husbandman 589154 589154 Moderson, Robert, of Nafferton, husbandman 0
5070921 2377795 2377795 defendant Kynyowe Richard husbandman 589154 589154 Kynyowe, Richard, of Nafferton, husbandman 0
5070923 2377795 2377795 defendant Kynyowe Robert husbandman 589154 589154 Kynyowe, Robert, of Nafferton, husbandman 2
5079555 2380373 2380373 defendant Spynes Thomas husbandman 589154 589154 Spynes, Thomas, of Nafferton, husbandman 0
5080819 2380754 2380754 defendant Russell John yeoman 589154 589154 Russell, John, of Nafferton,yeoman 0
5090592 2383630 2383630 defendant Selby Henry yeoman 589154 589154 Selby, Henry, of Nafferton, yeoman 1
5098756 2386065 2386065 defendant Selby Robert yeoman 589154 589154 Selby, Robert, of Nafferton, yeoman 0
5139775 2398110 2398110 defendant Swyppe John yeoman 589154 589154 Swyppe, John, of Nafferton, yeoman 1
5141937 2398763 2398763 defendant Malynson Thomas husbandman 589154 589154 Malynson, Thomas, of Nafferton, husbandman 2
5160722 2404235 2404235 defendant Swyppe John yeoman 589154 589154 Swyppe, John, of Nafferton, yeoman 1
5163021 2404912 2404912 defendant Kyghley Simon gent 589154 589154 Kyghley, Simon, of Nafferton, gent 3
5163030 2404914 2404914 defendant Malynson Thomas husbandman 589154 589154 Malynson, Thomas, of Nafferton, husbandman 2
5175430 2408507 2408507 defendant Swyppe John yeoman 589154 589154 Swyppe, John, of Nafferton, yeoman 1
5176862 2408922 2408922 defendant Malynson Thomas husbandman 589154 589154 Malynson, Thomas, of Nafferton, husbandman 2
5199425 2415581 2415581 defendant Kyghley Simon gent 589154 589154 Kyghley, Simon, of Nafferton, gent 2
5199430 2415582 2415582 defendant Malynson Thomas husbandman 589154 589154 Malynson, Thomas, of Nafferton, husbandman 2
5309498 2447879 2447879 defendant Hol_e Robert   589154 589154 Hol_e, Robert, of Nafferton, yeoman, formerly bailiff of the wapentake of Dykeryng 1
5415462 2479562 2479562 defendant Swynburn Thomas gent 589154 589154 Swynburn, Thomas, of Nafferton, gent 2
5503182 2505904 2505904 defendant Crossewall illiam husbandman 589154 589154 Crossewall, illiam, of Nafferton, husbandman 3
5503195 2505907 2505907 defendant Crossewold Margaret widow 589154 589154 Crossewold, Margaret, of Nafferton, widow 5
5503204 2505908 2505908 defendant Crossewold Margaret widow 589154 589154 Crossewold, Margaret, of Nafferton, widow 5
5517488 2510310 2510310 defendant Crossewold William husbandman 589154 589154 Crossewold, William, of Nafferton, husbandman 3
5571614 2526253 2526253 defendant Swynborne Thomas (legal representative) 589154 589154 Swynborne, Thomas, of Nafferton, executors of 0

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);