names

16 rows where place_id = 731637

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4295183 2128361 2128361 defendant Wells Gilbert clerk 731637 731637 Wells, Gilbert, of Weston, Lincs, clerk 0
4357430 2149827 2149827 defendant Wolrich William yeoman 731637 731637 Wolrich, William, of Weston, Lincs, yeoman 0
4838058 2307825 2307825 defendant Wyseman Henry   731637 731637 Wyseman, Henry, of Weston, Lincs 4
4899264 2326411 2326411 defendant Paynot Richard yeoman 731637 731637 Paynot, Richard, of Weston, Lincs, yeoman 2
4908336 2329162 2329162 defendant Halmer Matilda widow 731637 731637 Halmer, Matilda, of Weston, Lincs, widow 4
4938082 2338289 2338289 defendant Paynot Robert gent 731637 731637 Paynot, Robert, of Weston, Lincs, gent 3
4953640 2343053 2343053 defendant Paynot Robert gent 731637 731637 Paynot, Robert, of Weston, Lincs, gent 2
4994480 2355216 2355216 defendant Paynot Robert yeoman 731637 731637 (Paynot, Robert, of Weston, Lincs, yeoman 1
4994488 2355217 2355217 defendant Paynot Robert yeoman 731637 731637 together with Paynot, Robert, of Weston, Lincs, yeoman 2
4998102 2356296 2356296 defendant Payne Robert yeoman 731637 731637 Payne, Robert, of Weston, Lincs, yeoman 2
4998108 2356297 2356297 defendant Paynot Robert   731637 731637 (Paynot, Robert, of Weston, Lincs 1
4999093 2356606 2356606 defendant Paynot Robert yeoman 731637 731637 (Paynot, Robert, of Weston, Lincs, yeoman 1
5178342 2409371 2409371 defendant Thorpe Richard gent 731637 731637 Thorpe, Richard, of Weston, Lincs, gent 4
5244680 2428624 2428624 defendant Halmer Richard gent 731637 731637 Halmer, Richard, of Weston, Lincs, gent 0
5245121 2428736 2428736 defendant Halmer Richard gent 731637 731637 Halmer, Richard, of Weston, Lincs, gent 9
5358110 2462601 2462601 defendant Appultoft Robert husbandman 731637 731637 Appultoft, Robert, of Weston, Lincs, husbandman 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);