names

23 rows where place_id = 843438

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5075723 2379241 2379241 defendant Payne Michael husbandman 843438 843438 Payne, Michael, of Norton Beauchamp, husbandman 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
5227143 2423585 2423585 defendant Mower Henry, junior tanner 843438 843438 Mower, Henry, junior, of Norton Beauchamp, tanner 7
5227150 2423585 2423585 defendant Payn Michael tailor 843438 843438 Payn, Michael, of Norton Beauchamp, tailor 14
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
5227158 2423585 2423585 defendant of Pantry William yeoman 843438 843438 of Pantry, William, of Norton Beauchamp, yeoman 22
5227163 2423585 2423585 defendant Payn Thomas tailor 843438 843438 Payn, Thomas, of Norton Beauchamp, tailor 27
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
5227172 2423586 2423586 defendant Mower Henry, junior tanner 843438 843438 Mower, Henry, junior, of Norton Beauchamp, tanner 7
5227179 2423586 2423586 defendant Payn Michael tailor 843438 843438 Payn, Michael, of Norton Beauchamp, tailor 14
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
5227187 2423586 2423586 defendant of Pantry William yeoman 843438 843438 of Pantry, William, of Norton Beauchamp, yeoman 22
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);