names

218 rows where place_id = 596907

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3626602 1903172 1903172 defendant Brown John gent 596907 596907 Brown, John, of Ludham, gent 2
3641206 1907700 1907700 defendant Calthorp Edward esq 596907 596907 Calthorp, Edward, of Ludham, esq 2
3649430 1910211 1910211 defendant Broun John gent 596907 596907 Broun, John, of Ludham, gent 4
3654600 1911701 1911701 defendant Brown John gent 596907 596907 Brown, John, of Ludham, gent 0
3656314 1912220 1912220 defendant Sutterton Thomas yeoman 596907 596907 Sutterton, Thomas, of Ludham, yeoman 1
3656319 1912221 1912221 defendant Stoterton Thomas yeoman 596907 596907 Stoterton, Thomas, of Ludham, yeoman 1
3696154 1925019 1925019 defendant Croft William husbandman 596907 596907 Croft, William, of Ludham, husbandman 0
3701600 1926749 1926749 defendant Calthorp Edward esq 596907 596907 Calthorp, Edward, of Ludham, esq 1
3706986 1928467 1928467 defendant Albon Adam husbandman 596907 596907 Albon, Adam, of Ludham, husbandman 3
3714024 1930684 1930684 defendant Salman Edmund yeoman 596907 596907 Salman, Edmund, of Ludham, yeoman 0
3723296 1933558 1933558 defendant Calthorp Edward gent 596907 596907 Calthorp, Edward, of Ludham, gent 3
3740109 1938765 1938765 defendant Barker John husbandman 596907 596907 Barker, John, of Ludham, husbandman 2
3742253 1939447 1939447 defendant Wynkfeld John husbandman 596907 596907 Wynkfeld, John, of Ludham, husbandman 0
3753412 1943005 1943005 defendant Albon Adam butcher 596907 596907 Albon, Adam, of Ludham, butcher 0
3757820 1944422 1944422 defendant Ugge Thomas yeoman 596907 596907 Ugge, Thomas, of Ludham, yeoman 0
3758136 1944531 1944531 defendant Calthorp Edward esq 596907 596907 Calthorp, Edward, of Ludham, esq 0
3758189 1944550 1944550 defendant Litylwood Edmund mercer 596907 596907 Litylwood, Edmund, of Ludham, mercer 0
3759596 1944991 1944991 defendant Ugge Thomas husbandman 596907 596907 Ugge, Thomas, of Ludham, husbandman 2
3777484 1950708 1950708 defendant Ugge Thomas husbandman 596907 596907 Ugge, Thomas, of Ludham, husbandman 2
3794196 1956057 1956057 plaintiff Calthorp Anne (legal representative) 596907 596907 Calthorp, Anne, of Ludham, widow, executrix of 0
3835370 1969001 1969001 defendant Quentrell Philip butcher 596907 596907 Quentrell, Philip, of Ludham, butcher 0
3849787 1973521 1973521 defendant Smyth Robert shoemaker 596907 596907 Smyth, Robert, of Ludham, shoemaker 0
3849788 1973521 1973521 defendant Quentrell Philip butcher 596907 596907 Quentrell, Philip, of Ludham, butcher 1
3864791 1978419 1978419 defendant Taylour Robert miller 596907 596907 Taylour, Robert, of Ludham, miller 0
3864792 1978419 1978419 defendant Queyntrell Philip butcher 596907 596907 Queyntrell, Philip, of Ludham, butcher 1
3864793 1978419 1978419 defendant Curteys John laborer 596907 596907 Curteys, John, of Ludham, laborer 2
3875349 1982000 1982000 defendant Meye Thomas husbandman 596907 596907 Meye, Thomas, of Ludham, husbandman 1
3876885 1982511 1982511 defendant Frary William husbandman 596907 596907 Frary, William, of Ludham, husbandman 0
3897579 1989401 1989401 defendant Hogason John yeoman 596907 596907 Hogason, John, of Ludham, yeoman 3
3906388 1992424 1992424 defendant Frary William husbandman 596907 596907 Frary, William, of Ludham, husbandman 0
3906390 1992425 1992425 defendant Frary William husbandman 596907 596907 Frary, William, of Ludham, husbandman 0
3906513 1992470 1992470 defendant Hardy Edward husbandman 596907 596907 Hardy, Edward, of Ludham, husbandman 0
3914110 1995065 1995065 defendant Pery Thomas   596907 596907 Pery, Thomas, of Ludham, serving man 0
3915131 1995420 1995420 defendant Eche Nicholas yeoman 596907 596907 Eche, Nicholas, of Ludham, yeoman 0
3924529 1998518 1998518 defendant Gammon Richard clerk 596907 596907 Gammon, Richard, of Ludham, clerk 0
3934253 2001751 2001751 defendant Egerton Richard (legal representative) 596907 596907 Egerton, Richard, of Ludham, executors of 0
3934254 2001751 2001751 defendant Gammon Richard clerk 596907 596907 (Gammon, Richard, of Ludham, clerk 1
3934401 2001799 2001799 defendant Alyn Robert yeoman 596907 596907 Alyn, Robert, of Ludham, yeoman 0
3935806 2002282 2002282 defendant Ugge William yeoman 596907 596907 Ugge, William, of Ludham, yeoman 3
3952239 2007858 2007858 plaintiff Hemmyng Richard (legal representative) 596907 596907 Hemmyng, Richard, of Ludham, yeoman, executors of 0
3953583 2008327 2008327 defendant Hoddys Thomas butcher 596907 596907 Hoddys, Thomas, of Ludham, butcher 0
3953585 2008328 2008328 defendant Hoddys Thomas butcher 596907 596907 Hoddys, Thomas, of Ludham, butcher 0
3960156 2010655 2010655 defendant Stewarde or Styward John husbandman 596907 596907 Stewarde or Styward, John, of Ludham, husbandman 2
3960160 2010656 2010656 defendant Steward John husbandman 596907 596907 Steward, John, of Ludham, husbandman 1
3978990 2017240 2017240 defendant Palmer Leonard gent 596907 596907 Palmer, Leonard, of Ludham, gent 0
3982889 2018657 2018657 defendant Ryches John husbandman 596907 596907 Ryches, John, of Ludham, husbandman 0
3983747 2018961 2018961 defendant Garould John husbandman 596907 596907 Garould, John, of Ludham, husbandman 0
3983828 2018987 2018987 defendant Styward John husbandman 596907 596907 Styward, John, of Ludham, husbandman 0
3984232 2019129 2019129 defendant Riches John husbandman 596907 596907 Riches, John, of Ludham, husbandman 2
3989293 2020912 2020912 defendant Bekyngham Thomas gent 596907 596907 Bekyngham, Thomas, of Ludham, gent 0
4000572 2024973 2024973 defendant Ugg William yeoman 596907 596907 Ugg, William, of Ludham, yeoman 0
4015002 2030072 2030072 defendant Hodd Thomas butcher 596907 596907 Hodd, Thomas, of Ludham, butcher 10
4018406 2031316 2031316 plaintiff Ugg or Ugges William   596907 596907 Ugg or Ugges, William, of Ludham 0
4018407 2031316 2031316 defendant Garlonde John husbandman 596907 596907 Garlonde, John, of Ludham, husbandman 0
4018799 2031454 2031454 defendant Ugge William husbandman 596907 596907 Ugge, William, of Ludham, husbandman 0
4020835 2032180 2032180 defendant Ugg William yeoman 596907 596907 Ugg, William, of Ludham, yeoman 0
4046009 2041016 2041016 defendant Ugg William yeoman 596907 596907 Ugg, William, of Ludham, yeoman 2
4046013 2041017 2041017 defendant Ugg William yeoman 596907 596907 Ugg, William, of Ludham, yeoman 2
4046014 2041017 2041017 defendant Garland John husbandman 596907 596907 Garland, John, of Ludham, husbandman 3
4051257 2042889 2042889 defendant Gaulte Edmund cordwainer 596907 596907 Gaulte, Edmund, of Ludham, cordwainer 1
4051260 2042890 2042890 defendant Gault Edmund cordwainer 596907 596907 Gault, Edmund, of Ludham, cordwainer 1
4076367 2051846 2051846 defendant Locke Thomas husbandman 596907 596907 Locke, Thomas, of Ludham, husbandman 0
4076672 2051943 2051943 defendant Ugg William yeoman 596907 596907 Ugg, William, of Ludham, yeoman 15
4084376 2054683 2054683 defendant Garlond John husbandman 596907 596907 Garlond, John, of Ludham, husbandman 0
4084377 2054683 2054683 defendant Davy John smith 596907 596907 Davy, John, of Ludham, smith 1
4107394 2062933 2062933 defendant Lock Thomas yeoman 596907 596907 Lock, Thomas, of Ludham, yeoman 0
4107395 2062933 2062933 defendant Jeckes John husbandman 596907 596907 Jeckes, John, of Ludham, husbandman 1
4120363 2067557 2067557 defendant Garland John husbandman 596907 596907 Garland, John, of Ludham, husbandman 0
4124609 2069099 2069099 defendant Mannyng John cordwainer 596907 596907 Mannyng, John, of Ludham, cordwainer 0
4125529 2069415 2069415 defendant Garland John husbandman 596907 596907 Garland, John, of Ludham, husbandman 0
4133859 2072445 2072445 defendant Garlond John yeoman 596907 596907 Garlond, John, of Ludham, yeoman 0
4143386 2075851 2075851 defendant Garlond John husbandman 596907 596907 Garlond, John, of Ludham, husbandman 0
4148745 2077685 2077685 defendant Garlond John husbandman 596907 596907 Garlond, John, of Ludham, husbandman 0
4152178 2078873 2078873 defendant Wythers Thomas yeoman 596907 596907 Wythers, Thomas, of Ludham, yeoman 0
4157820 2080811 2080811 defendant Garlond John husbandman 596907 596907 Garlond, John, of Ludham, husbandman 0
4157826 2080814 2080814 defendant Garlond John yeoman 596907 596907 Garlond, John, of Ludham, yeoman 0
4162322 2082381 2082381 defendant Barker William yeoman 596907 596907 Barker, William, of Ludham, yeoman 2
4185878 2090556 2090556 defendant Grene Robert yeoman 596907 596907 Grene, Robert, of Ludham, yeoman 1
4191513 2092595 2092595 defendant Walker Henry   596907 596907 Walker, Henry, of Ludham gent 0
4195410 2093940 2093940 defendant Hodd Thomas husbandman 596907 596907 Hodd, Thomas, of Ludham, husbandman 0
4220460 2102658 2102658 defendant Dey Edmund fishmonger 596907 596907 Dey, Edmund, of Ludham, fishmonger 3
4229039 2105639 2105639 defendant Buntyng Robert husbandman 596907 596907 together with Buntyng, Robert, of Ludham, husbandman 2
4230873 2106295 2106295 defendant Howling William, junior husbandman 596907 596907 Howling, William, junior, of Ludham, husbandman 2
4231406 2106486 2106486 defendant Buntynge Robert husbandman 596907 596907 Buntynge, Robert, of Ludham, husbandman 2
4231407 2106486 2106486 defendant Pyle Robert tailor 596907 596907 Pyle, Robert, of Ludham, tailor 3
4244540 2111154 2111154 defendant Smyth Andrew gent 596907 596907 Smyth, Andrew, of Ludham, gent 1
4249512 2112820 2112820 defendant Bolt John yeoman 596907 596907 Bolt, John, of Ludham, yeoman 2
4251438 2113462 2113462 defendant Moone Thomas tailor 596907 596907 Moone, Thomas, of Ludham, tailor 0
4252275 2113753 2113753 defendant Hodges Thomas husbandman 596907 596907 Hodges, Thomas, of Ludham, husbandman 2
4252276 2113753 2113753 defendant Segar William husbandman 596907 596907 Segar, William, of Ludham, husbandman 3
4253687 2114224 2114224 defendant Beare Joan widow 596907 596907 Beare, Joan, of Ludham, widow 2
4253940 2114315 2114315 defendant Moone Thomas tailor 596907 596907 Moone, Thomas, of Ludham, tailor 1
4253941 2114315 2114315 defendant Palmer John cordwainer 596907 596907 Palmer, John, of Ludham, cordwainer 2
4253942 2114315 2114315 defendant Bateman Rachel widow 596907 596907 Bateman, Rachel, of Ludham, widow 3
4255445 2114815 2114815 defendant Barker William yeoman 596907 596907 Barker, William, of Ludham, yeoman 2
4257154 2115370 2115370 defendant Morley Christopher husbandman 596907 596907 Morley, Christopher, of Ludham, husbandman 1
4257155 2115370 2115370 defendant Morley William husbandman 596907 596907 Morley, William, of Ludham, husbandman 2
4260700 2116546 2116546 defendant Morley William yeoman 596907 596907 Morley, William, of Ludham, yeoman 0
4260902 2116611 2116611 defendant Love William husbandman 596907 596907 Love, William, of Ludham, husbandman 0
4260903 2116611 2116611 defendant Morley William husbandman 596907 596907 Morley, William, of Ludham, husbandman 1

Next page

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