names

29 rows where case_id = 2423585

✎ 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
5227135 2423585 2423585 plaintiff Talbot Joan Lady Lysle   Talbot, Joan, Lady Lysle 0
5227136 2423585 2423585 defendant Gamage Thomas esq 843438 843438 Gamage, Thomas, of Norton Beauchamp, esq 0
5227137 2423585 2423585 defendant Gamage William ap Morgan esq 843438 843438 Gamage, William ap Morgan, of Norton Beauchamp, esq 1
5227138 2423585 2423585 defendant Gamage William gent 843438 843438 Gamage, William, of Norton Beauchamp, gent 2
5227139 2423585 2423585 defendant ap Roger Thomas gent 843438 843438 ap Roger, Thomas, of Norton Beauchamp, gent 3
5227140 2423585 2423585 defendant Carpynter William yeoman 843438 843438 Carpynter, William, of Norton Beauchamp, yeoman 4
5227141 2423585 2423585 defendant Glasyer David   586748 586748 Glasyer, David, of Welles, court holder 5
5227142 2423585 2423585 defendant Mower Henry, senior tanner 623082 623082 Mower, Henry, senior, of Stoke Gyfford, tanner 6
5227143 2423585 2423585 defendant Mower Henry, junior tanner 843438 843438 Mower, Henry, junior, of Norton Beauchamp, tanner 7
5227144 2423585 2423585 defendant Treheron David yeoman 590061 590061 Treheron, David, of Barton, yeoman 8
5227145 2423585 2423585 defendant Dyryke John laborer 638361 638361 Dyryke, John, of Worle, laborer 9
5227146 2423585 2423585 defendant Neulond Thomas husbandman 638361 638361 Neulond, Thomas, of Worle, husbandman 10
5227147 2423585 2423585 defendant Dee Jenin weaver 616756 616756 Dee, Jenin, of Uphill, weaver 11
5227148 2423585 2423585 defendant Banewell John hosteler 616756 616756 Banewell, John, of Uphill, hosteler 12
5227149 2423585 2423585 defendant Hayne John tucker 588034 588034 Hayne, John, of Axbrigge, tucker 13
5227150 2423585 2423585 defendant Payn Michael tailor 843438 843438 Payn, Michael, of Norton Beauchamp, tailor 14
5227151 2423585 2423585 defendant Twytte Thomas husbandman 733426 733426 Twytte, Thomas, of Kewstoke, husbandman 15
5227152 2423585 2423585 defendant Mannyng Walter laborer 756657 756657 Mannyng, Walter, of Banewell, laborer 16
5227153 2423585 2423585 defendant Lewes David yeoman 861553 861553 Lewes, David, of Stoke Curry, yeoman 17
5227154 2423585 2423585 defendant Jones William tailor 594708 594708 Jones, William, of Wryngton, tailor 18
5227155 2423585 2423585 defendant ap Procer Robert yeoman 843438 843438 ap Procer, Robert, of Norton Beauchamp, yeoman 19
5227156 2423585 2423585 defendant Walssheman David chaplain 843438 843438 Walssheman, David, of Norton Beauchamp, chaplain 20
5227157 2423585 2423585 defendant Virgo Philip   638361 638361 Virgo, Philip, of Worle, mason 21
5227158 2423585 2423585 defendant of Pantry William yeoman 843438 843438 of Pantry, William, of Norton Beauchamp, yeoman 22
5227159 2423585 2423585 defendant ap Jankyn John yeoman 593476 593476 ap Jankyn, John, of Portebury, yeoman 23
5227160 2423585 2423585 defendant Porter John yeoman 593476 593476 Porter, John, of Portebury, yeoman 24
5227161 2423585 2423585 defendant Marchall William yeoman 589052 589052 Marchall, William, of Clopton, yeoman 25
5227162 2423585 2423585 defendant Haukyns John yeoman 589052 589052 Haukyns, John, of Clopton, yeoman 26
5227163 2423585 2423585 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);