names

15 rows where case_id = 1904329

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3630323 1904329 1904329 plaintiff Ernley John     Ernley, John 0
3630324 1904329 1904329 defendant Faryngton Henry esq 597906 597906 Faryngton, Henry, of Faryngton, Lancs, esq 0
3630325 1904329 1904329 defendant Sutton Edward Lord Dudley, knight   Sutton, Edward, Lord Dudley, knight 1
3630326 1904329 1904329 defendant Boteler Thomas   597907 597907 Boteler, Thomas, of Deansey, Lance, knight 2
3630327 1904329 1904329 defendant Aston John   800935 800935 Aston, John, of Heywode, Staffs, knight 3
3630328 1904329 1904329 defendant Morton Geoffrey gent 585869 585869 Morton, Geoffrey, of London, gent 4
3630329 1904329 1904329 defendant Fowey Thomas merchant 597909 597909 Fowey, Thomas, of Corne, Dorset, merchant 5
3630330 1904329 1904329 defendant Sintehill Robert gent 585869 585869 Sintehill, Robert, of London, gent 6
3630331 1904329 1904329 defendant Heton Richard gent 597910 597910 Heton, Richard, of Denbygh, North Wales, gent 7
3630332 1904329 1904329 defendant Specott Nicholas gent 597911 597911 Specott, Nicholas, of Thornebury, Devon, gent 8
3630333 1904329 1904329 defendant Horde Richard gent 591951 591951 Horde, Richard, of Briggenorth, Salop, gent 9
3630334 1904329 1904329 defendant Smyth William   585869 585869 Smyth, William, of London, knight 10
3630335 1904329 1904329 defendant Ughtred Anthony   597912 597912 Ughtred, Anthony, of Wyllisthorp, Yorks, knight 11
3630336 1904329 1904329 defendant Fortescu Adrian   585869 585869 Fortescu, Adrian, of London, knight 12
3630337 1904329 1904329 defendant Chamberlayn Edward gent 597913 597913 Chamberlayn, Edward, of Shirbourne, Oxon, gent 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);