names

18 rows where case_id = 2036252

✎ 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
4032423 2036252 2036252 plaintiff Garnons William gent, attorney of the bench   Garnons, William, gent, attorney of the bench 0
4032424 2036252 2036252 defendant Lewys Lewis Thomas yeoman 655905 655905 Lewys, Lewis Thomas, of Clodock, yeoman 0
4032425 2036252 2036252 defendant Baye John yeoman 589505 589505 Baye, John, of Kyngeston, yeoman 1
4032426 2036252 2036252 defendant Morrys Ralph yeoman 586390 586390 Morrys, Ralph, of Dylwyn, yeoman 2
4032427 2036252 2036252 defendant Baylye John husbandman 586390 586390 Baylye, John, of Dylwyn, husbandman 3
4032428 2036252 2036252 defendant Morrys John husbandman 586390 586390 Morrys, John, of Dylwyn, husbandman 4
4032429 2036252 2036252 defendant Corren Richard yeoman 604966 604966 Corren, Richard, of Leominster, yeoman 5
4032430 2036252 2036252 defendant Scudamor John Richard yeoman 655905 655905 Scudamor, John Richard, of Clodock, yeoman 6
4032431 2036252 2036252 defendant Frewne John husbandman 616022 616022 Frewne, John, of Fuogesashe, husbandman 7
4032432 2036252 2036252 defendant Pylkyngton Richard of Hereford, carpenter   Pylkyngton, Richard,, of Hereford, carpenter 8
4032433 2036252 2036252 defendant Grey John laborer 586143 586143 Grey, John, of Norton, laborer 9
4032434 2036252 2036252 defendant Jenkyn Philip yeoman 601480 601480 Jenkyn, Philip, of Peterchurche, yeoman 10
4032435 2036252 2036252 defendant ap Rosser Thomas husbandman 678649 678649 ap Rosser, Thomas, of Grysmond, Monmouth, husbandman 11
4032436 2036252 2036252 defendant Grene Henry gent 586208 586208 Grene, Henry, of Hereford, gent 12
4032437 2036252 2036252 defendant Whytney Nicholas gent 663045 663045 Whytney, Nicholas, of Castleton, gent 13
4032438 2036252 2036252 defendant Parre Hugh clerk   Parre, Hugh, clerk, executors of 14
4032439 2036252 2036252 defendant Baylye Henry yeoman 587494 587494 (Baylye, Henry, of Webley, yeoman 15
4032440 2036252 2036252 defendant Brayne Hugh yeoman 592662 592662 Brayne, Hugh, of Letton, yeoman 16

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