names

203 rows where place_id = 595972

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3622607 1874601 1874601 defendant Langton John glover 595972 595972 Langton, John, of Stamford, glover 0
3654969 1911816 1911816 defendant Blowfeld John butcher 595972 595972 Blowfeld, John, of Stamford, butcher 0
3698852 1925857 1925857 defendant Witton Mathew glover 595972 595972 Witton, Mathew, of Stamford, glover 5
3699384 1926027 1926027 defendant Maydewell Thomas cordwainer 595972 595972 Maydewell, Thomas, of Stamford, cordwainer 0
3743887 1939973 1939973 plaintiff Wytton Mathew   595972 595972 Wytton, Mathew, of Stamford 0
3746003 1940656 1940656 defendant Tyndale Philip gent 595972 595972 Tyndale, Philip, of Stamford, gent 0
3791603 1955213 1955213 defendant Chiselden William mercer 595972 595972 Chiselden, William, of Stamford, mercer 0
3792145 1955398 1955398 defendant Englysh John   595972 595972 Englysh, John, of Stamford, coverlet weaver 0
3800333 1958022 1958022 plaintiff Ley John mercer 595972 595972 Ley, John, of Stamford, mercer 0
3804853 1959463 1959463 defendant Hogeson Thomas draper 595972 595972 Hogeson, Thomas, of Stamford, draper 0
3804854 1959463 1959463 defendant Jakson Thomas shoemaker 595972 595972 Jakson, Thomas, of Stamford, shoemaker 1
3804855 1959463 1959463 defendant Tomson Robert   595972 595972 Tomson, Robert, of Stamford, parish clerk 2
3804856 1959463 1959463 defendant Grene John pewterer 595972 595972 Grene, John, of Stamford, pewterer 3
3804857 1959463 1959463 defendant Marshall William husbandman 595972 595972 Marshall, William, of Stamford, husbandman 4
3804858 1959463 1959463 defendant Button William glover 595972 595972 Button, William, of Stamford, glover 5
3804859 1959463 1959463 defendant Jones William sherman 595972 595972 Jones, William, of Stamford, sherman 6
3804860 1959463 1959463 defendant Nutte Thomas glover 595972 595972 Nutte, Thomas, of Stamford, glover 7
3804861 1959463 1959463 defendant Wynwyke Robert draper 595972 595972 Wynwyke, Robert, of Stamford, draper 8
3804862 1959463 1959463 defendant Beryge William draper 595972 595972 Beryge, William, of Stamford, draper 9
3804863 1959463 1959463 defendant Rankell William glover 595972 595972 Rankell, William, of Stamford, glover 10
3805555 1959679 1959679 plaintiff Thomas John   595972 595972 Thomas, John, of Stamford, burgess 0
3805556 1959679 1959679 defendant Nutt Thomas glover 595972 595972 Nutt, Thomas, of Stamford, glover 0
3830815 1967521 1967521 plaintiff Ganno Andrew   595972 595972 Ganno, Andrew, of Stamford 0
3836155 1969222 1969222 defendant Smyth John cordwainer 595972 595972 Smyth, John, of Stamford, cordwainer 0
3858787 1976424 1976424 defendant Haryson James yeoman 595972 595972 Haryson, James, of Stamford, yeoman 0
3861707 1977378 1977378 plaintiff Ganno Andrew   595972 595972 Ganno, Andrew, of Stamford 0
3864174 1978207 1978207 defendant Austen Ambrose husbandman 595972 595972 Austen, Ambrose, of Stamford, husbandman 2
3870653 1980427 1980427 plaintiff Wytton Matthew (legal representative) 595972 595972 Wytton, Matthew, of Stamford, glover, executor of 0
3874628 1981734 1981734 defendant Levyng William yeoman 595972 595972 Levyng, William, of Stamford, yeoman 0
3874629 1981734 1981734 defendant Tomson Thomas yeoman 595972 595972 Tomson, Thomas, of Stamford, yeoman 1
3884379 1985044 1985044 plaintiff Wytton Matthew (legal representative) 595972 595972 Wytton, Matthew, of Stamford, executor of 0
3886692 1985804 1985804 defendant Raskell Christopher draper 595972 595972 Raskell, Christopher, of Stamford, draper 0
3889859 1986847 1986847 defendant Rychemond John yeoman 595972 595972 Rychemond, John, of Stamford, yeoman 1
3897977 1989531 1989531 plaintiff Wytton Matthew glover 595972 595972 Wytton, Matthew, of Stamford, glover 0
3905278 1992032 1992032 plaintiff Kayworth Richard mercer 595972 595972 Kayworth, Richard, of Stamford, mercer 0
3908951 1993287 1993287 defendant Canon John gent 595972 595972 (Canon, John, of Stamford, gent 1
3916861 1996003 1996003 defendant Croke Thomas innholder 595972 595972 Croke, Thomas, of Stamford, innholder 1
3916864 1996004 1996004 defendant Croke Thomas innholder 595972 595972 Croke, Thomas, of Stamford, innholder 1
3919866 1996976 1996976 defendant Bomested Alice widow 595972 595972 Bomested, Alice, of Stamford, widow 4
3932376 2001124 2001124 defendant Creche Gervase   595972 595972 Creche, Gervase, of Stamford, cord wainer 1
3932410 2001127 2001127 defendant Urtesfeld Anthony husbandman 595972 595972 Urtesfeld, Anthony, of Stamford, husbandman 3
3933688 2001558 2001558 defendant Gydney Tnomas chapman 595972 595972 Gydney, Tnomas, of Stamford, chapman 0
3935238 2002096 2002096 defendant Warren Thomas mercer 595972 595972 Warren, Thomas, of Stamford, mercer 0
3937437 2002855 2002855 defendant Hall Robert gent 595972 595972 Hall, Robert, of Stamford, gent 0
3937442 2002857 2002857 defendant Hall Robert gent 595972 595972 Hall, Robert, of Stamford, gent 0
3937464 2002866 2002866 plaintiff Oldenall John   595972 595972 Oldenall, John, of Stamford, inn holder 0
3937738 2002954 2002954 defendant Warryn Thomas chapman 595972 595972 Warryn, Thomas, of Stamford, chapman 0
3941352 2004114 2004114 defendant Warren Thomas mercer 595972 595972 Warren, Thomas, of Stamford, mercer 0
3941353 2004114 2004114 defendant Halyday William barber 595972 595972 Halyday, William, of Stamford, barber 1
3961913 2011262 2011262 plaintiff Wallpull Robert gent 595972 595972 Wallpull, Robert, of Stamford, gent 0
3977277 2016623 2016623 defendant Thomson William vintner 595972 595972 Thomson, William, of Stamford, vintner 0
3994265 2022701 2022701 defendant Elmes John gent 595972 595972 Elmes, John, of Stamford, gent 0
4009737 2028249 2028249 defendant Thomson William vintner 595972 595972 Thomson, William, of Stamford, vintner 0
4078308 2052542 2052542 defendant Yerwood Thomas yeoman 595972 595972 Yerwood, Thomas, of Stamford, yeoman 2
4091247 2057159 2057159 defendant Beale William gent 595972 595972 Beale, William, of Stamford, gent 0
4091248 2057159 2057159 defendant Beale Roger gent 595972 595972 Beale, Roger, of Stamford, gent 1
4096377 2059036 2059036 defendant Bealle Roger gent 595972 595972 Bealle, Roger, of Stamford, gent 0
4113798 2065218 2065218 defendant Deale Roger yeoman 595972 595972 Deale, Roger, of Stamford, or of Bowthby Paynell, Lincs, yeoman 0
4121979 2068162 2068162 defendant Milner Christopher painter 595972 595972 Milner, Christopher, of Stamford, painter 0
4133574 2072340 2072340 defendant Harropp alias Baker Geoffrey innkeeper 595972 595972 Harropp alias Baker, Geoffrey, of Stamford, innkeeper 0
4133576 2072341 2072341 defendant Harropp alias Baker Geoffrey innkeeper 595972 595972 Harropp alias Baker, Geoffrey, of Stamford, innkeeper 0
4143616 2075924 2075924 defendant Beale William yeoman 595972 595972 Beale, William, of Stamford, yeoman 1
4147491 2077265 2077265 defendant Vincent Robert gent 595972 595972 Vincent, Robert, of Stamford, gent 0
4190866 2092370 2092370 defendant Harruppe Geoffrey innholder 595972 595972 Harruppe, Geoffrey, of Stamford, innholder 0
4191246 2092503 2092503 defendant Harruppe Geoffrey innholder 595972 595972 Harruppe, Geoffrey, of Stamford, innholder 0
4209001 2098699 2098699 defendant Bennett Anne widow 595972 595972 Bennett, Anne, of Stamford, widow 0
4237405 2108676 2108676 defendant Jarman William yeoman 595972 595972 Jarman, William, of Stamford, yeoman 0
4237406 2108676 2108676 defendant Wilson William yeoman 595972 595972 Wilson, William, of Stamford, yeoman 1
4240097 2109661 2109661 defendant Pepper William husbandman 595972 595972 Pepper, William, of Stamford, husbandman 0
4248351 2112440 2112440 defendant Pepper William husbandman 595972 595972 Pepper, William, of Stamford, husbandman 0
4248353 2112441 2112441 defendant Pepper William husbandman 595972 595972 Pepper, William, of Stamford, husbandman 0
4253614 2114202 2114202 defendant Revell Robert vintner 595972 595972 Revell, Robert, of Stamford, vintner 0
4260941 2116620 2116620 defendant Cressey Edward gent 595972 595972 Cressey, Edward, of Stamford, gent 0
4272131 2120244 2120244 defendant Cressey Edward gent 595972 595972 Cressey, Edward, of Stamford, gent 0
4274642 2121074 2121074 defendant Butler Edward carpenter 595972 595972 Butler, Edward, of Stamford, carpenter 0
4276216 2121625 2121625 defendant Holland Thomas gent 595972 595972 Holland, Thomas, of Stamford, gent 0
4282172 2123666 2123666 defendant Kester John baker 595972 595972 Kester, John, of Stamford, baker 0
4282173 2123666 2123666 defendant Campinet Henry yeoman 595972 595972 Campinet, Henry, of Stamford, yeoman 1
4285996 2125044 2125044 defendant Bonnyfant Geoffrey yeoman 595972 595972 Bonnyfant, Geoffrey, of Stamford, yeoman 0
4290680 2126724 2126724 defendant Earle John yeoman 595972 595972 Earle, John, of Stamford, yeoman 0
4295354 2128425 2128425 defendant Harryson John innholder 595972 595972 Harryson, John, of Stamford, innholder 0
4295355 2128425 2128425 defendant Kester John baker 595972 595972 Kester, John, of Stamford, baker 1
4295361 2128427 2128427 defendant Clerke William tailor 595972 595972 Clerke, William, of Stamford, tailor 2
4299503 2129913 2129913 defendant Lynnye Lawrence (legal representative) 595972 595972 Lynnye, Lawrence, of Stamford, yeoman, executor of 0
4299504 2129913 2129913 defendant Burr Urian   595972 595972 Burr, Urian, of Stamford, mason 1
4299622 2129955 2129955 defendant Wilbore Robert weaver 595972 595972 Wilbore, Robert, of Stamford, weaver 0
4299623 2129955 2129955 defendant Colton Lewis shoemaker 595972 595972 Colton, Lewis, of Stamford, shoemaker 1
4299624 2129955 2129955 defendant Collington Robert butcher 595972 595972 Collington, Robert, of Stamford, butcher 2
4342490 2144646 2144646 defendant Allen John gent 595972 595972 Allen, John, of Stamford, gent 0
4342492 2144647 2144647 defendant Allen John gent 595972 595972 Allen, John, of Stamford, gent 0
4342538 2144663 2144663 defendant Shorthose Henry   595972 595972 Shorthose, Henry, of Stamford, purse maker 0
4353715 2148520 2148520 defendant Colton Lewis shoemaker 595972 595972 Colton, Lewis, of Stamford, shoemaker 0
4354172 2148688 2148688 defendant Holmes Christopher   595972 595972 Holmes, Christopher, of Stamford, collar maker 0
4354173 2148688 2148688 defendant Allen John yeoman 595972 595972 Allen, John, of Stamford, yeoman 1
4354174 2148688 2148688 defendant Leiffe John butcher 595972 595972 Leiffe John, of Stamford, butcher 2
4354176 2148689 2148689 defendant Ganne William yeoman 595972 595972 Ganne, William, of Stamford, yeoman 0
4354177 2148689 2148689 defendant Anderton Ralph yeoman 595972 595972 Anderton, Ralph, of Stamford, yeoman 1
4354181 2148690 2148690 defendant Colton Lewis shoemaker 595972 595972 Colton, Lewis, of Stamford, shoemaker 1
4354182 2148690 2148690 defendant Pitt John   595972 595972 Pitt, John, of Stamford, mason 2
4356478 2149494 2149494 defendant Earle John tailor 595972 595972 Earle, John, of Stamford, tailor 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);