names

34 rows where case_id = 2386566

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5100433 2386566 2386566 plaintiff Yonge Thomas     Yonge, Thomas 0
5100434 2386566 2386566 defendant Turnour Richard clerk 606703 606703 Turnour, Richard, of Upton on Severn, Worcs, clerk 0
5100435 2386566 2386566 defendant Grove Nicholas husbandman 613341 613341 Grove, Nicholas, of Upton on Severn, husbandman 1
5100436 2386566 2386566 defendant Symondes William husbandman 613341 613341 Symondes, William, of Upton on Severn, husbandman 2
5100437 2386566 2386566 defendant Baker Geoffrey baker 613341 613341 Baker, Geoffrey, of Upton on Severn, baker 3
5100438 2386566 2386566 defendant Emson William husbandman 613341 613341 Emson, William, of Upton on Severn, husbandman 4
5100439 2386566 2386566 defendant Heyward John laborer 613341 613341 Heyward, John, of Upton on Severn, laborer 5
5100440 2386566 2386566 defendant Grygge William fisher 613341 613341 Grygge, William, of Upton on Severn, fisher 6
5100441 2386566 2386566 defendant Dekyn Thomas husbandman 613341 613341 Dekyn, Thomas, of Upton on Severn, husbandman 7
5100442 2386566 2386566 defendant Pakker Geoffrey husbandman 613341 613341 Pakker, Geoffrey, of Upton on Severn, husbandman 8
5100443 2386566 2386566 defendant Smyth John smith 613341 613341 Smyth, John, of Upton on Severn, smith 9
5100444 2386566 2386566 defendant Drewe John butcher 613341 613341 Drewe, John, of Upton on Severn, butcher 10
5100445 2386566 2386566 defendant Pynnok John butcher 613341 613341 Pynnok, John, of Upton on Severn, butcher 11
5100446 2386566 2386566 defendant Cokkys Nicholas butcher 613341 613341 Cokkys, Nicholas, of Upton on Severn, butcher 12
5100447 2386566 2386566 defendant Carpenter John carpenter 613341 613341 Carpenter, John, of Upton on Severn, carpenter 13
5100448 2386566 2386566 defendant Batte William husbandman 613341 613341 Batte, William, of Upton on Severn, husbandman 14
5100449 2386566 2386566 defendant Paccheford John cordwainer 613341 613341 Paccheford, John, of Upton on Severn, cordwainer 15
5100450 2386566 2386566 defendant Poule John cordwainer 613341 613341 Poule, John, of Upton on Severn, cordwainer 16
5100451 2386566 2386566 defendant Kynges John husbandman 613341 613341 Kynges, John, of Upton on Severn, husbandman 17
5100452 2386566 2386566 defendant Yeman John weaver 613341 613341 Yeman, John, of Upton on Severn, weaver 18
5100453 2386566 2386566 defendant Berkley John yeoman 613341 613341 Berkley, John, of Upton on Severn, yeoman 19
5100454 2386566 2386566 defendant Berkley William husbandman 613341 613341 Berkley, William, of Upton on Severn, husbandman 20
5100455 2386566 2386566 defendant Pyncher John husbandman 613341 613341 Pyncher, John, of Upton on Severn, husbandman 21
5100456 2386566 2386566 defendant Pyncher William husbandman 613341 613341 Pyncher, William, of Upton on Severn, husbandman 22
5100457 2386566 2386566 defendant Cokkes Thomas husbandman 613341 613341 Cokkes, Thomas, of Upton on Severn, husbandman 23
5100458 2386566 2386566 defendant Payn Thomas husbandman 613341 613341 Payn, Thomas, of Upton on Severn, husbandman 24
5100459 2386566 2386566 defendant Felde Walter husbandman 613341 613341 Felde, Walter, of Upton on Severn, husbandman 25
5100460 2386566 2386566 defendant Broughton William fisher 613341 613341 Broughton, William, of Upton on Severn, fisher 26
5100461 2386566 2386566 defendant Grayell Nicholas husbandman 613341 613341 Grayell, Nicholas, of Upton on Severn, husbandman 27
5100462 2386566 2386566 defendant Turnour John yeoman 613341 613341 Turnour, John, of Upton on Severn, yeoman 28
5100463 2386566 2386566 defendant Racche Thomas laborer 613341 613341 Racche, Thomas, of Upton on Severn, laborer 29
5100464 2386566 2386566 defendant Racche John tailor 613341 613341 Racche, John, of Upton on Severn, tailor 30
5100465 2386566 2386566 defendant Mody John husbandman 613341 613341 Mody, John, of Upton on Severn, husbandman 31
5100466 2386566 2386566 defendant Underwode Richard yeoman 613341 613341 Underwode, Richard, of Upton on Severn, yeoman 32

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