names

154 rows where place_id = 640775

✎ 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
3857391 1975947 1975947 defendant Baxster John merchant 640775 640775 Baxster, John, of Kings Lenn, merchant 0
3864615 1978362 1978362 defendant Lownde Christopher butcher 640775 640775 Lownde, Christopher, of Kings Lenn, butcher 0
3864616 1978362 1978362 defendant Feldgate John baker 640775 640775 Feldgate, John, of Kings Lenn, baker 1
3865945 1978840 1978840 defendant Brodebank Agnes widow 640775 640775 Brodebank, Agnes, of Kings Lenn, widow 0
3865949 1978842 1978842 defendant Sowermer John merchant 640775 640775 Sowermer, John, of Kings Lenn, merchant 0
3865951 1978843 1978843 defendant Pouleson Sibrand merchant 640775 640775 Pouleson, Sibrand, of Kings Lenn, merchant 0
3865952 1978843 1978843 defendant Sowarmer John merchant 640775 640775 Sowarmer, John, of Kings Lenn, merchant 1
3867259 1979285 1979285 defendant Roker alias Walsyngham Thomas   640775 640775 Roker alias Walsyngham, Thomas, of Kings Lenn, "rafman" 0
3869968 1980197 1980197 defendant Parke Robert merchant 640775 640775 Parke, Robert, of Kings Lenn, merchant 0
3870489 1980369 1980369 defendant Mason Robert bowyer 640775 640775 Mason, Robert, of Kings Lenn, bowyer 1
3872333 1980970 1980970 defendant Elys Thomas gent 640775 640775 (Elys, Thomas, of Kings Lenn, gent 1
3876090 1982254 1982254 defendant Tompson John carpenter 640775 640775 Tompson, John, of Kings Lenn, carpenter 2
3876271 1982303 1982303 defendant Bulbroke Thomas raffman 640775 640775 Bulbroke, Thomas, of Kings Lenn, raffman 1
3877175 1982606 1982606 defendant Dyxson John innholder 640775 640775 Dyxson, John, of Kings Lenn, innholder 0
3878635 1983100 1983100 defendant Lownde Christopher butcher 640775 640775 Lownde, Christopher, of Kings Lenn, butcher 0
3878636 1983100 1983100 defendant Faldygate John baker 640775 640775 Faldygate, John, of Kings Lenn, baker 1
3879988 1983565 1983565 defendant Pore John merchant 640775 640775 Pore, John, of Kings Lenn, merchant 0
3883827 1984857 1984857 defendant Parcke Robert merchant 640775 640775 Parcke, Robert, of Kings Lenn, merchant 0
3885034 1985254 1985254 defendant Heith John clerk 640775 640775 Heith, John, of Kings Lenn, clerk 0
3887369 1986039 1986039 defendant Gall John tailor 640775 640775 Gall, John, of Kings Lenn, tailor 1
3888067 1986262 1986262 defendant Spuddell John shipman 640775 640775 Spuddell, John, of Kings Lenn, shipman 1
3888193 1986306 1986306 defendant Bullyngbroke Thomas, senior merchant 640775 640775 Bullyngbroke, Thomas, senior, of Kings Lenn, merchant 0
3888814 1986512 1986512 defendant Amyas George   640775 640775 Amyas, George, of Kings Lenn, physician 0
3888815 1986512 1986512 defendant Overard William merchant 640775 640775 Overard, William, of Kings Lenn, merchant 1
3889756 1986810 1986810 plaintiff Guybon Thomas esq 640775 640775 Guybon, Thomas, of Kings Lenn, esq 0
3889980 1986884 1986884 defendant Waters William innholder 640775 640775 Waters, William, of Kings Lenn, innholder 0
3889983 1986885 1986885 defendant Waters William innholder 640775 640775 Waters, William, of Kings Lenn, innholder 0
3890070 1986913 1986913 defendant Lyghton Thomas fisherman 640775 640775 Lyghton, Thomas, of Kings Lenn, fisherman 0
3890164 1986950 1986950 defendant Waters Thomas merchant 640775 640775 Waters, Thomas, of Kings Lenn, merchant 0
3891558 1987441 1987441 defendant Pawlesson Sybrand yeoman 640775 640775 Pawlesson, Sybrand, of Kings Lenn, yeoman 0
3914485 1995185 1995185 defendant Dalton Thomas butcher 640775 640775 Dalton, Thomas, of Kings Lenn, butcher 0
3916672 1995947 1995947 plaintiff Newon Thomas   640775 640775 Newon, Thomas, of Kings Lenn 2
3917485 1996206 1996206 plaintiff Guybon Thomas esq 640775 640775 Guybon, Thomas, of Kings Lenn, esq 0
3917881 1996341 1996341 defendant Waters Thomas merchant 640775 640775 Waters, Thomas, of Kings Lenn, merchant 0
3918944 1996657 1996657 defendant Makanter John merchant 640775 640775 Makanter, John, of Kings Lenn, merchant 0
3920067 1997048 1997048 defendant Lownd Christopher butcher 640775 640775 Lownd, Christopher, of Kings Lenn, butcher 0
3920074 1997049 1997049 defendant Lownde Christopher butcher 640775 640775 Lownde, Christopher, of Kings Lenn, butcher 0
3920844 1997316 1997316 defendant Saunderson Richard merchant 640775 640775 Saunderson, Richard, of Kings Lenn, merchant 0
3922531 1997852 1997852 plaintiff Rummer Robert (legal representative) 640775 640775 Rummer, Robert, of Kings Lenn, husbandman, executrix of 0
3946125 2005721 2005721 defendant Palmer John merchant 640775 640775 Palmer, John, of Kings Lenn, merchant 0
3950440 2007232 2007232 defendant Mason William merchant 640775 640775 Mason, William, of Kings Lenn, merchant 0
3952947 2008101 2008101 defendant Shastowe Roman (legal representative) 640775 640775 Shastowe, Roman, of Kings Lenn, executors of 0
3952948 2008101 2008101 defendant Jude William merchant 640775 640775 (Jude, William, of Kings Lenn, merchant 1
3955501 2008993 2008993 defendant Woodhouse Margaret widow 640775 640775 Woodhouse, Margaret, of Kings Lenn, widow 0
3956207 2009241 2009241 defendant Makender John merchant 640775 640775 Makender, John, of Kings Lenn, merchant 6
3957148 2009565 2009565 defendant Walden Lawrence merchant 640775 640775 Walden, Lawrence, of Kings Lenn, merchant 0
3963536 2011854 2011854 defendant Robynson William merchant 640775 640775 Robynson, William, of Kings Lenn, merchant 0
3963833 2011953 2011953 plaintiff Allen William roper 640775 640775 Allen, William, of Kings Lenn, roper 0
3965389 2012510 2012510 defendant Wylcock Thomas yeoman 640775 640775 Wylcock, Thomas, of Kings Lenn, yeoman 2
3965392 2012510 2012510 defendant Reveley George merchant 640775 640775 Reveley, George, of Kings Lenn, merchant 5
3965633 2012594 2012594 defendant Danyell Robert yeoman 640775 640775 Danyell, Robert, of Kings Lenn, yeoman 0
3966095 2012764 2012764 defendant Ladyman Robert   640775 640775 Ladyman, Robert, of Kings Lenn, ship master 0
3966397 2012879 2012879 defendant Grene Walter merchant 640775 640775 Grene, Walter, of Kings Lenn, merchant 0
3972192 2014835 2014835 defendant Wylcocke Thomas husbandman 640775 640775 Wylcocke, Thomas, of Kings Lenn, husbandman 1
3972633 2015002 2015002 plaintiff Gaunt Christopher merchant 640775 640775 Gaunt, Christopher, of Kings Lenn, merchant 0
3972634 2015002 2015002 plaintiff Grove or Grave Thomas merchant 640775 640775 Grove or Grave, Thomas, of Kings Lenn, merchant 1
3973488 2015296 2015296 defendant Permytor John, junior merchant 640775 640775 Permytor, John, junior, of Kings Lenn, merchant 1
3975274 2015922 2015922 plaintiff Howard John, junior   640775 640775 Howard, John, junior, of Kings Lenn 0
3975277 2015923 2015923 plaintiff Howard John, junior   640775 640775 Howard, John, junior, of Kings Lenn 0
3975278 2015923 2015923 plaintiff Baker John yeoman 640775 640775 Baker, John, of Kings Lenn, yeoman 1
3975281 2015924 2015924 plaintiff Howard John, junior   640775 640775 Howard, John, junior, of Kings Lenn 0
3975282 2015924 2015924 plaintiff Baker John yeoman 640775 640775 Baker, John, of Kings Lenn, yeoman 1
3975308 2015932 2015932 defendant Dawny John merchant 640775 640775 Dawny, John, of Kings Lenn, merchant 0
3975309 2015932 2015932 defendant Hill Thomas merchant 640775 640775 Hill, Thomas, of Kings Lenn, merchant 1
3975369 2015951 2015951 defendant Dawny John merchant 640775 640775 Dawny, John, of Kings Lenn, merchant 0
3975370 2015951 2015951 defendant Hill Thomas merchant 640775 640775 Hill, Thomas, of Kings Lenn, merchant 1
3975492 2015996 2015996 plaintiff Hullyour Robert   640775 640775 Hullyour, Robert, of Kings Lenn 0
3975928 2016144 2016144 defendant Farrour Robert merchant 640775 640775 Farrour, Robert, of Kings Lenn, merchant 0
3976334 2016297 2016297 defendant Davye William chapman 640775 640775 Davye, William, of Kings Lenn, chapman 0
3976335 2016297 2016297 defendant Ferryer Nicholas chapman 640775 640775 Ferryer, Nicholas, of Kings Lenn, chapman 1
3976336 2016297 2016297 defendant Kynge William chapman 640775 640775 Kynge, William, of Kings Lenn, chapman 2
3979247 2017325 2017325 defendant Dawny John merchant 640775 640775 Dawny, John, of Kings Lenn, merchant 0
3979824 2017540 2017540 plaintiff Page Robert merchant 640775 640775 Page, Robert, of Kings Lenn, merchant 0
3980329 2017735 2017735 plaintiff Pell John   640775 640775 Pell, John, of Kings Lenn 0
3980332 2017736 2017736 defendant Grene Walter merchant 640775 640775 Grene, Walter, of Kings Lenn, merchant 0
3980344 2017740 2017740 defendant Dynnesdale John merchant 640775 640775 Dynnesdale, John, of Kings Lenn, merchant 0
3982798 2018621 2018621 plaintiff Shaxston Francis draper 640775 640775 Shaxston, Francis, of Kings Lenn, draper 0
3989728 2021072 2021072 defendant Spence Richard (legal representative) 640775 640775 Spence, Richard, of Kings lenn, merchant, executors of 0
3989729 2021072 2021072 defendant Kynne John merchant 640775 640775 (Kynne, John, of Kings Lenn, merchant 1
3995909 2023289 2023289 defendant Leyton Thomas gent 640775 640775 Leyton, Thomas, of Kings Lenn, gent 0
3996004 2023326 2023326 plaintiff Dade William gent 640775 640775 Dade, William, of Kings Lenn, gent 0
3996006 2023327 2023327 plaintiff Dade William gent 640775 640775 Dade, William, of Kings Lenn, gent 0
3996011 2023328 2023328 plaintiff Dade William gent 640775 640775 Dade, William, of Kings Lenn, gent 0
3996013 2023329 2023329 plaintiff Dade William gent 640775 640775 Dade, William, of Kings Lenn, gent 0
3996015 2023330 2023330 plaintiff Dade William gent 640775 640775 Dade, William, of Kings Lenn, gent 0
3996017 2023331 2023331 plaintiff Dade William merchant 640775 640775 Dade, William, of Kings Lenn, gent, merchant 0
3996023 2023332 2023332 defendant Brodbent John waterman 640775 640775 Brodbent, John, of Kings Lenn, waterman 1
3996032 2023334 2023334 defendant Brodbent John waterman 640775 640775 Brodbent, John, of Kings Lenn, waterman 1
3996213 2023395 2023395 plaintiff Danyell Robert   640775 640775 Danyell, Robert, of Kings Lenn 0
3998305 2024137 2024137 defendant Water Thomas merchant 640775 640775 Water, Thomas, of Kings Lenn, merchant 0
4001859 2025439 2025439 defendant Page Robert   640775 640775 Page, Robert, of Kings lenn, rope maker 0
4002546 2025678 2025678 defendant Lestraunge Nicholas   640775 640775 Lestraunge, Nicholas, of Kings Lenn, knight 0
4003751 2026109 2026109 plaintiff Hullyour Robert merchant 640775 640775 Hullyour, Robert, of Kings Lenn, merchant 0
4009572 2028192 2028192 plaintiff Newton James cordwainer 640775 640775 Newton, James, of Kings Lenn, cordwainer 0
4012725 2029274 2029274 defendant Walker John butcher 640775 640775 Walker, John, of Kings Lenn, butcher 1
4014648 2029961 2029961 plaintiff Shaxton Francis merchant 640775 640775 Shaxton, Francis, of Kings Lenn, merchant 0
4014652 2029962 2029962 plaintiff Shaxton Francis merchant 640775 640775 Shaxton, Francis, of Kings Lenn, merchant 0
4023304 2033043 2033043 defendant Jones Thomas gent 640775 640775 Jones, Thomas, of Kings Lenn, gent 0
4027340 2034425 2034425 defendant Allee William merchant 640775 640775 Allee, William, of Kings Lenn, merchant 5
4027341 2034425 2034425 defendant Wrenche John merchant 640775 640775 Wrenche, John, of Kings Lenn, merchant 6

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