names

45 rows where place_id = 599282

✎ 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
3636097 1906081 1906081 defendant Tarrant Thomas yeoman 599282 599282 Tarrant, Thomas, of Enford, yeoman 0
3814785 1962537 1962537 defendant Reve John husbandman 599282 599282 Reve, John, of Enford, husbandman 1
3814786 1962537 1962537 defendant Chifferell William husbandman 599282 599282 Chifferell, William, of Enford, husbandman 2
3814787 1962537 1962537 defendant Cheverell John husbandman 599282 599282 Cheverell, John, of Enford, husbandman 3
3814788 1962537 1962537 defendant Rolffe William husbandman 599282 599282 Rolffe, William, of Enford, husbandman 4
3814791 1962538 1962538 defendant Reve John husbandman 599282 599282 Reve, John, of Enford, husbandman 1
3814792 1962538 1962538 defendant Chifferell William husbandman 599282 599282 Chifferell, William, of Enford, husbandman 2
3814793 1962538 1962538 defendant Cheverell John husbandman 599282 599282 Cheverell, John, of Enford, husbandman 3
3814794 1962538 1962538 defendant Rolffe William husbandman 599282 599282 Rolffe, William, of Enford, husbandman 4
3964756 2012279 2012279 defendant Mawton Thomas yeoman 599282 599282 Mawton, Thomas, of Enford, yeoman 0
3972957 2015114 2015114 defendant Maton Thomas yeoman 599282 599282 Maton, Thomas, of Enford, yeoman 0
4040640 2039148 2039148 defendant Maton Thomas yeoman 599282 599282 Maton, Thomas, of Enford, yeoman 0
4040642 2039149 2039149 defendant Maton Thomas yeoman 599282 599282 Maton, Thomas, of Enford, yeoman 0
4185249 2090350 2090350 defendant Yate Richard gent 599282 599282 Yate, Richard, of Enford, gent 0
4226362 2104694 2104694 defendant Rolfe Agnes spinster 599282 599282 together with Rolfe, Agnes, of Enford, spinster 1
4253749 2114247 2114247 defendant Rolfe Simon husbandman 599282 599282 Rolfe, Simon, of Enford, husbandman 0
4275016 2121215 2121215 defendant Longman Rombold yeoman 599282 599282 Longman, Rombold, of Enford, yeoman 0
4444100 2183130 2183130 defendant Crouchere John   599282 599282 Crouchere, John, of Enford 0
4444102 2183131 2183131 defendant Crouchere John   599282 599282 Crouchere, John, of Enford 0
4465839 2189984 2189984 defendant Horn Thomas butcher 599282 599282 Horn, Thomas, of Enford, butcher 1
4492073 2198213 2198213 plaintiff Wyllys John   599282 599282 Wyllys, John, of Enford 0
4492080 2198213 2198213 defendant Smyth Henry   599282 599282 Smyth, Henry, of Enford 6
4519553 2206476 2206476 defendant Hempere John   599282 599282 Hempere, John, of Enford 0
4563439 2220137 2220137 defendant Gernon Richard   599282 599282 Gernon, Richard, of Enford 1
4563440 2220137 2220137 defendant Brokman John   599282 599282 Brokman, John, of Enford 2
4598506 2230768 2230768 defendant Graunt John   599282 599282 (Graunt, John, of Enford, vicar 1
4633668 2241379 2241379 defendant West Richard   599282 599282 West, Richard, of Enford 0
4670717 2256521 2256521 defendant Gorvays Walter husbandman 599282 599282 Gorvays, Walter, of Enford, husbandman 0
4759097 2283193 2283193 defendant Waterman John husbandman 599282 599282 Waterman, John, of Enford, husbandman 0
4781199 2290131 2290131 defendant Waterman John husbandman 599282 599282 Waterman, John, of Enford, husbandman 0
4821518 2302816 2302816 defendant Rycheman Thomas   599282 599282 Rycheman, Thomas, of Enford, shepherd 0
4832936 2306320 2306320 defendant Waterman John husbandman 599282 599282 Waterman, John, of Enford, husbandman 0
4859816 2314440 2314440 defendant Waterman John husbandman 599282 599282 Waterman, John, of Enford, husbandman 0
4904353 2327979 2327979 defendant Hacker Henry husbandman 599282 599282 Hacker, Henry, of Enford, husbandman 1
4974020 2349192 2349192 plaintiff Man Richard   599282 599282 Man, Richard, of Enford 0
5135995 2397039 2397039 defendant Plovell William   599282 599282 Plovell, William, of Enford 0
5192556 2413556 2413556 defendant Gerull Thomas husbandman 599282 599282 Gerull, Thomas, of Enford, husbandman 0
5301487 2445400 2445400 defendant Westley John chaplain 599282 599282 Westley, John, of Enford, chaplain 0
5336643 2456027 2456027 defendant Smyth William smith 599282 599282 Smyth, William, of Enford, smith 2
5337546 2456302 2456302 defendant Haukyn Thomas chaplain 599282 599282 Haukyn, Thomas, of Enford, chaplain 0
5337547 2456302 2456302 defendant Nete Nicholas husbandman 599282 599282 Nete, Nicholas, of Enford, husbandman 1
5371785 2466763 2466763 defendant Wylkys alias Hunte William husbandman 599282 599282 Wylkys alias Hunte, William, of Enford, husbandman 0
5483768 2500092 2500092 defendant Tarrant Thomas yeoman 599282 599282 Tarrant, Thomas, of Enford, yeoman 0
5585940 2530655 2530655 defendant Tarraunt Thomas, senior husbandman 599282 599282 Tarraunt, Thomas, senior, of Enford, husbandman 0
5634413 2554758 2554758 defendant Lytelcote Richard   599282 599282 Lytelcote, Richard, of Enford 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);