names

8 rows where case_id = 2261690

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4687522 2261690 2261690 plaintiff Storme William (legal representative)   Storme, William, executors of 0
4687523 2261690 2261690 plaintiff Paget John     (Paget, John 1
4687524 2261690 2261690 plaintiff Brand Adam     Brand, Adam 2
4687525 2261690 2261690 plaintiff Brand Cecily formerly wife of Testator   Cecily, his wife, formerly wife of Testator 3
4687526 2261690 2261690 defendant Bolle John yeoman 764029 764029 Bolle, John, of Sesaltre or Seasalter, yeoman 0
4687527 2261690 2261690 defendant Prest Thomas laborer 784525 784525 Prest, Thomas, of Herbaldoune or Harbledown, laborer 1
4687528 2261690 2261690 defendant Crotcheoll John tanner 760356 760356 Crotcheoll, John, of Canterbury Westgate, tanner 2
4687529 2261690 2261690 defendant Hill Robert carpenter 784526 784526 Hill, Robert, of Chertham or Chartham, carpenter 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);