names

249 rows where place_id = 587209

✎ 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
3590765 1864751 1864751 defendant Couper Richard husbandman 587209 587209 Couper, Richard, of Marham, husbandman 0
3590831 1864769 1864769 defendant Elden Robert husbandman 587209 587209 Elden, Robert, of Marham, husbandman 4
3603361 1868723 1868723 defendant Goos Matilda widow 587209 587209 Goos, Matilda, of Marham, widow 1
3628425 1903758 1903758 defendant Littell or Kittell Richard husbandman 587209 587209 Littell or Kittell, Richard, of Marham, husbandman 0
3666048 1915320 1915320 defendant Wythe Thomas yeoman 587209 587209 Wythe, Thomas, of Marham, tailor, Palmer, John, of Aylesham, yeoman 1
3693421 1924158 1924158 defendant Barcham John husbandman 587209 587209 Barcham, John, of Marham, husbandman 1
3710077 1929462 1929462 defendant Appley Denis carpenter 587209 587209 Appley, Denis, of Marham, carpenter 0
3814030 1962292 1962292 defendant Philip Thomas yeoman 587209 587209 Philip, Thomas, of Marham, yeoman 0
3814032 1962293 1962293 defendant Philip Thomas yeoman 587209 587209 Philip, Thomas, of Marham, yeoman 0
3814034 1962294 1962294 defendant Philip Thomas yeoman 587209 587209 Philip, Thomas, of Marham, yeoman 0
3836395 1969291 1969291 defendant Smyth William butcher 587209 587209 Smyth, William, of Marham, butcher 0
3840478 1970581 1970581 defendant Archer Edward husbandman 587209 587209 Archer, Edward, of Marham, husbandman 0
3844291 1971765 1971765 defendant Colynson Ralph husbandman 587209 587209 Colynson, Ralph, of Marham, husbandman 0
3845375 1972115 1972115 defendant Goodes Thomas husbandman 587209 587209 Goodes, Thomas, of Marham, husbandman 0
3846330 1972406 1972406 defendant Elwyn Thomas gent 587209 587209 Elwyn, Thomas, of Marham, gent 0
3846331 1972406 1972406 defendant Gardyner William husbandman 587209 587209 Gardyner, William, of Marham, husbandman 1
3849190 1973343 1973343 defendant Gardyner William husbandman 587209 587209 Gardyner, William, of Marham, husbandman 0
3866916 1979173 1979173 defendant Howson Robert gent 587209 587209 Howson, Robert, of Marham, gent 0
3872866 1981140 1981140 defendant Howson Robert gent 587209 587209 Howson, Robert, of Marham, gent 2
3881160 1983966 1983966 defendant Howson Robert gent 587209 587209 Howson, Robert, of Marham, gent 0
3881162 1983967 1983967 defendant Howson Robert gent 587209 587209 Howson, Robert, of Marham, gent 0
3883153 1984627 1984627 plaintiff Vyncent Thomas   587209 587209 Vyncent, Thomas, of Marham 0
3883154 1984627 1984627 defendant Howson Robert yeoman 587209 587209 Howson, Robert, of Marham, yeoman 0
3899902 1990183 1990183 defendant Ryxe Nicholas carpenter 587209 587209 Ryxe, Nicholas, of Marham, carpenter 0
3913232 1994755 1994755 defendant Marten William   587209 587209 Marten, William, of Marham, shepherd 4
3914477 1995182 1995182 defendant Vyncent Thomas husbandman 587209 587209 Vyncent, Thomas, of Marham, husbandman 3
3915924 1995706 1995706 defendant Lee Thomas husbandman 587209 587209 Lee, Thomas, of Marham, husbandman 1
3916897 1996017 1996017 defendant Bowley Robert husbandman 587209 587209 Bowley, Robert, of Marham, husbandman 0
3916898 1996017 1996017 defendant Gyles Nicholas husbandman 587209 587209 Gyles, Nicholas, of Marham, husbandman 1
3916899 1996017 1996017 defendant Lee Thomas husbandman 587209 587209 Lee, Thomas, of Marham, husbandman 2
3917476 1996202 1996202 defendant Mason John husbandman 587209 587209 Mason, John, of Marham, husbandman 0
3917478 1996203 1996203 defendant Howson Robert yeoman 587209 587209 Howson, Robert, of Marham, yeoman 0
3942117 2004380 2004380 defendant Norwiche alias Cosen John husbandman 587209 587209 Norwiche alias Cosen, John, of Marham, husbandman 0
3965487 2012540 2012540 plaintiff Baxster John yeoman 587209 587209 Baxster, John, of Marham, yeoman 0
3965489 2012540 2012540 defendant West Robert laborer 587209 587209 West, Robert, of Marham, laborer 1
3972202 2014837 2014837 defendant Parker Lawrence carpenter 587209 587209 Parker, Lawrence, of Marham, carpenter 2
3974093 2015509 2015509 defendant Jary Richard yeoman 587209 587209 Jary, Richard, of Marham, yeoman 0
3974094 2015509 2015509 defendant Vyncent Thomas, senior husbandman 587209 587209 Vyncent, Thomas, senior, of Marham, husbandman 1
3975972 2016160 2016160 defendant Harnes or Harves John husbandman 587209 587209 Harnes or Harves, John, of Marham, husbandman 0
3982893 2018659 2018659 plaintiff Sholdham William gent or esq 587209 587209 Sholdham, William, of Marham, gent or esq 0
4009017 2027990 2027990 defendant Vyncent Thomas, senior yeoman 587209 587209 Vyncent, Thomas, senior, of Marham, yeoman 1
4009018 2027990 2027990 defendant Vyncent John, senior yeoman 587209 587209 Vyncent, John, senior, of Marham, yeoman 2
4009019 2027990 2027990 defendant Vyncent John, junior yeoman 587209 587209 Vyncent, John, junior, of Marham, yeoman 3
4028922 2034987 2034987 defendant Vincent Thomas husbandman 587209 587209 Vincent, Thomas, of Marham, husbandman 0
4028923 2034987 2034987 defendant Vincent John husbandman 587209 587209 Vincent, John, of Marham, husbandman 1
4054886 2044138 2044138 defendant Orred William husbandman 587209 587209 Orred, William, of Marham, husbandman 1
4055418 2044333 2044333 defendant Vyncent Thomas husbandman 587209 587209 Vyncent, Thomas, of Marham, husbandman 1
4055419 2044333 2044333 defendant Vyncent John husbandman 587209 587209 Vyncent, John, of Marham, husbandman 2
4057943 2045222 2045222 defendant Vyncent John, senior husbandman 587209 587209 Vyncent, John, senior, of Marham, husbandman 0
4058760 2045525 2045525 defendant Howsegoo Peter husbandman 587209 587209 Howsegoo, Peter, of Marham, husbandman 3
4062125 2046740 2046740 defendant Lackforth John butcher 587209 587209 Lackforth, John, of Marham, butcher 0
4062129 2046741 2046741 defendant Lackforth John butcher 587209 587209 Lackforth, John, of Marham, butcher 0
4063957 2047389 2047389 defendant Vincent John, senior husbandman 587209 587209 Vincent, John, senior, of Marham, husbandman 0
4063959 2047390 2047390 defendant Vyncent Thomas, senior husbandman 587209 587209 Vyncent, Thomas, senior, of Marham, husbandman 0
4064273 2047497 2047497 defendant Barber John   587209 587209 Barber, John, of Marham, shepherd 1
4068676 2049086 2049086 defendant Cheston Robert husbandman 587209 587209 Cheston, Robert, of Marham, husbandman 0
4075043 2051375 2051375 defendant Crome Robert husbandman 587209 587209 Crome, Robert, of Marham, husbandman 0
4079166 2052851 2052851 defendant Lackford John, junior butcher 587209 587209 Lackford, John, junior, of Marham, butcher 0
4084212 2054626 2054626 defendant Vyncent John, senior husbandman 587209 587209 Vyncent, John, senior, of Marham, husbandman 2
4084593 2054765 2054765 defendant Vyncent John, senior husbandman 587209 587209 Vyncent, John, senior, of Marham, husbandman 3
4092070 2057460 2057460 defendant Chambers Thomas husbandman 587209 587209 Chambers, Thomas, of Marham, husbandman 2
4092075 2057462 2057462 defendant Chambers Thomas husbandman 587209 587209 Chambers, Thomas, of Marham, husbandman 0
4093361 2057942 2057942 defendant Vyncent John, senior yeoman 587209 587209 Vyncent, John, senior, of Marham, yeoman 0
4097053 2059269 2059269 defendant Crome Robert husbandman 587209 587209 Crome, Robert, of Marham, husbandman 0
4097054 2059269 2059269 defendant Crome John husbandman 587209 587209 Crome, John, of Marham, husbandman 1
4097055 2059269 2059269 defendant Brooke Robert husbandman 587209 587209 Brooke, Robert, of Marham, husbandman 2
4115434 2065809 2065809 defendant Gamblynge Thomas husbandman 587209 587209 Gamblynge, Thomas, of Marham, husbandman 0
4115435 2065809 2065809 defendant Loveden John, senior husbandman 587209 587209 Loveden, John, senior, of Marham, husbandman 1
4115436 2065809 2065809 defendant Loveden John, junior husbandman 587209 587209 Loveden, John, junior, of Marham, husbandman 2
4115437 2065809 2065809 defendant Blacke John husbandman 587209 587209 Blacke, John, of Marham, husbandman 3
4118504 2066909 2066909 defendant Hardye Thomas yeoman 587209 587209 Hardye, Thomas, of Marham, yeoman 0
4122203 2068245 2068245 defendant Gyles John husbandman 587209 587209 Gyles, John, of Marham, husbandman 1
4122700 2068413 2068413 defendant Tanne Thomas shoemaker 587209 587209 Tanne, Thomas, of Marham, shoemaker 0
4133590 2072347 2072347 defendant Okelye Roger, junior husbandman 587209 587209 Okelye, Roger, junior, of Marham, husbandman 0
4134463 2072657 2072657 defendant Gryffyn or Gryffyth William laborer 587209 587209 Gryffyn or Gryffyth, William, of Marham, laborer 1
4136892 2073544 2073544 defendant Smyth John thatcher 587209 587209 Smyth, John, of Marham, thatcher 1
4138745 2074226 2074226 defendant Smyth John husbandman 587209 587209 Smyth, John, of Marham, husbandman 0
4161764 2082182 2082182 defendant Lackforth John yeoman 587209 587209 Lackforth, John, of Marham, yeoman 0
4167796 2084226 2084226 defendant Chambers Thomas shoemaker 587209 587209 Chambers, Thomas, of Marham, shoemaker 0
4185501 2090438 2090438 defendant Bradfeild Thomas laborer 587209 587209 Bradfeild, Thomas, of Marham, laborer 1
4204821 2097229 2097229 defendant Vyncent Thomas, senior husbandman 587209 587209 Vyncent, Thomas, senior, of Marham, husbandman 0
4204822 2097229 2097229 defendant Vyncent John, senior husbandman 587209 587209 Vyncent, John, senior, of Marham, husbandman 1
4205402 2097442 2097442 defendant Maunsell John husbandman 587209 587209 Maunsell, John, of Marham, husbandman 0
4205403 2097442 2097442 defendant Clunny John laborer 587209 587209 Clunny, John, of Marham, laborer 1
4205404 2097442 2097442 defendant Maunsell John laborer 587209 587209 Maunsell, John, of Marham, laborer 2
4212753 2100001 2100001 defendant Lackford John yeoman 587209 587209 Lackford, John, of Marham, yeoman 1
4226763 2104834 2104834 defendant Jarye Robert yeoman 587209 587209 Jarye, Robert, of Marham, yeoman 0
4226825 2104854 2104854 defendant Whitfield Richard tailor 587209 587209 Whitfield, Richard, of Marham, tailor 2
4236162 2108217 2108217 defendant Jary Richard, junior (legal representative) 587209 587209 Jary, Richard, junior, of Marham, husbandman, administratrix of 0
4236163 2108217 2108217 defendant Harye Elizabeth widow 587209 587209 Harye Elizabeth, of Marham, widow 1
4239849 2109573 2109573 defendant Lackforth John gent 587209 587209 Lackforth, John, of Marham, gent 0
4241185 2110040 2110040 defendant Lackford John yeoman 587209 587209 Lackford, John, of Marham, yeoman 0
4241619 2110183 2110183 defendant Lackford John yeoman 587209 587209 Lackford, John, of Marham, yeoman 0
4244075 2110999 2110999 defendant Vincent Thomas husbandman 587209 587209 Vincent, Thomas, of Marham, husbandman 2
4244628 2111188 2111188 defendant Jarie Robert husbandman 587209 587209 Jarie, Robert, of Marham, husbandman 0
4244629 2111188 2111188 defendant Mowsdale Robert yeoman 587209 587209 Mowsdale, Robert, of Marham, yeoman 1
4246079 2111669 2111669 defendant Lackorth John yeoman 587209 587209 Lackorth, John, of Marham, yeoman 0
4246080 2111669 2111669 defendant Bayes William husbandman 587209 587209 Bayes, William, of Marham, husbandman 1
4246096 2111674 2111674 defendant Lackforth John yeoman 587209 587209 Lackforth, John, of Marham, yeoman 0
4246097 2111674 2111674 defendant Bayes William husbandman 587209 587209 Bayes, William, of Marham, 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);