names

17 rows where case_id = 2429134

✎ 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
5246478 2429134 2429134 plaintiff Saynton John     Saynton, John 0
5246479 2429134 2429134 defendant Carter John laborer 624751 624751 Carter, John, of Aram, laborer 0
5246480 2429134 2429134 defendant Trygge John laborer 845718 845718 Trygge, John, of Arham, laborer 1
5246481 2429134 2429134 defendant Barbour John   863764 863764 Barbour, John, of Northgate juxta Newerk, cook 2
5246482 2429134 2429134 defendant Yates John, senior husbandman 863765 863765 Yates, John, senior, of Ferymarnham, husbandman 3
5246483 2429134 2429134 defendant Edynburgh Henry yeoman 612266 612266 Edynburgh, Henry, of Blythe, yeoman 4
5246484 2429134 2429134 defendant Gabbe John yeoman 593657 593657 Gabbe, John, of Blithe, yeoman 5
5246485 2429134 2429134 defendant Carter Robert o Wyrksop, chaplain   Carter, Robert, o Wyrksop, chaplain 6
5246486 2429134 2429134 defendant Halle John husbandman 648093 648093 Halle, John, of Marnham, husbandman 7
5246487 2429134 2429134 defendant Godeman Gilbert ferryman 863765 863765 Godeman, Gilbert, of Ferymarnham, ferryman 8
5246488 2429134 2429134 defendant Whynell John   595541 595541 Whynell, John, of Ossyngton, wright 9
5246489 2429134 2429134 defendant Lamley John husbandman 597418 597418 Lamley, John, of Calverton, husbandman 10
5246490 2429134 2429134 defendant Taillour William yeoman 789181 789181 Taillour, William, of Mapulbek, yeoman 11
5246491 2429134 2429134 defendant Antyn John   595541 595541 Antyn, John, of Ossyngton, wright 12
5246492 2429134 2429134 defendant Horne Elizabeth widow 590061 590061 Horne, Elizabeth, of Barton, widow 13
5246493 2429134 2429134 defendant Moresby Richard gent 585869 585869 Moresby, Richard, of London, gent 14
5246494 2429134 2429134 defendant Calcote Richard gent 585869 585869 Calcote, Richard, of London, gent 15

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