names

11 rows where place_id = 625458

✎ 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
3692865 1923967 1923967 plaintiff le Strange John (legal representative) 625458 625458 le Strange, John, of Parva Massyngham, esq, executors of 0
3692869 1923968 1923968 plaintiff le Straunge John (legal representative) 625458 625458 le Straunge, John, of Parva Massyngham, esq, executors of 0
3692874 1923969 1923969 plaintiff le Straunge John (legal representative) 625458 625458 le Straunge, John, of Parva Massyngham, esq, son of le Staunge, Henry, executors of 0
3721370 1932992 1932992 plaintiff Lestrange John (legal representative) 625458 625458 Lestrange, John, of Parva Massyngham, esq, son of Lestrange, Henry, executors of 0
3764344 1946511 1946511 defendant Bastard James clerk 625458 625458 Bastard, James, of Parva Massyngham, clerk 1
3764851 1946673 1946673 defendant Anger or Auger William husbandman 625458 625458 Anger or Auger, William, of Parva Massyngham, husbandman 0
3977358 2016650 2016650 defendant Skaulpye Robert carpenter 625458 625458 Skaulpye, Robert, of Parva Massyngham, carpenter 1
4111404 2064324 2064324 defendant Wylchyn John   625458 625458 Wylchyn, John, of Parva Massyngham, shepherd 1
4205151 2097348 2097348 defendant Anderson John husbandman 625458 625458 (Anderson, John, of Parva Massyngham, husbandman 1
4952651 2342750 2342750 defendant Chelmyssey William laborer 625458 625458 Chelmyssey, William, of Parva Massyngham, laborer 0
5085856 2382258 2382258 defendant Gayton John chaplain 625458 625458 Gayton, John, of Parva Massyngham, chaplain 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);