names

36 rows where case_id = 2386567

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
5100467 2386567 2386567 plaintiff Yonge Thomas     Yonge, Thomas 0
5100468 2386567 2386567 defendant Turnour Richard clerk 606703 606703 Turnour, Richard, of Upton on Severn, Worcs, clerk 0
5100469 2386567 2386567 defendant Grove Nicholas husbandman 613341 613341 Grove, Nicholas, of Upton on Severn, husbandman 1
5100470 2386567 2386567 defendant Symondes William husbandman 613341 613341 Symondes, William, of Upton on Severn, husbandman 2
5100471 2386567 2386567 defendant Baker Geoffrey baker 613341 613341 Baker, Geoffrey, of Upton on Severn, baker 3
5100472 2386567 2386567 defendant Emson William husbandman 613341 613341 Emson, William, of Upton on Severn, husbandman 4
5100473 2386567 2386567 defendant Heyward John laborer 613341 613341 Heyward, John, of Upton on Severn, laborer 5
5100474 2386567 2386567 defendant Grygge William fisher 613341 613341 Grygge, William, of Upton on Severn, fisher 6
5100475 2386567 2386567 defendant Dekyn Thomas husbandman 613341 613341 Dekyn, Thomas, of Upton on Severn, husbandman 7
5100476 2386567 2386567 defendant Pakker Geoffrey husbandman 613341 613341 Pakker, Geoffrey, of Upton on Severn, husbandman 8
5100477 2386567 2386567 defendant Smyth John smith 613341 613341 Smyth, John, of Upton on Severn, smith 9
5100478 2386567 2386567 defendant Drewe John butcher 613341 613341 Drewe, John, of Upton on Severn, butcher 10
5100479 2386567 2386567 defendant Pynnok John butcher 613341 613341 Pynnok, John, of Upton on Severn, butcher 11
5100480 2386567 2386567 defendant Cokkys Nicholas butcher 613341 613341 Cokkys, Nicholas, of Upton on Severn, butcher 12
5100481 2386567 2386567 defendant Carpenter John carpenter 613341 613341 Carpenter, John, of Upton on Severn, carpenter 13
5100482 2386567 2386567 defendant Batte William husbandman 613341 613341 Batte, William, of Upton on Severn, husbandman 14
5100483 2386567 2386567 defendant Paccheford John cordwainer 613341 613341 Paccheford, John, of Upton on Severn, cordwainer 15
5100484 2386567 2386567 defendant Poule John cordwainer 613341 613341 Poule, John, of Upton on Severn, cordwainer 16
5100485 2386567 2386567 defendant Kynges John husbandman 613341 613341 Kynges, John, of Upton on Severn, husbandman 17
5100486 2386567 2386567 defendant Yeman John waver 613341 613341 Yeman, John, of Upton on Severn, waver 18
5100487 2386567 2386567 defendant Berkley John yeoman 613341 613341 Berkley, John, of Upton on Severn, yeoman 19
5100488 2386567 2386567 defendant Berkley William husbandman 613341 613341 Berkley, William, of Upton on Severn, husbandman 20
5100489 2386567 2386567 defendant Pyncher John husbandman 613341 613341 Pyncher, John, of Upton on Severn, husbandman 21
5100490 2386567 2386567 defendant Pyncher William husbandman 613341 613341 Pyncher, William, of Upton on Severn, husbandman 22
5100491 2386567 2386567 defendant Cokkes Thomas husbandman 613341 613341 Cokkes, Thomas, of Upton on Severn, husbandman 23
5100492 2386567 2386567 defendant Payn Thomas husbandman 613341 613341 Payn, Thomas, of Upton on Severn, husbandman 24
5100493 2386567 2386567 defendant Felde Walter husbandman 613341 613341 Felde, Walter, of Upton on Severn, husbandman 25
5100494 2386567 2386567 defendant Pynnok Richard yeoman 613341 613341 Pynnok, Richard, of Upton on Severn, yeoman 26
5100495 2386567 2386567 defendant Ormes William husbandman 613341 613341 Ormes, William, of Upton on Severn, husbandman 27
5100496 2386567 2386567 defendant Broughton William fisher 613341 613341 Broughton, William, of Upton on Severn, fisher 28
5100497 2386567 2386567 defendant Grayell Nicholas husbandman 613341 613341 Grayell, Nicholas, of Upton on Severn, husbandman 29
5100498 2386567 2386567 defendant Turnour John yeoman 613341 613341 Turnour, John, of Upton on Severn, yeoman 30
5100499 2386567 2386567 defendant Racche Thomas laborer 613341 613341 Racche, Thomas, of Upton on Severn, laborer 31
5100500 2386567 2386567 defendant Racche John tailor 613341 613341 Racche, John, of Upton on Severn, tailor 32
5100501 2386567 2386567 defendant Mody John husbandman 613341 613341 Mody, John, of Upton on Severn, husbandman 33
5100502 2386567 2386567 defendant Underwode Richard yeoman 613341 613341 Underwode, Richard, of Upton on Severn, yeoman 34

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