names

20 rows where case_id = 2353501

✎ 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
4988412 2353501 2353501 plaintiff Boynton Christopher     Boynton, Christopher 0
4988413 2353501 2353501 defendant Wyghtman John husbandman 758367 758367 Wyghtman, John, of Landmote, husbandman 0
4988414 2353501 2353501 defendant Lynehous Peter husbandman 774211 774211 Lynehous, Peter, of Acclom, husbandman 1
4988415 2353501 2353501 defendant Rassh William husbandman 801894 801894 Rassh, William, of Wilton in Cleveland, husbandman 2
4988416 2353501 2353501 defendant Marsshall John yeoman 587028 587028 Marsshall, John, of Whitby, yeoman 3
4988417 2353501 2353501 defendant Marsshall Robert   587028 587028 Marsshall, Robert, of Whitby, yeoman, son of John 4
4988418 2353501 2353501 defendant Wade Thomas husbandman 589744 589744 Wade, Thomas, of Thormondby, husbandman 5
4988419 2353501 2353501 defendant Golyn Henry yeoman 593823 593823 Golyn, Henry, of Bernyngham, yeoman 6
4988420 2353501 2353501 defendant Pert William jun, of Thormondby, husbandman   Pert, William, jun, of Thormondby, husbandman 7
4988421 2353501 2353501 defendant Stalyman John   763132 763132 Stalyman, John, of Stokton on Tees, ferry man 8
4988422 2353501 2353501 defendant Thormondy Robert fishmonger 597744 597744 Thormondy, Robert, of Thormonby, fishmonger 9
4988423 2353501 2353501 defendant Prestman John husbandman 590061 590061 Prestman, John, of Barton, husbandman 10
4988424 2353501 2353501 defendant Spicer William spicer 592378 592378 Spicer, William, of Yarom, spicer 11
4988425 2353501 2353501 defendant Swaldale Richard husbandman 762571 762571 Swaldale, Richard, of Cateryk, husbandman 12
4988426 2353501 2353501 defendant Webster John weaver 757558 757558 Webster, John, of Yarum, weaver 13
4988427 2353501 2353501 defendant Cokhey John husbandman 799902 799902 Cokhey, John, of Semer, in Cleveland, husbandman 14
4988428 2353501 2353501 defendant Pech Thomas tailor 831205 831205 Pech, Thomas, of Ryg in Ronceby, tailor 15
4988429 2353501 2353501 defendant Grene Thomas gent 758367 758367 together with Grene, Thomas, of Landmote, gent 16
4988430 2353501 2353501 defendant Thormondby Robert   589744 589744 Thormondby, Robert, of Thormondby, franklin 17
4988431 2353501 2353501 defendant Wharrom Thomas   807601 807601 Wharrom, Thomas, of Leventhorp, parish clerk 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);