names

20 rows where case_id = 2471490

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5387477 2471490 2471490 plaintiff Ferrers Martin     Ferrers, Martin 0
5387478 2471490 2471490 defendant Shelley John gent 585869 585869 Shelley, John, of London, gent 0
5387479 2471490 2471490 defendant Plowefeld William   653439 653439 Plowefeld, William, of London, scrivenor 1
5387480 2471490 2471490 defendant Middelton Nicholas gent 585869 585869 Middelton, Nicholas, of London, gent 2
5387481 2471490 2471490 defendant Gerves John gent 585869 585869 Gerves, John, of London, gent 3
5387482 2471490 2471490 defendant Manfeld Robert gent 585869 585869 Manfeld, Robert, of London, gent 4
5387483 2471490 2471490 defendant Paston Edmund gent 585869 585869 Paston, Edmund, of London, gent 5
5387484 2471490 2471490 defendant Lynford William gent 585869 585869 Lynford, William, of London, gent 6
5387485 2471490 2471490 defendant Haynes Richard gent 604018 604018 Haynes, Richard, of Colchester, Essex, gent 7
5387486 2471490 2471490 defendant Spyte Humphrey gent 585869 585869 Spyte, Humphrey, of London, gent 8
5387487 2471490 2471490 defendant Barton William gent 604131 604131 Barton, William, of Winchester, Hants, gent 9
5387488 2471490 2471490 defendant Don William gent 585869 585869 Don, William, of London, gent 10
5387489 2471490 2471490 defendant Forde Lawrence gent 585869 585869 Forde, Lawrence, of London, gent 11
5387490 2471490 2471490 defendant Fetiplace Anthony gent 585869 585869 Fetiplace, Anthony, of London, gent 12
5387491 2471490 2471490 defendant Eape Roger gent 585869 585869 Eape, Roger, of London, gent 13
5387492 2471490 2471490 defendant Mikesfeld Robert gent 585869 585869 Mikesfeld, Robert, of London, gent 14
5387493 2471490 2471490 defendant Derby John gent 881582 881582 Derby, John, of Colchester, Esses, gent 15
5387494 2471490 2471490 defendant Brygham William gent 585869 585869 Brygham, William, of London, gent 16
5387495 2471490 2471490 defendant Dagges John gent 585869 585869 Dagges, John, of London, gent 17
5387496 2471490 2471490 defendant Lathom John gent 586254 586254 Lathom, John, of Southampton, 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);