names

18 rows where case_id = 2242871

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4638780 2242871 2242871 plaintiff Chedder Richard     Chedder, Richard 0
4638781 2242871 2242871 defendant Mountfort William   602298 602298 Mountfort, William, of Bridport 0
4638782 2242871 2242871 defendant Hayward William   602298 602298 Hayward, William, of Bridport 1
4638783 2242871 2242871 defendant Gybbes Adam     Gybbes, Adam 2
4638784 2242871 2242871 defendant Broun Roger     Broun, Roger 3
4638785 2242871 2242871 defendant Stykelane Roger     Stykelane, Roger 4
4638786 2242871 2242871 defendant Stamp John     Stamp, John 5
4638787 2242871 2242871 defendant (illegible) John     _, John 6
4638788 2242871 2242871 defendant Gracy William     Gracy, William 7
4638789 2242871 2242871 defendant Draper Gilbert   735611 735611 togther with Draper, Gilbert, of Brydport 8
4638790 2242871 2242871 defendant Pury John     Pury, John 9
4638791 2242871 2242871 defendant Mey William     Mey, William 10
4638792 2242871 2242871 defendant Syfrewast Walter     Syfrewast, Walter 11
4638793 2242871 2242871 defendant Atte Forde Simon     Atte Forde, Simon 12
4638794 2242871 2242871 defendant Palmere John     Palmere, John 13
4638795 2242871 2242871 defendant Stalbrigge John     Stalbrigge, John 14
4638796 2242871 2242871 defendant Bal Wiliam     Bal, Wiliam 15
4638797 2242871 2242871 defendant Maudyt John     Maudyt, John 16

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