names

13 rows where case_id = 2346569

✎ 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
4965383 2346569 2346569 plaintiff Crakanthorp Margaret widow of Crakanthorp, William   Crakanthorp, Margaret, widow of Crakanthorp, William 0
4965384 2346569 2346569 defendant Burcy John smith 821240 821240 Burcy, John, of Tempil Soureby, smith 0
4965385 2346569 2346569 defendant Cartemale Thomas husbandman 821240 821240 Cartemale, Thomas, of Tempil Soureby, husbandman 1
4965386 2346569 2346569 defendant Stabyll John yeoman 821240 821240 Stabyll, John, of Tempil Soureby, yeoman 2
4965387 2346569 2346569 defendant Meburn Thomas yeoman 821240 821240 Meburn, Thomas, of Tempil Soureby, yeoman 3
4965388 2346569 2346569 defendant Wilson John yeoman 821240 821240 Wilson, John, of Tempil Soureby, yeoman 4
4965389 2346569 2346569 defendant Jonson William husbandman 821240 821240 Jonson, William, of Tempil Soureby, husbandman 5
4965390 2346569 2346569 defendant Soureby Richard tailor 821240 821240 Soureby, Richard, of Tempil Soureby, tailor 6
4965391 2346569 2346569 defendant Soureby William yeoman 821240 821240 Soureby, William, of Tempil Soureby, yeoman 7
4965392 2346569 2346569 defendant Soureby Thomas   821240 821240 Soureby, Thomas, of Tempil Soureby, wright 8
4965393 2346569 2346569 defendant Soureby John yeoman 821240 821240 Soureby, John, of Tempil Soureby, yeoman 9
4965394 2346569 2346569 defendant Hall Richard   821240 821240 Hall, Richard, of Tempil Soureby, franklin 10
4965395 2346569 2346569 defendant Gayll William husbandman 821240 821240 Gayll, William, of Tempil Soureby, husbandman 11

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