names

18 rows where case_id = 2554214

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5632550 2554214 2554214 plaintiff Strickland William Bishop of Carlisle   Strickland, William, Bishop of Carlisle 0
5632551 2554214 2554214 defendant Dalstonman Adam yeoman 590660 590660 Dalstonman, Adam, of Carlisle, yeoman 0
5632552 2554214 2554214 defendant Dalstonman William yeoman 590660 590660 Dalstonman, William, of Carlisle, yeoman 1
5632553 2554214 2554214 defendant S--th John yeoman 587559 587559 S--th, John, of Bampton, yeoman 2
5632554 2554214 2554214 defendant Benette Henry yeoman 654046 654046 Benette, Henry, of Dalston, yeoman 3
5632555 2554214 2554214 defendant Withre Thomas   654046 654046 Withre, Thomas, of Dalston yeoman 4
5632556 2554214 2554214 defendant Preston John yeoman 907809 907809 Preston, John, of Glassan, yeoman 5
5632557 2554214 2554214 defendant Keswyk John yeoman 654046 654046 Keswyk, John, of Dalston, yeoman 6
5632558 2554214 2554214 defendant del Barre Geoffrey yeoman 654046 654046 together with del Barre, Geoffrey, of Dalston, yeoman 7
5632559 2554214 2554214 defendant del Gill William yeoman 759606 759606 del Gill, William, of Cargowe, yeoman 8
5632560 2554214 2554214 defendant del Barre John yeoman 907810 907810 del Barre, John, of Blakhele, yeoman 9
5632561 2554214 2554214 defendant Sharp William yeoman 590660 590660 Sharp, William, of Carlisle, yeoman 10
5632562 2554214 2554214 defendant Werman John yeoman 590660 590660 Werman, John, of Carlisle, yeoman 11
5632563 2554214 2554214 defendant Wightman Robert yeoman 769582 769582 Wightman, Robert, of Cumbresdale, yeoman 12
5632564 2554214 2554214 defendant Wightman John yeoman 769582 769582 Wightman, John, of Cumbresdale, yeoman 13
5632565 2554214 2554214 defendant Tymbere William yeoman 907811 907811 Tymbere, William, of Brounelstave, yeoman 14
5632566 2554214 2554214 defendant Straunge William yeoman 907811 907811 Straunge, William, of Brounelstave, yeoman 15
5632567 2554214 2554214 defendant Tyngate John yeoman 654046 654046 Tyngate, John, of Dalston, yeoman 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);