names

12 rows where case_id = 2452983

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5326401 2452983 2452983 plaintiff Stevenson Philip     Stevenson, Philip 0
5326402 2452983 2452983 defendant Denmark John barber 585869 585869 Denmark, John, of London, barber 0
5326403 2452983 2452983 defendant Fox Thomas draper 585869 585869 Fox, Thomas, of London, draper 1
5326404 2452983 2452983 defendant Flete John parson of Parva Bukham   Flete, John, parson of Parva Bukham 2
5326405 2452983 2452983 defendant Harpar John yeoman 585990 585990 Harpar, John, of Banbury, Oxon, yeoman 3
5326406 2452983 2452983 defendant Messenger Thomas husbandman 588254 588254 Messenger, Thomas, of Est Pekham, Kent, husbandman 4
5326407 2452983 2452983 defendant Steres Alice widow 585869 585869 Steres, Alice, of London, widow 5
5326408 2452983 2452983 defendant (not given) John vicar of Ellyrgyll 873708 873708 Ellyrgyll, John, of Paward, Cumber, vicar of Anstaplith, Cumber 6
5326409 2452983 2452983 defendant Boddefeld Robert maltman 586058 586058 Boddefeld, Robert, of Enfeld, Middx, maltman 7
5326410 2452983 2452983 defendant Burre John tanner 589772 589772 Burre, John, of Barkyng, Essex, tanner 8
5326411 2452983 2452983 defendant Toby John skinner 585869 585869 Toby, John, of London, skinner 9
5326412 2452983 2452983 defendant Freman Stephen mercer 585869 585869 Freman, Stephen, of London, mercer 10

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