names

100 rows where place_id = 589379

✎ 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
3597435 1866816 1866816 defendant Sengilton Edmund esq 589379 589379 Sengilton, Edmund, of Mendelesham, esq 0
3659427 1913209 1913209 defendant Neve John husbandman 589379 589379 Neve, John, of Mendelesham, husbandman 1
3683875 1921091 1921091 defendant Revet Robert husbandman 589379 589379 Revet, Robert, of Mendelesham, husbandman 4
3780546 1951646 1951646 defendant Syngilton William gent 589379 589379 Syngilton, William, of Mendelesham, gent 0
3860698 1977071 1977071 plaintiff Doncon William yeoman 589379 589379 Doncon, William, of Mendelesham, yeoman 0
3949175 2006779 2006779 defendant Ellynger "Sevetheus" husbandman 589379 589379 Ellynger, "Sevetheus", of Mendelesham, husbandman 0
4518742 2206236 2206236 defendant Palent John   589379 589379 Palent, John, of Mendelesham 2
4527942 2209018 2209018 defendant Provale John   589379 589379 Provale, John, of mendelesham 0
4539612 2212649 2212649 defendant Chapman William   589379 589379 Chapman, William, of Mendelesham 0
4551408 2216380 2216380 plaintiff Dunche Robert   589379 589379 Dunche, Robert, of Mendelesham 0
4551413 2216380 2216380 defendant Knyvet John   589379 589379 Knyvet, John, of Mendelesham 0
4551419 2216381 2216381 defendant Knyvet John   589379 589379 Knyvet, John, of Mendelesham 0
4551448 2216390 2216390 defendant Cone or Cove Roger   589379 589379 Cone or Cove, Roger, of Mendelesham 0
4568199 2221625 2221625 defendant Havewode John   589379 589379 Havewode, John, of Mendelesham 0
4587531 2227504 2227504 plaintiff Hyrde Robert   589379 589379 Hyrde, Robert, of Mendelesham, vicar 0
4618792 2236877 2236877 plaintiff Heerde Robert (legal representative) 589379 589379 Heerde, Robert, of Mendelesham, vicar, executors of 0
4621144 2237599 2237599 defendant Eye John   589379 589379 Eye, John, of Mendelesham 0
4621146 2237600 2237600 defendant Whytop Joan   589379 589379 Whytop, Joan, of Mendelesham 0
4679651 2259252 2259252 plaintiff Knyvet John   589379 589379 Knyvet, John, of Mendelesham, son of John Knyvet, knight 0
4699240 2265228 2265228 defendant Stekehare Robert chaplain 589379 589379 Stekehare, Robert, of Mendelesham, chaplain 0
4711139 2268838 2268838 defendant Breton John husbandman 589379 589379 Breton, John, of Mendelesham, husbandman 3
4779609 2289608 2289608 defendant Proofale or Proosale John yeoman 589379 589379 Proofale or Proosale, John, of Mendelesham, yeoman 0
4797842 2295502 2295502 defendant Hake Thomas husbandman 589379 589379 Hake, Thomas, of Mendelesham, husbandman 1
4805911 2298057 2298057 defendant Leche Thomas   589379 589379 Leche, Thomas, of Mendelesham, vicar 1
4809102 2299024 2299024 defendant Cake John husbandman 589379 589379 Cake, John, of Mendelesham, husbandman 3
4835509 2307099 2307099 defendant Avenaunt John yeoman 589379 589379 Avenaunt, John, of Mendelesham, yeoman 0
4835512 2307099 2307099 defendant Rysewold Thomas butcher 589379 589379 Rysewold, Thomas, of Mendelesham, butcher 3
4835513 2307099 2307099 defendant Alom Thomas husbandman 589379 589379 Alom, Thomas, of Mendelesham, husbandman 4
4885058 2322219 2322219 defendant Bienamour Richard gent 589379 589379 Bienamour, Richard, of Mendelesham, gent 1
4885059 2322219 2322219 defendant Breuer Richard yeoman 589379 589379 Breuer, Richard, of Mendelesham, yeoman 2
4885060 2322219 2322219 defendant Fox John yeoman 589379 589379 Fox, John, of Mendelesham, yeoman 3
4904437 2327999 2327999 defendant Breuer Richard yeoman 589379 589379 Breuer, Richard, of Mendelesham, yeoman 2
4904438 2327999 2327999 defendant Fox John yeoman 589379 589379 Fox, John, of Mendelesham, yeoman 3
4926086 2334588 2334588 plaintiff Provale Thomas (legal representative) 589379 589379 Provale, Thomas, of Mendelesham, executors of 0
4926089 2334588 2334588 plaintiff Dunche Robert butcher 589379 589379 Dunche, Robert, of Mendelesham, butcher 3
4926096 2334589 2334589 plaintiff Dunche Robert butcher 589379 589379 Dunche, Robert, of Mendelesham, butcher 3
4934026 2337020 2337020 defendant Knyvet John   589379 589379 Knyvet, John, of Mendelesham, knight 2
4953111 2342894 2342894 defendant Brunwyn John chaplain 589379 589379 Brunwyn, John, of Mendelesham, chaplain 3
4959021 2344665 2344665 defendant Dunch Robert butcher 589379 589379 Dunch, Robert, of Mendelesham, butcher 0
4959022 2344665 2344665 defendant Brynglove William laborer 589379 589379 Brynglove, William, of Mendelesham, laborer 1
5015649 2361461 2361461 defendant Cutte Thomas husbandman 589379 589379 Cutte, Thomas, of Mendelesham, husbandman 0
5017611 2362025 2362025 defendant Haldon or Haldous Thomas gent 589379 589379 Haldon or Haldous, Thomas, of Mendelesham, gent 2
5056868 2373629 2373629 defendant Aldhous Thomas gent 589379 589379 Aldhous, Thomas, of Mendelesham, gent 0
5064135 2375813 2375813 defendant Bronewyn Robert husbandman 589379 589379 Bronewyn, Robert, of Mendelesham, husbandman 0
5068542 2377083 2377083 defendant Trenchemer Thomas esq 589379 589379 Trenchemer, Thomas, of Mendelesham, esq 0
5084110 2381751 2381751 defendant Mannyng Robert butcher 589379 589379 Mannyng, Robert, of Mendelesham, butcher 0
5098062 2385866 2385866 defendant Bradwey Robert yeoman 589379 589379 Bradwey, Robert, of Mendelesham, yeoman 1
5099240 2386205 2386205 defendant Aldhous Thomas gent 589379 589379 Aldhous, Thomas, of Mendelesham, gent 0
5099244 2386206 2386206 defendant Aldhous Thomas gent 589379 589379 Aldhous, Thomas, of Mendelesham, gent 0
5099435 2386267 2386267 defendant Bronewyn Robert yeoman 589379 589379 Bronewyn, Robert, of Mendelesham, yeoman 0
5104265 2387669 2387669 defendant Bacheler John carver 589379 589379 Bacheler, John, of Mendelesham, carver 5
5108935 2389032 2389032 defendant Dunkon Thomas husbandman 589379 589379 Dunkon, Thomas, of Mendelesham, husbandman 4
5112917 2390170 2390170 defendant Rowt or Rowe Richard shoemaker 589379 589379 Rowt or Rowe, Richard, of Mendelesham, shoemaker 3
5119455 2392118 2392118 defendant Aldhous Thomas gent 589379 589379 Aldhous, Thomas, of Mendelesham, gent 1
5121144 2392609 2392609 defendant Mannyng Robert husbandman 589379 589379 Mannyng, Robert, of Mendelesham, husbandman 1
5131965 2395833 2395833 defendant Scot Richard clerk 589379 589379 Scot, Richard, of Mendelesham, clerk 0
5135214 2396797 2396797 defendant Mannyng Robert yeoman 589379 589379 Mannyng, Robert, of Mendelesham, yeoman 0
5135215 2396797 2396797 defendant Brad--- Robert yeoman 589379 589379 Brad---, Robert, of Mendelesham, yeoman 1
5183031 2410781 2410781 defendant Bradwey Robert yeoman 589379 589379 Bradwey, Robert, of Mendelesham, yeoman 3
5183032 2410781 2410781 defendant Canon Walter husbandman 589379 589379 Canon, Walter, of Mendelesham, husbandman 4
5202816 2416591 2416591 defendant Mannyng Robert yeoman 589379 589379 Mannyng, Robert, of Mendelesham, yeoman 1
5214540 2419980 2419980 defendant Bradwey Robert yeoman 589379 589379 Bradwey, Robert, of Mendelesham, yeoman 1
5215795 2420346 2420346 defendant Dunche Robert, junior yeoman 589379 589379 Dunche, Robert, junior, of Mendelesham, yeoman 0
5216721 2420624 2420624 defendant Dunkoon Thomas yeoman 589379 589379 Dunkoon, Thomas, of Mendelesham, yeoman 2
5222908 2422413 2422413 defendant Bradwey Robert yeoman 589379 589379 Bradwey, Robert, of Mendelesham, yeoman 0
5222909 2422413 2422413 defendant Bussh Geoffrey glover 589379 589379 Bussh, Geoffrey, of Mendelesham, glover 1
5224560 2422852 2422852 plaintiff Awty John tailor 589379 589379 Awty, John, of Mendelesham, tailor 1
5224564 2422853 2422853 plaintiff Awty John tailor 589379 589379 Awty, John, of Mendelesham, tailor 1
5227515 2423673 2423673 defendant Dunkon Thomas husbandman 589379 589379 Dunkon, Thomas, of Mendelesham, husbandman 1
5227516 2423673 2423673 defendant Bussh Geoffrey husbandman 589379 589379 Bussh, Geoffrey, of Mendelesham, husbandman 2
5227517 2423673 2423673 defendant Baret William husbandman 589379 589379 Baret, William, of Mendelesham, husbandman 3
5227520 2423674 2423674 defendant Barker Robert mercer 589379 589379 Barker, Robert, of Mendelesham, mercer 1
5232814 2425180 2425180 defendant Bussh Geoffrey (legal representative) 589379 589379 Bussh, Geoffrey, of Mendelesham, executors of 4
5232815 2425180 2425180 defendant Cake Robert yeoman 589379 589379 (Cake, Robert, of Mendelesham, yeoman 5
5232816 2425180 2425180 defendant Bussh Isabel widow 589379 589379 Bussh, Isabel, of Mendelesham, widow 6
5232967 2425224 2425224 defendant Byfeld Philip yeoman 589379 589379 Byfeld, Philip, of Mendelesham, yeoman 2
5236024 2426118 2426118 plaintiff Dunche John   589379 589379 Dunche, John, of Mendelesham 1
5236025 2426118 2426118 defendant Goslyn John mercer 589379 589379 Goslyn, John, of Mendelesham, mercer 0
5236027 2426119 2426119 plaintiff Dunche John   589379 589379 Dunche, John, of Mendelesham 1
5236028 2426119 2426119 defendant Goslyn John mercer 589379 589379 Goslyn, John, of Mendelesham, mercer 0
5256305 2432093 2432093 defendant Rotele John husbandman 589379 589379 Rotele, John, of Mendelesham, husbandman 0
5256669 2432206 2432206 defendant Gosselyn John, junior mercer 589379 589379 Gosselyn, John, junior, of Mendelesham, mercer 1
5279321 2439045 2439045 defendant Gyles Thomas fuller 589379 589379 Gyles, Thomas, of Mendelesham, fuller 1
5302768 2445811 2445811 defendant Berton Richard clerk 589379 589379 Berton, Richard, of Mendelesham, clerk 0
5314028 2449218 2449218 defendant Gyles Thomas fuller 589379 589379 Gyles, Thomas, of Mendelesham, fuller 1
5329135 2453791 2453791 defendant Teryngton William painter 589379 589379 Teryngton, William, of Mendelesham, painter 4
5333896 2455212 2455212 defendant Cake John shoemaker 589379 589379 Cake, John, of Mendelesham, shoemaker 0
5359267 2462935 2462935 plaintiff Maltyward John   589379 589379 Maltyward, John, of Mendelesham 1
5359270 2462936 2462936 plaintiff Maltyward John   589379 589379 Maltyward, John, of Mendelesham 1
5397492 2474358 2474358 defendant Dunche Margery widow 589379 589379 Dunche, Margery, of Mendelesham, widow 11
5408532 2477516 2477516 defendant Sengylton Edmund esq 589379 589379 Sengylton, Edmund, of Mendelesham, esq 0
5408534 2477516 2477516 defendant Dunch John butcher 589379 589379 Dunch, John, of Mendelesham, butcher 2
5421703 2481428 2481428 defendant Sengylton Edmund esq 589379 589379 Sengylton, Edmund, of Mendelesham, esq 0
5421705 2481428 2481428 defendant Dunch John butcher 589379 589379 Dunch, John, of Mendelesham, butcher 2
5424665 2482337 2482337 defendant Dunche Magery widow 589379 589379 Dunche, Magery, of Mendelesham, widow 11
5441572 2487398 2487398 defendant Sengylton Edmund esq 589379 589379 Sengylton, Edmund, of Mendelesham, esq 0
5441574 2487398 2487398 defendant Dunch John butcher 589379 589379 Dunch, John, of Mendelesham, butcher 2
5504199 2506228 2506228 defendant Dunch John butcher 589379 589379 Dunch, John, of Mendelesham, butcher 2
5544243 2518303 2518303 defendant Wylkyn Thomas husbandman 589379 589379 Wylkyn, Thomas, of Mendelesham, husbandman 0
5559183 2522649 2522649 defendant Dunche John laborer 589379 589379 Dunche, John, of Mendelesham, laborer 0

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);