names

16 rows where case_id = 1955513

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3792498 1955513 1955513 plaintiff Barker John     Barker, John 0
3792499 1955513 1955513 defendant Calton John, senior husbandman 626604 626604 Calton, John, senior, of Totley, husbandman 0
3792500 1955513 1955513 defendant Calton Thomas, senior husbandman 626604 626604 Calton, Thomas, senior, of Totley, husbandman 1
3792501 1955513 1955513 defendant Burton John husbandman 626604 626604 Burton, John, of Totley, husbandman 2
3792502 1955513 1955513 defendant Calton Humphrey husbandman 626604 626604 Calton, Humphrey, of Totley, husbandman 3
3792503 1955513 1955513 defendant Calton John husbandman 626604 626604 Calton, John, of Totley, husbandman 4
3792504 1955513 1955513 defendant Calton Thomas, junior husbandman 626604 626604 Calton, Thomas, junior, of Totley, husbandman 5
3792505 1955513 1955513 defendant Flynte William husbandman 626604 626604 Flynte, William, of Totley, husbandman 6
3792506 1955513 1955513 defendant Grene Ellen widow 626604 626604 Grene, Ellen, of Totley, widow 7
3792507 1955513 1955513 defendant Burton Elizabeth spinster 630114 630114 Burton, Elizabeth, of Doore, spinster 8
3792508 1955513 1955513 defendant Burton Margaret spinster 630114 630114 Burton, Margaret, of Doore, spinster 9
3792509 1955513 1955513 defendant Cot Cecilia widow 630114 630114 Cot, Cecilia, of Doore, widow 10
3792510 1955513 1955513 defendant Cot Joan spinster 630114 630114 Cot, Joan, of Doore, spinster 11
3792511 1955513 1955513 defendant Adamson Joan spinster 630114 630114 Adamson, Joan, of Doore, spinster 12
3792512 1955513 1955513 defendant Adamson John husbandman 630114 630114 Adamson, John, of Doore, husbandman 13
3792513 1955513 1955513 defendant Crofte William yeoman 608445 608445 Crofte, William, of Holmesfeld, yeoman 14

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