names

13 rows where case_id = 2181170

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4437871 2181170 2181170 plaintiff Albold Richard     Albold, Richard 0
4437872 2181170 2181170 defendant Bysshopp John   756451 756451 Bysshopp, John, of Stoure Estovere, Dorset 0
4437873 2181170 2181170 defendant Nevyle Robert   756452 756452 Nevyle, Robert, of Fyshide, Dors 1
4437874 2181170 2181170 defendant Poterych Robert, junior     Poterych, Robert, junior 2
4437875 2181170 2181170 defendant Gyldenvere Robert     Gyldenvere, Robert 3
4437876 2181170 2181170 defendant Gildenvere John     Gildenvere, John 4
4437877 2181170 2181170 defendant Rouse Roger     Rouse, Roger 5
4437878 2181170 2181170 defendant Wylot Nicholas     Wylot, Nicholas 6
4437879 2181170 2181170 defendant Eynot John     Eynot, John 7
4437880 2181170 2181170 defendant Cave John     Cave, John 8
4437881 2181170 2181170 defendant Doudyng John     Doudyng, John 9
4437882 2181170 2181170 defendant Harpour John     Harpour, John 10
4437883 2181170 2181170 defendant Folewere Roger   756453 756453 Folewere, Roger, of Stoure of Westovere or West Stour, Dors 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);