names

12 rows where case_id = 2302055

✎ 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
4819101 2302055 2302055 plaintiff Peche Thomas     Peche, Thomas 0
4819102 2302055 2302055 defendant Postgayte Robert husbandman 807204 807204 Postgayte, Robert, of Uglardby, husbandman 0
4819103 2302055 2302055 defendant Postgayte William husbandman 807204 807204 Postgayte, William, of Uglardby, husbandman 1
4819104 2302055 2302055 defendant Couper Roger husbandman 807204 807204 Couper, Roger, of Uglardby, husbandman 2
4819105 2302055 2302055 defendant Chapman John husbandman 807204 807204 Chapman, John, of Uglardby, husbandman 3
4819106 2302055 2302055 defendant Hagate William husbandman 807205 807205 Hagate, William, of Cropton in Pykeryng Lyth, husbandman 4
4819107 2302055 2302055 defendant Persyson Richard husbandman 626203 626203 Persyson, Richard, of Cropton, husbandman 5
4819108 2302055 2302055 defendant Robynson John husbandman 626203 626203 Robynson, John, of Cropton, husbandman 6
4819109 2302055 2302055 defendant Dykson William husbandman 626203 626203 Dykson, William, of Cropton, husbandman 7
4819110 2302055 2302055 defendant Dogesson William husbandman 626203 626203 Dogesson, William, of Cropton, husbandman 8
4819111 2302055 2302055 defendant Webster John weaver 784874 784874 Webster, John, of Medilton, weaver 9
4819112 2302055 2302055 defendant Litster Adam husbandman 807204 807204 Litster, Adam, of Uglardby, husbandman 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);