names

81 rows where place_id = 591757

✎ 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
3605492 1869382 1869382 defendant Goldyng John husbandman 591757 591757 Goldyng, John, of Lakenham, husbandman 4
3606536 1869716 1869716 defendant Goldyng John yeoman 591757 591757 Goldyng, John, of Lakenham, yeoman 0
3615411 1872461 1872461 defendant Goldyng John husbandman 591757 591757 Goldyng, John, of Lakenham, husbandman 0
3636363 1906164 1906164 defendant Davy Philip miller 591757 591757 Davy, Philip, of Lakenham, miller 0
3668743 1916158 1916158 defendant Bettys John husbandman 591757 591757 Bettys, John, of Lakenham, husbandman 2
3697462 1925425 1925425 defendant Bromehole John husbandman 591757 591757 Bromehole, John, of Lakenham, husbandman 1
3700541 1926412 1926412 defendant Bradford Henry husbandman 591757 591757 Bradford, Henry, of Lakenham, husbandman 0
3700542 1926412 1926412 defendant Decon Nicholas husbandman 591757 591757 Decon, Nicholas, of Lakenham, husbandman 1
3700543 1926412 1926412 defendant Mason John husbandman 591757 591757 Mason, John, of Lakenham, husbandman 2
3715255 1931056 1931056 defendant Bromell John miller 591757 591757 Bromell, John, of Lakenham, miller 4
3724779 1934034 1934034 defendant Whelpdale Thomas smith 591757 591757 Whelpdale, Thomas, of Lakenham, smith 0
3735325 1937283 1937283 defendant Whelpdale Thomas smith 591757 591757 Whelpdale, Thomas, of Lakenham, smith 0
3738450 1938231 1938231 defendant Smyth Robert husbandman 591757 591757 Smyth, Robert, of Lakenham, husbandman 0
3738451 1938231 1938231 defendant Harre Robert husbandman 591757 591757 Harre, Robert, of Lakenham, husbandman 1
3738452 1938231 1938231 defendant Harre John husbandman 591757 591757 Harre, John, of Lakenham, husbandman 2
3749002 1941619 1941619 defendant Spynsby Nicholas laborer 591757 591757 Spynsby, Nicholas, of Lakenham, laborer 0
3769298 1948051 1948051 defendant Harryson John laborer 591757 591757 Harryson, John, of Lakenham, laborer 0
3776618 1950431 1950431 defendant Harryson John husbandman 591757 591757 Harryson, John, of Lakenham, husbandman 3
3797675 1957169 1957169 defendant Felde John smith 591757 591757 Felde, John, of Lakenham, smith 1
3803395 1958963 1958963 defendant Harryson John laborer 591757 591757 Harryson, John, of Lakenham, laborer 0
3824993 1965689 1965689 defendant Shreve Andrew smith 591757 591757 Shreve, Andrew, of Lakenham, smith 3
3836579 1969344 1969344 defendant Blythe John husbandman 591757 591757 Blythe, John, of Lakenham, husbandman 1
3907219 1992705 1992705 defendant Barne Richard laborer 591757 591757 Barne, Richard, of Lakenham, laborer 1
4011788 2028954 2028954 plaintiff Potter Humphrey   591757 591757 Potter, Humphrey, of Lakenham 0
4038459 2038392 2038392 defendant Brigg Katherine widow 591757 591757 Brigg, Katherine, of Lakenham, or of Woodnorton, Norf, widow 0
4043540 2040150 2040150 plaintiff Potter Humphrey gent 591757 591757 Potter, Humphrey, of Lakenham, gent 0
4056161 2044593 2044593 defendant Barker Thomas yeoman 591757 591757 Barker, Thomas, of Lakenham, yeoman 0
4066402 2048278 2048278 defendant Barker Gregory husbandman 591757 591757 Barker, Gregory, of Lakenham, husbandman 0
4066406 2048279 2048279 defendant Barker William husbandman 591757 591757 Barker, William, of Lakenham, husbandman 0
4066410 2048281 2048281 defendant Barker Thomas yeoman 591757 591757 Barker, Thomas, of Lakenham, yeoman 0
4073712 2050890 2050890 plaintiff Potter Humphrey gent 591757 591757 Potter, Humphrey, of Lakenham, gent 0
4076837 2052001 2052001 defendant Barker William husbandman 591757 591757 Barker, William, of Lakenham, husbandman 1
4076838 2052001 2052001 defendant Barker Thomas yeoman 591757 591757 Barker, Thomas, of Lakenham, yeoman 2
4078279 2052533 2052533 defendant Barker George husbandman 591757 591757 Barker, George, of Lakenham, husbandman 0
4078281 2052533 2052533 defendant Barker William husbandman 591757 591757 Barker, William, of Lakenham, husbandman 2
4093763 2058090 2058090 defendant Barton Thomas yeoman 591757 591757 Barton, Thomas, of Lakenham, yeoman 1
4095300 2058642 2058642 defendant Barker Thomas yeoman 591757 591757 Barker, Thomas, of Lakenham, yeoman 0
4108588 2063327 2063327 defendant Barker Thomas yeoman 591757 591757 Barker, Thomas, of Lakenham, yeoman 0
4113313 2065029 2065029 defendant Barker Thomas yeoman 591757 591757 Barker, Thomas, of Lakenham, yeoman 1
4113570 2065131 2065131 defendant Barker Gregory husbandman 591757 591757 Barker, Gregory, of Lakenham, husbandman 1
4113574 2065132 2065132 defendant Barker Thomas yeoman 591757 591757 Barker, Thomas, of Lakenham, yeoman 0
4119140 2067134 2067134 defendant Barker Thomas yeoman 591757 591757 Barker, Thomas, of Lakenham, yeoman 1
4133099 2072166 2072166 defendant Barker Thomas yeoman 591757 591757 Barker, Thomas, of Lakenham, yeoman 1
4172147 2085719 2085719 defendant Barker Thomas yeoman 591757 591757 Barker, Thomas, of Lakenham, yeoman 0
4198277 2094946 2094946 defendant Barker Thomas husbandman 591757 591757 Barker, Thomas, of Lakenham, husbandman 0
4243144 2110699 2110699 defendant Jenney John miller 591757 591757 Jenney, John, of Lakenham, miller 0
4243145 2110699 2110699 defendant Nunne George clothier 591757 591757 Nunne, George, of Lakenham, clothier 1
4243147 2110700 2110700 defendant Jenney John miller 591757 591757 Jenney, John, of Lakenham, miller 0
4243148 2110700 2110700 defendant Nunne George clothier 591757 591757 Nunne, George, of Lakenham, clothier 1
4344763 2145448 2145448 defendant Barker Thomas yeoman 591757 591757 Barker, Thomas, of Lakenham, yeoman 0
4384551 2159522 2159522 defendant Dunt Thomas tailor 591757 591757 Dunt, Thomas, of Lakenham, tailor 1
4456951 2187182 2187182 defendant Thurston John de   591757 591757 Thurston, John de, of Lakenham 5
4665242 2250618 2250618 defendant Amerynghale Robert yeoman 591757 591757 Amerynghale, Robert, of Lakenham, yeoman 0
4744853 2279013 2279013 defendant Amberynggale Robert husbandman 591757 591757 Amberynggale, Robert, of Lakenham, husbandman 1
4857651 2313773 2313773 defendant Miller Thomas husbandman 591757 591757 Miller, Thomas, of Lakenham, husbandman 1
4859165 2314241 2314241 defendant Kegyll Robert fuller 591757 591757 Kegyll, Robert, of Lakenham, fuller 1
4892348 2324342 2324342 defendant Smyth John smith 591757 591757 Smyth, John, of Lakenham, smith 1
4951762 2342503 2342503 defendant Amerynghale Richard husbandman 591757 591757 Amerynghale, Richard, of Lakenham, husbandman 2
4984454 2352284 2352284 defendant Amerynghale Richard yeoman 591757 591757 Amerynghale, Richard, of Lakenham, yeoman 2
5001053 2357187 2357187 plaintiff Drantale William   591757 591757 (Drantale, William, of Lakenham 1
5018246 2362221 2362221 defendant Wotton John laborer 591757 591757 Wotton, John, of Lakenham, laborer 5
5023633 2363822 2363822 defendant Amrynghale Richard husbandman 591757 591757 Amrynghale, Richard, of Lakenham, husbandman 3
5095169 2385002 2385002 defendant Eyr John husbandman 591757 591757 Eyr, John, of Lakenham, husbandman 1
5130437 2395392 2395392 defendant Wytton John laborer 591757 591757 Wytton, John, of Lakenham, laborer 1
5168606 2406539 2406539 defendant Witton John laborer 591757 591757 Witton, John, of Lakenham, laborer 1
5184613 2411247 2411247 defendant Witton John laborer 591757 591757 Witton, John, of Lakenham, laborer 1
5256066 2432023 2432023 defendant Ayleward William miller 591757 591757 Ayleward, William, of Lakenham, miller 0
5256067 2432023 2432023 defendant Smyth Henry husbandman 591757 591757 Smyth, Henry, of Lakenham, husbandman 1
5256068 2432023 2432023 defendant Lachesose John fuller 591757 591757 Lachesose, John, of Lakenham, fuller 2
5395761 2473869 2473869 defendant Smyth John husbandman 591757 591757 Smyth,John, of Lakenham, husbandman 4
5460136 2492965 2492965 defendant Pepyr William husbandman 591757 591757 Pepyr, William, of Lakenham, husbandman 3
5471636 2496466 2496466 defendant Seled Richard   591757 591757 Seled, Richard, of Lakenham, wood ash burner 1
5471771 2496510 2496510 defendant Pepyr William husbandman 591757 591757 Pepyr, William, of Lakenham, husbandman 3
5483180 2499909 2499909 defendant Pepir William husbandman 591757 591757 Pepir, William, of Lakenham, husbandman 4
5485061 2500450 2500450 defendant Seled Richard   591757 591757 Seled, Richard, of Lakenham, wood ash burner 1
5506270 2506879 2506879 defendant Kegyll William husbandman 591757 591757 Kegyll, William, of Lakenham, husbandman 7
5506271 2506879 2506879 defendant Tolle Edmund husbandman 591757 591757 Tolle, Edmund, of Lakenham, husbandman 8
5584076 2530094 2530094 defendant Tredwey alias Johnson William husbandman 591757 591757 Tredwey alias Johnson, William, of Lakenham, husbandman 1
5596652 2533874 2533874 defendant Davy John miller 591757 591757 Davy, John, of Lakenham, miller 0
5602221 2535592 2535592 defendant Bromoll John miller 591757 591757 Bromoll, John, of Lakenham, miller 0
5606569 2536938 2536938 plaintiff Tredwey William   591757 591757 Tredwey, William, of Lakenham 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);