names

22 rows where case_id = 2487938

✎ 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
5443382 2487938 2487938 plaintiff Buxton Robert     Buxton, Robert, on his own account 0
5443383 2487938 2487938 defendant Penem_ John husbandman   Penem_, John, husbandman 0
5443384 2487938 2487938 defendant Soty Gregory baker 586134 586134 Soty, Gregory, of Ipswich, baker 1
5443385 2487938 2487938 defendant (illegible) Thomas laborer 586134 586134 _, Thomas, of Ipswich, laborer 2
5443386 2487938 2487938 defendant Taverner John husbandman 634335 634335 Taverner, John,of Freeston, husbandman 3
5443387 2487938 2487938 defendant (illegible) John tailor 767615 767615 _, John, of Braham, tailor 4
5443388 2487938 2487938 defendant Brightwell Robert   590415 590415 Brightwell, Robert, of Mildenhale 5
5443389 2487938 2487938 defendant Copynger Richard husbandman 590415 590415 Copynger, Richard, of Mildenhale, husbandman 6
5443390 2487938 2487938 defendant Fryss_ William yeoman   Fryss_, William, yeoman 7
5443391 2487938 2487938 defendant Furmage Henry   674509 674509 Furmage, Henry, of Stradbrook 8
5443392 2487938 2487938 defendant (illegible) of Mendelsham widow   _, of Mendelsham, widow 9
5443393 2487938 2487938 defendant Kent John     Kent, John 10
5443394 2487938 2487938 defendant Praty (illegible) smith 587550 587550 Praty, _, of Eye, smith 11
5443395 2487938 2487938 defendant Dryver John     Dryver, John 12
5443396 2487938 2487938 defendant Wale Henry     Wale, Henry 13
5443397 2487938 2487938 defendant Haton Thomas yeoman 593914 593914 Haton, Thomas, of Hygham, yeoman 14
5443398 2487938 2487938 defendant (illegible) Thomas laborer   _, Thomas, laborer 15
5443399 2487938 2487938 defendant Podde Robert yeoman 592979 592979 Podde, Robert, of Tatyngston, yeoman 16
5443400 2487938 2487938 defendant Feltewell John   586134 586134 Feltewell, John, of Ipswich 17
5443401 2487938 2487938 defendant (illegible) of Combes yeoman   _, of Combes, yeoman 18
5443402 2487938 2487938 defendant Arnold William   623710 623710 Arnold, William, of Lalford 19
5443403 2487938 2487938 defendant Suffolk (illegible) butcher 604018 604018 Suffolk, _, of Colchester, Essex, butcher 20

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