names

16 rows where case_id = 2198812

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4493990 2198812 2198812 plaintiff (not given)   Abbess of Berkyng   Berkyng, Abbess of 0
4493991 2198812 2198812 defendant Grenelef William   606671 606671 Grenelef, William, of Peldon 0
4493992 2198812 2198812 defendant Knott William   606671 606671 Knott, William, of Peldon 1
4493993 2198812 2198812 defendant Shepherd John   606671 606671 Shepherd, John, of Peldon 2
4493994 2198812 2198812 defendant Hammond Thomas   606671 606671 Hammond, Thomas, of Peldon 3
4493995 2198812 2198812 defendant Hammond John     Hammond, John 4
4493996 2198812 2198812 defendant Hayward Thomas   606671 606671 Hayward, Thomas, of Peldon 5
4493997 2198812 2198812 defendant Tibneam John   606671 606671 Tibneam, John, of Peldon 6
4493998 2198812 2198812 defendant Tigneam Walter   606671 606671 Tigneam, Walter, of Peldon 7
4493999 2198812 2198812 defendant Stefenes John   757035 757035 Stefenes, John, of West Merseye 8
4494000 2198812 2198812 defendant Stephenes Richard   757035 757035 Stephenes, Richard, of West Merseye 9
4494001 2198812 2198812 defendant Pod John   757035 757035 Pod, John, of West Merseye 10
4494002 2198812 2198812 defendant Balent John   757035 757035 Balent, John, of West Merseye 11
4494003 2198812 2198812 defendant Martell Richard   757035 757035 Martell, Richard, of West Merseye 12
4494004 2198812 2198812 defendant Busshe Richard   757035 757035 Busshe, Richard, of West Merseye 13
4494005 2198812 2198812 defendant Cook John   763078 763078 Cook, John, of East Merseye 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);