names

23 rows where case_id = 2466059

✎ 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
5369517 2466059 2466059 plaintiff Ferrers Martin     Ferrers, Martin 0
5369518 2466059 2466059 defendant Shelley John     Shelley, John 0
5369519 2466059 2466059 defendant Plowfeld William scrivenor   Plowfeld, William, scrivenor 1
5369520 2466059 2466059 defendant Middilton Nicholas     Middilton, Nicholas 2
5369521 2466059 2466059 defendant Colwich William     Colwich, William 3
5369522 2466059 2466059 defendant Paston Edmund     Paston, Edmund 4
5369523 2466059 2466059 defendant Lustede William     Lustede, William 5
5369524 2466059 2466059 defendant Haynes Richard gent 604018 604018 Haynes, Richard, of Colchester, Essex, gent 6
5369525 2466059 2466059 defendant Spice Humphrey     Spice, Humphrey 7
5369526 2466059 2466059 defendant Barton William gent 604131 604131 Barton, William, of Winchester, Hants, gent 8
5369527 2466059 2466059 defendant Dynne William     Dynne, William 9
5369528 2466059 2466059 defendant Forde Lawrence     Forde, Lawrence 10
5369529 2466059 2466059 defendant Fetiplace Anthony     Fetiplace, Anthony 11
5369530 2466059 2466059 defendant Aissheford John     Aissheford, John 12
5369531 2466059 2466059 defendant Gage Roger     Gage, Roger 13
5369532 2466059 2466059 defendant Mikelfeld Robert     Mikelfeld, Robert 14
5369533 2466059 2466059 defendant Derby John gent 604018 604018 Derby, John, of Colchester, Essex, gent 15
5369534 2466059 2466059 defendant Thirlond Thomas     Thirlond, Thomas 16
5369535 2466059 2466059 defendant Leylond John     Leylond, John 17
5369536 2466059 2466059 defendant Bagges John     Bagges, John 18
5369537 2466059 2466059 defendant Lathom John gent 654876 654876 Lathom, John, of Southampton, Hants, gent 19
5369538 2466059 2466059 defendant Burgyn John clerk 588081 588081 Burgyn, John, of Cambridge, clerk 20
5369539 2466059 2466059 defendant default is: of London   gent   default is: of London, gent 21

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