names

40 rows where place_id = 660113

✎ 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
3955196 2008881 2008881 defendant Mallett William gent 660113 660113 Mallett, William, of Swillington, gent 2
3977953 2016862 2016862 plaintiff Mallett William esq 660113 660113 Mallett, William, of Swillington, esq 0
4095894 2058863 2058863 defendant Cockell Henry clerk 660113 660113 Cockell, Henry, of Swillington, clerk 1
4108881 2063429 2063429 defendant Cockell Henry clerk 660113 660113 Cockell, Henry, of Swillington, clerk 0
4126354 2069716 2069716 defendant Hemsworthe Stephen yeoman 660113 660113 Hemsworthe, Stephen, of Swillington, yeoman 0
4130254 2071133 2071133 defendant Hemsworth Stephen yeoman 660113 660113 Hemsworth, Stephen, of Swillington, yeoman 0
4149626 2077994 2077994 defendant Newton Robert husbandman 660113 660113 Newton, Robert, of Swillington, husbandman 0
4152538 2079002 2079002 defendant Hemsworthe Stephen yeoman 660113 660113 Hemsworthe, Stephen, of Swillington, yeoman 0
4159786 2081491 2081491 defendant Hymsworth Stephen gent 660113 660113 Hymsworth, Stephen, of Swillington, gent 1
4164575 2083119 2083119 defendant Cockell Henry clerk 660113 660113 Cockell, Henry, of Swillington, clerk 0
4166064 2083636 2083636 defendant Hunsworth or Hesworth Stephen yeoman 660113 660113 Hunsworth or Hesworth, Stephen, of Swillington, yeoman 0
4171192 2085389 2085389 defendant Hall William   660113 660113 Hall, William, of Swillington, linen weaver 0
4178890 2088094 2088094 defendant Cockhill Henry clerk 660113 660113 Cockhill, Henry, of Swillington, clerk 0
4187364 2091081 2091081 defendant Hemsworth Stephen gent 660113 660113 Hemsworth, Stephen, of Swillington, gent 0
4199927 2095524 2095524 defendant Hemsworth Stephen gent 660113 660113 Hemsworth, Stephen, of Swillington, gent 0
4210931 2099383 2099383 defendant Hemsworth Stephen gent 660113 660113 Hemsworth, Stephen, of Swillington, gent 0
4219023 2102149 2102149 defendant Grave Ralph yeoman 660113 660113 Grave, Ralph, of Swillington, yeoman 0
4219024 2102149 2102149 defendant Chambers Francis yeoman 660113 660113 Chambers, Francis, of Swillington, yeoman 1
4254735 2114577 2114577 defendant Newton Robert husbandman 660113 660113 Newton, Robert, of Swillington, husbandman 1
4255105 2114701 2114701 defendant Grave Ralph yeoman 660113 660113 Grave, Ralph, of Swillington, yeoman 0
4260390 2116442 2116442 defendant Shackleton John husbandman 660113 660113 Shackleton, John, of Swillington, husbandman 1
4260391 2116442 2116442 defendant Cloughe Richard husbandman 660113 660113 Cloughe, Richard, of Swillington, husbandman 2
4260392 2116442 2116442 defendant Otes Arthur husbandman 660113 660113 Otes, Arthur, of Swillington, husbandman 3
4269182 2119288 2119288 defendant Grave Ralph yeoman 660113 660113 Grave, Ralph, of Swillington, yeoman 0
4269183 2119288 2119288 defendant Chambers Francis yeoman 660113 660113 Chambers, Francis, of Swillington, yeoman 1
4269185 2119289 2119289 defendant Grave Ralph yeoman 660113 660113 Grave, Ralph, of Swillington, yeoman 0
4269186 2119289 2119289 defendant Chambers Francis yeoman 660113 660113 Chambers, Francis, of Swillington, yeoman 1
4269187 2119289 2119289 defendant Grave Thomas husbandman 660113 660113 Grave, Thomas, of Swillington, husbandman 2
4271086 2119905 2119905 defendant Wrightson Richard gent 660113 660113 Wrightson, Richard, of Swillington, or of Stillington, gent 0
4313630 2134871 2134871 defendant Grave Ralph husbandman 660113 660113 Grave, Ralph, of Swillington, husbandman 1
4313631 2134871 2134871 defendant Otes Arthur husbandman 660113 660113 Otes, Arthur, of Swillington, husbandman 2
4313632 2134871 2134871 defendant Peyse Thomas husbandman 660113 660113 Peyse, Thomas, of Swillington, husbandman 3
4313661 2134883 2134883 defendant Grave Ralph yeoman 660113 660113 Grave, Ralph, of Swillington, yeoman 0
4314279 2135102 2135102 defendant Pease William weaver 660113 660113 Pease, William, of Swillington, weaver 0
4319705 2137004 2137004 defendant Otes Arthur yeoman 660113 660113 Otes, Arthur, of Swillington, yeoman 0
4319706 2137004 2137004 defendant Grene Ralph yeoman 660113 660113 Grene, Ralph, of Swillington, yeoman 1
4319707 2137004 2137004 defendant Grene Thomas yeoman 660113 660113 Grene, Thomas, of Swillington, yeoman 2
4320433 2137244 2137244 defendant Cloughe Richard yeoman 660113 660113 Cloughe, Richard, of Swillington, yeoman 1
4320436 2137245 2137245 defendant Black John yeoman 660113 660113 Black, John, of Swillington, yeoman 1
4405317 2166358 2166358 defendant Grave Ralph yeoman 660113 660113 Grave, Ralph, of Swillington, yeoman 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);