names

81 rows where place_id = 588336

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594145 1865811 1865811 defendant Ulneston or Ulveston John gent 588336 588336 Ulneston or Ulveston, John, of Debenham, Suff, gent 1
3765881 1946993 1946993 defendant Newton William yeoman 588336 588336 Newton, William, of Debenham, Suff, yeoman 1
3790217 1954758 1954758 defendant Fen Gregory clerk 588336 588336 Fen, Gregory, of Debenham, Suff, clerk 4
3871633 1980750 1980750 defendant Downes Robert gent 588336 588336 Downes, Robert, of Debenham, Suff, gent 1
3871748 1980787 1980787 defendant Brownwyn John weaver 588336 588336 Brownwyn, John, of Debenham, Suff, weaver 0
3902612 1991107 1991107 defendant Ryvet Thomas husbandman 588336 588336 Ryvet, Thomas, of Debenham, Suff, husbandman 0
3907963 1992955 1992955 defendant Kyrby Thomas yeoman 588336 588336 Kyrby, Thomas, of Debenham, Suff, yeoman 0
3936079 2002389 2002389 defendant Lone or Love John yeoman 588336 588336 Lone or Love, John, of Debenham, Suff, yeoman 2
3974810 2015753 2015753 defendant Harryson John mercer 588336 588336 Harryson, John, of Debenham, Suff, mercer 0
4003947 2026181 2026181 defendant Bradwell Thomas clothier 588336 588336 Bradwell, Thomas, of Debenham, Suff, clothier 1
4070044 2049574 2049574 defendant Perce or Pyers William gent 588336 588336 Perce or Pyers, William, of Debenham, Suff, gent 0
4092073 2057461 2057461 defendant Scott Philip singleman 588336 588336 Scott, Philip, of Debenham, Suff, yeoman, singleman 0
4189691 2091891 2091891 defendant Lorde Robert yeoman 588336 588336 Lorde, Robert, of Debenham, Suff, yeoman 0
4213429 2100215 2100215 defendant Jeffris alias Sponer Simon yeoman 588336 588336 Jeffris alias Sponer, Simon, of Debenham, Suff, yeoman 0
4292217 2127285 2127285 defendant Sudburye alias Gaines William yeoman 588336 588336 Sudburye alias Gaines, William, of Debenham, Suff, yeoman 3
4338814 2143330 2143330 defendant Cheeke John, senior gent 588336 588336 Cheeke, John, senior, of Debenham, Suff, gent 0
4340394 2143904 2143904 defendant Bond Charles draper 588336 588336 Bond, Charles, of Debenham, Suff, draper 1
4341175 2144185 2144185 defendant Marshall George, senior cordwainer 588336 588336 Marshall, George, senior, of Debenham, Suff, cordwainer 2
4341674 2144368 2144368 defendant Craske John chapman 588336 588336 Craske, John, of Debenham, Suff, chapman 1
4345460 2145683 2145683 defendant Smythe William chapman 588336 588336 Smythe, William, of Debenham, Suff, chapman 3
4364693 2152431 2152431 defendant Marshall George, senior cordwainer 588336 588336 Marshall, George, senior, of Debenham, Suff, cordwainer 2
4387052 2160324 2160324 defendant Harrison John draper 588336 588336 Harrison, John, of Debenham, Suff, draper 0
4406201 2166638 2166638 defendant Lather John   588336 588336 Lather, John, of Debenham, Suff, apothecary 3
4595192 2229748 2229748 defendant Foket John   588336 588336 Foket, John, of Debenham, Suff 11
4595205 2229749 2229749 defendant Feket John   588336 588336 Feket, John, of Debenham, Suff 11
4674067 2257498 2257498 defendant Bysshop Godewin chandler 588336 588336 Bysshop, Godewin, of Debenham, Suff, chandler 2
4739546 2277448 2277448 defendant Framlyngham John esq 588336 588336 Framlyngham, John, of Debenham, Suff, esq 3
4740408 2277709 2277709 defendant Baxster Thomas yeoman 588336 588336 Baxster, Thomas, of Debenham, Suff, yeoman 1
4810789 2299498 2299498 defendant Haward John mercer 588336 588336 Haward, John, of Debenham, Suff, mercer 0
4823672 2303495 2303495 defendant Monk John skinner 588336 588336 Monk, John, of Debenham, Suff, skinner 0
4839483 2308273 2308273 defendant Jenore Stephen yeoman 588336 588336 Jenore, Stephen, of Debenham, Suff, yeoman 0
4841159 2308771 2308771 defendant Tyell John gent 588336 588336 Tyell, John, of Debenham, Suff, gent 0
4855991 2313246 2313246 defendant Howard Thomas mercer 588336 588336 Howard, Thomas, of Debenham, Suff, mercer 0
4864406 2315848 2315848 defendant Haward Thomas mercer 588336 588336 Haward, Thomas, of Debenham, Suff, mercer 0
4864410 2315849 2315849 defendant Haward Thomas mercer 588336 588336 Haward, Thomas, of Debenham, Suff, mercer 0
4924719 2334168 2334168 defendant Prat William chapman 588336 588336 Prat, William, of Debenham, Suff, chapman 1
4924732 2334171 2334171 defendant Prat William chapman 588336 588336 Prat, William, of Debenham, Suff, chapman 1
4927474 2335028 2335028 defendant Sexton John, junior mercer 588336 588336 Sexton, John, junior, of Debenham, Suff, mercer 0
4942551 2339648 2339648 defendant Howard Thomas chapman 588336 588336 Howard, Thomas, of Debenham, Suff, chapman 0
4942572 2339650 2339650 defendant Howard Thomas chapman 588336 588336 Howard, Thomas, of Debenham, Suff, chapman 0
4950127 2342005 2342005 defendant Prat Thomas chapman 588336 588336 Prat, Thomas, of Debenham, Suff, chapman 2
4950131 2342006 2342006 defendant Prat Thomas chapman 588336 588336 Prat, Thomas, of Debenham, Suff, chapman 2
4957449 2344197 2344197 defendant Sexteyn John, junior yeoman or mercer 588336 588336 Sexteyn, John, junior, of Debenham, Suff, yeoman or mercer 0
5040149 2368653 2368653 defendant Framlyngham John esq 588336 588336 Framlyngham, John, of Debenham, Suff, esq 0
5047561 2370890 2370890 defendant Wood William chapman 588336 588336 Wood, William, of Debenham, Suff, chapman 1
5058696 2374164 2374164 defendant Framyngham John esq 588336 588336 Framyngham, John, of Debenham, Suff, esq 0
5063099 2375500 2375500 defendant Framyngham John esq 588336 588336 Framyngham, John, of Debenham, Suff, esq 0
5065497 2376213 2376213 defendant Prat Thomas husbandman 588336 588336 Prat, Thomas, of Debenham, Suff, husbandman 0
5067127 2376690 2376690 defendant Framyngham John esq 588336 588336 Framyngham, John, of Debenham, Suff, esq 0
5067131 2376691 2376691 defendant Framyngham John esq 588336 588336 Framyngham, John, of Debenham, Suff, esq 0
5084341 2381827 2381827 defendant Framyngham John esq 588336 588336 Framyngham, John, of Debenham, Suff, esq 0
5100556 2386588 2386588 defendant Cheke Robert yeoman 588336 588336 Cheke, Robert, of Debenham, Suff, yeoman 2
5101360 2386809 2386809 defendant Framlyngham John esq 588336 588336 Framlyngham, John, of Debenham, Suff, esq 3
5116651 2391304 2391304 defendant Cheke Robert gent 588336 588336 Cheke, Robert, of Debenham, Suff, gent 0
5116657 2391305 2391305 defendant Cheke Robert gent 588336 588336 Cheke, Robert, of Debenham, Suff, gent 0
5120720 2392489 2392489 defendant Cheke Robert yeoman 588336 588336 Cheke, Robert, of Debenham, Suff, yeoman 2
5120993 2392572 2392572 defendant Framlyngham John esq 588336 588336 Framlyngham, John, of Debenham, Suff, esq 0
5130296 2395344 2395344 defendant (illegible) John tailor 588336 588336 ----, John, of Debenham, Suff, tailor 2
5130329 2395356 2395356 defendant Burton John tailor 588336 588336 Burton, John, of Debenham, Suff, tailor 2
5143934 2399369 2399369 defendant Femyngham John, sen esq 588336 588336 Femyngham, John, sen, of Debenham, Suff, esq 0
5149631 2401021 2401021 defendant Burton John tailor 588336 588336 Burton, John, of Debenham, Suff, tailor 2
5149635 2401022 2401022 defendant Burton John tailor 588336 588336 Burton, John, of Debenham, Suff, tailor 2
5157532 2403332 2403332 defendant Wode William chapman 588336 588336 Wode, William, of Debenham, Suff, chapman 0
5164964 2405490 2405490 defendant Fremyngham John, sen esq 588336 588336 Fremyngham, John, sen, of Debenham, Suff, esq 0
5173414 2407929 2407929 defendant Wode William chapman 588336 588336 Wode, William, of Debenham, Suff, chapman 0
5217219 2420772 2420772 defendant Gosselyn John husbandman 588336 588336 Gosselyn, John, of Debenham, Suff, husbandman 0
5229852 2424350 2424350 defendant Framlyngham John esq 588336 588336 Framlyngham, John, of Debenham, Suff, esq 2
5264941 2434793 2434793 defendant Arnold William   588336 588336 Arnold, William, of Debenham, Suff, mason 5
5295489 2443671 2443671 defendant Strangman Nicholas clerk 588336 588336 Strangman, Nicholas, of Debenham, Suff, clerk 1
5306175 2446835 2446835 defendant Framlyngham John esq 588336 588336 Framlyngham, John, of Debenham, Suff, esq 0
5334853 2455492 2455492 defendant Nunne John husbandman 588336 588336 Nunne, John, of Debenham, Suff, husbandman 0
5334856 2455493 2455493 defendant Nunne John, senior husbandman 588336 588336 Nunne, John, senior, of Debenham, Suff, husbandman 0
5341479 2457526 2457526 defendant Curwen Roger yeoman 588336 588336 Curwen, Roger, of Debenham, Suff, yeoman 1
5365807 2464960 2464960 defendant a Wode Robert chapman 588336 588336 a Wode, Robert, of Debenham, Suff, chapman 1
5380254 2469400 2469400 defendant Awode Robert chapman 588336 588336 Awode, Robert, of Debenham, Suff, chapman 0
5548672 2519654 2519654 defendant Knouthe Peter yeoman 588336 588336 Knouthe, Peter, of Debenham, Suff, yeoman 1
5562998 2523773 2523773 defendant Framlyngham James gent 588336 588336 Framlyngham, James, of Debenham, Suff, gent 0
5584939 2530366 2530366 defendant Framyngham James esq 588336 588336 Framyngham, James, of Debenham, Suff, esq 3
5584947 2530367 2530367 defendant Framyngham James esq 588336 588336 Framyngham, James, of Debenham, Suff, esq 4
5589978 2531849 2531849 defendant Framlyngham James esq 588336 588336 Framlyngham, James, of Debenham, Suff, esq 1
5589980 2531850 2531850 defendant Framlyngham James esq 588336 588336 Framlyngham, James, of Debenham, Suff, esq 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);