names

117 rows where place_id = 590661

✎ 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
3601927 1868258 1868258 defendant Hasyll William husbandman 590661 590661 Hasyll, William, of Hadleygh, husbandman 1
3605635 1869427 1869427 defendant Fen John clothmaker 590661 590661 Fen, John, of Hadleygh, clothmaker 0
3607628 1870042 1870042 defendant Mynte Robert husbandman 590661 590661 Mynte, Robert, of Hadleygh, husbandman 0
3607629 1870042 1870042 defendant Fenne John butcher 590661 590661 Fenne, John, of Hadleygh, butcher 1
3608479 1870313 1870313 plaintiff Thorpe Robert gent 590661 590661 Thorpe, Robert, of Hadleygh, gent 0
3608480 1870313 1870313 defendant Chepe John fuller 590661 590661 Chepe, John, of Hadleygh, fuller 0
3711274 1929830 1929830 plaintiff Sumpter William sherman 590661 590661 Sumpter, William, of Hadleygh, sherman 0
3711275 1929830 1929830 defendant Pullen Richard sherman 590661 590661 Pullen, Richard, of Hadleygh, sherman 0
3711276 1929830 1929830 defendant Ware John carpenter 590661 590661 Ware, John, of Hadleygh, carpenter 1
3711277 1929830 1929830 defendant Mannyng William weaver 590661 590661 Mannyng, William, of Hadleygh, weaver 2
3757391 1944293 1944293 defendant Bryon Thomas yeoman 590661 590661 Bryon, Thomas, of Hadleygh, yeoman 0
3784762 1953026 1953026 defendant Sparowe Thomas innkeeper 590661 590661 Sparowe, Thomas, of Hadleygh, innkeeper 0
3784763 1953026 1953026 defendant Cowke John weaver 590661 590661 Cowke, John, of Hadleygh, weaver 1
3839280 1970214 1970214 plaintiff Barker Roger   590661 590661 Barker, Roger, of Hadleygh 1
3839281 1970214 1970214 defendant Yeman John clothmaker 590661 590661 Yeman, John, of Hadleygh, clothmaker 0
3883537 1984766 1984766 plaintiff Barker Roger   590661 590661 Barker, Roger, of Hadleygh 1
3883538 1984766 1984766 defendant Yeman John (legal representative) 590661 590661 Yeman, John, of Hadleygh, executors of 0
3883539 1984766 1984766 defendant Kembell John brewer 590661 590661 (Kembell, John, of Hadleygh, brewer 1
3883540 1984766 1984766 defendant Bryan Thomas weaver 590661 590661 Bryan, Thomas, of Hadleygh, weaver 2
3933378 2001457 2001457 defendant Bryan Thomas smith 590661 590661 Bryan, Thomas, of Hadleygh, smith 0
3988622 2020672 2020672 defendant Lambe Richard sherman 590661 590661 Lambe, Richard, of Hadleygh, sherman 7
4040710 2039171 2039171 defendant Forth William gent 590661 590661 Forth, William, of Hadleygh, gent 1
4040711 2039171 2039171 defendant Forth Israel gent 590661 590661 Forth, Israel, of Hadleygh, gent 2
4090303 2056817 2056817 defendant Turnor Stephen yeoman 590661 590661 Turnor, Stephen, of Hadleygh, or of Layham, Suff, yeoman 0
4090305 2056817 2056817 defendant Coplande Richard clothier 590661 590661 Coplande, Richard, of Hadleygh, clothier 2
4106860 2062747 2062747 defendant Becon Richard gent 590661 590661 Becon, Richard, of Hadleygh, gent 0
4160171 2081621 2081621 defendant Rood James clothier 590661 590661 Rood, James, of Hadleygh, clothier 2
4546168 2214748 2214748 defendant Coo Richard   590661 590661 Coo, Richard, of Hadleygh 0
4574133 2223432 2223432 plaintiff Benton Richard de clerk 590661 590661 Benton, Richard de, of Hadleygh, clerk 1
4574134 2223432 2223432 defendant Bayn Thomas   590661 590661 Bayn, Thomas, of Hadleygh 0
4604201 2232484 2232484 defendant Thedam John   590661 590661 Thedam, John, of Hadleygh 1
4605999 2232992 2232992 plaintiff atte Ston Richard   590661 590661 atte Ston, Richard, of Hadleygh 0
4612077 2234844 2234844 defendant Cook Roger (legal representative) 590661 590661 Cook, Roger, of Hadleygh, executor of 0
4612078 2234844 2234844 defendant Elys John   590661 590661 Elys, John, of Hadleygh 1
4614177 2235444 2235444 defendant Hache Robert   590661 590661 Hache, Robert, of Hadleygh 0
4614179 2235445 2235445 defendant Hache Robert   590661 590661 Hache, Robert, of Hadleygh 0
4632748 2241127 2241127 defendant Makeel Thomas   590661 590661 Makeel, Thomas, of Hadleygh 1
4633082 2241215 2241215 defendant Sadelere Peter   590661 590661 Sadelere, Peter, of Hadleygh 1
4642773 2243998 2243998 defendant Cag Nicholas   590661 590661 Cag, Nicholas, of Hadleygh 3
4645404 2244725 2244725 defendant Bayn Thomas   590661 590661 Bayn, Thomas, of Hadleygh 4
4646234 2244971 2244971 plaintiff Plat John   590661 590661 Plat, John, of Hadleygh 0
4646242 2244971 2244971 defendant Elys John   590661 590661 Elys, John, of Hadleygh 7
4649765 2245955 2245955 defendant Sadyllere Peter   590661 590661 Sadyllere, Peter, of Hadleygh 0
4662609 2249773 2249773 defendant Parker Peter   590661 590661 Parker, Peter, of Hadleygh, saddler, or of Ipswich, sergeant 3
4696853 2264496 2264496 plaintiff Cherche Thomas   590661 590661 Cherche, Thomas, of Hadleygh 0
4734576 2275977 2275977 defendant Kempe Stephen chapman 590661 590661 Kempe, Stephen, of Hadleygh, chapman 3
4767068 2285687 2285687 defendant Creswelle Peter yeoman 590661 590661 Creswelle, Peter, of Hadleygh, yeoman 1
4856818 2313508 2313508 plaintiff Bele John tailor 590661 590661 Bele, John, of Hadleygh, tailor 0
4882190 2321333 2321333 plaintiff Lyon John   590661 590661 Lyon, John, of Hadleygh 0
4882193 2321334 2321334 defendant Hill William barber 590661 590661 Hill, William, of Hadleygh, barber 0
4893633 2324708 2324708 defendant But John thatcher 590661 590661 But, John, of Hadleygh, thatcher 0
4903154 2327596 2327596 plaintiff Lyon John   590661 590661 Lyon, John, of Hadleygh 0
4908423 2329191 2329191 defendant Prykke Robert baker 590661 590661 Prykke, Robert, of Hadleygh, baker 0
4922878 2333571 2333571 plaintiff Lyon John   590661 590661 Lyon, John, of Hadleygh 0
4922881 2333572 2333572 plaintiff Lyon John   590661 590661 Lyon, John, of Hadleygh 0
4923047 2333627 2333627 defendant Talbot Roger draper & merchant 590661 590661 Talbot, Roger, of Hadleygh, draper & merchant 0
4923048 2333627 2333627 defendant Forth William draper 590661 590661 Forth, William, of Hadleygh, draper 1
4923049 2333627 2333627 defendant Lyon John draper 590661 590661 Lyon, John, of Hadleygh, draper 2
4923052 2333628 2333628 defendant Forth William draper 590661 590661 Forth, William, of Hadleygh, draper 1
4923053 2333628 2333628 defendant Lyon John draper 590661 590661 Lyon, John, of Hadleygh, draper 2
4957555 2344231 2344231 defendant Love John merchant 590661 590661 Love, John, of Hadleygh, merchant 0
4957556 2344231 2344231 defendant Bryan John merchant 590661 590661 Bryan, John, of Hadleygh, merchant 1
5053123 2372530 2372530 defendant Warde John merchant 590661 590661 Warde, John, of Hadleygh, merchant 0
5053124 2372530 2372530 defendant Lowell Maurice yeoman 590661 590661 Lowell, Maurice, of Hadleygh, yeoman 1
5053125 2372530 2372530 defendant Holbrook John yeoman 590661 590661 Holbrook, John, of Hadleygh, yeoman 2
5053126 2372530 2372530 defendant Sugge Richard yeoman 590661 590661 Sugge, Richard, of Hadleygh, yeoman 3
5093350 2384454 2384454 plaintiff Prykke Robert merchant 590661 590661 Prykke, Robert, of Hadleygh, merchant 0
5137726 2397548 2397548 plaintiff Purpyt John   590661 590661 Purpyt, John, of Hadleygh 0
5148367 2400660 2400660 defendant Greyne Thomas draper 590661 590661 Greyne, Thomas, of Hadleygh, draper 1
5164843 2405450 2405450 defendant Hood Thomas laborer 590661 590661 Hood, Thomas, of Hadleygh, laborer 0
5169600 2406847 2406847 plaintiff Groom Maud   590661 590661 Groom, Maud, of Hadleygh 0
5186599 2411831 2411831 plaintiff Groom Maud   590661 590661 Groom, Maud, of Hadleygh 0
5186602 2411832 2411832 plaintiff Groom Maud   590661 590661 Groom, Maud, of Hadleygh 0
5186605 2411833 2411833 plaintiff Groom Maud   590661 590661 Groom, Maud, of Hadleygh 0
5218766 2421216 2421216 plaintiff Groom John (legal representative) 590661 590661 Groom, John, of Hadleygh, executrix of 0
5270988 2436612 2436612 plaintiff Foorth Robert merchant 590661 590661 Foorth, Robert, of Hadleygh, merchant 0
5291377 2442481 2442481 defendant Hembrynggale Thomas merchant 590661 590661 Hembrynggale, Thomas, of Hadleygh, merchant 0
5328786 2453687 2453687 defendant Lambard Robert   590661 590661 Lambard, Robert, of Hadleygh, stockfishmonger or yeoman, alias Coldaker, Robert, of London 3
5362184 2463838 2463838 plaintiff Thorp Robert gent 590661 590661 Thorp, Robert, of Hadleygh, gent 0
5363276 2464169 2464169 defendant Myddowe John shoemaker 590661 590661 Myddowe, John, of Hadleygh, shoemaker 0
5366478 2465171 2465171 defendant Wilyot alias Spycer Henry   590661 590661 Wilyot alias Spycer, Henry, of Hadleygh, administrators of 0
5386094 2471093 2471093 defendant Blake Robert husbandman 590661 590661 Blake, Robert, of Hadleygh, husbandman 1
5398357 2474595 2474595 defendant Blake Robert husbandman 590661 590661 Blake, Robert, of Hadleygh, husbandman 1
5399901 2475066 2475066 plaintiff Fen John   590661 590661 Fen, John, of Hadleygh, cloth maker 0
5405003 2476509 2476509 defendant Fen John   590661 590661 Fen, John, of Hadleygh, cloth man 0
5405005 2476510 2476510 defendant Fen John clothman 590661 590661 Fen, John, of Hadleygh, clothman 0
5405015 2476513 2476513 defendant Rever Semanus mercer 590661 590661 Rever, Semanus, of Hadleygh, mercer 0
5411484 2478391 2478391 defendant Blake Robert husbandman 590661 590661 Blake, Robert, of Hadleygh, husbandman 1
5420036 2480910 2480910 plaintiff Thorp Robert gent 590661 590661 Thorp, Robert, of Hadleygh, gent 0
5422601 2481712 2481712 plaintiff Barouw Robert chaplain 590661 590661 Barouw, Robert, of Hadleygh, chaplain 0
5425776 2482676 2482676 defendant Blake Robert husbandman 590661 590661 Blake, Robert, of Hadleygh, husbandman 1
5445505 2488554 2488554 plaintiff Fen John yeoman 590661 590661 Fen, John, of Hadleygh, yeoman 0
5445507 2488554 2488554 defendant Gyffard William weaver 590661 590661 Gyffard, William, of Hadleygh, weaver 1
5468742 2495580 2495580 defendant Blake Robert husbandman 590661 590661 Blake, Robert, of Hadleygh, husbandman 0
5481947 2499534 2499534 plaintiff Goodere John gent 590661 590661 Goodere, John, of Hadleygh, gent 0
5502663 2505750 2505750 plaintiff Tunbek Peter (legal representative) 590661 590661 Tunbek, Peter, of Hadleygh, chaplain, executors of 0
5525353 2512519 2512519 defendant Richer Thomas yeoman 590661 590661 Richer, Thomas, of Hadleygh, yeoman 3
5527917 2513296 2513296 defendant Thorp John mercer 590661 590661 Thorp, John, of Hadleygh, mercer 3
5537367 2516180 2516180 defendant Thorp John merchant 590661 590661 Thorp, John, of Hadleygh, merchant 0
5538835 2516635 2516635 plaintiff Foorthe William   590661 590661 Foorthe, William, of Hadleygh 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);