names

21 rows where case_id = 2024084

✎ 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
3998113 2024084 2024084 plaintiff Exilbye Miles merchant tailor 585869 585869 Exilbye, Miles, of London, merchant tailor 0
3998114 2024084 2024084 defendant Nevell Alexander gent 585869 585869 Nevell, Alexander, of London, gent 0
3998115 2024084 2024084 defendant Seyntleger John esq 682015 682015 Seyntleger, John, of Cannon Leigh, Devon, esq 1
3998116 2024084 2024084 defendant Fenner Thomas gent 585869 585869 Fenner, Thomas, of London, gent 2
3998117 2024084 2024084 defendant Peeke Edmund gent 590478 590478 Peeke, Edmund, of Sandwich, Kent, gent 3
3998118 2024084 2024084 defendant Gyslyngham Nicholas gent 585869 585869 Gyslyngham, Nicholas, of London, gent 4
3998119 2024084 2024084 defendant Brett Jerome gent 585869 585869 Brett, Jerome, of London, gent 5
3998120 2024084 2024084 defendant Cabdysh Henry gent 585869 585869 Cabdysh, Henry, of London, gent 6
3998121 2024084 2024084 defendant Wyngfeld John gent 585869 585869 Wyngfeld, John, of London, gent 7
3998122 2024084 2024084 defendant Chester Edward gent 585869 585869 Chester, Edward, of London, gent 8
3998123 2024084 2024084 defendant Wryght William gent 585869 585869 Wryght, William, of London, gent 9
3998124 2024084 2024084 defendant Whitmore of London gent   Whitmore, of London, gent 10
3998125 2024084 2024084 defendant Cotton of Sedhampton or Southampton Hants, gent   Cotton, of Sedhampton or Southampton, Hants, gent 11
3998126 2024084 2024084 defendant Snagg William gent 585869 585869 Snagg, William, of London, gent 12
3998127 2024084 2024084 defendant Snagg Robert gent 585869 585869 Snagg, Robert, of London, gent 13
3998128 2024084 2024084 defendant Mallett William gent 585869 585869 Mallett, William, of London, gent 14
3998129 2024084 2024084 defendant Hardwicke Thomas gent 585869 585869 Hardwicke, Thomas, of London, gent 15
3998130 2024084 2024084 defendant Marvyn Philip gent 585869 585869 Marvyn, Philip, of London, gent 16
3998131 2024084 2024084 defendant Bulbeck Francis gent 585869 585869 Bulbeck, Francis, of London, gent 17
3998132 2024084 2024084 defendant Nanfant William gent 585869 585869 Nanfant, William, of London, gent 18
3998133 2024084 2024084 defendant Ellys Thomas gent 585869 585869 Ellys, Thomas, of London, gent 19

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