names

238 rows where place_id = 601889

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3647454 1909593 1909593 defendant Russhe Thomas gent 601889 601889 Russhe, Thomas, of Ipswich, Suff, gent 0
3650930 1910661 1910661 defendant Percyvale Richard merchant 601889 601889 Percyvale, Richard, of Ipswich, Suff, merchant 0
3654071 1911535 1911535 defendant Blogat John   601889 601889 Blogat, John, of Ipswich, Suff, fish monger 0
3656623 1912325 1912325 defendant Eston John   601889 601889 Eston, John, of Ipswich, Suff, blade smith 2
3657774 1912683 1912683 defendant Crowlyng Harticus   601889 601889 Crowlyng, Harticus, of Ipswich, Suff, gold smith 0
3663945 1914666 1914666 defendant Purpet Thomas   601889 601889 Purpet, Thomas, of Ipswich, Suff, wax chandler 1
3663952 1914668 1914668 defendant Purpet Thomas   601889 601889 Purpet, Thomas, of Ipswich, Suff, wax chandler 1
3665720 1915226 1915226 defendant West John sadler 601889 601889 West, John, of Ipswich, Suff, sadler 1
3666135 1915353 1915353 defendant Parcyvall Richard merchant 601889 601889 Parcyvall, Richard, of Ipswich, Suff, merchant 0
3666142 1915355 1915355 defendant Percyvall Richard merchant 601889 601889 Percyvall, Richard, of Ipswich, Suff, merchant 0
3666147 1915356 1915356 defendant Percyvall Richard   601889 601889 Percyvall, Richard, of Ipswich, Suff, merhcnat 0
3666690 1915529 1915529 defendant Stannard Henry merchant 601889 601889 Stannard, Henry, of Ipswich, Suff, merchant 2
3667714 1915846 1915846 defendant Manser Thomas   601889 601889 Manser, Thomas, of Ipswich, Suff, cloth maker 0
3667720 1915847 1915847 defendant Goodwyn Robert merchant 601889 601889 Goodwyn, Robert, of Ipswich, Suff, merchant 0
3763238 1946139 1946139 defendant Goodwyn Robert merchant 601889 601889 Goodwyn, Robert, of Ipswich, Suff, merchant 0
3765885 1946994 1946994 defendant Goodwyn Robert merchant 601889 601889 Goodwyn, Robert, of Ipswich, Suff, merchant 0
3768058 1947647 1947647 defendant Goodwyn Robert merchant 601889 601889 Goodwyn, Robert, of Ipswich, Suff, merchant 0
3773803 1949520 1949520 defendant Goodwyn Robert merchant 601889 601889 Goodwyn, Robert, of Ipswich, Suff, merchant 0
3809251 1960774 1960774 defendant Pykeryng Richard schoolmaster 601889 601889 Pykeryng, Richard, of Ipswich, Suff, schoolmaster 0
3926643 1999244 1999244 defendant Stamard William chapman 601889 601889 Stamard, William, of Ipswich, Suff, chapman 0
3929123 2000078 2000078 plaintiff Browrik John merchant 601889 601889 Browrik, John, of Ipswich, Suff, merchant 0
3931491 2000832 2000832 defendant Renton William merchant 601889 601889 Renton, William, of Ipswich, Suff, merchant 0
3932652 2001216 2001216 defendant Goodwyn Christopher merchant 601889 601889 Goodwyn, Christopher, of Ipswich, Suff, merchant 0
3932654 2001217 2001217 defendant Goodwyn Ralph merchant 601889 601889 Goodwyn, Ralph, of Ipswich, Suff, merchant 0
3934118 2001705 2001705 defendant Amys James merchant 601889 601889 Amys, James, of Ipswich, Suff, merchant 0
3934122 2001706 2001706 defendant Amys James merchant 601889 601889 Amys, James, of Ipswich, Suff, merchant 0
3934239 2001745 2001745 defendant Coly Richard chapman 601889 601889 Coly, Richard, of Ipswich, Suff, chapman 1
3935769 2002269 2002269 defendant Holmes Alexander merchant 601889 601889 Holmes, Alexander, of Ipswich, Suff, merchant 0
3935771 2002270 2002270 defendant Holmes Richard yeoman 601889 601889 Holmes, Richard, of Ipswich, Suff, yeoman 0
3936923 2002682 2002682 defendant Olyver John chapman 601889 601889 Olyver, John, of Ipswich, Suff, chapman 0
3938130 2003087 2003087 defendant Goodwyn Christopher merchant 601889 601889 Goodwyn, Christopher, of Ipswich, Suff, merchant 0
3940209 2003743 2003743 plaintiff Smythe John (legal representative) 601889 601889 Smythe, John, of Ipswich, Suff, merchant, executor of 0
3969116 2013810 2013810 defendant Reede Thomas merchant 601889 601889 Reede, Thomas, of Ipswich, Suff, merchant 0
4029667 2035250 2035250 plaintiff Dawson John clothier 601889 601889 Dawson, John, of Ipswich, Suff, clothier 0
4031215 2035834 2035834 defendant Prentise William skinner 601889 601889 Prentise, William, of Ipswich, Suff, skinner 0
4093814 2058111 2058111 defendant Bedingfeld James gent 601889 601889 Bedingfeld, James, of Ipswich, Suff, gent 0
4107539 2062983 2062983 defendant Baker Edmund chapman 601889 601889 Baker, Edmund, of Ipswich, Suff, chapman 0
4123501 2068708 2068708 defendant Not Richard merchant 601889 601889 Not, Richard, of Ipswich, Suff, merchant 0
4190572 2092261 2092261 defendant Edward Nicholas yeoman 601889 601889 Edward, Nicholas, of Ipswich, Suff, yeoman 1
4207573 2098209 2098209 defendant Trofte Edward gent 601889 601889 Trofte, Edward, of Ipswich, Suff, gent 0
4225085 2104243 2104243 defendant Froste Henry mariner 601889 601889 Froste, Henry, of Ipswich, Suff, mariner 0
4389700 2161183 2161183 defendant Dameron Edmund draper 601889 601889 Dameron, Edmund, of Ipswich, Suff, draper 0
4408404 2167385 2167385 defendant Croftes John esq 601889 601889 Croftes, John, of Ipswich, Suff, esq 0
4576258 2224077 2224077 defendant Nesham Walter   601889 601889 Nesham, Walter, of Ipswich, Suff 0
4576260 2224078 2224078 defendant Nesham Walter spicer 601889 601889 Nesham, Walter, of Ipswich, Suff, spicer 0
4642156 2243818 2243818 defendant Starlyng John   601889 601889 Starlyng, John, of Ipswich, Suff 0
4668915 2255980 2255980 defendant Caunceler John yeoman 601889 601889 Caunceler, John, of Ipswich, Suff, yeoman 2
4670430 2256437 2256437 defendant Starlyng John esq 601889 601889 Starlyng, John, of Ipswich, Suff, esq 1
4670527 2256457 2256457 defendant Wode John chapman 601889 601889 Wode, John, of Ipswich, Suff, chapman 0
4670530 2256458 2256458 defendant Wode John chapman 601889 601889 Wode, John, of Ipswich, Suff, chapman 0
4670885 2256571 2256571 defendant Caunceler John husbandman 601889 601889 Caunceler, John, of Ipswich, Suff, husbandman 1
4671583 2256757 2256757 defendant Hacche Robert husbandman 601889 601889 Hacche, Robert, of Ipswich, Suff, husbandman 0
4671969 2256877 2256877 defendant Pollard John gent 601889 601889 Pollard, John, of Ipswich, Suff, gent 0
4672157 2256938 2256938 defendant Rous Joan widow 601889 601889 Rous, Joan, of Ipswich, Suff, widow 1
4673773 2257420 2257420 plaintiff Absy Benedict   601889 601889 Absy, Benedict, of Ipswich, Suff 1
4729086 2274330 2274330 defendant Walworth William gent 601889 601889 Walworth, William, of Ipswich, Suff, gent 2
4736155 2276443 2276443 defendant Joye John chapman 601889 601889 Joye, John, of Ipswich, Suff, chapman 3
4736529 2276554 2276554 defendant Snowe William ostler 601889 601889 Snowe, William, of Ipswich, Suff, ostler 0
4741165 2277919 2277919 defendant Stonham William chapman 601889 601889 Stonham, William, of Ipswich, Suff, chapman 4
4741208 2277925 2277925 defendant Stonham William chapman 601889 601889 Stonham, William, of Ipswich, Suff, chapman 4
4742559 2278324 2278324 defendant Talifer William barber 601889 601889 Talifer, William, of Ipswich, Suff, barber 0
4742775 2278393 2278393 defendant Debenham William merchant 601889 601889 Debenham, William, of Ipswich, Suff, merchant 2
4742909 2278435 2278435 defendant Rous John (legal representative) 601889 601889 Rous, John, of Ipswich, Suff, merchant, executrix of 0
4742912 2278436 2278436 defendant Rouse John (legal representative) 601889 601889 Rouse, John, of Ipswich, Suff, merchant, executrix of 0
4743106 2278506 2278506 defendant Greyve John chapman 601889 601889 Greyve, John, of Ipswich, Suff, chapman 1
4744846 2279011 2279011 defendant Frenssh John   601889 601889 Frenssh, John, of Ipswich, Suff, bailiff 4
4752417 2281165 2281165 defendant Spaldyng Geoffrey taverner 601889 601889 Spaldyng, Geoffrey, of Ipswich, Suff, taverner 1
4755835 2282206 2282206 defendant Terry Peter yeoman 601889 601889 Terry, Peter, of Ipswich, Suff, yeoman 0
4759425 2283288 2283288 defendant Greyve (illegible) merchant 601889 601889 Greyve, _, of Ipswich, Suff, merchant 3
4762304 2284191 2284191 defendant Skynnere Nicholas skinner 601889 601889 Skynnere, Nicholas, of Ipswich, Suff, skinner 1
4765591 2285229 2285229 defendant Priour John merchant 601889 601889 Priour, John, of Ipswich, Suff, merchant 0
4765802 2285304 2285304 defendant Roberdys Thomas yeoman 601889 601889 Roberdys, Thomas, of Ipswich, Suff, yeoman 1
4769004 2286283 2286283 defendant Haverill John barber 601889 601889 Haverill, John, of Ipswich, Suff, barber 0
4771067 2286930 2286930 defendant Dobil Thomas yeoman 601889 601889 Dobil, Thomas, of Ipswich, Suff, yeoman 1
4794509 2294422 2294422 defendant Dysse Richard woolman 601889 601889 Dysse, Richard, of Ipswich, Suff, woolman 0
4807249 2298468 2298468 defendant Rous John mercer 601889 601889 Rous, John, of Ipswich, Suff, mercer 0
4808941 2298972 2298972 defendant Pryour John mercer 601889 601889 Pryour, John, of Ipswich, Suff, mercer 0
4809988 2299282 2299282 defendant Frenssh John husbandman 601889 601889 Frenssh, John, of Ipswich, Suff, husbandman 0
4809992 2299283 2299283 defendant Nedam Thomas husbandman 601889 601889 Nedam, Thomas, of Ipswich, Suff, husbandman 0
4814499 2300643 2300643 defendant Tyell John dyer 601889 601889 Tyell, John, of Ipswich, Suff, dyer 0
4814503 2300644 2300644 defendant Roberd Thomas   601889 601889 Roberd, Thomas, of Ipswich, Suff, wood man 0
4817323 2301507 2301507 defendant Grove John merchant 601889 601889 Grove, John, of Ipswich, Suff, merchant 0
4819182 2302079 2302079 defendant Intebergh John chapman 601889 601889 Intebergh, John, of Ipswich, Suff, chapman 0
4821142 2302692 2302692 defendant Lovell William esq 601889 601889 (Lovell, William, of Ipswich, Suff, esq 1
4823907 2303558 2303558 defendant Walden John clerk 601889 601889 Walden, John, of Ipswich, Suff, clerk 1
4825119 2303898 2303898 defendant Deken John merchant 601889 601889 Deken, John, of Ipswich, Suff, merchant 2
4836241 2307314 2307314 defendant Frenssh John husbandman 601889 601889 Frenssh, John, of Ipswich, Suff, husbandman 0
4836957 2307516 2307516 defendant Fornham Alexander   601889 601889 Fornham, Alexander, of Ipswich, Suff, mason 1
4836963 2307517 2307517 defendant Fornham Alexander   601889 601889 Fornham, Alexander, of Ipswich, Suff, mason 1
4837608 2307695 2307695 defendant Gyffard John merchant 601889 601889 Gyffard, John, of Ipswich, Suff, merchant 1
4837613 2307696 2307696 defendant Gyffard John merchant 601889 601889 Gyffard, John, of Ipswich, Suff, merchant 1
4844000 2309635 2309635 defendant Twayte John gent 601889 601889 Twayte, John, of Ipswich, Suff, gent 0
4844952 2309941 2309941 defendant Priour John merchant 601889 601889 Priour, John, of Ipswich, Suff, merchant 0
4844955 2309942 2309942 defendant Priour John merchant 601889 601889 Priour, John, of Ipswich, Suff, merchant 0
4848948 2311138 2311138 defendant Dounham Thomas   601889 601889 Dounham, Thomas, of Ipswich, Suff, town clerk 0
4849807 2311411 2311411 defendant Inkbergh John merchant 601889 601889 Inkbergh, John, of Ipswich, Suff, merchant 0
4850694 2311673 2311673 defendant Draper John yeoman 601889 601889 Draper, John, of Ipswich, Suff, yeoman 0
4908355 2329167 2329167 defendant Lombe Edmund merchant 601889 601889 Lombe, Edmund, of Ipswich, Suff, merchant 0
4910460 2329787 2329787 defendant Draper John skinner 601889 601889 Draper, John, of Ipswich, Suff, skinner 0
4911798 2330194 2330194 defendant Dounham Thomas yeoman 601889 601889 Dounham, Thomas, of Ipswich, Suff, 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);