names

196 rows where place_id = 596238

✎ 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
3623811 1874979 1874979 plaintiff Spryng Thomas clothmaker 596238 596238 Spryng, Thomas, of Suffolk, clothmaker 0
3851728 1974129 1974129 plaintiff Peryent George (legal representative) 596238 596238 Peryent, George, of Suffolk, gent, executors of 0
3904939 1991914 1991914 plaintiff Hutton Henry yeoman 596238 596238 Hutton, Henry, of Suffolk, yeoman 0
3962506 2011480 2011480 plaintiff Wetherbye Robert (legal representative) 596238 596238 Wetherbye, Robert, of Suffolk, gent, executor of 0
3985539 2019592 2019592 defendant Reynold Thomas gent 596238 596238 Reynold, Thomas, of Suffolk, gent 4
4029134 2035063 2035063 defendant Hennyngham Jane spinster 596238 596238 Hennyngham, Jane, of Suffolk, spinster 1
4045680 2040906 2040906 defendant Mark William clothier 596238 596238 Mark, William, of Suffolk, clothier 3
4191551 2092607 2092607 plaintiff Ballett Edward (legal representative) 596238 596238 Ballett, Edward, of Suffolk, yeoman, executrix of 0
4372225 2155132 2155132 defendant Harryson Richard gent 596238 596238 Harryson, Richard, of Suffolk, gent 1
4387354 2160419 2160419 defendant Bungey Robert gent 596238 596238 Bungey, Robert, of Suffolk, gent 2
4408401 2167384 2167384 defendant Springe John esq 596238 596238 Springe, John, of Suffolk, esq 0
4411222 2168339 2168339 defendant Higham Clement   596238 596238 Higham, Clement, of Suffolk, knight 1
4433883 2175358 2175358 defendant Holbrok Thomas de   596238 596238 Holbrok, Thomas de, of Suffolk 0
4438508 2181331 2181331 defendant Wykham Theobald   596238 596238 Wykham, Theobald, of Suffolk 1
4439392 2181586 2181586 defendant Carbonel Robert esq 596238 596238 Carbonel, Robert, of Suffolk, esq 1
4448561 2184477 2184477 defendant Weylond John   596238 596238 Weylond, John, of Suffolk 3
4451766 2185529 2185529 defendant Clopton William   596238 596238 Clopton, William, of Suffolk 1
4455552 2186741 2186741 defendant Spicer Richard   596238 596238 Spicer, Richard, of Suffolk 0
4457440 2187339 2187339 defendant Langham William   596238 596238 Langham, William, of Suffolk 0
4457442 2187340 2187340 defendant Langham William   596238 596238 Langham, William, of Suffolk 0
4457444 2187341 2187341 defendant Hoigham William   596238 596238 Hoigham, William, of Suffolk 0
4463881 2189381 2189381 defendant Carbonel Robert esq 596238 596238 Carbonel, Robert, of Suffolk, esq 1
4469317 2191076 2191076 defendant Carbonel Robert   596238 596238 Carbonel, Robert, of Suffolk 0
4476703 2193372 2193372 defendant Glemsford Geoffrey   596238 596238 Glemsford, Geoffrey, of Suffolk 0
4479813 2194348 2194348 plaintiff Kedynton Robert (legal representative) 596238 596238 Kedynton, Robert, of Suffolk, executors of 0
4480230 2194475 2194475 defendant Malcher Thomas   596238 596238 Malcher, Thomas, of Suffolk 0
4490172 2197643 2197643 defendant Barre Robert   596238 596238 Barre, Robert, of Suffolk 4
4490199 2197644 2197644 defendant Barre Roger   596238 596238 Barre, Roger, of Suffolk 4
4492624 2198396 2198396 defendant Hardeshull John   596238 596238 Hardeshull, John, of Suffolk 0
4496937 2199708 2199708 defendant Page William   596238 596238 Page, William, of Suffolk 1
4499424 2200471 2200471 defendant Perpount Thomas   596238 596238 Perpount, Thomas, of Suffolk 0
4501216 2200989 2200989 defendant Braunforde Stephen   596238 596238 Braunforde, Stephen, of Suffolk 0
4501822 2201168 2201168 defendant Michel Geoffrey   596238 596238 Michel, Geoffrey, of Suffolk 0
4501824 2201169 2201169 defendant Michel Geoffrey   596238 596238 Michel, Geoffrey, of Suffolk 0
4510494 2203745 2203745 defendant Wode John esq 596238 596238 Wode, John, of Suffolk, esq 1
4511316 2203984 2203984 defendant Drury Edmund clerk 596238 596238 Drury, Edmund, of Suffolk, clerk 0
4511602 2204079 2204079 defendant Waleys Robert   596238 596238 Waleys, Robert, of Suffolk 1
4518701 2206223 2206223 plaintiff Hildeburgh Thomas   596238 596238 Hildeburgh, Thomas, of Suffolk 2
4523283 2207607 2207607 defendant Perpount Thomas   596238 596238 Perpount, Thomas, of Suffolk 0
4529293 2209445 2209445 plaintiff Molcher Thomas   596238 596238 Molcher, Thomas, of Suffolk 0
4532528 2210438 2210438 defendant Hastyng William   596238 596238 Hastyng, William, of Suffolk 0
4537134 2211885 2211885 defendant Appilton John   596238 596238 Appilton, John, of Suffolk 4
4537140 2211886 2211886 defendant Appulton John   596238 596238 Appulton, John, of Suffolk 4
4544477 2214184 2214184 defendant Mascall Roger   596238 596238 Mascall, Roger, of Suffolk 0
4544850 2214309 2214309 defendant Hundelane Joan   596238 596238 Hundelane, Joan, of Suffolk 0
4547557 2215169 2215169 defendant Cogger John butcher 596238 596238 Cogger, John, of Suffolk, butcher 2
4553569 2217048 2217048 defendant Bekkyls Walter   596238 596238 Bekkyls, Walter, of Suffolk 2
4553603 2217053 2217053 defendant Bekkyls Walter   596238 596238 Bekkyls, Walter, of Suffolk 2
4555537 2217660 2217660 defendant Bigge John   596238 596238 Bigge, John, of Suffolk 6
4556524 2217975 2217975 defendant Ive Hugn   596238 596238 Ive, Hugn, of Suffolk 0
4558775 2218700 2218700 defendant Michell Geoffrey   596238 596238 Michell, Geoffrey, of Suffolk 0
4561296 2219484 2219484 defendant Crestede John esq 596238 596238 Crestede, John, of Suffolk, esq 3
4561302 2219485 2219485 defendant Crestede John esq 596238 596238 Crestede, John, of Suffolk, esq 3
4561502 2219530 2219530 defendant Apilton John   596238 596238 Apilton, John, of Suffolk 0
4561507 2219532 2219532 defendant Appulton (illegible)   596238 596238 Appulton, _, of Suffolk 1
4569632 2222083 2222083 plaintiff Weston John de   596238 596238 Weston, John de, of Suffolk 0
4569634 2222084 2222084 plaintiff Weston John de   596238 596238 Weston, John de, of Suffolk 0
4569845 2222139 2222139 defendant Huwet Thomas   596238 596238 Huwet, Thomas, of Suffolk 0
4573509 2223242 2223242 plaintiff Barry Edmund esq 596238 596238 Barry, Edmund, of Suffolk, esq 0
4573572 2223254 2223254 plaintiff Cavndyssh Roger   596238 596238 (Cavndyssh, Roger, of Suffolk, father of Margaret, formerly wife of Thomas 1
4573578 2223255 2223255 plaintiff Cavndyssh Roger   596238 596238 (Cavndyssh, Roger, of Suffolk, father of Margaret, formerly wife of Thomas 1
4573587 2223256 2223256 plaintiff Cavndyssh Roger   596238 596238 (Cavndyssh, Roger, of Suffolk, father of Margaret, formerly wife of Thomas 1
4574459 2223543 2223543 defendant Polstede John   596238 596238 Polstede, John, of Suffolk 0
4574870 2223668 2223668 plaintiff Bliaunt Simon   596238 596238 Bliaunt, Simon, of Suffolk 0
4574921 2223680 2223680 defendant Munchesey Thomas (legal representative) 596238 596238 Munchesey, Thomas, of Suffolk, esq, executors of 0
4574928 2223681 2223681 defendant Munchesy Thomas (legal representative) 596238 596238 Munchesy, Thomas, of Suffolk, esq, executors of 0
4577320 2224423 2224423 defendant Lone or Love Hugh   596238 596238 Lone or Love, Hugh, of Suffolk 0
4577323 2224423 2224423 defendant Rocheford John   596238 596238 Rocheford, John, of Suffolk 3
4579371 2225026 2225026 defendant Stanton John   596238 596238 Stanton, John, of Suffolk 0
4582692 2226027 2226027 defendant Leyre John   596238 596238 Leyre, John, of Suffolk 0
4582694 2226028 2226028 defendant Leyre John   596238 596238 Leyre, John, of Suffolk 0
4584023 2226421 2226421 defendant Pole Michael de la   596238 596238 Pole, Michael de la, of Suffolk 0
4584082 2226440 2226440 defendant Baron Robert   596238 596238 Baron, Robert, of Suffolk 1
4586305 2227131 2227131 defendant Peyton Robert de   596238 596238 Peyton, Robert de, of Suffolk 0
4586541 2227199 2227199 plaintiff Heyward Richard   596238 596238 Heyward, Richard, of Suffolk 0
4589447 2228072 2228072 defendant Criset Richard   596238 596238 Criset, Richard, of Suffolk 3
4592693 2229058 2229058 defendant Forster Simon   596238 596238 Forster, Simon, of Suffolk 0
4593001 2229125 2229125 defendant Depenham John   596238 596238 Depenham, John, of Suffolk 1
4594107 2229417 2229417 defendant Duk Robert   596238 596238 Duk, Robert, of Suffolk 0
4596196 2230065 2230065 defendant Bisshop John   596238 596238 Bisshop, John, of Suffolk 0
4597296 2230396 2230396 defendant Arunerger or Armiger William   596238 596238 Arunerger or Armiger, William, of Suffolk 0
4597305 2230397 2230397 defendant Arunger William   596238 596238 Arunger, William, of Suffolk 0
4600971 2231531 2231531 defendant Braham John   596238 596238 Braham, John, of Suffolk, knight 0
4602186 2231903 2231903 defendant Cosyn John clerk 596238 596238 Cosyn, John, of Suffolk, clerk 1
4602192 2231904 2231904 defendant Cosyn John clerk 596238 596238 Cosyn, John, of Suffolk, clerk 3
4605157 2232779 2232779 defendant Clyfton John esq 596238 596238 Clyfton, John, of Suffolk, esq 0
4606188 2233044 2233044 defendant Clyfton John esq 596238 596238 Clyfton, John, of Suffolk, esq 0
4606207 2233049 2233049 defendant Plomer William   596238 596238 Plomer, William, of Suffolk 0
4609273 2234003 2234003 defendant Cook Clement   596238 596238 Cook, Clement, of Suffolk 5
4612748 2235053 2235053 defendant Upton John   596238 596238 Upton, John, of Suffolk 2
4612752 2235054 2235054 defendant Upton John   596238 596238 Upton, John, of Suffolk 2
4616583 2236187 2236187 defendant Cook Thomas   596238 596238 Cook, Thomas, of Suffolk 0
4616588 2236189 2236189 defendant Cook Thomas   596238 596238 Cook, Thomas, of Suffolk 0
4627898 2239656 2239656 defendant Hunt Robert   596238 596238 Hunt, Robert, of Suffolk 2
4627904 2239657 2239657 defendant Hunt Robert   596238 596238 Hunt, Robert, of Suffolk 2
4630212 2240360 2240360 defendant Hunte Thomas   596238 596238 Hunte, Thomas, of Suffolk 1
4632397 2241021 2241021 defendant Rougton Edmund   596238 596238 Rougton, Edmund, of Suffolk 0
4632402 2241022 2241022 defendant Rougton Edmund   596238 596238 Rougton, Edmund, of Suffolk 0
4633782 2241418 2241418 defendant Burys John de   596238 596238 Burys, John de, of Suffolk 2
4636210 2242157 2242157 defendant Ade John   596238 596238 Ade, John, of Suffolk 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);