names

29 rows where case_id = 2423586

✎ 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
5227164 2423586 2423586 plaintiff Talbot Joan Lady Lysle   Talbot, Joan, Lady Lysle 0
5227165 2423586 2423586 defendant Gamage Thomas esq 843438 843438 Gamage, Thomas, of Norton Beauchamp, esq 0
5227166 2423586 2423586 defendant Gamage William ap Morgan esq 843438 843438 Gamage, William ap Morgan, of Norton Beauchamp, esq 1
5227167 2423586 2423586 defendant Gamage William gent 843438 843438 Gamage, William, of Norton Beauchamp, gent 2
5227168 2423586 2423586 defendant ap Roger Thomas gent 843438 843438 ap Roger, Thomas, of Norton Beauchamp, gent 3
5227169 2423586 2423586 defendant Carpynter William yeoman 843438 843438 Carpynter, William, of Norton Beauchamp, yeoman 4
5227170 2423586 2423586 defendant Glasyer David   586748 586748 Glasyer, David, of Welles, court holder 5
5227171 2423586 2423586 defendant Mower Henry, senior tanner 623082 623082 Mower, Henry, senior, of Stoke Gyfford, tanner 6
5227172 2423586 2423586 defendant Mower Henry, junior tanner 843438 843438 Mower, Henry, junior, of Norton Beauchamp, tanner 7
5227173 2423586 2423586 defendant Treheron David yeoman 590061 590061 Treheron, David, of Barton, yeoman 8
5227174 2423586 2423586 defendant Dyryke John laborer 638361 638361 Dyryke, John, of Worle, laborer 9
5227175 2423586 2423586 defendant Neulond Thomas husbandman 638361 638361 Neulond, Thomas, of Worle, husbandman 10
5227176 2423586 2423586 defendant Dee Jenin weaver 616756 616756 Dee, Jenin, of Uphill, weaver 11
5227177 2423586 2423586 defendant Banewell John hosteler 616756 616756 Banewell, John, of Uphill, hosteler 12
5227178 2423586 2423586 defendant Hayne John tucker 588034 588034 Hayne, John, of Axbrigge, tucker 13
5227179 2423586 2423586 defendant Payn Michael tailor 843438 843438 Payn, Michael, of Norton Beauchamp, tailor 14
5227180 2423586 2423586 defendant Twytte Thomas husbandman 733426 733426 Twytte, Thomas, of Kewstoke, husbandman 15
5227181 2423586 2423586 defendant Mannyng Walter laborer 756657 756657 Mannyng, Walter, of Banewell, laborer 16
5227182 2423586 2423586 defendant Lewes David yeoman 861553 861553 Lewes, David, of Stoke Curry, yeoman 17
5227183 2423586 2423586 defendant Jones William tailor 594708 594708 Jones, William, of Wryngton, tailor 18
5227184 2423586 2423586 defendant ap Procer Robert yeoman 843438 843438 ap Procer, Robert, of Norton Beauchamp, yeoman 19
5227185 2423586 2423586 defendant Walssheman David chaplain 843438 843438 Walssheman, David, of Norton Beauchamp, chaplain 20
5227186 2423586 2423586 defendant Virgo Philip   638361 638361 Virgo, Philip, of Worle, mason 21
5227187 2423586 2423586 defendant of Pantry William yeoman 843438 843438 of Pantry, William, of Norton Beauchamp, yeoman 22
5227188 2423586 2423586 defendant ap Jankyn John yeoman 593476 593476 ap Jankyn, John, of Portebury, yeoman 23
5227189 2423586 2423586 defendant Porter John yeoman 593476 593476 Porter, John, of Portebury, yeoman 24
5227190 2423586 2423586 defendant Marchall William yeoman 589052 589052 Marchall, William, of Clopton, yeoman 25
5227191 2423586 2423586 defendant Haukyns John yeoman 589052 589052 Haukyns, John, of Clopton, yeoman 26
5227192 2423586 2423586 defendant Payn Thomas tailor 843438 843438 Payn, Thomas, of Norton Beauchamp, tailor 27

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