names

10 rows where case_id = 2201220

✎ 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
4501994 2201220 2201220 plaintiff Marston Richard     Marston, Richard 0
4501995 2201220 2201220 defendant Mirsyn or Mirfyn John     Mirsyn or Mirfyn, John 0
4501996 2201220 2201220 defendant Loveles John     Loveles, John 1
4501997 2201220 2201220 defendant Normanby John   590152 590152 Normanby, John, of Clyfton, parson 2
4501998 2201220 2201220 defendant Gamelston Simon de     Gamelston, Simon de 3
4501999 2201220 2201220 defendant Daucue or Dancue Adam   593727 593727 Daucue or Dancue, Adam, of Codnore 4
4502000 2201220 2201220 defendant Payntour John     Payntour, John 5
4502001 2201220 2201220 defendant Breuster Robert   601376 601376 Breuster, Robert, of Lenton 6
4502002 2201220 2201220 defendant Sengre William     Sengre, William 7
4502003 2201220 2201220 defendant Webster Richard   763953 763953 Webster, Richard, of Kymmemrley, parson 8

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