names

170 rows where place_id = 590750

✎ 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
3602186 1868350 1868350 defendant Hagon Simon husbandman 590750 590750 Hagon, Simon, of Wyveton, husbandman 1
3602187 1868350 1868350 defendant Rudham Edward husbandman 590750 590750 Rudham, Edward, of Wyveton, husbandman 2
3602528 1868451 1868451 defendant Stele James yeoman 590750 590750 Stele, James, of Wyveton, yeoman 0
3602530 1868451 1868451 defendant Rudham Edward yeoman 590750 590750 Rudham, Edward, of Wyveton, yeoman 2
3604974 1869218 1869218 defendant Quarles William yeoman 590750 590750 Quarles, William, of Wyveton, yeoman 0
3604975 1869218 1869218 defendant Hagon Simon yeoman 590750 590750 Hagon, Simon, of Wyveton, yeoman 1
3604977 1869218 1869218 defendant Stele James yeoman 590750 590750 Stele, James, of Wyveton, yeoman 3
3604978 1869218 1869218 defendant Lawes Edmund yeoman 590750 590750 Lawes, Edmund, of Wyveton, yeoman 4
3723443 1933600 1933600 defendant Greneway John yeoman 590750 590750 Greneway, John, of Wyveton, yeoman 0
3765329 1946819 1946819 plaintiff Kyngys John merchant or yeoman 590750 590750 Kyngys, John, of Wyveton, merchant or yeoman 0
3777310 1950647 1950647 defendant Aimes Robert cooper 590750 590750 Aimes, Robert, of Wyveton, cooper 1
3792811 1955602 1955602 defendant Dalle Thomas yeoman 590750 590750 (Dalle, Thomas, of Wyveton, yeoman 1
3815011 1962616 1962616 plaintiff Grenewey John (legal representative) 590750 590750 Grenewey, John, of Wyveton merchant, executors of 0
3860193 1976903 1976903 defendant Spenser James mariner 590750 590750 Spenser, James, of Wyveton, mariner 1
3914909 1995335 1995335 defendant Dey John, junior merchant 590750 590750 Dey, John, junior, of Wyveton, merchant 0
3915556 1995571 1995571 defendant Dey John, junior merchant 590750 590750 Dey, John, junior, of Wyveton, merchant 0
3918300 1996457 1996457 defendant Dey John, junior merchant 590750 590750 Dey, John, junior, of Wyveton, merchant 0
3918301 1996457 1996457 defendant Dey John, senior yeoman 590750 590750 Dey, John, senior, of Wyveton, yeoman 1
3918451 1996500 1996500 defendant Dey John, junior merchant 590750 590750 Dey, John, junior, of Wyveton, merchant 0
3918477 1996509 1996509 defendant Dey John, senior yeoman 590750 590750 Dey, John, senior, of Wyveton, yeoman 0
3918626 1996555 1996555 defendant Hales John raffman 590750 590750 Hales, John, of Wyveton, raffman 3
3919269 1996775 1996775 defendant Haylys John merchant 590750 590750 Haylys, John, of Wyveton, merchant 0
3919270 1996775 1996775 defendant Wyllys Nicholas mariner 590750 590750 Wyllys, Nicholas, of Wyveton, mariner 1
3927782 1999630 1999630 defendant Dey Cecilia widow 590750 590750 Dey, Cecilia, of Wyveton, widow 1
3972635 2015002 2015002 defendant Hethe John miller 590750 590750 Hethe, John, of Wyveton, miller 0
3974698 2015719 2015719 defendant Buntyng Agnes widow 590750 590750 Buntyng, Agnes, of Wyveton, widow 0
3974701 2015719 2015719 defendant Spencer Margaret widow 590750 590750 Spencer, Margaret, of Wyveton, widow 3
3974702 2015719 2015719 defendant Woodrowe Elizabeth widow 590750 590750 Woodrowe, Elizabeth, of Wyveton, widow 4
3974703 2015719 2015719 defendant Hayles or Hayler John mariner 590750 590750 Hayles or Hayler, John, of Wyveton, mariner 5
3987885 2020412 2020412 defendant Thurloo Christopher mariner 590750 590750 Thurloo, Christopher, of Wyveton, mariner 0
3988095 2020486 2020486 defendant Thyrloo Christopher mariner 590750 590750 Thyrloo, Christopher, of Wyveton, mariner 0
4002004 2025495 2025495 defendant Maleham John baker 590750 590750 Maleham, John, of Wyveton, baker 0
4005700 2026812 2026812 plaintiff Kyrrye George yeoman 590750 590750 Kyrrye, George, of Wyveton, yeoman 0
4005702 2026813 2026813 plaintiff Kyrrye George yeoman 590750 590750 Kyrrye, George, of Wyveton, yeoman 0
4011092 2028740 2028740 defendant Buntyng Edmund mariner 590750 590750 Buntyng, Edmund, of Wyveton, mariner 2
4040490 2039091 2039091 defendant Bysshope Richard   590750 590750 Bysshope, Richard, of Wyveton, gent, administrators of 0
4062762 2046982 2046982 defendant Crome Robert clerk 590750 590750 Crome, Robert, of Wyveton, clerk 2
4064601 2047622 2047622 plaintiff Gynne Hugh yeoman 590750 590750 Gynne, Hugh, of Wyveton, yeoman 0
4144126 2076107 2076107 defendant Buntinge Edmund   590750 590750 Buntinge, Edmund, of Wyveton, rope maker 0
4144129 2076108 2076108 defendant Buntynge Edmund   590750 590750 Buntynge, Edmund, of Wyveton, rope maker 0
4163968 2082926 2082926 defendant Bryant Arthur joiner 590750 590750 Bryant, Arthur, of Wyveton,joiner 3
4179099 2088166 2088166 defendant Smythe John yeoman 590750 590750 Smythe, John, of Wyveton, yeoman 0
4196671 2094382 2094382 defendant Longstye Miles   590750 590750 Longstye, Miles, of Wyveton, rope maker 0
4196672 2094382 2094382 defendant Bussoppe Roger   590750 590750 Bussoppe, Roger, of Wyveton, shepherd 1
4212785 2100009 2100009 defendant Skottowe John merchant 590750 590750 Skottowe, John, of Wyveton, yeoman, or of Kings Lynn, merchant 0
4218734 2102055 2102055 defendant Sherwood Robert   590750 590750 Sherwood, Robert, of Wyveton, ship master 1
4221950 2103171 2103171 defendant Brighte Simon yeoman 590750 590750 Brighte, Simon, of Wyveton, yeoman 1
4229620 2105846 2105846 defendant Smyth Robert mariner 590750 590750 Smyth, Robert, of Wyveton, mariner 0
4229621 2105846 2105846 defendant Clipwell Thomas cooper 590750 590750 Clipwell, Thomas, of Wyveton, cooper 1
4229622 2105846 2105846 defendant Sherwood Robert mariner 590750 590750 Sherwood, Robert, of Wyveton, mariner 2
4246579 2111831 2111831 defendant Gynne Hugh yeoman 590750 590750 Gynne, Hugh, of Wyveton, yeoman 0
4246583 2111832 2111832 defendant Gynne Hugh yeoman 590750 590750 Gynne, Hugh, of Wyveton, yeoman 0
4246724 2111883 2111883 defendant Smyth Robert mariner 590750 590750 Smyth, Robert, of Wyveton, mariner 0
4246725 2111883 2111883 defendant Clypwell Thomas cooper 590750 590750 Clypwell, Thomas, of Wyveton, cooper 1
4246726 2111883 2111883 defendant Sherwood Robert mariner 590750 590750 Sherwood, Robert, of Wyveton, mariner 2
4247043 2111986 2111986 defendant Graye James mariner 590750 590750 Graye, James, of Wyveton, mariner 1
4247044 2111986 2111986 defendant Smyth John yeoman 590750 590750 Smyth, John, of Wyveton, yeoman 2
4247048 2111987 2111987 defendant Graye James yeoman 590750 590750 Graye, James, of Wyveton, yeoman 1
4247049 2111987 2111987 defendant Smyth John yeoman 590750 590750 Smyth, John, of Wyveton, yeoman 2
4247635 2112190 2112190 defendant Brighte Simon yeoman 590750 590750 Brighte, Simon, of Wyveton, yeoman 1
4251345 2113429 2113429 defendant Clypwell Thomas, senior cooper 590750 590750 Clypwell, Thomas, senior, of Wyveton, cooper 1
4251346 2113429 2113429 defendant Sherwood Robert mariner 590750 590750 Sherwood, Robert, of Wyveton, mariner 2
4251347 2113429 2113429 defendant Smyth James (legal representative) 590750 590750 Smyth, James, of Wyveton, mariner, executrix of 3
4251348 2113429 2113429 defendant Smyth Mary widow 590750 590750 Smyth, Mary, of Wyveton, widow 4
4252565 2113848 2113848 defendant Clypwell Thomas cooper 590750 590750 Clypwell, Thomas, of Wyveton, cooper 0
4252566 2113848 2113848 defendant Chapman Thomas yeoman 590750 590750 Chapman, Thomas, of Wyveton, yeoman 1
4266157 2118318 2118318 defendant Jackson William mariner 590750 590750 Jackson, William, of Wyveton, mariner 2
4280984 2123250 2123250 defendant Poditche John, senior vintner 590750 590750 Poditche, John, senior, of Wyveton, vintner 3
4289993 2126486 2126486 defendant Clypwell Thomas cooper 590750 590750 Clypwell, Thomas, of Wyveton, cooper 0
4311624 2134208 2134208 defendant Robynson James yeoman 590750 590750 (Robynson, James, of Wyveton, yeoman 1
4317975 2136398 2136398 defendant Graye James yeoman 590750 590750 Graye, James, of Wyveton, mariner, yeoman 0
4317977 2136398 2136398 defendant Smythe John yeoman 590750 590750 Smythe, John, of Wyveton, yeoman 2
4336252 2142413 2142413 defendant Thurlowe Hugh weaver 590750 590750 Thurlowe, Hugh, of Wyveton, weaver 0
4346118 2145896 2145896 defendant Clypwell Thomas cooper 590750 590750 Clypwell, Thomas, of Wyveton, or of Wystonne, cooper 0
4383485 2159184 2159184 defendant Clypwell Thomas cooper 590750 590750 Clypwell, Thomas, of Wyveton, cooper 3
4388634 2160836 2160836 defendant Ogle Anthony chapman 590750 590750 Ogle, Anthony, of Wyveton, chapman 2
4401379 2165058 2165058 defendant Clypwell Thomas cooper 590750 590750 Clypwell, Thomas, of Wyveton, cooper 3
4403679 2165805 2165805 defendant Robynson James yeoman 590750 590750 Robynson, James, of Wyveton, yeoman 1
4410809 2168204 2168204 defendant Powdytch John (legal representative) 590750 590750 Powdytch, John, of Wyveton, mariner, executor of 0
4410811 2168204 2168204 defendant Graye John mariner 590750 590750 Graye, John, of Wyveton, mariner 2
4439337 2181572 2181572 plaintiff Norton William de   590750 590750 (Norton, William de, of Wyveton, parson 1
4439342 2181573 2181573 plaintiff Norton William de   590750 590750 (Norton, William de, of Wyveton, parson 1
4441017 2182112 2182112 defendant Berneys Nicholas   590750 590750 Berneys, Nicholas, of Wyveton 0
4637850 2242609 2242609 defendant Derham Simon de   590750 590750 Derham, Simon de, of Wyveton 0
4637858 2242610 2242610 defendant Derham Simon de   590750 590750 Derham, Simon de, of Wyveton 0
4647830 2245430 2245430 defendant Derham Simon   590750 590750 Derham, Simon, of Wyveton 0
4649167 2245806 2245806 defendant Derham Simon   590750 590750 Derham, Simon, of Wyveton 0
4655408 2247584 2247584 defendant de Thoresby John yeoman 590750 590750 de Thoresby, John, of Wyveton, yeoman 0
4662840 2249839 2249839 defendant Dytton William yeoman 590750 590750 Dytton, William, of Wyveton, yeoman 2
4713470 2269534 2269534 defendant Bron John yeoman 590750 590750 Bron, John, of Wyveton, yeoman 7
4737808 2276930 2276930 defendant Lyderpole Thomas (legal representative) 590750 590750 Lyderpole, Thomas, of Wyveton, executors of 0
4740322 2277680 2277680 plaintiff atte Katherine   590750 590750 atte Katherine, of Wyveton, on their own account 1
4749647 2280383 2280383 defendant Bacon John esq 590750 590750 Bacon, John, of Wyveton, esq 0
4774595 2288041 2288041 defendant atte Brigge Katherine widow 590750 590750 atte Brigge, Katherine, of Wyveton, widow 0
4779913 2289718 2289718 plaintiff Bron John   590750 590750 Bron, John, of Wyveton 0
4779919 2289719 2289719 plaintiff Bron John   590750 590750 Bron, John, of Wyveton 0
4779987 2289742 2289742 plaintiff Broun John   590750 590750 Broun, John, of Wyveton 0
4779988 2289742 2289742 defendant Millere Mathew yeoman 590750 590750 Millere, Mathew, of Wyveton, yeoman 0
4782928 2290680 2290680 defendant Letherpool Katherine widow 590750 590750 Letherpool, Katherine, of Wyveton, widow 0
4801871 2296768 2296768 defendant Parker John yeoman 590750 590750 Parker, John, of Wyveton, yeoman 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);