names

80 rows where place_id = 597044

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3627069 1903328 1903328 defendant Kyng Nicholas butcher 597044 597044 Kyng, Nicholas, of Henfeld, butcher 0
3698925 1925878 1925878 defendant Averey John weaver 597044 597044 Averey, John, of Henfeld, weaver 0
3698926 1925878 1925878 defendant Broke Robert yeoman 597044 597044 Broke, Robert, of Henfeld, yeoman 1
3698932 1925879 1925879 defendant Bray Edward   597044 597044 Bray, Edward, of Henfeld, knight 0
3698933 1925879 1925879 defendant Holden Robert yeoman 597044 597044 Holden, Robert, of Henfeld, yeoman 1
3698935 1925880 1925880 defendant Bray Edward   597044 597044 Bray, Edward, of Henfeld, knight 0
3698936 1925880 1925880 defendant Holden Robert yeoman 597044 597044 Holden, Robert, of Henfeld, yeoman 1
3698937 1925880 1925880 defendant Chate John husbandman 597044 597044 Chate, John, of Henfeld, husbandman 2
3698938 1925880 1925880 defendant Bedyng Richard husbandman 597044 597044 Bedyng, Richard, of Henfeld, husbandman 3
3698939 1925880 1925880 defendant Broke Robert yeoman 597044 597044 Broke, Robert, of Henfeld, yeoman 4
3698941 1925880 1925880 defendant Holman John husbandman 597044 597044 Holman, John, of Henfeld, husbandman 6
3706039 1928179 1928179 defendant at Towne Thomas butcher 597044 597044 at Towne, Thomas, of Henfeld, butcher 0
3736027 1937510 1937510 defendant Berde John yeoman 597044 597044 Berde, John, of Henfeld, yeoman 0
3736032 1937510 1937510 defendant Randoll Edward laborer 597044 597044 Randoll, Edward, of Henfeld, laborer 5
3736034 1937511 1937511 defendant Saywell John smith 597044 597044 Saywell, John, of Henfeld, smith 0
3751240 1942311 1942311 defendant Wodde James smith 597044 597044 Wodde, James, of Henfeld, smith 0
3756348 1943953 1943953 defendant Dukeman James shoemaker 597044 597044 Dukeman, James, of Henfeld, shoemaker 0
3774472 1949742 1949742 defendant Lucas Richard butcher 597044 597044 Lucas, Richard, of Henfeld, butcher 0
3792921 1955640 1955640 defendant A Stabull John husbandman 597044 597044 A Stabull, John, of Henfeld, husbandman 0
3807177 1960140 1960140 defendant Lucas Richard butcher 597044 597044 Lucas, Richard, of Henfeld, butcher 0
3824562 1965557 1965557 defendant Berd William yeoman 597044 597044 Berd, William, of Henfeld, yeoman 0
3824565 1965558 1965558 defendant Duggryd John laborer 597044 597044 Duggryd, John, of Henfeld, laborer 0
3824566 1965558 1965558 defendant Lyndfeld Thomas laborer 597044 597044 Lyndfeld, Thomas, of Henfeld, laborer 1
3864072 1978167 1978167 defendant Hodge William maltman 597044 597044 Hodge, William, of Henfeld, maltman 0
3893900 1988182 1988182 defendant Edwarde Richard husbandman 597044 597044 Edwarde, Richard, of Henfeld, husbandman 3
3902500 1991067 1991067 defendant Bedyll William laborer 597044 597044 Bedyll, William, of Henfeld, laborer 1
3906282 1992390 1992390 defendant A Barrowe James chapman 597044 597044 A Barrowe, James, of Henfeld, chapman 4
3931805 2000942 2000942 defendant Peter alias George Thomas mercer 597044 597044 Peter alias George, Thomas, of Henfeld, mercer 0
3931808 2000943 2000943 defendant Randall John tailor 597044 597044 Randall, John, of Henfeld, tailor 0
3931809 2000943 2000943 defendant Bedell William husbandman 597044 597044 Bedell, William, of Henfeld, husbandman 1
3937093 2002740 2002740 defendant Peyke alias George Thomas mercer 597044 597044 Peyke alias George, Thomas, of Henfeld, mercer 1
3937096 2002741 2002741 defendant Peyke alias George Thomas mercer 597044 597044 Peyke alias George, Thomas, of Henfeld, mercer 1
3953309 2008227 2008227 defendant Mychell Roger gent 597044 597044 Mychell, Roger, of Henfeld, gent 0
3994762 2022878 2022878 defendant Coppock Richard yeoman 597044 597044 Coppock, Richard, of Henfeld, yeoman 3
4075707 2051617 2051617 defendant Michell Henry gent 597044 597044 Michell, Henry, of Henfeld, gent 0
4311076 2134023 2134023 defendant Falkenor John butcher 597044 597044 Falkenor, John, of Henfeld, butcher 3
4366934 2153223 2153223 defendant Steyninge senior yeoman 597044 597044 Steyninge, , senior, of Henfeld, yeoman 2
4371877 2155004 2155004 defendant Mercer Roger husbandman 597044 597044 Mercer, Roger, of Henfeld, husbandman 0
4379579 2157787 2157787 defendant Merser Roger yeoman 597044 597044 Merser, Roger, of henfeld, yeoman 0
4669464 2256153 2256153 defendant Wankelyn Thomas husbandman 597044 597044 Wankelyn, Thomas, of Henfeld, husbandman 2
4739066 2277309 2277309 defendant Smolt John husbandman 597044 597044 Smolt, John, of Henfeld, husbandman 4
4814484 2300638 2300638 defendant Denys Nicholas husbandman 597044 597044 Denys, Nicholas, of Henfeld, husbandman 0
4820118 2302367 2302367 defendant Walder William husbandman 597044 597044 Walder, William, of Henfeld, husbandman 2
4824004 2303583 2303583 defendant Stourode Robert laborer 597044 597044 Stourode, Robert, of Henfeld, laborer 0
4824005 2303583 2303583 defendant Burgeys Edward tanner 597044 597044 Burgeys, Edward, of Henfeld, tanner 1
4839068 2308148 2308148 defendant Goodale John butcher 597044 597044 Goodale, John, of Henfeld, butcher 0
4839069 2308148 2308148 defendant Holden Walter butcher 597044 597044 Holden, Walter, of Henfeld, butcher 1
4853653 2312560 2312560 defendant Smyth John husbandman 597044 597044 Smyth, John, of Henfeld, husbandman 3
4951559 2342444 2342444 defendant Carpenter Philip carpenter 597044 597044 Carpenter, Philip, of Henfeld, carpenter 1
4967738 2347295 2347295 defendant Daunser Robert chaplain 597044 597044 Daunser, Robert, of Henfeld, chaplain 1
4984969 2352438 2352438 defendant Holney Nicholas husbandman 597044 597044 Holney, Nicholas, of Henfeld, husbandman 0
5034933 2367075 2367075 defendant Town John husbandman or yeoman 597044 597044 Town, John, of Henfeld, husbandman or yeoman 0
5047929 2371000 2371000 defendant Dauncer Robert clerk 597044 597044 Dauncer, Robert, of Henfeld, clerk 0
5047930 2371000 2371000 defendant Holden Thomas husbandman 597044 597044 Holden, Thomas, of Henfeld, husbandman 1
5047931 2371000 2371000 defendant atte Breche John husbandman 597044 597044 atte Breche, John, of Henfeld, husbandman 2
5047932 2371000 2371000 defendant Webbe William husbandman 597044 597044 Webbe, William, of Henfeld, husbandman 3
5047933 2371000 2371000 defendant Benet Thomas husbandman 597044 597044 Benet, Thomas, of Henfeld, husbandman 4
5088362 2382970 2382970 defendant Dauncer or Auncer Robert chaplain 597044 597044 Dauncer or Auncer, Robert, of Henfeld, or of Chyltyngton, chaplain 2
5101329 2386800 2386800 defendant Estowte James husbandman 597044 597044 Estowte, James, of Henfeld, husbandman 0
5142504 2398935 2398935 defendant atte Stone Thomas butcher 597044 597044 atte Stone, Thomas, of Henfeld, butcher 0
5203986 2416915 2416915 defendant Benet Thomas husbandman 597044 597044 Benet, Thomas, of Henfeld, husbandman 3
5241387 2427675 2427675 defendant Worth Ralph yeoman 597044 597044 Worth, Ralph, of Henfeld, yeoman 0
5275017 2437773 2437773 defendant Sterman William husbandman 597044 597044 Sterman, William, of Henfeld, husbandman 0
5292875 2442910 2442910 defendant Sterman William husbandman 597044 597044 Sterman, William, of Henfeld, husbandman 0
5342569 2457876 2457876 defendant Sterman William husbandman 597044 597044 Sterman, William, of Henfeld, husbandman 0
5367150 2465372 2465372 defendant (illegible) John husbandman 597044 597044 ---, John, of Henfeld, husbandman 0
5367151 2465372 2465372 defendant Wolgare John husbandman 597044 597044 Wolgare, John, of Henfeld, husbandman 1
5367153 2465373 2465373 defendant Attwode John husbandman 597044 597044 Attwode, John, of Henfeld, husbandman 0
5367154 2465373 2465373 defendant Wolgare John husbandman 597044 597044 Wolgare, John, of Henfeld, husbandman 1
5412848 2478790 2478790 defendant Starman Henry   597044 597044 Starman, Henry, of Henfeld 0
5427848 2483282 2483282 defendant Sherman Henry laborer 597044 597044 Sherman, Henry, of Henfeld, laborer 0
5454213 2491162 2491162 defendant Sterman Henry laborer 597044 597044 Sterman, Henry, of Henfeld, laborer 0
5471246 2496336 2496336 defendant Sewall Thomas husbandman 597044 597044 Sewall, Thomas, of Henfeld, husbandman 3
5482512 2499711 2499711 defendant Sewall Thomas husbandman 597044 597044 Sewall, Thomas, of Henfeld, husbandman 3
5516246 2509918 2509918 defendant Underwode John yeoman 597044 597044 Underwode, John, of Henfeld, yeoman 1
5531134 2514253 2514253 defendant Carpenter John husbandman 597044 597044 Carpenter, John, of Henfeld, husbandman 1
5590817 2532099 2532099 defendant Tonsell Thomas clerk 597044 597044 Tonsell, Thomas, of Henfeld, clerk 0
5608582 2537583 2537583 defendant Canon John carpenter 597044 597044 Canon, John, of Henfeld, carpenter 0
5608583 2537583 2537583 defendant Estowete Nicholas weaver 597044 597044 Estowete, Nicholas, of Henfeld, weaver 1
5608584 2537583 2537583 defendant Vagger John gent 597044 597044 with Vagger, John, of Henfeld, gent 2

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