names

23 rows where case_id = 2521856

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5556385 2521856 2521856 plaintiff Lovell Thomas knight   Lovell, Thomas, knight 0
5556386 2521856 2521856 defendant Cavell or Canell Richard merchant of the staple 586383 586383 Cavell or Canell, Richard, of Stamford, Lincs, merchant of the staple 0
5556387 2521856 2521856 defendant Storke John merchant of the staple 621323 621323 Storke, John, of Selby, Yorks, merchant of the staple 1
5556388 2521856 2521856 defendant Walweyn Roger     Walweyn, Roger 2
5556389 2521856 2521856 defendant Andrewes Richard     Andrewes, Richard 3
5556390 2521856 2521856 defendant Hulton William     Hulton, William 4
5556391 2521856 2521856 defendant Ede John     Ede, John 5
5556392 2521856 2521856 defendant Heron John     Heron, John 6
5556393 2521856 2521856 defendant Mason Thomas     Mason, Thomas 7
5556394 2521856 2521856 defendant Messyndyn John     Messyndyn, John 8
5556395 2521856 2521856 defendant Vycars William     Vycars, William 9
5556396 2521856 2521856 defendant Sherard Thomas     Sherard, Thomas 10
5556397 2521856 2521856 defendant Sherard William     Sherard, William 11
5556398 2521856 2521856 defendant Husse Robert     Husse, Robert 12
5556399 2521856 2521856 defendant Penyngton Adam     Penyngton, Adam 13
5556400 2521856 2521856 defendant Basset William     Basset, William 14
5556401 2521856 2521856 defendant Ascough Christopher     Ascough, Christopher 15
5556402 2521856 2521856 defendant Gylpyn Richard     Gylpyn, Richard 16
5556403 2521856 2521856 defendant Troughton Robert     Troughton, Robert 17
5556404 2521856 2521856 defendant Ascough Roger     Ascough, Roger 18
5556405 2521856 2521856 defendant Ascough Thomas     Ascough, Thomas 19
5556406 2521856 2521856 defendant Savell John     Savell, John 20
5556407 2521856 2521856 defendant Calverley William     Calverley, William 21

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