names

20 rows where case_id = 2036253

✎ 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
4032441 2036253 2036253 plaintiff Garnons William gent, attorney of the bench   Garnons, William, gent, attorney of the bench 0
4032442 2036253 2036253 defendant Lewys Lewis Thomas yeoman 655905 655905 Lewys, Lewis Thomas, of Clodock, yeoman 0
4032443 2036253 2036253 defendant Morgan William yeoman 658981 658981 Morgan, William, of Longtown, yeoman 1
4032444 2036253 2036253 defendant Baye John yeoman 589505 589505 Baye, John, of Kyngeston, yeoman 2
4032445 2036253 2036253 defendant Morys Ralph yeoman 586390 586390 Morys, Ralph, of Dylwyn, yeoman 3
4032446 2036253 2036253 defendant Baylye John yeoman 586390 586390 Baylye, John, of Dylwyn, yeoman 4
4032447 2036253 2036253 defendant Morys John husbandman 586390 586390 Morys, John, of Dylwyn, husbandman 5
4032448 2036253 2036253 defendant Corren Richard yeoman 604966 604966 Corren, Richard, of Leominster, yeoman 6
4032449 2036253 2036253 defendant Rychard John yeoman 593772 593772 Rychard, John, of Kyngton, yeoman 7
4032450 2036253 2036253 defendant Scudamor John Richard yeoman 655905 655905 Scudamor, John Richard, of Clodock, yeoman 8
4032451 2036253 2036253 defendant Frewne John husbandman 616022 616022 Frewne, John, of Fuogesashe, husbandman 9
4032452 2036253 2036253 defendant Pylkyngton Richard carpenter 586208 586208 Pylkyngton, Richard, of Hereford, carpenter 10
4032453 2036253 2036253 defendant Grey John laborer 586143 586143 Grey, John, of Norton, laborer 11
4032454 2036253 2036253 defendant Jenkyn Philip yeoman 678650 678650 Jenkyn, Philip, of Peterchirche, yeoman 12
4032455 2036253 2036253 defendant ap Rosser Thomas of Grysmond Monmouth, husbandman   ap Rosser, Thomas of Grysmond, Monmouth, husbandman 13
4032456 2036253 2036253 defendant Grene Henry gent 586208 586208 Grene, Henry, of Hereford, gent 14
4032457 2036253 2036253 defendant Whytney Nicholas gent 593479 593479 Whytney, Nicholas, of Castelton, gent 15
4032458 2036253 2036253 defendant Parre Hugh clerk   Parre, Hugh, clerk, executors of 16
4032459 2036253 2036253 defendant Baylye Henry yeoman 586390 586390 ((Baylye, Henry, of Dylwyn, yeoman 17
4032460 2036253 2036253 defendant Brayne Hugh yeoman 592662 592662 Brayne, Hugh, of Letton, yeoman 18

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