names

4 rows where case_id = 2459496

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5347929 2459496 2459496 plaintiff Bolley or Boweley Henry servant of Noreys, William, of Grombrigge, Kent, gent   Bolley or Boweley, Henry, servant of Noreys, William, of Grombrigge, Kent, gent, executors of 0
5347930 2459496 2459496 plaintiff Fenwyk John gent   (Fenwyk, John, gent 1
5347931 2459496 2459496 plaintiff Hakwell John tailor 585869 585869 Hakwell, John, of London, tailor 2
5347932 2459496 2459496 defendant Radmyld William esq 835161 835161 Radmyld, William, of Bradwater, Sussex, esq 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);