names

15 rows where place_id = 622634

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3668434 1916080 1916080 plaintiff Asty Thomas (legal representative) 622634 622634 Asty, Thomas, of Tytsale, clerk, executors of 0
3748129 1941341 1941341 defendant Goodram Henry husbandman 622634 622634 Goodram, Henry, of Tytsale, husbandman 0
3957696 2009750 2009750 defendant Tower Robert husbandman 622634 622634 Tower, Robert, of Tytsale, husbandman 0
4087770 2055919 2055919 defendant Bulletonte Richard carpenter 622634 622634 Bulletonte, Richard, of Tytsale, carpenter 0
4146709 2077002 2077002 defendant Carter James husbandman 622634 622634 Carter, James, of Tytsale, husbandman 0
4648332 2245569 2245569 defendant Waye William   622634 622634 Waye, William, of Tytsale 3
4648333 2245569 2245569 defendant Banyard Thomas   622634 622634 Banyard, Thomas, of Tytsale 4
4648334 2245569 2245569 defendant Banyard John   622634 622634 Banyard, John, of Tytsale 5
5391582 2472663 2472663 defendant Dole Richard husbandman 622634 622634 Dole, Richard, of Tytsale, husbandman 2
5450303 2489975 2489975 defendant Dole Richard husbandman 622634 622634 Dole, Richard, of Tytsale, husbandman 0
5559064 2522610 2522610 defendant None John smith 622634 622634 None, John, of Tytsale, smith 4
5586276 2530750 2530750 defendant Laughter Agnes widow 622634 622634 Laughter, Agnes, of Tytsale, widow 0
5586277 2530750 2530750 defendant Laughter Robert tailor 622634 622634 Laughter, Robert, of Tytsale, tailor 1
5586278 2530750 2530750 defendant Laughter John, junior laborer 622634 622634 Laughter, John, junior, of Tytsale, laborer 2
5586279 2530750 2530750 defendant Laughter Katherine spinster 622634 622634 Laughter, Katherine, of Tytsale, spinster 3

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