names

53 rows where place_id = 598242

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3631699 1904726 1904726 defendant Bowet John yeoman 598242 598242 Bowet, John, of Hedley, yeoman 2
3670323 1916671 1916671 defendant Atwell John husbandman 598242 598242 Atwell, John, of Hedley, husbandman 0
3670324 1916671 1916671 defendant Weller Richard husbandman 598242 598242 Weller, Richard, of Hedley, husbandman 1
3670325 1916671 1916671 defendant Kempe Richard husbandman 598242 598242 Kempe, Richard, of Hedley, husbandman 2
3670326 1916671 1916671 defendant Hall John husbandman 598242 598242 Hall, John, of Hedley, husbandman 3
3699454 1926056 1926056 defendant Atwell John husbandman 598242 598242 Atwell, John, of Hedley, husbandman 0
3801052 1958244 1958244 defendant Fygg Richard clothmaker 598242 598242 Fygg, Richard, of Hedley, clothmaker 0
3801053 1958244 1958244 defendant Cleamentis Thomas dyer 598242 598242 Cleamentis, Thomas, of Hedley, dyer 1
3801054 1958244 1958244 defendant Fygg John   598242 598242 Fygg, John, of Hedley, parish clerk 2
3812161 1961714 1961714 defendant Arnold Thomas yeoman 598242 598242 Arnold, Thomas, of Hedley, yeoman 1
3812162 1961714 1961714 defendant Kempe Roger husbandman 598242 598242 Kempe, Roger, of Hedley, husbandman 2
3812163 1961714 1961714 defendant Drewe Alan husbandman 598242 598242 Drewe, Alan, of Hedley, husbandman 3
3812164 1961714 1961714 defendant Atwell Richard husbandman 598242 598242 Atwell, Richard, of Hedley, husbandman 4
3812165 1961714 1961714 defendant Gower John husbandman 598242 598242 Gower, John, of Hedley, husbandman 5
3812166 1961714 1961714 defendant Kempe Richard husbandman 598242 598242 Kempe, Richard, of Hedley, husbandman 6
3812171 1961715 1961715 defendant Arnold Thomas yeoman 598242 598242 Arnold, Thomas, of Hedley, yeoman 1
3812172 1961715 1961715 defendant Kempe Roger husbandman 598242 598242 Kempe, Roger, of Hedley, husbandman 2
3812173 1961715 1961715 defendant Drewe Alan husbandman 598242 598242 Drewe, Alan, of Hedley, husbandman 3
3812174 1961715 1961715 defendant Atwell Richard husbandman 598242 598242 Atwell, Richard, of Hedley, husbandman 4
3812175 1961715 1961715 defendant Gower John husbandman 598242 598242 Gower, John, of Hedley, husbandman 5
3812176 1961715 1961715 defendant Kempe Richard husbandman 598242 598242 Kempe, Richard, of Hedley, husbandman 6
3812181 1961716 1961716 defendant Arnold Thomas yeoman 598242 598242 Arnold, Thomas, of Hedley, yeoman 1
3812182 1961716 1961716 defendant Kempe Roger husbandman 598242 598242 Kempe, Roger, of Hedley, husbandman 2
3812183 1961716 1961716 defendant Drewe Alan husbandman 598242 598242 Drewe, Alan, of Hedley, husbandman 3
3812184 1961716 1961716 defendant Atwell Richard husbandman 598242 598242 Atwell, Richard, of Hedley, husbandman 4
3812185 1961716 1961716 defendant Gower John husbandman 598242 598242 Gower, John, of Hedley, husbandman 5
3812186 1961716 1961716 defendant Kempe Richard   598242 598242 Kempe, Richard, of Hedley 6
3812189 1961717 1961717 defendant Arnold Thomas yeoman 598242 598242 Arnold, Thomas, of Hedley, yeoman 1
3812190 1961717 1961717 defendant Kempe Roger husbandman 598242 598242 Kempe, Roger, of Hedley, husbandman 2
3812191 1961717 1961717 defendant Drewe Alan husbandman 598242 598242 Drewe, Alan, of Hedley, husbandman 3
3812192 1961717 1961717 defendant Atwell Richard husbandman 598242 598242 Atwell, Richard, of Hedley, husbandman 4
3812193 1961717 1961717 defendant Gower John husbandman 598242 598242 Gower, John, of Hedley, husbandman 5
3812194 1961717 1961717 defendant Kempe Richard   598242 598242 Kempe, Richard, of Hedley 6
3828938 1966933 1966933 defendant Magewyk Gregory clothier 598242 598242 Magewyk, Gregory, of Hedley, clothier 0
3838697 1970029 1970029 defendant Mylle John husbandman 598242 598242 Mylle, John, of Hedley, husbandman 0
3861174 1977214 1977214 defendant Smyth Thomas tailor 598242 598242 Smyth, Thomas, of Hedley, tailor 0
3878402 1983023 1983023 defendant Barker Francis yeoman 598242 598242 Barker, Francis, of Hedley, yeoman 4
3883020 1984586 1984586 defendant Fygge William clothier 598242 598242 Fygge, William, of Hedley, clothier 0
3926485 1999188 1999188 defendant Parker Gregory gent 598242 598242 Parker, Gregory, of Hedley, gent 0
3926486 1999188 1999188 defendant Langford Thomas laborer 598242 598242 Langford, Thomas, of Hedley, laborer 1
3926516 1999201 1999201 defendant Turner Nicholas fuller 598242 598242 Turner, Nicholas, of Hedley, fuller 0
3926694 1999262 1999262 defendant Turner Nicholas fuller 598242 598242 Turner, Nicholas, of Hedley, fuller 0
3926695 1999262 1999262 defendant Valower Thomas weaver 598242 598242 Valower, Thomas, of Hedley, weaver 1
3950071 2007108 2007108 defendant Abbes Richard clothier 598242 598242 Abbes, Richard, of Hedley, clothier 1
4110110 2063878 2063878 defendant Kelsey John husbandman 598242 598242 Kelsey, John, of Hedley, husbandman 0
4110111 2063878 2063878 defendant Trygge John weaver 598242 598242 Trygge, John, of Hedley, weaver 1
4110112 2063878 2063878 defendant Baker William weaver 598242 598242 Baker, William, of Hedley, weaver 2
4379766 2157858 2157858 defendant Morer John yeoman 598242 598242 Morer, John, of Hedley, yeoman 0
4386140 2160047 2160047 defendant Hardynge William yeoman 598242 598242 Hardynge, William, of Hedley, yeoman 1
5295699 2443737 2443737 plaintiff Wade William   598242 598242 Wade, William, of Hedley 0
5321234 2451448 2451448 defendant Myldram John yeoman 598242 598242 Myldram, John, of Hedley, yeoman 2
5321258 2451455 2451455 defendant Myldram John yeoman 598242 598242 Myldram, John, of Hedley, yeoman 2
5606905 2537048 2537048 defendant Gale William husbandman 598242 598242 Gale, William, of Hedley, husbandman 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);