names

6 rows where case_id = 2201443

✎ 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
4502762 2201443 2201443 plaintiff Nevyll Alesia or Alice (legal representative) 764050 764050 Nevyll, Alesia or Alice, of Nerford or Narford, Lady Nevill, formerly wife of John de Nevyll, executors of 0
4502763 2201443 2201443 plaintiff Borgh William de   585869 585869 (Borgh, William de, of London, parson of St Christopher's church 1
4502764 2201443 2201443 plaintiff Spice Clement     Spice, Clement 2
4502765 2201443 2201443 plaintiff Aleyn John   761261 761261 Aleyn, John, of Doxford 3
4502766 2201443 2201443 defendant Herd John   762850 762850 Herd, John, of Great Totham 0
4502767 2201443 2201443 defendant Wellys John   764051 764051 Wellys, John, of Wetherefeld 1

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