names

17 rows where case_id = 2022302

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3993154 2022302 2022302 plaintiff Carpenter Thomas attorney of the bench   Carpenter, Thomas, attorney of the bench 0
3993155 2022302 2022302 defendant Gwatkyn John James gent 659038 659038 Gwatkyn, John James, of Bergevenny, Monmouth, gent 0
3993156 2022302 2022302 defendant Jones John esq 659783 659783 Jones, John, of Treowen, Monmouth, esq 1
3993157 2022302 2022302 defendant Morgan George gent 669422 669422 Morgan, George, of Pentricke, Monmouth, gent 2
3993158 2022302 2022302 defendant ap John Thomas David yeoman 668012 668012 ap John, Thomas David, of Llannarth, Monmouth, yeoman 3
3993159 2022302 2022302 defendant Gybons John gent 586208 586208 Gybons, John, of Hereford, gent 4
3993160 2022302 2022302 defendant Reynold Jenkin gent 669423 669423 Reynold, Jenkin, of Magorm Monmouth, gent 5
3993161 2022302 2022302 defendant Parker Richard gent 668257 668257 Parker, Richard, of Llanlowell, Monmouth, gent 6
3993162 2022302 2022302 defendant Thomas alias Reynold James gent 669424 669424 Thomas alias Reynold, James, of Llanlowell, gent 7
3993163 2022302 2022302 defendant Rosser Philip yeoman 669425 669425 Rosser, Philip, of Llangome, Monmouth, yeoman 8
3993164 2022302 2022302 defendant Fludd David John chapman 585925 585925 Fludd, David John, of Bristol, chapman 9
3993165 2022302 2022302 defendant Morgan John yeoman 657218 657218 Morgan, John, of Llantrissen, Monmouth, yeoman 10
3993166 2022302 2022302 defendant ap Jevan Roger   669426 669426 ap Jevan, Roger, of Llangowen, Monmouth 11
3993167 2022302 2022302 defendant Buck Anthony, senior gent 669427 669427 Buck, Anthony, senior, of Pulton, Glos, gent 12
3993168 2022302 2022302 defendant Arney John (legal representative)   Arney, John, executors of 13
3993169 2022302 2022302 defendant Gente Robert gent 669428 669428 (Gente, Robert, of Waston, Monmouth, gent 14
3993170 2022302 2022302 defendant Kettynge John gent 669429 669429 Kettynge, John, of Nasshe, Monmouth, 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);