names

116 rows where place_id = 591106

✎ 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
3603345 1868719 1868719 defendant Fytlyng John husbandman 591106 591106 Fytlyng, John, of Depeham, husbandman 4
3667484 1915772 1915772 defendant Vincent Robert, senior husbandman 591106 591106 Vincent, Robert, senior, of Depeham, husbandman 1
3667485 1915772 1915772 defendant Warde William miller 591106 591106 Warde, William, of Depeham, miller 2
3700096 1926262 1926262 defendant Grote Edmund yeoman 591106 591106 Grote, Edmund, of Depeham, yeoman 0
3703425 1927346 1927346 defendant Wylkyns John butcher 591106 591106 Wylkyns, John, of Depeham, butcher 1
3704972 1927847 1927847 defendant Cuttys Nicholas husbandman 591106 591106 Cuttys, Nicholas, of Depeham, husbandman 3
3718977 1932215 1932215 defendant Cutte Nicholas husbandman 591106 591106 Cutte, Nicholas, of Depeham, husbandman 1
3722372 1933257 1933257 defendant Wylkynson John husbandman 591106 591106 Wylkynson, John, of Depeham, husbandman 0
3728853 1935271 1935271 defendant Wright Richard husbandman 591106 591106 Wright, Richard, of Depeham, husbandman 2
3740811 1938983 1938983 defendant Kersey Thomas yeoman 591106 591106 Kersey, Thomas, of Depeham, yeoman 1
3745609 1940533 1940533 defendant Warde William miller 591106 591106 Warde, William, of Depeham, miller 0
3751445 1942369 1942369 defendant Grote Edmund husbandman 591106 591106 Grote, Edmund, of Depeham, husbandman 0
3766448 1947163 1947163 defendant Wright Richard miller 591106 591106 Wright, Richard, of Depeham, miller 4
3814995 1962609 1962609 defendant Wryght Richard husbandman 591106 591106 Wryght, Richard, of Depeham, husbandman 0
3822469 1964926 1964926 defendant Wright Richard miller 591106 591106 Wright, Richard, of Depeham, miller 0
3858817 1976437 1976437 defendant Rogers Thomas husbandman 591106 591106 Rogers, Thomas, of Depeham, husbandman 0
3858818 1976437 1976437 defendant Howlet Robert smith 591106 591106 Howlet, Robert, of Depeham, smith 1
3870312 1980322 1980322 plaintiff Wryght Richard yeoman 591106 591106 Wryght, Richard, of Depeham, yeoman 0
3897676 1989432 1989432 defendant Cuttys John husbandman 591106 591106 Cuttys, John, of Depeham, husbandman 0
3925640 1998886 1998886 defendant Fyssher William husbandman 591106 591106 Fyssher, William, of Depeham, husbandman 0
3928182 1999761 1999761 defendant Spilman Geoffrey husbandman 591106 591106 Spilman, Geoffrey, of Depeham, husbandman 0
3931528 2000845 2000845 defendant Boley Thomas gent 591106 591106 Boley, Thomas, of Depeham, gent 0
3943111 2004710 2004710 defendant Saman William husbandman 591106 591106 Saman, William, of Depeham, husbandman 0
3943112 2004710 2004710 defendant Layte John husbandman 591106 591106 Layte, John, of Depeham, husbandman 1
3943349 2004792 2004792 defendant Duffyld Henry husbandman 591106 591106 Duffyld, Henry, of Depeham, husbandman 0
3956212 2009241 2009241 defendant Shelton Anne widow 591106 591106 Shelton, Anne, of Depeham, widow 11
3958667 2010106 2010106 defendant Spylman Godfrey husbandman 591106 591106 Spylman, Godfrey, of Depeham, husbandman 0
3960476 2010763 2010763 defendant Shelton Mary widow 591106 591106 Shelton, Mary, of Depeham, widow 4
3963663 2011902 2011902 defendant Seman William yeoman 591106 591106 Seman, William, of Depeham, yeoman 0
3963665 2011902 2011902 defendant Kyllyngworth alias Josse or Joffe Robert miller 591106 591106 Kyllyngworth alias Josse or Joffe, Robert, of Depeham, miller 2
3965915 2012697 2012697 defendant Duffylde Henry yeoman 591106 591106 (Duffylde, Henry, of Depeham, or of Ellyngham, yeoman 1
3971988 2014761 2014761 defendant Knyght Robert yeoman 591106 591106 Knyght, Robert, of Depeham, laborer, or of Craneworth, yeoman 0
3976640 2016405 2016405 defendant Seman William yeoman 591106 591106 Seman, William, of Depeham, yeoman 0
3978797 2017163 2017163 defendant Sugar Walter husbandman 591106 591106 Sugar, Walter, of Depeham, husbandman 0
3982666 2018569 2018569 plaintiff Seman William yeoman 591106 591106 Seman, William, of Depeham, yeoman 0
3982669 2018570 2018570 defendant Knyght Robert yeoman 591106 591106 Knyght, Robert, of Depeham, husbandman, or of Craneworthe, yeoman 0
3991696 2021787 2021787 defendant Baxter Alexander husbandman 591106 591106 Baxter, Alexander, of Depeham, husbandman 0
3991879 2021852 2021852 defendant Amyas Thomas gent 591106 591106 Amyas, Thomas, of Depeham, gent 0
3991881 2021853 2021853 defendant Amyas Thomas gent 591106 591106 Amyas, Thomas, of Depeham, gent 0
3997709 2023938 2023938 defendant Kelyngworth alias Josse Robert miller 591106 591106 Kelyngworth alias Josse, Robert, of Depeham, miller 0
3997710 2023938 2023938 defendant Baxter Alexander miller 591106 591106 Baxter, Alexander, of Depeham, miller 1
4009668 2028227 2028227 defendant Godfrey Robert clerk 591106 591106 Godfrey, Robert, of Depeham, clerk 2
4009980 2028335 2028335 defendant Godfrey Robert clerk 591106 591106 Godfrey, Robert, of Depeham, clerk 2
4015028 2030074 2030074 defendant Parke Thomas husbandman 591106 591106 Parke, Thomas, of Depeham, husbandman 4
4026125 2033987 2033987 plaintiff Wyat John yeoman 591106 591106 Wyat, John, of Depeham, yeoman 1
4063377 2047190 2047190 defendant Cressey John husbandman 591106 591106 Cressey, John, of Depeham, husbandman 2
4064142 2047452 2047452 defendant Gyldersleve John clerk 591106 591106 Gyldersleve, John, of Depeham, clerk 0
4072546 2050487 2050487 defendant Gyldenslyve John clerk 591106 591106 Gyldenslyve, John, of Depeham, clerk 0
4076648 2051942 2051942 defendant Stacey John husbandman 591106 591106 Stacey, John, of Depeham, husbandman 11
4115667 2065889 2065889 defendant Colman John husbandman 591106 591106 Colman, John, of Depeham, husbandman 0
4195569 2093997 2093997 defendant Graves William clerk 591106 591106 Graves, William, of Depeham, clerk 1
4196039 2094165 2094165 defendant Davye Thomas husbandman 591106 591106 Davye, Thomas, of Depeham, husbandman 2
4213969 2100408 2100408 defendant Longe John husbandman 591106 591106 Longe, John, of Depeham, husbandman 0
4216808 2101375 2101375 defendant Carsey Martin husbandman 591106 591106 Carsey, Martin, of Depeham, husbandman 0
4216809 2101375 2101375 defendant Colman John husbandman 591106 591106 Colman, John, of Depeham, husbandman 1
4218693 2102038 2102038 defendant Webster Thomas yeoman 591106 591106 Webster, Thomas, of Depeham, or of Wicklewood, yeoman 0
4242185 2110379 2110379 defendant Colman John, senior husbandman 591106 591106 Colman, John, senior, of Depeham, husbandman 0
4242312 2110425 2110425 defendant Colman John, senior yeoman 591106 591106 Colman, John, senior, of Depeham, yeoman 0
4242313 2110425 2110425 defendant Colman John, junior yeoman 591106 591106 Colman, John, junior, of Depeham, yeoman 1
4259391 2116116 2116116 defendant Colman John, senior yeoman 591106 591106 Colman, John, senior, of Depeham, yeoman 0
4259393 2116116 2116116 defendant Carsey Thomas husbandman 591106 591106 Carsey Thomas, of Depeham, husbandman 2
4263307 2117392 2117392 defendant Wright John yeoman 591106 591106 Wright, John, of Depeham, yeoman 1
4269280 2119319 2119319 defendant Coleman John yeoman 591106 591106 Coleman, John, of Depeham, yeoman 3
4269282 2119320 2119320 defendant Howlett Henry blacksmith 591106 591106 Howlett, Henry, of Depeham, blacksmith 0
4269283 2119320 2119320 defendant Colman John, senior yeoman 591106 591106 Colman, John, senior, of Depeham, yeoman 1
4276511 2121724 2121724 defendant Howlett Robert husbandman 591106 591106 Howlett, Robert, of Depeham, husbandman 3
4286128 2125093 2125093 defendant Baxter Agnes widow 591106 591106 Baxter, Agnes, of Depeham, widow 1
4331792 2140927 2140927 defendant Wright John yeoman 591106 591106 Wright, John, of Depeham, yeoman 0
4335199 2142047 2142047 defendant Cowper Thomas yeoman 591106 591106 Cowper, Thomas, of Depeham, yeoman 0
4335201 2142048 2142048 defendant Browne Oliver husbandman 591106 591106 Browne, Oliver, of Depeham, husbandman 0
4624413 2238618 2238618 defendant Bell Richard   591106 591106 Bell, Richard, of Depeham 1
4626803 2239325 2239325 defendant Seeman Richard   591106 591106 Seeman, Richard, of Depeham 1
4626804 2239325 2239325 defendant Gurnay William   591106 591106 Gurnay, William, of Depeham 2
4691625 2262912 2262912 defendant Bury Richard husbandman 591106 591106 Bury, Richard, of Depeham, husbandman 0
4695125 2263966 2263966 defendant Putes John   591106 591106 Putes, John, of Depeham, wright 1
4756329 2282345 2282345 defendant Bury Richard de   591106 591106 Bury, Richard de, of Depeham, wright 1
4804391 2297556 2297556 defendant Dunnyng William husbandman 591106 591106 Dunnyng, William, of Depeham, husbandman 2
4892229 2324312 2324312 defendant Byker Richard laborer 591106 591106 Byker, Richard, of Depeham, laborer 6
4892939 2324521 2324521 defendant Crosse John gent 591106 591106 Crosse, John, of Depeham, gent 4
4897783 2325971 2325971 defendant Prat Thomas husbandman 591106 591106 Prat, Thomas, of Depeham, husbandman 0
4932289 2336500 2336500 defendant Company Edmund yeoman 591106 591106 Company, Edmund, of Depeham, yeoman 4
4943869 2340044 2340044 defendant Pyttys John carpenter 591106 591106 Pyttys, John, of Depeham, carpenter 0
5028465 2365197 2365197 defendant Porteman John husbandman 591106 591106 Porteman, John, of Depeham, husbandman 2
5071378 2377931 2377931 defendant Prath Thomas yeoman 591106 591106 Prath, Thomas, of Depeham, yeoman 2
5197886 2415118 2415118 defendant Walter John husbandman 591106 591106 Walter, John, of Depeham, husbandman 2
5315447 2449683 2449683 defendant Humfrey Richard yeoman 591106 591106 Humfrey, Richard, of Depeham, yeoman 0
5331416 2454474 2454474 defendant Colyour Richard yeoman 591106 591106 Colyour, Richard, of Depeham, yeoman 0
5333356 2455049 2455049 defendant Stacy Thomas husbandman 591106 591106 Stacy, Thomas, of Depeham, husbandman 1
5374531 2467638 2467638 defendant Fytleyn Thomas   591106 591106 Fytleyn, Thomas, of Depeham, yeoman, administrators of 1
5374532 2467638 2467638 defendant Fytlyng Edward husbandman 591106 591106 (Fytlyng, Edward, of Depeham, husbandman 2
5374533 2467638 2467638 defendant Fytlyng John, junior husbandman 591106 591106 Fytlyng, John, junior, of Depeham, husbandman 3
5378533 2468870 2468870 defendant Fytlyng Edward husbandman 591106 591106 Fytlyng, Edward, of Depeham, husbandman 2
5451346 2490279 2490279 defendant Marrys Stephen   591106 591106 Marrys, Stephen, of Depeham 2
5453603 2490969 2490969 defendant Fytlyng Edward husbandman 591106 591106 Fytlyng, Edward, of Depeham, husbandman 2
5453604 2490969 2490969 defendant Fytlyng John husbandman 591106 591106 Fytlyng, John, of Depeham, husbandman 3
5463384 2493957 2493957 defendant Marrys Stephen husbandman 591106 591106 Marrys, Stephen, of Depeham, husbandman 0
5463386 2493957 2493957 defendant Walter John, sen husbandman 591106 591106 Walter, John, sen, of Depeham, husbandman 2
5481550 2499409 2499409 defendant Roberdys John gent 591106 591106 Roberdys, John, of Depeham, gent 1
5481559 2499411 2499411 defendant Roberdys John gent 591106 591106 Roberdys, John, of Depeham, gent 1
5488533 2501457 2501457 defendant Fitlyng Thomas, junior husbandman 591106 591106 Fitlyng, Thomas, junior, of Depeham, 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);