names

20 rows where case_id = 2353499

✎ 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
4988390 2353499 2353499 plaintiff Boynton Christopher     Boynton, Christopher 0
4988391 2353499 2353499 defendant Grene Thomas gent 758367 758367 Grene, Thomas, of Landmote, gent 0
4988392 2353499 2353499 defendant Thormondby Robert   589744 589744 together with Thormondby, Robert, of Thormondby, franklin 1
4988393 2353499 2353499 defendant Wharrom Thomas   807601 807601 Wharrom, Thomas, of Leventhorp, parish clerk 2
4988394 2353499 2353499 defendant Wightman John husbandman 758367 758367 Wightman, John, of Landmote, husbandman 3
4988395 2353499 2353499 defendant Lynehous Peter husbandman 831198 831198 Lynehous, Peter, of Accolom, husbandman 4
4988396 2353499 2353499 defendant Rassh William husbandman 801894 801894 Rassh, William, of Wilton in Cleveland, husbandman 5
4988397 2353499 2353499 defendant Marsshall John yeoman 587028 587028 Marsshall, John, of Whitby, yeoman 6
4988398 2353499 2353499 defendant Marsshal Robert son of John, of Whitby, yeoman   Marsshal, Robert, son of John, of Whitby, yeoman 7
4988399 2353499 2353499 defendant Wade Thomas husbandman 831199 831199 Wade, Thomas, of Tthormondby, husbandman 8
4988400 2353499 2353499 defendant Colyn Henry yeoman 591737 591737 Colyn, Henry, of Birmingham, yeoman 9
4988401 2353499 2353499 defendant Pert William jun, of Thormondby, husbandman   Pert, William, jun, of Thormondby, husbandman 10
4988402 2353499 2353499 defendant Stalyman John ferryman 831200 831200 Stalyman, John, of Stockton on Tees, ferryman 11
4988403 2353499 2353499 defendant Thormondby Robert fishmonger 589744 589744 Thormondby, Robert, of Thormondby, fishmonger 12
4988404 2353499 2353499 defendant Prestman John husbandman 590061 590061 Prestman, John, of Barton, husbandman 13
4988405 2353499 2353499 defendant Spycer William spicer 757558 757558 Spycer, William, of Yarum, spicer 14
4988406 2353499 2353499 defendant Swaldale Richard   762571 762571 Swaldale, Richard, of Cateryk, husb 15
4988407 2353499 2353499 defendant Webster John weaver 757558 757558 Webster, John, of Yarum, weaver 16
4988408 2353499 2353499 defendant Colkhey John husbandman 799902 799902 Colkhey, John, of Semer, in Cleveland, husbandman 17
4988409 2353499 2353499 defendant Pech Thomas tailor 831202 831202 Pech, Thomas, of Rig in Rouceby, tailor 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);