names

37 rows where place_id = 760938

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4474637 2192731 2192731 defendant Herberd Robert   760938 760938 Herberd, Robert, of Fornesete 1
4489387 2197401 2197401 defendant Houlet Robert   760938 760938 Houlet, Robert, of Fornesete 0
4517839 2205966 2205966 defendant Thaxtere Thomas   760938 760938 Thaxtere, Thomas, of Fornesete 2
4575286 2223785 2223785 defendant Baxtere Robert   760938 760938 Baxtere, Robert, of Fornesete 2
4599219 2230969 2230969 plaintiff Stokkere William clerk 760938 760938 Stokkere, William, of Fornesete, clerk 0
4599222 2230969 2230969 defendant Sergeant Robert   760938 760938 Sergeant, Robert, of Fornesete 2
4599223 2230969 2230969 defendant Whitfot Adam   760938 760938 Whitfot, Adam, of Fornesete 3
4614997 2235703 2235703 defendant Skilman John   760938 760938 Skilman, John, of Fornesete 1
4627554 2239550 2239550 plaintiff Rolliston Robert   760938 760938 Rolliston, Robert, of Fornesete, parson 0
4672326 2256993 2256993 defendant Baxter Robert yeoman 760938 760938 Baxter, Robert, of Fornesete, yeoman 4
4684831 2260856 2260856 defendant (illegible) Robert yeoman 760938 760938 ---, Robert, of Fornesete, yeoman 2
4699116 2265188 2265188 defendant Baxter Robert yeoman 760938 760938 Baxter, Robert, of Fornesete, yeoman 1
4724898 2273080 2273080 defendant Floraunce William husbandman 760938 760938 Floraunce, William, of Fornesete, husbandman 1
4724900 2273080 2273080 defendant Reyngger John husbandman 760938 760938 Reyngger, John, of Fornesete, husbandman 3
4730437 2274714 2274714 defendant Lounde Richard tanner 760938 760938 Lounde, Richard, of Fornesete, tanner 3
4733441 2275634 2275634 defendant Harrald Andrew weaver 760938 760938 Harrald, Andrew, of Fornesete, weaver 2
4740098 2277622 2277622 defendant Baxster Robert husbandman 760938 760938 Baxster, Robert, of Fornesete, husbandman 0
4744877 2279018 2279018 defendant Florance William yeoman 760938 760938 Florance, William, of Fornesete, yeoman 0
4744879 2279018 2279018 defendant Rynger John yeoman 760938 760938 Rynger, John, of Fornesete, yeoman 2
4747411 2279746 2279746 defendant Blount Roger clerk 760938 760938 Blount, Roger, of Fornesete, clerk 0
4750495 2280628 2280628 defendant Baxstere Robert yeoman 760938 760938 Baxstere, Robert, of Fornesete, yeoman 1
4755228 2282023 2282023 defendant Baxster Robert yeoman 760938 760938 Baxster, Robert, of Fornesete, yeoman 2
4766882 2285632 2285632 defendant Stokere William husbandman 760938 760938 Stokere, William, of Fornesete, husbandman 0
4809534 2299150 2299150 defendant Sergeaunt Robert yeoman 760938 760938 Sergeaunt, Robert, of Fornesete, yeoman 0
4809538 2299150 2299150 defendant Stokkere William yeoman 760938 760938 Stokkere, William, of Fornesete, yeoman 4
4857396 2313701 2313701 defendant Wolsy Robert husbandman 760938 760938 Wolsy, Robert, of Fornesete, husbandman 0
4857401 2313702 2313702 defendant Wolsy Robert husbandman 760938 760938 Wolsy, Robert, of Fornesete, husbandman 0
4998998 2356582 2356582 plaintiff Kyrton John   760938 760938 Kyrton, John, of Fornesete 0
5022207 2363388 2363388 defendant Rynger John, senior husbandman 760938 760938 Rynger, John, senior, of Fornesete, husbandman 0
5059496 2374410 2374410 defendant Patteshull Thomas clerk 760938 760938 Patteshull, Thomas, of Fornesete, clerk 0
5067937 2376908 2376908 plaintiff Patteshull Thomas clerk 760938 760938 Patteshull, Thomas, of Fornesete, clerk 0
5071364 2377929 2377929 defendant Werden William yeoman 760938 760938 Werden, William, of Fornesete, yeoman 2
5251241 2430491 2430491 defendant Verdon William yeoman 760938 760938 Verdon, William, of Fornesete, yeoman 0
5268604 2435937 2435937 defendant Reede Robert tailor 760938 760938 (Reede, Robert, of Fornesete, tailor 1
5268605 2435937 2435937 defendant Verdon Robert chaplain 760938 760938 Verdon, Robert, of Fornesete, chaplain 2
5278915 2438946 2438946 defendant Verdon William (legal representative) 760938 760938 Verdon, William, of Fornesete, butcher, executor of 0
5278916 2438946 2438946 defendant Verdon Robert chaplain 760938 760938 Verdon, Robert, of Fornesete, chaplain 1

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