home / cp40x

names

185 rows where place_id = 590396

✎ 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
3601063 1867999 1867999 defendant Lambe Thomas gent 590396 590396 Lambe, Thomas, of Wymondham, Norf, gent 1
3607064 1869874 1869874 defendant Pyttys Richard butcher 590396 590396 Pyttys, Richard, of Wymondham, Norf, butcher 0
3607068 1869875 1869875 defendant Halle alias Payn Richard yeoman or barker 590396 590396 Halle alias Payn, Richard, of Wymondham, Norf, yeoman or barker 0
3664112 1914726 1914726 defendant Cheseman Thomas smith 590396 590396 Cheseman, Thomas, of wymondham, Norf, smith 4
3665497 1915160 1915160 plaintiff Standisshe Edward yeoman 590396 590396 Standisshe, Edward, of Wymondham, Norf, yeoman 0
3684087 1921158 1921158 defendant Knyvet Edward esq 590396 590396 Knyvet, Edward, of Wymondham, Norf, esq 0
3723113 1933494 1933494 defendant Sygar John chandler 590396 590396 Sygar, John, of Wymondham, Norf, chandler 2
3726917 1934684 1934684 defendant Beale Thomas yeoman 590396 590396 Beale, Thomas, of Wymondham, Norf, yeoman 4
3743595 1939873 1939873 defendant Yarham William miller 590396 590396 Yarham, William, of Wymondham, Norf, miller 1
3750717 1942148 1942148 defendant Hovell John yeoman 590396 590396 Hovell, John, of Wymondham, Norf, yeoman 0
3754842 1943468 1943468 defendant Beale William yeoman 590396 590396 Beale, William, of Wymondham, Norf, yeoman 0
3808457 1960523 1960523 defendant Inglysshe Richard   590396 590396 Inglysshe, Richard, of Wymondham, Norf, mason 0
3836332 1969270 1969270 defendant Gysborne Florence mercer 590396 590396 Gysborne, Florence, of Wymondham, Norf, mercer 4
3876168 1982276 1982276 defendant Benslen Thomas husbandman 590396 590396 Benslen, Thomas, of Wymondham, Norf, husbandman 1
3927727 1999611 1999611 defendant Tolye Robert yeoman 590396 590396 Tolye, Robert, of Wymondham, Norf, yeoman 1
3928040 1999712 1999712 defendant Tolye Robert yeoman 590396 590396 Tolye, Robert, of Wymondham, Norf, yeoman 1
3935907 2002324 2002324 defendant Elsyng Robert gent 590396 590396 Elsyng, Robert, of Wymondham, Norf, gent 0
3937716 2002948 2002948 defendant Haste Thomas gent 590396 590396 Haste, Thomas, of Wymondham, Norf, gent 0
3951687 2007645 2007645 defendant Chapman Thomas gent 590396 590396 Chapman, Thomas, of Wymondham, Norf, gent 0
3970056 2014123 2014123 defendant Neave William butcher 590396 590396 Neave, William, of Wymondham, Norf, butcher 1
3970059 2014124 2014124 defendant Neave William butcher 590396 590396 Neave, William, of Wymondham, Norf, butcher 1
3970558 2014300 2014300 defendant Burrell Thomas yeoman 590396 590396 Burrell, Thomas, of Wymondham, Norf, yeoman 1
3970567 2014301 2014301 defendant Rawse John yeoman 590396 590396 Rawse, John, of Wymondham, Norf, yeoman 2
3970582 2014303 2014303 defendant Knyght alias Kett Valentine yeoman 590396 590396 Knyght alias Kett, Valentine, of Wymondham, Norf, yeoman 0
3978379 2017023 2017023 defendant Woodcock Thomas beer brewer 590396 590396 Woodcock, Thomas, of Wymondham, Norf, beer brewer 0
3984163 2019101 2019101 defendant Michell William innholder 590396 590396 Michell, William, of Wymondham, Norf, innholder 0
3984783 2019314 2019314 defendant Graye Thomas yeoman 590396 590396 Graye, Thomas, of Wymondham, Norf, yeoman 1
3984787 2019315 2019315 defendant Gaye Thomas yeoman 590396 590396 Gaye, Thomas, of Wymondham, Norf, yeoman 1
3993972 2022595 2022595 defendant Gedney John chapman 590396 590396 Gedney, John, of Wymondham, Norf, chapman 0
3994486 2022776 2022776 defendant Haste Thomas gent 590396 590396 Haste, Thomas, of Wymondham, Norf, gent 0
4005796 2026850 2026850 defendant Wynsdon Thomas gent 590396 590396 Wynsdon, Thomas, of Wymondham, Norf, gent 0
4008544 2027819 2027819 defendant Dalbye Edward cordwainer 590396 590396 Dalbye, Edward, of Wymondham, Norf, cordwainer 3
4013431 2029537 2029537 defendant Allyn David barker 590396 590396 Allyn, David, of Wymondham, Norf, barker 0
4021047 2032251 2032251 defendant More John cordwainer 590396 590396 More, John, of Wymondham, Norf, cordwainer 0
4021051 2032252 2032252 defendant More John cordwainer 590396 590396 More, John, of Wymondham, Norf, cordwainer 0
4027270 2034400 2034400 defendant Flynte Robert gent 590396 590396 Flynte, Robert, of Wymondham, Norf, gent 0
4027272 2034401 2034401 defendant Flynte Robert gent 590396 590396 Flynte, Robert, of Wymondham, Norf, gent 0
4078000 2052435 2052435 defendant Wyseman Robert yeoman 590396 590396 Wyseman, Robert, of Wymondham, Norf, yeoman 1
4078866 2052737 2052737 defendant Haste Thomas gent 590396 590396 Haste, Thomas, of Wymondham, Norf, gent 0
4079805 2053077 2053077 defendant Carter Robert yeoman 590396 590396 Carter, Robert, of Wymondham, Norf, yeoman 0
4089069 2056384 2056384 defendant Nevell Christopher yeoman 590396 590396 Nevell, Christopher, of Wymondham, Norf, yeoman 1
4093687 2058067 2058067 defendant Garrede Robert tailor 590396 590396 Garrede, Robert, of Wymondham, Norf, tailor 1
4101793 2060951 2060951 defendant Haste Thomas gent 590396 590396 Haste, Thomas, of Wymondham, Norf, gent 0
4104440 2061873 2061873 defendant Hast Thomas gent 590396 590396 Hast, Thomas, of Wymondham, Norf, gent 0
4104493 2061890 2061890 defendant Francys John butcher 590396 590396 Francys, John, of Wymondham, Norf, butcher 0
4106149 2062494 2062494 defendant Haste Thomas gent 590396 590396 Haste, Thomas, of Wymondham, Norf, gent 0
4106547 2062629 2062629 defendant Appleyarde Philip esq 590396 590396 Appleyarde, Philip, of Wymondham, Norf, esq 0
4114315 2065403 2065403 defendant Haste Thomas gent 590396 590396 Haste, Thomas, of Wymondham, Norf, gent 0
4119822 2067378 2067378 defendant Wade Stephen tailor 590396 590396 Wade, Stephen, of Wymondham, Norf, tailor 2
4123658 2068764 2068764 defendant Woodcocke Robert husbandman 590396 590396 Woodcocke, Robert, of Wymondham, Norf, husbandman 0
4126223 2069670 2069670 defendant Knyght alias Kett Thomas yeoman 590396 590396 Knyght alias Kett, Thomas, of Wymondham, Norf, yeoman 1
4126549 2069781 2069781 defendant Cowper William bowyer 590396 590396 Cowper, William, of Wymondham, Norf, bowyer 0
4126947 2069930 2069930 defendant Randall Robert husbandman 590396 590396 Randall, Robert, of Wymondham, Norf, husbandman 0
4126949 2069931 2069931 defendant Randall Robert husbandman 590396 590396 Randall, Robert, of Wymondham, Norf, husbandman 0
4127613 2070167 2070167 defendant Haste Thomas gent 590396 590396 Haste, Thomas, of Wymondham, Norf, gent 0
4135879 2073163 2073163 defendant Randall Robert yeoman 590396 590396 Randall, Robert, of Wymondham, Norf, yeoman 0
4143770 2075981 2075981 defendant Venyll Ambrose (legal representative) 590396 590396 Venyll, Ambrose, of Wymondham, Norf, singleman, executors of 2
4148007 2077435 2077435 defendant Kett Valentine yeoman 590396 590396 Kett, Valentine, of Wymondham, Norf, yeoman 0
4182142 2089232 2089232 defendant Cooper William bowyer 590396 590396 Cooper, William, of Wymondham, Norf, bowyer 0
4188413 2091437 2091437 defendant Denny Firmus gent 590396 590396 Denny, Firmus, of Wymondham, Norf, gent 4
4194476 2093619 2093619 defendant Kett alias Knyght Francis gent 590396 590396 Kett alias Knyght, Francis, of Wymondham, Norf, gent 1
4215111 2100786 2100786 defendant Foster James gent 590396 590396 Foster, James, of Wymondham, Norf, gent 0
4215140 2100795 2100795 defendant Ensyng Francis gent 590396 590396 Ensyng, Francis, of Wymondham, Norf, gent 0
4217460 2101600 2101600 defendant Browne Richard gent 590396 590396 Browne, Richard, of Wymondham, Norf, gent 0
4253135 2114046 2114046 defendant Cleere Francis esq 590396 590396 Cleere, Francis, of Wymondham, Norf, esq 2
4276285 2121650 2121650 defendant Cullier Richard yeoman 590396 590396 Cullier, Richard, of Wymondham, Norf, yeoman 0
4276787 2121814 2121814 defendant Drake John husbandman 590396 590396 Drake, John, of Wymondham, Norf, husbandman 0
4276798 2121816 2121816 defendant Browne John tailor 590396 590396 Browne, John, of Wymondham, Norf, tailor 2
4286242 2125133 2125133 defendant Clare Thomas esq 590396 590396 Clare, Thomas, of Wymondham, Norf, esq 0
4292291 2127308 2127308 defendant Rookewood Thomas gent 590396 590396 Rookewood, Thomas, of Wymondham, Norf, gent 0
4293241 2127646 2127646 defendant Dyxon John (legal representative) 590396 590396 Dyxon, John, of Wymondham, Norf, gent, executors of 0
4294003 2127932 2127932 defendant Endynge Francis gent 590396 590396 Endynge, Francis, of Wymondham, Norf, gent 0
4294006 2127932 2127932 defendant Southwell Miles gent 590396 590396 Southwell, Miles, of Wymondham, Norf, gent 3
4306529 2132422 2132422 defendant Okes Robert saddler 590396 590396 Okes, Robert, of Wymondham, Norf, saddler 3
4313699 2134898 2134898 defendant Clare Henry esq 590396 590396 Clare, Henry, of Wymondham, Norf, esq 0
4316010 2135711 2135711 defendant Kett Thomas yeoman 590396 590396 Kett, Thomas, of Wymondham, Norf, yeoman 0
4325646 2138955 2138955 defendant Ensynge Francis gent 590396 590396 Ensynge, Francis, of Wymondham, Norf, gent 0
4337028 2142674 2142674 defendant Spanye or Spavye Katherine spinster 590396 590396 Spanye or Spavye, Katherine, of Wymondham, Norf, spinster 3
4337844 2142984 2142984 defendant Dynne John yeoman 590396 590396 Dynne, John, of Wymondham, Norf, yeoman 0
4337870 2142989 2142989 defendant Costerton Lawrence yeoman 590396 590396 Costerton, Lawrence, of Wymondham, Norf, yeoman 0
4343119 2144865 2144865 defendant Turpyn William draper 590396 590396 Turpyn, William, of Wymondham, Norf, draper 0
4362583 2151671 2151671 defendant Ryngwood Margaret widow 590396 590396 Ryngwood, Margaret, of Wymondham, Norf, widow 1
4367144 2153304 2153304 defendant Haste Thomas gent 590396 590396 Haste, Thomas, of Wymondham, Norf, gent 0
4379123 2157615 2157615 defendant Symondes John, senior yeoman 590396 590396 Symondes, John, senior, of Wymondham, Norf, yeoman 0
4385019 2159680 2159680 defendant Foster James yeoman 590396 590396 Foster, James, of Wymondham, Norf, yeoman 1
4387305 2160402 2160402 defendant Gosse Geoffrey yeoman 590396 590396 Gosse, Geoffrey, of Wymondham, Norf, yeoman 1
4393432 2162404 2162404 defendant Male Robert, senior yeoman 590396 590396 Male, Robert, senior, of Wymondham, Norf, yeoman 2
4394864 2162868 2162868 defendant Warner Robert gent 590396 590396 Warner, Robert, of Wymondham, Norf, gent, son of William Warner, of Wymondham, gent 0
4395831 2163185 2163185 defendant Page James baker 590396 590396 Page, James, of Wymondham, Norf, baker 2
4399269 2164340 2164340 defendant Drake Geoffrey miller 590396 590396 Drake, Geoffrey, of Wymondham, Norf, miller 2
4399274 2164341 2164341 defendant Gedney John innkeeper 590396 590396 Gedney, John, of Wymondham, Norf, innkeeper 2
4669416 2256142 2256142 defendant Whytman Simon yeoman 590396 590396 Whytman, Simon, of Wymondham, Norf, yeoman 3
4670534 2256459 2256459 defendant Bate Thomas   590396 590396 Bate, Thomas, of Wymondham, Norf, mason 2
4676970 2258415 2258415 defendant Bate Thomas   590396 590396 Bate, Thomas, of Wymondham, Norf, mason 3
4682628 2260183 2260183 defendant Boteler Thomas yeoman 590396 590396 Boteler, Thomas, of Wymondham, Norf, yeoman 1
4683237 2260369 2260369 defendant Herenede John tailor 590396 590396 Herenede, John, of Wymondham, Norf, tailor 2
4683270 2260373 2260373 defendant Herenode John tailor 590396 590396 Herenode, John, of Wymondham, Norf, tailor 1
4684315 2260697 2260697 defendant Hapton John yeoman 590396 590396 Hapton, John, of Wymondham, Norf, yeoman 1
4699160 2265200 2265200 defendant Newehagh John baker 590396 590396 Newehagh, John, of Wymondham, Norf, baker 0
4701122 2265758 2265758 defendant Motte William husbandman 590396 590396 Motte, William, of Wymondham, Norf, husbandman 0

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);
Powered by Datasette · Queries took 22.946ms