names

123 rows where place_id = 657148

✎ 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
3943218 2004750 2004750 defendant Ryveley George merchant 657148 657148 Ryveley, George, of Kings Lenne, merchant 0
3944513 2005180 2005180 defendant Grewson Richard   657148 657148 Grewson, Richard, of Kings Lenne, rope maker 1
3949116 2006753 2006753 defendant Williamson William merchant 657148 657148 Williamson, William, of Kings Lenne, merchant 0
3952950 2008101 2008101 defendant Hall Margaret widow 657148 657148 Hall, Margaret, of Kings Lenne, widow 3
3952952 2008102 2008102 defendant Shastowe Roman (legal representative) 657148 657148 Shastowe, Roman, of Kings Lenne, mariner, executors of 0
3952955 2008102 2008102 defendant Hall Margaret widow 657148 657148 Hall, Margaret, of Kings Lenne, widow 3
3953291 2008220 2008220 defendant Harryson Andrew merchant 657148 657148 Harryson, Andrew, of Kings Lenne, merchant 0
3953293 2008221 2008221 defendant Harryson Andrew merchant 657148 657148 Harryson, Andrew, of Kings Lenne, merchant 0
3953294 2008221 2008221 defendant Wyllymson William merchant 657148 657148 Wyllymson, William, of Kings Lenne, merchant 1
3954182 2008536 2008536 plaintiff Kynder William merchant 657148 657148 Kynder, William, of Kings Lenne, merchant 0
3957521 2009697 2009697 plaintiff Porter John merchant 657148 657148 Porter. John, of Kings Lenne, merchant 0
3957697 2009751 2009751 plaintiff Proctour William   657148 657148 Proctour, William, of Kings Lenne, cordwainer, administrators of 0
3976658 2016413 2016413 plaintiff Kyllyngtre William yeoman 657148 657148 Kyllyngtre, William, of Kings Lenne, yeoman 0
3989186 2020871 2020871 plaintiff Baker George merchant 657148 657148 Baker, George, of Kings Lenne, merchant 0
3989741 2021074 2021074 plaintiff Bastard Francis gent 657148 657148 Bastard, Francis, of Kings Lenne, gent 0
3996021 2023332 2023332 plaintiff Dade William merchant 657148 657148 Dade, William, of Kings Lenne, gent, merchant 0
3996025 2023333 2023333 plaintiff Dade William merchant 657148 657148 Dade, William, of Kings Lenne, gent, merchant 0
3996215 2023396 2023396 plaintiff Danyell Robert   657148 657148 Danyell, Robert, of Kings Lenne 0
3997137 2023744 2023744 defendant Lane Robert merchant 657148 657148 Lane, Robert, of Kings Lenne, merchant 0
3997140 2023745 2023745 defendant Soome Edmund merchant 657148 657148 Soome, Edmund, of Kings Lenne, merchant 0
3999852 2024713 2024713 plaintiff Gaunt Christopher merchant 657148 657148 Gaunt, Christopher, of Kings Lenne, merchant 0
4000469 2024936 2024936 plaintiff Grebbye John merchant 657148 657148 Grebbye, John, of Kings Lenne, merchant 0
4000899 2025093 2025093 plaintiff Guybon Thomas (legal representative) 657148 657148 Guybon, Thomas, of Kings Lenne, executors of 0
4002399 2025636 2025636 plaintiff Hendrye Edmund merchant 657148 657148 Hendrye, Edmund, of Kings Lenne, merchant 0
4003503 2026015 2026015 plaintiff Howarde John, junior merchant 657148 657148 Howarde, John, junior, of Kings Lenne, merchant 0
4006201 2026992 2026992 plaintiff Leache Richard merchant 657148 657148 Leache, Richard, of Kings Lenne, merchant 0
4009016 2027990 2027990 defendant Greveson Richard   657148 657148 Greveson, Richard, of Kings Lenne, rope maker 0
4010559 2028551 2028551 plaintiff Parmyntore Abraham merchant 657148 657148 Parmyntore, Abraham, of Kings Lenne, merchant 0
4017000 2030782 2030782 plaintiff Sympson John merchant 657148 657148 Sympson, John, of Kings Lenne, merchant 0
4018466 2031338 2031338 defendant Kernele Robert gent 657148 657148 Kernele, Robert, of Kings Lenne, gent 0
4018802 2031456 2031456 plaintiff Walden George merchant 657148 657148 Walden, George, of Kings Lenne, merchant 0
4021005 2032238 2032238 plaintiff Wrenche John merchant 657148 657148 Wrenche, John, of Kings Lenne, merchant 0
4021012 2032240 2032240 defendant Peerson William yeoman 657148 657148 Peerson, William, of Kings Lenne, yeoman 0
4021097 2032268 2032268 defendant Peerson William yeoman 657148 657148 Peerson, William, of Kings Lenne, yeoman 0
4021288 2032339 2032339 plaintiff Wylkenson Thomas draper 657148 657148 Wylkenson, Thomas, of Kings Lenne, draper 0
4021320 2032350 2032350 plaintiff Wylkynson Thomas draper 657148 657148 Wylkynson, Thomas, of Kings Lenne, draper 0
4022054 2032619 2032619 plaintiff Anderton Hamlet tailor 657148 657148 Anderton, Hamlet, of Kings Lenne, tailor 0
4022059 2032620 2032620 plaintiff Anderton Hamlet tailor 657148 657148 Anderton, Hamlet, of Kings lenne, tailor 0
4023565 2033137 2033137 defendant Wylcocke Thomas yeoman 657148 657148 Wylcocke, Thomas, of Kings Lenne, yeoman 0
4027589 2034515 2034515 defendant Wrenche John mercer 657148 657148 Wrenche, John, of Kings Lenne, mercer 0
4031351 2035885 2035885 plaintiff Fenne William yeoman 657148 657148 Fenne, William, of Kings Lenne, yeoman 0
4032660 2036332 2036332 plaintiff Gervys Robert merchant 657148 657148 Gervys, Robert, of Kings Lenne, merchant 0
4033280 2036558 2036558 plaintiff Grave Thomas merchant 657148 657148 Grave, Thomas, of Kings Lenne, merchant 0
4033284 2036559 2036559 plaintiff Grave Thomas merchant 657148 657148 Grave, Thomas, of Kings Lenne, merchant 0
4033289 2036560 2036560 plaintiff Grave Thomas merchant 657148 657148 Grave, Thomas, of Kings Lenne, merchant 0
4033290 2036560 2036560 plaintiff Wadeson John merchant 657148 657148 Wadeson, John, of Kings Lenne, merchant 1
4033293 2036561 2036561 plaintiff Grave Thomas merchant 657148 657148 Grave, Thomas, of Kings Lenne, merchant 0
4033294 2036561 2036561 plaintiff Wadeson John merchant 657148 657148 Wadeson, John, of Kings Lenne, merchant 1
4033622 2036674 2036674 plaintiff Grobby John merchant 657148 657148 Grobby, John, of Kings Lenne, merchant 0
4033750 2036723 2036723 plaintiff Gurlyn William yeoman 657148 657148 Gurlyn, William, of Kings Lenne, yeoman 0
4033793 2036736 2036736 plaintiff Guybon William gent 657148 657148 Guybon, William, of Kings Lenne, gent 0
4033796 2036737 2036737 plaintiff Guybon William gent 657148 657148 Guybon, William, of Kings Lenne, gent 0
4033799 2036738 2036738 plaintiff Guybon William gent 657148 657148 Guybon, William, of Kings Lenne, gent 0
4033802 2036739 2036739 plaintiff Guybon William gent 657148 657148 Guybon, William, of Kings Lenne, gent 0
4033947 2036796 2036796 plaintiff Gyrlyng William yeoman 657148 657148 Gyrlyng, William, of Kings Lenne, yeoman 0
4033950 2036797 2036797 plaintiff Gyrlyng William yeoman 657148 657148 Gyrlyng, William, of Kings Lenne, yeoman 0
4033954 2036798 2036798 plaintiff Gyrlyng William yeoman 657148 657148 Gyrlyng, William, of Kings Lenne, yeoman 0
4036172 2037622 2037622 plaintiff Howard John, junior merchant 657148 657148 Howard, John, junior, of Kings Lenne, merchant 0
4036178 2037623 2037623 plaintiff Howard John, junior merchant 657148 657148 Howard, John, junior, of Kings Lenne, merchant 0
4036183 2037624 2037624 plaintiff Howard John, junior merchant 657148 657148 Howard, John, junior, of Kings Lenne, merchant 0
4036187 2037625 2037625 plaintiff Howard John, junior merchant 657148 657148 Howard, John, junior, of Kings Lenne, merchant 0
4038893 2038530 2038530 defendant Page Robert merchant 657148 657148 Page, Robert, of Kings Lenne, merchant 0
4039557 2038770 2038770 plaintiff Manne Francis merchant 657148 657148 Manne, Francis, of Kings Lenne, merchant 0
4039558 2038770 2038770 plaintiff Manne Robert merchant 657148 657148 Manne, Robert, of Kings Lenne, merchant 1
4039561 2038771 2038771 plaintiff Manne Francis merchant 657148 657148 Manne, Francis, of Kings Lenne, merchant 0
4039562 2038771 2038771 plaintiff Waters Robert merchant 657148 657148 Waters, Robert, of Kings Lenne, merchant 1
4040504 2039096 2039096 defendant Baker George merchant 657148 657148 Baker, George, of Kings Lenne, merchant 0
4040505 2039096 2039096 defendant Overend Thomas merchant 657148 657148 Overend, Thomas, of Kings Lenne, merchant 1
4043113 2040003 2040003 defendant Wadeson John draper 657148 657148 Wadeson, John, of Kings Lenne, draper 0
4045175 2040728 2040728 plaintiff Rowse John merchant 657148 657148 Rowse, John, of Kings Lenne, merchant 0
4045176 2040728 2040728 defendant Page Robert merchant 657148 657148 Page, Robert, of Kings Lenne, merchant 0
4045946 2040998 2040998 plaintiff Shaxton Francis merchant 657148 657148 Shaxton, Francis, of Kings Lenne, merchant 0
4049788 2042365 2042365 plaintiff Wadeson John merchant 657148 657148 Wadeson, John, of Kings Lenne, merchant 0
4050380 2042567 2042567 plaintiff Waters Edward (legal representative) 657148 657148 Waters, Edward, of Kings Lenne, gent, executrix of 0
4050383 2042568 2042568 plaintiff Waters Edward (legal representative) 657148 657148 Waters, Edward, of Kings Lenne, gent, executrix of 0
4050398 2042573 2042573 plaintiff Waters Robert merchant 657148 657148 Waters, Robert, of Kings Lenne, merchant 0
4050399 2042573 2042573 plaintiff Man Francis merchant 657148 657148 Man, Francis, of Kings Lenne, merchant 1
4050401 2042574 2042574 plaintiff Waters Robert merchant 657148 657148 Waters, Robert, of Kings Lenne, merchant 0
4050402 2042574 2042574 plaintiff Manne Francis merchant 657148 657148 Manne, Francis, of Kings Lenne, merchant 1
4051871 2043090 2043090 plaintiff Wormell Bartholomew merchant 657148 657148 Wormell, Bartholomew, of Kings Lenne, merchant 0
4051873 2043091 2043091 plaintiff Wormell Barthomew merchant 657148 657148 Wormell, Barthomew, of Kings Lenne, merchant 0
4054850 2044127 2044127 plaintiff Bassett John merchant 657148 657148 Bassett, John, of Kings Lenne, merchant 0
4063954 2047388 2047388 plaintiff Grebby John merchant 657148 657148 Grebby, John, of Kings Lenne, merchant 0
4063956 2047389 2047389 plaintiff Grebby John merchant 657148 657148 Grebby, John, of Kings Lenne, merchant 0
4063958 2047390 2047390 plaintiff Grebby John merchant 657148 657148 Grebby, John, of Kings Lenne, merchant 0
4066735 2048399 2048399 plaintiff Howard John, junior merchant 657148 657148 Howard, John, junior, of Kings Lenne, merchant 0
4069083 2049234 2049234 plaintiff Ledebeter Stephen yeoman 657148 657148 Ledebeter, Stephen, of Kings Lenne, yeoman 0
4074631 2051229 2051229 defendant Makyns Edmund merchant 657148 657148 Makyns, Edmund, of Kings Lenne, merchant 0
4074764 2051274 2051274 plaintiff Revett Michael merchant 657148 657148 Revett, Michael, of Kings Lenne, merchant 0
4076240 2051792 2051792 plaintiff Shaxton Thomas draper 657148 657148 Shaxton, Thomas, of Kings Lenne, draper 0
4076241 2051792 2051792 defendant Rowse John merchant 657148 657148 Rowse, John, of Kings Lenne, merchant 0
4076242 2051792 2051792 defendant Makyn Edmund merchant 657148 657148 Makyn, Edmund, of Kings Lenne, merchant 1
4076243 2051793 2051793 plaintiff Shaxton Thomas draper 657148 657148 Shaxton, Thomas, of Kings Lenne, draper 0
4076244 2051793 2051793 defendant Rowse John merchant 657148 657148 Rowse, John, of Kings Lenne, merchant 0
4076245 2051793 2051793 defendant Makyn Edmund merchant 657148 657148 Makyn, Edmund, of Kings Lenne, merchant 1
4076410 2051859 2051859 plaintiff Shorte Robert   657148 657148 Shorte, Robert, of Kings Lenne, woolen draper 0
4079861 2053099 2053099 defendant Grene Walter merchant 657148 657148 Grene, Walter, of Kings Lenne, merchant 1
4084379 2054684 2054684 defendant Myller Andrew merchant 657148 657148 Myller, Andrew, of Kings Lenne, merchant 0
4084829 2054849 2054849 defendant Robynson Roger joiner 657148 657148 Robynson, Roger, of Kings Lenne, joiner 0
4096959 2059243 2059243 defendant Leyghton Thomas gent 657148 657148 Leyghton, Thomas, of Kings Lenne, gent 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);