names

17 rows where case_id = 2515708

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5535804 2515708 2515708 plaintiff Broun Humphrey     Broun, Humphrey 0
5535805 2515708 2515708 plaintiff Hardyng Nicholas     Hardyng, Nicholas 1
5535806 2515708 2515708 plaintiff Spencer John     Spencer, John 2
5535807 2515708 2515708 defendant Mordaunt John   608374 608374 Mordaunt, John, of Turvey 0
5535808 2515708 2515708 defendant Mordaunt William   590610 590610 Mordaunt, William, of Hempsted 1
5535809 2515708 2515708 defendant Broun Wistan     Broun, Wistan 2
5535810 2515708 2515708 defendant Gascoign William     Gascoign, William 3
5535811 2515708 2515708 defendant Vynter John     Vynter, John 4
5535812 2515708 2515708 defendant Heron Thomas     Heron, Thomas 5
5535813 2515708 2515708 defendant Sewester William     Sewester, William 6
5535814 2515708 2515708 defendant Hasilden Hugh     Hasilden, Hugh 7
5535815 2515708 2515708 defendant Morecote Roger     Morecote, Roger 8
5535816 2515708 2515708 defendant Laurence John     Laurence, John 9
5535817 2515708 2515708 defendant Peryn John     Peryn, John 10
5535818 2515708 2515708 defendant Ball John     Ball, John 11
5535819 2515708 2515708 defendant Turpeny Gilbert     Turpeny, Gilbert 12
5535820 2515708 2515708 defendant Skevyngton John     Skevyngton, John 13

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