names

7 rows where case_id = 2024460

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3999165 2024460 2024460 plaintiff Freman Elizabeth (legal representative) 664071 664071 Freman, Elizabeth, of High Holborne, Middx, widow, executrix of Thomas Freman, of St Andrew in Holborne, Middx, gent, attorney of the bench, executor of 0
3999166 2024460 2024460 plaintiff Fylmer Robert gent   Fylmer, Robert, gent 1
3999167 2024460 2024460 defendant Cheyney Thomas esq 665139 665139 Cheyney, Thomas, of West Woodhey, Berks, esq 0
3999168 2024460 2024460 defendant Owen William gent 585869 585869 Owen, William, of London, gent 1
3999169 2024460 2024460 defendant Cosgarne or Cosgarve John, senior gent 670871 670871 Cosgarne or Cosgarve, John, senior, of Bossedewell, Cornw, gent 2
3999170 2024460 2024460 defendant Cowell George merchant 612067 612067 Cowell, George, of Cromer, Norf, merchant 3
3999171 2024460 2024460 defendant Cooke Richard   669785 669785 Cooke, Richard, of Barnyngham, Norf, wool chapman 4

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