names

277 rows where place_id = 603960

✎ 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
3656392 1912244 1912244 plaintiff Castell William   603960 603960 Castell, William, of Kings Lynne 1
3666614 1915499 1915499 defendant Coop Thomas   603960 603960 Coop, Thomas, of Kings Langley, prior 0
3888364 1986370 1986370 defendant Castell Henry gent 603960 603960 Castell, Henry, of Kings Lynne, gent 0
3892007 1987578 1987578 plaintiff Makanter John merchant 603960 603960 Makanter, John, of Kings Lynne, merchant 0
3894382 1988338 1988338 defendant Fyssher John merchant 603960 603960 Fyssher, John, of Kings Lynne, merchant 0
3922378 1997801 1997801 defendant Fyssher John merchant 603960 603960 Fyssher, John, of Kings Lynne, merchant 0
3943638 2004887 2004887 defendant Porter John mercer 603960 603960 Porter, John, of Kings Lynne, mercer 0
3946543 2005857 2005857 defendant Kyng John merchant 603960 603960 Kyng, John, of Kings Lynne, merchant 0
3947191 2006085 2006085 defendant Pyreson William yeoman 603960 603960 Pyreson, William, of Kings Lynne, yeoman 0
3947193 2006086 2006086 defendant Pyreson William yeoman 603960 603960 Pyreson, William, of Kings Lynne, yeoman 0
3949736 2006986 2006986 defendant Jude William merchant 603960 603960 Jude, William, of Kings Lynne, merchant 0
3951008 2007418 2007418 defendant Wilcocke Robert butcher 603960 603960 Wilcocke, Robert, of Kings Lynne, butcher 4
3951070 2007440 2007440 plaintiff Grave Thomas merchant 603960 603960 Grave, Thomas, of Kings Lynne, merchant 0
3951072 2007441 2007441 plaintiff Grave Thomas merchant 603960 603960 Grave, Thomas, of Kings Lynne, merchant 0
3951557 2007599 2007599 defendant Revelaye George merchant 603960 603960 Revelaye, George, of Kings Lynne, merchant 0
3951660 2007634 2007634 defendant Grene Walter yeoman 603960 603960 Grene, Walter, of Kings Lynne, yeoman 0
3952871 2008079 2008079 plaintiff Houghton Robert yeoman 603960 603960 Houghton, Robert, of Kings Lynne, yeoman 2
3952953 2008102 2008102 defendant Jude William merchant 603960 603960 (Jude, William, of Kings Lynne, merchant 1
3953296 2008222 2008222 defendant Wyllymson William merchant 603960 603960 Wyllymson, William, of Kings Lynne, merchant 0
3954580 2008674 2008674 plaintiff Leman Walter grocer 603960 603960 Leman, Walter, of Kings Lynne, grocer 0
3954892 2008778 2008778 defendant Jaxson Lewis yeoman 603960 603960 Jaxson, Lewis, of Kings Lynne, yeoman 2
3955170 2008871 2008871 plaintiff Makender John merchant 603960 603960 Makender, John, of Kings Lynne, merchant 0
3955172 2008872 2008872 plaintiff Makender John merchant 603960 603960 Makender, John, of Kings Lynne, merchant 0
3956935 2009493 2009493 plaintiff Parmeytor Robert merchant 603960 603960 Parmeytor, Robert, of Kings Lynne, merchant 0
3962918 2011626 2011626 defendant Mouth Robert merchant 603960 603960 Mouth, Robert, of Kings Lynne, merchant 0
3962995 2011655 2011655 plaintiff Woodhouse Margaret widow 603960 603960 Woodhouse, Margaret, of Kings Lynne, widow 0
3973138 2015176 2015176 plaintiff Grave Thomas merchant 603960 603960 Grave, Thomas, of Kings Lynne, merchant 0
3975364 2015950 2015950 defendant Brese Thomas merchant 603960 603960 Brese, Thomas, of Kings Lynne, merchant 0
3975365 2015950 2015950 defendant Lessey Henry merchant 603960 603960 Lessey, Henry, of Kings Lynne, merchant 1
3975366 2015950 2015950 defendant Lane Robert merchant 603960 603960 Lane, Robert, of Kings Lynne, merchant 2
3975367 2015950 2015950 defendant Dynsdaill John merchant 603960 603960 Dynsdaill, John, of Kings Lynne, merchant 3
3977233 2016607 2016607 plaintiff Leche Richard merchant 603960 603960 Leche, Richard, of Kings Lynne, merchant 0
3977397 2016665 2016665 defendant Jones Thomas gent 603960 603960 Jones, Thomas, of Kings Lynne, gent 0
3977794 2016803 2016803 defendant Dawney John merchant 603960 603960 Dawney, John, of Kings Lynne, merchant 0
3979249 2017326 2017326 defendant Dawnye John merchant 603960 603960 Dawnye, John, of Kings Lynne, merchant 0
3979251 2017327 2017327 defendant Revelley George merchant 603960 603960 Revelley, George, of Kings Lynne, merchant 0
3980340 2017739 2017739 plaintiff Pell John merchant 603960 603960 Pell, John, of Kings Lynne, merchant 0
3982284 2018434 2018434 plaintiff Ryveley George merchant 603960 603960 Ryveley, George, of Kings Lynne, merchant 0
3982526 2018525 2018525 defendant Lessey Henry merchant 603960 603960 Lessey, Henry, of Kings Lynne, merchant 0
3982802 2018622 2018622 plaintiff Shaxston Francis merchant 603960 603960 Shaxston, Francis, of Kings Lynne, merchant 0
3982809 2018625 2018625 plaintiff Shaxton Francis merchant 603960 603960 Shaxton, Francis, of Kings Lynne, merchant 0
3982811 2018625 2018625 defendant Williamson William merchant 603960 603960 Williamson, William, of Kings Lynne, merchant 1
3985906 2019724 2019724 plaintiff Waters Edward gent 603960 603960 Waters, Edward, of Kings Lynne, gent 0
3989188 2020872 2020872 plaintiff Baker George merchant 603960 603960 Baker, George, of Kings Lynne, merchant 0
3989714 2021067 2021067 plaintiff Bassett John merchant 603960 603960 Bassett, John, of Kings Lynne, merchant 0
3989716 2021068 2021068 plaintiff Bassett John merchant 603960 603960 Bassett, John, of Kings Lynne, merchant 0
3992899 2022214 2022214 defendant Wrenche John merchant 603960 603960 Wrenche, John, of Kings Lynne, merchant 0
3996030 2023334 2023334 plaintiff Dade William gent 603960 603960 Dade, William, of Kings Lynne, gent 0
3996034 2023335 2023335 plaintiff Dade William gent 603960 603960 Dade, William, of Kings Lynne, gent 0
3997044 2023710 2023710 defendant Guybon Thomas (legal representative) 603960 603960 Guybon, Thomas, of Kings Lynne, esq, executors of 2
3997046 2023710 2023710 defendant Guybon William gent 603960 603960 Guybon, William, of Kings Lynne, gent 4
3997509 2023858 2023858 plaintiff Dynsdale John merchant 603960 603960 Dynsdale, John, of Kings Lynne, merchant 0
4000403 2024913 2024913 plaintiff Grave Thomas merchant 603960 603960 Grave, Thomas, of Kings Lynne, merchant 0
4000406 2024914 2024914 plaintiff Grave Thomas merchant 603960 603960 Grave, Thomas, of Kings Lynne, merchant 0
4000407 2024914 2024914 plaintiff Wadson John merchant 603960 603960 Wadson, John, of Kings Lynne, merchant 1
4000512 2024954 2024954 defendant Forman John tailor 603960 603960 Forman, John, of Kings Lynne, tailor 0
4005785 2026847 2026847 plaintiff Laighton Thomas merchant 603960 603960 Laighton, Thomas, of Kings Lynne, gent, merchant 0
4006527 2027115 2027115 plaintiff Leyghton Thomas merchant 603960 603960 Leyghton, Thomas, of Kings Lynne, gent, merchant 0
4006927 2027251 2027251 defendant Bastarde Francis gent 603960 603960 Bastarde, Francis, of Kings Lynne, gent 0
4010997 2028710 2028710 defendant Leman Walter grocer 603960 603960 Leman, Walter, of Kings Lynne, grocer 0
4014324 2029849 2029849 defendant Goodwyn Valentine gent 603960 603960 Goodwyn, Valentine, of Kings Lynne, gent 0
4018465 2031338 2031338 plaintiff Valenger Henry gent 603960 603960 Valenger, Henry, of Kings Lynne, gent 0
4018469 2031339 2031339 defendant Guybon Francis gent 603960 603960 Guybon, Francis, of Kings Lynne, gent 0
4018580 2031377 2031377 plaintiff Vepenne John painter 603960 603960 Vepenne, John, of Kings Lynne, painter 0
4019274 2031628 2031628 plaintiff Waters Edward gent 603960 603960 Waters, Edward, of Kings Lynne, gent 0
4019277 2031629 2031629 plaintiff Waters Edward gent 603960 603960 Waters, Edward, of Kings Lynne, gent 0
4020907 2032205 2032205 plaintiff Wormell Bartholomew merchant 603960 603960 Wormell, Bartholomew, of Kings Lynne, merchant 0
4020909 2032206 2032206 plaintiff Wormell Bartholomew merchant 603960 603960 Wormell, Bartholomew, of Kings Lynne, merchant 0
4020911 2032207 2032207 plaintiff Wormell Bartholomew merchant 603960 603960 Wormell, Bartholomew, of Kings Lynne, merchant 0
4021648 2032470 2032470 defendant Wrenche John merchant 603960 603960 Wrenche, John, of Kings Lynne, merchant 0
4027030 2034314 2034314 defendant Wrenche John merchant 603960 603960 Wrenche, John, of Kings Lynne, merchant 0
4027670 2034546 2034546 plaintiff Cleyborne Thomas merchant 603960 603960 Cleyborne, Thomas, of Kings Lynne, merchant 0
4029979 2035367 2035367 defendant le Strange Nicholas gent 603960 603960 le Strange, Nicholas, of Kings Lynne, gent 0
4029982 2035368 2035368 defendant le Straunge Nicholas   603960 603960 le Straunge, Nicholas, of Kings Lynne, knight 0
4030328 2035500 2035500 plaintiff Dynsdale John merchant 603960 603960 Dynsdale, John, of Kings Lynne, merchant 0
4030688 2035638 2035638 plaintiff Ellys Robert yeoman 603960 603960 Ellys, Robert, of Kings Lynne, yeoman 0
4031135 2035808 2035808 plaintiff Farrer Robert merchant 603960 603960 Farrer, Robert, of Kings Lynne, merchant 0
4031137 2035809 2035809 plaintiff Farrer Robert merchant 603960 603960 Farrer, Robert, of Kings Lynne, merchant 0
4033309 2036564 2036564 plaintiff Grave Thomas merchant 603960 603960 Grave, Thomas, of Kings Lynne, merchant 0
4033311 2036565 2036565 plaintiff Grave Thomas merchant 603960 603960 Grave, Thomas, of Kings Lynne, merchant 0
4033313 2036566 2036566 plaintiff Grave Thomas merchant 603960 603960 Grave, Thomas, of Kings Lynne, merchant 0
4033316 2036567 2036567 plaintiff Wadeson John merchant 603960 603960 Wadeson, John, of Kings Lynne, merchant 1
4033778 2036731 2036731 plaintiff Guybon Thomas (legal representative) 603960 603960 Guybon, Thomas, of Kings Lynne, gent, executors of 0
4036191 2037626 2037626 plaintiff Howard John, junior merchant 603960 603960 Howard, John, junior, of Kings Lynne, merchant 0
4036215 2037636 2037636 defendant Waters Thomas merchant 603960 603960 Waters, Thomas, of Kings Lynne, merchant 0
4036218 2037637 2037637 defendant Waters Thomas merchant 603960 603960 Waters, Thomas, of Kings Lynne, merchant 0
4038098 2038268 2038268 plaintiff Lacy or Lassey Henry merchant 603960 603960 Lacy or Lassey, Henry, of Kings Lynne, merchant 0
4038100 2038269 2038269 plaintiff Lacy or Lessey Henry merchant 603960 603960 Lacy or Lessey, Henry, of Kings Lynne, merchant 0
4043564 2040157 2040157 defendant Boston Thomas merchant 603960 603960 Boston, Thomas, of Kings Lynne, merchant 0
4045480 2040837 2040837 defendant Tydd Richard butcher 603960 603960 Tydd, Richard, of Kings Lynne, butcher 0
4045836 2040956 2040956 plaintiff Sendall Thomas merchant 603960 603960 Sendall, Thomas, of Kings Lynne, merchant 0
4045838 2040957 2040957 plaintiff Sendall Thomas merchant 603960 603960 Sendall, Thomas, of Kings Lynne, merchant 0
4051884 2043094 2043094 defendant Archer John butcher 603960 603960 Archer, John, of Kings Lynne, butcher 0
4052165 2043193 2043193 plaintiff Wylkynson John mercer 603960 603960 Wylkynson, John, of Kings Lynne, mercer 0
4052894 2043471 2043471 defendant Bradforthe or Bradford Thomas fishmonger 603960 603960 Bradforthe or Bradford, Thomas, of Kings Lynne, fishmonger 0
4053267 2043548 2043548 defendant Scottyng John yeoman 603960 603960 Scottyng, John, of Kings Lynne, yeoman 7
4058738 2045518 2045518 defendant Dawnye John merchant 603960 603960 Dawnye, John, of Kings Lynne, merchant 0
4059470 2045783 2045783 defendant Rowse John merchant 603960 603960 Rowse, John, of Kings Lynne, merchant 1
4059706 2045865 2045865 plaintiff Corney John merchant 603960 603960 Corney, John, of Kings Lynne, merchant 0
4062711 2046962 2046962 defendant Parmiter John merchant 603960 603960 Parmiter, John, of Kings Lynne, merchant 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);