names

20 rows where case_id = 2091435

✎ 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
4188368 2091435 2091435 plaintiff Wallenger James principal of Thavies Inn   Wallenger, James, principal of Thavies Inn 0
4188369 2091435 2091435 defendant Kynge James gent 585869 585869 Kynge, James, of London, gent 0
4188370 2091435 2091435 defendant Sutlyff John gent 611010 611010 Sutlyff, John, of Grymesby, Lincs, gent 1
4188371 2091435 2091435 defendant Everard Ralph gent 711344 711344 Everard, Ralph, of Masheburye, Essex, gent 2
4188372 2091435 2091435 defendant Upcher Edward gent 636810 636810 Upcher, Edward, of Sutton, Cams, gent 3
4188373 2091435 2091435 defendant Paighton John gent 585869 585869 Paighton, John, of London, gent 4
4188374 2091435 2091435 defendant Hunte William gent 585869 585869 Hunte, William, of London, gent 5
4188375 2091435 2091435 defendant Prowe Robert gent 585869 585869 Prowe, Robert, of London, gent 6
4188376 2091435 2091435 defendant Minars John gent 586172 586172 Minars, John, of Hertford, gent 7
4188377 2091435 2091435 defendant Tanfield William gent 585869 585869 Tanfield, William, of London, gent 8
4188378 2091435 2091435 defendant Clarke Alban gent 585869 585869 Clarke, Alban, of London, gent 9
4188379 2091435 2091435 defendant Kynge Nicholas gent 585869 585869 Kynge, Nicholas, of London, gent 10
4188380 2091435 2091435 defendant Drought John gent 585869 585869 Drought, John, of London, gent 11
4188381 2091435 2091435 defendant Dunne Samuel gent 585869 585869 Dunne, Samuel, of London, gent 12
4188382 2091435 2091435 defendant Pechye Robert gent 589636 589636 Pechye, Robert, of Soham, Cams, gent Covell, Francis, of Pynchbecke, Cams, gent 13
4188383 2091435 2091435 defendant Johnson George gent 585869 585869 Johnson, George, of London, gent 14
4188384 2091435 2091435 defendant Ferres Julius gent 585869 585869 Ferres, Julius, of London, gent 15
4188385 2091435 2091435 defendant Woodroffe Percival gent 585869 585869 Woodroffe, Percival, of London, gent 16
4188386 2091435 2091435 defendant Ogle William gent 585869 585869 Ogle, William, of London, gent 17
4188387 2091435 2091435 defendant Evens Peter gent 585869 585869 Evens, Peter, of London, gent 18

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