names

55 rows where place_id = 603977

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3651803 1910922 1910922 defendant Senns Lawrence goldsmith 603977 603977 Senns, Lawrence, of Cokermouth, Cumber, goldsmith 4
3656445 1912262 1912262 defendant Heyde Henry merchant 603977 603977 Heyde, Henry, of Cokermouth, merchant 0
3660599 1913575 1913575 defendant Rubton Alan chapman 603977 603977 Rubton, Alan, of Cokermouth, chapman 0
3798817 1957545 1957545 defendant Ribton Alan merchant 603977 603977 Ribton, Alan, of Cokermouth, merchant 0
3798818 1957545 1957545 defendant Leys John yeoman 603977 603977 Leys, John, of Cokermouth, yeoman 1
3798827 1957548 1957548 defendant Ribton or Riberton Alan merchant 603977 603977 Ribton or Riberton, Alan, of Cokermouth, merchant 0
3798828 1957548 1957548 defendant Leyes John yeoman 603977 603977 Leyes, John, of Cokermouth, yeoman 1
3962582 2011504 2011504 defendant Lamplewgh George gent 603977 603977 Lamplewgh, George, of Cokermouth, Cumber, gent 0
4439638 2181665 2181665 defendant del Warderop William   603977 603977 del Warderop, William, of Cokermouth 0
4439639 2181665 2181665 defendant Hussher Adam   603977 603977 Hussher, Adam, of Cokermouth 1
4439641 2181665 2181665 defendant Brounfeld William   603977 603977 Brounfeld, William, of Cokermouth 3
4454470 2186411 2186411 plaintiff Macarinta Michael   603977 603977 Macarinta, Michael, of Cokermouth 0
4474385 2192642 2192642 plaintiff Dike John   603977 603977 Dike, John, of Cokermouth 0
4474387 2192643 2192643 plaintiff Dike John   603977 603977 Dike, John, of Cokermouth 0
4482924 2195357 2195357 plaintiff Muche William   603977 603977 Muche, William, of Cokermouth 0
4484331 2195803 2195803 defendant Margerison John   603977 603977 Margerison, John, of Cokermouth 0
4502375 2201331 2201331 plaintiff Micche or Muthe William   603977 603977 Micche or Muthe, William, of Cokermouth 0
4573635 2223267 2223267 defendant Pate Thomas   603977 603977 Pate, Thomas, of Cokermouth 0
4605262 2232812 2232812 defendant Dikke John   603977 603977 Dikke, John, of Cokermouth 4
4613342 2235206 2235206 plaintiff Dalton William   603977 603977 Dalton, William, of Cokermouth 0
4613699 2235296 2235296 defendant Myrke Thomas   603977 603977 Myrke, Thomas, of Cokermouth 1
4661452 2249411 2249411 defendant Danson or Dauson John, junior yeoman 603977 603977 Danson or Dauson, John, junior, of Cokermouth, yeoman 0
4661455 2249412 2249412 defendant Doweson John, junior yeoman 603977 603977 Doweson, John, junior, of Cokermouth, yeoman 1
4661456 2249412 2249412 defendant Marke Thomas miller 603977 603977 Marke, Thomas, of Cokermouth, miller 2
4661457 2249412 2249412 defendant Doweson John, senior husbandman 603977 603977 Doweson, John, senior, of Cokermouth, husbandman 3
4684304 2260693 2260693 defendant Sadler Thomas yeoman 603977 603977 Sadler, Thomas, of Cokermouth, yeoman 0
4841962 2309024 2309024 defendant Tolson Robert chapman 603977 603977 Tolson, Robert, of Cokermouth, chapman 0
4848676 2311056 2311056 defendant Cokden Richard yeoman 603977 603977 Cokden, Richard, of Cokermouth, yeoman 5
4865855 2316291 2316291 defendant Jonson Robert mercer 603977 603977 Jonson, Robert, of Cokermouth, mercer 0
4869410 2317399 2317399 defendant Tolson Robert chapman 603977 603977 Tolson, Robert, of Cokermouth, chapman 0
4876337 2319561 2319561 defendant Cokden Richard yeoman 603977 603977 Cokden, Richard, of Cokermouth, yeoman 4
4888338 2323155 2323155 defendant Richardson John mercer 603977 603977 Richardson, John, of Cokermouth, Cumber, mercer 3
4892283 2324323 2324323 defendant Ylson Robert Jonesson mercer 603977 603977 Ylson, Robert Jonesson, of Cokermouth, mercer 0
4933599 2336892 2336892 defendant Mercer James yeoman 603977 603977 Mercer, James, of Cokermouth, yeoman 3
4933600 2336892 2336892 defendant Rollynson John yeoman 603977 603977 Rollynson, John, of Cokermouth, yeoman 4
4942212 2339553 2339553 defendant Fenwyk Henry   603977 603977 Fenwyk, Henry, of Cokermouth, Cumber, knight 0
4942213 2339553 2339553 defendant Dykenson Thomas yeoman 603977 603977 Dykenson, Thomas, of Cokermouth, yeoman 1
4955896 2343730 2343730 defendant Mercer James yeoman 603977 603977 Mercer, James, of Cokermouth, yeoman 3
4955897 2343730 2343730 defendant Rollynson John yeoman 603977 603977 Rollynson, John, of Cokermouth, yeoman 4
4955899 2343731 2343731 defendant Dyxson John yeoman 603977 603977 Dyxson, John, of Cokermouth, yeoman 0
4957200 2344112 2344112 defendant Fenwyk Henry   603977 603977 Fenwyk, Henry, of Cokermouth, Cumber, knight 0
4957202 2344113 2344113 defendant Fenwyk Henry   603977 603977 Fenwyk, Henry, of Cokermouth, Cumber, knight 0
4966770 2346991 2346991 defendant Fenwyk Henry   603977 603977 Fenwyk, Henry, of Cokermouth, Cumber, knight 0
5021199 2363100 2363100 defendant Denton John gent 603977 603977 Denton, John, of Cokermouth, Cumber, gent 1
5024249 2364007 2364007 defendant Fenwyk Henry   603977 603977 Fenwyk, Henry, of Cokermouth, Cumber, knight 1
5025779 2364437 2364437 defendant Fenwyk Henry   603977 603977 Fenwyk, Henry, of Cokermouth, Cumber, knight 1
5042347 2369317 2369317 defendant Crakenthorp Thomas esq & sheriff of Cumberlan 603977 603977 Crakenthorp, Thomas, of Cokermouth, esq & sheriff of Cumberlan 0
5086946 2382566 2382566 defendant Lamplegh Gilbert gent 603977 603977 Lamplegh, Gilbert, of Cokermouth, Cumber, gent 4
5094939 2384931 2384931 defendant Tunge Richard chapman 603977 603977 Tunge, Richard, of Cokermouth, Cumber, chapman 2
5303597 2446071 2446071 defendant Fyssher Richard yeoman 603977 603977 Fyssher, Richard, of Cokermouth, yeoman 2
5390056 2472217 2472217 defendant Lolond John   603977 603977 Lolond, John, of Cokermouth 0
5481878 2499511 2499511 defendant Hogeson James chapman 603977 603977 Hogeson, James, of Cokermouth, chapman 3
5585071 2530402 2530402 plaintiff Holland Richard   603977 603977 Holland, Richard, of Cokermouth 0
5592625 2532685 2532685 defendant Norman Richard (legal representative) 603977 603977 Norman, Richard, of Cokermouth, gent, executors of 0
5620825 2550382 2550382 defendant Spycer Alan   603977 603977 Spycer, Alan, of Cokermouth 0

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