names

7 rows where case_id = 2026543

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4004919 2026543 2026543 plaintiff Judde Andrew knight, of London, skinner, merchant of the staple, alderman, administrators of   Judde, Andrew, knight, of London, skinner, merchant of the staple, alderman, administrators of 0
4004920 2026543 2026543 plaintiff Smyth Thomas gent   (Smyth, Thomas, gent 1
4004921 2026543 2026543 plaintiff Smyth Alice daughter of Andrew   Alice his wife, daughter of Andrew 2
4004922 2026543 2026543 defendant Popham Alexander (legal representative) 643405 643405 Popham, Alexander, of North Petherton, Soms, gent, executors of 0
4004923 2026543 2026543 defendant Walron Humphrey esq 585869 585869 (Walron, Humphrey, of London, esq 1
4004924 2026543 2026543 defendant Stradlynge Thomas   585869 585869 together with Stradlynge, Thomas, of London, knight 2
4004925 2026543 2026543 defendant Combes Bartholomew esq 585869 585869 Combes, Bartholomew, of London, esq 3

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