names

29 rows where place_id = 591296

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3603976 1868911 1868911 plaintiff Foorthe William   591296 591296 Foorthe, William, of Hadlee 0
3604008 1868920 1868920 plaintiff Forthe William   591296 591296 Forthe, William, of Hadlee 0
3621801 1874356 1874356 defendant Fen John clothmaker 591296 591296 Fen, John, of Hadlee, clothmaker 3
3621802 1874356 1874356 defendant Turnour William weaver 591296 591296 Turnour, William, of Hadlee, weaver 4
3631305 1904602 1904602 defendant Whitlee William smith 591296 591296 Whitlee, William, of Hadlee, smith 13
4504359 2201915 2201915 defendant atte Feen John chandler 591296 591296 atte Feen, John, of Hadlee, chandler 0
4575303 2223788 2223788 defendant Poyt Simon   591296 591296 Poyt, Simon, of Hadlee 4
4582928 2226088 2226088 plaintiff Fisshere Richard   591296 591296 Fisshere, Richard, of Hadlee 0
4582931 2226089 2226089 plaintiff Fisshere Richard   591296 591296 Fisshere, Richard, of Hadlee 0
4585427 2226864 2226864 defendant Hache Robert   591296 591296 Hache, Robert, of Hadlee 0
4607212 2233371 2233371 defendant Tyryngton Henry chaplain 591296 591296 Tyryngton, Henry, of Hadlee, chaplain 0
4636721 2242304 2242304 defendant Tyryngton Henry chaplain 591296 591296 Tyryngton, Henry, of Hadlee, chaplain 0
4670428 2256437 2256437 plaintiff Bryan alis Brion John, senior   591296 591296 Bryan alis Brion, John, senior, of Hadlee 0
4670431 2256437 2256437 defendant Smyth Richard smith 591296 591296 Smyth, Richard, of Hadlee, smith 2
4671317 2256678 2256678 defendant Kerswell Peter yeoman 591296 591296 Kerswell, Peter, of Hadlee, yeoman 0
4686907 2261512 2261512 plaintiff Sperhauk William   591296 591296 Sperhauk, William, of Hadlee 0
4686908 2261512 2261512 defendant Kyng John weaver 591296 591296 Kyng, John, of Hadlee, weaver 0
4686909 2261512 2261512 defendant Munchesy John draper 591296 591296 Munchesy, John, of Hadlee, draper 1
4773034 2287537 2287537 defendant Clerk John carpetner 591296 591296 Clerk, John, of Hadlee, carpetner 1
4777093 2288817 2288817 defendant Clopton Robert   591296 591296 Clopton, Robert, of Hadlee 2
4777101 2288818 2288818 defendant Clopton Robert   591296 591296 Clopton, Robert, of Hadlee 2
4809121 2299028 2299028 defendant Wymarke William yeoman 591296 591296 Wymarke, William, of Hadlee, yeoman 1
4938779 2338517 2338517 defendant Burghwell John   591296 591296 Burghwell, John, of Hadlee, mason 0
4938780 2338517 2338517 defendant Ewell John tailor 591296 591296 Ewell, John, of Hadlee, tailor 1
5053257 2372578 2372578 defendant Willemot John maltman 591296 591296 Willemot, John, of Hadlee, maltman 0
5164056 2405223 2405223 defendant Greve Thomas husbandman 591296 591296 Greve, Thomas, of Hadlee, husbandman 0
5251034 2430430 2430430 defendant Greve Thomas yeoman 591296 591296 Greve, Thomas, of Hadlee, yeoman 0
5345152 2458648 2458648 defendant Danyell Richard butcher 591296 591296 Danyell, Richard, of Hadlee, butcher 1
5552503 2520788 2520788 plaintiff Fane alias Vane Henry gent 591296 591296 Fane alias Vane, Henry, of Hadlee, gent 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);