names

15 rows where case_id = 1908647

✎ 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
3644319 1908647 1908647 plaintiff Ernley John     Ernley, John 0
3644320 1908647 1908647 defendant Champion Lawrence abbot of Battle Abbey   Champion, Lawrence, abbot of Battle Abbey 0
3644321 1908647 1908647 defendant Willoughby Robert Lord Broke, of Devon, knight   Willoughby, Robert, Lord Broke, of Devon, knight 1
3644322 1908647 1908647 defendant Holford George   601209 601209 Holford, George, of Lathom, Lancs, knight 2
3644323 1908647 1908647 defendant Ravenyscrofte Ralph esq 601210 601210 Ravenyscrofte, Ralph, of Bretton, Cheshire, esq 3
3644324 1908647 1908647 defendant Hopwode John     Hopwode, John 4
3644325 1908647 1908647 defendant Laversage Thomas     Laversage, Thomas 5
3644326 1908647 1908647 defendant (not given)   abbot of Langley Abbey   Langley Abbey, abbot of 6
3644327 1908647 1908647 defendant Stephynson Edward     Stephynson, Edward 7
3644328 1908647 1908647 defendant Skevyngton William     Skevyngton, William 8
3644329 1908647 1908647 defendant Skevyngton Thomas abbot of Beaulieu Abbey   Skevyngton, Thomas, abbot of Beaulieu Abbey 9
3644330 1908647 1908647 defendant Fortescue Adrian     Fortescue, Adrian 10
3644331 1908647 1908647 defendant Tay Thomas     Tay, Thomas 11
3644332 1908647 1908647 defendant Gresham Richard     Gresham, Richard 12
3644333 1908647 1908647 defendant Barkeley James     Barkeley, James 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);