names

18 rows where place_id = 672293

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4005078 2026602 2026602 defendant Conyers Leonard gent 672293 672293 Conyers, Leonard, of Whitbye, gent 1
4007299 2027391 2027391 defendant Wyclyffe Christopher gent 672293 672293 Wyclyffe, Christopher, of Whitbye, gent 1
4088598 2056225 2056225 defendant Constable Marmaduke gent 672293 672293 (Constable, Marmaduke, of Whitbye, gent 1
4088603 2056226 2056226 defendant Constable Marmaduke gent 672293 672293 (Constable, Marmaduke, of Whitbye, gent 1
4142217 2075455 2075455 defendant Howe Robert yeoman 672293 672293 Howe, Robert, of Whitbye, yeoman 4
4167699 2084193 2084193 defendant Howe Robert yeoman 672293 672293 Howe, Robert, of Whitbye, yeoman 4
4168219 2084372 2084372 defendant Wilson Mathew merchant 672293 672293 Wilson, Mathew, of Whitbye, merchant 1
4168220 2084372 2084372 defendant Wilson Marmaduke merchant 672293 672293 Wilson, Marmaduke, of Whitbye, merchant 2
4171439 2085474 2085474 defendant Dutton Ruchard gent 672293 672293 Dutton, Ruchard, of Whitbye, gent 0
4185561 2090455 2090455 defendant Annyson Gregory merchant 672293 672293 Annyson, Gregory, of Whitbye, merchant 0
4222864 2103486 2103486 defendant Pudsey Ambrose gent 672293 672293 Pudsey, Ambrose, of Whitbye, gent 2
4254101 2114368 2114368 defendant Dicconson Robert yeoman 672293 672293 Dicconson, Robert, of Whitbye, yeoman 3
4254166 2114386 2114386 defendant Dicconson Robert yeoman 672293 672293 Dicconson, Robert, of Whitbye, yeoman 3
4262491 2117118 2117118 defendant Pudsey Ambrose gent 672293 672293 Pudsey, Ambrose, of Whitbye, gent 2
4323438 2138257 2138257 defendant Paskett Christopher tanner 672293 672293 Paskett, Christopher, of Whitbye, tanner 0
4390601 2161472 2161472 defendant Boys George yeoman 672293 672293 Boys, George, of Whitbye, yeoman 1
4401600 2165132 2165132 defendant Boys George yeoman 672293 672293 Boys, George, of Whitbye, yeoman 3
4411659 2168496 2168496 defendant Constable Elizabeth widow 672293 672293 Constable, Elizabeth, of Whitbye, widow 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);