names

13 rows where case_id = 2439214

✎ 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
5279967 2439214 2439214 plaintiff Bughey Robert     Bughey, Robert 0
5279968 2439214 2439214 defendant Fyton Edward gent 868039 868039 Fyton, Edward, of Ganesworth, Cheshire, gent 0
5279969 2439214 2439214 defendant Bidyll John gent 868040 868040 Bidyll, John, of Bidyll, Staffs, gent 1
5279970 2439214 2439214 defendant Rope Lawrence gent 720542 720542 Rope, Lawrence, of Sapley, Cheshire, gent 2
5279971 2439214 2439214 defendant Damporte Roger gent 868041 868041 Damporte, Roger, of Ganeswirth, gent 3
5279972 2439214 2439214 defendant Smalwode Geofrey yeoman 868042 868042 Smalwode, Geofrey, of Ganesworth, yeoman 4
5279973 2439214 2439214 defendant Alcok James yeoman 868042 868042 Alcok, James, of Ganesworth, yeoman 5
5279974 2439214 2439214 defendant Plant Thomas husbandman 868043 868043 Plant, Thomas, of Derliston, husbandman 6
5279975 2439214 2439214 defendant Alcok William yeoman 625432 625432 Alcok, William, of Riston, yeoman 7
5279976 2439214 2439214 defendant Higgombotham Richard husbandman 868043 868043 Higgombotham, Richard, of Derliston, husbandman 8
5279977 2439214 2439214 defendant Couper John husbandman 589444 589444 Couper, John, of Annesley, husbandman 9
5279978 2439214 2439214 defendant Bromley John yeoman 596473 596473 Bromley, John, of Whitmore, yeoman 10
5279979 2439214 2439214 defendant Tournour William yeoman 592854 592854 Tournour, William, of Chaldon, yeoman 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);