names

19 rows where case_id = 2525205

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5567997 2525205 2525205 plaintiff Ernley John     Ernley, John 0
5567998 2525205 2525205 defendant Pilkington John esq 900973 900973 Pilkington, John, of Rovyngton, Lancs, esq 0
5567999 2525205 2525205 defendant Maynwaryng John esq 900962 900962 Maynwaryng, John, of Pevir, Cheshire, esq 1
5568000 2525205 2525205 defendant Damport Ralph esq 628376 628376 Damport, Ralph, of Damport, Cheshire, esq 2
5568001 2525205 2525205 defendant Maynwaryng Hank or Haukum esq 900974 900974 Maynwaryng, Hank or Haukum, of Pevir, esq 3
5568002 2525205 2525205 defendant Musgrave Richard esq 900975 900975 Musgrave, Richard, of Hertley, Westmor, esq 4
5568003 2525205 2525205 defendant Sanford Thomas gent 900976 900976 Sanford, Thomas, of Ascombe, Westmor, gent 5
5568004 2525205 2525205 defendant Lancaster Christopher esq 652144 652144 Lancaster, Christopher, of Ascombe, esq 6
5568005 2525205 2525205 defendant Crakynthorp Edward clerk 835748 835748 Crakynthorp, Edward, of Holgyll, Westmor, clerk 7
5568006 2525205 2525205 defendant Crakenthorp Anthony gent 791119 791119 Crakenthorp, Anthony, of Holgyll, gent 8
5568007 2525205 2525205 defendant Alie John   671921 671921 Alie, John, of Bageley, Cheshire, knight 9
5568008 2525205 2525205 defendant Hothom John   626967 626967 Hothom, John, of Scorborowe, Yorks, knight 10
5568009 2525205 2525205 defendant Vyncent Guy gent 900980 900980 Vyncent, Guy, of Scorborowe, gent 11
5568010 2525205 2525205 defendant Culpeper Edward esq 900981 900981 Culpeper, Edward, of Oxmonden, Kent, esq 12
5568011 2525205 2525205 defendant Darcy Thomas Lord Darcy, of Tempull, Yorks, knight   Darcy, Thomas, Lord Darcy, of Tempull, Yorks, knight 13
5568012 2525205 2525205 defendant Huddeleston Robert gent 900982 900982 Huddeleston, Robert, of Radclyff, Stepneyth, Middx, gent 14
5568013 2525205 2525205 defendant Tresham John esq 833638 833638 Tresham, John, of Russhton, Nhants, esq 15
5568014 2525205 2525205 defendant Pilkyngton Robert gent 629193 629193 Pilkyngton, Robert, of Rovyngton, gent 16
5568015 2525205 2525205 defendant Mores John gent 821275 821275 Mores, John, of Glapthorn, Nhants, gent 17

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