names

16 rows where case_id = 2311908

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4851477 2311908 2311908 plaintiff Upton William     Upton, William 0
4851478 2311908 2311908 defendant Beche Robert   601931 601931 Beche, Robert, of Sutton in Holand 0
4851479 2311908 2311908 defendant Forset John gent 777150 777150 Forset, John, of S_, gent 1
4851480 2311908 2311908 defendant Thakker Roger husbandman 587309 587309 Thakker, Roger, of Holbeche, husbandman 2
4851481 2311908 2311908 defendant Boste_ John husbandman 812694 812694 Boste_, John, of Wregl_, husbandman 3
4851482 2311908 2311908 defendant Osawr William   594426 594426 Osawr, William, of Benyngton 4
4851483 2311908 2311908 defendant Yoke John husbandman 587309 587309 Yoke, John, of Holbeche, husbandman 5
4851484 2311908 2311908 defendant S_ Simon     S_, Simon 6
4851485 2311908 2311908 defendant Hervy (illegible) chaplain 756733 756733 Hervy, _, of Kirketon in Holand, chaplain 7
4851486 2311908 2311908 defendant other words may be: ] Richard of Soterton   husbandman   other words may be: ] Richard of Soterton, husbandman 8
4851487 2311908 2311908 defendant Casson Lambert husbandman 589593 589593 Casson, Lambert, of Swyneshed, husbandman 9
4851488 2311908 2311908 defendant Cokeson of Marome husbandman   Cokeson, of Marome, husbandman 10
4851489 2311908 2311908 defendant Wrytell Eleanor widow 650810 650810 Wrytell, Eleanor, of High Laver, Essex, widow 11
4851490 2311908 2311908 defendant John of Essex yeoman   John, of Essex, yeoman 12
4851491 2311908 2311908 defendant Turnour Richard yeoman 783243 783243 Turnour, Richard, of Chikewell, Essex, yeoman 13
4851492 2311908 2311908 defendant Waytele Robert   608829 608829 Waytele, Robert, of Essex 14

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