names

32 rows where case_id = 2472912

✎ 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
5392399 2472912 2472912 plaintiff Saucheverell John     Saucheverell, John 0
5392400 2472912 2472912 defendant Lyndap William laborer 591514 591514 Lyndap, William, of Worsworth, laborer 0
5392401 2472912 2472912 defendant Barker Richard tanner 620597 620597 Barker, Richard, of Worseworth, tanner 1
5392402 2472912 2472912 defendant Robynson James shoemaker 620597 620597 Robynson, James, of Worseworth, shoemaker 2
5392403 2472912 2472912 defendant Fryth Robert laborer 620597 620597 Fryth, Robert, of Worseworth, laborer 3
5392404 2472912 2472912 defendant Mecok Robert walker 620597 620597 Mecok, Robert, of Worseworth, walker 4
5392405 2472912 2472912 defendant Fleccher Roger weaver   Fleccher, Roger, weaver 5
5392406 2472912 2472912 defendant Barley William tanner   Barley, William, tanner 6
5392407 2472912 2472912 defendant Fouke Nicholas laborer 620597 620597 Fouke, Nicholas, of Worseworth, laborer 7
5392408 2472912 2472912 defendant Fouke John laborer   Fouke, John, laborer 8
5392409 2472912 2472912 defendant Whetcroft John laborer   Whetcroft, John, laborer 9
5392410 2472912 2472912 defendant Stanton David butcher   Stanton, David, butcher 10
5392411 2472912 2472912 defendant Salforth Richard shoemaker   Salforth, Richard, shoemaker 11
5392412 2472912 2472912 defendant Salforth William laborer   Salforth, William, laborer 12
5392413 2472912 2472912 defendant Holley Bartonus slater   Holley, Bartonus, slater 13
5392414 2472912 2472912 defendant Holley Eliis dyer   Holley, Eliis, dyer 14
5392415 2472912 2472912 defendant Fryth Nicholas laborer   Fryth, Nicholas, laborer 15
5392416 2472912 2472912 defendant Smyth Richard chaplain 595329 595329 Smyth, Richard, of Ireton, chaplain 16
5392417 2472912 2472912 defendant Day John laborer 595329 595329 Day, John, of Ireton, laborer 17
5392418 2472912 2472912 defendant Foucher Thomas laborer 595329 595329 Foucher, Thomas, of Ireton, laborer 18
5392419 2472912 2472912 defendant Eyton Thomas husbandman 586406 586406 Eyton, Thomas, of Hopton, husbandman 19
5392420 2472912 2472912 defendant Coghen John husbandman 586406 586406 Coghen, John, of Hopton, husbandman 20
5392421 2472912 2472912 defendant Stepill Nicholas husbandman 586406 586406 Stepill, Nicholas, of Hopton, husbandman 21
5392422 2472912 2472912 defendant Stepyll John husbandman 586406 586406 Stepyll, John, of Hopton, husbandman 22
5392423 2472912 2472912 defendant Smotherley William husbandman 586406 586406 Smotherley, William, of Hopton, husbandman 23
5392424 2472912 2472912 defendant Heghton Thomas husbandman 807259 807259 Heghton, Thomas, of Carston, husbandman 24
5392425 2472912 2472912 defendant Wylson Oliver laborer 807259 807259 Wylson, Oliver, of Carston, laborer 25
5392426 2472912 2472912 defendant Knolles Richard husbandman 807259 807259 Knolles, Richard, of Carston, husbandman 26
5392427 2472912 2472912 defendant Haselond Robert laborer 807259 807259 Haselond, Robert, of Carston, laborer 27
5392428 2472912 2472912 defendant Markham John laborer 807259 807259 Markham, John, of Carston, laborer 28
5392429 2472912 2472912 defendant Wilton William husbandman 610360 610360 Wilton, William, of Brassyngton, husbandman 29
5392430 2472912 2472912 defendant Fleccher John husbandman 882302 882302 Fleccher, John, of Milvehouse, husbandman 30

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