names

230 rows where place_id = 603207

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3653856 1911470 1911470 plaintiff (illegible) (illegible)   603207 603207 --, --, of Kings Lynn 0
3654708 1911731 1911731 plaintiff Barker Richard   603207 603207 Barker, Richard, of Kings Lynn 0
3655571 1912004 1912004 defendant Tyge John yeoman 603207 603207 Tyge, John, of Kings Lynn, yeoman 0
3655573 1912005 1912005 defendant Tygo John yeoman 603207 603207 Tygo, John, of Kings Lynn, yeoman 0
3656132 1912172 1912172 defendant Dawney Thomas merchant 603207 603207 Dawney, Thomas, of Kings Lynn, merchant 0
3656221 1912194 1912194 plaintiff Campion Richard barker 603207 603207 Campion, Richard, of Kings Lynn, barker 0
3656223 1912195 1912195 plaintiff Campion Richard miller 603207 603207 Campion, Richard, of Kings Lynn, miller 0
3656225 1912196 1912196 plaintiff Campion Richard miller 603207 603207 Campion, Richard, of Kings Lynn, miller 0
3656436 1912258 1912258 plaintiff Cawood Thomas merchant 603207 603207 Cawood, Thomas, of Kings Lynn, merchant 0
3656438 1912259 1912259 plaintiff Cawood Thomas merchant 603207 603207 Cawood, Thomas, of Kings Lynn, merchant 0
3659669 1913280 1913280 defendant Amflys Richard (legal representative) 603207 603207 Amflys, Richard, of Kings Lynn, merchant, executor of John Wittyllsey, of Kings Lynn, merchant, executor of 0
3661968 1914034 1914034 defendant Champion Richard baker 603207 603207 Champion, Richard, of Kings Lynn, baker 1
3662495 1914185 1914185 plaintiff Miller Thomas merchant 603207 603207 Miller, Thomas, of Kings Lynn, merchant 0
3662496 1914185 1914185 defendant Pepir Richard fishmonger 603207 603207 Pepir, Richard, of Kings Lynn, fishmonger 0
3665905 1915273 1915273 defendant Genyns Robert (legal representative) 603207 603207 Genyns, Robert, of Kings Lynn, administrator of 0
3667144 1915657 1915657 defendant Cawode Thomas painter 603207 603207 Cawode, Thomas, of Kings Lynn, painter 0
3667170 1915666 1915666 defendant Colvyle alias Spalvyne William butcher 603207 603207 Colvyle alias Spalvyne, William, of Kings Lynn, butcher 0
3887367 1986039 1986039 plaintiff Cony Humphrey yeoman 603207 603207 Cony, Humphrey, of Kings Lynn, yeoman 0
3889548 1986737 1986737 plaintiff Grendell John (legal representative) 603207 603207 Grendell, John, of Kings Lynn, gent and alderman, executor of Amffles, Robert, of Kings Lynn, merchant, executors of 0
3902106 1990941 1990941 defendant Cogley Malachai yeoman 603207 603207 Cogley, Malachai, of Kings Lynn, yeoman 0
3902231 1990982 1990982 defendant Canaby William merchant 603207 603207 Canaby, William, of Kings Lynn, merchant 1
3903734 1991481 1991481 defendant Paynter Edward merchant 603207 603207 Paynter, Edward, of Kings Lynn, merchant 0
3903737 1991482 1991482 defendant Robynson William   603207 603207 Robynson, William, of Kings Lynn, shipwright 0
3903843 1991521 1991521 plaintiff Guybon Thomas esq 603207 603207 Guybon, Thomas, of Kings Lynn, esq 0
3904310 1991690 1991690 defendant Waters Thomas merchant 603207 603207 Waters, Thomas, of Kings Lynn, merchant 0
3904465 1991740 1991740 defendant Bowsey Thomas merchant 603207 603207 Bowsey, Thomas, of Kings Lynn, merchant 0
3904467 1991741 1991741 defendant Bowsy Thomas merchant 603207 603207 Bowsy, Thomas, of Kings Lynn, merchant 0
3904471 1991742 1991742 defendant Dowssy Thomas merchant 603207 603207 Dowssy, Thomas, of Kings Lynn, merchant 0
3905905 1992259 1992259 plaintiff Lokwood Thomas merchant 603207 603207 Lokwood, Thomas, of Kings Lynn, merchant 0
3905906 1992259 1992259 defendant Mysterchamber Thomas merchant 603207 603207 Mysterchamber, Thomas, of Kings Lynn, merchant 0
3905922 1992264 1992264 defendant Dunston John (legal representative) 603207 603207 Dunston, John, of Kings Lynn, merchant, executors of 1
3905923 1992264 1992264 defendant Wyllyams William merchant 603207 603207 (Wyllyams, William, of Kings Lynn, merchant 2
3906271 1992387 1992387 plaintiff Makerell William waterman 603207 603207 Makerell, William, of Kings Lynn, waterman 0
3907161 1992686 1992686 defendant Saunderson Richard merchant 603207 603207 Saunderson, Richard, of Kings Lynn, merchant 0
3907525 1992812 1992812 defendant Richardson John yeoman 603207 603207 (Richardson, John, of Kings Lynn, yeoman 1
3908206 1993043 1993043 plaintiff Pyper Agnes widow 603207 603207 Pyper, Agnes, of Kings Lynn, widow 0
3909838 1993595 1993595 defendant Poyntour Edward merchant 603207 603207 Poyntour, Edward, of Kings Lynn, merchant 0
3911983 1994333 1994333 plaintiff Wrenche John merchant 603207 603207 Wrenche, John, of Kings Lynn, merchant 0
3912277 1994436 1994436 defendant Hunston Henry merchant 603207 603207 Hunston, Henry, of Kings Lynn, merchant 0
3917718 1996281 1996281 defendant Amyas George merchant 603207 603207 Amyas, George, of Kings Lynn, merchant 0
3931387 2000794 2000794 defendant Dawney John merchant 603207 603207 Dawney, John, of Kings Lynn, merchant 1
3931397 2000798 2000798 defendant Saunderson Richard merchant 603207 603207 Saunderson, Richard, of Kings Lynn, merchant 0
3931956 2000986 2000986 defendant Ducke John sadler 603207 603207 Ducke, John, of Kings Lynn, sadler 0
3932502 2001160 2001160 defendant Bowsey Thomas brewer 603207 603207 Bowsey, Thomas, of Kings Lynn, brewer 0
3937711 2002946 2002946 plaintiff Palmer Robert   603207 603207 Palmer, Robert, of Kings Lynn, Mayor & successor to Ralph Downes, Mayor & burgess of Norwich 0
3942970 2004655 2004655 defendant Wyllyamson William merchant 603207 603207 Wyllyamson, William, of Kings Lynn, merchant 0
3973190 2015194 2015194 plaintiff Grebbye John merchant 603207 603207 Grebbye, John, of Kings Lynn, merchant 0
3973512 2015306 2015306 plaintiff Guybon Thomas esq 603207 603207 Guybon, Thomas, of Kings Lynn, esq 0
3973785 2015402 2015402 defendant Jaxson Lewis draper 603207 603207 Jaxson, Lewis, of kings Lynn, draper 0
3976785 2016448 2016448 plaintiff Kynne John merchant 603207 603207 Kynne, John, of Kings Lynn, merchant 0
3980331 2017736 2017736 plaintiff Pell John merchant 603207 603207 Pell, John, of Kings Lynn, merchant 0
3980333 2017737 2017737 plaintiff Pell John merchant 603207 603207 Pell, John, of Kings Lynn, merchant 0
3980337 2017738 2017738 plaintiff Pell John merchant 603207 603207 Pell, John, of Kings Lynn, merchant 0
3985583 2019607 2019607 plaintiff Walden Lawrence merchant 603207 603207 Walden, Lawrence, of Kings Lynn, merchant 0
4005561 2026762 2026762 defendant Blesby Thomas yeoman 603207 603207 Blesby, Thomas, of Kings Lynn, yeoman 3
4023307 2033044 2033044 defendant Jones Thomas gent 603207 603207 Jones, Thomas, of Kings Lynn, gent 0
4033299 2036562 2036562 plaintiff Grave Thomas   603207 603207 Grave, Thomas, of Kings Lynn merchant 0
4033303 2036563 2036563 plaintiff Grave Thomas   603207 603207 Grave, Thomas, of Kings Lynn merchant 0
4042948 2039953 2039953 defendant Leman Walter grocer 603207 603207 Leman, Walter, of Kings Lynn, grocer 0
4056036 2044542 2044542 defendant Wormell Bartholomew merchant 603207 603207 Wormell, Bartholomew, of Kings Lynn, merchant 0
4063890 2047367 2047367 plaintiff Grave Thomas merchant 603207 603207 Grave, Thomas, of Kings Lynn, merchant 0
4066032 2048139 2048139 defendant Okes Ralph yeoman 603207 603207 Okes, Ralph, of Kings Lynn, yeoman 0
4077365 2052189 2052189 defendant White Edward merchant 603207 603207 White, Edward, of Kings Lynn, merchant 0
4078353 2052556 2052556 defendant Graye Leonard merchant 603207 603207 Graye, Leonard, of Kings Lynn, merchant 0
4078354 2052556 2052556 defendant Wrenche John merchant 603207 603207 Wrenche, John, of Kings Lynn, merchant 1
4078355 2052556 2052556 defendant Lane Robert merchant 603207 603207 Lane, Robert, of Kings Lynn, merchant 2
4078356 2052557 2052557 plaintiff Sympson John   603207 603207 Sympson, John, of Kings Lynn, merchant, administrators of 0
4078364 2052558 2052558 plaintiff Sympson John   603207 603207 Sympson, John, of Kings Lynn, merchant, administrators of 0
4078705 2052679 2052679 defendant Warde John pewterer 603207 603207 Warde, John, of Kings Lynn, pewterer 0
4078706 2052679 2052679 defendant Mathewe Thomas   603207 603207 Mathewe, Thomas, of Kings Lynn, hair weaver 1
4080659 2053395 2053395 defendant Watson John (legal representative) 603207 603207 Watson, John, of Kings Lynn, mariner, executor of 0
4095717 2058800 2058800 defendant Hayes John merchant 603207 603207 Hayes, John, of Kings Lynn, merchant 1
4097502 2059433 2059433 defendant Quarles Thomas gent 603207 603207 Quarles, Thomas, of Kings Lynn, or of Crostweyt, gent 0
4106181 2062505 2062505 defendant Wrenche John merchant 603207 603207 Wrenche, John, of Kings Lynn, merchant 0
4109873 2063790 2063790 defendant Wormell Bartholomew merchant 603207 603207 Wormell, Bartholomew, of Kings Lynn, merchant 0
4111193 2064253 2064253 defendant Coxson Anthony merchant tailor 603207 603207 Coxson, Anthony, of Kings Lynn, merchant tailor 2
4113524 2065117 2065117 defendant Baker George merchant 603207 603207 Baker, George, of Kings Lynn, merchant 0
4113525 2065117 2065117 defendant Baker Thomas gent 603207 603207 Baker, Thomas, of Kings Lynn, gent 1
4113526 2065117 2065117 defendant Scarborowe Thomas blacksmith 603207 603207 Scarborowe, Thomas, of Kings Lynn, blacksmith 2
4114136 2065337 2065337 defendant Warde John pewterer 603207 603207 Warde, John, of Kings Lynn, pewterer 0
4114137 2065337 2065337 defendant Morthewe Thomas weaver 603207 603207 Morthewe, Thomas, of Kings Lynn, weaver 1
4118354 2066854 2066854 defendant Gyrlyng Thomas   603207 603207 Gyrlyng, Thomas, of Kings Lynn, yeoman, servant to Thomas Sydney, of Walsingham Parva 0
4118847 2067024 2067024 defendant Gyrlyng Thomas   603207 603207 Gyrlyng, Thomas, of Kings Lynn, yeoman, servant unto Thomas Sydney, of Walsyngham Parva 0
4128185 2070369 2070369 defendant Parmyter John merchant 603207 603207 Parmyter, John, of Kings Lynn, merchant 0
4128186 2070369 2070369 defendant Parmyter Abraham merchant 603207 603207 Parmyter, Abraham, of Kings Lynn, merchant 1
4128187 2070369 2070369 defendant Dynsdale Thomas merchant 603207 603207 Dynsdale, Thomas, of Kings Lynn, merchant 2
4137017 2073589 2073589 defendant Dade William gent 603207 603207 Dade, William, of Kings Lynn, gent 1
4154679 2079729 2079729 defendant Mann Francis merchant 603207 603207 Mann, Francis, of Kings Lynn, merchant 1
4156192 2080240 2080240 defendant Grave William yeoman 603207 603207 Grave, William, of Kings Lynn, yeoman 0
4158438 2081023 2081023 defendant Smythe George weaver 603207 603207 Smythe, George, of Kings Lynn, weaver 0
4158440 2081024 2081024 defendant Smythe George weaver 603207 603207 Smythe, George, of Kings Lynn, weaver 0
4160264 2081658 2081658 defendant Waldenn George merchant 603207 603207 Waldenn, George, of Kings Lynn, merchant 0
4167801 2084227 2084227 defendant Fletcher William merchant 603207 603207 Fletcher, William, of Kings Lynn, merchant 0
4167802 2084227 2084227 defendant Lambkyn William keelman 603207 603207 Lambkyn, William, of Kings Lynn, keelman 1
4167803 2084227 2084227 defendant Gyle James keelman 603207 603207 Gyle, James, of Kings Lynn, keelman 2
4168564 2084489 2084489 defendant Brygg Richard miller 603207 603207 Brygg, Richard, of Kings Lynn, or of Soffeham, miller 1
4174766 2086642 2086642 defendant Skynner Richard yeoman 603207 603207 Skynner, Richard, of Kings Lynn, yeoman 2
4174771 2086643 2086643 defendant Skynner Richard yeoman 603207 603207 Skynner, Richard, of Kings Lynn, yeoman 2
4176854 2087372 2087372 defendant Baldwyn William butcher 603207 603207 Baldwyn, William, of Kings Lynn, butcher 0
4177428 2087579 2087579 defendant Towtynge John yeoman 603207 603207 Towtynge, John, of Kings Lynn, yeoman 1

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